Dynacom Technologies

Hello,

we're in the process of building an e-commerce site for a client of ours that uses the Enterprise SQL edition. their ultimate goal is to have a consolidated management of both inventories, invoices, orders, etc. I understand Dynacom has import and export functions, but that requires human interaction and the client is looking for full automation. basically my questions is if there's a way for real-time integration (Web Services, SOAP, etc.). any help would be much appreciated.
 

Hi,

there's in nothing builtin to do exactly what you need. Dynacom Accouting has import/export functions that allow you to export and import file in XML format.

You can build your e-commerce site to connect to Dynacom's database to be able to get all items of your inventory. After that your site should create xml files, in the format that Dynacom support, for each invoices and orders. After that, you can configure an automatic task in Dynacom to process all xml files that your site generated.

To see what's the format of xml you need to use, you just need to export a current record and take a look. To be able to export/import, you need to activate this feature (in Dynacom, menu customization / Customization Wizard, choose I want to use advanced customization to customize my application and hit Next, choose Import/Export data and select Yes then hit Next and Finish. Now, open invoice form, fetch an existing record, then press on Options button in the toolbar and then choose Export the current record.

---

Martin Ouellette
Dynacom Technologies, Inc.
www.dynacom.com

thank you for your response.

how do we connect to the Dynacom DB for the items? is there any documentation on the Dynacom DB schema?

There is no documentation on the Dynacom DB schema, but you just need to open the database in SQL Management Studio (if you are using sql database) or in MS Access (for access Database) to take a look. If you are using access database just ask me and I'll send you the password to open database in a private message.

To connect to database you just need to use an ADO connection.

Best regards, 

---

Martin Ouellette
Dynacom Technologies, Inc.
www.dynacom.com

great. may i have the pass? let me know how to proceed with a private message.