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



Importing data Expand / Collapse
Author
Message
Posted 4/5/2007 2:56:48 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 4/11/2007 3:44:25 AM
Posts: 1, Visits: 5
Is it possible to import a CSV file directly into the SQL backend?

At present I am importing data into Firebird then using your util from Firebird to SQL which is far from ideal.

Can you suggest a better procedure for the import?
Post #2994
Posted 4/5/2007 7:21:46 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: Yesterday @ 8:27:06 PM
Posts: 1,702, Visits: 4,008
Hi

Please provide the actual names of the utilitiies that you are using in the two different imports as the Import utilties we provide - ImportPartCSV, ImportClientCSV, ImportUnitCSV

Also note that the import utilities are not dependant on what AyaNova database server is in use.

The AyaNova import utilities are for use with AyaNova - regardless whether using the AyaNova Firebrid database configuration or using an AyaNova SQL database configuration.

Perhaps this is what the issue is? Do let me know that you are now importing directly into your AyaNova database using the provided utilities regardless whether you are using the AyaNova SQL configuration or the AyaNova Firebird configuration. If you are still experiencing an issue, do let me know exactly what import utility you are using, and exactly what steps you are doing and the issue so that I can help.

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #2997
« 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 1:11am

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