List:General Discussion« Previous MessageNext Message »
From:David Brian Chait Date:August 11 2011 9:17pm
Subject:RE: Import from Quicken 2004 Mac?
View as plain text  
The QIF file includes a lot of data aside from basic transactions, what exactly are you
trying to end up with at the end of the day? Simply a copy of your QB data in Mysql?

-----Original Message-----
From: Jan Steinman [mailto:Jan@stripped] 
Sent: Thursday, August 11, 2011 2:15 PM
To: mysql@stripped
Subject: Import from Quicken 2004 Mac?

I'm looking for ways to import QuickBooks 2010 Mac. I've only just started researching
this, so feel free to "RTFM" me -- with a proper reference, of course!

I'll be wanting to set up a process to do this periodically (and hopefully, automagically)
for new transactions.

QB 2010 Mac appears to only export ".IIF" format, which appears to be a variant of the
older ".QIF" format, and Google didn't turn up really anything for getting IIF/QIF files
into MySQL. The best I could find would be importing them into Excel first, then CSV out
of Excel into MySQL, which sounds like a lot of bother and not readily scriptable for
routine use. I find it hard to believe I'm the first one to ever attempt this!

IIF/QIF seems to be a rather unusual format. Lacking a one-step MySQL import tool, does
anyone know of good parsers and translators for IIF/QIF that may be useful?

Thanks in advance for any advice offered!

----------------
Science uses mathematics to predict the future; economics uses statistics to predict the
past. -- Jeff Barton
:::: Jan Steinman, EcoReality Co-op ::::


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1

Thread
Import from Quicken 2004 Mac?Jan Steinman11 Aug
  • RE: Import from Quicken 2004 Mac?David Brian Chait11 Aug
    • Re: Import from Quicken 2004 Mac?Jan Steinman11 Aug
      • RE: Import from Quicken 2004 Mac?David Brian Chait12 Aug
  • Re: Import from Quicken 2004 Mac?hsv12 Aug
Re: Import from Quicken 2004 Mac?Chris Elhardt13 Aug