VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: simoesdaniel on October 29, 2012, 16:42:57 PM

Title: Web Service to connect to ERP
Post by: simoesdaniel on October 29, 2012, 16:42:57 PM
Hey guys,

I'm a new member of this forum as at developing in virtuemart plataform. So, the issue is this.

In my job i need to integrate some data from an ERP sql server database based, to my mysql database. I have been trying to reach some info about, how to create web services, and i found this:

http://virtuemart-datamanager.com/index.php

but when i install the free component, i get php errors every where i access,

So my question is:

How do i create a web service to integrate sql server database data to my mysql and virtuemart data?
Title: Re: Web Service to connect to ERP
Post by: bytelord on October 29, 2012, 16:51:40 PM
Hello,

You could ask the vendor of that extension also. Also forgot to mention your joomla, vm and php versions.

Take a look on that extension also: http://forum.virtuemart.net/index.php?topic=109287.0

Regards
Title: Re: Web Service to connect to ERP
Post by: simoesdaniel on October 29, 2012, 18:15:04 PM
Thank you for the tip, but i am trying to do it without any costs. My joomla version is 2.5.7 and virtuemart is 2.0.12f, php 5.4.

I found another doubt just a few hours ago. If i develop a service in native php, can i use it in virtuemart? I really hope that this way to create the service is possible.
Title: Re: Web Service to connect to ERP
Post by: bytelord on October 29, 2012, 18:55:27 PM
I think you should try a little bit more with http://virtuemart-datamanager.com/index.php
Basically is the webservices of vm, produces xml files if not mistaken every x time and sync with the erp db.
btw, take a look in csv improved also which is exporting/importing data to vm, you can automate it's process to export your data into an xml every 5 hours for example, after that configure your ERP to pull that changes from your xml and update it's database.

Regards
Title: Re: Web Service to connect to ERP
Post by: simoesdaniel on October 29, 2012, 19:17:30 PM
bytelord, tell me one thing that i haven't understand yet. This component, gives me the possibility to call for my service, or provide me a service that i have to configure to access my ERP?
Title: Re: Web Service to connect to ERP
Post by: bytelord on October 29, 2012, 19:51:31 PM
which component you mean? csvi, datamanager?