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



Assistance to create the Client Import CSV... Expand / Collapse
Author
Message
Posted 8/6/2007 7:54:45 PM
Forum Member

Forum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum Member

Group: Forum Members
Last Login: 11/11/2007 1:38:15 PM
Posts: 28, Visits: 60
Hi -

I've been trying to create the Client Import file & am having some difficulties.  As directed, I originally started out with an Excel file & once ready brought it into Access to create the CSV file.  Once exported, I bought it into Notepad to ensure all the ,"", were in place and resaved the file.  The file is a .txt & AyaNova doesn't recognize it as a valid import file. 

In the manual, there is the opportunity to send in our file & have it converted properly.  Please advise how I may do so.

Many thanks -

Gladys

Post #3325
Posted 8/6/2007 8:09:10 PM
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 @ 6:04:54 PM
Posts: 2,018, Visits: 4,604
Hi Gladys

When you are done checking the file in NotePad, exit out of NotePad, and then just rename the extension from .txt to .csv

Now when you run the Import Client utility, you will be able to open the file because it will be a CSV file

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #3326
Posted 8/6/2007 8:45:16 PM
Forum Member

Forum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum Member

Group: Forum Members
Last Login: 11/11/2007 1:38:15 PM
Posts: 28, Visits: 60
Hi Joyce -

That was my first attempt too, however the import didn't seem to recognize it.  Will try again & let you know.

Thanks -

Gladys

Post #3327
Posted 8/6/2007 9:05:56 PM
Forum Member

Forum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum Member

Group: Forum Members
Last Login: 11/11/2007 1:38:15 PM
Posts: 28, Visits: 60
Hi Joyce -

I'm not sure what changed, but I went back & renamed the file & it seems to be loading just fine.

Thanks a bunch-

Gladys

Post #3328
Posted 11/11/2007 1:21:40 PM
Forum Member

Forum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum Member

Group: Forum Members
Last Login: 11/11/2007 1:38:15 PM
Posts: 28, Visits: 60
I am happy to advise this entire issue has been resolved & the import completed without any additional grief.

Thanks for all your assistance over the last number of months.

Gladys

Post #3549
« 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:39pm

Powered by InstantForum.NET v4.1.4 © 2009
Execution: 0.063. 10 queries. Compression Disabled.