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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy