Customer database migration help - Filemaker to 4D ERP
$30-100 USD
Closed
Posted almost 13 years ago
$30-100 USD
Paid on delivery
I have to migrate the whole customer data of a company from a Filemaker 8.0 Pro environment to a 4D based ERP solution.
The data now is in *52 fields spread on 8 tables in Filemaker*. The 4D software has a CSV-import function. The data has to be drawn together from the filemaker tables and put on *one line per customer/contact in a CSV-file* to be imported into 4D.
Some fields have to be drawn together into one field (for example the contact's history is spread among 3 fields in the source DB and should end up in one field in the CSV).
*Source:* Filemaker 8.0 Pro database ( [login to view URL] )
*Target:* ProFinance ERP (by [login to view URL] based on the 4D framework [login to view URL] )
My first aproach was using the Filemaker export function into Excel, prepare the data there, save as CSV and then import it. But the 'preparing the data in Excel' turned out to be too much manual work for the 7500 entries the DB does have.
**So now I'm looking for somebody who can help me to get this done in a smarter smoother way.**
I can export all tables from the Filemaker db to Excel sheets - or they could be accessed from within Filemaker or maybe through ODBC/JDBC