Very often it is required to get data from 1C 8.3 and save the information to an external file, in other words, to upload from 1C enterprise. The task is almost always feasible without the involvement of 1C programmers.
Consider the series useful tips, with which you can upload data from 1C to an external information system.
There are several methods in 1C by which you can get information without involving specialists:
- Unloading the entire database from 1C 8.3 - for subsequent download on another computer
- Save reports and printables to Excel, Word or PDF
- Unloading tables from 1C
- Getting Information Using the Query Console
More about them:
How to unload the entire database from 1s 8.3 (to a .dt file)
To do this, you need to enter the configurator mode, then select the item "Administration" - "Unload infobase" in the main menu:
Then you only need to specify the name of the future file and its location on the disk.
For subsequent upload to another database, click on the "Upload infobase" button and select the previously uploaded file.
Unloading reports and printables from 1C to Excel
This method is universal and very simple. To do this, it is enough when you open a printable form or report.
For example, open the TORG 12 printable, press ctrl+S (or in the menu File - Save As) and select the file type and its name:
For the same system operates - the report is unloaded in two clicks:
Get 267 1C video lessons for free:
Saving to the main formats is available - excel, word, pdf, html, txt, etc.
Unloading tables from 1C 8.3
Often there are such banal 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 "Vector" counterparty with an amount of more than 1000. Let's open the list form and set the necessary filters in the list:
The system will offer a withdrawal option - in spreadsheet document or text, choose tabular. The 1C program will display information in such a 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 upload a list of goods from receipt No. МСК00003, 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 desired format:
Uploading a journal of transactions from 1C to Excel:
Getting Information Using the Query Console
However, not all information can be found in a simple tabular part of 1C 8.2. Sometimes you need to collect data from several data sources, connect them by some fields.
This method is suitable for tech-savvy people who know the basics of the query language. It consists in getting the result of the query using and saving it in the format we need.
For example, you want to get all supplier contractors and their telephone number. To do this, write the following query:
The resulting table can also be uploaded to the desired file format:
You can upload the received data to another 1C database using "". Watch the video instruction on the example of the nomenclature:
JSC GNIVTS (FTS of Russia): 08/05/2016 from 05:00 Moscow time due to technological work at the FDC site, the federal level components (GPK, SM, IRUD, SP FU) of the GP-3 receiving complex will be unavailable. Estimated completion time is 12:00 Moscow time. At the same time, the Link-Service companywill carry out technical work. The mail server may not be available to send/receive emails at this time. We apologize for any inconvenience caused.
Posted Aug 4 2016 10:55 by Vyacheslav Abisalov
Posted Jan 19 2016, 04:51 by Vyacheslav Abisalov
Posted 18 Jan. 2016, 08:22 by Vyacheslav Abisalov
Submitted 8 Dec. 2015, 11:24 by Vyacheslav Abisalov
Submitted 6 Dec. 2015, 13:49 by Vyacheslav Abisalov
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 to e-mail report to another person, make calculations in Excel. Unfortunately, not all users know that it is very easy to upload such data from 1C on their own without outside help.
Often there is a need to upload a list of any data from the tabular part of a document, a list form, a document journal, etc. Such tasks are often isolated, and it is not advisable to involve a specialist to write a report.
For example, you need to get the entire item with the "Materials" type, while only the "Nomenclature" and "Unit" columns are needed.
In the case when you need to upload data with their filtering, first of all, you need to set up the list in the “More” menu of the tabular section.
In the window that appears, from the left side (available fields), you must select those by which you will make a selection (in this case, “Nomenclature type”). 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 turn has been set, only those positions that meet the specified condition will be displayed in the list form of the "Nomenclature" reference book.
The next step is to display this list in a spreadsheet document.
From the More menu, select Show 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 get, in fact, a report that we can save in any available format. How to do this will be discussed below. Similarly, you can upload tabular parts of documents and directories, data from document journals, list forms, and more.
Uploading reports and printables from 1C
Any report, printable form, 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 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.
Unloading the entire 1C database
This method is necessary in cases where the entire 1C database needs to be unloaded, for example, to create a test copy.
Go to the required infobase in the configurator mode.
In the "Administration" menu, select the "Unload infobase" item.
Specify a different file name and save path if necessary.
The resulting uploaded 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 the "Load infobase" item and open the *.dt file obtained earlier.
It is convenient and fast to upload reports from 1C in the system. To do this, in the 1C program, in which reporting is generated, it is proposed to install special add-ons.
It should be noted that the transfer of reporting from 1C to SBiS ++ is implemented only for version 7.7. Reporting transfer from 1C programs version 8.0 is not yet possible. Check the version of the 1C program you have installed.
As a result, in 1C in the window for uploading reporting data, a setting will appear for uploading data to " SBS++Electronic reporting":
Rice. 14-11 - Setting up the upload of reporting data 1C
The installation of the necessary add-ons is performed automatically during the installation of the system" SBS++Electronic reporting" (details in the chapter " Installation and launch"). If necessary, add-ons can be installed in 1C at any time, just use the special command " Add-ons for 1C" ("Main menu / Service") and specify the databases for which you want to install add-ons:
Rice. 14-12 - Installing add-ons for 1C
Location information bases 1C installed on your computer or server is detected automatically.
After installing new forms of regulated reporting in 1C or updating them, you need to reinstall the add-ons for 1C.
Reporting in 1C
In the 1C program, electronic reporting is generated in the following configurations: " 1c accounting", "1C: Taxpayer", "Complex configuration". In all configurations, the principles for generating electronic reporting are the same.
To generate a report:
1. Open the 1C program and execute "Main menu / Reports / Regulated". A window opens " Regulated reports"with a list of reports that can be submitted electronically:
Rice. 14-13 - List of regulated reporting
2. In the list of reports, open the corresponding folder and then select and open (<Enter>) the report you want to create.
3. After that, a window opens with a list of sections that the form of this report contains.
Rice. 14-14 - Tax reporting list
Sequentially open each section and enter the data. A form window with data entry fields appears as soon as you open a section. After the form is completed, save the information.
In the same way, form all the reports that you submit in this tax period in electronic form. After all the reports are generated, proceed to them. uploading to SBiS++.
Transfer of reporting to SBS++
After the necessary reports are generated in 1C, you can proceed to transfer them to " SBS++ Electronic reporting".
In the 1C program in the window " Uploading reporting data"(Fig. 14-11):
1. Select the forms that you want to transfer to SBiS++.
2. Select the period for which the forms are uploaded.
3. Check the box " to the program "SBiS ++ Electronic reporting".
4. Using the " Review" Specify the location of the directory with the SBiS++ program.
5. Returning to the data upload window, click " Download reporting data".
6. Reports are uploaded to electronic reporting files. The process report is displayed in the message window, in 1C.
Rice. 14-15 - Report on uploading reports to files
As soon as the uploading of reports is completed, SBiS++ starts and the loading of reports into SBiS++ begins.
This may result in messages:
| Message |
1. Setting up the BSU 1.0 configuration for the correct unloading of the balance sheet.
For the formation of financial statements of state (municipal) budgetary and autonomous institutions in electronic form in formats, processing is used.
Processing for unloading financial statements "UnloadingReportingFor the Federal Tax Service.epf" you can download , or find in subdirectory " AppData\Roaming\1C\1Cv82\tmplts\1c\StateAccounting\ latest version BGU1.0 configuration \cases\extrp.zip» .
Processing should be added to the program. To do this, go to the menu. Further "Upload log" → "Settings" → "Export formats". In the window that opens, click "Create", and then, in the next window, click "Load from file..." and select the downloaded file.
After that in the window "Upload format (create)" click "Record and Close".
2. Unloading the balance sheet from the BGU1.0 configuration.
Go to menu "Accounting → Regulated reports → Accounting statements". Further " Report log", and click the " Unloading».
In the opened window " Uploading reports» make the following settings:
- Mark the reports prepared for uploading, if necessary, using the filters in the left part of the window
- In the right part of the window, in the paragraph "Exchange Format" select previously loaded processing "UnloadingReportingFor the Federal Tax Service.epf".
- Select "Unloading method" and "Unloading Path"
- In field " Correction number" specify the type of document 0 - primary document 1 before 999 - correction number for the corrective document).
- After that press the button " Upload data»
Attention! As a general rule, reports with the status " Prepared" or " Approved". This status is set for reports that have successfully passed the control of indicator matching.
Upon completion of the download, it will open "Protocol for uploading reports".
- Go to menu " Accounting» → « Regulated reports” and select “ Tax and statistical reporting».
- In the window that opens, click the " Go' and select ' External Electronic Reporting Submissions».
- Click the button Download» and select the desired file.
- Check the correctness of filling in the details of the report, click " burn» and send the report by pressing the button « Sending» - « Send».
