I was wondering if there is a direct command to fetch some data tables
from SQL for Microsoft RMS - and import them into the MySQL for
ERPNext directly and sync with two sections directly related.
For example - import master inventory, warehouse names, sales figures
etc - and import them automatically and reflect in related sections in
ERPNext.
Lots of help needed and will be sincerely appreciated!
On 13-Sep-2012, at 5:45 PM, Danish Agha <da...@gmail.com> wrote:
Hi Guys,
I was wondering if there is a direct command to fetch some data tables from SQL for Microsoft RMS - and import them into the MySQL for ERPNext directly and sync with two sections directly related.
For example - import master inventory, warehouse names, sales figures etc - and import them automatically and reflect in related sections in ERPNext.
Lots of help needed and will be sincerely appreciated!
Hi guys, I also am interested in importing data from external systems under program control (instead of the manual Setup > Data Import mechanism). In my case I would probably use a CSV as the intermediate data format (export nightly using cron from a legacy system to a CSV file or files), and then import the data into ERPNext automatically (e.g. scheduled using cron).
We have many legacy systems, and at least initially I would like to automatically import data from our legacy systems every night into ERPNext (something like a test server that resets itself every night). Over time, as we understand ERPNext better and implement required custom functionality, we would migrate away from most of these legacy systems - but it would be gradual (not in the typical big cut-over one night, when legacy systems get turned off and all data entry is done in the new ERP starting next morning).
Further, the data being I am importing is well over 5000 rows in some cases (e.g. I am importing 25,000 part numbers from our legacy part numbering system, and 50,000 serial numbers from a separate manufacturing management system). I can use a shell script to break up the import data into multiple files, do how could ERPNext deal with this if the import was scheduled?
Alternatively (which could be closer to the OP’s question), would it be possible to write data obtained from another system directly to ERPNext’s MySQL schema? A shell script could be run by cron that would simply “load data infile…” through the mysql command line monitor, but could it work in practice? Some systems have too much interaction between models in the business logic for this to be feasible, but would it work with ERPNext?
On Thursday, 13 September 2012 22:55:09 UTC-6, Rushabh Mehta wrote:
Unfortunately, we have no experience in the technology you are asking us to integrate.
On 13-Sep-2012, at 5:45 PM, Danish Agha <da…@gmail.com> wrote:
For example - import master inventory, warehouse names, sales figures etc - and import them automatically and reflect in related sections in ERPNext.
ERPNext would need to support CSV format import only. It could be the responsibility of the site administrator to see that data from other systems is provided in CSV format.
Dale
–
You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.
Hi guys, I also am interested in importing data from external systems under program control (instead of the manual Setup > Data Import mechanism). In my case I would probably use a CSV as the intermediate data format (export nightly using cron from a legacy system to a CSV file or files), and then import the data into ERPNext automatically (e.g. scheduled using cron).
We have many legacy systems, and at least initially I would like to automatically import data from our legacy systems every night into ERPNext (something like a test server that resets itself every night). Over time, as we understand ERPNext better and implement required custom functionality, we would migrate away from most of these legacy systems - but it would be gradual (not in the typical big cut-over one night, when legacy systems get turned off and all data entry is done in the new ERP starting next morning).
Further, the data being I am importing is well over 5000 rows in some cases (e.g. I am importing 25,000 part numbers from our legacy part numbering system, and 50,000 serial numbers from a separate manufacturing management system). I can use a shell script to break up the import data into multiple files, do how could ERPNext deal with this if the import was scheduled?
Alternatively (which could be closer to the OP's question), would it be possible to write data obtained from another system directly to ERPNext's MySQL schema? A shell script could be run by cron that would simply "load data infile..." through the mysql command line monitor, but could it work in practice? Some systems have too much interaction between models in the business logic for this to be feasible, but would it work with ERPNext?
On Thursday, 13 September 2012 22:55:09 UTC-6, Rushabh Mehta wrote:
Unfortunately, we have no experience in the technology you are asking us to integrate.
On 13-Sep-2012, at 5:45 PM, Danish Agha <da...@gmail.com> wrote:
For example - import master inventory, warehouse names, sales figures etc - and import them automatically and reflect in related sections in ERPNext.
ERPNext would need to support CSV format import only. It could be the responsibility of the site administrator to see that data from other systems is provided in CSV format.
Dale
–
You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.
Hi guys, I also am interested in importing data from external systems under program control (instead of the manual Setup > Data Import mechanism). In my case I would probably use a CSV as the intermediate data format (export nightly using cron from a legacy system to a CSV file or files), and then import the data into ERPNext automatically (e.g. scheduled using cron).
We have many legacy systems, and at least initially I would like to automatically import data from our legacy systems every night into ERPNext (something like a test server that resets itself every night). Over time, as we understand ERPNext better and implement required custom functionality, we would migrate away from most of these legacy systems - but it would be gradual (not in the typical big cut-over one night, when legacy systems get turned off and all data entry is done in the new ERP starting next morning).
Further, the data being I am importing is well over 5000 rows in some cases (e.g. I am importing 25,000 part numbers from our legacy part numbering system, and 50,000 serial numbers from a separate manufacturing management system). I can use a shell script to break up the import data into multiple files, do how could ERPNext deal with this if the import was scheduled?
Alternatively (which could be closer to the OP's question), would it be possible to write data obtained from another system directly to ERPNext's MySQL schema? A shell script could be run by cron that would simply "load data infile..." through the mysql command line monitor, but could it work in practice? Some systems have too much interaction between models in the business logic for this to be feasible, but would it work with ERPNext?
On Thursday, 13 September 2012 22:55:09 UTC-6, Rushabh Mehta wrote:
Unfortunately, we have no experience in the technology you are asking us to integrate.
On 13-Sep-2012, at 5:45 PM, Danish Agha <da...@gmail.com> wrote:
For example - import master inventory, warehouse names, sales figures etc - and import them automatically and reflect in related sections in ERPNext.
ERPNext would need to support CSV format import only. It could be the responsibility of the site administrator to see that data from other systems is provided in CSV format.
Dale
–
You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.