⬆️ ⬇️

1C 7.7: Organization of auto-exchange via FTP

In this article, we will discuss the organization of 1C: Enterprise 7.7 auto-exchange using URBD (distributed database management) via an FTP server. To make the task more concrete, let us assume that we have a central office and several remote branches (outlets) that will exchange information with the central office through auto-exchange and distributed databases.



We will not dwell on the configuration of a distributed IB, assuming that you have already done this more than once. Our task is to reduce the “user component” of auto-exchange to a minimum, i.e. - to ensure that the user runs a single shortcut for auto-exchange, after the launch of which the information from the central database would fall into the periphery and vice versa. To organize all of the above, we will need an FTP server, as well as Internet access at all outlets. Suppose we have the following configuration of a distributed database (screenshot from the central information security):



image



At the same time, in the settings of the auto-exchange parameters, the mode is set to automatic, the upload directory is C: \ DB \ CP , the download directory is C: \ DB \ PC (where C: \ DB is actually the path to the central database), and the file names of the upload and downloads for the specified peripheral IB have the following meanings:

')

Peripheral information securityDownload DirectoryDownload DirectoryUpload File NameDownload File Name
MG1 (Rostov)C: \ DB \ CPC: \ DB \ PCMG1C.zipMG1D.zip
MG2 (Novosibirsk)C: \ DB \ CPC: \ DB \ PCMG2C.zipMG2D.zip
MG3 (Kaluga)C: \ DB \ CPC: \ DB \ PCMG3C.zipMG3D.zip








ps The article was first published on my website and blog, now decided to use it to get an invite to Habr. I hope someone it will be useful.

pps If the path to the folder with the database contains spaces (for example, spaces are contained in the name of one of the folders), then for bat to work correctly, when calling ncftpget and ncftput% CP_Folder% and% PC_Folder%, you must enclose in quotes. If the path to the folder is implied, then we take in quotes "% CP_Folder%", if the full path to the file, then the whole path is entirely, i.e. "% CP_Folder% \ MG1C.zip".

Source: https://habr.com/ru/post/184336/



All Articles