php libraries for exporting to quicken?

[laredotornado@zipmail.com]

Hi,

I have a client that wants to export his sales data into formats that
can be imported into Quicken. Figured this kind of thing has been
tackled before, but had trouble finding freeware on Google. Any
suggestions on libraries/code to use when using PHP 4/MySQL 4 to export
data to Quicken file formats (preferrably CSV).

Thanks, - Dave

[ZeldorBlat]

Re: php libraries for exporting to quicken?


laredotornado@z ipmail.com wrote:[color=blue]
> Hi,
>
> I have a client that wants to export his sales data into formats that
> can be imported into Quicken. Figured this kind of thing has been
> tackled before, but had trouble finding freeware on Google. Any
> suggestions on libraries/code to use when using PHP 4/MySQL 4 to export
> data to Quicken file formats (preferrably CSV).
>
> Thanks, - Dave[/color]

Turning a table into a CSV is easy:

$f = fopen('mycsvfil e.csv', 'w');
$query = 'select * from someTable';
$rs = mysql_query($qu ery);
while ($row = mysql_fetch_arr ay($rs, MYSQL_NUM))
fwrite($f, implode(', ', $row) . "\n");
fclose($f);

[NC]

Re: php libraries for exporting to quicken?

laredotornado@z ipmail.com wrote:[color=blue]
>
> I have a client that wants to export his sales data into formats that
> can be imported into Quicken. Figured this kind of thing has been
> tackled before, but had trouble finding freeware on Google. Any
> suggestions on libraries/code to use when using PHP 4/MySQL 4
> to export data to Quicken file formats (preferrably CSV).[/color]

If you are comfortable with CSV as data interchange format (i.e., if
there is no requirement to produce IIF files), it's very easy to
produce in MySQL, with or without the use of PHP. Just run a SELECT
INTO OUTFILE query or output results of your SELECT query as CSV...

Cheers,
NC

[laredotornado@zipmail.com]

Re: php libraries for exporting to quicken?

Thanks for these replies. I didn't mean to imply that I don't know how
to produce CSV files. My actual question centered around Quicken
specifically. I am unfamiliar with its file formats or what data
comprises a valid import. Could you post or point me to code that
would do that?

Thanks, - Dave

[NC]

Re: php libraries for exporting to quicken?

laredotornado@z ipmail.com wrote:[color=blue]
>
> I am unfamiliar with its file formats or what data comprises
> a valid import.[/color]

You should read Quicken documentation; I seem to remember that it was
helpful. I managed to produce valid Information Interchange Files
(IIF) based entirely on information found in Quickbooks oline help and
on Intuit's Web site...

Also, you could try some primitive reverse-engineering. Export some
data from Quicken (the kind of data you want to import; in your case,
sales) into CSV and see what the format is. Then use the exported file
as a template.
[color=blue]
> Could you post or point me to code that would do that?[/color]

No; last time I worked with IIF was about four years ago... I can help
you figure it out if you want to though...

Cheers,
NC