Suppose you need to download the "Nomenclature" directory from the 1C: Enterprise database. There can be many reasons for this, for example, transferring a reference book to an empty database or creating a price list. Let's consider the simplest way to accomplish this task.
Necessary
database
Instructions
Step 1
1C: Enterprise allows you to unload any directory without resorting to writing complex loading / unloading processing, using only built-in tools. First, we need to decide in what format we want to receive the data:
*.mxl - internal format of 1C tabular data, suitable for loading into another 1C database;
*.xls - Excel spreadsheets;
*.pdf - electronic document Adobe Reader;
*.html - web page for publishing on the Internet;
*.txt is a simple text file, useful for loading into any database.
If the directory is hierarchical, then the list will be unloaded into the *.mxl and *.xls formats with the preservation of the hierarchy and the ability to collapse / expand groups. All other formats will be uploaded with a simple list, with the enumeration of the group's elements after its name.
Step 2
Let's open the directory that we need to unload. In our case, this is "Nomenclature". Operations -> References -> Nomenclature. You can download not the entire directory, but only a certain group, for this you need to go to this group. With large amounts of data, it makes sense to upload in groups to different files to speed up work.
Step 3
On any line of the opened list, right-click and select the "Display list" item. The settings window will appear.
Step 4
In the settings window, we will leave the checkboxes only for those fields that we need in the final document. In the field "Output to …" we will leave the item "Tabular document" (you can also select "Text document", but tabular document is more universal). Click the "OK" button.
Step 5
A spreadsheet document with a list of items will appear on the screen. Place the mouse cursor on one of the cells of the document, for this it is enough to click on the first cell.
Step 6
For further work, the file must be saved. Choose File -> Save a Copy from the menu. Items "Save" and "Save as …" can be selected only if you save in the internal 1C format.
Step 7
In the window that appears, write the name of the file and select the format we need. If the amount of data is very large (more than 10 thousand lines), then the first should be preferred between the table formats *.mxl and *.xls - this will significantly speed up the saving of the document. You also need to remember that in Excel there is a limit on the number of rows:
in Excel below 97 - no more than 16384 lines;
in Excel 97-2003 - no more than 65536 lines;
in Excel 2007 and later, no more than 1,048,576 rows.
Step 8
Click the "Save" button. Our task has been accomplished.
