July 6, 2010 at 1:09 pm
Hi guys,
I have data in sql server 2008 which needs to be exported into QIF format... is there a way we can do that through sql? Checking if someone had expereince exporting data in QIF file... Thanks.
July 7, 2010 at 8:00 am
No one with QIF export experience?
July 7, 2010 at 8:31 am
Well looking at the format of the QIF file, it's not difficult, but it's not easy either.
I've done it the other way...using a utility that converts QIF to comma delimited,and then importing the file into SQL; searching for "QIF" on SSC shows like 3 or 4 other threads, and they all pertain to importing into SQL.
to help others visualize the question,here's an example QIF file that has a list of "Expenses"; some fields are clearly optional, like the memos and stuff;
you would need copies of the two lookup lists for "P" and "L" categories; i knwo you cannot just put any value in; they must exist in Quicken before import.
i think D1/ 1'10 is coded to be day 1 of month 1 of year '10: 01/01/2010 (duh i know which date is in the file, so it's obvious to me)
U is amount? expenses are negatives, and contain commas.
T is Total? i suspect a quantity multiplier example does not exist in my sample, so T values are always the same as the U values.
C is "Cleared" or not
P is Category?
L is legal/tax category?
M is memo`
^ denotes end of line item.
!Type:Bank
D1/ 1'10
U0.00
T0.00
CX
POpening Balance
L[Expenses]
^
D1/ 1'10
U-391.00
T-391.00
C*
PLicense Renewal
MLicense Renewal
LProf and Legal Fees
^
D1/ 1'10
U-1,200.00
T-1,200.00
PCourse And Credits
LCourse Participation
^
D1/ 1'10
U-350.00
T-350.00
PLegal Fees Contract Review Exit Contract
LProf and Legal Fees
^
D1/ 1'10
U-99.00
T-99.00
PQuicken
LBiz Supplies
^
D1/ 3'10
U-66.73
T-66.73
PAmazon.com
MSQL Book
LBiz Supplies
^
D1/ 7'10
U-250.00
T-250.00
PInjury Compensation Associati
LProf and Legal Fees
^
D1/15'10
U-2,395.00
T-2,395.00
PBoard Stiff
Mjan15-17 review course
LContinuing Edication
^
D2/ 1'10
U-88.83
T-88.83
PIhostasp
Mhosting
LBiz Utilities:Internet, Biz
^
D2/ 1'10
U-10.95
T-10.95
PIhostasp
Mregister domain
LBiz Utilities:Internet, Biz
^
D2/11'10
U-29.95
T-29.95
PTrustFax
LBiz Utilities
^
D2/12'10
U-59.34
T-59.34
PWalgreens
MMagicJack & ATT Phone
LBiz Utilities
^
D2/12'10
U-247.36
T-247.36
PUS Pak And Ship
M: Mailbox 1 YR.
LBiz Utilities
^
D2/14'10
U-3.00
T-3.00
PMagicJack
LBiz Utilities
^
D2/14'10
U-10.00
T-10.00
PmagicJack
LBiz Utilities
^
D2/14'10
U-105.99
T-105.99
POffice Depot
LBiz Supplies
^
D2/14'10
U-29.67
T-29.67
POffice Depot
LBiz Supplies
^
D2/14'10
U-13.77
T-13.77
POffice Depot
LBiz Supplies
^
D2/14'10
U-49.99
T-49.99
POffice Depot
LBiz Supplies
^
D2/16'10
U-1,807.00
T-1,807.00
PInsurance
LBiz Insurance
^
D2/19'10
U-339.25
T-339.25
PRitz-Carlton
MBuckhead Atlanta
LBiz Travel
^
D2/19'10
U-149.40
T-149.40
PExpedia
MFlight: Fort Lauderdale to Atlanta
LBiz Travel
^
D2/24'10
U2,625.00
T2,625.00
PSome Company Inc.
MAnotherCompany LLC
L[SQL Service Invoices]
^
D3/11'10
U2,843.75
T2,843.75
PSome Company Inc.
MAnotherCompany, LLC
L[SQL Service Invoices]
^
D3/25'10
U4,243.75
T4,243.75
PSome Company Inc.
MAnotherCompany, LLC
L[SQL Service Invoices]
^
D4/ 8'10
U-10.53
T-10.53
PUS Pak And Ship
MShipping
LBiz Utilities
^
D4/16'10
U8,531.25
T8,531.25
PSome Company Inc.
MAnotherCompany, LLC
L[Anes Service Invoices]
^
D4/16'10
U-2,395.00
T-2,395.00
C*
Pboard Stiff
Mapr16-18 review coarse
LContinuing Edication
^
D4/20'10
U4,068.75
T4,068.75
PSome Company Inc.
MAnotherCompany, LLC
L[SQL Service Invoices]
^
D4/21'10
U-150.00
T-150.00
PDelta Airlines
MBaggage Fee And Flight Change$25 + $25 + $100
LBiz Travel
^
D4/21'10
U-1,950.00
T-1,950.00
PABSE American Board Of SQL Experts
M Certification Examination fees
LProf and Legal Fees
^
D5/ 1'10
U-1,807.00
T-1,807.00
P Insurance
LBiz Insurance
^
D5/ 5'10
U3,587.50
T3,587.50
PSome Company Inc.
MAnotherCompany, LLC
L[SQL Service Invoices]
^
Lowell
July 7, 2010 at 8:45 am
Wiki has a good explanation of the format:
http://en.wikipedia.org/wiki/Quicken_Interchange_Format
Lowell
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply