When an enterprise constantly uses some kind of software package in its work, then, naturally, the question of its ongoing support and administration always arises. There is no way to avoid the tasks of exchanging, storing and restoring data. Let's look at how to load or upload data from 1C to XML format, as this is an important procedure of this topic.
They are built in such a way that when uploading, you can receive an XML file in which the data necessary for the client will be recorded. At the same time, simultaneously with the recording, the correctness of the transferred records is monitored for critical errors.
Thus, uploading to an XML file (importing records) from one information base and subsequent loading from XML to another represents an exchange of data in XML format between databases.
This procedure, especially with large amounts of information, saves a lot of manual work.
Import (the resulting file) can also be used as an archive for recovery in unexpected situations (if lost or damaged).
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 official users of Odeneski, the developers have created a universal handler “Upload/Load XML data».
IMPORTANT. Export to XML in 1C and further loading into XML from 1C is acceptable for identical configurations - otherwise it will be damaged.
Universal handler
Key points for using the universal developer:
- Save importing files until the transfer of records is completed and their correctness is checked;
- When used as backup copies, a record of them should be kept to sort the search.
Its operation has two modes: 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.
Extracting records
You can upload data both throughout the entire database and selectively - object by object.
After downloading, installing and opening the handler, the following occurs:
Their selection is made 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);
- Disk space is selected;
- The operation itself starts.
Uploading records to the receiver
The first step to accept data into the receiving database is to open the processor program in it.
After the path to the source file has been specified and the procedure settings flags have been activated (if necessary), you can start the process with the “Load data” button.
Now you know how to load or unload data from 1C in XML format to save data and exchange between databases.
Working with XML documents is available directly from the built-in language of the 1C:Enterprise 8 system.
There is a possibility:
- sequentially read and write xml documents:
- convert from a string obtained from the text of an element or an XML attribute value to a value according to the specified type;
- get a string representation of the value to put into the text of an element or the value of an XML attribute;
- get the XML data type corresponding to the type passed as a parameter;
- check whether a value of the specified type can be read from XML;
- check for XML schema compliance when reading XML
- record the value in XML format;
- return a type that matches the XML data type.
- use an object access model for xml document data (DocumentDOM), which complies with the following standards:
- DOM Level 2;
- XPath (DOM Level 3);
- DOM Load and Save (DOM Level 3).
- use object model XML schemas(XML Schema);
- use Canonical XML 1.1 standard.
Using an external connection and mechanisms for working with XML, you can organize integration with application systems using the formats accepted in these systems. XSL transformation mechanisms are used for this. For example, for such integration you can use Microsoft's BizTalk server:
Fast Information
The platform provides tools for working with XML documents in the Fast Infoset binary format. Fast technology Infoset uses an alternative syntax for displaying XML data. This results in smaller file sizes and more high speed processing speed than the processing speed of data written in conventional XML format. A file written in the Fast Infoset format has a .fi or .finf extension.
Operating modes
Processing UploadLoadDataXML82 implements 2 operating modes: Upload (creating an upload file of user-specified data) and Load (reading an upload file created by the mode of the same name and writing the data contained in it). The mode is set by selecting it in the Mode field.
Before starting a particular mode (clicking 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 to select this field and standard dialogue file selection.
In download mode, it is possible to edit the use of totals when writing registers, which may affect the download speed. The “Disable totals” and “Enable totals” buttons are available when the “Enable the ability to edit the use of totals while loading data” flag is set and are used to manually control the mode of using totals when loading data. ** Conditions of applicability of processing**
Processing can only be used in cases where the information base in which the data was uploaded and the one in which the data was loaded are homogeneous (the configurations are identical, the data may differ), or all the uploaded objects are almost completely identical in composition and types of details and tabular parts, properties of the “leading” metadata object, etc. It should be noted that, due to these limitations, processing is mainly intended for exchange between homogeneous IS.
The upload file format differs from the file format created when uploading according to an exchange plan in the header part. To upload data (directory elements, sets of register records, etc.), processing uses the same XML serialization mechanism as uploading according to exchange plans; in this part, the file formats are identical.
Determining the composition of the unloading
Processing allows for both full and partial uploading of infobase data to a file. The composition of the uploaded data is configured in the dialog by checking the boxes in the column of the tree that displays metadata objects for which data can be uploaded. An additional column of checkboxes, “If necessary,” sets the need to unload objects of this type"link". That is, if the checkbox is checked only in the “If necessary” column, then the data for such an object will not be downloaded completely, but only to the extent that is necessary to maintain referential integrity in the infobase that will load the download file.
When opening a form, processing sets the sign of unloading by reference to all objects, which guarantees the referential integrity of the unloaded fragment of the information base.
When you click on the “Detect objects downloaded by link” button, processing analyzes which data links may be contained in objects that have the full download flag set, and automatically fills in the column of flags indicating the need to download by link. If the object already has the full unload flag set, then the unload by reference flag is not set.
Possible applications
The use of this processing is possible, for example, to create complete or partial backup copy data, data exchange between information bases, and also as an auxiliary tool for restoring problematic information databases.
Loading...
