AyaNova service management & work order software
AyaNova Support Forum
Home       Members    Calendar    Who's On
Welcome Guest ( Login | Register )
        



Exporting QuickBooks clients to AyaNova using... Expand / Collapse
Author
Message
Posted 5/10/2006 9:01:47 AM
AyaNova Sales & Support

AyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & Support

Group: Administrators
Last Login: 2 days ago @ 5:11:14 PM
Posts: 1,778, Visits: 4,123
Do note that you can use the ImportClientCSV and ImportPartsCSV utilities to import and export data from your accounting program.

For example, as QBI v3 is not compatible with Australian QuickBooks, An Australian AyaNova user may still want to import their QuickBooks clients into AyaNova.

Below is a very brief outline of how to do so:

Download the ImportClientCSV utility (or ImportPartCSV utility) from http://www.ayanova.com/download.htm

Refer to the AyaNova v3 Manual technical section on Importing / Export Utilities for the utility you will be using.

  1. Install and configure as per the manual section
  2. Make a sample export file of your existing AyaNova clients so you can see what the format looks like
  3. In QuickBooks, view a Customer Contact List report, modifying it so that the fields that display are the same fields that are stated in the manual section for the import utility
  4. Select Export, select Export to CSV format (comma separated value)
  5. You may still need to edit the format and postition of the fields. You might use Excel to do this as easy to cut and insert columns. If using Excel, remember that you do need the final format to include quotation marks as well as commas to identify the fields, so a suggestion is to import into Access and export to get the correct format
  6. When the format and position of the fields are as per the manual section for that import utility, run the ImportCSV utility, log in, open the CSV file, confirm data in correct fields and import.
  7. Remember, if you get an error opening the CSV file, it will state you might have an issue with the CSV file, such as not the corect number of fields, or missing quotation marks, etc. You may need to edit the file until you are able to import.


AyaNova Sales & Technical Support
http://www.ayanova.com
Post #1275
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: AyaNova Sales & Support

Permissions Expand / Collapse

All times are GMT -8:00, Time now is 4:01pm

Powered by InstantForum.NET v4.1.4 © 2008
Execution: 0.078. 10 queries. Compression Disabled.