Instruction to execute the scheduled operations at the DBMS level.
Information can be applied for the client-server variant of 1С:Enterprise 8 when using DBMS MS SQL Server.
Continue reading Scheduled operations at the DBMS level for MS SQL Server
Category Archives: Common publications
Universal search and replacement of duplicate catalog items
This is a modified standard processor “Search and replacement of duplicate catalog items” with ability to work in the managed application.
Data processor have an open source code.
The developer is not responsible for and loss and/or damage (including deficiency of commercial profit, interruption of commercial or industrial activities, loss of any (including business) information and another property damage) which appears due to the use or inability to use of processor, even if the Developer was informed about the possibility of such loss and/or damage. The user assume all the risks related to the use or the quality of Processor functioning.
Continue reading Universal search and replacement of duplicate catalog items
Creation of simple mobile application in 1C for Android
1С released a new platform 8.3.2 whose feature is an ability to develop the configuration for the mobile platforms. The bottom line is that after all manipulations we receive the finished packages .apk (for Android) and .zip (for iOS) that can be installed on the mobile devices. This file you can place on Google Play or AppStore and it can be downloaded those who need this mobile application.
The basic idea is that the 1С programmer can do this and completely control the development. In this case, there is no need of knowledge in the field of mobile application development (for example, java)!
Continue reading Creation of simple mobile application in 1C for Android
Catalog with picture (manageable forms)
Since 1C platform release 8.2 the work with pictures is performed with different from the previous platforms method to deal with which without examples is difficult.
The picture as before is stored in the base in attribute with type ValueStorage, but it is impossible to write data in the attribute with this type in normal way, the writing is performed in predefined procedure «BeforeWriteAtServer».
Continue reading Catalog with picture (manageable forms)
Simple Twitter-client for 1C 8.3
Example of work from 1С with Twitter API 1.1, OAuth 1.0a, HMAC-SHA1
The purpose of publication - to show how is it possible to pass the problems created for us by OAuth 1.0
This is not a complete library of functions to work with Twitter, but just an example, a couple of functions. For service functions javascript is used with help of COM-calls to MSScriptControl.
Continue reading Simple Twitter-client for 1C 8.3
Managed application: correct software form open
The publication covers all the possible (or almost all) options of programmed form open in the manageable application. The appearance of publication is related to the fact that 1С help and yellow books are very reticent on this topic. Often the simple tasks (for example, creation of catalog item based on) cause the difficulties even for the most experienced 1С developers who worked few with manageable application.
Continue reading Managed application: correct software form open
Query builder in 1C:Enterprise 8
One of the most powerful tools of 1С:Enterprise 8, beyond a doubt, is a query builder. The builder is a visual tool to work with queries using which it is possible to build a query of any complexity.
Perhaps, in no one IDE I’ve seen such a convenient tool for rapid query development.
Continue reading Query builder in 1C:Enterprise 8
Accounting deployment and maintenance principles for ERP-system based on 1С
Considerations on the technique of accounting deployment and maintenance based on the 1С systems in the form of short principles, explanations and illustrations for them in the form of examples and conclusions. Refers mainly to the business accounting, however, applies to any industry and, as it seems to me, not necessarily to 1С. The purpose of writing this article was to present the practically available information, rather than to fill up the theory, in spite of the resulting volume. The article is intended for the deployment specialists, contains, in addition to the technical information, the accounting and taxes.
Continue reading Accounting deployment and maintenance principles for ERP-system based on 1С
How to remove the passwords of 1C users if the base is on the SQL Server
There are the cases when the access to SQL Server us available, but the password of 1С user with full rights is lost, in this case, it is possible to remove the password using the method described below, so, here is goes.
Continue reading How to remove the passwords of 1C users if the base is on the SQL Server
On the brink of failure
It’s no secret that quite a lot of project on the deployment of software products end in failure. The secret is what are the reasons of this failure. Which firm, the head of programmer will publicly own to it? This publication is not intended to be a comprehensive analysis and is based only on the personal experience of author. And since I had to act both from the Customer side and Executor side, I hope to avoid a one-sided assessment of the events.
Continue reading On the brink of failure