Data transfer consists of two stages:

1st - discharge of data from TIS to XML format file using processing "Processing system.ert.» .

DETAILED INSTRUCTIONS:

1) Open processing " Processing systems.ert."In 1C 7.7 TIS 9.2

Fig.1. The main type of unloading processing.

2) Select the path to the exchange rules (clause 1) to the file " Under_penos_nochnikov_Tis_BP20.xml.».

3) You can immediately specify a file to unload data in XML format in (clause 2).

4) If the documents are unloaded, you must specify the data unloading period in (clause 3).

5) Next, press the button (paragraph 11), a list of data unloading rules will appear. On the left of each rule flag, you can disable or connect the unloaded object. For example, if we are only interested in the reference book counterparties Mark must be included only by the rule Counterparties.

6) If we need to ask any selection for the unloading object (in Figure 1, it Organizations (p.10)).Selectable object, press the button Install PVD (in (p.12), the name of the selected object "Selection of data will appear Organizations» ) only after that you can add a condition for selecting a button. Selection condition (p.5). In (paragraph 6), we put a mark if this selection condition is involved, then select the props on which the selection will be made. (P.8) Sets a logical operation for selection. And in (p. 9) the selection value is set. After the selection condition is set for any rule, in the list Data unloading rules (§ 10) this rule in square brackets will appear [SELECTION].

7) I will give an example to unload the directory counterparties. And so, we need to unload the counterparties only from the "Buyers" groupfig. 2.

Select object Counterpartiesin the list of rules, press the button Install PVD,next, click the button Add a conditionin the selection table, a new empty string fill it: double click in the selection propumer in the column new string (clause 2) Call the selection details selection window (the table of the props of the object by which it is possible to make selection), in the table (clause 1) select the props Parent.

Fig.2 Selection of selection details

The next step is rice. 4 Selecting a logical operator in (clause 1) from the list of operators (clause 2), in our case "B", i.e. Will be selected and unloaded only those elements that are included in the "Buyers" group

Conditions on one rule can be as much as you like, they will all be combined through logical operation "AND".

1) All now press the button UnloadWe are waiting for the unloading of selected objects. At the end, we get a joyful message. five.

Fig. five

1) Go to the second stage - loading in BP 2.0. We open up the standard processing in the "enterprise accounting" - the main menu "Service" \u003d\u003e "Other data exchanges" \u003d\u003e "Universal data exchange in XML format" Fig. 6 (clause 1).

1) in the form that opens. 7 on the field in the field File name for download (clause 2) Specify the file in which unloaded, click the button Download Data (clause 1). Upon completion of the download, a window will appear with the "Download Completed" inscription.

Fig. 7 Typical processing of universal exchange in BP 2.0

That's it.)

I hope this article is useful to someone and help. If anyone is very necessary to refine and under the inepar configurations, please contact comments.

post office: [Email Protected]

Here I will describe the main points when working with the standard component v7plus.dll.. The information is strongly outdated, and it appeared here more for me - so as not to forget when the next time it appears. Describes reading from an XML file to the XML parser tools of almost standard components. An example will serve as a document document file downloaded to a file in Commerceml 2.03 format (from the site on the bitmix).

So, begin. First of all, you need to load the component. Here is a typical code:

If + "v7plus.dll")<> 1 Then if Download (cataloging () + "ExtForms \\" + "v7plus.dll")<> 1 Then if Download (Catalog Programs () + "V7Plus.dll")<> 1 Then a warning ("component V7Plus.dll is not found!"); Return; Ended; Ended; Ended; Analyzer \u003d Create object ("addin.xmlparser");

The analyzer can work with schemes, but I will not consider this moment. Simple linear (well, or almost linear) reading file. Therefore, just create new document:

XML_Document \u003d Analyzer. Cold(); If empty (XML_Document) \u003d 1 Then return to the end; XML_Document. Download (name File);

In a variable File name A string is recorded with the name of the open file. After that, you can read the file, gradually decrypting it.
The XML file consists of nodes and attributes. Each node may contain zero and more attributes and zero and more subsidiaries. Root knot can be obtained directly from the variable XML_Document. For clarity, consider part of the XML file:

<КоммерческаяИнформация ВерсияСхемы=»2.03″ ДатаФормирования=»2014-04-09 14:25″>
<Документ>
<Ид>53006
<Номер>53006
<Дата>2014-04-29
<ХозОперация>Order goods
<Роль>Seller
<Валюта>rub
<Курс>1
<Сумма>300000.00
<Контрагенты>…
<Время>11:52
<Комментарий>Test ...... .BSV
<Товары>
<Товар>
<Ид>ID46.
<Наименование>…
<БазоваяЕдиница Код=»796″ НаименованиеПолное=»Штука» МеждународноеСокращение=»PCE»>pC

Here is a highly abbreviated version of the file, more precisely, its part. The purpose of this article is not to describe the Commerceml format, and show work with the XML file, so I will give only commands. The Commerceml file consists of the root node " Commercial information". We consider it from the document:

Aldocument \u003d XML_Document. Choosezel ("Commercial Information");

Variable value Aldocument There will be a node (OLE-Object). He has subsidiaries and attributes. In one file there may be several documents, so we switched in the cycle:

Sampling \u003d Eldocument. Selected ("Document"); For y \u003d 1 by sample. Number of Number Cycle dock \u003d sampling. Released (th - 1);

Property Number of Number Returns the total number of subsidiaries, and the method Release () Returns the specified child node (the numbering goes from 0).

Knot " room»Does not have attributes or subsidiaries. It has only meaning 00006 ". Similarly " date«, « Hosoperation" and many others. To obtain the node value, the following design is used:

Number \u003d dock. Selected ("Number"). Value; The number reader \u003d number (Dock. Verification). Value);

Here is used method Selected (). Unlike " Selects ()", He returns not a list, but the very first node with specified name. And his property " Value"Returns a string with a value. To convert the value to the desired type, we use the conversion functions. The date will have to be converted by parts (it is stored in XML in the form of the GGs-MM-DD, not supported by the standard function ()). It is possible that when using schemes, the type conversion will be performed automatically - not checked.
For reading attributes, the following method is used:

Okay \u003d product. Selected ("Baseed"). Get the Point("The code");

Here Product - This is a knot " Product". Attribute value, as well as a single subsidiary, can be obtained by the attribute name. Always returns a string, so if necessary, you need to bring the type of value to the desired one. If the node needs to read several attributes, it is better to save the node value in a separate permanent one.
Well, that's all the basic functions required for the full reading of XML files.

Working with 1C XML files: Accounting 7.7

Make a link to this article on your blog:

Solution: unloading / loading documents from / in 1C (7.7) in text file

By downloading and installing our software, you can try it in a demonstration, informational mode. If you want to study our software product - use the version of Trial, which has no restrictions on the terms of use. For work - use the working version. Both versions are in one archive. The working version of the trial version is identical during the agreed period (usually a month).

Description:

Universal processing "Unloading of documents from 1C (7.7) to a text file" allows you to easily and simply unload documents for certain period, with the selection to fill these documents. You can define a list of documents that were registered in the system in the specified period of time and unload them into a text transfer file. You can specify for the selected documents the selection condition for them for them to details and fill them. The transfer file format is the original author's development and is built on the principle of displaying objects in 1C in the text view: what the user sees in the document will be unloaded.

Universal processing "Loading documents in 1C (7.7) from a text file" allows you to easily and simply download documents at the specified period from the generated transfer file. When reading the transfer file and its structure, the portable documents are analyzed and the comparison of their structure with the current configuration occurs. For identical configurations or close configurations 1C, the mapping process does not require a user of significant efforts to configure the compliance of documents. If the configuration of the database and source database differ, the program finds those details that are present in both configurations and compares them. False conformity setting should take on the user.

Processing does not use XML transfer format. When unloading and loading, the details of the reference elements are not transferred, which are filled with documents. Due to this, the transfer file is significantly less XML fileswhich are often used in similar procedures in other handlers. The transfer file is intuitive to the user and can be viewed and edited manually.

Use order: Copy file with archive. Unpack. Copy files from the installation directory (information database files) to the directory of your information base. Upload processing is designed for use in the database, and the download processing is in the database. With this copying, the ExtForms directory will be replenished with multiple files - reports and descriptions. Open a report through the "Service - Additional features": I. OB.Dogging documents. If you remember the configuration of the processing dialog form - upon subsequent opening, the program will restore it automatically. It can be convenient for organizing a simple document exchange between the central office and the peripheral workstation.

Usage: 1 month Introductory (demo mode), with restriction on downloading documents: no more than 1 document of each loaded type in demo mode.

Full use: after acquisition and activation.

Support: technical advice, consulting on the use, correction of detected errors - for free. Improvements, improvements - by request of the client, on a contractual basis.

Product Advantages

The functioning of the processing is very simple. The user does not need to customize several forms to unload documents. He also does not need to worry about the presence of unloading / download rules that are needed for XML document exchange. This complex each user can configure independently without inviting consultancy programmers.

Causes to buy

You save time and money. You can use any program, and unload documents from it to another, also - arbitrary. There is no need to worry about the presence of rules for converting objects - everything works and without them. Do not forget to view the download results and adjust the details of the newly created elements of reference books. By the way - download processing can use additional processing and printed forms that can be run after processing the transfer file. You can write them yourself or entrust these professionals to solve additional tasks simultaneously with downloading documents.

Comparison of versions

Currently, one version of this solution is proposed, consisting of two treatments: unloading and loading.

Legality

Everyone who needs it is necessary to provide a complete set of documents (sent by mail): a license agreement, an account for payment, the act of transfer of rights and invoice. To get - contact e-mail to the developer.

Warranty

If this treatment It does not suit you with its characteristics, you can seek the refund paid for this solution Amounts, sent by e-mail of the color scan of appeal to the branded form of your fare, with printing and signature of the head of the organization. We guarantee the service "Maney Back Guarantee" (Return money on the first requirement of the buyer). We are confident as our products.

Video:

Uploading documents from 1C (7.7) in a text file:

Loading documents in 1C (7.7) from a text file:

Unloading-download of documents in 1C: Trade and warehouse 7.7 from a text file:

Demonstration of the activation process software:

Software cost:

Local * version

• Name: Solution: unloading / loading documents from / in 1C (7.7) in a text file. Local *
• Currency calculations: ruble
• Price for user: 1500

Local * - Means that you acquire a version for use on one computer (for one user) in your organization. To determine the concept of "user", a computer / database / user ratio is used.

Network * version

• The code software Product: Resh012.
• Name: Solution: unloading / loading documents from / in 1C (7.7) in a text file. Network *
• Currency calculations: ruble
• Price for user: 6000
• VAT rate: VAT is not subject to paragraphs.26 paragraph 2 of Article 149 of the Tax Code of the Russian Federation

Network * - Means that you acquire a version for use on multiple computers (for several users) in your organization. Limit the number of licenses: 6. You can request activation for the specified users without additional payment.

Note
Under the term, the copy is understood as an instance of software, ready to use and apply on each computer in accordance with its intention within each information base of the program "1C: Enterprise 7.7". By purchasing separate licenses, you acquire the right to use the software product by various users, on various computers. If you have a few information bases "1C: Enterprise 7.7" in which you would like to use this software product - you must acquire additional licenses for each information base. If you would like to use this software product on multiple computers - you must acquire additional licenses for each computer.
Example 1.
You have one informational base with which several users work (for example, shifting), i.e. Work from one computer - You acquire one license. You can use the file with the activation code for several users of this information base that will use the software product on the same computer.
Example 2.
You have one informational base with which several users work (at the same time, from different computers, in network or terminal mode) - you acquire several licenses. Activation codes will be different for users working on various computers, so you will have to get several files with activation codes (several licenses).

Repeated (free) activation of the software product is not provided. If for some reason you have failed - you can try to use previously obtained activation. If it does not fit (the computer name, user, the directory of the information database changed, the 1C program directory, temporary file directory operating system) - You should re-acquire a license. When buying new licenses, discounts apply to them taking into account the number of previously purchased copies.

You can contact us by email:

Want to buy right now? Online store: SoftKay.ru, or email us with an application!

Legal basis for VAT benefits

Taxpayers have the right to use benefits in accordance with sub. 26 p. 2 art. 149 of the Tax Code of the Russian Federation, only under the observance of the conditions provided for in the Tax Code of the Russian Federation, as well as proper understanding The conceptual apparatus associated with the use of this benefits.

Consider the use of benefits on VAT provided for by sub. 26 p. 2 art. 149 of the Tax Code of the Russian Federation, in terms of implementation on the territory of the Russian Federation the right to use computer programs and databases on the basis of a license agreement.

In accordance with sub. 26 p. 2 art. 149 of the Tax Code of the Russian Federation is not subject to the implementation of VAT implementation of "exclusive rights to inventions, useful models, industrial samples, programs for electronic computing machines, databases, the topology of integrated circuits, the secrets of production (know-how), as well as rights to use the indicated results of intellectual Activities on the basis of a license agreement. "

Implementation of the rights to use programs for computer and databases

According to paragraph 1 of Art. 39 of the Tax Code of the Russian Federation. The sale of goods, works, services for tax purposes is the transfer on a reimbursable basis (in the established Tax Code of the Russian Federation cases at no cost) of ownership of goods, the results of the work provided by the services provided. In paragraph 1 of Art. The 39 Tax Code of the Russian Federation refers to the sale of goods, the results of the work performed, services rendered, but not about the realization of rights. Therefore, it can be concluded that in paragraph 1 of Art. The 39 Tax Code of the Russian Federation does not disclose the content of the concept "Implementation of the rights to use programs for computer and databases". Since the content of the specified concept is not disclosed in other norms of the Tax Code of the Russian Federation, then it is necessary to refer to the norm of paragraph 1 of Art. 11 of the Tax Code of the Russian Federation, according to which, in the absence of the values \u200b\u200bof the NK of the Russian Federation, the values \u200b\u200bof concepts and terms for the establishment of values \u200b\u200bof the respective concepts and terms should be guided by acts of other branches of the legislation of the Russian Federation. Based on paragraph 1 of Art. 11 of the Tax Code of the Russian Federation should apply to the norms of the Civil Code of the Russian Federation.

In accordance with paragraph 1, paragraph 1 of Art. 1235 of the Civil Code of the Russian Federation under the license agreement. One party is the owner of an exclusive right to the result of creative activity (licensor) provides or undertaken to provide another person (license) the right to use such a result in the limits envisaged. According to paragraph 1 of Art. 1286 of the Civil Code of the Russian Federation under the license agreement. One party is the author or other right holder (Licensor) provides or undertaken to provide the other party (Licensee) the right to use such a work in the limits established by the contract.

System interpretation of sub. 26 p. 2 art. 149 of the Tax Code of the Russian Federation, paragraph 1, paragraph 1 of Art. 1235 of the Civil Code of the Russian Federation and paragraph 1 of Art. 1286 of the Civil Code of the Russian Federation makes it possible that under the implementation of the right to use programs for computer and databases it is understood to provide the right to use computer programs and databases on the basis of a license agreement

Providing "Use Rights"

The concept of "providing the right of use" when applying tax breaks on VAT established in sub. 26 p. 2 art. 149 of the Tax Code of the Russian Federation, causes many issues.

According to paragraph 1 of Art. 1236 of the Civil Code of the Russian Federation license agreement may be two species:

• the license agreement for which the Licensee is granted the right to use the result of intellectual activities while maintaining the licensor the right to issue licenses to other persons (simple (non-exclusive license);
• the license agreement in which the Licensee provides the right to use the result of intellectual activity without preserving the licensor the right to issue licenses to other persons (exceptional license).

From the given paragraph 1 of Art. 1236 of the Civil Code of the Russian Federation it follows that the provision of rights of use is reduced to providing a licensing licensee of an exceptional or non-exclusive license in the form of a license agreement. Naturally, such an understanding of the concept of "license" is quite unusual. In our usual understanding under the license, a document itself, issued by an authorized state body, is a permit for the implementation of a person who is issued such a document determined by the type of activity.

At first glance, from paragraph 1 of Art. 1236 of the Civil Code of the Russian Federation, it can be concluded that the concept of "providing the right of use" is identical to the concept of "license". However, this conclusion is erroneous because the license provides a complex object that includes several elements.

Providing use rights is just one of the elements of license provision.

The second element of license provision may be a licensee of the licensee of the corresponding document on paper.

Paper on paper

By agreement of the parties to the license agreement, the licensor may transfer a document on paper on paper with the title "License". This document contains information about the content of the right-handed right, about the method of access to software and other necessary information.

The third element of the license is a way to access software.

Software access methods

The license license license license does not make sense without the availability of software in respect of which the relevant license is provided.

In this regard, you can select the following ways to access the software:

• The Licensor transmits passwords license, ciphers, codes, access keys, etc. By directions through the Internet, transmission on media or other methods.
• The Licensor transmits passwords license, ciphers, codes, access keys, etc. By directions through the Internet network, transmission on media or other methods, as well as a license as a paper document, which contains the necessary relevant information.
• The licensor transmits a licenseer with a license as a paper document in which passwords are specified, ciphers, codes, access keys, etc. and other relevant necessary information.

Note to the three methods above. With the help of appropriate passwords, ciphers, codes, access keys, etc. The licensee gets access to the software on the manufacturer's website or other right holder, which he "downloads" from the specified site and establishes on its computer in accordance with the terms of the license provided.

• The licensor transmits the licensees directly on the software on the respective media.
• The Licensor transmits the licensee directly on the software on the respective media, as well as a license as a paper document, which indicates the necessary relevant information.

There may be other ways to access the software under the license provided. Those. The above list of methods is not exhaustive.

Act of reception

In addition to the license agreement, regulating issues of licensing license license, it is necessary to confirm the moment of direct license. A document confirming the direct provision of the license is an act of acceptance.

Currently, there is a controversy regarding the name and provisions of the content of the specified act. Some experts propose to call the specified act of receiving rights. This name of the act (and, accordingly, understanding the essence of the process) is erroneous, since the rights cannot be transmitted physically the form of their intangible nature. Therefore, for the specified act is an accurate and correct such name as "act of acceptance and transmission" or "Act acceptance and license transmission". The proposed act of the act is true for the case if the licensory transmits the licensee only passwords, ciphers, codes, access keys, etc. in electronic form by shipment via the Internet. The specified act reflects that:

• The licensor gave a licensee with a license indicating its name, quantity, amounts (size) for a license. It is necessary to separately indicate that the amount (size) of the remuneration per license is not subject to VAT on the basis of PP. 26 p. 2 art. 149 of the Tax Code. The terms "sum" and "size" with respect to the term "remuneration" are equivalent, therefore it is possible to use both terms - respectively, the amount of remuneration or the amount of remuneration;
• The license is considered to be provided by the licensor licensee since the signing of this act.

If software instances are transmitted, then the act also indicates the number of copies for each type of software and their carriers (usually CD (DVD) -disci).

Note. If several licenses are provided, then, respectively, listed data specified for each type of licenses.

From version 1C 7.7 Universal loading from XML (as well as any exchange processes) occurs using the built-in "Data Conversion" mechanism. In different versions, various approaches to the organization of metabolic processes are implemented.

Universal processing

With the seventh version of 1C, it is possible to exchange information between databases and platforms using the built-in "data conversion" tool. Its means make it possible to transform information from the base 1c to XML format and transfer it from the seventh version to the eighth, from the "Commodity Management" in the Warehouse and others. For 1C 7, this tool includes the following components:

Configuration base;

External processing:

• V77exp.ert unloading from 1C in XML;

  MD77EXP.ERT unloads to the XML file metadata.

Configuration and processing are available on the official website of 1C for all users (partners) of this company's products. They can also be found on the ITS disk, which is attached to any product 1C when buying.

Approaches to data download in XML format

To transfer information within 1C, versions 2.0 and 3.0 "Data Conversion" are used. Their difference lies in the processing and data conversion approaches.

1.In version 2.0 to transfer data to create rules. They are based on the source base and receiving base metadata, including descriptions of objects of all available types. Rules are entered into a separate document. Reading this file is made with each unloading. If the description of the bases changes, then the rules should be rechecked and updated.

2. Conversion 3.0 "data conversion" was developed for the purpose of separating the exchange processes from the structure of information bases. This became possible thanks to the XML format - Enterprisedata. Now, for each database, the rules for converting its contents to this universal format without the need to create rules for each particular pair "Source-receiver" is anew.

To help configuration installation and debugging data, contact Netburg. We will not just pick up the tools for specific tasks and configure their work, but also save your nerves and time.

Quite often in the work of large enterprises and retail chains there is a need to exchange data between databases. Each programmer and administrator solves this question in different ways. Someone writes unloading-downloads through intermediate files of the tables, someone uses the COM connection mode to connect to the database source. However, in recent times, its 1C-OVOB mechanism called "Universal Data Exchange in XML format" is becoming increasingly popular.

Exterior treatment

In the full interface, you can open processing at service-\u003e other data exchanges-\u003e Universal data exchange in XML format.

Processing form (Fig. 1) contains four bookmarks:

Additional settings;

Delete data.

The interface of each of the bookmarks is highly loaded with elements, and therefore requires separate consideration.

Disload data

In the upper part of the tab, there is a field selection file selection field. For non-standard databases and exchanges, the exchange file will have to create himself.

On the next line Forms are two switches:

1. Unloading to the exchange file (Fig.2);
2. Connecting and unloading data to IB (Fig. 3).

As can be seen from the above figures, depending on the switch differs the appearance of the form. If the sharing file is selected, the user is proposed to select the location of the file where the unloading and the ability to compress it to save space and protect the password.

An option of direct connection to the database supports and file and client-server version. In this case, you will need to register the address of the database, fill in the fields "User" and "Password". Before proceeding with the exchange of data, it is advisable to test the connection.

The tabular part below allows you to configure the selection and other unloading parameters.

For debugging algorithms and correcting errors, you can use the integrated mechanism in the exchange processing. Its activation is made by installing the corresponding flag at the bottom of the form. Pressing the "Debug Setting ..." button calls the window (Fig. 4).

Fig.4.

A distinctive feature of this form is an informative help on the left side of the layout, which describes each of the three possible debug modes. Any EPF format file can be performed as an external processing file with a module.

Pressing the "Finish" button checks the correctness and completeness of the completed data.

Unlike the "unloading", on this tab (Fig. 5) there is no tabular part, but much more flags that allow you to adjust the recording parameters of new and modified objects.

Fig.5

First you need to select a file that will serve as a source of information. This can be done in the input field "File name for download". If the data was unloaded into a password-protected archive, it will be necessary to enter it into the corresponding field.

The corresponding checkboxes allow you to configure:

• Transaction when writing objects (it sometimes accelerates the process);
• Download data in exchange mode (in this case, all platform checks, with the exception of checking when conducting documents, will be ignored when writing);
• Overwriting modified elements;
• Removal Removal Installation for Downloadable Elements;
• Recording new data to register (either one or set);
• Crimping of insignificant characters (gaps and tabs) for string values.

Additional settings

As it is clear from the nameplate name, it contains tools that the use of which allows you to more accurately configure the exchange process. In particular:

1. Includes debug mode;
2. Allows you to use the transaction in the unloading process;
3. Optimizes the exchange between the bases of the 8th version 1C;
4. Unload only those objects that are allowed to use the current user;
5. Enable logging the exchange process between databases.

These and some other functions are included with the appropriate flags on the form (Fig. 6).

Fig.6.

Delete data

This tab is used only by developers in debug mode. Allows you to remove unnecessary objects from the base.

Briefly configure the exchange rules

Using a standard handler greatly simplifies the life of programmers. At the same time, one of the most difficult moments for the one who first encountered the "Universal Data Exchange in XML format" is the question: "Where to take the exchange rules file?".

First of all, for the independent making of the exchange rules, a special configuration is necessary, which is called "data conversion". It has several interesting files that allow you to configure almost any exchange between different bases 1C 7 and 8 versions:

1. ePF - needed to unload the metadata structure for databases 1C 8;
2. ePF - If the configuration 1C 8 is self-written or not standard, it may not be processing "Universal Data Exchange", this file is this processing;
3. eRT file contains code for unloading the structure of metadata of configurations 1C versions 7.7;
4. eRT - Upload-Download data processing file for seven.

By running the appropriate processing, you must unload the metadata structures for the source database and the receiver base. Then in the Configuration "Conversion" it is necessary to make information about the source and receiver configurations in the configuration directory.

Then, the Conversion Guide creates an item containing information on the direction of data exchange. You can configure the exchange rules for it.