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=3Dgcdmg-mysql-2@m.gmane.o rg

RE: Import from Quicken 2004 Mac?

The QIF file includes a lot of data aside from basic transactions, what exa=
ctly 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@Bytesmiths.com]=20
Sent: Thursday, August 11, 2011 2:15 PM
To: mysql@lists.mysql.com
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 var=
iant 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 import=
ing them into Excel first, then CSV out of Excel into MySQL, which sounds l=
ike a lot of bother and not readily scriptable for routine use. I find it h=
ard 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 impor=
t tool, does anyone know of good parsers and translators for IIF/QIF that m=
ay be useful?

Thanks in advance for any advice offered!

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


--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Ddchait@invenda.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Import from Quicken 2004 Mac?

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@Bytesmiths.com]=20
> Sent: Thursday, August 11, 2011 2:15 PM
> To: mysql@lists.mysql.com
> 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@invenda.com
>=20

----------------
Always do right. This will surprise some people and astonish the rest. =
-- Mark Twain
:::: 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=3Dgcdmg-mysql-2@m.gmane.o rg

RE: Import from Quicken 2004 Mac?

I don't think I have ever heard of anyone directly importing a QIF into any=
relational database, you would have to translate the resulting data into a=
delimited txt file and then import. You may want to check to see if Quickb=
ooks has an API that you can use to access the data natively rather than tr=
ying to move it around from platform to platform.

-----Original Message-----
From: Jan Steinman [mailto:Jan@Bytesmiths.com]=20
Sent: Thursday, August 11, 2011 2:37 PM
To: David Brian Chait
Cc: mysql@lists.mysql.com
Subject: Re: Import from Quicken 2004 Mac?

On 11 Aug 11, at 14:17, David Brian Chait wrote:

> The QIF file includes a lot of data aside from basic transactions, what e=
xactly are you trying to end up with at the end of the day? Simply a copy o=
f your QB data in Mysql?

That would be a good start. We don't need a complete duplicate, but in my e=
xperience, 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, amo=
unt, memo, category, account from, account to.

This is to reconcile the chart of accounts (in Quick Books) with project ma=
nagement (in MySQL).

> From: Jan Steinman [mailto:Jan@Bytesmiths.com]=20
> Sent: Thursday, August 11, 2011 2:15 PM
> To: mysql@lists.mysql.com
> Subject: Import from Quicken 2004 Mac?
>=20
> I'm looking for ways to import QuickBooks 2010 Mac. I've only just starte=
d researching this, so feel free to "RTFM" me -- with a proper reference, o=
f course!
>=20
> I'll be wanting to set up a process to do this periodically (and hopefull=
y, automagically) for new transactions.
>=20
> QB 2010 Mac appears to only export ".IIF" format, which appears to be a v=
ariant of the older ".QIF" format, and Google didn't turn up really anythin=
g for getting IIF/QIF files into MySQL. The best I could find would be impo=
rting 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 imp=
ort 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@invenda.co=
m
>=20

----------------
Always do right. This will surprise some people and astonish the rest. -- M=
ark Twain
:::: 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=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Import from Quicken 2004 Mac?

>>>> 2011/08/11 14:14 -0700, Jan Steinman >>>>
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!
<<<<<<<<
I found this:
http://www.qblittlesquare.com/2011/07/import-lists-into-quic kbooks-with-iif/
If I can believe it, there is no reason for you to attempt any conversion, because, if, as it seems, HT is the separator, you can directly use "LOAD DATA" with optional double-quote, ignoring (*sigh*) leading lines.

I saw references to convertors for IIF, CSV, and QIF.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Import from Quicken 2004 Mac?

might want to look at QIF Master. Generally designed to convert lists
of data into QIF formats but Mr. Wooward may have some other tools to
go the other way also.

c

On Aug 11, 2011, at 5:02 PM, David Brian Chait wrote:

> I don't think I have ever heard of anyone directly importing a QIF
> into any relational database, you would have to translate the
> resulting data into a delimited txt file and then import. You may
> want to check to see if Quickbooks has an API that you can use to
> access the data natively rather than trying to move it around from
> platform to platform.
>
> -----Original Message-----
> From: Jan Steinman [mailto:Jan@Bytesmiths.com]
> Sent: Thursday, August 11, 2011 2:37 PM
> To: David Brian Chait
> Cc: mysql@lists.mysql.com
> Subject: Re: Import from Quicken 2004 Mac?
>
> 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@Bytesmiths.com]
>> Sent: Thursday, August 11, 2011 2:15 PM
>> To: mysql@lists.mysql.com
>> 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=dchait@invenda.com
>>
>
> ----------------
> Always do right. This will surprise some people and astonish the
> rest. -- Mark Twain
> :::: 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=celhardt@mac.com
>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org