- Skype (http://www.skype.com/en/download-skype/skype-for-computer/)
- Cutewriter (pdf) (http://www.cutepdf.com/products/cutepdf/writer.asp) (optional)
- Winrar (http://www.rarlab.com/download.htm) or 7zip
- Teamviewer (http://www.teamviewer.com/en/download/windows.aspx)
- Printer driver (Dymo/Canon) (http://www.dymo.com/en-US/dymo-user-guides) (Optional, only if customer buy)
- SQLftpbackup – backup SQL database
- MS Office 2013 (Optional, only if customer buy)
- “Turn Windows Features on or off” in control panel, Install everything (main item “IIS”)
(NOTE: MUST INSTALL IIS FIRST, followed by .netframework 4.5.2, don’t install framework before IIS if NOT GOT ERROR)
- .net framework 4.5.2 (or latest) (http://www.microsoft.com/en-sg/download/details.aspx?id=42642)
- Vanda Client
- Vanda Web service
- Database backup restore
MS SQL express installation
download this “ENU\x64\SQLEXPRADV_x64_ENU.exe” - 1.3 GB
*MS SQL standard installation (Optional, only if customer buy)
Set as mixed mode authentication, input login ‘sa’ and password “Vanda650211” for standard version(or other specified password)
- ***DO THIS ONLY WHEN YOU ARE PROVIDED WITH BAK FILE, ELSE USE GET THE CORRECT INITIAL SCRIPT AND GENERATE A NEW DATABASE***
- Go to start and launch your SQL server management studio
- SQL management studio will open with a connect to server window to prompt you
- Under server type, select Database Engine
- Under Server name, key in your computer name or put “(local)” to make things easier
***For SQL server express, always key in computer name under server name field as (local) usually doesn’t work. ***THEREFORE express, you need servername to be .\SQLEXPRESS
- Under Authentication, use SQL server authentication. In some cases, there is only windows authentication. This happen when u did not select Mixed mode option during the installation process of SQL Server
- Under login, by default its always “sa”
- Under password, key in your desire password. Normally if it’s a server, we will use the server password.
- Remember the Server Name, login and password parameters as you will use it later on during the adding of web service to IIS
- Click connect once done
You will come to the main page of SQL management studio
- Right click on Database
- Select restore database
Restore Database window will be open. Do the following
- Select Device ‘…’ to browse the location
- Click on ‘Add’ to open up the windows explorer
- Browse through the windows directory to locate your .BAK File
- Click ‘Ok’ to select
- Click OK, u will go back to the specify backup window again
- Click OK again
- You will go back to restore database backup window
- Under select the backup sets to restore, select the last backup in the list as its always the latest backup
- Remember the name of the database as you will need it later on for adding of web service to IIS
Your settings will be like this
- Click OK once done to restore backup
- Once it’s the restore backup is successful, it will show a message box
saying database has been restored successfully.
- Click OK and you will go back to the main page of SQL management studio
To add Initial Script, do the following:
- Open SQL management studio
- Login with username and password then connect
- Under database, right-click and select new database
- Enter your desire database name and click OK when done
- Select the database that you have just created from the drop list beside the Execute button
- Remember your database name as you need it to add web service into IIS
Before we can install vanda, we need to have the following files
- Vanda.WS (Web Service (To be added into IIS))
- Vanda.Client (To run vanda after configuring all the other parameters)
- Database file (Get from the backup in SQL management studio or create a new database and run initial script. Backup file is in .BAK format or SQL Database format)
I will recommend putting all of them into one folder and naming it accordingly. For example, the best structure would be:
If they have D: (have a lot of space ) you can use D:
If not use C: if they only have 1 partition
Main folder D:/MAGICSOFT/
Has 3 folders - OTHERS [Rationale: stores all miscellaneous items/files including scripts]
- Upload [Rationale: stores only every Upload of Vanda UPDATE with date]
- VANDA [Rationale: mainly Vanda.Client & Vanda.WS & AutoUpdate Agent]
- The Client folder will be whatever version you have downloaded/obtained from magicsoft(depends)
*For Vanda versions Feb 2016 onwards*
- The Web Service folder normally contain the usual files (as per downloaded;
- Go to start, key in IIS under search programs and files and press enter.
- IIS will launch, u should see this
Under application pool, create a new application pool.
To create new application pool, do the following
- Click on application pool, Right Click and select Add application pool.
- An add application pool window will be shown
- Under name, key in the name of the application pool
- Under Framework version, Select .NET Framework 4.0
- Under managed pipeline mode, select integrated
- Click OK when done
- The new application pool will be added as shown
If your operating system is 64-bits, u will need to do this extra step to make Vanda web service work.
- Select the new application pool u have created
- Right Click and select Advanced Settings
- Advanced Settings window will be shown
Install IIS in Windows features
- Go to Control Panel
- Click on ‘Turn Windows features on or off’
- Select all
- Click ‘Ok’
(NOTE: remember to open up the [+] icon to tick everything properly)
To add the web service to IIS, do the following
- Under sites, Expand it
- Right Click on default web sites
- Select add application
- Add application window will be shown
- Under alias, key in the name which u want. This name will be part of the url address, for example: http://localhost/(alias name)/
- Under application pool, select the application pool which you have added just now
- Under physical path, select the location of the web service which you have stored in your directory and click OK
- The settings should be like this
Under default web site, expand it and you can see the web service that you have added
After adding the web service as application into the IIS, do the following:
Under default website, expand it then select the web service that has just been added. You should see this screen on the right.
- Click on Content view so that you can view the files inside this web service folder.
- Click on Explore under the Actions Menu on the right. It will open up the actual web service folder.
- Right Click on “Web”, then click open with Notepad. You should see this
- Look for the area under with the coding parameters like this:
Here u will need the server name, login and password which u have key in to access SQL management studio. You will also need to have the database name that you use to restore the .bak file or adding initial script in SQL management studio too. The parameters to be filled in respectively highlighted in red below.
- Under Data Source=Key in Server Name
- User ID=Key in Login
- Password=Key in Password
- Initial Catalog=Key in Name of the Database
- Do not edit other parameters except for the ones listed above.
- Use Ctrl+S to save the changes made to the notepad.
- Now return back to this IIS page.
- Select on AppService.asmx and click on Browse, under Actions menu on the right. Your default web browser will open. This is to test if the web service is configured correctly. If it’s successful, it will show this screen.
- Make sure you see something like above. It means webservice is setup correctly.
- If not, recheck the database connection configuration.
Remember the URL of this page. Example: localhost/vanda/AppService.asmx
- Now, open up the client folder. (do not worry, contents inside Vanda.Client folder may vary)
(BUT all should have Vanda.Client.exe config file)
- Select on Vanda.Client.exe config, open with notepad
- Under add key=”ServiceUrl” value=”http://localhost/vanda/AppService.asmx”/>, you will need to replace the URL with the one u have copy down when you browse your AppService.asmx in IIS. You only need to replace the one highlighted in red. Save the changes done.
- If you are not connecting the vanda client with the web service locally, you will need to replace the localhost with the IP address the of server/PC with the IIS web service. For example: http://192.168.1.20/vanda/AppService.asmx
- Close the notepad.
- The last step is to open up the vanda client by clicking on Vanda.Client.
- If the Login From shows a branch name, it is installed successfully.
If it shows ‘Loading branch list’, it could mean the Vanda.Client.Config file is wrong. Recheck.
So Summary of Vanda.Client user installation
PC user setup
- Copy “Vanda Client” folder to desired location
- Create shortcut to desktop
- Edit and Make sure the Vanda.Client.exe.Config is changed to http://<ServerPCname>:<port number>/AppService.asmx
Connect printer only after driver has been installed on PC
- After connecting to the printer
- Preferences, create new form
- Set label size (4 cm x 8 cm size)
- Enable inbound/outbound rule for port 82 (port number which is assigned for Vanda) in Windows Firewall
- Ensure Vanda.Reports.dll is ‘unblock’, (from its properties)
- Or remember to RIGHT CLICK > Properties on the Vanda.Client zip file which you have downloaded from TFS (if not you will encounter SANDBOX error message when running Vanda)
- IF VANDA suddenly cannot run for ALL PCs, says connection to database is not connected etc. (see screenshot below)
- 1) check NETWORK CONNECTION of the server PC and client PCs.
- 2) can check the server PC's SQL Server Service IS IT RUNNING PROPERLY.
- 3) can check if the server's IIS service is running properly?
- 4) from any affected client PC, try to visit the service URL (can get it from Vanda.Client.exe.Config)
if it still keeps on loading nothing and fails, even after step 1-3 above has been checked.
Please restart the SERVER PC.