|
|
|
Forum Newbie
Group: Forum Members
Last Login: 11/27/2006 9:25:54 AM
Posts: 5,
Visits: 11
|
|
Per the manual I downloaded ImportClientVSV and Extracted it to Program Files on my PC (the same file AyaNova is in). I right clicked on my Access database...selected Export, and CSV is not in Program Files (top drop down list), or the file type (bottom drop down list).
Help would be appreciated.
Thanks,
Dave
|
|
|
|
|
AyaNova Sales & Support
Group: Administrators
Last Login: 2 days ago @ 2:53:05 PM
Posts: 1,840,
Visits: 4,267
|
|
| Hi Dave Although Access support is outside of our AyaNova support, I've provided basic information below on exporting data from an Access database. As any database table could have completely different fields in it, it is not possible for us to provide step by step instructions on exporting from another program, nor on how to format for use with the ImportClientCSV program - we can only provide what the final CSV file must be formated as to be able to be used with the ImportClientCSV utility. If creating a CSV file for eventual use with the ImportClientCSV utility, and your present data is in an Access database: - you would open the Access database via the Access program itself.
- then you would select the table in this Access database that would be imported and right click on this table itself
- then select Export which opens a "Export table "xxxx" to..." window (where xxxx is the name of the table you are exporting data from)
- move to the location where you want to save to
- in the Save As Type field at the very bottom, drop down and select the type Text Files (*.txt, *.csv, *.tab, *.asc)
- enter in the name of the file with an extension csv on it - for example myclients.csv - into the File Name field
You will than need to edit this file so that it meets the exact format and field order outlined in the AyaNova v3 Manual on using the ImportClientCSV utility prior to being able to import. I hope this points you in the right direction. - Joyce
- AyaNova Sales & Technical Support
- http://www.ayanova.com
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 11/27/2006 9:25:54 AM
Posts: 5,
Visits: 11
|
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 11/27/2006 9:25:54 AM
Posts: 5,
Visits: 11
|
|
Hi Joyce,
I made a few more attempts to import my client database from Microsoft Access without success. Approximately 50 of my 350 clients entered into the AyaNova grid screen. Many other client records had information scrambled in the grid.
I have deleted the 300 scrambled client information records one at a time per your instructions.
Now I am attempting to enter these 300 records, one at a time using the Client Entry Screen. After I enter the client information manually, I hit the Save button, then the Exit button at the top of the page. When I am back at the Client Grid Screen, the client information is not there. I have repeated this process with the same results. I searched for the record I have been attempting to enter, and it comes up in a search.
Why aren't these new client records being saved and showing in the Client Grid Screen?
Thanks,
Dave
|
|
|
|
|
AyaNova Sales & Support
Group: Administrators
Last Login: 2 days ago @ 2:53:05 PM
Posts: 1,840,
Visits: 4,267
|
|
| Hi Dave You say that you do a search for the client , and it does come up in a search - so that would mean that the client record has been saved. - Select the Clients navigation pane
- Select the Clients grid
- Select the Refresh button at the top of the Clients grid
- Do these new client records now display?
If you are creating new clients via the New... menu option in the Clients grid, once you save and exit the new client record, the grid will automatically refresh itself if using the AyaNova program. Please confirm from what exact grid, step by step what you do to confirm that you are in the Clients grid selecting the New... menu option, and that when you select Save & Ext, you return to the Clients grid too. - Joyce
- AyaNova Sales & Technical Support
- http://www.ayanova.com
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 11/27/2006 9:25:54 AM
Posts: 5,
Visits: 11
|
|
Hi Joyce,
I click on the Clients button of the Navigation Pane to get to the Client Grid Screen. At the top of the Client Grid Screen I click the New button, which takes me to the Client Entry Screen. After entering my client information on the Client Entry Screen I click the Save button, then the Exit button on the top of the Client Entry Screen. This brings me back to the Client Grid Screen (without the new client entry). I have hit the Refresh button, with no change. I have also exited the software, and re-entered it, with no new client data on the Client Grid Screen.
When I first enter the client name in the Client Entry Screen I get a message to the effect that this client is already entered in the system/software.
Thanks,
Dave
|
|
|
|
|
AyaNova Sales & Support
Group: Administrators
Last Login: 2 days ago @ 2:53:05 PM
Posts: 1,840,
Visits: 4,267
|
|
| Hi Dave If you receive a message "Warning: There is an existing item in the database with the same name" that is telling you that there already is a client with that same name entered - and you can not have the two clients with the same name. So even though you select Save and than select Exit - that second client record with the same name will not show up ever. You can confirm this by entering a client that is not already entered into your database, save it and exit - and you will see that the grid will now show this new client - as long as it has not already been entered. - Joyce
- AyaNova Sales & Technical Support
- http://www.ayanova.com
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 11/27/2006 9:25:54 AM
Posts: 5,
Visits: 11
|
|
Hi Joyce,
I understand that these client names that I am attempting to enter into AyaNova may be in the software somewhere, but they are not in the Client Grid Screen, or anywhere else that I can tell. Also, I have several clients with the same last name. Are yoiu telling me this is a problem for the AyaNova software?
Dave
|
|
|
|
|
AyaNova Sales & Support
Group: Administrators
Last Login: 2 days ago @ 2:53:05 PM
Posts: 1,840,
Visits: 4,267
|
|
| Hi Dave You can not have clients with the exact same text in the Client Name field in the client entry screen. As suggested in the AyaNova v3 Manual, if you have clients with the same name, append to the name in the Client Name field additional text identifying thtat client from others with the same name - or you won't know which is the one to select when creating a workorder. Fo | | | |
Posted 11/15/2006 3:18:55 PM
