1c download the nomenclature directory. Unloading items

It will not be found among the uploaded items, its search will be carried out directly in 1C, using an online call.

However, this option should be resorted to only when necessary, for example, when the product directory is very large and changes frequently, so that its constant reloading becomes a difficult task.

This is due to the fact that a direct search for items by barcode in 1C will take much longer than in a pre-loaded directory, since Mobile SMARTS has special optimized algorithms for this task. It is recommended to unload the item at least when using the driver for the first time, and repeat the unloading periodically, as changes accumulate in it and whenever possible.

Starting with version 2.7.1.49, it became possible to smartly partially “upload” the item directory, which allows you to speed up the process of updating the directory.


Unloadable fields

On the bookmark Upload settings there is a list of item fields, the fields to be loaded are marked with a tick. To specify the TSD field into which a particular item field should be uploaded, you need to select this field in the list and click the “Edit field...” button:

By default, the following fields are loaded:

When uploading to TSD, the following TSD Field values ​​are supported:

  • Name
  • vendor code
  • Unit
  • Barcode
  • Description
  • Series
  • Quality
  • Quantity

In 1C 8.3 it is possible to bulk load a list from a spreadsheet document, for example, from an Excel file.

For loading we use external processing Loading Data From TabularDocument.epf for managed forms (8.2 and 8.3), which can be downloaded . It is universal and should be suitable for any configuration written for a managed application.

  • If you are a programmer and want to develop your own download from Excel, detailed instructions By ;
  • An example of loading a price list in 1C Trade Management can be found at.

To start external processing, you need to go to the “File” menu, then “Open” and select this processing from the directory in which it was saved:

Processing Loading data from a spreadsheet document 1C 8.3 (managed forms)

After processing has opened in 1C, you can start working with it. First of all, we need to decide where and what we will download:

I want to give an example in the directory ““. I created a data file in xls format.

Processing can also load files in the following format:

  • any other format from which you can copy data.

This is what it looks like Excel file with source data, which we will upload to the “Nomenclature” directory:

Get 267 video lessons on 1C for free:

I did not write down all the fields in the directory, since this is enough to understand the principle of loading. In addition, this data is enough to start working with these positions.

These positions are not yet in the 1C information database, and we will now upload them there.

Click on the “Open” icon (indicated in the figure as “Select source”) and select the file with the data. You can use simple copying of information. My example file can be downloaded. The data will be loaded into processing automatically. Now let's check if we filled out our data correctly. To do this, click the “Filling Control” button.

As you can see, we have some errors! We will eliminate it. Go to the “Settings” tab:

Before correcting errors, I want to draw your attention to one important detail. The program initially does not know in which field to look for a directory element in case it is already there. So she needs to point it out. I prefer to search by code since it is usually unique. In the “Search field” column in the “Code” line, put a checkmark. Now, if a record with such a code is found, it will be replaced, otherwise it will be created.

Important! If you do not specify a search field, duplicate items may appear. Especially after the second download of a similar file!

Now let’s see why “Unity” is swearing on the field. The fact is that units of measurement in 1C 8.3 are stored in a separate directory, and processing by default looks for this unit by name. But in fact, the word unit is written in the “Full name” field.

Unfortunately, processing can only search by “Name” and “Code” (for the programmer the possibilities are wider). If you pay attention to the pictures above, you will see that I have a code in the “Unit” column. And in processing you need to indicate that the search should be carried out by code. Double-click on the “Communication Condition” column opposite “Units” and change it to “Code”.

Now let’s see what they tell us about “Service” in the list of errors. One more important note. The columns in the file must be located strictly in the same order as the lines of the directory fields. And for us “” is located at the very bottom, and in the file after the “Comment” column.

In order to move the “Item type” line up, there are blue arrows at the top of the form. Using the “Up” arrow, raise the desired line and place it under “Comment”.

Click “Load data”, and this time everything goes without errors:

Video tutorial on loading products into 1C from Excel files:

There are several ways to unload items from 1C. The choice of one of them depends on whether you need to download the entire directory or just some of its elements. Also, you need to take into account the direction of unloading, that is, the configuration with which you are working.

How to unload all items from 1C?
Uploading the entire directory can be carried out either by the built-in functionality of the program or by separately prescribed processing. The second method requires an experienced specialist who can take into account all aspects of the process. Among more simple ways there are the following:
built-in exchange rules;
Excel tables;
"1C: Data Conversion".

Exchange rules will help you unload and load items into 1C 8, provided the configurations are the same. An XML file is used for this. The process is fairly standard for this software. Moreover, this method is the simplest. It does not require manual writing of rules, which means no additional skills are needed.

How to unload the entire product range from 1C: Enterprise to any other configuration is a more complex question. One of the options for solving this is to use data conversion. This special program, intended for writing rules that are not provided by the main configuration.

Another way to download items from 1C 7. 7 is to use Excel tables or any other similar program. This is more complex than using standard rules, but for many it is easier than writing your own.

Unloading item items
It is possible to download items from 1C with prices using universal exchange. It is also possible to create a report with the necessary information and transfer it to an xls file. After this, all that remains is to load the data into the second program. You can also carry out the process by creating a copy and then deleting unnecessary documents from it.

How to download items with a barcode from 1C is an equally important question. This can be done in “Data Conversion”. For this purpose, a rule is prescribed for the information register. It is its use that will allow you to unload such an item of nomenclature. However, if difficulties arise, it is better to contact specialists.

You can also download the characteristics of the 1C: UT 11 nomenclature in “Data Conversion”. Another method is the “UnloadByRule()” procedure. It must be applied in the “Upload” event. You need to be very careful about the properties of the object, which are sometimes not taken into account.

It will also be useful for an accountant to know how to upload a list of items in 1C. For this purpose, group movement is used. You only need to select the necessary data and specify the properties that should be taken into account during the process of transferring information. This processing is located on disk 1C: ITS.

How to upload items from 1C to 1C of a different version or configuration
When transferring information in identical configurations, the entire process follows a standard scenario. However, this sometimes causes confusion among enterprise employees. You can combat this if you understand all the details of the problem.

Uploading items from 1C to Frontol is a mandatory requirement when setting up exchange between programs. There is also the possibility of automatic or semi-automatic synchronization. You can set up such a process in Frontol by marking flag files, thanks to which signals will be sent about the need for loading and unloading.

The question often arises about how to upload items from 1C to Retail. It is quite convenient to perform such an operation using tables. To do this, the information is transferred to Excel and then loaded into the program. This method is not suitable for transferring pictures, so you can use “Conversion”.

For the first transfer option, you need to know how to upload items into Excel in 1C. This is done in several steps. The first will be the list setting, which adds grouping by a specific field. Next, in the “All actions” item, select “Output list”. Then you just need to click the “Save As” button and select the desired format.

Difficulties in the process of transferring the directory
Uploading items into 1C: Retail can be difficult for a user with little experience. Although those who have been working for several years cannot always avoid mistakes. Problems especially often arise with unloading the characteristics of objects. You need to be careful about the registers that cause difficulties.

When asking the question of how to unload items from 1C: UNF, users indicate the transfer of pictures as a problematic issue. It is worth noting that they are stored in a separate directory. It's called "Storage" additional information", and therefore you need to transfer it along with the rest of the data.

It may be impossible to upload items into 1C 7 due to problems with some details. It is also often necessary to simply change the exchange rules. These two reasons are where the program's difficulties lie. Dealing with them is quite simple, so the task will be within the power of any employee. Experts will help you figure out how to unload items from 1C 7. This will make the work much easier and faster.

Programmers will handle issues of uploading directories to 1C
The Setby company has been working with software 1C. That is why uploading a product catalog into 1C of any configuration is a simple and quickly accomplished task for our programmers. We will not only configure all functions, but also consult with employees of your organization.

Questions about how to unload items from 1C 8: Trade are not the only ones that the Setby company deals with. Our website presents a wide range of services provided. It is important that the work is carried out around the clock, so at any time of the day or night you will receive a response to your request.

How to download items from 1C 8.3 or its characteristics, set up data exchange with programs or a bank - tasks are simple for Setbi specialists. Just leave a request for a call on the website, and a response will not be long in coming. We guarantee that the work will be completed to top level and within the specified time frame. And company employees will learn how to download 1C 8 items, since the programmer will explain all the details of the process.

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 display this list in 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, spreadsheet document (for example, which we received in our example) in 1C 8.3 can be uploaded to 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 one 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.

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 advanced users They 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 have 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

A very useful function in edition 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.

mob_info