Read XML file 1C 8.3. Formation of the XML file. Simple unloading for third-party application. Pour entries to the receiver

When the company constantly enjoys in his work with some software complex, then, of course, the question of its continuous support and administration always arises. There is no way to do with the tasks of exchange, storing and recovering data. Consider how to upload or unload data from 1C in XML format, as this is an important procedure for this topic.

They are built so that during unloading it was possible to get the XML format file in which the data necessary for the client will be recorded. At the same time, simultaneously with the recording, the correctness of the correct entries for critical errors occurs.

Thus, unloading to an XML file (import entries) from one information base and subsequent loading from XML to another - represent the data exchange in XML format between the bases.

Such a procedure, especially with large information arrays, saves a large number of handmade.

Import (received file) can also be used as an archive for recovery in unforeseen situations (with loss or damage).

There are a lot of such processing tools, and they are available on the Internet. Responsibility for their use falls on the shoulders (and head) of the client.

But for official users, a universal handler "Unloading / loading is created by the developers. xML data».

IMPORTANT. Export to XML in 1C and further loading in XML from 1C is permissible for identical configurations - Otherwise, its damage will occur.

Universal handler

Highlights for the use of a universal developer:

• Import files to save until the end of transferring records and verify their correctness;
• When using both backup copies, they should be recorded to sort the search.

It provides two modes in its work: creating a file while saving information and reading / writing - when imports.

In addition, the user can install both when exporting and loading data additional limitations.

Remove records

You can unload data both throughout the database and selectively.

After downloading, installing and opening the handler, the following is followed:

Their selection is produced in the dialog box that opens after launch. To do this, set ticks in the list that displays metadata objects to extract;

1. The necessary filters are configured (for example, by date);
2. Selects a place on the disk space;
3. Operation itself starts.

Pour entries to the receiver

The first step to accept data to the database, you need to open a processing program in it.

After the path to the source file is specified and the procedure settings checkboxes are activated (if necessary), you can run the process to "Download Data" button.

Now you know how to upload or unload data from 1C in XML format to save data and exchange between databases.

Universal processing "Unloading and downloading data XML" makes a complete or partial unloading of the information database data to the XML file. Subsequently, this file can be loaded into information base With the same processing. The format of the unloading file is different from the file format created when unloading according to the exchange plan, the header part.

Processing can be used only in cases where the information base in which the data is unloaded, and the data in which the data is loaded are homogeneous (configurations are identical, data may vary), or all unloaded objects are almost completely identical in composition and types of details and table portions, properties of the "leading" object of metadata and so on.

Using this processing is possible, for example, to create a full or partial backup of data, making data exchange between information bases, as well as auxiliary tool when restoring failed information bases.

Processing supports unloading data with the possibility of setting the selection by the period. Also implemented checking objects for invalid symbols when exchanging through XML.

Regards, (teacher and developer).

A simple exchange of data between different accounts is one of the key moments of their prevalence, in practice it is enough to download XML in 1C or another product. More often, it is easy to do without its conversion: all databases support the format standard. In practice there is a lot of ways to use XML to transfer data, all of them are implemented in 1C and compatible with it products.

How to download the XML file to 1C database?

Unloaded databases, separately taken documents can be transmitted from users on any communication channels - on interchangeable media, by email or through cloud storage. The format is well compressed with archivers, which significantly speeds up copying and saves a disk space.

The procedure for downloading data from XML format file in general is as follows:

Allow the display of the menu item "All functions". To do this, put a tick in the corresponding Parameters window (the tab is in the "Service" menu section).

In the "All Functions" menu, through this plus, disclose the list of options where and select "Processing".

In the proposed list, open item " Universal exchange data in XML format. "

By pressing the "Download data" button, it will be read from the file, saving to the database with simultaneous validation check. If errors are detected in the document, the procedure will be discontinued with the issuance of a specific text indicating the cause.

How are XML files in 1C?

Using the same processing, the user can unload the selected data list in the XML or the entire base of the whole, creating it backup. This must be done before the introduction of serious adjustments to the global module 1c, if you do not succeed in external processing for any reason.

The format is used on the 1C platform: Enterprise 8 in the following directions:

Unloading price lists, orders, printed Forms documents.

Data exchange with banks, tax service, extrabudgetary funds.

Transfer of calculations by wages Of 1C: ZUP and other "specialized" configurations in the "total" 1C: Accounting 8.

Everywhere is used by the same implementation of universal processing. If its functions are not enough, then resort to the development of your own variants of this module. Moreover, it is not necessary to change the standard files of necessity, it is enough to connect the desired processing and run them to choose from - depending on the specific task.

If a separate method of accounting and tax accounting is selected, the processing for unloading / downloading financial data through XML format will become very popular. With it, the necessary for the calculation tax base The numbers are transferred to the program 1C: taxpayer or like software. Due to the fact that the files of this format are easily edited using the package Microsoft Office. Easy to correct their content before shipping to the tax service.

The same refers to Kudir (book accounting book of income and expenses), accounting magazine issued or received invoice. All this is transmitted through the SMIS ++ system and, in addition to the process of editing the XML file, the unloading in this format is necessary for subsequent download to the service and data transmission in the FTS.

The exchange is often in demand and with such a configuration as 1C: the trade management, since in business, it is used to organize sales, managerial accounting, and accounting based on 1C: Accounting 8 operates autonomously, receiving only summary data on all movements and cash movements funds.

If you unload orders or plunks to configure simply, as it is easy to use "any" data format, then the same bank account statements have to be saved in XML (as a generally accepted standard).

Most often exchange occurs with the Client-Bank program. The upload process looks here as follows:

Extra charge for the user you need.

Depending on the version of the program, the button is pressed or "Export" or "Export".

In the window that opens is selected needled folder and file name.

After completion of the procedure, the document can be transferred on interchangeable media or via the Internet ( email, cloud storages with common access etc.). When you need to download an extract to the 1C configuration, then select the "Bank and Cashier" section, then go to the journal "Bank statements".

Before tabular part The document (in the right corner) press the "still" button, after which the list of functions appears where the item "Exchange with the Bank" appears. Bookmark "Loading an extract from the bank" allows you to import data on the specified company name or on a specific bank account.

After loading an extract to the 1C database, payment orders will still need, it happens in manual mode. An accountant can order a processing development that will allow you to automate the process, but it will be necessary to contact the competent programmer.

The XML format is used and for downloading different classifiers (bracing, octop, ENEF). If they are missing in the program 1C, it is necessary to avoid their manual fill, since it is easy to allow an error when specifying codes. It is worth using the XML file once by downloading the classifier from a reliable source.

Make it can both the user itself and the guest specialist:

The main menu select "References".

Press the "Settings" button.

In the window that opens, you specify the "Download OKOF Classifier" item, followed by clicking on the Add button.

In the "Service" section that appears, select the desired command and nod ok.

It remains to click on the "Open and read file" button, specify the desired on the disk or shift media, open it with the corresponding key. Standard classifiers are automatically copied to hDD When installing the platform and configuration 1c. Moreover, when updating the version of this or that folders are created with the revision number, where the current file corresponding to the current requirements is placed. In version 7 7 is also the possibility download XML Files, but this outdated platform often requires the help of specialists.

Working with XML documents is available directly from the built-in Language of System 1C: Enterprise 8.

It is possible:

• serve read and write XML documents:
  • convert from a string obtained from the text of the element or the XML attribute value to the value in accordance with the specified type;
  • receive a string representation of the value for the placement in the text of the element or the value of the XML attribute;
  • get the XML data type corresponding to the type transmitted as parameter;
  • check the reading features from the XML value of the specified type;
  • make compliance with XML scheme when reading XML
  • to record the value in XML format;
  • return the type corresponding to the XML data type.
• use the object access model to XML documents (DocumentDom), complying with the following standards:
  • Dom Level 2;
  • XPath (Dom Level 3);
  • Dom Load and Save (Dom Level 3).
• use the object model of the XML schema (schemexml);
• use the canonical XML standard 1.1 (Canonical XML 1.1).

Using the external connection and mechanisms for working with XML, you can organize integration with application systems according to the formats adopted in these systems. For this, XSL transform mechanisms are used. For example, for such integration, you can use the Biztalk Server Microsoft:

Fast Infoset.

The platform provides means for working with XML documents in Fast Infoset binary format. Fast InfoSet technology uses alternative XML data display syntax. This provides smaller files and higher processing speed than the data processing speed recorded in the usual XML format. The file recorded in Fast InfoSet format has an extension. Fi or.finf.

Allows you to save time on 1C information about the purchase of PETERHOST services.
To do this, you must download in 1C XML file and the document "Receipt of goods and services" is formed from it, containing information about purchased services. The invoice can be formed on the basis of this document.

detailed instructions Presented below.

1. Connecting external processing

1.1. In case the information base is used: Enterprise 8.x with the "Accounting Company 2.0" configuration, to load a document in CommerceML format, you must connect external processing ()
This can be done in two ways:
1. Save the external processing file locally to disk and open through the "File" → "Open" menu before each data load in the CML format.
2. Connect the processing to the information base (IB) constantly. Then it will be available to everyone (in case of operation on the network) from the "Service" → "Additional reports and processing" → "Additional external processing».

• In the "Service" menu, you must select "Additional Reports and Processing" - "Additional External Processing".
• Press the Add button. The form of adding a new directory element will open:
• In the "Name" field, specify the processing name, such as "Download data in Commerceml format (RU-CENTER GROUP).
• Press the file selection button and specify the path to the boot processing file ().
• Press the "OK" button. Now the processing is connected to the information database and is in the "Advanced External Processing" directory, and you can open it with a double-clicking mouse.

1.2. In the case of using the configuration "Managing the Production Enterprise" (version 10.3 and above) and "Trade Management" (version 1.3 and above), this processing is already included and you can go to clause 2.

2. Formation of the document "Receipt of goods and services"

As a result of the following actions in 1C will be entered information about services purchased in Peterhost.
1. Next, you need to save the XML file with the document "Arrival of goods and services" document for the desired period. File in XML format is in section Personal Cabinet Under reference "XML for" 1C ".
Press the selection button to the right of the "Data File Name" field and select this file (see Figure 1). To the question "read the data from the file?" Answer "OK". The data file will be read by processing.
2. If the processing can be determined to determine all the compliance of the file data elements with the information base data, will the question be set to "save data to the information base?". If you answer "yes," it will be created new document "The arrival of goods and services." Go to clause 3.
3. If not all data meets will be defined, the message will be displayed: "When the data is loaded, the program failed to automatically find IB objects corresponding to the elements transmitted in the exchange file ..." and will suggest mapping manually. In this case, the following must be performed:

• Press "OK". The form matching file and IB objects will appear. It has several bookmarks that match various types objects (organization, counterparties, nomenclature, etc.). If the data of some type was not compared, then on the relevant bookmarks there will be red exclamation signs (see Figure 2).

• Go to the appropriate bookmarks and manually set the conformity of the elements. It should be noted that the compliance of counterparties and organizations are searched for the Inn, and the compliance of the nomenclature - first on the article, then by name. If the item that corresponds to the file data is not in IB, then it can be created automatically according to the file by clicking the "Create data from the file" button.
• When adding a nomenclature, you must mark the "Service" property checkbox (see Figure 3). You can also change the complete and brief name of the element of the nomenclature.

• On the Account Account Bookmark, it is desirable to add account accounting accounts so that, when creating a document "Arrival of goods and services", these numbers are automatically affixed. For example, the following values \u200b\u200bcan be installed for services: "Accounting Account" - 25 (general production costs) and "Account Account Accountable" - 19.04 (VAT for Accessible Services) (see Figure 4).

• After mapping all the items and pressing the "OK" button, the program will request confirmation for the download of the document in IB, after which the new document "Arrival of goods and services" will create (see Figure 5).

3. Wiring of the document "Arrival of goods and services"

To conduct a document "Receipt of goods and services", it is necessary to open it to double pressing and fill in the missing fields, such as "expendancy of advances" (for example, "automatic") and fields on the "Account Account" tab (see Figure 6). The values \u200b\u200bof these fields are determined by the accounting policy of your organization. To carry out the document, you must click the "OK" button.

4. Formation of the document "invoice"

After successfully creating and conducting the document "Arrival of goods and services", on the basis of it, create a document "Account received". To do this, click on the appropriate link in the left lower part of the document form.