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



Time needed for customer files import Expand / Collapse
Author
Message
Posted 5/7/2007 9:35:01 AM
Forum Member

Forum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum Member

Group: Forum Members
Last Login: 9/9/2009 2:45:13 PM
Posts: 28, Visits: 73
[NOTE: Issue that occurred here will no longer occur with AyaNova 4 due to the new and simplified installation - as in this case user had not created the specified configuration file and ignored the warning error messages]

Hello Joyce,

Can you give us some idea how long it should take to import 800-900 csv files into AN3? We've been at it for about 2 hours and that seems a bit long.

Best regards,
Ian

Post #3071
Posted 5/7/2007 9:49:23 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 @ 7:34:22 AM
Posts: 2,190, Visits: 5,029
Hi Ian

Is the import utility actually still running or perhaps is there an error that is somehow sitting behind a window or did an error occur and you clicked "Continue" instead of resolving the error first?

Which utility are you using - the ImportPartCSV, the ImportClientCSV or the ImportUnitCSV?

When you say 800-900 csv files - do you mean a single CSV file that has 800-900 records in it or do you mean something else?

How much data do you already have in the AyaNova database? Exactly what data affected depends on what import utility you are using. For example, if using the ImportClientCSV data, how many client records do you already have in AyaNova. If using the ImportPartCSV, how many existing part records were there, how many vendors were there already? If using the ImportUnitCSV, how many existing unit records were there, how many existing unit models were there, how many existing client records were there?

What configuration is the AyaNova database - single user default installation, network FireBird, SQL Express or SQL Server?

What computer are you running the Import utility on in relation to the AyaNova database - are you running the import utility on the same computer where the database resides, on a computer within the same network, on a computer connecting via terminal or data portal etc?

Is anti-virus shut off on all computers in use in regards to the AyaNova database and where running the import utility, or at minimum exceptions so that the AyaNova database and the utility and the csv file not being scanned?

Have you checked the event logs on the computer to see if any errors?

Is there other processes running on the computer that are using up all of the resources?

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #3072
Posted 5/9/2007 8:01:42 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 @ 7:34:22 AM
Posts: 2,190, Visits: 5,029
Hi again Ian

Do post what resolved it for you.

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #3075
Posted 5/9/2007 8:04:31 AM
Forum Member

Forum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum Member

Group: Forum Members
Last Login: 9/9/2009 2:45:13 PM
Posts: 28, Visits: 73
I don't think so. You should have gotten a query from John about it.
Post #3076
« 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 9:15pm

Powered by InstantForum.NET v4.1.4 © 2010
Execution: 0.047. 9 queries. Compression Disabled.