[GNC] Importing Data

[Chris Miller]

Hi Folks, 

QuickBooks does not give up its data graciously, but it will export many things as an IIF -- "Intuit Interchange File", which is almost like a "CSV", except with "tab" instead of "comma". I can replace the "tab" with ";" and I'm good to go. Almost. The first line is a header to identify the fields of the subsequent lines in the file. GNC does not understand IIF, but does understand CSV, and IIF is just a specialized CSV. Since one of the things I can get from QuickBooks is a chart of accounts with current balance, I have a place to start, but I need to understand more than I do. 

How do I map the existing "column" headers in the erstwhile IIF to columns that GNC understands? How do I know what that mapping is? I can't just assert an account balance; there has to be a complimentary entry to "Equity:Opening Balance", so how does that happen? 

I'm almost ready to light this candle. 

Thanks for the help, 
-- 
Chris. 

V:916.799.9461 
F:916.974.0428 
A: Because we read from top to bottom, left to right.
    Q: > Why should I start my reply below the quoted text?