AyaImport Installation & Configuration & Use

Top  Previous  Next

It is always recommend to read through all instructions first before proceeding.

 

 

 

The import steps must be followed exactly. Failure to do so may result in loss of data or inability to import.

 

NOTE: AyaNova 4 must be installed on the computer before you install the CE Import utility

 

NOTE: Make sure you have reviewed the Important information about AyaNova CE Import

 

If you experience an issue, refer to If have any errors running the AyaNova CE Import

 

 

Using the AyaNova CE Import utility involves 5 major steps:

 

1. Prepare the AyaNova CE 1.9.4.4 database

2. Prepare AyaNova 4

3. Install and configure the AyaNova CE Import utility

4. Perform the CE Import

5. Check the import completed successfully in AyaNova 4

 

 

1. Prepare the AyaNova CE 1.9.4.4 database

Ensure all AyaNova CE users are out and stay out
Ensure no other program accesses the AyaNova CE 1.9.4.4 database, including ARAS or QBI
Log into AyaNova CE 1.9.4.4 on the same computer where the database resides as the manager account.
If you do not know the manager login name and password, you must obtain this as it is needed for the import
If do not know the manager username and password, log into AyaNova as another username that has access to Users & Rights, and edit the manager account login name and password so it is known – than log in as that manager account.
Confirm that the version of AyaNova CE is 1.9.4.4 with database version of 171 by selecting menu Help -> About this program from within the AyaNova CE program
IF you have any questions on updating or experiencing an issue updating, please provide the following:
Detailed Info from AyaNova – select menu Help -> Select About this program -> click on Detailed Info -> copy all information to a NotePad document.
Your registered company name
Perform the Database Utilities feature Re-index Everything
It has always been recommended to perform this on the same computer where the database resides
This may be intensive and take time – let it finish
Exit out of AyaNova CE 1.9.4.4
If needed, move the AyaNova CE 1.9.4.4 database file SCDATA.SC to the same local C:\ of the computer where the AyaNova v4 database resides

 

2. Prepare AyaNova v4

Confirm a successful installation of AyaNova v4 program and database
You can import into AyaNova v4 in any of its three configurations – the default installation, the network Firebird configuration or the SQL Server configuration.
Apply the AyaNova v4 license activation keycode to AyaNova 4 as per the instructions with your keycode.
Log in as the AyaNova Adminstrator (default is manager with password letmein)
Create Tax Codes for your environment
Edit Part Warehouses if needed – one is the default warehouse and can only have its name edited.
Edit Regions if needed – one is the default region and can only have its name edited.
Configure Global Settings if needed
Note that service workorders imported will use the same workorder numbers as AyaNova 1.9.4.4 so setting a number here  will not affect existing workorder numbers
Set default tax codes settings
What Tax Codes are set up as defaults will apply to all imported parts and rates in imported service workorders.
Set Part Display Format
Set Unit Display Format
Set your Language Settings
Save any changes
Exit out of AyaNova v4

 

3. Install and configure the AyaNova CE Import utility

 

The AyaNova 4 program must be installed before installing the CE Import utility

 

Download the AyaNova CE Import utility from the AyaNova web site

 

Run the CE Import installation.

 

By default, the CE Import utility will be installed to the same folder as the AyaNova 4 program files which is C:\Program Files\Ground Zero Tech-Works Inc\AyaNova

 

 

4. Perform the AyaNova CE Import

You are logged into the computer with full access
You are not performing this via remote access
AyaNova v4 program, database, and import utility are all installed on the local hard drive
The AyaNova CE 1.9.4.4 database file SCDATA.SC is also on this local C:\
No programs are running that may interfere (if have an anti-virus program, either shut it off for the import, or make an exception for both the SCDATA.SC and the AyaNova 4 database)

 

1.Run the CEImport utility from Start -> Programs -> AyaNova -> CEImport

 

2.Be sure to read all messages thoroughly before continuing and comply before continuing.

 

3.Select <Choose Database…>

 

4. Select <Browse manually for source database>

 

5. Move to the location of the AyaNova CE 1.9.4.4 database located on the C:\ of this computer - for example:

 

6. Basic information on the database selected will display

 

7.Select the button Import and review each message before proceeding

 

8.A screen depicting both the AyaNova CE 1.9.4.4 login and the AyaNova v4 login displays

CEImportLogin

You must log in using the AyaNova CE 1.9.4.4 manager account – attempting to use any other account will result in issues
The AyaNova v4 AyaNova Administrator account login name “manager” and password “letmein” are pre-entered - if this isn't your AyaNova 4 AyaNova Administrator username and password, than enter the correct.

 

9.Select the Login button, and the import begins.

 

10.The amount of time to perform the import may vary from 30 seconds to hours depending on different aspects:
The speed and memory of the computer that is performing the import
The number of records in the AyaNova CE 1.9.4.4 database
The type of these records (parts records will import faster than workorder records)
The computer where the import is being performed should not be used for other functions while the import is occurring so that all its processing can go to the import
This is incredibly intensive for the computer – do NOT run any other programs while this is performing
Once you start seeing progress bars, you know the import has started.
If you don’t see the progress bars within 2 minutes – stop the utility and restart it.
If after the progress bars start displaying, if at any time it does not seem to be doing anything – it is NOT frozen – the import utility is chugging away – please let it finish.
If the import utility experiences an issue, it will display so as an error message. Refer to If have any errors running the AyaNova CE import

 

 

11.The import utility will display IMPORT COMPLETED when it is finished.

 

12.Use the X in the upper right hand corner to close (make sure to close before proceeding)

 

 

5. Check the import completed successfully in AyaNova 4

 

1.Log into AyaNova v4 as the AyaNova Administrator
default if not yet changed in AyaNova 4 is “manager” with password “letmein”

 

2.Confirm imported data is correct and complete
3.Re-enter all users’ login names and passwords, and set schedulable users as active and of user type Schedulable User
4.Check security groups and edit as needed
5.Edit PM items as needed
6.If utilizing full inventory, enter Part Adjustments as needed for starting inventory.

 

 

 

See also:

How is AyaNova 4 different from AyaNova CE

Suggested order of setting up AyaNova once licensed