Universal transfer of reference books 1C 8.3.

Data transfer is a very important process in any accounting system, 1C 8.3 and 8.2 platform no exception. Below we consider the instructions, how to easier to transfer data from one system to another, having a similar configuration (for different configurations, you can use a tool for programmers - or).

Before any actions needed, changes are irpenitable!

The easiest I. convenient way Data transfer from 1C 8.3 to 1C 8.3 Accounting 3.0 - Using processing Uploading and loading data in XML format (download - for 8.2 or for 1C 8.3 or ITS). Processing is universal and suitable for any configurations.

Let's not go into details, consider step-by-step instructions By migration data using this processing on the example of the simplest transfer of goods.

Unloading data in XML

I will first work out the processing in the database source (where we will unload the goods) and look at the interface:

Get 267 video tutorials for 1C for free:

Immediately you need to fill in the "File Name" field - on this path will be created new file. Data that we will upload a receiver to the database. Slightly below, in the tabular part "Data for unloading" you need to select the data that we want to unload from the database.

After selecting an object from the left tabular part, you can apply selection in the right tabular part:

In our example, I want to unload all products with the name "Rake".

After all the settings are filled, the data can be unloaded. To do this, click on the "Upload Data" button:

Loading data from XML in 1C 8.3

Data is unloaded from the database of the source, now they must be transferred to the database.

To do this, it is necessary to start processing already in the database in which it is necessary to download the data, and go to the "Load" tab, select the unloaded file on the disk and click on the Download Data button:

This example is suitable for transferring data between identical configurations on 1C platform. To understand the exchange mechanism, for programmers, we wrote an article -.

The transfer of various data is a very significant action in any accounting system on 1C platform. Before exporting a directory to another base, you need to do backupBecause the changes made are considered irreversible.

The most popular and at the same time a fairly simple method of transferring a reference book in 1C 8.3 - to the processing of information data in XML form.

To perform this task, you will need to use the Upload / Download processing file for 8.2 or for 1C 8.3. This method is universal and most optimal, suitable for almost any configuration installed.

Disload data

To do this, it will be initially necessary to enter the program interface and perform a number of actions:

1. Fill out the "File Name" field. With this path, the information data file will be created subsequently for downloading to the database.

2. In the area of \u200b\u200b"Data for Unloading" tables, select information from the directory you want to unload from the available base.

3. After that, when the necessary objects are highlighted, selection overlapping in the right side of the tables.

4. After completing the installation of all the required settings, perform the export of the directory.

Download data to the directory

To transfer reference books in 1C, you will need to perform a number of actions:

1. Run the processing in the database where you want to download information data, and use the Loading tab.

2. Then select the previously unloaded file and use the Download Data command.

After this action is performed, the migration of the reference book from one base to another is considered fully completed.

Probably, each 1C specialist came across the situation of the need to transfer data from one information base to another. In the case when the configurations are different, you have to write data conversion rules. These rules are created in the 1C configuration "data conversion".

Also, data can be transferred using. Many configurations 1C 8.3 there is a typical functionality for configuring data synchronization between different configurations and seamless integration with 1C document flow.

But when the data must be transferred between absolutely identical configurations, you can simplify the task and take advantage of standard processing Unloading and download via XML. Note that such a method as the data conversion compares objects by unique identifier (GUID), not by name.

You can download this processing on the ITS disk, or by reference:

It is universal and suitable for any configuration.

Consider an example of unloading the Handbook "Nomenclature" from one information base of 1C 8.3 Accounting 3.0 to another. Mandatory condition There will be a selection by a parent (group) "Woodworking".

Uploading data from 1C in XML

Go to the information base, from where the data (source) will be unloaded. Be sure to check them, provided for all possible conditions in order to avoid the occurrence of undesirable consequences.

Open the upload and loading and downloading XML data (Ctrl + O).

We are interested in the "Unloading" tab. First of all, specify the name of the file to which the data and the path for saving will be unloaded. In this case, the data is unloaded "to the file on the server".

In the processing cap, the period in which the selection will be carried out. Also, for periodic registers, you can specify a method for using selection by period. If you need to unload movements together with documents, the corresponding flag is set. In this case, we overload the directory, so you do not need to set anything in the header.

Let us turn to the selection of data for unloading. In the table part of the processing form, select the configuration objects that you need to transfer flags.

The column "unload if necessary" means whether it is necessary to overload this objectIf it refers to the requisition of the reference book overlap. For example, the position of the nomenclature overloading has such a measurement unit that is not in the database. If in front of the reference book with units of measurement, the flag in the "Unload, if necessary" column, will create a new position. Otherwise, as the value of the props will be the inscription "<Объект не найден>"And its unique identifier.

IN simple case Without selections, setting up the overload of the nomenclature will look like this.

In this example, you only need to select the nomenclature that is located in the Woodworking folder.

Similar processing for 8.2 allows you to install selection in a convenient form for each configuration object. In 8.3, unfortunately, there is no such functional. One of the options for the output in this situation will be the selection of the necessary positions on the "Additional Objects for Unloading" tab.

You can add objects here as manually ("Add" button) and the query ("add a request ..."). With their large quantity, the second option is preferable.

In this case, the request will be as follows. Fill in the settings, execute the request by checking the data, and click on the "Select Result" button.

After you specify all the necessary objects and additional elements for unloading, click on the Upload Data button. They will fall into the XML file, the name and path of which were indicated earlier. The results of this operation will be displayed in messages.

In this example, it was necessary to unload only 3 positions, but five unloaded. All because in front of the Handbook "Nomenclature" in the "Unload If necessary" column, a flag was installed. Together with the right positions, their parents overloaded.

Download directory from XML

After successfully unloading data from the configuration - the source in the XML file, open the database - receiver. The structure of objects and their details should coincide with each other. In this case, the transfer is carried out between two standard configurations 1C: Accounting 3.0.

Open the processing in the database. This treatment Used both for unloading and downloading data. Click the Download tab and specify the path to XML fileIn which the data was previously unloaded. After that, click on the Upload Data button.

The download result will be displayed in messages. In our case, everything was successful.

Handbook "Nomenclature" in the database was not filled. Now it has five elements: three nomenclature positions and two groups.

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 the information base using 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 tabular parts, the properties of the "master" object of metadata and so on.

Using this processing is possible, for example, to create a full or partial backup data, making data exchange between information bases, as well as auxiliary instrument 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).