RE: Uploading Transactions
Hi gregfallon1,
I have two thoughts on this topic:
1) Regarding the uploading: webERP is running on a MySQL database, hence you could use any ETL tool you want to write into the database. On my end, I'm a big fan of RapidMiner for this purpose, also for the reporting, but you could basically use any tool that is able to connect via ODBC or JDBC (for example MS Access).
2) However: If you modify any table, you need to be sure you keep the consistency and dependencies between any related tables. Usually, when you do something in webERP (or any other database driven application), not only one table is being affected, but several. If you don't keep the database consistent, you run the risk to render it completely useless.
Also: Before you do any "experiments", make sure you run the provided backup sript (.../BackupDatabase.php). For safety reasons it's recommended to download the backup, and delete it off the server immediately.
I hope this helps.
MacPhotoBiker
Just Core Business Inc.
[url]http://www.justcorebusiness.com[/url]
|