Import fields from CSV files to specific fields in Ayanova via SQL

As we have used Quickbooks for all kinds of data collection for client specific data in fields that QBI can’t handle. We’d like to import some of the data by client into a pre-determined field in Ayanova so tha data can be used for display on workorders and dispatch reports. We know this can be done with SQL and we are using SQL Express 2008 as our database. Can you lend some guidance on what the SQL statements would look like if we were attempting to load a 2 field CSV file (Customer Name and Notes)that wouldverify the client field and then populate the Scheduleable Users Notes field with the’Notes’ data? Any help would be appreciated.

superior (5/12/2009)As we have used Quickbooks for all kinds of data collection for client specific data in fields that QBI can’t handle. We’d like to import some of the data by client into a pre-determined field in Ayanova so tha data can be used for display on workorders and dispatch reports. We know this can be done with SQL and we are using SQL Express 2008 as our database. Can you lend some guidance on what the SQL statements would look like if we were attempting to load a 2 field CSV file (Customer Name and Notes)that wouldverify the client field and then populate the Scheduleable Users Notes field with the’Notes’ data? Any help would be appreciated.

Hi, I’m pretty sure what you justed posted at http://forum.ayanova.com/Topic4648-121-1.aspxis what you are also talking about above? In that you want the Schedulable User Notes from the QB client imported into AyaNova. Do review the posting reply I posted there at http://forum.ayanova.com/FindPost4650.aspx.

Do note that you never ever want to directly edit the AyaNova database (which is what you would be doing with a SQL statement), instead the client import/export plugin we provide correctly creates a client record in AyaNova and populates the fields.

  • Joyce