SureTrend 4

Where is my SureTrend 4 database located?

By default, the database is located in this folder: C:\ProgramData\Hygiena\SureTrend and is called suretrend. It is a .sdf file.

You can verify where you are saving your data to in SureTrend 4 before backing it up by opening the software and clicking the Admin tab at the top of the program. Click Server Configuration Setting tab on the left. If your Config Type i set to SQLCe then you should see the location of your database in the Database Name box. Go to that location and backup that file before proceeding with any sort of SureTrend uninstallation or upgrade.

Does SureTrend support Virtual Desktop or RDP?

SureTrend can run on a Windows Terminal Servier (RDS), Citrix, or other VNC software that will remote the COM port from the server to the desktop. Since SureTrend is running on the server, but the unit is connected to the desktop COM port, communication to the Unit is directed over the network. If your network latency is too high you may get COM port communication failures that require you to repeat the synchronization process with the Unit. Also, the SureTrend feature that automatically detects the COM port will not work and user must know the COM port used on the desktop.

Does SureTrend support virtualization?

SureTrend will run on virtualized versions of Windows supported by SureTrend as long as the virtualization software supports COM ports or USB. Some users are running Windows 7 or 8 on their desktop computer, but spend most of their time in a Windows XP mode session to support other legacy applications in their organization. Having SureTrend run in the Windows XP mode helps the user stay in the Windows XP mode and not have to switch to the native desktop just to run SureTrend. You may use SureTrend in virtual machines created by tools such as VMWare.

Is there a version of SureTrend 4 for Mac?

SureTrend 4 was built for the Windows operating system only. It will not work on Mac hardware, even if installed in a virtual machine (VM) as there is no USB driver for Mac.

Can I run SureTrend 4 on a tablet?

SureTrend can only be run on tablets running a Microsoft Windows operating system. This does not include Windows RT and Windows S as those operating systems do not allow for the use of desktop-grade applications.

For a full list of software and hardware requirements click here.

keywords: windows rt

Receiving “Network Connection Lost” message

Possible solutions:

  1. Delete the unit in the Units tab and re-add it by doing a sync.
  2. Uninstall and re-install SureTrend. Make sure to backup your database first.
  3. Replace your database with a blank, new one (download from the footer below). You can import your users, locations, and plans from your original database using the Import Data feature.

I am unable to import from Excel

There can be a number of reasons why this would not work. You could be missing prerequisites SureTrend requires for this feature to work successfully. You may also have an improperly formatted Excel spreadsheet. In order to make sure the formatting is correct download our official Excel template (download from the footer below). Use this as a guide. If you still encounter issues importing data from Excel contact a Hygiena representative to help you through the process.

Locations / Users / Plans are not syncing to device

In order to have new programming data (i.e. locations, users, plans, date/time changes) sync over to your device you need to choose Complete Process on the Sync tab and make sure the Erase Results box is checked. Keep in mind you will lose all results currently on the unit unless you sync them prior to doing this. On the units tab make sure you see the red text, Unit data has been modified… If you do not see this text try adding a dummy location or plan to initiate a response from SureTrend and then delete it. You can then sync and the changes will be sent to your device.

I have synced results but can’t see them

Always verify the results you are trying to see in SureTrend actually exist on the device first! Make sure the data and time is correct on your unit. When batteries die or are replaced the data and time resets. If you take results with an incorrect date/time and sync them they could get lost in SureTrend amongst other results.

Be sure you do not have any filtering in place that could be limiting what you see. Make sure your syncs were successful and the sync log shows data was actually imported from the device.

I am seeing results that aren’t mine

You most likely have been setup to a shared database. This means you can see synced results of other people connected to the database and they can see anything you sync as well. There is no way to prevent this, but you can use filtering to limit what you see to only what you care about. When working with reports, create custom reports and only include the units, users, plans or locations that interest you so the rest are not shown.

SureTrend is asking for a username and password at startup

SureTrend should never ask for a username or password. If it asks you to login when starting up that means it cannot connect to its database properly. If you just installed SureTrend on a server make sure you have HTTP Activation enabled and try starting the application again. If you have just installed SureTrend on a PC and are receiving this uninstall it and reinstall it without checking the ‘Multiuser – Distributed’ checkbox.

I renamed my database and now SureTrend won’t start

Change the name of your SureTrend database back to what it was prior to you changing it. SureTrend should start now. Copy and paste the database and rename the copied file to the new name you want leaving the original database file alone. Now in SureTrend navigate to the Admin Tab and go to Server Configuration Setting. If your Config Type is SQLCe you can change the database to the newly named one. Save and restart SureTrend. Make sure SureTrend starts and go back to Server Configuration Setting to verify it is using the newly named database file. If everything was successful you may delete your old database file.

I moved my database and now SureTrend won’t start

Move the database back to it is original location prior to you moving it. SureTrend should start now. Copy and paste the database to its new location leaving the original database file alone. Now in SureTrend navigate to the Admin Tab and go to Server Configuration Setting. If your Config Type is SQLCe you can change the database location now to point to the new location. Save and restart SureTrend. Make sure SureTrend starts and go back to Server Configuration Setting to verify it is using the newly located database file. If everything was successful you may delete your old database file.

SureTrend or syncing is slow

If SureTrend is located on a machine with less than 4GB of RAM or an older generation CPU you may experience some slowness navigating around the application or syncing.

If the database you are connecting to is located on a network file share the syncing and reporting process will take longer. How much longer depends on your network bandwidth utilization and capabilities. Sharing a SureTrend database on a server or using our SQL server option instead may make the process a lot faster.

Check my SureTrend version

 
 
 
 
 
If you are running SureTrend 4.x you can find your version by going to the Admin tab and click on the About tab on the lower left. You will see what version and build you currently have installed.

If you are running SureTrend 2 or 3 you will not see the tabs shown above in your software.

Maximum location name length

Location names in SureTrend can hold up to 20 characters. This restriction (not present in versions of SureTrend prior to version 4 ) is in place due to the devices only being able to display up to 20 characters on screen.

Device and software limitations

SureTrend

  • 5000 maximum locations
  • 200 maximum users
  • 100 maximum plans
  • 250 maximum locations per plan

Luminometer

  • 2000 maximum results

What is the database password?

The default database password for suretrend.sdf is systemsure.


Important

This password should never be changed unless it is absolutely necessary for security concerns. Tampering with it could lead to permanent data loss!

Where is my data located?

For SQLce and Distributed installations

By default SureTrend’s database file, suretrend.sdf, is located at

C:\ProgramData\Hygiena\SureTrend\

For SQL Server installations

Data is located in a Microsoft SQL Server database.