CAUTION: Full uploads should no longer be performed in any situation, whether data related or for troubleshooting upsys issues. They are more trouble than they are worth, and will end up causing you a major headache – avoid them completely.
Upsys is a Windows service developed by our team, that creates a communication channel between our servers that all iOffice data is contained on, and the local server running on every POS in every salon we support. If any change happens on either side, Upsys will look for those changes and send them in whichever direction they need to go.
Example 1: A salon owner is making changes to permissions on iOffice for one of their stores, after making the changes and saving the page – Upsys will recognize that these adjustments have been made and it will relay them to the particular salon that the owner made changes to.
Example 2: A busy supercuts is completing ticket after ticket, employees are clocking in and out for lunches, and the manager has added a few new products to the system. ALL of these things are relayed by Upsys from the salon’s computer, to iOffice where the owner can see the changes!
Because SuperSalon and iOffice are both designed to always change the dirty_bit value to ‘1’ when data is inserted or updated, this means that data that has been pulled out and uploaded (dirty_bit=2) but is then changed before the dirty_bit is reset to 0, will have its dirty_bit changed back to ‘1’, which is then ignored when dirty_bits are “cleared” (set to 0) after a successful upload. As a result, this changed row will still have a dirty_bit value of ‘1’, and will thus get picked up in the next upload. (This was not the case with the old upload system.)
Go to ioffice.supersalon.com/update on the salon’s POS, and download the latest version of upsys.
Right click the file, select run as administrator and wait a few seconds for the patch to run. This will load the installer into the C:\SuperSalon\upsys file directory.
Open Windows Command Prompt as administrator.
Tell Windows where the file that needs to be installed is, by typing cd C:\SuperSalon\upsys and hitting enter.
Install the Upsys service using Command Prompt, by typing upsys_ctl install and hitting enter.
On admin, go to the tools tab and paste the store’s database name into the Upsys Username field, under the Upsys Password Generator section. Be absolutely sure that you have the correct database name, you can cause serious damage if you make a mistake here.
Click the generate button, and make sure that a Password Release Key and Upsys Password generate.
On the salon’s POS, go to Setup → Internet Setup and make sure that the Upload Host and Upload Username are correct! This is how the POS knows where the data needs to go, and the database name associated with it.
2. Click the Click to Change button, and follow the prompts to enter the Release Key and Password you generated in the previous step.
3. This will complete the registration process, and an upload can now be completed.
Your main tool here is going to be the Upload Overview page found on SuperSalon under Setup → Internet Setup, which may be where you found the problem to begin with. During troubleshooting this problem, you will frequently reference this page to confirm if the upload service has corrected itself or not.
Start by checking the most recent upload via Setup → Internet Setup → Upload Overview and click on the latest upload.
You may see an Upsys Array Error – complete the troubleshooting below to fix this problem.
Another possibility is that the upload is stuck at a certain percentage, and won’t continue any further.
Lastly, the last upload may have been some time ago (check the date) and some further troubleshooting may be necessary.
To troubleshoot, try to restart the Upsys service in the SuperSalon UI-
Go to Setup → Internet Setup → Upsys Status.
Scroll down and you may find the Server State is either Running or Stopped.
Either way, click the Restart Service button at the bottom of the page. It may take a moment or two, but the page will refresh once it completes and you may see that the status is changed to Running.
Check the Upload Overview page to find the status of the upload, and try to complete a new upload via Manager → Upload!
If step two doesn’t work, you may need to try a few more things-
Reboot the salon’s PC. Check the Upload Overview page again, as this may be all that is necessary in some cases.
If the service is still stopped or stuck, open Windows Command Prompt as administrator, and try stopping Upsys with the command stop.
Start the upsys service again by using the command net start upsys.
Check the Upload Overview page again to see if the service is still stopped or stuck.
Run the Clear Database Schema tool on Admin:
Copy the store’s database name from it’s admin page.
Go to Admin → Tools and scroll down to the Clear Database Schema tool.
Paste the database name into the given field, and click the Find Database button.
On the salon’s POS, go to Setup → Utilities → Upload Options and run a Full Stop.
Complete a standard upload (NOT a full upload!), which may give you an error: Try 1 more upload, and it should work that time (and may also work on the first try).
Try Uninstalling Upsys by following the guide in the panel below!
If all else fails, or it seems like the issue persists even after support troubleshooting, check with an experienced agent, or create an escalation.
In computer programming, developers frequently use a method called “commenting” in their code. This allows them to leave a side note to themselves or other developers, or to otherwise exclude a chunk of code for one reason or another. In some situations, ProPoint Support agents need to do this with a small line of code that enables Upsys as a possible option in SuperSalon:
Go to C:\SuperSalon\Apache24\conf and open the file titled httpd.conf in notepad. This is the configuration file which the Apache server uses to function, and is part of SuperSalon operation.
Use ctrl+f and search upsys to locate the line of code you need to change.
3. Take note of how the lines above and below the Upsys line have a hashtag in front of them, this is what turns a line of code into a “comment”, excluding it from being used in the program.
4. To exclude Upsys from the Apache configuration file, place 1 hashtag in front of Include conf/extra/httpd-upsys.conf and save the file.
5. Open Windows Command Prompt as administrator, and type upsys_ctl.bat remove and follow it up by stopping and starting the Apache service.
6. Delete the upsys folder in C:\SuperSalon.
Stop the Upsys service, via services.msc or using the command net stop upsys in Windows Command Prompt. If it won’t stop, reboot the PC.
Go to C:\SuperSalon and delete the upsys folder. If Windows will not allow you to do this, Upsys may still be running – check services.msc again.
From here you will most likely be Installing Upsys back onto the system.
In some cases this error may be found directly on an upload, or it may be displayed on the Setup → Internet Setup page, preventing you from viewing or using the page. Follow the methods below to address this problem.
Go to C:\SuperSalon\Upsys and rename or delete the file titled upsys.dat.
Try going back to Internet Setup to see if the error persists.
Uninstall Upsys, and reinstall it if steps 1 and 2 do not work!
If all else fails, or it seems like the issue persists even after support troubleshooting, check with an experienced agent, or create an escalation.
When uploads are failing due to a schema issue, there is a ready-made tool available in Admin that should clear the issue almost immediately. The image below shows the location of this tool, and instructions for its use follow.
In Admin, go to Tools, and scroll to the bottom of the page.
Enter the DB name into the text field of the “Clear Schema Cache” tool.
Click the button on the bottom labeled “Find Database“.
This should clear the issue, and run a standard upload during the next interval. To confirm the issue is resolved, manually perform an upload and test the results.
The UpSys installs a new Windows service into the Service Control Manager (SCM) named, unsurprisingly, “UpSys”. This service is controllable just like any other Windows service — via the net start/stop command (e.g. net start upsys), or via the SCM GUI window — and starts up automatically on Windows start-up. The service is responsible for monitoring the UpSys settings and for determining the next scheduled run of the upload client and, when that time comes, starting the client as a separate parallel process and monitoring it to ensure it does not hang.By default, the UpSys service wakes up every 2 seconds to perform its tasks, including monitoring a running client process; a client process is terminated if it runs for more than 2 hours (again, by default).
Upsys uses a database field called dirty_bit to that becomes toggled whenever a change is made in SuperSalon or iOffice on every single row (meaning everything!). The dirty_bit field can have 5 different values: 0: This row has not changed since it was last uploaded; “clean”. 1: This row has changed since it was last uploaded; “dirty”. 2: This row is currently being uploaded. 3: This row has just been inserted/updated. 4: *Reserved*