From: Jan Steinman Date: August 11 2011 9:36pm Subject: Re: Import from Quicken 2004 Mac? List-Archive: http://lists.mysql.com/mysql/225521 Message-Id: MIME-Version: 1.0 (Apple Message framework v1084) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable On 11 Aug 11, at 14:17, David Brian Chait wrote: > 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? That would be a good start. We don't need a complete duplicate, but in = my experience, it's easier to get it all and winnow out the bits you = don't want than to selectively import. That said, we really only need the basic transaction info: date, payee, = amount, memo, category, account from, account to. This is to reconcile the chart of accounts (in Quick Books) with project = management (in MySQL). > From: Jan Steinman [mailto:Jan@stripped]=20 > Sent: Thursday, August 11, 2011 2:15 PM > To: mysql@stripped > Subject: Import from Quicken 2004 Mac? >=20 > 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! >=20 > I'll be wanting to set up a process to do this periodically (and = hopefully, automagically) for new transactions. >=20 > 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! >=20 > 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? >=20 > Thanks in advance for any advice offered! >=20 > ---------------- > Science uses mathematics to predict the future; economics uses = statistics to predict the past. -- Jeff Barton > :::: Jan Steinman, EcoReality Co-op :::: >=20 >=20 > --=20 > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: = http://lists.mysql.com/mysql?unsub=3Ddchait@stripped >=20 ---------------- Always do right. This will surprise some people and astonish the rest. = -- Mark Twain :::: Jan Steinman, EcoReality Co-op ::::