Newbie
Joined: 09/06/2019
Location: AustraliaPosts: 16
| Posted: 12:01pm 15 Jul 2019 |
[quote=Gizmo] Do you have any experience with creating the export files to import into Reckon ( Quickbooks )? [/quote]
Hi Gizmo , I have created query's from the mysql> Shell ..
Had been using them to import into earlier QuickBooks Versions .
mysql> select * from database WHERE feild INTO OUTFILE '/tmp/forqb.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '"' LINES TERMINATED BY '\r\n';
This was using debian .
This query gives a file compatible to Excel 2003 export to csv .
The resulting file ( /tmp/forqb.csv ) can then be imported to QB's
You may have to format the query to suit . Depending on your version of QB's
and its New line/terminating requirements .
Be shure that you have read write 755 permisions to the output directory and the file
( /tmp/forqb.csv ) ( C:\forqb.csv ) As mysql wont tell you it can't write the file
but complain about your syntax , Go Figure
And from the shell you can use mysqldump ,
radar@access:~# mysqldump -u root -p --tab=/tmp --fields-terminated-by=, --fields-enclosed-by='"' --lines-terminated-by=0x0d0a databasename
From the above command you will get two files output into the /tmp directory databasename.txt databasename.sql the sql contains the database schema .
If you looking for a gui try < phpmyadmin.net > Written in php for administration
of mysql .. Very good tool if you like mysql syntax .
I guess you don't want a commercial solution QuickBooks import - Zed Axis v13
And thank you for all your work on the forum ,
It may be from the earlier days but it stands the test of time .