Vivantage from dodo іс in 1 s. Retrieving information from an additional query console

It’s no secret that among office workers, especially those employed in the industrial and financial spheres, Excel and 1C programs are especially popular. Therefore, it is often necessary to exchange data between these two supplements. Alas, it’s a pity that not all wealthy people know how to earn money. Let's understand how to visualize data from a 1C Excel document.

Since the acquisition of data from Excel in 1C is a complex procedure, it can be automated only with the help of third-party solutions, a reverse process, and the acquisition itself from 1C in Excel is a simple set of actions. This can be easily achieved with the help of using the new tools of knowledge programs, and it can be done in a number of ways, depending on what you need to transfer. Let's take a look at what's wrong with specific butts in the 1C version 8.3 .

Method 1: copy instead of copy

One unit of data is available in 1C. They can be transferred to Excel using the basic copy method.

Excel will be inserted instead of 1C.

Method 2: inserting a list into your main Excel workbook

However, this method of fortune-telling is only suitable in cases where it is necessary to transfer data from one middle. If you need to transfer an entire list, you can do it quickly in another way, even copying one element at a time will take longer.

List of document insertions.

Method 3: create a new Excel workbook with a list

The same list of 1C programs can be immediately output to a new Excel file.

The entire list will be preserved in a book.

Method 4: copying the range from the list 1C Excel

There are exceptions if it is necessary to transfer not the entire list, but only a row or range of data. This option can be implemented entirely with the help of purchased tools.

Method 5: Saving documents in Excel format

In Excel, sometimes you need to save not only lists, but documents created in 1C (sheets, invoices, etc.). This is due to the fact that many developers find it easier to edit a document in Excel. In addition, you can view filled-in data in Excel by unzipping the document and using it 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 a matter of fact, the use of information from 1C in the Excel format does not create any problems. It is necessary to know the algorithm of action, because, unfortunately, not all traders are intuitively intelligent. With the help of the installed 1C and Excel tools, you can copy in the middle, lists and ranges from one program to another, and also save lists and documents outside the book. There are a lot of saving options and in order for the buyer to know the one that suits his situation, there is no need to go to third-party software or set up complex combinations diy.

1. Find in the “Accounting” section the “Data acquisition from “1C: Accounting”” tab.

2. The form for data collection has opened – fill in the fields “Organization” and “Period of collection”. Check the required documents.

3. Have all required fields been filled in? Click "Visit data" - the download of the file on your computer in the "xml" format has begun. Save it on your computer.

Now you need to import the file from your “1C: Accounting”. For whom should you follow the current instructions?

Important note

After importing files from 1C, counterparties will be automatically created using the IPN, since they were not created before. The organization must be added independently.

The representatives of “Reasonable Logistics” cannot use your 1C to access the file from “Reasonable Logistics” - they do not interfere with anyone’s access.

Zavantazhennya from "Reasonable Logistics" to "1C: Accounting" of the Russian Federation

1. Opened in 1C: Business Accounting 3.0. On the toolbar, click the arrow and click "Add or remove buttons." Check the box opposite "Parameters".

2. On the same toolbar, click the “Options” button and click “Show all functions”. Save "Ok".

3. Click the trivet at the top right part and select “All functions”.

4. In the form of all functions, open the “Processing” list and start from the list “Universal data exchange in xml format”.

5. You have opened a section for storing documents from Smart Logistics. Go to the "Data acquisition" tab.

6. Select Client Operation Mode from the list.

7. Click on the “Upload data” button and select the required data from the Smart Logistics file in xml format. The file is called simply "Rozvantazhenya File".

Documents created in Smart Logistics are located in the Sales and Purchases sections.

You have stolen documents created in Smart Logistics from your 1C: Accounting.

Zavantazhennya from "Reasonable Logistics" to "1C: Accounting"

1. Find the “Administration” tab in “1C: Business Accounting 3.0”.

2. In the “Service” section, click “Universal data exchange in XML format”.

3. Add the animation file to the “Name of the file for animation on the server” field and click “Enter data”.

4. Once the file has been successfully acquired, a notification about the number of acquired documents will appear at the bottom of the page, for example, “Objects acquired: 19.”

You have stolen the documents created in Reasonable Logistics, up to your “1C: Accounting”.

29.05.2017

How to transfer the 1C information base with all cloud data from the terrible 1C:Fresh service to a local computer

For whatever reason, you needed to copy or transfer the working database with all the cloud data from the terrible 1C:Fresh service to your local computer, it’s even easier to do it!

We would like to remind you that it is necessary to ensure that the 1C configuration release is consistent with 1C:Fresh, for which data is required, the 1C configuration release is required on the local computer, as the data will be required.

At the Nashom’s application, the 1C platform was launched on the local compMeteri: Pidprimani 8.3 (8.3.10.2299) The configuration of the accounting of the Pidprimanism (3.0.50.19), and the Vydpovіdov -bass parameters at the Khmari 1C.

Please note that most of the add-ons that are available in the dark 1C:Fresh service correspond to the PROF versions of boxed deliveries, then. On the local computer you can install the following 1C programs and the PROF version. The only exception is the “1C:Enterprise” add-on, data from the information base that can be accessed on your local computer in basic versions of 1C:Accounting 8 Basic version, 1C:Sproshchenka or 1C:Enterprise.

Then, on the local computer, we launch an empty working database with the appropriate configuration for the release that needs to import the data.

In the “Administration” section, select the “Acquisition of data from the service” item.

From the explorer, select the file that was saved at the recovery stage (data_dump.zip).

You can also specify which list to transfer to your local computer.

If you are interested in the program, it will start in the user mode. If koristuvachs were vivantaged, to enter you will need to select a koristuvach (login without a password).

After this, the restructuring of the base may be launched.

The primary interface of the configuration "1C: Business Accounting" edition 3.0 is desired, in which you can continue to work on your local computer in the same way as you previously worked in the dark.

The external appearance and functioning of the programs are identical, making it impossible to verify the correctness of the acquired data.

How to import data from the data_dump.zip file in other typical configurations of the 1C:Enterprise system

If everything turned out well for you, then we like the article on social media or share it with people on our favorite forums))).

Online company, 2017

How to recover data from the bad service 1C: Fresh to a local computer, Saving the 1C information database from bad to your computer, How to recover the database from the bad service 1C: Fresh to a local computer, Transferring the database Marie 1C: Fresh on local computer, How to recover a database from the 1C service: Fresh to a local computer, How to recover data from the 1C service: Fresh to a local computer, How to recover a 1C information database from 1C Fresh to your computer Yuter, Transferred data from the 1C:Fresh service to a local computer, How to transfer data from the 1C:Fresh service to a local computer, How to transfer the database from the 1C:Fresh service to a local computer, Vivantage of data from the 1C:Fresh service local computer How to transfer all data from the dirty 1C:Fresh service to a local computer How to save the information base from the dirty 1C:Fresh to your computer

Regardless of the fact that 1C is the most popular, manual and reliable information system, which has its own line of solutions for automating and processing absolutely all business processes in the enterprise In assets of any scale and gales of activity, however, investors today face the need to vivantize data z 1C third-party programs have files. In this article, we will look at how to work with 1C and show how to work with 1C and what problems can arise from it.

Data that can be extracted from 1C

1C, any configuration routinely supports the analysis of such data as:

• Drukar forms;
• Call;
• Tables and lists.

Vivantazhennya data from 1C 8.3 Mozhlive in many popular formats:

• Microsoft Excel;
• Microsoft Word;
• Vivantazhennya at CSV;
• HTML and others.

Vivantage of other forms and sounds

Either way, the form or sound in 1C can be saved in the required format. For this you need to open the form or call, then select in the Main menu File - Save the Yak.

After this, the saving window will be opened for the file in which the file name and type are indicated:

Possible problems when dismantling from 1C

This is due to the fact that the form is either designed or not activated at the moment. To make the created form available for saving, you just need to click the bear in any place on it:

Visualization in Excel

Processing data in the most popular tabular format will require extensive processing. To save the required data in the Excel format, it is necessary in the saving dialog to specify the file type Arcush Excel2007-...(*.xlsx). It is now necessary to save data in the old Arkuš Excel format (*.xls):

Similarly, by selecting the required format, you can create visualizations from 1C PDF, 1C WORD, 1C CSV, and also in other formats.

Vivantage of additional tables from 1C

In this section it will be shown how you can extract any money from your mind that you have the right to do.

1C has a built-in mechanism that allows you to visualize any list (for example, a list of documents and document elements). For which there is a list in the command panel, in the group "More" command available "View list":

The information will be displayed in a special tabular document. This document looks like it would be another version of 1C, and it can be visualized just like that by the vikory team File – Save your money:

How to highlight data that is not visible on the list

Most often, the destruction of a certain list is accompanied by the need to add columns there that are in the document (advisor), otherwise they are not visible in the flow list for any reason. Example: in the “Clients” list, add the “Phone” field for display, which is no longer displayed in the add-on panel:

Although the phone can be transferred from 1C, it still needs to be added to the list right away. For what you need, click the command "More - Change the form." Then we will have to find out what we need from the list of columns. There is one trick here: in most cases, developers of typical configurations add a field "Posilannya." Why don't you, and then press the button? We will use all possible fields of this representative. Known field "Telephone" And put a tick in the vikoristanny box.

After this, the client database with telephone numbers can be downloaded from the file through the standard command "Vive list" and sell it to competitors.

1C platforms may introduce functionality for saving Excel data. Make sure that the cost is sufficient for vyvantazheniya, otherwise you can use the Excel.Application Com object. This article will look at different ways to convert data into Excel.

Swedish crossing

Vivantazhennya in 1C v7.7 using standard methods

Saving in Excel 7.7 is possible without forming spreadsheet documents, for example links.

After completing the form, click on the “File\Save” menu:

That's it! Data from 1C Vivantazheni:

Data extraction from 1C v. 8.3 (8.2, 8.1)

It is also prepared from a spreadsheet document, but the platform can output cloud data into a spreadsheet document.

Let's get this out of the way.

In the demo database, open the client agent, and click “Show list...” in the “All activities” menu.

This command allows you to display visible columns.

In basic forms, this command can be selected with the right button from the list.

In the next dialog, select the required columns:

As a result, a tabular document will be generated that is available for saving.

Restore your respect: this is very new, to save a wider list of formats available.

Please also respect:

• The retailer can enable savings from lists in other forms
• Therefore, this typical functionality is expanded by a button, or by a manual click
• You may have the right to “Open” every day, choose the ability to copy to the clipboard or another document, obviously, and save it in Excel, which will not work
• The ability to display lists is also available in the configurator (for example, at the moment you can display the value table)

Visualization in Excel is also available through the BSP functionality (libraries of standard subsystems), which is available in most standard 1C solutions.

For example, in the context of “Inventory balances” in managed trade 11.2:

Saving in Excel using software

Option 1: Click to save a spreadsheet document

A spreadsheet document has a “Write” method, the parameters of which are the FileType of the TabularDocument

Tabular Document = New Tabular Document;

//Setting up the spreadsheet document

Area = Tabular Document. Region ( 1 , 1 , 1 , 1 ) ;

Region. Text = "Heading H1";

//Saving the tabular document

Tabular document. Write (TabularDocumentFileType. XLS, ) ;

Option 2: Select Excel object.

This option is available on Windows, but you must enter this code for the client, if necessary.

Dali, simple code for recording data in Excel(not specially complicated, nothing fancy. Obviously, only the 2nd row is taken up to 1c, deciding on the correct methods and powers of the Excel.Application object, documentation for which is available on the Microsoft website):

Outside file name = "C:\123.xls" ;

BookExcel = New COMObject ("Excel.Application");

Excel book. WorkBooks. Open(OpenIFile) ;

//Welcome to the image

Excel book. Visible = 0;