Category Archives: Common publications

Example of transformation from the values tree to the values table and back

I want to share with visitors of the site my approach to transform the values table in the values tree and back.
In general, when developing the branch-wise task, it was necessary almost for all the documents to output information as a tree and store it in the table parts of document, as well as in the interactive data processor as a tree.
Continue reading Example of transformation from the values tree to the values table and back

When employee becomes a gadget

Let’s talk about automation. Automation of enterprises, or at least some departments or even some functions. The word by itself is something artificial. It is not seen the life behind it. Sounds nice, but can be interpreted in different ways.

On the first place there is always the question – how will change the role of particular person who will work with created system? Will it be easy or hard to work, will he creatively work with the system or just push the button on command, how will change the requirements for his qualification?
Continue reading When employee becomes a gadget

Security profiles in 1C:Enterprise 8.3

Publications: Security profiles in 1C:Enterprise 8.3
We pay heavy attention to the questions of safety and stability of 1С:Enterprise 8.3 in the service mode. An operation in this mode creates problems which never appeared before, when the solutions of 1С:Enterprise were operated strictly by the awarding authority. If due to the unskilled or consciously harmful configuring the application operation led to the problems, it was only the problem of the person who exploits this application solution.
Continue reading Security profiles in 1C:Enterprise 8.3

Formatted document in 1C

Since version 8.2.11 a new object appeared in the platform – Formatted document.
The formatted document is intended to design the text. It can be made bold, underlined, with increased/decreased font, centered, etc. Also it is possible to add picture. That is, in 1С it is possible now to format the text approximately like in MS Word and other similar programs. This can be convenient when designing various contracts or, for example, when editing email. Thus, we have an opportunity to lead a text document to the form that we desire.
Continue reading Formatted document in 1C

Read data from Excel file through ADO driver

Publications: Read data from Excel file through ADO driver
Conventional methods to work with Excel files (using COM-object “Excel.Application”) satisfy as long as you meet the files with 30 000 lines and a few dozen of columns. The time of execution and processing of such file grows terribly. It is certainly possible to write: “and now you can go to smoke” like some developers do, but this is the wrong approach. You should always try to find more efficient and elegant solution.
So, there is a need to download specific Excel files from the client site to the base of 1С:Enterprise system. The standard method of subsequent read showed that 30 000 lines are downloaded for 12 minutes a little after. After using the method with ADO, the download speed was reduced to 20 seconds.
Continue reading Read data from Excel file through ADO driver

Event handlers when writing the objects. What for and what after what?

It is difficult for the programmer with a little experience on the 1С 8.2 platform to understand: BeforeWrite, OnWrite, AfterWrite, on the server, on the client, in the form module, in the object module, ah-ah-ah-ah-ahhh!!…..
This complex feeling of misunderstanding I had at first too. During learning and a real experience this crib was created whose purpose was “to unscramble everything” in order to have a clear understanding in what case what handler should be used and in what order they are launched when writing the objects.
Continue reading Event handlers when writing the objects. What for and what after what?

Games on the project field

Publications: Games on the project field
PROCEEDINGS: Any software product deployment is a team work. And to achieve a positive result, it is important what kind of relationship system will be in a team. What factors can prevent a precise formulation of project objectives? What kind of management system can be an insurmountable difficulty on the road of successful deployment?
These problems are focused on the speech.
Continue reading Games on the project field