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

[Byambaa Mendbayar]

Dear David and vTiger developers,

Thank you very much. 

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!

With regards,
B.Mendbayar  


On Tue, 2010-10-26 at 21:27 -0400, David V. wrote:
> Keeping two databases in sync is usualy not an easy task.
> 
> It depends on many differents details.
> 
> I'm not sure I can really help you on this.
> 
> Maybe someone else on this list.
> 
> David V.
> 
> 
> 2010/10/26 Byambaa Mendbayar <mendbayar_b at e-map.mn>
>         Dear David,
>         
>         Also, just I have investigate Vtiger Database structure. I had
>         been
>         using product export feature and compare the output .csv file
>         for Vtiger
>         Database's `vtiger_products` table structure. (Please, find
>         this
>         comparison result from attachment.)
>         
>         I didn't found the .csv file's some fields origin from the
>         Vtiger
>         database. (It was highlighted in gray colored in the title
>         row, "Product
>         Active", "Created Time", "Modified Time", "Description")
>         
>         Can you tell to me where is the those fields original data was
>         kept in
>         the database's which table and which fields!
>         
>         Also, what do you think which is better way for 'import &
>         sync':
>                1. develop custom app based on mostly SQL DML level or
>                2. develop custom app based on Vtiger PHP programming
>         level
>         Actually I have more experienced in SQL database programming
>         than the
>         PHP, but do not consider it for your advise.
>         
>         With best regards,
>         B.Mendbayar
>         
>         
>         On Mon, 2010-10-25 at 07:58 -0400, David V. wrote:
>         
>         
>         > Do you want to import once ? Or import and keep in sync in
>         the
>         > future ?
>         >
>         > If you just want to import it's easy :
>         >
>         > You export from your other system as a csv file and then
>         import in
>         > Vtiger using the import feature in the Product module.
>         >
>         > David V.
>         >
>         >
>         > 2010/10/25 Byambaa Mendbayar <mendbayar_b at e-map.mn>
>         >         Dear Developers,
>         >
>         >         Greetings for everyone who had been developing and
>         participate
>         >         vTiger
>         >         CRM development.
>         >
>         >         I am new one in vTiger CRM system. Just I try to
>         implement
>         >         vTiger CRM
>         >         for our sales & administrative departments.
>         >
>         >         In this time I want to know how can I import or
>         synchronize
>         >         vTiger CRM
>         >         products' inventory? Just we have dedicated
>         financial software
>         >         system
>         >         for product inventory it was in MSSQL server. I want
>         to
>         >         synchronize this
>         >         DB's products inventory table data to vTiger CRM
>         products
>         >         table! How can
>         >         I do this, please advice to me that! I mean how can
>         I
>         >         replicate my
>         >         primary (MSSQL) DB data to my vTiger CRM DB? Of
>         course, I know
>         >         our
>         >         fin/system DB structure.
>         >
>         >         With best regards,
>         >         B.Mendbayar
>         >
>         >
>         >         _______________________________________________
>         >         http://www.vtiger.com/
>         >
>         
>         
>