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, for creating a full or partial backup of data, for exchanging 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).
This processing allows the exchange of data between the same (identical) configurations on the 1C 8.3 platform - Bukh 3.0, ZUP 3.0, UT 11, UPP 2.0 and others, the main thing is that the configurations are the same!
Screenshots
(foto) 
(foto)
Operating modes
Processing implements 2 modes of operation: Unloading (creating an unloading file specified by the user) and Loading (reading the unloading file created by the mode of the same name and writing the data available in it). The mode is set by selecting in the Mode field.
Before starting this or that mode (pressing the Run button), you need to specify the name of the upload file either by entering it manually in the "File name" field, or by using the button for selecting this field and the standard file selection dialog.
In the download mode, it is possible to edit the use of totals when writing registers, which may affect the download speed.
The buttons "Disable totals" and "Include totals" are available when the checkbox "Enable the ability to edit the use of totals during data loading" is checked and are used to manually control the mode of using totals during data loading.
Conditions of applicability of processing
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 "leading" metadata object, and so on. It should be noted that, due to the specified limitations, processing is mainly intended for exchange between homogeneous information security.
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. To unload data (elements of directories, sets of register records, etc.), processing uses the same XML serialization mechanism as unloading according to exchange plans; in this part, the file formats are identical.
Determination of the composition of the unloading
Processing allows both full and partial uploading of infobase data to a file. Configuring the composition of the uploaded data is done in the dialog by checking the boxes in the column of the tree displaying metadata objects, data on which can be uploaded. An additional column of flags, "If necessary", sets the need to unload objects of this type "by reference". That is, if the checkbox is selected only in the "If necessary" column, then the data for such an object will not be completely unloaded, but only to the extent necessary to maintain referential integrity in the infobase that will load the unloading file.
When the form is opened, processing sets the sign of unloading by reference to all objects, which guarantees the referential integrity of the unloaded infobase fragment.
When you click on the "Define objects to be uploaded by link" button, the processing analyzes the links to which data can be contained in the objects that have the complete unloading flag set, and automatically fills in the column of flags indicating the need to upload by reference. If the object already has the full upload check box selected, then the upload by link check box is not set.
Possible applications
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 problem infobases.
This processing allows the exchange of data between the same (identical) configurations on the 1C 8.2 platform - Bukh, ZUP, UT, UPP and others, the main thing is that the configurations are the same!
Processing screenshots
(foto) 
(foto)
Operating modes
Processing implements 2 modes of operation: Unloading (creating an unloading file specified by the user) and Loading (reading the unloading file created by the mode of the same name and writing the data available in it). The mode is set by selecting in the Mode field.
Before starting this or that mode (pressing the Run button), you need to specify the name of the upload file either by entering it manually in the "File name" field, or by using the button for selecting this field and the standard file selection dialog.
In the download mode, it is possible to edit the use of totals when writing registers, which may affect the download speed.
The buttons "Disable totals" and "Include totals" are available when the checkbox "Enable the ability to edit the use of totals during data loading" is checked and are used to manually control the mode of using totals during data loading.
Conditions of applicability of processing
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 "leading" metadata object, and so on. It should be noted that, due to the specified limitations, processing is mainly intended for exchange between homogeneous information security.
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. To unload data (elements of directories, sets of register records, etc.), processing uses the same XML serialization mechanism as unloading according to exchange plans; in this part, the file formats are identical.
Determination of the composition of the unloading
Processing allows both full and partial uploading of infobase data to a file. Configuring the composition of the uploaded data is done in the dialog by checking the boxes in the column of the tree displaying metadata objects, data on which can be uploaded. An additional column of flags, "If necessary", sets the need to unload objects of this type "by reference". That is, if the checkbox is selected only in the "If necessary" column, then the data for such an object will not be completely unloaded, but only to the extent necessary to maintain referential integrity in the infobase that will load the unloading file.
When the form is opened, processing sets the sign of unloading by reference to all objects, which guarantees the referential integrity of the unloaded infobase fragment.
When you click on the "Define objects to be uploaded by link" button, the processing analyzes the links to which data can be contained in the objects that have the complete unloading flag set, and automatically fills in the column of flags indicating the need to upload by reference. If the object already has the full upload check box selected, then the upload by link check box is not set.
Possible applications
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 problem infobases.
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, for creating a full or partial backup of data, for exchanging 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).
Simple data exchange between different accounting programs is one of the key points of their prevalence; in practice, it is enough to load XML into 1C or another product. Moreover, most often it is easy to do without converting it: all databases support the format standard in full. In practice, there are many ways how to use XML to transfer data, all of them are implemented in 1C and compatible products.
How to upload an XML file to the 1C database?
The downloaded databases, individual documents can be transferred from users through any communication channels - on removable media, by e-mail or through cloud storage. The format lends itself well to compression using archivers, which significantly speeds up copying and saves disk space.
The procedure for loading data from an XML file is broadly as follows:
Allow the display of the menu item "All functions". To do this, put a tick in the corresponding item of the "Parameters" window (the tab is located in the "Service" menu section).
In the menu "All functions" through the plus open the list of options, where and select the item "Processing".
In the offered list, open the item "Universal data exchange in XML format".
By pressing the button "Load data", they will be read from the file, saved to the database with simultaneous verification of their correctness. If errors are found in the document, the procedure will be terminated with the issuance of a specific text indicating the reason.
How are XML files used in 1C?
Using the same processing, the user can upload a selected list of data or the entire database into XML, thereby creating a backup copy of it. This must be done before the introduction of serious adjustments to the global 1C module, if you cannot manage with external processing for some reason.
The format is used on the 1C: Enterprise 8 platform in the following areas:
Unloading of price lists, orders, printed forms of documents.
Data exchange with banks, tax service, extra-budgetary funds.
Transfer of payroll calculations from 1C: ZUP and other "specialized" configurations to the "general" 1C: Accounting 8.
The same universal processing implementation is used everywhere. If its functions are few, then they resort to developing their own versions of this module. Moreover, there is no need to change the standard files, it is enough then to connect the necessary processing and launch them at choice - depending on the specific task.
If a company chooses a separate method of accounting and tax accounting, then the processing of uploading / downloading financial data via the XML format will become very popular. With its help, the numbers necessary for calculating the tax base are transferred to the 1C: Taxpayer program or to a similar software product. Due to the fact that files of this format are easy to edit, using the Microsoft Office package it is easy to correct their content before sending to the tax office.
The same applies to KUDiR (book of income and expenses), a journal of accounting of issued or received invoices. All this is transmitted through the VLSI ++ system and, in addition to the process of editing the tabular section of the XML file, unloading in this format is necessary for subsequent loading into the service and transferring data to the Federal Tax Service.
Exchange with such a configuration as 1C: Trade Management is often in demand, since in business it is used to organize sales, management accounting, and accounting based on 1C: Accounting 8 functions autonomously, receiving only summary data on all movements of goods and cash funds.
If the unloading of orders or price lists is easy to set up, since it is easy to use "any" data format, then the same bank statements have to be saved in XML (as a generally accepted standard).
Most often, the exchange takes place with the Client-Bank program. The upload process looks like this here:
An extract is generated for the period required by the user.
Depending on the version of the program, either the “Export” or “Export” button is pressed.
In the window that opens, the required folder and file name are selected.
After completing the procedure, the document can be transferred to removable media or via the Internet (e-mail, cloud storage with shared access, etc.). When you need to load a statement into the 1C configuration, you select the "Bank and Cashier" section, then go to the "Bank statements" journal.
In front of the tabular part of the document (in the right corner), press the "More" button, after which a list of functions appears, where the item "Exchange with the bank" is selected. The "Download bank statement" tab allows you to import data on the specified company name or on a specific bank account.
After uploading the statement to the 1C database, you will still need to carry out payment orders, this happens in manual mode. An accountant can order the development of processing that will automate the process, but here you need to contact a competent programmer.
The XML format is also used to load various classifiers (KLADR, OKOF, ENAOF). If they are absent in the 1C program, you must avoid manually filling them in, since it is easy to make a mistake when specifying the codes. It is worth using the XML file once by downloading the classifier from a trusted source.
This can be done by both the user himself and the invited specialist:
In the main menu, select the "References" section.
The button "Configure actions" is pressed.
In the window that opens, point "Load okof classifier", then click on the "Add" button.
In the "Service" section that appears, select the desired command and press "OK".
It remains to click on the "Open and read the file" button, specify the desired one on the disk or removable media, open it with the appropriate key. Standard classifiers are automatically copied to the hard disk during platform installation and 1C configuration. Moreover, when updating a version of one or another, folders with a revision number are created, where the current file is located that meets the current requirements. Version 7-7 also has the ability to load XML files, but this legacy platform often requires professional help.
