Installing NEOSYS Service: Difference between revisions

From NEOSYS Technical Support Wiki
Jump to navigationJump to search
(→‎Creating a .CMD file to start NEOSYS Service:: Instructions repeated exactly for test and live database. The duplicate removed.)
 
(88 intermediate revisions by 12 users not shown)
Line 1: Line 1:
= INSTALLING NEOSYS SERVICE =
Reference to X:\ in the notes below denotes the actual drive letter and needs to be replaced (eg D:\)


== Main installation: ==
==Main installation:==


  Make sure NOT TO COPY an existing NEOSYS installation to another location and ONLY do a  
  Make sure NOT TO COPY an existing NEOSYS installation to another location and ONLY do a  
Line 7: Line 7:
  hidden configurations.  
  hidden configurations.  


=== Preparing server for installation ===
===Installing NEOSYS on partitions===
# Make sure not connected to domain controller
# Away in a secure place and secure power cable
# No services like IIS and no server roles are installed
# Preferably installed with more than one partition (C: D:)
# Make sure that the boot sequence is correct (CD,HDD,USB)
# Make sure that the Windows CD or I386 folder is copied to C Drive
 
=== Locating servers ===
Before installation, ensure that Clients servers should be placed out of public areas for safety and also to ensure that USB flash drives for NEOSYS backup cannot be misappropriated.
 
=== Installing NEOSYS on partitions ===
Good server management practice is to have separate partitions for operating system (C:) and data partitions (D:)
Good server management practice is to have separate partitions for operating system (C:) and data partitions (D:)
   
   
In the case of operating system reinstallation (which causes the loss of the C: partition) if NEOSYS programs and data were installed on D: can be preserved. If there is only one partition then NEOSYS programs and data will have to be backed up and restored.
In the case of operating system reinstallation (which causes the loss of the C: partition) if NEOSYS programs and data were installed on D: can be preserved. If there is only one partition then NEOSYS programs and data will have to be backed up and restored.


==== Multiple Partitions ====
====Multiple Partitions====
If there is more than one partition then NEOSYS should be installed on any partition (e.g. D:) except the operating system partition (usually C:).
NEOSYS MUST be installed on a different partition rather than the C drive for reasons already explained above (eg. D drive)


==== Single Partition ====
====Single Partition====
If there is only one partition then depending on the level of sophistication of the client it may be advisable to go to the effort of reinstall the operating system or using third party repartitioning tools to create separate partitions.
If there is only one partition then you have to inform the client to take the effort to reinstall the operating system or using third party repartitioning tools to create separate partitions.
   
   
Otherwise there is no overriding problem to have NEOSYS installed on the operating system.
===Downloading and running installation files===


=== Downloading and running installation files ===
#http://www.neosys.com/support/neosys.exe ... and unzip/install to X:\neosys (or to X:\hosts\client for multi-installation on one server where "client" is the client folder name which MUST be same as the main database code planned to be used, to reduce the number of codes that are in use. This folder name MUST also be in lower case to maintain consistency and be able to see deviations easily.)
# http://www.neosys.com/support/neosys.exe ... and install to X:\Neosys
#http://www.neosys.com/support/neosys2.exe ... and install same as previous step.
# http://www.neosys.com/support/neosys2.exe ... and install to X:\Neosys


=== Creating shortcuts ===
===Creating shortcuts===
In x:\Neosys, make a shortcut called ‘Maintenance’ and link it to
In x:\neosys (or x:\hosts\client), make a shortcut called ‘Maintenance’ and link it to


x:\neosys\neosys\adagency.bat (for Adagency install)
x:\neosys\neosys\adagency.bat (for Adagency install)
Line 44: Line 32:
x:\neosys\neosys\accounts.bat (for Accounts install)
x:\neosys\neosys\accounts.bat (for Accounts install)


=== Activating NEOSYS using authorization number ===
===Activating NEOSYS using authorization number===


Start NEOSYS Maintenance, select Initial Backup and it will give a “Computer Number” and ask for an “Authorisation No”
Start NEOSYS Maintenance, select Initial Backup and it will give a “Computer Number” and ask for an “Authorisation No”


Send the computer number to NEOSYS admin to get the authorization no.
Send the computer number to NEOSYS admin, email: admin@neosys.com to get the authorisation no. Do not leave the authorisation no. promt page open for a long time. This will cause the CPU usage to go to 100%.  


If you cannot get the authorization number immediately then you can close NEOSYS and when you reopen NEOSYS it will still give the same computer number and accept the same authorization number.
If you cannot get the authorisation number immediately then you can close NEOSYS and when you reopen NEOSYS it will still give the same computer number and accept the same authorisation number.


=== Installing initial Database ===
===Installing initial or Restoring Database===


Download the initial database file from http://www.neosys.com/support/BACKUP.ZIP and place it in C drive (or any other drive) - but make sure that this file exists in the root folder i.e. C:\BACKUP.ZIP
#Get backup file to be restored
##For new clients on win3, use "D:\DATA.BAK\STARTUP1\<current day of week>\BACKUP.ZIP" and for shifting clients use the latest backup copy available on backup media. For new clients on their own server, use the link ( http://www.neosys.com/support/STARTUP1.ZIP ) to get the most recent backup of STARTUP1 database.
##Place the backup zip file in root drive folder ("D:" or "C:")
#Restore the backup file
##Run Maintenance mode and login to "BASIC" database.
###If the window does not prompt for username/password, then go to Quit > Quit to next user. (Login with user/pass MUST be done otherwise NEOSYS will not allow restore)
###Check if command line appeared (like when you do F5), if no then press F5 to check if accessible and then Esc.
##Go to General > Backup & Data Management > Restore a backup (4th option).
###Select D drive (or whichever drive you put the backup zip file in) and follow the prompts ahead. (When asked "switch to new database?" ALWAYS choose NO)
###Press Esc, F5 and type "exit".
#Create clientLIVE and clientTEST databases
##For new clients
###Run Maintenance mode and login to "STARTUP1" database
###Delete "BASIC" database by going to General > Backup & Data Management > Delete Database
###Follow the instruction on how to decide on database code from the following link. [[Installing_NEOSYS_Service#Assigning_database_codes|Assigning database codes]]
###Go to General > Backup & Data Management > Create a new database (6th option) and follow prompts ahead. Create new clientLIVE database using the previously restored STARTUP1 database.
###Run Maintenance mode and login to the clientLIVE database. After logging in you will be prompted with "This database has been copied or the database name or code has been changed. <br> Is this going to be a unique new master database?" select first option YES - Going to be a new independent database.
###Delete "STARTUP1" database by going to General > Backup & Data Management > Delete Database
###Go to General > Backup & Data Management > Create a new database (6th option) and create clientTEST database using clientLIVE database
##For shifting clients
###Run Maintenance mode and login to the clientLIVE database.
###Delete "BASIC" database by going to General > Backup & Data Management > Delete Database
###Go to General > Backup & Data Management > Create a new database (6th option) and create clientTEST database using clientLIVE database
#Check only LIVE and TEST databases are available by going to General > Backup & Data Management > Reorder databases (8th option).


Next, click on the Maintenance icon, select BASIC DATA SET and type in the admin username and password. The first time when you enter maintenance you will get a command box (like when you do F5). If you do not get a command box, hit the F5 key to get one.
Note:


Type FILEMAN - and then select Restore from disk or diskette (which is no 4), select C drive (or whichever drive you put the backup.zip file in) and follow the prompts ahead.
#Sometimes it may tell you that you cannot use FILEMAN as you are logged in as MASTER. Hence you need to hit the ESC key, go to General > Backup & Data Management > Restore from disk or diskette, select C drive or whichever drive you put the backup zip file in and follow the prompts ahead.
#While doing the step no.2 if you get a message as below just hit enter or space and continue.
<pre>
▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒
▒╔═══════════════════════════════════════════════════════╗▒
▒║                                                      ║▒
▒║Unable to attach the "..\DATA\BASIC\ADAGENCY" volume.  ║▒
▒║                                                      ║▒
▒║─[FS109]────────────────────────────────────────      ║▒
▒║                                                      ║▒
▒║ Open or Create Media error.                          ║▒
▒║ The name "..\DATA\BASIC\ADAGENCY" is an              ║▒
▒║ invalid volume directory label.                      ║▒
▒║                                                      ║▒
▒║                  < Press any key >                    ║▒
▒╚═══════════════════════════════════════════════════════╝▒
▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒
</pre>


Sometimes it may tell you that you cannot use FILEMAN as you are logged in as MASTER. Hence you need to hit the ESC key, go to General > Backup & Data Management > Restore from disk or diskette, select C drive (or whichever drive you put the backup.zip file in) and follow the prompts ahead.
====Assigning database codes====
It is necessary to make sure that the following guidelines are met while creating database codes:


After you have restored the BACKUP.ZIP file, it will ask you to switch to this database, say NO - because the switch to database option here brings you back to the BASIC DATA SET. Hence press the ESC button, type EXIT on the F5 prompt and startup maintenance again and this time select the STARTUP DATABASE. After you have logged in, go to General > Backup & Data Management > Delete a data set and delete the BASIC DATA SET.
#The code MUST be within 8 letters
#The client MUST be instantly recognisable or as recognisable as possible from the main database code
#The test database code MUST END with the word "TEST" and it is not necessary that it must be recognisable.<br />The system needs to know if a database is "test" or not.<br />Otherwise test documents like invoices appear like real live documents potentially causing serious confusion. Many other internal problems will also occur.
#The test database code MUST sort alphabetically after the main database code at login. Prefixing the code with the letter X may achieve this.
#In cases where the company name consists of more than one word, make sure you choose the right combination which implies the company name clearly.
 
Examples of wrong and right database codes:


==== Assigning database codes ====
ALTO VISTA ADVERTISING
It is necessary to make sure that the following guidelines are met while creating database codes:


#The code should be within 8 letters
ALTOVIST and XALTTEST - right
#The client should be as recognisable as possible from the main database code
AVISTA and AVTEST - wrong - AVISTA is not as recognisable as ALTOVIST above
#The test database code should end with the TEST word and it is not necessary that it must be recognisable
#The test database code should always appear after the main database code at login
GLOBAL EDGE ADVERTISING


Examples of wrong and right database codes:
GLOBEDGE and XGLOTEST - right
GLOBEDAD or GLOBALED and XGEATEST - wrong - GLOBEAD and GLOBALED are not as recognisable as GLOBEDGE above
CONTEXTURE ASSOCIATES


  ALTO VISTA ADVERTISING          ALTOVIST and XALTTEST - right       AVISTA and AVTEST - wrong  (AVISTA not "as recognisable as possible")
  CONTEXT and XCONTEST - right
  CONTEXTURE ASSOCIATES            CONTEXT and XCONTEST - right        CONTEXT and CONTEST - wrong (CONTEST alphabetically first in the login screen database drop down)
  CONTEXT and CONTEST - wrong - CONTEST will be alphabetically first in the login screen database drop down


=== Creating a .CMD file to start NEOSYS Service: ===
===Creating a .CMD file to start NEOSYS Service:===
(Note: change x to the correct drive you have installed NEOSYS on)
(Note: change x to the correct drive you have installed NEOSYS on)


In x:\neosys create a file start MAIN-DATABASE-CODE.cmd (eg start ALTOVIST.cmd)
In x:\neosys create a file called "START MAIN-DATABASE-CODE.cmd". (e.g. "START ALTOVIST.CMD" and "START AVTEST.CMD")
 
Repeat the steps below for both the main and test database:


  x:
  x:
Line 86: Line 125:
  Start neosys.js /system ADAGENCY /database <b>databasecode</b>
  Start neosys.js /system ADAGENCY /database <b>databasecode</b>


(where <i>databasecode</i> is the code of the database)
#Change X to drive neosys is installed in.
(also you need to replace ADAGENCY with ACCOUNTS if this is an accounts only installation)
#Change path to where NEOSYS is installed. (E.g Win3 = "cd \hosts\<b>clientfolder</b>\NEOSYS\neosys" or on client hosted servers "\neosys\neosys")
#Where <b>databasecode</b> is the code of the database
#Also you need to replace ADAGENCY with ACCOUNTS if this is an accounts only installation.
#TEST THAT THE FILES YOU HAVE CREATED CAN RUN SUCCESSFULLY.
#ENSURE THAT YOU DO NOT CLOSE THE PROCESS WINDOWS BY USING THE X BUTTON. HIT ESC 3 TIMES ON EACH WINDOW.
 
===Differences for Pure Accounts Module Only Installations===
Accounts module only has a slightly different startup command. In the above, replace '''/system adagency''' with '''/system accounts''' to startup a service and use '''accounts.bat''' instead of '''adagency.bat''' to start up maintenance. Other than that, accounts module setup is identical. Pure accounts clients are very few and tend not to upgrade often so care needs to be taken when upgrading. Upgrade is done using the usual neosys2.exe file.


In x:\neosys create a file start TEST-DATABASE-CODE.cmd (eg start AVTEST.cmd)
===Setting up daily scheduled tasks===
NEOSYS is normally configured to backup and shutdown at 1 am.


x:
====If NEOSYS is installed on NEOSYS Server (win3)====
cd \neosys\neosys
Edit d:/hosts/STARTXXX.cmd (XXX could be MEA, USA etc. depending on the time zone of the client) to configure the client's live and test processes to start up automatically. As of 2016 TEST process is set to start first followed by LIVE processes for all clients in STARTXXX.cmd 
Start neosys.js /system ADAGENCY /database <b>testdatabasecode</b>
 
The number of live and test processes configured to startup in STARTMEA.cmd MUST be exactly the same as the number of processes configured in the client's system configuration file. Otherwise, if a client's required number of processes are not started up by STARTMEA.cmd, then that client's remaining required processes will automatically start up after a few minutes and may interfere with startups of other clients' processes, thus ruining the desired sequential startup of client processes.
 
Use web access and go to Support Menu, System Configuration File and set the following for a) tiny clients : 1 process for main database and 1 for test database or b) large clients : 2 processes for main database and 1 for test database c) very large clients who have issues regularly with no process available : 3 processes for main database and 1 for test database.


(where <b>testdatabasecode</b> is the code of the testdatabase)
Set up an automatic copy of the main database to test database as shown at the end of the next section. The copy is done immediately after the backup. Test running “Copy now” SHOULD be avoided while users are online.
(also you need to replace ADAGENCY with ACCOUNTS if this is an accounts only installation)


=== Differences for Pure Accounts Module Only Installations ===
====If NEOSYS is installed on client server====
Accounts module only has a slightly different startup command. In the above, replace '''/system adagency''' with '''/system accounts''' to startup a service and use '''accounts.bat''' instead of '''adagency.bat''' to start up maintenance. Other than that, accounts module setup is identical. Pure accounts clients are very few and tend not to upgrade often so care needs to be taken when upgrading. Upgrade is perhaps surprisingly done using the adagency.exe file.
A Windows Scheduled Task MUST be created to startup NEOSYS every day typically at 6 am.  
It can startup one live database process and that process will startup all other required database processes.  
Test databases will not startup other database processes automatically unless configured to do so from the System Configuration File.


=== Creating a .CMD file to copy maindata to testdata ===
On Windows 2008 Standard, untick highest privileges and untick run whether user is logged in or not. This means that NEOSYS processes will be visible on the desktop when you login BUT the windows scheduled tasks to startup NEOSYS will FAIL to run if the server is rebooted for any reason including power failure or when the monthly Windows Update procedure reboots.
(Note: change x to the correct drive you have installed NEOSYS on)


In x:\neosys create a file copymain2test.cmd
Alternatively, for clients which cannot tolerate manual intervention after server reboots for any reason (e.g.need to start work before NEOSYS support is available or on NEOSYS support weekends), tick "highest privileges" and "run whether the user is logged in or not". This approach means that NEOSYS processes which are started by the windows scheduled task are not visible on the desktop and run hidden in the background and only listed in task manager, so avoid this approach on small clients (only a few users). Windows Update is a common cause for server reboots so configure Updates to install at 3 AM on any day between Sunday to Thursday since on these days Support will be available to manually restart NEOSYS processes after a server restart.


xcopy x:\neosys\data\<i>maindatabasecode</i> x:\neosys\data\<i>testdatabasecode</i> /s /y
Create a task to start one Main database process at 6:00 am daily.


eg. xcopy c:\neosys\data\<i>ALTOVIST</i> x:\neosys\data\<i>AVTEST</i> /s /y
[[File:start1.jpg]]<br><br><br>
[[File:start2.jpg]]<br><br><br>
[[File:start3.jpg]]<br><br><br>


=== Setting up daily scheduled tasks ===
(For multiple sites on the same computer put the second site starting five minutes later at 6:05 am, the third site starting five minutes earlier at 5:55 am, the fourth site starting five minutes later at 6:10 am and so on.)
<b>Automatic Schedules:</b>
NEOSYS automatically shuts down at 1am (was 2am) every morning for backup. It closes all the running processes and backups up to the selected drive.


<b>Manually Configured Schedules:</b>
Once created, test them to see that they are working correctly by running them directly using right click- Run. There is no problem testing the “daily 6 am startup task” at any time since it will just add an additional process.
Automatic download & Install of Windows Update - to be configured at 3 am everyday


==== New Instructions ====
[[File:task1.jpg]]<br><br><br>
Main database 1 process starting at 6:00am.


Use Support Menu, System Configuration File to request 3 processes for main database and 1 for test database
Use web access and go to Support Menu, System Configuration File to request 3 processes for main database and 1 for test database. Also, set up an automatic copy of the main database to test database as below. The copy is done immediately after the backup. Test running “Copy now” SHOULD be avoided while users are online.


==== Old Instructions ====
[[File:autocopy.jpg]]<br><br><br>
Maindata – 1 process
Remaining processes (including testdata) need to be configured from NEOSYS web interface - Menu > Support > System Configuration File > Databases


===Configuring NEOSYS to start automatically on server start-up / reboot===
We no longer configure NEOSYS processes to start on reboot as we would like to know of the failures at the client side and hence whenever the server reboots we expect the client to inform us and we will start the process - or NEOSYS will start automatically next day at 6 am


Copy Maindata to Testdata – 1 process at 2:45 am
Unfortunately using this method the NEOSYS processes are not visible when you login as a user.  
For multiple sites on the same computer put the second site starting five minutes later at 6:05, third site starting five minutes earlier at 5:55, the third site starting five minutes later at 6:10 and so on.


=== Configuring NEOSYS to start automatically on server start-up / reboot ===
Unfortunately using this method the NEOSYS processes are not visible when you login as a user.
==== startall.cmd file ====
Make a startall.cmd file in the neosys folder something like this, where xxxx and xxxxtest are the names of the usual database start-up cmd files.
start cmd /c "start xxxx.cmd"
c:\cygwin\bin\sleep 5
start cmd /c "start xxxx.cmd"
c:\cygwin\bin\sleep 5
start cmd /c "start xxxx.cmd"
c:\cygwin\bin\sleep 5
start cmd /c "start xxxxtest.cmd"
c:\cygwin\bin\sleep 5
==== Windows scheduled task ====
[[Image:win_sch_task.jpg]]
[[Image:win_sch_task.jpg]]


Schedule a task to run the startall.cmd file whenever the computer starts
Schedule a task to run the main database file whenever the computer starts. In Windows 2008 you need to tick the options - Run whether user logged in or not and Run with highest privilege.
 
Additional in Windows 2008: Tick Highest Priviledges and Run whether user logged in or not


== Installing and upgrading NEOSYS pure accounting systems ==
==Installing and upgrading NEOSYS pure accounting systems==


Basic installation using NEOSYS.EXE and upgrades using NEOSYS2.EXE are identical to the normal adagency installation process.
Basic installation using NEOSYS.EXE and upgrades using NEOSYS2.EXE are identical to the normal adagency installation process.
Line 156: Line 189:
Differences are as follows:
Differences are as follows:


# Maintenance shortcut to ACCOUNTS.BAT
#Maintenance shortcut to ACCOUNTS.BAT
# Process startup file contains "/system ACCOUNTS" instead of "/system ADAGENCY"
#Process startup file contains "/system ACCOUNTS" instead of "/system ADAGENCY"
# Internet address is http://server/neosys/accounts.htm although it auto converts to http://server/neosys/default.htm??ACCOUNTS. Although not to be relied upon, the login page stores a cookie so even plain http://server/neosys or http://server/neosys/default.htm works thereafter until the cookie is lost. To get back to adagency login you use http://server/neosys/default.htm??ADAGENCY
#Internet address is http://server/neosys/accounts.htm although it auto converts to http://server/neosys/default.htm??ACCOUNTS. Although not to be relied upon, the login page stores a cookie so even plain http://server/neosys or http://server/neosys/default.htm works thereafter until the cookie is lost. To get back to adagency login you use http://server/neosys/default.htm??ADAGENCY
# BACKUP.ZIP files created by ADAGENCY systems and ACCOUNTS systems are slightly incompatible with the result that restoring one in the other type of system will not work. NEOSYS programmers can convert from one type to the other but it is almost never required since any ad agency that only requires accounts only module is given the adagency version of NEOSYS and accounting only clients becoming ad agencies never happened.
#BACKUP.ZIP files created by ADAGENCY systems and ACCOUNTS systems are slightly incompatible with the result that restoring one in the other type of system will not work. NEOSYS programmers can convert from one type to the other but it is almost never required since any ad agency that only requires accounts only module is given the adagency version of NEOSYS and accounting only clients becoming ad agencies never happened.

Latest revision as of 11:01, 26 February 2020

Reference to X:\ in the notes below denotes the actual drive letter and needs to be replaced (eg D:\)

Main installation:

Make sure NOT TO COPY an existing NEOSYS installation to another location and ONLY do a 
completely new install with a fresh database, because copying a folder will copy a variety of 
hidden configurations. 

Installing NEOSYS on partitions

Good server management practice is to have separate partitions for operating system (C:) and data partitions (D:)

In the case of operating system reinstallation (which causes the loss of the C: partition) if NEOSYS programs and data were installed on D: can be preserved. If there is only one partition then NEOSYS programs and data will have to be backed up and restored.

Multiple Partitions

NEOSYS MUST be installed on a different partition rather than the C drive for reasons already explained above (eg. D drive)

Single Partition

If there is only one partition then you have to inform the client to take the effort to reinstall the operating system or using third party repartitioning tools to create separate partitions.

Downloading and running installation files

  1. http://www.neosys.com/support/neosys.exe ... and unzip/install to X:\neosys (or to X:\hosts\client for multi-installation on one server where "client" is the client folder name which MUST be same as the main database code planned to be used, to reduce the number of codes that are in use. This folder name MUST also be in lower case to maintain consistency and be able to see deviations easily.)
  2. http://www.neosys.com/support/neosys2.exe ... and install same as previous step.

Creating shortcuts

In x:\neosys (or x:\hosts\client), make a shortcut called ‘Maintenance’ and link it to

x:\neosys\neosys\adagency.bat (for Adagency install)

or

x:\neosys\neosys\accounts.bat (for Accounts install)

Activating NEOSYS using authorization number

Start NEOSYS Maintenance, select Initial Backup and it will give a “Computer Number” and ask for an “Authorisation No”

Send the computer number to NEOSYS admin, email: admin@neosys.com to get the authorisation no. Do not leave the authorisation no. promt page open for a long time. This will cause the CPU usage to go to 100%.

If you cannot get the authorisation number immediately then you can close NEOSYS and when you reopen NEOSYS it will still give the same computer number and accept the same authorisation number.

Installing initial or Restoring Database

  1. Get backup file to be restored
    1. For new clients on win3, use "D:\DATA.BAK\STARTUP1\<current day of week>\BACKUP.ZIP" and for shifting clients use the latest backup copy available on backup media. For new clients on their own server, use the link ( http://www.neosys.com/support/STARTUP1.ZIP ) to get the most recent backup of STARTUP1 database.
    2. Place the backup zip file in root drive folder ("D:" or "C:")
  2. Restore the backup file
    1. Run Maintenance mode and login to "BASIC" database.
      1. If the window does not prompt for username/password, then go to Quit > Quit to next user. (Login with user/pass MUST be done otherwise NEOSYS will not allow restore)
      2. Check if command line appeared (like when you do F5), if no then press F5 to check if accessible and then Esc.
    2. Go to General > Backup & Data Management > Restore a backup (4th option).
      1. Select D drive (or whichever drive you put the backup zip file in) and follow the prompts ahead. (When asked "switch to new database?" ALWAYS choose NO)
      2. Press Esc, F5 and type "exit".
  3. Create clientLIVE and clientTEST databases
    1. For new clients
      1. Run Maintenance mode and login to "STARTUP1" database
      2. Delete "BASIC" database by going to General > Backup & Data Management > Delete Database
      3. Follow the instruction on how to decide on database code from the following link. Assigning database codes
      4. Go to General > Backup & Data Management > Create a new database (6th option) and follow prompts ahead. Create new clientLIVE database using the previously restored STARTUP1 database.
      5. Run Maintenance mode and login to the clientLIVE database. After logging in you will be prompted with "This database has been copied or the database name or code has been changed.
        Is this going to be a unique new master database?" select first option YES - Going to be a new independent database.
      6. Delete "STARTUP1" database by going to General > Backup & Data Management > Delete Database
      7. Go to General > Backup & Data Management > Create a new database (6th option) and create clientTEST database using clientLIVE database
    2. For shifting clients
      1. Run Maintenance mode and login to the clientLIVE database.
      2. Delete "BASIC" database by going to General > Backup & Data Management > Delete Database
      3. Go to General > Backup & Data Management > Create a new database (6th option) and create clientTEST database using clientLIVE database
  4. Check only LIVE and TEST databases are available by going to General > Backup & Data Management > Reorder databases (8th option).

Note:

  1. Sometimes it may tell you that you cannot use FILEMAN as you are logged in as MASTER. Hence you need to hit the ESC key, go to General > Backup & Data Management > Restore from disk or diskette, select C drive or whichever drive you put the backup zip file in and follow the prompts ahead.
  2. While doing the step no.2 if you get a message as below just hit enter or space and continue.
▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒
▒╔═══════════════════════════════════════════════════════╗▒
▒║                                                       ║▒
▒║Unable to attach the "..\DATA\BASIC\ADAGENCY" volume.  ║▒
▒║                                                       ║▒
▒║─[FS109]────────────────────────────────────────       ║▒
▒║                                                       ║▒
▒║ Open or Create Media error.                           ║▒
▒║ The name "..\DATA\BASIC\ADAGENCY" is an               ║▒
▒║ invalid volume directory label.                       ║▒
▒║                                                       ║▒
▒║                  < Press any key >                    ║▒
▒╚═══════════════════════════════════════════════════════╝▒
▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒

Assigning database codes

It is necessary to make sure that the following guidelines are met while creating database codes:

  1. The code MUST be within 8 letters
  2. The client MUST be instantly recognisable or as recognisable as possible from the main database code
  3. The test database code MUST END with the word "TEST" and it is not necessary that it must be recognisable.
    The system needs to know if a database is "test" or not.
    Otherwise test documents like invoices appear like real live documents potentially causing serious confusion. Many other internal problems will also occur.
  4. The test database code MUST sort alphabetically after the main database code at login. Prefixing the code with the letter X may achieve this.
  5. In cases where the company name consists of more than one word, make sure you choose the right combination which implies the company name clearly.

Examples of wrong and right database codes:

ALTO VISTA ADVERTISING

ALTOVIST and XALTTEST - right
AVISTA and AVTEST - wrong - AVISTA is not as recognisable as ALTOVIST above

GLOBAL EDGE ADVERTISING

GLOBEDGE and XGLOTEST - right
GLOBEDAD or GLOBALED and XGEATEST - wrong - GLOBEAD and GLOBALED are not as recognisable as GLOBEDGE above

CONTEXTURE ASSOCIATES

CONTEXT and XCONTEST - right
CONTEXT and CONTEST - wrong - CONTEST will be alphabetically first in the login screen database drop down

Creating a .CMD file to start NEOSYS Service:

(Note: change x to the correct drive you have installed NEOSYS on)

In x:\neosys create a file called "START MAIN-DATABASE-CODE.cmd". (e.g. "START ALTOVIST.CMD" and "START AVTEST.CMD")

Repeat the steps below for both the main and test database:

x:
cd \neosys\neosys
Start neosys.js /system ADAGENCY /database databasecode
  1. Change X to drive neosys is installed in.
  2. Change path to where NEOSYS is installed. (E.g Win3 = "cd \hosts\clientfolder\NEOSYS\neosys" or on client hosted servers "\neosys\neosys")
  3. Where databasecode is the code of the database
  4. Also you need to replace ADAGENCY with ACCOUNTS if this is an accounts only installation.
  5. TEST THAT THE FILES YOU HAVE CREATED CAN RUN SUCCESSFULLY.
  6. ENSURE THAT YOU DO NOT CLOSE THE PROCESS WINDOWS BY USING THE X BUTTON. HIT ESC 3 TIMES ON EACH WINDOW.

Differences for Pure Accounts Module Only Installations

Accounts module only has a slightly different startup command. In the above, replace /system adagency with /system accounts to startup a service and use accounts.bat instead of adagency.bat to start up maintenance. Other than that, accounts module setup is identical. Pure accounts clients are very few and tend not to upgrade often so care needs to be taken when upgrading. Upgrade is done using the usual neosys2.exe file.

Setting up daily scheduled tasks

NEOSYS is normally configured to backup and shutdown at 1 am.

If NEOSYS is installed on NEOSYS Server (win3)

Edit d:/hosts/STARTXXX.cmd (XXX could be MEA, USA etc. depending on the time zone of the client) to configure the client's live and test processes to start up automatically. As of 2016 TEST process is set to start first followed by LIVE processes for all clients in STARTXXX.cmd

The number of live and test processes configured to startup in STARTMEA.cmd MUST be exactly the same as the number of processes configured in the client's system configuration file. Otherwise, if a client's required number of processes are not started up by STARTMEA.cmd, then that client's remaining required processes will automatically start up after a few minutes and may interfere with startups of other clients' processes, thus ruining the desired sequential startup of client processes.

Use web access and go to Support Menu, System Configuration File and set the following for a) tiny clients : 1 process for main database and 1 for test database or b) large clients : 2 processes for main database and 1 for test database c) very large clients who have issues regularly with no process available : 3 processes for main database and 1 for test database.

Set up an automatic copy of the main database to test database as shown at the end of the next section. The copy is done immediately after the backup. Test running “Copy now” SHOULD be avoided while users are online.

If NEOSYS is installed on client server

A Windows Scheduled Task MUST be created to startup NEOSYS every day typically at 6 am. It can startup one live database process and that process will startup all other required database processes. Test databases will not startup other database processes automatically unless configured to do so from the System Configuration File.

On Windows 2008 Standard, untick highest privileges and untick run whether user is logged in or not. This means that NEOSYS processes will be visible on the desktop when you login BUT the windows scheduled tasks to startup NEOSYS will FAIL to run if the server is rebooted for any reason including power failure or when the monthly Windows Update procedure reboots.

Alternatively, for clients which cannot tolerate manual intervention after server reboots for any reason (e.g.need to start work before NEOSYS support is available or on NEOSYS support weekends), tick "highest privileges" and "run whether the user is logged in or not". This approach means that NEOSYS processes which are started by the windows scheduled task are not visible on the desktop and run hidden in the background and only listed in task manager, so avoid this approach on small clients (only a few users). Windows Update is a common cause for server reboots so configure Updates to install at 3 AM on any day between Sunday to Thursday since on these days Support will be available to manually restart NEOSYS processes after a server restart.

Create a task to start one Main database process at 6:00 am daily.

Start1.jpg


Start2.jpg


Start3.jpg


(For multiple sites on the same computer put the second site starting five minutes later at 6:05 am, the third site starting five minutes earlier at 5:55 am, the fourth site starting five minutes later at 6:10 am and so on.)

Once created, test them to see that they are working correctly by running them directly using right click- Run. There is no problem testing the “daily 6 am startup task” at any time since it will just add an additional process.

Task1.jpg


Use web access and go to Support Menu, System Configuration File to request 3 processes for main database and 1 for test database. Also, set up an automatic copy of the main database to test database as below. The copy is done immediately after the backup. Test running “Copy now” SHOULD be avoided while users are online.

Autocopy.jpg


Configuring NEOSYS to start automatically on server start-up / reboot

We no longer configure NEOSYS processes to start on reboot as we would like to know of the failures at the client side and hence whenever the server reboots we expect the client to inform us and we will start the process - or NEOSYS will start automatically next day at 6 am

Unfortunately using this method the NEOSYS processes are not visible when you login as a user.

Win sch task.jpg

Schedule a task to run the main database file whenever the computer starts. In Windows 2008 you need to tick the options - Run whether user logged in or not and Run with highest privilege.

Additional in Windows 2008: Tick Highest Priviledges and Run whether user logged in or not

Installing and upgrading NEOSYS pure accounting systems

Basic installation using NEOSYS.EXE and upgrades using NEOSYS2.EXE are identical to the normal adagency installation process.

Differences are as follows:

  1. Maintenance shortcut to ACCOUNTS.BAT
  2. Process startup file contains "/system ACCOUNTS" instead of "/system ADAGENCY"
  3. Internet address is http://server/neosys/accounts.htm although it auto converts to http://server/neosys/default.htm??ACCOUNTS. Although not to be relied upon, the login page stores a cookie so even plain http://server/neosys or http://server/neosys/default.htm works thereafter until the cookie is lost. To get back to adagency login you use http://server/neosys/default.htm??ADAGENCY
  4. BACKUP.ZIP files created by ADAGENCY systems and ACCOUNTS systems are slightly incompatible with the result that restoring one in the other type of system will not work. NEOSYS programmers can convert from one type to the other but it is almost never required since any ad agency that only requires accounts only module is given the adagency version of NEOSYS and accounting only clients becoming ad agencies never happened.