[Vtigercrm-developers] how to import & synchronize product inventory data

[Byambaa Mendbayar]

Dear John Crisp,

Thank you very much for your kind response. 

I have been reading vtlib document, and also experimenting 'import'
function from product inventory module for getting mandatory fields list
of product & product related tables.

Is there anyone who had been meet familiar for my current research &
problem? If there any one please, help to me!

Is there ready list of mandatory fields of 'vtiger_products' table? I
mean I have try to direct import products data from my fin/system DB to
vTiger DB via SQL DML programming.


With regards,
B.Mendbayar


On Thu, 2010-10-28 at 11:48 +0200, John Crisp wrote:
> On 28/10/10 06:20, Byambaa Mendbayar wrote:
> 
> >
> > Is there anybody help to me, for synchronize vTiger Products related
> > tables data with my existing financial system Products data?
> >
> > By the way just I have reading vtlib development guide for customizing
> > vTiger, but actually I do not want to write any new module for vTiger
> > CRM and really want to synchronize my financial system DB products set
> > to vTiger product inventory ('vtiger_products',
> > 'vtiger_product_category' and etc...).
> >
> > What is the simple and optimal way for that, please advice to me!
> >
> 
> I'm not sure if there is a 'simple' way to do what you want to do.
> 
> As a starter you could have a look at web services - vtwsclib. That may 
> work in conjunction with vtlib. Also have a look at the vTiger API to 
> familiarize yourself with the system.
> 
> Beyond that you will need to write a lot of code yourself.
> 
> HTH
> 
> B. Rgds
> John