TSI 804x Porta Count Installation Guide

Contents hide
1 804x Porta Count
2 Product Information
2.1 Specifications
3 Product Usage Instructions
3.1 Category 1: No current data
3.2 Category 2: Currently store data in SQL Lite with FPU
4 FAQ
4.1 Q: Are the steps for Category 1 and Category 2 one-time only?
4.2 Documents / Resources
4.2.1 References

804x Porta Count

“

Product Information

Specifications

  • Product Name: SQL Server PortaCountTM 804x
  • Version: Detailed Instructions V2
  • Publication: Application Note RFT-027 (US) September 2024

Product Usage Instructions

Category 1: No current data

  1. DBA Steps:
    1. CreateFitPro4Tables.sql
  2. Start FPU.
  3. Give a name for the SQL Server DB, then type in the DB string
    given by DBA to connect to the DB.
  4. Select the Data Management option:
    1. Save the database information and Save it.
    2. Open the side menu and make the SQL Server active.
  5. Exit FPU.
  6. Go back into FPU.

Category 2: Currently store data in SQL Lite with FPU

  1. DBA Steps:
    1. CreateFitPro4Tables.sql
  2. Start FPU.
  3. Give a name for the SQL Server DB, then type in the DB string
    given by DBA to connect to the DB.
  4. Select the Data Management option:
    1. Select the Database table(s), the delimiter and Location.
    2. Click the Export button.
  5. Importing into SQL Server:
    1. Select Data Management.
    2. Select Import from the side menu.
    3. Repeat the process for each table.
  6. Exit FPU.
  7. Start FPU and make the SQL Server active from the side
    menu.

FAQ

Q: Are the steps for Category 1 and Category 2 one-time
only?

A: Yes, the steps for Category 1 and Category 2 are one-time
only as long as the customer continues with the new data management
approach of SQL Server. If switching to SQL Lite and then back to
SQL Server, additional steps will be required.

“`

View Fullscreen

SQL Server PortaCountTM 804x
Detailed Instructions V2
Application Note RFT-027 (US) September 2024
Based on current data approach, customers seeking SQL Server with 804x/FPU fall into four categories:
FitProTM Ultra software includes a set of support files (README.pdf and four SQL script files) that are distributed with the software.
*The support files are located in the FitProTM Ultra installation directory (typically “C:Program Files (x86)TSIFitPro Ultra”) in a folder called, “MS SQL Support”.
CATEGORY 1: No current data New, first time 804x customers (never owned any prior version of PortaCountTM fit tester). These customers are in the process of purchasing (1 or more) 804x units and for a variety of reasons#, these customers are required to use SQL Server from the very get-go, and do not have any prior data to migrate.
Steps (to begin using SQL Server for 804x/FPU) 1. DBA Steps**
a. Create DB. b. Run SQL script to create FPU tables ­
“CreateFitPro4Tables.sql”. 2. Start FPU. 3. Give a name for the SQL Server DB, then type in
the DB string (given by DBA) to connect to DB. a. Select the “Data Management” option.
**Step 1 (DBA Steps) is a common step for all four customer categories. TSI® does not provide SQL server software – this is a Microsoft® product) required to be purchased by customer. The minimum version SQL Server required to work with FPU is MS SQL Server 2016 (but you can use newer versions). The customer’s Database Admin (IT Dept.) needs to do this #Variety of reasons include information security and data storage policy, expected high volumes of fit tests, etc.
www.tsi.com

b. Save the database information and “Save” it. c. Open the side menu and make the
SQL Server active. 4. Exit FPU. 5. Go back into FPU.
NOTICE These steps need to be performed for every computer that will connect to the instrument(s). Steps above are one-time only, so long as customer moves forward to the new data management approach of SQL Server. If at some point the customer switches to SQL Lite and creates SQL Lite data which later need to be moved over to SQL Server, then they would need to follow instructions in Category 2.
CATEGORY 2: Currently store data in SQL Lite with FPU Existing customers who already own (1 or more) 804x units. These customers have been using SQL Lite data management option in FPU, but now for a variety of reasons#, are seeking to switch over to SQL Server option being offered with FPU and they need to migrate all their stored SQL Lite data into SQL Server.
Steps* (to begin using SQL Server for 804x/FPU) 1. DBA Steps.**
a. Create DB. b. Run SQL script to create FPU tables ­
“CreateFitPro4Tables.sql”. 2. Start FPU. 3. Give a name for the SQL Server DB, then type in the
DB string (given by DBA) to connect to DB. a. Select the “Data Management” option. b. Save the database information and “Save” it.
4. Export (from SQL Lite DB) ­ a. Select Data Management. b. Make the SQLite database the active database and then select “Export”.
**Step 1 (DBA Steps) is a common step for all four customer categories. TSI® does not provide SQL server software – this is a Microsoft product) required to be purchased by customer. The minimum version SQL Server required to work with FPU is MS SQL Server 2016 (but you can use newer versions). The customer’s Database Admin (IT Dept.) needs to do this #Variety of reasons include information security and data storage policy, expected high volumes of fit tests, etc.
-2-

5. Select the Database table(s), the delimiter and Location. The Location is the Location displayed in the previous screen.
6. Click the “Export” button.
7. Importing into SQL Server. a. Select Data Management. b. Open the side menu again and select “Import”. The form shown will appear. c. Do this same process for each of the tables.
8. Exit FPU. 9. Start FPU.
a. Open the side menu and make the SQL Server active.
NOTICE These steps need to be performed for every computer that will connect to the instrument(s). These steps need to be performed per SQL Lite DB that needs to be migrated to SQL Server. If the DBs have some duplicate data between them, the import step in FPU will prompt for “override” or “skip” for each duplicate. Steps above are one-time only, so long as customer moves forward to the new data management approach of SQL Server and retires current data management approach. If at some point the customer switches to SQL Lite and creates SQL Lite FPU data which later need to be moved over to SQL Server FPU data, then they would need to repeat these instructions under Category 2.
-3-

CATEGORY 3: Currently store data in Access with FP+ Existing customers, owning (1 or more) 803x units, and in process of upgrading (some or all) 803x to 804x units. Currently these customers use Access data management option in FP+. For a variety of reasons# they seek the SQL Server data management option when they upgrade to 804x. They need to migrate their stored FP+ data into SQL Server and this data migration needs to be performed during the 804x upgrade. Steps* (to begin using SQL Server for 804x/FPU) 1. DBA Steps.**
a. Create DB. b. Run SQL script to create FPU tables ­
“CreateFitPro4Tables.sql”. 2. Start FPU. 3. Give a name for the SQL Server DB, then type in the DB
string (given by DBA) to connect to DB. a. Select the “Data Management” option. b. Save the database information and “Save” it. 4. Exit FPU. 5. Start FP+. 6. Export FP+ data ­ note the directory and name of the .csv file. a. Go to “Data Record Tools” in the “Database”
menu option.
**Step 1 (DBA Steps) is a common step for all four customer categories. TSI® does not provide SQL server software – this is a Microsoft product) required to be purchased by customer. The minimum version SQL Server required to work with FPU is MS SQL Server 2016 (but you can use newer versions). The customer’s Database Admin (IT Dept.) needs to do this #Variety of reasons include information security and data storage policy, expected high volumes of fit tests, etc.
-4-

b. Select the Source database. Click on the “Text File” tab.
c. Select the “Comma” Column delimiter, “UTF-8” Text encoding, and table (Record type to export).
d. Select a “Destination File”. This is the file that will be imported into FitProTM Ultra software.
e. Click “Export”. This creates a file, here named FITTEST_People.csv.
f. Repeat this same process for each of the tables listed (People, Respirator, Protocol, Fit test and Daily Check).
7. Exit FP+. 8. Start FPU.
a. Select the “Data Management” option. Add the new SQL Server database to the application if it has not been previously installed.
b. Open the side menu and make the SQL Server active.
c. Open the side menu again and select “Import”. The form shown will appear.
d. Select the “DATABASE TABLE” and the delimiter (Comma) as selected when exporting from the FitProTM Plus database.
e. At this point duplicate records can either be added or overwritten in the new database.
f. Enter (or browse) to the location of the exported (.CSV) file and select it. Press “IMPORT”. The data should be transferred to the SQL Server database. A message will be displayed indicating the number of records transferred.
g. Repeat this process for each of the other tables listed in FitProTM Plus (People, Respirators, Fit test and Daily Check).
9. Exit FPU. 10. Go back into FPU.
-5-

NOTICE These steps need to be performed for every computer that will connect to the instrument(s). These steps need to be performed per Access DB that needs to be migrated to SQL Server. If the DBs have some duplicate data between them, the import step in FPU will prompt for “override” or “skip” for each duplicate. Steps above are one-time only, so long as customer moves forward to the new data management approach of SQL Server and retires current data management approach. If at some point the customer switches to SQL Lite and creates SQL Lite FPU data which later need to be moved over to SQL Server FPU data, then they would need to repeat these instructions under Category 2.
CATEGORY 4: Currently store data in SQL Server with FP+ Existing customers, owning (1 or more) 803x units, and in process of upgrading (some or all) 803x to 804x units. Currently these customers are already using SQL Server data management option in FP+ and seek to continue using SQL Server data management option when they upgrade to 804x. They need to migrate their stored FP+ SQL Server data into FPU SQL Server and this data migration needs to be performed during the 804x upgrade.
Steps* (to begin using SQL Server for 804x/FPU) 1. DBA Steps.**
a. Create DB. b. Run SQL script to create FPU tables ­
“CreateFitPro4Tables.sql”. 2. Additional DBA Step.
a. Run SQL script “FitProPlustoFitProUltrainitial.sql” which copies all the FP+ SQL server data into FPU SQL Server data. NOTICE The SQL Server script has comments in it that guide the DBA on how to point to the right locations, etc.
3. Start FPU. 4. Give a name for the SQL Server DB, then type in
the DB string (given by DBA) to connect to DB. a. Select the “Data Management” option. Save
the database information and “Save” it. 5. Exit FPU. 6. Start FPU.
a. Open the side menu and make the SQL Server active.
**Step 1 (DBA Steps) is a common step for all four customer categories. TSI® does not provide SQL server software – this is a Microsoft product) required to be purchased by customer. The minimum version SQL Server required to work with FPU is MS SQL Server 2016 (but you can use newer versions). The customer’s Database Admin (IT Dept.) needs to do this #Variety of reasons include information security and data storage policy, expected high volumes of fit tests, etc.
-6-

NOTICE
These steps need to be performed for every computer that will connect to the instrument(s). These steps need to be performed per SQL Server FP+ DB that needs to be migrated to SQL Server FPU DB. If the DBs have some duplicate data between them, the SQL script (run by DBA) will prompt for “override” or “skip” for each duplicate. Steps above are one-time only, so long as customer moves forward to new data management approach of SQL Server and retires current data management approach. If at some point the customer switches to SQL Lite and creates SQL Lite FPU data which later need to be moved over to SQL Server FPU data, then they would need to repeat these instructions under Category 2.

_____________________
TSI and the TSI logo are registered trademarks of TSI Incorporated in the United States and may be protected under other country’s trademark registrations. Microsoft and Windows are registered trademarks of Microsoft Corporation.

TSI Incorporated ­ Visit our website www.tsi.com for more information.

USA UK France Germany

Tel: +1 800 680 1220 Tel: +44 149 4 459200 Tel: +33 1 41 19 21 99 Tel: +49 241 523030

India

Tel: +91 80 67877200

China

Tel: +86 10 8219 7688

Singapore Tel: +65 6595 6388

RFT-027-US Rev. B (9/23/2024)

©2024 TSI Incorporated

Printed in U.S.A.

Documents / Resources

TSI 804x Porta Count [pdf] Installation Guide
804x Porta Count, 804x, Porta Count, Count

References

Leave a comment

Your email address will not be published. Required fields are marked *