News:

Support the VirtueMart project and become a member

Main Menu

Web Service to connect to ERP

Started by simoesdaniel, October 29, 2012, 16:42:57 PM

Previous topic - Next topic

simoesdaniel

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?

bytelord

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
Production: Joomla 2.5.8 | VM 2.0.14 | PHP 5.3.13
Testing     : Joomla 2.5.8 | VM 2.0.16 | PHP 5.3.8
Testing     : Joomla 2.5.8 |    VM 2.1   | PHP 5.3.8

- Don't Forget to mark thread as solved when it is solved!
- Please do not PM with support questions, use the forum!

simoesdaniel

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.

bytelord

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
Production: Joomla 2.5.8 | VM 2.0.14 | PHP 5.3.13
Testing     : Joomla 2.5.8 | VM 2.0.16 | PHP 5.3.8
Testing     : Joomla 2.5.8 |    VM 2.1   | PHP 5.3.8

- Don't Forget to mark thread as solved when it is solved!
- Please do not PM with support questions, use the forum!

simoesdaniel

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?

bytelord

which component you mean? csvi, datamanager?
Production: Joomla 2.5.8 | VM 2.0.14 | PHP 5.3.13
Testing     : Joomla 2.5.8 | VM 2.0.16 | PHP 5.3.8
Testing     : Joomla 2.5.8 |    VM 2.1   | PHP 5.3.8

- Don't Forget to mark thread as solved when it is solved!
- Please do not PM with support questions, use the forum!