Quite often, users need to save data from 1C 8.3 to a file, for example, pdf, Word, Excel and other formats. For example, send by e-mail report to another person, make calculations in Excel. Unfortunately, not all users know that it is very easy to download such data from 1C on their own without outside help.
It is often necessary to download a list of some data from the tabular part of a document, a list form, a document log, etc. Such tasks are often isolated, and it is inappropriate to involve a specialist to write a report.
For example, you need to get the entire item with the “Materials” view, but you only need the columns “Item” and “Unit”.
In the case when you need to upload data with filtering, first of all, you need to configure the list in the “More” menu of the tabular section.
In the window that appears, from the left side (available fields), you need to select those by which you will make a selection (in this case, “Type of item”). In the right part of the window, the values of the selection parameters are set. Moreover, the type of comparison is not limited to equality alone.
After the stock has been set, in the list form of the “Nomenclature” directory, only those items that meet the specified condition will be displayed.
The next step is to output this list into a spreadsheet document.
From the More menu, select List.
If you need to display not all columns, as in our example, then check the boxes only for those that are necessary.
As a result, you essentially get a report that we can save in any available format. How to do this will be discussed below. In a similar way, you can download tabular parts of documents and reference books, data from document journals, list forms, and more.
Uploading reports and printed forms from 1C
Any report printed form, a spreadsheet document (for example, which we received in our example) in 1C 8.3 can be uploaded to an external file in two clicks.
On the top panel of the program there is a button to save to an external file (Taxi interface). It will be active on any reports and printed forms where saving is available.
Uploading the entire 1C database
This method is necessary in cases where the 1C database needs to be unloaded as a whole, for example, to create a test copy.
Go to the desired information base in configurator mode.
In the “Administration” menu, select “Download infobase”.
Specify a different file name and save path if necessary.
The resulting downloaded data file with the *.dt extension is very easy to download in the future. To do this, in the configurator mode, in the “Administration” menu, select “Load infobase” and open the *.dt file received earlier.
Probably every 1C specialist has encountered the situation of needing to transfer data from one information base to another. In the case where the configurations are different, you have to write data conversion rules. These rules are created in the 1C “Data Conversion” configuration.
Data can also be transferred using . Many 1C 8.3 configurations have standard functionality for setting up data synchronization between different configurations and seamless integration with 1C Document Flow.
But when data needs to be transferred between absolutely identical configurations, you can simplify your task and use standard processing for uploading and downloading via XML. Please note that this method, like data conversion, compares objects with each other by a unique identifier (GUID), and not by name.
You can download this processing on the ITS disk, or using the links:
It is universal and suitable for any configuration.
Let's consider an example of unloading the "Nomenclature" directory from one 1C 8.3 Accounting 3.0 information base to another. A prerequisite will be selection by the parent (group) “Woodworking”.
Uploading data from 1C to XML
Go to the information base from which the data will be downloaded (source). Be sure to check them, taking into account all possible conditions to avoid undesirable consequences.
Open XML data upload and download processing (Ctrl+O).
We are interested in the “Upload” tab. First of all, specify the name of the file into which the data will be uploaded and the path for saving. In this case, the data is uploaded “To a file on the server.”
In the processing header you can configure the period for which the selection will be carried out. Also, for periodic registers, you can specify the method of applying selection by period. If it is necessary to upload movements along with documents, the corresponding flag is set. In this case, we overload the directory, so there is no need to configure anything in the header.
Let's move on to selecting data for uploading. In the tabular part of the processing form, select the checkboxes for the configuration objects that you need to transfer.
The “Unload if necessary” column indicates whether it is necessary to reload this object, if it is referenced by the attribute of the directory we are reloading. For example, the position of the item you are loading has a unit of measurement that is not in the target database. If the flag in the “Upload if necessary” column is checked opposite the reference book with units of measurement, a new position will be created. Otherwise, the value of the attribute will be “<Объект не найден>" and its unique identifier.
In a simple case without selections, the item overload setting will look like this.
IN in this example you need to select only the items that are located in the “Woodworking” folder.
Similar processing for 8.2 allows you to set selections for each configuration object in a convenient form. In 8.3, unfortunately, there is no such functionality. One way out in this situation would be to select the necessary items on the “Additional objects for unloading” tab.
You can add objects here either manually (the “Add” button) or by request (“Add by request...”). If there are a large number of them, the second option is preferable.
In this case, the request will be as follows. Fill in the parameters, complete the request after checking the data, and click on the “Select result” button.
After you have specified all the necessary objects and additional elements for uploading, click on the “Upload data” button. They will end up in an XML file, the name and path of which you specified earlier. The results of this operation will be displayed in messages.
In this example, it was necessary to unload only 3 positions, but five were unloaded. This is because a flag was set opposite the “Nomenclature” directory in the “Upload if necessary” column. Along with the necessary positions, their parents were overloaded.
Loading a directory from XML
After successfully downloading data from the source configuration into an XML file, open the destination database. The structure of objects and their details must match each other. In this case, the transfer is carried out between two standard configurations 1C: Accounting 3.0.
Open processing in the receiver database. This processing used for both uploading and downloading data. Go to the “Download” tab and specify the path to the XML file into which the data was previously downloaded. After that, click on the “Download data” button.
The download result will be displayed in messages. In our case, everything went well.
The “Nomenclature” directory in the receiving database was not filled out. Now it has five elements: three nomenclature positions and two groups.
Very often you need to obtain data from 1C 8.3 and save the information to an external file, in other words, download it from 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 – Save As menu) 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 obtaining 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 phone number. To do this, we will write the following query:
The resulting table can also be downloaded to required format file:
You can load the received data into another 1C database using “ “. Watch the video instructions using the nomenclature as an example:
Configuration: 1c accounting
Configuration version: 3.0.44.177
Publication date: 20.01.2017
The 1C: Accounting program now offers the ability to routinely upload and download data from Excel spreadsheet documents, without the use of third-party processing or configuration changes. Loading and unloading is so easy that experienced users will quickly fall in love with this convenient mechanism, and new users will quickly master it.
Download from Excel 1C: Accounting 8.3 ed. 3.0
For example, we have this Excel spreadsheet document for loading a list of items and prices (retail and purchasing).
Come to .
At the top click Nomenclature and Prices - Download. This is where loading and unloading from spreadsheet documents is hidden.
The download supports xls (old Excel 97-2003 format) and xlsx (new format), as well as mxl and ods formats. Now we select our file with the nomenclature and wait for it to load.
The spreadsheet document has been loaded in the form we saw it in Excel, now we’ll assign columns and delete the unnecessary ones.
Click on Please provide details and select the desired item from the list.
Select the row that contains unnecessary entries, namely the table header, and click Delete line.
Now we delete the column with the purchase price, note that processing can fill out only 1 type of price at a time!!! Then you can do this operation again and load the 2nd type of price, for the 1st load Retail for the 2nd purchase.
Fill in the blank data, Price type, Set prices for. The buttons All, Found, New, Duplicates will greatly facilitate the search and help compare items. Fill in and click Download after which the data will be loaded into 1C: Accounting.
New items appeared in the product list, filled and with assigned prices. If you need to load another type of price, do all the steps again, but select a column with a different price, 1C itself will find already created positions and will not try to duplicate them, but will simply add a new type of price.
As you can see, the download created 2 documents for setting item prices, for the Purchase Price and for the Retail Price. The difference between this treatment is Loading from Excel to 1C: Accounting 8.3, The fact is that this is standard processing and it works without failures and takes into account all the features of filling out the document.
Uploading to Excel from 1C: Accounting 8.3 ed. 3.0
Very useful function in version 3.0.44.177 and higher is uploading to Excel from 1C: Accounting 8.3, this processing will help you create a company price list or transfer your list of items to suppliers or buyers immediately with prices.
It's all there in the directory Nomenclature - Nomenclature and Prices - Unload.
In point Columns, select the columns that need to be built in the Excel document. Selection serves to select items by Groups, properties, names... etc.
To upload to Excel, we will add a new column, namely the VAT rate, it doesn’t seem to be very necessary, but we are practicing.
Very often, users have the task of uploading a nomenclature directory to external files (most often Excel or XML). There is a simple solution "on the forehead" - use the button List in the directory, however there are problems:
- a very limited number of details (of course you can add them, but this is a separate and difficult job),
- the list cannot be saved in XML,
- it does not contain data on prices and inventory balance.
In this regard, the idea of creating this product was born.
Uploading items into Excel
On the processing form, select the source for generating the names of the file columns:
Select the desired type of unloading:
If necessary, we set up selection by item (in my example, it is configured by type of item; those products that are not on stock are also excluded. If we want to analyze warehouse balances not for all warehouses, but for a specific one, we should fill in the field value Stock. To upload price data to a file, you need to select the price type:
At the bottom of the form, from the proposed list of details, select those whose values need to be uploaded to a file (using blue arrows you can configure the desired order of the columns of the future Excel file). In addition to the standard properties of the item, you can upload additional details, as well as data on price and free stock balance:
After all the settings, click Unload, the system prompts you to specify a folder to save the file:
Once the upload is complete, the following protocol appears:
The result is the following file:
Uploading items in XML
Uploading to XML is usually required for exchange with third parties information systems(most often this is a website), processing is well suited for such tasks.
We select the type of upload; now, as an example, we will take the names of the fields in the file from the alias. This time we unload all the items available in the remainder of a particular warehouse and for which retail prices have been set.
In the list of details for each selected field you need to specify an alias:
The result is an XML file like this:
The table settings are remembered when closed and restored automatically the next time it is opened.
Release 1.0.1.2 from 04/07/2019
It is now possible to upload barcodes and item characteristics in separate columns.
Release 1.0.1.3 from 04/13/2019
A second version of processing has been added, which allows you to download items from the tabular part of selected information base documents (one or more).
When you open the upload form, a selection is automatically created based on the item from the document (the selection table is hidden).
Of course, you can use both processing options in your database.
