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
Category Archives: Common publications
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
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
Why is it required in 1С to periodically recalculate the registers totals?
We often hear the recommendation that the recalculation of totals should be performed regularly and this operation results in the improvement of performance, but what lies behind this procedure and what problems are solved exactly?
Continue reading Why is it required in 1С to periodically recalculate the registers totals?
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
Translation using the tools of Google translate
Processor example on the managed forms for 1С 8.2 to translate the text using Google translate.
Continue reading Translation using the tools of Google translate
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
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
FormAttributeToValue() and FormDataToValue(). Description and examples of usage.
In the Syntax Assistant it is very sparingly written about the procedure FormDataToValue(), a little more - about FormAttributeToValue(). And there is absolutely no example of use. Let’s try to examine it.
Continue reading FormAttributeToValue() and FormDataToValue(). Description and examples of usage.