[RBG7-L] - RE: QIF files

[John Engwer]

Claudine and Albert, thanks for the information on QIF files.  It looks like I will have to create my own import method.  I was hoping that there was some easy/automatic way to convert to a format that is compatible with Gateway.   John   From: rbg7-l@rbase.com [mailto:rbg7-l@rbase.com] On Behalf Of Claudine Robbins Sent: Tuesday, October 25, 2005 3:10 PM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: QIF files   John,   http://web.intuit.com/support/quicken/2002/win/1181.html   I have never used QIF/OFX file formats, but I would start looking at converting the data into a better known format such as ASCII, CSV or XLS (search/replace for the field and record delimiters).  I can’t tell from this sample what the field delimiter is,  but the file delimiter is a caret.  It appears you first have to manipulate the file format then map a temporary R:Base import table to the import fields.  Then, you’re home free to append, insert or update the fields in your permanent R:Base tables.   Hope that helps a little.   From: rbg7-l@rbase.com [mailto:rbg7-l@rbase.com] On Behalf Of John Engwer Sent: Tuesday, October 25, 2005 1:17 PM To: RBG7-L Mailing List Subject: [RBG7-L] - QIF files   I have a client that wants to download checking account information from a bank and import it into RBase.   Does anyone have experience importing  QIF files to RBase? If so, how do you do it?     John