Despite the fact that 1C is the most popular, convenient and reliable information system, which has in its line a set of solutions for automating and processing absolutely all business processes at enterprises of any size and field of activity, users still have a daily need to download data from 1C to third party programs or files. In this article we will look at what unloading from 1C is and we will show how to unload from 1C and what problems may arise during this process.
Data that can be downloaded from 1C
1C of any configuration normally supports uploading such data as:
- Printing forms;
- Reports;
- Tables and lists.
Uploading data from 1C 8.3 is possible in many popular formats:
- Microsoft Excel;
- Microsoft Word;
- Upload to CSV;
- HTML and others.
Uploading printed forms and reports
I love it printed form or the report in 1C can be saved in the desired format. To do this, you will need to open the form or report, then select from the Main menu File - Save As.
After this, a file saving window will open, indicating the file name and type:
Possible problems when unloading from 1C
This is because the printable form or report is not enabled in at the moment. To make the printed form available for saving, you just need to click the mouse anywhere on it:
Upload to Excel
Processing data in the most popular tabular format requires appropriate uploading. In order to save the necessary data in Excel format, you must specify the type in the file save dialog Excel sheet 2007-...(*.xlsx). Less often it is necessary to save data in the old Excel Sheet format (*.xls):
Likewise, choosing required format, you can upload from 1C to PDF, from 1C to WORD, from 1C to CSV, and also to other formats.
Uploading arbitrary tables from 1C
IN this section It will show you how you can upload any data, provided that you have the rights to do so.
1C has developed a standard mechanism that allows you to upload any list (for example, a list of documents or directory elements). To do this, in the command panel of any list, in the group "More" command available "Get a list":
The information will be displayed in a special spreadsheet document. This document looks the same as any other report in 1C, and it can be uploaded in the same way using the command File - Save As:
How to upload data that is not visible in the list
Often, the task of unloading a list is accompanied by the need to add columns that are definitely in the document (directory), but for some reason they are not visible in the current list. Example: in the “Clients” list, add the “Phone” field for uploading, which is displayed only in the additional panel on the right:
In order for the phone to be unloaded from 1C, it must first be added to the list. To do this you need to call the command "More - Change Shape." Next, we need to find the one we need in the list of columns. There is one trick here: developers of standard configurations almost always add a field "Link". If you stand on it and then press the button then we will see all possible fields of this directory. Finding the field "Telephone" and check the use box.
After this, the client database with telephone numbers can be uploaded to a file using the standard command "Get a list" and sell to competitors.
"Loading and Unloading XML data"is a universal processing with which you can perform partial or complete unloading of data from information base to a file with an XML extension. In the future this file can also be uploaded to the information base using the same processing. Note that the file format that is created when uploading for data exchange differs from the format of the upload file in the header part.
Processing is intended for use when uploading data between identical configurations. That is, the information base from which data is downloaded and the database into which they are loaded must be identical, but the data in them may differ. Processing can also be used when all unloading objects are almost completely identical in terms of details, composition, types tabular parts, by the properties of the “leading” metadata object, etc.
Using this processing, you can not only create partial or full backups, but also exchange data between databases, and, if necessary, restore failed or lost information databases. At the same time, the processing provides a function for checking objects for the content of invalid characters when exchanged via XML, as well as the ability to upload data with restrictions.
The presented processing is intended for informational purposes and can only be used by registered ITS users.
Let's set it up. Let's connect. We'll fix it. Let's find error 1c.
Very often it is required to obtain data from 1C 8.3 and save the information in external file, in other words, make an unload from the 1C enterprise. The task is almost always possible without the involvement of 1C programmers.
Consider the series useful tips, with the help of which you can upload data from 1C to an external information system.
In 1C there are several methods by which you can obtain information without the involvement of specialists:
- Uploading the entire database from 1C 8.3 - for subsequent loading on another computer
- Save reports and printables in Excel, Word or PDF
- Uploading tables from 1C
- Retrieving Information Using the Query Console
More details about them:
How to download the entire database from 1C 8.3 (to a .dt file)
To do this, you will need to go to the configurator mode, then in the main menu select “Administration” - “Upload information base”:
Then you only need to indicate the name of the future file and its location on the disk.
To subsequently upload to another database, click on the “Load information base” button and select the previously uploaded file.
Uploading reports and printed forms from 1C to Excel
This method is universal and very simple. To do this, it is enough to open a printed form or report.
For example, open the TORG 12 printable form, press ctrl+S (or in the File menu - Save As) and select the file type and its name:
The same system applies - the report is downloaded in two clicks:
Get 267 video lessons on 1C for free:
Saving in the main formats is available - excel, word, pdf, html, txt, etc.
Uploading tables from 1C 8.3
Often there are such trivial tasks as “get a list of payments for the current year”, “unload a book of purchases or sales” or “unload goods from invoice No. 256”. Solving such problems is quite simple.
For example, I need to receive all receipts from the counterparty “Vector” with an amount greater than 1000. Let’s open the list form and set the necessary selections in the list:
The system will offer an output option - to a spreadsheet document or a text document, select tabular. The 1C program will display the information in the following spreadsheet document, which, like reports, can be saved in the format we need:
Similar actions can be performed for almost any tabular part in 1C 8.2. For example, we needed to unload a list of goods from receipt No. MSK00003, no problem. This is done very simply - open the document, call context menu and after a couple of clicks we get the desired download in the required format:
Uploading a journal of transactions from 1C to Excel:
Retrieving Information Using the Query Console
However, not all information can be found in the simple tabular part of 1C 8.2. Sometimes you need to collect data from several data sources and connect them using some fields.
This method is suitable for technically savvy people who know the basics of query language. It consists in getting the result of the request using and saving it in the format we need.
For example, you need to get all supplier counterparties and their telephone number. To do this, we will write the following query:
The resulting table can also be downloaded into the desired file format:
You can load the received data into another 1C database using “ “. Watch the video instructions using the nomenclature as an example:
This processing allows you to exchange 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 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 using the button to select this field and the standard file selection dialog.
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 during data loading" flag is set and are used to manually control the mode of using totals when loading data.
Conditions for the 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 table 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"by reference". 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 that are unloaded by link” button, processing analyzes which data links may be contained in objects that have the full unload attribute set, and automatically fills in the column of flags indicating the need to unload 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 a full or partial backup copy of data, exchange data between information bases, and also as an auxiliary tool when restoring problematic information bases.
When an enterprise constantly uses some kind of software package, then, naturally, the question of its constant 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 unload data from 1C in XML format, since this is an important procedure for 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 processor “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.
