Contact 1C and MySQL?

Pass practice at the enterprise it is necessary to conclude orders and their statuses on the website. All information about orders is stored in 1C. Programmer 1C from the company said he will create a ftp server. To which to throw .xml files. And somehow I'll have to bring this information in MySQL. Well, for a quick throw he will not be the entire DB, but only what has changed( his words). How is it possible without participation in an automatic mode it can be implemented? Maybe there is an easier way ?
Asking him why not connect directly to 1C. He replied( I remember) that 1C is a file database.( something like that). And a direct connection is not safe.
Just say opening Google, I just came across some web services. And did not understand who is supposed to create ?
September 19th 19 at 00:33
5 answers
September 19th 19 at 00:37
Let translate base on skul is dt-hee,normal firewall and directly uploading,fears for safety,put Kerio if finances allow then squid.
A direct connection is unsafe - in the sense nefig to climb in 1сную database directly, without 1C. For will collapse. - joanne_Feene commented on September 19th 19 at 00:40
September 19th 19 at 00:39
Well, write a script that will mess up the old database work for the day on the strength of
*Can import - joanne_Feene commented on September 19th 19 at 00:42
: and to run it must be a man ? Just then, probably will not have the sense of customer notification by email. If once a day. In the backend is not strong. - Eladio36 commented on September 19th 19 at 00:45
of course not just the schedule on the server to run - Michael.Watsica commented on September 19th 19 at 00:48
: how to do it using cron? or are there better ways? - janis_Schneider commented on September 19th 19 at 00:51
: do well with crowns - joanne_Feene commented on September 19th 19 at 00:54
September 19th 19 at 00:35
Well, in this case to parse xml, you can either curl at the address, or there is still some special xml parser is in php dom works (can't remember the name).
That is without adding in MySQL ? Immediately display info about orders from a file?

Are there simply for example the status of fluctuation and the file already will be new. I still do not yet understand. - joanne_Feene commented on September 19th 19 at 00:38
: no you parsite xml and put the results of parsing in MySQL and create a website already from DB - Eladio36 commented on September 19th 19 at 00:41
September 19th 19 at 00:41
I alone seem that much more reasonable to go with the file 1S on MSSQL, and the simple replication, to convey certain fields of the table "customer orders". And then Google "Replication MSSQL > MySQL".

I understand they were going to give you a full file sharing. How many people work in the 1C and how big they have, and how much information there clogged you have not specified. But there is one problem. These exchanges are quite large (we have not compressed xml 700метров weighs on average), if IB is used actively and to parse them long enough and a pain in the ass, a feature even if squeeze them. The data will be well times a day pass, well two at the most. As in they would have a shit-ton of superfluous information.

From here the conclusions I see are:
A - to continue in the same spirit, and your server will be long enough to parse these xmlы and information will be updated rarely
B - force them to switch to MSSQL/PostgreSQL
In What would be their 1C programmer wrote individual exchange, which will upload at least the same txt/xml customer orders with the fields you want.
In the company of about 70 people. Almost the entire document is tied to 1C. Payroll there. All the reports there. In connection with the current situation, the company saves money. A full transition to MSSQL will require the writing of appropriate software, which probably will cost a lot of money ( not a professional do not know ).

B I have just this option. Only he said that first he will throw file completely, and then will throw only what has changed. He is not special in 1C. Ride this or not I do not know.

Let's say 100 customers and each 10 orders. At the start will be approximately the number.
And that is a lot. - joanne_Feene commented on September 19th 19 at 00:44
70 people in the file base?! Something is not believed...
If they work as many as 70 people, at least 100-200 thousand on the appropriate deployment of MSSQL.
What would so many people worked on the FILE!!! database and backups, this is what is necessary to have the disk subsystem?
And Yes, no rewrite is not necessary. - Eladio36 commented on September 19th 19 at 00:47
: no 1C runs only about 30 people. In the database to store information about orders. About the salaries. Everything related to the files lying on the file server.
My job is to do what I said. There let them decide. - Michael.Watsica commented on September 19th 19 at 00:50
September 19th 19 at 00:43
The easiest way is from 1C to write "direct queries" in MySQL database.
Certainly not special in 1C, and is it possible when the file structure ? - joanne_Feene commented on September 19th 19 at 00:46
: of course you can, I just did. You can't write the file 1s, and 1s in MySQL. - Eladio36 commented on September 19th 19 at 00:49
: that is just adding to write an append query in MySQL ? 1C is engaged in just another programmer. How can he explain ? - Michael.Watsica commented on September 19th 19 at 00:52
: Yes, something like that.
How to explain - don't know question creative. - janis_Schneider commented on September 19th 19 at 00:55
: Connection example: https://helpf.pro/faq/view/348.html
If the file is to be able to run a regular job, so in a certain interface you need to run the processor idle, example: https://helpf.pro/faq/view/1302.html - joanne_Feene commented on September 19th 19 at 00:58

Find more questions by tags Web DevelopmentMySQL1C