Uploading or loading information into 1C is one of the most common tasks when working with configurations. This article will help you quickly exchange data between databases with identical 1C configurations.

Data transfer is required in situations where it is necessary to download data to save or create an archive copy of the “Nomenclature” and “Cost Items” directories; documents "Input initial balances", "Cash receipt order", etc. That is, any program objects, including accounting registers, information and savings.

To complete this task, we will need processing - Processing the upload/download of IB 1C8 data.

For example, we need to save the “Counterparties” directory so that in the future, in cases where it turns out to be damaged in a working database or any counterparty was accidentally deleted from it, we can download the full list.

So, we need to load the directory data into a file with the “xml” extension, in other words, make an archive copy of it. For this we need:

• Go to the “Enterprise” mode and open the database from which we will save contractors
• In the 1c database, in the main menu, click “File - Open” and select the downloaded file with processing, the link to which is located above in the article. Let's open it

Select the “Configuration Objects” column and in it put a check mark next to all the objects that we need to unload. In our case, we need to check the box in the “Directories” section next to the “Counterparties” line.

Above, opposite the “Where” input field, click on the “…” button and indicate where the database elements will be uploaded. Note that in addition to selecting the directory, you need to enter the File name (the file extension must be “xml”)

In another column located on the right “Unload if necessary...” you can check the boxes everywhere if we need to load adjacent database elements. If in this column the checkboxes in front of the “Bank Accounts” directory are not checked, later, during loading from the created download, the details of the “Counterparties” directory with the name “Main Bank Account” may be empty, or the corresponding field will indicate “Object not found” . If we leave a checkmark next to this directory, then for the counterparty associated with it, this bank account will also be uploaded to an archived copy.

Now click “Run” and wait until the operation progress reaches 100%

Thus, we have unloaded ALL counterparties in our 1C database. If necessary, you can access them at any time if you need to restore them in the working database or in any other database with a similar configuration.

Now let's move on to loading data from the archived copy of the directory into another or used database:

• Open the database into which the saved infobase elements will be loaded. In our situation, we need a list of counterparties
• Now, just as in the previous case, in the main menu click “File → Open” and select the downloaded file with processing, the link to which is located above in the article
• We indicate the path to the file with the data that will be loaded into the 1C database

Click the “Run” button

We are waiting for the directory to finish loading into the database.

Note that through the processing presented in the article, you can unload and load all infobase objects between the same configurations. If you need to unload all objects of the 1C database, then, accordingly, check the boxes next to all configuration objects: Charts of accounts Documents, Directories, etc.

If it doesn’t work out for you, then our specialist can come and.

Let's set it up. Let's connect. We'll fix it. Let's find error 1c.

It is no secret that among office workers, in particular those employed in the accounting and financial spheres, Excel programs and 1C. Therefore, quite often it is necessary to exchange data between these applications. But, unfortunately, not all users know how to quickly do this. Let's find out how to upload data from 1C to an Excel document.

If loading data from Excel into 1C is a rather complicated procedure, which can only be automated using third party solutions, then the reverse process, namely uploading from 1C to Excel, is a relatively simple set of actions. It can be easily done using the built-in tools of the above programs, and this can be done in several ways, depending on what exactly the user needs to transfer. Let's look at how to do this using specific examples in the 1C version 8.3 .

Method 1: Copy cell contents

One unit of data is contained in cell 1C. It can be transferred to Excel using the usual copy method.

The contents of cell 1C will be inserted into Excel.

Method 2: Paste a list into an existing Excel workbook

But the above method is only suitable if you need to transfer data from one cell. When you need to transfer an entire list, you should use another method, because copying one element at a time will take a lot of time.

The list is inserted into the document.

Method 3: Create a new Excel workbook with a list

Also, the list from the 1C program can be immediately output to a new Excel file.

The entire list will be saved as a separate book.

Method 4: copying a range from a 1C list to Excel

There are times when you need to transfer not the entire list, but only individual rows or a range of data. This option is also quite feasible using built-in tools.

Method 5: Saving documents in Excel format

In Excel, sometimes you need to save not only lists, but also documents created in 1C (invoices, invoices, etc.). This is due to the fact that for many users it is easier to edit a document in Excel. In addition, in Excel you can delete the completed data and, after printing the document, use it, if necessary, as a form for manual filling.

The document will be saved in Excel format. This file can now be opened in this program and further processed in it.

As you can see, uploading information from 1C to Excel format does not present any difficulties. You only need to know the algorithm of actions, since, unfortunately, it is not intuitive for all users. Using the built-in 1C and Excel tools, you can copy the contents of cells, lists and ranges from the first application to the second, as well as save lists and documents in separate books. There are quite a lot of saving options and in order for the user to find the one suitable specifically for his situation, there is no need at all to resort to using a third-party software or use complex combinations of actions.

Many office workers often have to use 1C and Excel programs. They have to export data from one application to another. Today we will look at how to upload from 1C to Excel.

Uploading data from 1C to Excel

Uploading data from 1C to Microsoft Excel- a process consisting of simple actions. To do this, the tools built into these applications are sufficient. There are several ways to export data.

Uploading a large amount of data

IN open document You should right-click and select “List”. After this, all elements will be displayed as plain text. It can be copied and pasted into an MS Excel document, but it is better to open the "File" menu and go to the "Save As" section.

All that remains is to select the file format and save it.

Uploading printed forms of documents

How to insert a list into an Excel workbook

To transfer the list, use the following method:

• Open the desired list in the 1C program. Then you need to right-click on “All actions”, and then “Display list”.

• The list display shell appears. The "Outputs to" field must be set to "Spreadsheet Document".
• Just below you can select the columns that should be moved.

Advice! You should not change anything in this window when you are about to transfer the entire document.

1. After all this, the user will see a list on the screen in the form of a table. You need to select it all and copy it.
2. Then it is created new document in Excel and the data is pasted into it using “CTRL + V”.

Create a new Excel workbook with a list

You don’t have to bother for a long time and immediately output the list from 1C to Excel:

1. We do the same as in the previous method until the list is formed. Then you need to go to the menu, open the “File” section and select “Save As”.

Conclusion

Now you know several ways to upload a table from 1C to Excel. The procedure is quite easy, and absolutely any user can handle it. The main thing is to study our instructions well, choose the appropriate method and strictly follow the instructions. To make it easier, look at the inserted screenshots.

In the last lesson we looked at.

However, the most common example is the exchange between accounting and payroll. These bases are not subordinate to each other and may not even be connected initially.

All we need is to periodically unload from the salary to the accounting department.

Let's consider the process of downloading data from 1C.

Principles of uploading and downloading 1C data

In Accounting, the document Sales of goods and services can have 30 fields. This is accounting, it has its own goals, many fields are devoted to the chart of accounts and subaccounts.

In Trade Management, the same document Sales of goods can have 25. This is operational accounting, it has its own goals. But the accounts from the chart of accounts are not indicated there.

The names of the fields in these two databases may be different. Then how to upload one document from one database, and load another into another database?

To describe how a document must be converted so that it can be loaded from one database into another, there are exchange rules.

They are a file with an XML extension. To create it, there is a special 1C configuration called “Data Conversion”.

For exchange between standard configurations there are standard rules exchange of data that is hardwired into typical settings exchanges (Service/Exchange with xxx) or supplied separately with .

Unload BU-ZP 1C

From the standard configuration Salary and personnel management in typical configuration Accounting departments usually periodically upload information about the results of accruals wages, including for paying taxes.

In order for this to be possible, you must first upload the settings from Accounting to the payroll.

To upload 1C from 1C Accounting to 1C Salary - select the menu item Service/Data Exchange with Salary/Upload Data in Accounting.

When uploading 1C for the first time, do not forget to check the box “Information for uploading 1C to a new information base».

How to upload initial information to Salary - see the next article Uploading 1C.

Unload ZP-BU 1C

After the initial information from the Accounting Department is loaded into the Salary, you can upload accruals from the Salary to the Accounting Department.

In Salary, select the menu Service/Data exchange/Download data into an accounting program.

On the 1C upload settings form, by default, you only need to select the period and path where you want to upload the data file.

The 1C upload format is displayed as a hyperlink - in blue text. You can change it by clicking on the hyperlink and selecting a different accounting configuration.

Unload BU-UT 1C

To upload 1C from Accounting to Trade Management, you need to create exchange settings. This will allow you to do not only one-time 1C uploads, but also set up a full-fledged periodic exchange, as in.

To make settings, select the menu item Service/Data exchange with Trade management/Set up data exchange in Accounting.

Settings are created using a “wizard”.

We will not take the easy route, and will control all the settings ourselves; for this you need to select the Expert operating mode.

Since we are creating a setup from scratch, we will select “Create an exchange setup” (accordingly, you can “continue” if you interrupted the wizard earlier or change if the wizard was completed).

This exchange setup is done in two databases - first in one, then in the other.

Accordingly, we will select “Create using file” if you started making a new one from scratch in Trade Management, and here you need to complete the setup (similarly, if you start in Accounting, you will need to complete it in Trade Management).

The settings for “via file” exchanges are simple and are not shown here in the pictures. But for “direct” COM connections examples here.

Example, if Trade Management is “file” - it is located on disk. .

Example, if Trade Management is located on the 1C server. The name of the server and database is .

The path to the file database, as well as the server and the name of the database on the server, are displayed in the database selection window in 1C.

Here you need to indicate whether you plan to download something from Trade Management. If so, then this is a “two-way” exchange.

We can specify filters for uploaded documents. For example, in terms of organizations.

The next page indicates the period from which the exchange is expected, as well as the list of documents that will be uploaded.

This completes the first part of the setup. Based on its results, 1C creates a settings file. Now you need to go to the Trade Management and continue the setup there, selecting the “Continue using file” option and specifying this file.

After setting up the exchange from both databases, 1C offers to perform an initial upload of 1C directories and compare objects. This is an analogue of the primary unloading of 1C for the further normal functioning of the exchange.

Pay attention to this point, if Trade Management is not an empty database, it has its own directories, especially if they have been maintained for a long time.

If you are not sure about this point:

• Make backups of both databases (especially if the exchange is two-way)
• Ask users not to work in these databases while you are doing the initial unloading of 1C (weekends and evenings :)
• Unload 1C, check that the directories are not duplicated
• If something is wrong, go back to the backup.

Unload UT-Retail 1C

The typical 1C Retail configuration is often used in conjunction with the Trade Management configuration. Typically, UT is used in retail stores, and Retail in the office.

We are looking at an example of setting up the exchange of UT edition 11 with Retail.

Select Administration in the interface, then Data Exchanges, Add/Create Exchange with Retail configuration.

Setting up the exchange is done in two databases - first in one, then in the other.

Accordingly, we will select “Continue” if you started making a new one from scratch in Retail, and here you need to complete the setup (similarly, if you start in Trade Management, you will need to complete it in Retail).

On this tab, you select the method of transferring information between two databases - through a file (share). Skip this page if you want to use another option.

On this tab, you select the method of transferring information between two databases - via a file (FTP). Skip this page if you want to use another option.

Final settings page. To specify clarifications, click the “Configure restrictions” button.

Here you can specify the date from which documents will be uploaded, as well as selections (filters) by organizations, warehouses, etc.

On the correspondence tab, you can configure the correspondence of some directories (stores = departments and cash desks).

This completes the first stage of setup. As a result, a settings file was created. You need to complete the setup in the Retail database by specifying Continue using the file.

The 1C program is certainly unique and necessary program for every accountant. Thanks to it, running any business will be more efficient and productive. This program helps automate financial, management, business and accounting activities. However, despite this, sometimes situations arise when it is necessary to display or download data from 1C. We offer you two ways.

Upload data from 1C: methods

First way

With 1C 7.7, you can download data by moving it from one computer to another. To do this, you need to open the 1C platform itself. Once the program has successfully opened and loaded, select the database you need, and then click on the “Configurator” option. A menu will appear on the desktop where you need to select “Open configuration”. After some time, a red window will appear on the desktop, which is called “Configuration”, where a very large and complex structure of all elements will be provided.

Now you need to go directly to uploading a copy of the database to another Personal Computer. On the second computer you also need to launch the 1C program and select the “Save configuration to file” section in the menu. After this, you need to transfer the necessary file to any location on the second computer. It is from this file that the necessary database will be made in the future.

The next step is adding the required database. If the 1C program is loaded for the first time on a second computer, then the computer will do everything automatically, without your intervention. When you open 1C, a small window will appear with the following message: “There is no configuration in the list. Add?”, in response to this message, you must click the “Yes” button.

At the final stage, you should put in very little effort to obtain the necessary database. At this stage, select “Create a new infobase”, and indicate that this database has no configuration. Next, you need to select a specially prepared directory for your database and click “Configurator”. After this, the familiar red window will appear on the computer monitor, in which various schematic configurations will be presented. Then you just need to download a copy of the database. To do this, select the file that contains the copy and click “Load infobase”. After that, update the downloaded database configuration and get started.

Second way

Some of you are still wondering how to download data from 1C? So, the second method is much simpler and faster than the first. Now you can upload data to some storage device. In order to download the necessary data from 1C, you need to go to the program menu and perform the following actions: following the strict sequence, select “Service”, then “Data Exchange” and finally “Download Data”. After the work has been done, indicate the path to download the necessary data. Then, after you have indicated the path, confirm your actions - click the “Upload” button. By strictly observing this scheme and following it, you will always copy the necessary data to another computer or media on time.