Access a database generated by Ciel
aznaud
Posted messages
3
Status
Member
-
NearEarthObject Posted messages 1 Status Member -
NearEarthObject Posted messages 1 Status Member -
Hello,
I am currently in a development internship and I’m asked to connect their data stored on a server via Ciel with their e-commerce site.
After spending several hours on the forums talking about so-called solutions to use the data from the file created by Ciel, I’m asking my own question:
Is it possible and if so, how can I use the data contained in the file created by Ciel "mon_fichier.SgwGc" (Ciel Gestion Commercial réseau 2014) to fill, for example, an ".xls" file and be able to use the data in the simplest possible way by sending the data to an SQL database to do e-commerce?
Or in short: How to access the data from an ".SgwGc" file?
Surely it is possible to create a program capable of sending this data, it would just be necessary to access it.
Thanks in advance, I’m really overwhelmed (I’m in BTS first year...).
I am currently in a development internship and I’m asked to connect their data stored on a server via Ciel with their e-commerce site.
After spending several hours on the forums talking about so-called solutions to use the data from the file created by Ciel, I’m asking my own question:
Is it possible and if so, how can I use the data contained in the file created by Ciel "mon_fichier.SgwGc" (Ciel Gestion Commercial réseau 2014) to fill, for example, an ".xls" file and be able to use the data in the simplest possible way by sending the data to an SQL database to do e-commerce?
Or in short: How to access the data from an ".SgwGc" file?
Surely it is possible to create a program capable of sending this data, it would just be necessary to access it.
Thanks in advance, I’m really overwhelmed (I’m in BTS first year...).
2 answers
-
Apparently Ciel might provide an SDK.
Tomorrow I would call them and share news if anyone is interested, otherwise I would delete this post ;)-
-
Hi,
Yes, actually we should call Ciel, for a partner and reseller, no problem, but it’s more complicated for a regular customer, we need to push.
Then they provide an SDK that offers examples in VB, C++, and C# with a doc a bit vague but which allows you to do some small things, where I’m stuck is that I have to use COM technology and load each article before obtaining the information, but to load it you need the ID and I can’t retrieve them, you have to put them like in the .config file or elsewhere, that’s the last problem I have...
If you find a solution, I won’t say no ;)
-
-
This post is already two years old, but I would like to know if anyone has found a solution to this post; I would like to be able to interact on the basis of from C#, has anyone got a mini tutorial or a hint?
