Home  |  Contents 

Site News
  Forum Index : Site News         Section
Subject Topic: Forum upgrade Post ReplyPost New Topic
<< Prev Page of 2
Author
Message << Prev Topic | Next Topic >>
radar
Newbie
Newbie
Avatar

Joined: 09 June 2019
Location: Australia
Online Status: Offline
Posts: 12
Posted: 15 July 2019 at 10:01pm | IP Logged Copy link to clipboard   Quote radar

Gizmo wrote:
Do you have any experience with creating the export files to import into Reckon ( Quickbooks )?


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 .


Back to Top View radar's Profile Search for other posts by radar
 


If you wish to post a reply to this topic you must first login
If you are not already registered you must first register

  Search the forums using Google.
<< Prev Page of 2
 
Post ReplyPost New Topic
Printable version Printable version
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

Powered by Web Wiz Forums version 7.8
Copyright ©2001-2004 Web Wiz Guide

This page was generated in 0.1211 seconds.
Privacy Policy     Process times : 0, 0, 0, 0.12