D
D
Denis Solovyov2016-01-12 12:31:42
SQL
Denis Solovyov, 2016-01-12 12:31:42

How to implement automatic data upload from 1C?

There are 20 enterprises in the holding. Each enterprise works in 1C (18 companies for 8.3, 2 companies for 8.2) in a configuration that has been modified independently. Bases 1C are located on servers with terminal access. The file system 1C (not SQL) is used.
The holding company is required to:
1) receive up-to-date data on cash balances;
2) receive data on accounts payable and receivable by counterparties for each company.
How to implement the actual receipt of information?

Answer the question

In order to leave comments, you need to log in

4 answer(s)
D
Dmitry Kinash, 2019-06-17
@DeeDenn

And on the file base you can make a web service!
First you need to collect the requirements for the exchange - what data will be exchanged now, what is possible in the near future. Based on the results, you need to describe the structure of the transmitted data in XML or JSON format.
Now you can create a web service. It can be created in the database of the management company and then 20 enterprises upload their data through this web service (by a scheduled task or some financier checks / corrects the sent data and explicitly presses the button in the upload processing). Or you can create web services in all 20 databases, and the management company, in a convenient mode, polls other databases for new information.
If there is no direct connection, then files in the described format can be saved to a special network drive, and from there a special person will already pick them up and upload them for processing to the database of the management company.
PS The option with COM connection is not recommended as unstable and slow. I do not recommend the option to work through system buses (unless, of course, they are available - otherwise, another song) as redundant and requiring a dedicated engineer for maintenance.

Y
Yuri Goncharuk, 2016-01-12
@yukon39

To get started, look at "1C: Holding Management 8". There is a custom integration with peripheral accounting databases.
Or a question about how to technically issue information "up"?

A
Andrey Shishkin, 2016-01-12
@compiler

Go to the French, they write to you.

I
igruschkafox, 2016-01-15
@igruschkafox

Two options
1. direct query to the database
2. COM connection

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question