Here is a simple way to migrate any data into FA, for example:
Import of huge number of Bank Accounts.
1. Take a sql dump (SQL1) of the data only of your existing FA database - no need for the schema. Do this while being logged into FA at the Bank Account data entry form with no other users logged in.
2. Enter one bank account manually into FA.
3. Take another sql dump (SQL2) of the data only of the same database.
4. Now observe the difference between the two SQL dumps - SQL1 and SQL2.
5. Make a set of insert / update statements (SQLsynch) that will simulate the data synch from SQL1 to SQL2.
6. Import the CSV of you bank accounts into some table schema that has all the relevant data for SQLsynch statements.
7. Using SQL statements or Excel CONCATENATE formulae, create a set of SQLsynch statements for the whole set of bank accounts.
8. Execute this newly created SQLsynch statements set in the database.
Viola! If all went well, you've managed to import the whole set of bank accounts into FA!
Now make a php script to acquire the CSV from your source and populate the current version of FA and submit it to the project so that others will benefit from the migratory effort.
SQLyog Ultimate has a data synch wizard that will make the SQLsynch statement generation a breeze.