[RBG7-L] - RE: QIF files

[John Engwer]

Title: Message

Clive   My client’s bank only offers downloads in QIF format.  At least that is the only option on their menu.  I will call them to see if they could set the account up with an ASCII option.  If not, I will need to write a routine to convert the QIF files.   Thanks for the reply.   John   From: rbg7-l@rbase.com [mailto:rbg7-l@rbase.com] On Behalf Of Clive Williams Sent: Friday, October 28, 2005 12:20 AM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: QIF files   G'day John,   Australian banks allow downloads as either QIF files or as ASCII delimited files.  If US banks offer the same option you may find that manipulating the delimited file is easier than the QIF file.       Regards Clive Williams -----Original Message----- From: rbg7-l@rbase.com [mailto:rbg7-l@rbase.com] On Behalf Of John Engwer Sent: Friday, 28 October 2005 00:34 To: RBG7-L Mailing List Subject: [RBG7-L] - RE: QIF files J   Banks also use the QIF format.  I this case I am downloading a file from a bank.   John   From: rbg7-l@rbase.com [mailto:rbg7-l@rbase.com] On Behalf Of J BLAUSTEIN Sent: Thursday, October 27, 2005 9:45 AM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: QIF files   John other than vendor,customer, account numbers, I did not belive that Quickbooks allow for export - I create a report will all the information and then export it to Excel then to Rbase J At 09:33 AM 10/27/2005, you wrote: 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 cant 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, youre 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