Processing of external data in 1s. Accounting info. Writing the command handler code

Attention!
All processing from ITS disks are intended for informational purposes and exclusively for registered ITS users.

Selection and processing of objects. (Universal)

Searches for objects in documents and directories that meet certain conditions. Processes search results.

Folding the infobase. (Universal)

Rolls up IB of typical configurations:

SCP 3.1.
BP 1.6.
UT 10.3.

Registration of changes for exchange. (Universal)

Edits, in managed application mode, the registration of changes to exchange objects. Allows you to change the current registration on various nodes. Changes the numbers of received and sent messages.

Convert user activity log. (Universal)

Converts a user activity log to a built-in program.

Full-text data search. (Universal)

Indexing and searching in data.

Finding and replacing values. (Universal)

Searches for and replaces reference values in IB objects.

Setting up a technological log. (Universal)

Creates or edits a technology log file. Has the ability to configure the creation of a dump of an abnormal termination, configure conditions and events, upon the occurrence of which, information will be written to this log.

Quest Console. (Universal)

Monitors background and scheduled jobs. Deletes, creates new ones.

Conversion of external treatments. (Universal)

Change of confidential information. (Universal)

Selective change or clearing of information security from certain information.

Group change of details. (Universal)

Changes requisites and tabular sections in documents and reference books.

Unloading and loading users. (Universal)

Unloads and loads IB users into an XML file.

Uploading data to external databases. (Universal)

Uploads data structures to external DBMS using ADO in two modes:

Unload All
Upload changes (used to synchronize changes in the working IS, with the IS - the receiver). This mode uses exchange plan mechanisms.

Supports the following DBMS:

Microsoft SQL
IBM DB2
Oracle
PostgreSQL
MySQL

Unloading and loading XML data. (Universal)

Unloads and loads data into IB, both in whole and in part. It is used to transfer data between configurations with similar object composition.

Loading data from a spreadsheet document. (Universal)

It loads data into directories and tabular sections from tabular documents.

Runs in a thick client as a regular application.

Query console. (Universal)

Provides tremendous assistance in reporting and creating queries.

In short: 1C processing expands the configuration functionality and allows you to quickly perform certain operations in the program. This not only saves time, but sometimes prevents you from making mistakes. If you want to know more about processing - read to the end.

Read also the article about connecting external processors and reports that extend the standard configuration functionality.

1C processing - what is it?

In fact, everything is simple. The configuration includes not only directories, registers, documents and various types of reports, but also special "add-ons" that allow you to perform other actions on the data stored in your database. These additional parts of the program allow to process information available in the database in a certain way, and it is customary to call processing.

Another example of very useful processing is the bulk registration of invoices for advance payment.

site_

Other processing examples as well summary of this article, you can watch the video below. If something is not clear - just open your 1C database and in the "All functions" menu, find the "Processing" section, then you yourself can see what is hidden in your configuration.

Video review about processing in 1C: Accounting

A small informational video about what 1C Accounting processing is and why they are needed. Processing makes it easier to work in the program, helps to identify errors, and speed up data entry.

Let's sum up

So, in the 1C Enterprise program there are special subroutines, that is, modules that allow you to process data in the database. Therefore, they are called so - processing.

Use built-in and external processing to speed up your work in 1C, but be careful!

+ to the question about questions about ...

In general, it has nothing to do with the topic of this article, but I just can't resist.

The funny is sometimes found in the requests of visitors to my site. Of course, Yandex and Google have not seen this, but today I was especially pleased with one request. I was not even lazy and drew a picture corresponding to him. Pay attention to the underlined in red.

site_

Ask correct questions, if you want to get a correct and comprehensive answer!

In 1C there are many configuration objects that are somehow related to accounting - that is, they allow it to be kept - reference books, documents, registers, and so on. However, what to do when you need to create a program in the 1C language, which is in no way related to accounting, but is required for the office needs of the programmer or to facilitate the user's work?

A great example is batch processing of documents. This is a tool that allows you to post / change / print not one document, but many at once, according to the selected list. Agree - it's very convenient.

To implement tools in 1C to facilitate the work of a user or administrator of the 1C database, there is a special configuration object - 1C processing. 1C processing can be part of the configuration or distributed as separate files (then processing is called external 1C processing).

1C processing allows you to develop your own tools both for programming 1C and for setting up or managing 1C. Thanks to this, there are hundreds of standard treatments on the Internet (developed by 1C) and thousands of amateur treatments on the Internet.

It's time to try to do 1C processing yourself. Details below.

What are 1C processing and how are they used

Small introduction. Those who are already familiar with 1C treatments can skip this point.

So, processing is a tool written by a programmer. She does not know how to do anything on her own and does not save data to the 1C database, unlike, for example, a document - which is saved to the database and can independently record and conduct, without additional programming. 1C processing functions are entirely dependent on the programmer who wrote it.

According to the processing functionality, 1C can be divided into three types:

Auxiliary processing 1C configuration
Each typical configuration has a variety of treatments. They are used as additional interface forms (user desktop, configuration overview), as part of the configuration functionality (entering initial residues, initial filling of the database, closing of the month).
Objects (Classes)
Anyone who knows other programming languages is already familiar with the concept of an object. This is a class that has a set of "variables" and "functions" at its disposal. Its charm lies in self-sufficiency - that is, everything that is needed to perform its functions is collected in one class.
In 1C, classes can be created using 1C processing: "variables" are the details of 1C processing, "functions" are functions in the 1C processing object module (the Export mark for public functions). Convenience lies both in creating an instance of such a class and in moving it between configurations.

A good example is the processing of 1C printing (additional printing forms), which you can find in typical configurations in the Additional printing forms directory. They always have a public Print () function and standardized usage.

Note that, of course, such "classes" are not directly related to data - they must be passed or read in the "constructor".
Additional user and admin tools
There are many generic tools for use, typically by the database administrator, that are not tied to a specific configuration. Such tools are often not included in the standard configuration delivery and are distributed separately (usually on ITS disks). In addition to the standard ones, programmers post a lot of their own tools on the Internet.
An example is: 1C processing of work with retail equipment, 1C task console (displays a list of scheduled tasks), 1C query console (allows you to execute any requests without programming), etc.

Where are the 1C processing

So, there are 1C processing built into the configuration and external 1C processing.

Built-in 1C processing is used by the programmer developing the configuration, situationally - that is, they can either be displayed in the user menu (part in the Service menu), or opened programmatically from other 1C objects (for example, from the directory form).

One way or another, under administrator rights, you can open the list of processings built into the configurations and any of them, if it is possible to open it (that is, if it has a screen form and the programmer has not set a lock for opening). To do this, in the thick client, use the Operations / Processings menu, in thin client use the menu All functions / Processing. If you do not know how to find these menus -.

In the configurator, the 1C processing built into the configuration is located in the Processing branch.

External 1C processing can be opened both in the Configurator and in the Enterprise using the File / Open menu.

Security. Pay attention to . The 1C processing object module is executed automatically when you open 1C processing in the Enterprise mode. Therefore, if you open processing written by an attacker, it can be performed automatically without any questions.

How to do 1C processing yourself

So, let's get down to the most interesting thing - the algorithm for creating 1C processing on our own from scratch.

Download universal object processing 1C 8.3.

In the usual application of the version of the platform 1C 8.2 and 8.1 (on regular forms), there was such wonderful processing as "Universal selection and processing of objects." It made life much easier for programmers and program administrators.

There is the same 1C processing for a managed application (8.3 and 8.2). Prior to that, in 1C 8.3, it was necessary to manage a typical processing of a group change of details, but it does not solve all the tasks that are required in the daily work of a user or a 1C programmer.

Search and selection of objects

After downloading the processing, we can run it as an external one. Who does not know, this is done through the menu "File" - "Open". A processing window will appear:

On the first tab, we must select the object with which we are going to work. And so, in the field "Search object" the document "Implementation (acts, invoices)" is already selected. This is because they have already chosen this object... Processing knows how to memorize.

By clicking on the "Customize selection" button, we can set the selection for almost any field of the object:

If the selection data is not enough, you can select the necessary objects using an arbitrary query. To do this, turn the selector mode switch to the appropriate position.

After all the settings, the objects must be selected. Click on the "Find objects" button and look at the selection result:

Processing elements

Let's go to the "Processing" tab:

A separate brief overview only the first three treatments are worthy, perhaps. The work of the others is clear by the name and they do not require any settings.

Arbitrary algorithm

Processing "Arbitrary algorithm" allows you to write a program of actions on objects in the internal language of 1C. Processing requires programming skills and its description is worthy of a separate article. With its help, you can do practical actions on objects:

Setting requisites

Processing "Setting details" allows you to change the details of the selected documents or reference books, as well as information registers. Quite useful, and sometimes just necessary processing. For example, let's replace the document currency in the selected documents:

It should be noted right away that processing can be performed immediately, or you can save the setting. This setting will be displayed in the processing tree.

Renumbering objects

Processing "Renumbering objects" accordingly allows you to renumber documents, or change the codes of directories. Processing provides a rich set of actions. For example, you decided to change the prefix of the documents that you selected: