Upload counterparties from 1s 8.3 to excel. Retrieving Information Using the Query Console
Using accounting programs is a convenient way to process data: for example, you can unload counterparties from 1C and supplement them with expanded information. However, the most popular utility is not simple and often causes problems even for experienced users. Setby specialists will provide all the necessary assistance when working with the program.
How to upload only counterparties from the database to 1C?
For organizations of any size, it is very important to keep data about employees, clients and transactions in order. At the same time, it is not always convenient to work with information of different types in the same programs. To optimize the process, you may need to upload information to another application.
It is most convenient to transfer data in text format. To figure out how to download a list of counterparties from 1C, you need to have minimal experience in using the program. However, the task will become more complicated if, in addition to basic information, private information is required - addresses, telephone numbers, transaction data.
The direct procedure for importing information is carried out in just a few steps. The program itself will tell you how to unload counterparties with addresses from 1C. The user needs to perform the following actions:
open the list of counterparties and display them in the list;
transfer data to a table element;
save the file in the required format.
This procedure will transfer the information to an Excel sheet or another application. It is also possible to download the counterparty's address into 1C from similar programs, however, the variability of the sequence of steps will increase. For such actions, you must adhere to the algorithm contained in the corresponding utility.
Data transfer procedure
Different versions of accounting programs have their own operating nuances. You can download counterparties from 1C 8 in the form of a directory saved in Excel format. This option is convenient for further data processing. The sequence of actions is as follows:
run report;
upload directory details;
save the modified file with the “String” type.
How to unload counterparties in other formats in 1C 8 can only be figured out with a more confident user level. For most commands, console data entry is used, which requires manual coding. In this case, making mistakes can lead to malfunctions of the program.
Difficulties often arise with how to unload contacts of counterparties in 1C and save them for further changes. However, most of the problems are due to the fact that large amounts of information are used for import, which is almost impossible to work with manually. To solve them, console commands are used.
In addition, instructions on how to download counterparty contacts from 1C often contain a description of the use of web sites for compiling data. In this case, there is a high probability that the data will be “eaten” when transmitted through third-party servers. Often, add-ons such as “Uploading and loading data” also refuse to work.
Possible solutions to the problem
When wondering how to unload counterparties with phone numbers and other data from 1C, you need to be prepared for the difficulties that arise when working with the program. Most commands with extended access require administrator rights. The next step is to write functional code.
You can download from 1C: Managing counterparties' trade using the same algorithm that is suitable for other versions of the programs - Accounting or Enterprise. At the same time, the application has a slightly different structure, which is reflected in the arrangement of fields and cells. A universal information grid has been developed for Trade Management.
To carry out the data transfer, it is necessary to upload counterparties to XML in 1C in several stages. They operate using two basic programs and one additional program that transforms data. The operation goes through the following stages:
data conversion in the Upload and Load application;
transferring data to Excel;
using a secondary processor on a copied base.
Most of the information is contained in the cells “Directories of registers and information”. How to unload counterparties from 1C 7 for applications with other add-ons should be discussed separately. The most convenient method was developed for the eighth, most modern version. However, the data can still be displayed directly in code form.
Sequence of actions: how to upload counterparties to XML from 1C
Copying and saving data in a new format is not enough to display it correctly. For advanced processing of information, the Python utility is used, which allows you to organize entities into separate files. With its help, the following columns are formed:
item barcode;
articles;
names and characteristics;
units of nomenclature.
In order to quickly figure out how to upload counterparties into an acceptable format in 1C 7, you need to have practice in writing console programs. The task is simplified by the ability to enter commands in Russian, but without the proper knowledge it will not be possible to work. Errors in the code will lead to crashes.
The same applies to instructions on how to unload counterparties from 1C 8.2. For this version of the program, you can use universal working methods that will allow you to do without the help of advanced access. However, this does not apply to all types of tasks when working with the application.
How to unload counterparties from 1C 8.2 without using console access codes can only be understood by importing a small amount of data. They can be transferred to external systems using the functions included in 1C. This is done by saving the entire data array or directly unloading tables.
How to download information about counterparties from 1C: the easiest ways
Obtaining data of this type is also possible using the program itself, without resorting to advanced access. The first step is to select all the parameters by which you should copy and transfer data. After this you need:
display the list via the context menu;
select text or table display;
save the data in the required format.
Using the same principle, you can understand how to download counterparties with extended data from 1C UNF. However, this simple method will not work for obtaining information from several fields. In this case, the information will need to be saved and compiled via the command line.
You can download a list of contractors with 1C addresses using code only if you have confident knowledge of working in the program. Queries are entered using a unified language. If there are errors in the recording, the application will produce incorrect results.
You can determine how to unload counterparties from 1C: Enterprise in the simplest possible way in accordance with the assigned tasks. The larger the volume of data and the smaller the breakdown into individual arrays, the higher the complexity of the operation. Very often it is impossible to do without the help of programmers.
How to unload 1C: Enterprise counterparties and save in other formats
All operations with directories of this type must be carried out in local copies of files with the xml extension. To save data, you need to go to “Enterprise” mode and perform the following steps:
start processing configuration objects;
specify the path for data transfer;
select the copy start command;
select the extension to save.
Using the same scheme, you can determine how to download from 1C the e-mail of counterparties and other data placed in the original database. Creating a local copy will allow the user, if necessary, to restore the data and edit it on another device. This will require a certain level of access.
It is necessary to figure out how to upload counterparties from 1C to Excel using advanced access functions if the user has to work with a large amount of data. For smaller jobs, the pre-installed functions will suffice. For console input mode, it is advisable to enlist the help of a professional.
Specialists of the Setby company will tell you how to upload counterparties from 1C 8.3 to the final file and carry out the necessary actions. Extensive experience in this field allows us to guarantee fast and high-quality results. For detailed information, contact our operators at the number listed on the website.
Instructions
1C: Enterprise allows you to upload any directory without resorting to writing complex loading/unloading processing, using only built-in tools. First, we need to decide in what format we want to receive the data:
*.mxl – internal 1C tabular data format, suitable for loading into another 1C database;
*.xls – Excel spreadsheets;
*.pdf – electronic document Adobe Reader;
*.html – web page for publication on the Internet;
*.txt – a simple text file, useful for loading into any database.
If the directory is hierarchical, then the list will be uploaded to *.mxl and *.xls formats, preserving the hierarchy and with the ability to collapse/expand groups. In all other formats, the upload will occur in a simple list, listing the elements of the group after its name.
Let's open the directory that we need to download. In our case, this is “Nomenclature”. Operations -> Directories -> Nomenclature. You can download not the entire directory, but only a specific group; to do this, you need to go to this group. For large volumes of data, it makes sense to upload them in groups to different files to speed up the work.
On any line of the list that opens, right-click and select “Display List”. A settings window will appear.
In the settings window, we will leave the checkboxes only for those fields that we need in the final document. In the “Output to...” field, leave the “Tabular document” item (you can also select “Text document”, but a tabular one is more universal). Click the “OK” button.
A common task when creating a new 1C database is to unload directories from another database and add them to a new one.
Let's look at several options on how to do this.
Upload/download using a spreadsheet document
Uploading directories
1) You can use a spreadsheet document, i.e. upload data in xml, xls form.
To do this, you can use the built-in capabilities of 1C.
So, using the example of “accounting 2 platforms 8.2”:
Using batch processing directories and documents, we need to select all columns by type:
Code Name INN KPP
001 Romashka LLC xxx xxx
1) Go to the service - group processing of directories and documents
2) Object type - directories - counterparties
3) In Selection, indicate the required fields
Select
4) In the selection that appears, right-click - display a list, here we can once again select what we need - OK
Next we need to save this - File - Save As - xls
If you are the owner of a smartphone running Android, then you often have problems with the playmarket not working. They will help you solve this problem
You can download using the Report
Go to - Reports - Other - Universal report
Here we also select - Directory - counterparties
1) In "Grouping of rows" remove "Name"
2) In the “Report Columns” field, add the necessary fields - “Generate”
3) Save as xls or xml
Uploading directories to another database
Here we will use the processing "Loading data from a spreadsheet document"
1) Open processing - Select the directory - Open file - indicate the previously uploaded file.
2) Go to settings - Check the required fields
The main thing here is to set the correct column numbering
So, for example, if you have the “name” field in the uploaded document in the 2nd column, then here you should put it in 2.
Those. check the correctness of the columns and redo them in accordance with the uploaded document.
Column numbering - manual numbering
Next, click fill control - correct errors
You should also understand that related directories will not be available for you this way.
Those. For example, counterparty agreements will not work
For complete unloading and loading (into an identical configuration), it will be necessary to use processing, for example:
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 a report to another person by email, 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, list form, 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 inventory 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, 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.