J
Banks also use the QIF format.
I this case I am downloading a file from a
bank.
From: [email protected] [mailto:[email protected]]
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: [email protected] [ mailto:[email protected]] 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: [email protected] [ mailto:[email protected]] 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
