Unloading data 1c 7.7 to csv. Uploading printed forms and reports

Quite often, it becomes necessary to unload goods from 1C 7.7 v online store... But it's not enough for us just to unload them, we need to keep the price up to date. If your nomenclature is more than 1000 items, this is a rather laborious task to do it manually. And then the exchange rate is unstable. Below I offer a ready-made solution for unloading and updating the price list of an online store.

In a nutshell, how it works:

It is assumed that the online store will use a two-level structure of the price list. Category and its subcategory. In this case, it does not matter how many levels of the nomenclature you have in 1C.
Once we set up export from 1C.
We open the processing and with one button unload the price list from 1C.
We go to the site and press a couple more buttons to update the price list of the online store.

All tested on Trade + Warehouse 9.2 (7.70.981). Minor changes are made to the main configuration Trade + Warehouse 9.2

CONFIGURATION SETTING 1C

1. Opening Configurator... We create new references with default parameters. Their names:

ImagazineCategory
ImagazineSubcategory

2. In the reference book Nomenclature add new fields:

CategoryIM field type reference. StoreCategory, Advanced tab - use " For groups "
SubcategoryIM field type reference. StoreSubcategory, Advanced tab - use " For groups "

Unload IM field type number, length 1, precision 0
IM field type number, length 1, precision 0

3. Open the directory settings Nomenclatures, we adjust the visual Group shape. We add our new fields to it:

CategoryIM
Subcategory

Next, we adjust the visual Element shape... Let's add new flags for unloading goods. To do this, use the button Requisites... Do not forget to change the type of the added props element to checkbox.

UnloadIM
Publish

4. We save the made changes. This completes the configuration setup. Close the configurator. Note, absolutely nothing complicated.

SETTING UP EXPORT TO CSV

5. Launch 1C Enterprise. Open processing for exporting goods to csv. We begin preliminary preparation. To do this, we need to compare the categories of goods in the online store and your 1C database. Open the category directory and first of all add an entry with code 0 and text ! do not unload... Next, we fill in your list of categories. As you understood, products of category 0 will not be unloaded. Next, we fill in the Subcategory directory.

7. Attention to the table. On the left, it displays information about existing categories in 1C. On the right, their new name is assigned in the online store.

9. There are several ways to assign new categories. Massively or individually. For mass assignment, we use the checkboxes in the first column of the table, the corresponding fields of group 1 and the button " Assign categories "... For the individual assignment of categories, we use a double click in the desired position on the column "Category on the Internet", "Subcategory".

10. After all the correspondences between the Internet and 1C categories have been established, it is necessary to save the settings made. To do this, use the appropriate button " Save Categories".

11. Additional functions in the category setting mode. By double clicking on the "Categories in 1C" column, you can quickly rename the selected category to 1C.

12. Go to the second section of the export settings "Balances and prices". First of all, we select the required company, the date of the price list, the type of prices and the warehouse if necessary, otherwise all warehouses will be processed. We set the necessary filters - checkboxes:

Only with a positive balance
With a set price only

We press the button " Load Products". At the end of the procedure, the total number of items suitable for unloading will be reported. Goods that are not assigned a category or that are in the category! Do not unload are ignored.

13. Now, using the first three columns of the table, checkboxes and 3 buttons in the left corner above the table, you need to configure the parameters for unloading the nomenclature. Namely, whether this position is unloaded or not, whether this product will be immediately published in the online store or it will be hidden by default.

14 Additional functions available in this mode. Having selected one of the positions, you can quickly change the name by double-clicking on the "Nomenclature in 1C" column. Using the "Sub.Reference" button, you can quickly access any subordinate item directory. For example, to change the price.

15. Save the changes made with the button of the second section " Save @ #". Now everything is ready to upload the file with the nomenclature.

16 Let's move on to the third section - Export. It is provided for uploading 2 versions of the csv file, with full information about the item and a truncated version containing only the data necessary to update the price of goods. At the bottom right is the path for uploading the source file.

# 1С Enterprise # Export #InternetShop#CSV # Processing # Price # Configurator# Nomenclature # Price

The free scripts of online stores that we are talking about (see on our website) have almost everything for organizing e-commerce: they are Russified, rich in functionality and free. But, unfortunately, almost all of them are not Russian and cannot download data from the 1C: Trade Management program, popular in Russia.

To download data from the 1C program, there are additional paid modules for scripts. But still it is possible to leave the free script free: you can regular means scripts and 1C to exchange data. In this post, we will tell our readers how you can do it yourself: quickly and for free. download information about goods from 1C to the online store.

To exchange data, we will use the fact that almost all scripts of online stores have a module for loading data in CSV format. CSV is a plain text file, the information in which is delimited by some symbol. This is usually a comma. For example, product information might look like this:

Product, Quantity, Price
Sneakers, 10, 1800
Fan, 150, 350

As you can see, this is actually a table: in each row there is a new product and information about its price and quantity, and the first row is the column headings.

In order to exchange data, we need to prepare such a file with data in CSV format and upload it to the online store.

It remains only to download information about goods from 1C in CSV format. Unfortunately, 1C cannot directly upload data in CSV format. You can write an additional module for 1C (processing) that would upload the data we need in this format, but there is an easier way to do this.

The essence of our easy way in the fact that in 1C you can generate a report on goods, and then save this report in XLS format ( Excel document). Then open this file in Excel and save it again in CSV format. Excel can save data in this format.

Detailed instructions for unloading data from 1C in CSV format:

In the program "1C: Trade Management" generate a report: Cost estimate of the warehouse in the prices of the item. But it is in the menu: Reports -> Inventories.
When the report is generated, save it: File -> Save a Copy.
When saving, specify the format of the saved file " Excel sheet(* .xls) ".
Open the saved file in Excel program.
In Excel, re-save the file: File -> Save As
When saving, specify the format of the saved file: CSV.

To upload the resulting file with data to the online store, you need to find a section in the online store admin panel, which may be called something like this: Import in CSV format. Then select our data file and click the Upload button. After that, you will need to match the column names in your file with the names of the database fields in the online store.

If you understand 1C, you can write an additional report that will give you all necessary information for an online store (not only the balance and the price). You can write a processing that will save data directly to CSV format. In the near future, a lesson on writing such processing will appear on our website.

Despite the fact that 1C is the most popular, convenient and reliable information system, which has in its line a set of solutions for the automation and processing of absolutely all business processes at enterprises of any scale and field of activity, users still need to upload data from 1C to third-party programs or files every day. In this article, we will consider what unloading from 1C is and show how to unload from 1C and what problems may arise in this case.

Data that can be downloaded from 1C

1C of any configuration regularly supports uploading such data as:

Printing forms;
Reports;
Tables and lists.

Unloading 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

Any printed form or report in 1C can be saved in the desired format. To do this, you need to open a form or report, then select in the Main Menu File - Save As.

After that, the window for saving the file will open, in which the name and type of the file are indicated:

Possible problems when unloading from 1C

This is due to the fact that the printable or report is not active at the moment. To make the printable available for saving, you just need to click the mouse anywhere on it:

Export to Excel

Processing data in the most popular tabular format requires an appropriate upload. In order to save the required data in Excel format, you must specify the type Excel2007 -... (*. xlsx) Sheet in the file save dialog. Less often, you need to save the data in the old Excel Sheet (* .xls) format:

Similarly, by choosing the desired format, you can upload from 1C to PDF, from 1C to WORD, from 1C to CSV, as well as to other formats.

Unloading arbitrary tables from 1C

This section will show you how you can upload any data, provided that you have the rights to do so.

1C developed standard mechanism, which allows you to unload any list (for example, a list of documents or directory elements). To do this, in the command panel of any list, in the group "Yet" command available "Display the list":

The information will be displayed in a special spreadsheet document... This document looks just like any other report in 1C, and it can be downloaded in exactly the same way using the command File - Save As:

How to unload data that is not visible in the list

Often, the arisen task of unloading a list is accompanied by the need to add columns there that are definitely in the document (reference), but for some reason they are not visible in the current list. Example: in the "Clients" list, add the "Phone" field for unloading, 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, 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 typical configurations almost always add a field "Link". If you stand on it and then press the button then we will see all the possible fields of this directory. Find the field "Telephone" and put a check mark on its use.

After that, the customer database with phones can be uploaded to a file via the standard command "Display the list" and sell to competitors.