When creating a website for a company in a social business network, the website gives you the opportunity, without much effort, to upload your goods and services from the 1C version 8.2 to your online store. To do this, you need to use the external unload XML data processing. This processing, if necessary, can be found on the ITS disk.
You can upload no more than 100 products from the 1C program to your website.
To use the processing, you need to open the 1C program, in the main menu click on the button "file", choose "open" and indicate the path to processing. Then in the window that opens, in the field "file name", specify the name and folder where the XML file will be uploaded. After that, on the left side of the screen, you must indicate what you need to unload. Finally, press the button "unload data"... To upload to the online store in your personal account, you must click the Upload XML button and specify the path to the file that was downloaded from 1C. The integration is based on Russian and international standards and protocols for electronic data exchange.
1 To use the processing, you need to open the 1C program, in the main menu, click "file", choose "open" and indicate the path to processing.
2. After that, in the window that opens, in the field "File name", specify the name and folder where the XML file will be uploaded.
3. Then, on the left side of the screen, you must indicate what you need to unload.
4 ... Finally, press the button "Upload data".
Probably, every 1C specialist was faced with the situation of the need to transfer data from one infobase to another. In the case when the configurations are different, you have to write data conversion rules. These rules are created in the 1C Data Conversion configuration.
You can also transfer data using. Many 1C 8.3 configurations have standard functionality for setting up data synchronization between different configurations and seamless integration with 1C Document Management.
But when data needs to be transferred between completely identical configurations, you can simplify your task and use the standard processing of upload and download via XML. Please note that this method, as well as data conversion, matches objects with each other by a unique identifier (GUID), and not by name.
You can download this processing on the ITS disk, or follow the links:
It is universal and suitable for any configuration.
Let's consider an example of unloading the Nomenclature directory from one 1C 8.3 Accounting 3.0 information base to another. Selection by parent (group) "Woodworking" will be a prerequisite.
Unloading data from 1C to XML
Go to the infobase from where the data will be downloaded (source). Be sure to check them, taking into account all possible conditions in order to avoid undesirable consequences.
Open XML data upload and download processing (Ctrl + O).
We are interested in the Unloading tab. First of all, specify the name of the file into which the data will be uploaded and the path for saving. In this case, the data is uploaded "To a file on the server".
In the processing header, the period for which the selection will be carried out is configured. Also, for periodic ledgers, you can specify how the selection by period is applied. If it is necessary to unload movements along with documents, the corresponding flag is set. In this case, we are overloading the directory, so there is no need to configure anything in the header.
Let's move on to selecting data for uploading. In the tabular section of the processing form, check the boxes for the configuration objects that you need to transfer.
The column "Unload if necessary" means whether it is necessary to reload this object if it is referenced by the attribute of the directory we are reloading. For example, the position of the item you are reloading has a unit of measurement that is not in the receiver base. If the checkbox in the “Unload if necessary” column is set opposite the reference book with units of measurement, a new position will be created. Otherwise, the inscription “<Объект не найден>"And its unique identifier.
In a simple case, without sampling, the item reloading setting will look like this.
In this example, you only need to select the item that is located in the "Woodworking" folder.
Similar processing for 8.2 allows you to conveniently set selections for each configuration object. In 8.3, unfortunately, there is no such functionality. One of the ways out in this situation would be to select the necessary positions on the "Additional objects for unloading" tab.
You can add objects here either manually (the "Add" button) or by request ("Add by request ..."). With a large number of them, the second option is preferable.
In this case, the request will be as follows. Fill in the parameters, execute the request, checking the data, and click on the "Select result" button.
After you have specified all the necessary objects and additional elements for uploading, click on the "Upload data" button. They will go to the XML file, the name and path of which you specified earlier. The results of this operation will be displayed in messages.
In this example, it was necessary to unload only 3 positions, but five were unloaded. This is because the flag was set in the column “Unload if necessary” opposite the “Nomenclature” directory. Together with the necessary positions, their parents were overloaded.
Loading a reference from XML
After successfully unloading data from the source configuration into an XML file, open the destination database. The structure of objects and their details must match each other. In this case, the transfer is carried out between two typical configurations of 1C: Accounting 3.0.
Open processing in the receiver base. This processing is used for both uploading and downloading data. Go to the Download tab and specify the path to the XML file into which the data was previously downloaded. After that, click on the "Download data" button.
The download result will be displayed in messages. In our case, everything went well.
Directory "Nomenclature" in the base - the receiver was not filled. Now it has five elements: three nomenclature items and two groups.
Universal processing "Upload and download XML data" performs full or partial upload of infobase data into a file in XML format. Subsequently, this file can be loaded into the infobase using the same processing. The format of the upload file differs from the format of the file created when uploading according to the exchange plan by the header part.
Processing can be used only in cases where the infobase in which the data was downloaded and the one in which the data is loaded are homogeneous (the configurations are identical, the data may differ), or all unloaded objects are almost completely identical in composition and types of attributes and tabular sections, properties of the "lead" metadata object, and so on.
The use of this processing is possible, for example, to create a full or partial backup of data, to exchange data between infobases, and also as an auxiliary tool in restoring failed infobases.
Processing supports data uploading with the ability to specify a selection by period. Also, objects are checked for invalid characters when exchanged via XML.
Best regards, (teacher and developer).
2018-11-15T19: 32: 35 + 00: 00Universal processing "Upload and download XML data" performs full or partial upload of infobase data into a file in XML format. Subsequently, this file can be loaded into the infobase using the same processing. The format of the upload file differs from the format of the file created when uploading according to the exchange plan by the header part.
Processing can be used only in cases where the infobase in which the data was downloaded and the one in which the data is loaded are homogeneous (the configurations are identical, the data may differ), or all unloaded objects are almost completely identical in composition and types of attributes and tabular sections, properties of the "lead" metadata object, and so on.
The use of this processing is possible, for example, to create a full or partial backup of data, to exchange data between infobases, and also as an auxiliary tool in restoring failed infobases.
Processing supports data uploading with the ability to specify a selection by period. Also, objects are checked for invalid characters when exchanged via XML.
Best regards, (teacher and developer).
When an enterprise constantly uses some kind of software package in its work, then, naturally, the question of its constant support and administration always arises. There is no way to do with the tasks of data exchange, storage and recovery. Let's consider how to load or unload data from 1C in XML format, since this is an important procedure in this topic.
They are built so that when unloading, you can get an XML file, in which the data required by the client will be written. At the same time, simultaneously with the recording, the correctness of the transferred records is checked for critical errors.
Thus, uploading to an XML file (importing records) from one infobase and then loading from XML to another is an exchange of data in XML format between databases.
This procedure, especially with large amounts of information, saves a lot of manual work.
Import (resulting file) can also be used as an archive for recovery in unforeseen situations (in case of loss or damage).
A lot of such processing tools have been developed, and they are available on the Internet. Responsibility for their use falls on the shoulders (and head) of the client.
But for the official users of the same one, the developers have created a universal XML data upload / download handler.
IMPORTANT. Export to XML in 1C and further loading into XML from 1C is permissible for identical configurations - otherwise it will be damaged.
Generic handler
Highlights for using a generic developer:
- Save the import of files until the end of the transfer of records and check their correctness;
- When used as backups, keep track of them for sorting searches.
It has two modes of operation: creating a file when saving information and reading / writing it when importing.
In addition, the user can set additional restrictions both when exporting and loading data.
Retrieving records
The data can be unloaded both throughout the database and selectively - by object.
After downloading, installing and opening the handler, the following is done:
They are selected in the dialog box that opens after launch. To do this, check the boxes in the list that displays the metadata objects to be retrieved;
- The necessary filters are configured (for example, by date);
- A place on the disk space is selected;
- The operation itself starts.
Fill records into the receiver
The first step for receiving data into the receiving database is to open a handler program in it.
After the path to the source file is indicated and the checkboxes of the procedure settings are activated (if necessary), you can start the process with the button “Load data”.
Now you know how to load or unload data from 1C in XML format to save data and exchange between databases.
