Layout Not Found errors when running reports

When running a new report for the first time, you may run across an error message indicating that the layout cannot be found or the layout does not exist. This is common right after performing an update in which new reports were added to the program.

When adding new reports to ProfitFab, we generate a standard default layout to include with the program. However, we cannot overwrite your layout files during the update, or else you would lose all of the layouts you have modified for yourself in the Report Designer. What we do for new reports in the program is generate a special layout file that you use to import the default layouts into your layout file.

Here is the procedure for importing new layouts.

Open the Report Designer and select Files, then Open Layout. In the Opening Layout screen, the Reports are listed on the left and the layouts on the right. Scroll through the list of Reports (you can use your down-arrow key to scroll one report at a time) and write down the name of each report that has no layout associated with it. When you have gone through the entire list, click the Cancel button to close the screen.

Next, select Files, then Import Layout.

In the “Select file to import from” dialog, enter the filename as RDIMPORT.TPS, or browse through the list of files to find this file (RDIMPORT stands for ReportDesignerIMPORT). Press the Open button to open the Import Layouts dialog.

The Import Layouts dialog lists the Reports on the right and the layouts on the left. Scroll through the Reports to find the reports you wrote down previously.

Select the Layout name and click the Import button to import the layout. You should see numbers flickering on the screen just below the list of reports. These represent the fields being imported. When they go away, the import is complete for that layout.

Repeat this procedure for the remaining reports on your list.

After the layout(s) has been imported, exit the “Imports Layouts” dialog and go to Files, then Open Layout and select each report to mark the layout as default. This step is optional, however, if there is only one layout for the report, marking it as the Default Layout will allow ProfitFab to automatically print to that layout without bringing up a Select Layout screen each time you print it.

Error in LOG file after updating to v26

In ProfitFab v26, we have repurposed a previously unused data file called “LOG.TPS”. This file was used a number of versions ago for, among other things, RFID tracking and has not been used for many years. Some customers may experience an error message indicating there is an error, or invalid record declaration in the LOG file after updating to ProfitFab v26.

This problem has been addressed and is now resolved in the latest update program which is available through our download page. If you’ve already run the update, and are receiving an error when launching ProfitFab about the LOG file, you will need to manually delete the LOG.TPS file located in your ProfitFab folder.

To remove the LOG.TPS file, you will first need to find and open the folder where your ProfitFab files are stored.

  1. Right-click the icon on your desktop used to launch ProfitFab, then click “Properties”.
  2. Click the “Open File Location” button. This will open a file explorer window listing all the files in your ProfitFab folder, including application and data files.
  3. Click the “Name” header, to sort the files in name order.
  4. Scroll through the list until you locate the LOG.TPS file. Depending on your system settings, you may just see “LOG” with either “Clarion TPS data file” or “TPS file” under the “Type” column.
  5. Right-click on the LOG.TPS file.
  6. Click “Delete”.

ProfitFab should now open normally. If you have any further problems, please don’t hesitate to contact our support staff!

Gmail: Review blocked sign-in attempt

Sending email from ProfitFab using a Google Suite (formerly known as Google Apps) Gmail account may result in an error if allowing access to less secure apps is disabled. You may also receive an email from Google with the subject “Review blocked sign-in attempt”.

If this is the case, please follow the instructions contained within the email on enabling access to less secure apps.

To manually change this setting, visit your Google account page. Find the “Connected apps & sites” section under “Sign in & security”. Scroll to the bottom and click the slider to “Allow less secure apps: ON”. If you do not see this section, you do not have sufficient rights to modify this setting. Contact your domain administrator.

ProfitFab and Windows 10

Will ProfitFab run on Windows 10?

With the release of Windows 10 and the free upgrade period coming to an end, we get asked this question quite often.

The short answer is Yes.

We have several customers that have already made the switch and are running the latest version of ProfitFab on Windows 10 without any issues. Some of our development staff uses Windows 10, and our in-house test network also uses Windows 10 as a server to host the ProfitFab data files. We have yet to uncover any problems with running ProfitFab on Windows 10.

However, we have had one report of fonts being blurred on report previews (viewing reports to the screen). So far, we have not been able to replicate this issue, nor have we had anyone else report the same issue.

Also keep in mind this is a new operating system, and this will result in ProfitFab appearing slightly different. Fonts may appear different, buttons, browses, windows, etc will all appear slightly different than before.

Early versions of ProfitFab

Earlier versions of ProfitFab may have issues with Windows 10 that were introduced with the release of Windows 8. These issues were addressed and resolved in v24. If you are running any version of ProfitFab prior to v24, it is not recommended that you upgrade to Windows 10 without also upgrading to the latest version of ProfitFab. Customers with a current subscription to the UPP can download the latest version of ProfitFab that is compatible with Windows 10.

Database Backup and Restore

The database files are the heart and soul of ProfitFab. Having a reliable backup and recovery system is like an insurance policy against accidental loss of data due to database corruption, hardware failures, and even natural disasters. In this post, we will discuss some important points to consider when making backups of your ProfitFab program and data files.

Before Making a Backup

Make sure all running instances of ProfitFab (the admin program and Shopclock module) are closed. If running on a single-user system, make sure your running copy of ProfitFab is closed. If on a network environment, make sure all running copies on all workstations are closed.

Although there are some backup solutions that allow the safe backup of open files, we still highly recommend backing up during a time when all running instances of ProfitFab are closed. This will prevent the possibility of the backup copy of your database from becoming corrupt, or parent/child file relationships from getting out of sync during the backup process. If ProfitFab updates any one of the database files during the time it is being backed up, the header information in the backup file will not match its content, causing a corruption in the backup copy of that particular database file.

What to Backup

ProfitFab is completely self-contained in its installation folder. Usually “C:\ProfitFab” on a single-user installation, or in the “ProfitFab” folder on your server in a typical network installation. We recommend backing up all files in this folder to maintain compatibility between the version of ProfitFab you’re backing up, and its database files. This is very important when making a backup prior to updating ProfitFab that requires a database conversion.

The database files ProfitFab uses all end with the “TPS” extension. (TopSpeed Database) These are the most critical files that need to be backed up. These files cannot be replaced if lost or damaged, unlike the application files (EXE, DLL, etc) that can be reinstalled.

How to Restore

Like backing up, before restoring, make sure there are no running instances of ProfitFab. When recovering from a disaster situation (crashed server), or moving to a new server, this most likely won’t be an issue. However, if the need to restore some or all database files, for example, to recover missing customer records, or revert to a prior dataset, it is critical that all running instances of ProfitFab are closed to prevent potential data corruption during the restore process.

Depending on your situation, you may need to restore some or all of the database files, and/or the ProfitFab application files. In either case, care must be taken to ensure that the application files match with the database version; otherwise, you’ll receive an “Invalid Record Declaration” error.

Important Considerations

It is crucial that you have a disaster recovery plan in place, not only for ProfitFab, but for all critical data your company relies upon. The following questions address some things you may want to consider when creating a backup and recovery plan for your business.

  • How often does the data change?
    The frequency of changes made to your data can affect your decision on how often data needs to be backed up. Data that changes daily would typically need to be backed up daily. When recovering data from a backup, any data created since the time of your most recent backup would need to be recreated. Deciding how much data you are comfortable recreating will help in determining the frequency of your backup.
  • How quickly do you need to recover the data?
    Time is an important factor in creating a backup plan. Keep in mind the location of your backup sets, who has access to them, and how quickly you’ll be able to retrieve them.
  • What is the best time to schedule backups?
    Scheduling backups when system use is as low as possible is ideal. However, you can’t always schedule backups for off-peak hours, so you’ll need to carefully plan when key system data is backed up.
  • Do you need to store backups off-site?
    Storing backup sets off-site is essential to recovering your system in the case of a natural disaster. Storing backups in the cloud, or on removable media (external hard drives, tape drives, thumb drives, etc.) that can be taken off-site are some ways of storing off-site backups.
  • Who will be responsible for the backup and recovery plan?
    You need at least one primary contact for the organization’s backup and recovery plan. This person may also be responsible for performing the actual backup and recovery of data.
  • How many backup sets are needed?
    It may be necessary to recover a file or files from an earlier point in time from your latest backup. For this reason, it is generally a good idea to maintain a history of several backup sets.
  • Who will monitor the status of the backups?
    Backups are useless if they are corrupt or not being created. Someone will need to occasionally check the status of the backups, ensure that they are still being made on schedule and that the backup contents are not corrupt and can still be read. One way to do this is to run through a “drill”. Restore data from your latest backup to a temporary location, and check the validity of the data that is restored. Can you still access/read the data? Was everything you expected restored?

Ultimately, it is your IT administrator’s job to create a disaster recovery plan that best suits your company’s needs. There is no, one solution that fits everyone’s needs. We hope this post will help you make better decisions when it comes to backing up ProfitFab, and other mission-critical data for your company.