Home

CubiScan® Qbit-DB™

1. 2 Obit DB InstallAware Wizard Ready to Install Collecting information Setup is ready to start installing Qbit DB e Preparing installation 0 Installing Please click Next Eo install now Click Back bo review our installation settings 1 Finalizing installation a E Tn h ner INSLAAN T oA E 8 Ifyou want to review or change any of the settings click Back If not click Next to continue The following window is displayed as the Qbit DB files are copied to the specified destination folder Quantronix CubiScan Obit DB 107 Installing Qbit DB Installation COSTA al Ez 1 Installing Qbit DB Collecting information e f O LJ B O N CUBING amp WEIGHING systems ay QUANTRONIX Preparing installation CubiScan by Quantronix offers the broadest range of dimension scanning equipment available including portable static large static and in line configurations Installing Finalizing installation Fe Web www cubiscan com a Ph 800 488 CUBE Generating script operations For action InstallAware 108 Quantronix CubiScan Obit DB Installation Installing Qbit DB 9 When the installation is complete the following window appears Abit DB Install ware Wizard Qbit DB Setup Complete O Collecting information O Preparing installation O Installing Finaliz
2. 10 If you do not want to start Qbit DB now click to remove the checkmark Click Finish to exit and close the installation win dow If Run Qbit DB now was selected Qbit DB will open immediately Quantronix CubiScan Obit DB 109 Installing Qbit DB Installation Notes 110 Quantronix CubiScan Obit DB Appendix B Frequently Asked Questions This appendix contains some common questions about Qbit DB If after reading this manual and reviewing this appendix you still have questions please contact Quantronix Inc Question Do updated records that are exported contain data records from previous sessions Answer Each record in the database is marked when it is updated and remains marked until exported When exporting updated records all records that are marked are included Question I am unable to communicate with the CubiScan unit What should I do Answer Make sure the serial communications cable is properly connected with a NULL MODEM cable Verify that the proper COM port is selected in the setup options in Qbit DB If there is still no commu nication verify that the serial port on your computer is operational refer to your computer s documentation Quantronix CubiScan Qbit DB 111 Frequently Asked Questions Notes 112 Quantronix CubiScan Obit DB
3. e Select Swap Length for Width or press lt Ctrl gt lt L gt to switch the length and width measurement values for the selected item e Select Swap Width for Height or press lt Ctrl gt lt W gt to switch the width and height measurement values for the selected item e Select Swap Height for Length or press lt Ctrl gt lt H gt to switch the height and length measurement values for the selected item Quantronix CubiScan Obit DB 93 Editing Data Measuring Freight 94 When you have finished click qp E A to update the information in the database Quantronix CubiScan Qbit DB Chapter 6 Reports The Reports menu contains one standard report option plus any cus tomized reports you may have Customized reports are created by Quantronix by special arrangement The standard report option 1s a Detail report explained below Detail Report The Detail report lists all recorded data for the open database Pull down the Report menu and select Detail to generate the Detail report An example of the report is shown on the next page The Detail report contains all of the database detail as shown in the database table If you use user defined fields they are included on additional lines NOTE t You can also generate reports on your measurement data by export ing it from Obit DB in a text file and importing it into another appli cation such as a word processing or spreadsheet program Refer to Exporti
4. Ascii Remote Port 21 C Binary Remote Path Network Mode Trace Mode Passive tf Off Remote File Marne Active f On FTP Enter the login information required by your network for file transfer User ID Enter a valid user ID required for upload access to the host site Password Enter a valid password required for upload access to the host site Remote Host Enter the name of the FTP host e g ftp host com Remote Port Enter the port used for the transfer normally 21 Remote Path Enter the directory path on the host Be sure to use the correct syntax for the server type e g or Remote File Name Enter a name for the file on the host Upload Mode Select the option you want to use to create the exported file Overwrite Existing File Select this option to overwrite a previously uploaded file Quantronix CubiScan Obit DB 49 Export Configuration Transfer Mode Network Mode Trace Mode FTP Transfer Process 50 Append Data to File Select this option to append add the uploaded file to an existing file Create Unique Files Select this option to export the data into a unique file that will contain only the exported records Select the file transfer method ASCII Select this option if you want the file to be exported in ASCII plain text mode Binary Select this option if the file contains formatted text non text characters or other data not interpreted as text
5. Export Interval Timer options become available to set up the time interval for export Export After Each Update Select this option to automatically export the current database file each time it is updated No other options are necessary in this tab if you select this option If you selected Export at Specified Time of Day this section 1s available to set up the time of day you want the file exported Export Times Enter times in 12 hour clock format e Enable Time 1 Enable Time 2 Time 1 Time 2 00 AM 12 00 4M Enable Time 3 Enable Time 4 Time 3 Time 4 12 00 Am 12 00 Am You can set up four different times to export a file Click Enable Time 1 to enter the first export time Then type the time of day in the Time 1 text box in a 12 hour clock format 1 e 1 00 AM 2 00 PM and so on Do the same to set up times 2 through 4 as required The database file will be exported automatically every day at the specified time or times until you disable the time Quantronix CubiScan Obit DB Configuration Export Export Interval If you selected Export at Specified Time Interval this section is Timer available to set up the interval timer Esport Interval Timer Click the arrow buttons to scroll up or down from 1 to 23 hours 1 to 59 minutes and 1 to 59 seconds Click once to scroll one at a time or click and hold to scroll quickly through the numbers in sequence The database
6. Import at Specified Time of Day Select this option to set up a time of day to import the selected file The Import Times options become available to set up the time s of day for import Import at Specified Time Interval Select this option to set up a time interval to import the selected file The Import Interval Timer options become available to set up the time interval for import 38 Quantronix CubiScan Obit DB Configuration Import Import Times If you selected Import at Specified Time of Day this section is available to set up the time of day you want the file imported Import Times Enter times in 12 hour clack format W Enable Time 1 e Enable Time 2 Time 1 Time 2 3 00 PM 6 00 FM TT Enable Time 3 Enable Time 4 Time 3 E Time 4 12 00 4m You can set up four different times to import a file Click Enable Time 1 to enter the first import time Then type the time of day in the Time 1 text box in a 12 hour clock format 1 e 1 00 AM 2 00 PM and so on Do the same to set up times 2 through 4 as required The selected file will be imported automatically every day at the specified time or times until you disable the time Import Interval If you selected Import at Specified Time Interval this section is Timer available to set up the interval timer Import Interval Timer A El Click the arrow buttons to scroll up or down from 1 to 23 hou
7. s date To change a date click El and a calendar is dis played from which to choose the date as follows 4 May 2009 FF Mon Tue Wed Thu Fri Sat Zn 25 ag 30 1 2 5 4 5 G T B 9 10 11 12 13 14 15 16 17 18 13 20 2 ee 23 24 25 26 ei 25 24 30 3 1 2 3 4 5 E KD Ts a 3 Select the date and click OK The date is inserted in the From Date or To Date field The export file will contain all records added or updated on and between the dates you selected 4 Click OK to export the data to the file The status of the export and any errors are displayed in the message box Quantronix CubiScan Obit DB 73 Exporting a Database Database Management 74 Notes Quantronix CubiScan Obit DB Chapter 4 CubiScan Functions This chapter provides information on the Qbit DB functions used to verify reset and test the CubiScan These functions are selected from the Tools menu and include the following e Zero Use this function to set all empty measurements and weight to Zero e Status Use this function to verify that the CubiScan is operating prop erly e Test Mode Use this function to set up the CubiScan for testing e Values Use this function to display a table of sensor values that can be useful for troubleshooting problems e Calibrate Use this function to calibrate the sensors and the scale NOTE gt The Zero Status Test Mode Values and
8. Tools Options to set the CubiScan Model Pack Type Description 4 mal Table CubiScan Record 0 of 0 Updated Records 0 A VOX TINE ANOS VIVE EXDOITINE RNE All recorded measurement data is saved in the open database table You can open a different database if necessary Refer to Chapter 3 Database Management for information 2 Quantronix CubiScan Qbit DB Getting Started Main Window The following functions are performed at the main window e Measure and weigh freight see Chapter 5 Measuring Freight on page 87 e Add update database entries see Database View on page 7 e Access all other Qbit DB functions using the menus see Menu Bar on page 10 The main window is divided into several sections as described in the following sections You can move resize or hide some sections to make it easier to view only what your needs require refer to Customizing the Main Window on page 8 Stacked Quantities Box The Stacked Quantities box can be used if you want to stack like items for measurement but want the dimensions for each item included separately in the database Refer to Chapter 5 Measuring Freight for information mm 8 stacked Oty s Height h Length h Y Width h Stacked Qty is the number of like Items placed in ar axis The net dimensions and weight are calculated to provide an Each measurement Quantro
9. vides the following information Table Cubi5 can Record 1 of 4 Updated Records 1 Open an existing table Next Import Table CubiScan Name of the currently loaded database table Record 1 of 4 Currently selected record number and the total number of records Updated Records 1 Whether or not the records have been updated Until a record is updated the label reads Updated Records 0 After one or more records are updated it reads Updated Records xx where xx is the total number of updated records in the current database Open an existing table Move the mouse over a menu or function and a description of the menu or function is displayed Next Import AL LH ue If you scheduled an automatic import see Auto Import on page 37 the number of hours minutes seconds to the next import is displayed If you have not set up auto import Next Import Dis abled is shown Quantronix CubiScan Obit DB 15 Status Bar Getting Started Next Export MA Ub gt 1 If you scheduled an automatic export see Auto Export on page 44 the number of hours minutes seconds to the next export 1s displayed If you have not set up auto export Next Export Dis abled 1s shown 16 Quantronix CubiScan Obit DB Chapter 2 Configuration This chapter provides information and instructions to configure and set up defaults for Qbit DB using the Tools Options function Th
10. 0000 in 1 4000 lb 480 0000 in3 2 4742 194 ltem Number Pack Type Description Length Width Height Weight Yolume Dim Wat Dim Unit Wot Unit Yol Unit Factor Site Id F 2 789022343 6 pack Soda Pop g 11 7 08 693 3572 n lb in 194 3 789012343 6 pack Soda Pop 10 6 e 14 480580412371 lin Ib in 194 SLC3 4 789230301 Case Bottles 241 12 12 6 3456 329896907 in lb in 194 SLC3 Te KER Table CubiScan Record 4 of 5 Updated Records 1 ie 8 Quantronix CubiScan Qbit DB This step is only necessary if tare is enabled and the freight being measured requires a tare adjustment To apply tare values to an item pull down the Actions menu and select Apply Tare Values or press lt Ctrl gt lt T gt after you measure the item Tare values are subtracted from the measurements or weight Set up tare values in Options on the Tools menu Refer to Tare Val ues on page 24 for information Edit the data as required see Editing Data on page 93 91 Measuring Stacked Quantities Measuring Freight 9 When you are finished click qp 5 pa to update the item record To clear an item s measurement data and start over or to mea sure a different item click ex F A record must either be updated or cleared before you can measure another item 10 Remove the item from the CubiScan and repeat the steps above for the next item Measuring Stacked Quantities If you want to stack
11. Calibrate 6 Clear the CubiScan of all objects and click Step 2 or press lt F2 gt 7 Place the test weight on the CubiScan platform wait for the platform to stop moving and click Step 3 or press lt F3 gt The scale calibration is finished 8 Click Exit or press lt F6 gt to return to the main window 9 Remove the test weight from the CubiScan platform make sure the platform 1s completely clear of all objects and select Zero from the Tools menu to zero the CubiScan Quantronix CubiScan Obit DB 85 Calibrate CubiScan Functions Notes 86 Quantronix CubiScan Obit DB Chapter 5 Measuring Freight This chapter describes how to measure freight If your CubiScan has a scale weight is automatically recorded at the same time as the measurements There are two methods you can use to measure freight in Qbit DB depending on how you enter items in your database as follows 1 Measure items that are already listed in an imported database refer to Importing a Database on page 63 for information on importing a database Depending on your setup there are two ways to select the item to be measured from the database Auto Advance If you will be measuring items in the same order they are listed in the database you can set up the Auto Advance through Items function in Options see Database Options on page 23 for information If Auto Advance is set up you select the first item and Qbit
12. Calibrate functions may not be available if not available they are dimmed or grayed depending on whether or not the functions are available on the selected CubiScan model Refer to the following sections for more information on each func tion Quantronix CubiScan Obit DB 75 Zero CubiScan Functions Zero Use the Zero function to zero the CubiScan Zeroing sets all empty measurements and weight to zero The weight of the platform and the measurement from each sensor to the platform sides when the platform is empty must be set to zero for the CubiScan to oper ate properly A CubiScan zeros itself automatically every five sec onds when it is not in Measure mode However you may need to manually zero the CubiScan in the following circumstances e If during a long measuring session environmental conditions temperature and humidity have changed noticeably e If you suspect that the last zeroing was in error e g something was on the platform NOTE gt Make certain that the CubiScan platform is free of all objects before using Zero If not the zero reading will not be accurate 1 Pull down the Tools menu and select Zero The following prompt is displayed AN The Cubiscan must be clear of all objects i Cancel 2 Verify that the CubiScan platform is free of ALL objects then click OK to proceed 76 Quantronix CubiScan Obit DB CubiScan Functions Status 3 After the scale and sensors a
13. Click the name of the database table that you want to delete and the following warning is displayed AN Warning all records will be lost Delete table Mew Table 60 Quantronix CubiScan Obit DB Database Management Emptying a Database 3 All records in the selected database table will be deleted and cannot be recovered Click Yes if you want to delete the speci fied database table The following message 1s displayed Information x ao i i Table New Table successtully deleted 4 Click OK to close the message Emptying a Database Do the following to delete all of the records from a database table 1 Make sure the table from which you want to delete all records is the open table 2 Select Empty Table from the Database menu and the following prompt is displayed AN Warning all records will be lost Empty table Cubiscan Y 3 All records in the open database table will be deleted and cannot be recovered Click Yes if you want to empty the database table Quantronix CubiScan Qbit DB 61 Copying a Database Database Management The following message is displayed Information x G Table New Table successfully emptied 4 Click OK to close the message Copying a Database You can save a copy of a database table to use as a backup in case of problems with the database or a hard disk or other computer failure Do the following to save a copy of a database table the origina
14. DB automatically moves down the database list in sequential order as you measure and update each item How ever you can also manually click an item to select it Select Items Manually Read an item s label to identify it then click the item in the database table to select the item as shown below Sequence ltem Number Pack Type Description Length Width Height Weight Volume Cim at Din Unit ico a 1 789023344 Liter 3 5 12 075 180 0 928 in lb 2 Page 2343 E pack Soda Pop g 11 f 0 8 693 3 572 lin lb 3 7189012343 E pack Soda Pop 10 G B 1 4 480 2 474 lin lb Bl 789230301 Case Bottles 24 12 12 6 3456 829896907 in lb B 789012343 12 pack Soda 20 12 B 2 5 1920 3 89 in Ib rile l Quantronix CubiScan Qbit DB 87 Measuring Existing Items Measuring Freight Enter items into the database manually or by scanning as you measure each item With the cursor at the Item Number field you can do one of the following e If your system has a scanner scan the item and the number is inserted in the Item Number field Then press lt Enter gt e Type the item number in the Item Number field and press lt Enter gt NOTE gt An lt Enter gt key can be programmed into a barcode scanner see your system or hardware administrator for assistance Measuring Existing Items 88 Do the following to measure items listed in an existing database 1 If necessary open the database that contains the items you a
15. Data d t ej Ex database LS My Network P File name Save as type Excel Files xls hi Cancel Z Quantronix CubiScan Qbit DB 71 Exporting a Database Database Management 12 Date Range 6 Export files are saved in the CubiScan Qbit DB Data folder by default If you want to save the file to a different drive and or folder click or I at the Look in box and select the drive folder Enter a name for the export file in the File name field The x s file extension is added automatically If you want to copy over an existing export file select the drive folder containing the file you want to copy over and click the file name to insert it in the File name field 8 Click Save to export the database table to the file The status of the export and any errors are displayed in the message box Use the Date Range option to save an export text file containing all records that were updated or added within a specified period of time l Select Date Range from the Run Manual Excel Export sub menu and the following dialog box is displayed Export Date Range Parameters Ea Please Select Desired Date Range From Date To Date 5 12 2008 El 5 13 2009 El x Cancel Quantronix CubiScan Obit DB Database Management Exporting a Database 2 By default the from date is yesterday s date and the to date is today
16. Setup Collecting information Welcome to the InstallAware Wizard for Obit DB Setup Preparing installation Installing The Install4ware Wizard will install Qbit DB on this computer Please click Next Eo Finalizing installation continue S InstallAware Cancel 4 Click Next to continue and the license agreement is dis played Quantronix CubiScan Obit DB 103 Installing Qbit DB Installation FE Qbit DE InstallAware Wizard License Agreement ME QUANTRONIX INC LICENSE AGREEMENT J O oe Installing This License Agreement governs your use of the enclosed Sothware product Ey installing andor using the Software you agree to be O bound by the terms of this Agreement Ifyou do not agree to these terms and conditions promptly return all the components of this product to the place of purchase and your money will be refunded LICENSE This License Agreement allows you to use the enclosed Software with a single CubiScan device You may install and use the enclosed Software on multiple computers but only for the Cancel 5 Read the license agreement and click the radio button next to I accept the license agreement Click Next to continue and the following window appears 104 Quantronix CubiScan Obit DB Installation Installing Qbit DB 2 Qbit DB InstallAware Wizard Destination Folder Collecting informatio
17. Site Id F 2 789022343 6 pack Soda Pop 9 11 7 0 8 693 3 572 in lb in 194 3 789012343 6 pack Soda Pop 10 6 8 14 480 580412371 in lb in 194 SLC3 4 789230301 Case Bottles 24 12 12 6 3456 329896907 in lb in 194 SLC3 d TEE Table CubiScan Record 4 of 5 Updated Records 1 6 Quantronix CubiScan Qbit DB This step is only necessary if tare is enabled and the freight being measured requires a tare adjustment To apply tare values to an item pull down the Actions menu and select Apply Tare Values or press lt Ctrl gt lt T gt after you measure the item Tare values are subtracted from the measurements or weight Set up tare values in Options on the Tools menu Refer to Tare Val ues on page 24 for information Edit the data as required see Editing Data on page 93 ke Update 4 LO update the item When you are finished click record 89 Measuring New ltems Measuring Freight To clear an item s measurement data and start over or to mea rie if sure a different item click cea pg A record must either be updated or cleared before you can measure another item Remove the item from the CubiScan and repeat the steps above for the next item Measuring New Items Do the following to enter new items into the database as you mea sure them 90 If necessary open the database in which you want to enter the items you are measuring Verify that all of the Cubi
18. Tools menu The Zero Status Test Mode Values and Calibrate functions may not be available grayed depending on whether or not the functions are available on the selected CubiScan model Quantronix CubiScan Obit DB Getting Started Menu Bar Zero Status Test Mode Values Calibrate Options Use this function to zero the CubiScan Refer to Zero on page 76 Use this function to verify that the CubiScan is operating properly Refer to Status on page 77 Use this function to set up the CubiScan for testing purposes Refer to Test Mode on page 79 Use this function to display a table of sensor values that can be use ful for troubleshooting problems with the CubiScan Refer to Val ues on page 80 Use this function to calibrate the scale and sensors Refer to Cali brate on page 80 Use this function to configure Qbit DB Configuration options include setting the serial port selecting your CubiScan model determining the measurement units setting up import and export options setting up user defined fields setting up a password and so on Refer to Chapter 2 Configuration on page 17 for details Caliper Menu Length Width Height This menu is only displayed if a CubiScan 30 model is selected in the Tools menu Options CubiScan tab The following functions are available Refer to the CubiScan 30 Operations and Technical Man ual fo
19. insert a field above the selected field Click a table field and then click Move Up to move the selected field up one position in the table Click a table field and then click Move Down to move the selected field down one position in the table Click the drop down arrow at a table field to display a list of avail able fields and select a field name to add or change a field label The SPACE FILLER option in the drop down list can be used to specify an empty or blank field If you specified fixed length as the file type in the Export Type tab click in the second column next a field to change the starting position in number of characters of the field O Primary 1 35 Secondary 36 O O Description Ab 40 O Length 96 0 1 Quantronix CubiScan Obit DB 43 Export Configuration 44 If you specified fixed length as the file type in the Export Type tab click in the Size column next to a field to change the number of characters in the field 1 0 Primary E Secondary 36 O O Description Ab 40 O Length 36 20 1 Click in the Decimals column for a field to add or change the number of characters after the decimal point for entries in the field This applies to decimal fields only e g dimensions weight vol ume T r TR i Primary Secondary O Auto Export NOTE gt To set up Qbit DB to automatically export a file at a time of day at specified time inte
20. like items for measurement but want the dimen sions for each item included separately in the database use the Stacked Quantities box 1 If the Stacked Quantities box is not visible pull down the View menu and select Stacking a 8 stacked Oty s Height h Y Length h Width h y Stacked Qty is the number of like Items placed in an axis The net dimensions and weight are calculated to provide an Each measurement 92 Quantronix CubiScan Obit DB Measuring Freight Editing Data 2 Place the stack of objects on the CubiScan platform Make sure the edges are aligned 3 Identify and measure the stacked objects and enter the quantity in the Stacked Quantities box in the Height Length and Width fields as applicable The specified number of each dimension will be entered as separate items in the database Editing Data At any time after measuring an item you can edit any of its mea surements using one of the following methods Click the item in the database table to select it Edit Fields You can edit any field that is not greyed has a white background Click in a field to edit it and type over the existing entry Then click fee sl to update the information in the database Swap You can change the orientation of an item using one of the swap Measurements functions Pull down the Actions menu and select a function or use the specified keyboard shortcut as follows
21. must be selected in the Tools menu Options CubiScan tab 1 Select Calibrate from the Tools menu then select Laser The following prompt is displayed AN Place the calibration block onto the Cubiscan platform E Cancel 2 Place the calibration standard block on the CubiScan platform and click OK to proceed 3 Follow the instructions in the CubiScan 30 Operations and Technical Manual to calibrate the lasers Scale This option may not be available for all CubiScan models Refer to your CubiScan Operations And Technical Manual for information Take the following steps to calibrate a CubiScan scale Quantronix CubiScan Obit DB 83 Calibrate CubiScan Functions 1 Select Calibrate from the Tools menu then select Scale The following prompt is displayed 2 Click OK to proceed and the following dialog box appears Scale Calibration This routine will run through a seres of steps designed to calibrate the scale This procedure should be performed periodically or any time the Weight is not within tolerance IF You wish to continue with the calibration click CONTINUE otherwise pou may esit without calibrating the Cubis can 3 Click Continue or press lt F7 gt The cursor moves to the text box 4 Enter the weight of the official calibration test weight Refer to your CubiScan manual for specific recommendations 5 Click Step 1 or press lt F1 gt 84 Quantronix CubiScan Obit DB CubiScan Functions
22. name field includ ing the extension which can be any ASCII text file extension e g txt CSV If you want to copy over an existing export file select the drive folder containing the file you want to copy over and click the file name to insert it in the File name field 9 Click Save to export the database table to the file The status of the export and any errors are displayed in the message box Date Range Use the Date Range option to save an export text file containing all records that were updated or added within a specified period of time l Select Date Range from the Run Manual Export submenu and the following dialog box is displayed Export Date Range Parameters x Please select Desired Date Range From Cate To Date 5 12 2008 El 5 13 2003 El x Cancel Quantronix CubiScan Obit DB 69 Exporting a Database Database Management 2 By default the from date is yesterday s date and the to date is today s date To change a date click El and a calendar is dis played from which to choose the date as follows 4 May 2009 t H Mon Tue Wed Thu Fri Sat men 3 Select the date and click OK The date is inserted in the From Date or To Date field The export file will contain all records added or updated on and between the dates you selected 4 Click OK to export the data to the file The status of the export and any errors are
23. o6 f4 in 325 lb 301 595 f 2356981 4 de 14 14 in 1123 lb 3 038 ft 4 a elt out 12 La TE Jg q4 1234555 a 0 21 875 15 1234556 14 4 de 0 1 685 16 1234558 8 Click Close to exit the dialog box The new database table is opened in Qbit DB Refer to Chapter 3 Database Management for information on databases 28 Quantronix CubiScan Obit DB Configuration Password Password To provide security for specified functions in Qbit DB you can set up a password Once a password is set up the selected functions are dimmed in the menus and only become available when the password is entered The Options function is always included when pass word protection is enabled for any function Ll m m al I E al m E m r Password Options Select the functions for which a password will be required Quantronix CubiScan Obit DB 29 Password Configuration Set Password Click this button to set up or change the password The following dialog box is displayed Set Password Dialog x Enter password In the Enter Password box type the password In the Re enter Password box type it again for verification The password is case sensitive if you enter upper or lower case characters they must be entered in the same case when entering the password Click OK to accept the password Clear Password Click Clear Password to remove an existing password This allows access to all fun
24. record is indicated by a Y Yes in the Updated last column in the database table After a Quantronix CubiScan Obit DB 67 Exporting a Database Database Management 68 record has been exported an N No 1s shown in the Updated column Take the following steps to export data using either the All Data or Updated Data option 1 Pull down the Tools menu and select Options 2 Click the Export tab and then the Export Type tab 3 Select the export file type and other applicable options see Export Type on page 40 4 If you want to change the layout of the data click the Export Layout tab and make the desired changes see Export Layout on page 42 5 Click OK to save and close the Options dialog box 6 Select All Data or Updated Data from the Run Manual Export submenu The following dialog box is displayed Save As Save ini Data de t E f Esport 7 tut import data tet Sample txt My Network P File name Export 2 tut Save as type Text Files txt cew Cancel Ze Quantronix CubiScan Qbit DB Database Management Exporting a Database 7 Export files are saved in the CubiScan Qbit DB Data folder by default If you want to save the file to a different drive and or folder click or IH at the Look in box and select the drive folder 8 Enter a name for the export file in the File
25. B and describes the different areas and the functions performed at the main window Starting Exiting Qbit DB Do one of the following to start Qbit DB e Click Start select Programs click CubiScan then click Qbit DB e Double click the Qbit DB desktop icon Qbit The main window is displayed see next page Do one of the following to exit Qbit DB e Pull down the File menu and click Exit e Click the Close button X located in the upper right corner of the main window Quantronix CubiScan Obit DB l Main Window Getting Started Main Window When Qbit DB starts the main window is displayed and either an empty database table with the default name Cubiscan or the last database table that was opened is loaded Qbit DB File Database View Tools Actions Reports Help 28 Item Number User 1 User 5 stacked Oty s Pack Type User 2 User 6 Height Lengnfi H NS User 3 pooo Width i User 4 a 8 A Stacked Oty is the dele of ia CubiScan Database eee Length in 0 0000 0 0000 The net nena re Width in 0 0000 aooo weight are SSA l calculated to a Height in 0 0000 0 0000 provide an Each drid o as we Select Tools Options to set the Serial Port 4 Clear F6 i mm AK Number a ens a Opening Table gt CubiScan i anann Serial port ber is set t Dim Wegt 194 0 0000 0 0000 eral port number Is set to zero Select
26. CubiScan Qbit DB User Guide Version 1 0 Quantronix Inc Cubing and Weighing Systems 380 South 200 West P O Box 929 Farmington Utah 84025 U S A Phone 801 451 7000 Fax 801 451 0502 Web Site http www cubiscan com CubiScan Obit DB User Guide CubiScan and the Quantronix logo are registered trademarks of Quantronix Inc Scanning New Dimensions Qbit DB Qbit Win and The FreightWeigh System are trademarks of Quantronix Inc Microsoft Windows Windows NT Windows 2000 and their respective logos are registered trademarks of Microsoft Corporation in the United States and other countries All other brand and product names used in this manual are trademarks or registered trademarks of their respec tive companies CubiScan software and firmware are protected by international and domestic copyrights CubiScan products incorporate technology protected by one or more of U S patents 5 042 015 5 105 392 5 422 861 5 606 534 5 220 536 5 636 028 5 850 370 6 049 836 6 064 629 6 298 009 6 611 787 6 850 464 7 277 187 and D490 328 and corresponding international patents Other international patents are pending This document copyright 2009 by Quantronix Inc All rights reserved No portion of this manual may be reproduced in any form without written permission from Quantronix Inc Information in this manual is subject to change without notice Manual updated May 14 2009 Contents Chapter 1 Getting S
27. M 4222 an analiani ia pd decia Nate ke da 18 Unitot Measure Opon ica rd ead dees 19 CUbIS Can OPUONS e rai E ii es ate AA GE A 19 Cubis Cam Model esmas a alo IDU carne x 19 A E A a hs 20 Database dis ate ae E aaa we Baek Oe een he 20 Primary Field etc as Subs poe ies 21 Secondary Field norris apa nadaa Baek 22 Database Opus lt a EEES 23 LATE VAIS a A EEN anda 24 Deseription Field as citada OS OS Ree uch eee Se 25 Convert Qbit Win Qbit WMS Database 2D PASS WOU a ond Ghat ore vee a hie cere ao eee eau ena een teh es 29 MOE hs Laie tN eek ao wee abe oo eee oon hires 31 port Type A Vee behets oe SA 31 Inport La volta sola ld 33 AUTO TM POT rosa ras a it ae athe 37 Mport Frequency Opu0ns ss ierre ns de 38 EXPORT i056 i i dace sa ira al RA ala A a Ak 40 Expo Peeran a Gu ae cee wh awa 40 EXpOn LaAayOUls her ra o ta 42 AMO KOU ias cios ra o aa 44 PEQUE A en 45 PCS CHALOM 555s oe tate rare o Ale Oe are ce ah 48 o aaa a eee eek eee Bee 32 MSN A II eosin E Bat tate sa E 54 Quantronix CubiScan Qbit DB Contents Chapter 3 Chapter 4 Chapter 5 Chapter 6 Database Management 05 57 Creatine a New Database ssl ria ers 6d AE e E 58 Opes a Database 44322652850 e ee ct eet ade ke Sagas 4 59 Deletine a Database cias ttire meua tte era G ete seed 60 Emptying a Database nora A AAA ia 61 Copy ins a Database cia LAA ez 62 Importing a Database o ooooooooooocoonororo
28. Scan options have been set up cor rectly see CubiScan on page 18 Place the item to be measured on the CubiScan refer to your CubiScan Operations Manual for details on correct freight placement Verify that the cursor is in the Item Number field If not click E l to save the last measurement or click Update F4 Clear F6 if it is not valid or is already saved Scan the item or type in the item number and press lt Enter gt An lt Enter gt key can be programmed into a barcode scanner see your system or hardware administrator for help Quantronix CubiScan Obit DB Measuring Freight Measuring New ltems T 6 Click HMeasure F3 to measure the item The measurement process 1s shown on the screen the measurements are inserted into the dimension fields and a simulation of the measured freight is shown in the CubiScan picture box ltem Number Pack Number User 5 789230301 3321 Pack Type User 2 User 6 Case Description User 3 User 7 Bottles User 4 User 8 Repeater WUMEN ed 0 ILLL CubiScan Database Measure F3 Length in 24 0000 24 0000 A 4 Widlth in 12 0000 120000 a pone Height in 12 0000 12 0000 if FG Weight lb 6 0000 6 0000 Opening Table gt CubiScan a E Connected to Serial Port 1 Volume in3 3456 0000 3456 0000 CubiScan Model 100 Selected A Connected to Serial Port 1 Delete Dim Wgt 194 17 8144 17 8144 CubiScan Model 100 Selected 10 0000 x 6 0000 x 8
29. Select your network mode Passive Select this option if your network uses passive FTP Active Select this option if your network uses active FTP Select whether you want packet tracing on or off for the file transfer After you have configured the frequency and FTP settings the file transfer process is automatic and only requires periodic monitoring of the message box to identify any problems messages in red Quantronix CubiScan Qbit DB Configuration Export Activate ASCII Text File Output Select this option to output the exported data to an ASCII text file W Activate ASCII Text File Output ASCH Text File File Location and Name Browse Output Mode f Ovenarite Existing File f Append Data To File f Create Unique Files File Location and Enter a directory path and complete file name for the exported file Name Or click Browse and the following dialog box is displayed Browse x Save in a Data e 0 e Ed import data but Sample tet My Network P File name Save as hype E Files Cancel Ze Browse to the folder in which you want to save the file If you want to write over or append to an existing file select the file name if you want to create a unique file enter a file name in the File name field including the extension which can be any ASCII text file extension e g txt csv Click Save The path and file name are inserted in the field i
30. agement Exporting a Database 66 Use the Export option to export an entire Qbit DB database or a por tion of a database to a variable or fixed length format ASCII text file that can be loaded into a different application or moved to a differ ent computer and imported into Qbit DB You can also use auto export to upload the database via FTP You must set up the export file options before exporting data see Export Type on page 40 You can also change the layout of the Qbit DB database table to be exported not applicable to the Run Manual Excel Export func tion Refer to Export Layout on page 42 for instructions Click Export on the File menu and a submenu is displayed with the following functions Run Auto Export Select this function to start the automatic export that you have already set up See Auto Export on page 44 Run Manual Export When you click this function a submenu is displayed with the following options e All Data Select this option to create a text file that contains all records in the current database e Updated Data Select this option to create a text file that contains only records updated or added since the last export e Date Range Select this option to create a text file containing all records updated or added within a specified period of time Run Manual Excel Export When you click this function a submenu is displayed with the following options Quantronix Cu
31. all sections are open they can be positioned one on top of the other on either side side by side on either side or on each side of the win dow Quantronix CubiScan Obit DB 9 Menu Bar Getting Started Hiding Showing Saving a View Menu Bar 10 To hide the Stacked Quantities box CubiScan picture Message box or the Database fields in the Measurement section pull down the View menu and click the section you want to hide Pull down the menu and click 1t again to show a hidden section You can also click the x on the docking bar or title bar of the Stacked Quantities box CubiScan picture or Message box To show the section again select 1t from the View menu After you have customized the view of the main window you can lock the sections into place save the new arrangement as the default view or return to the default view Pull down the View menu and select a function as follows e Load Default View Select this function to return the main window to the default view e Save as Default View Select this function to save the new arrangement as the default view e Lock View Select this function to lock the position of the sections so they cannot be moved Select Unlock View to unlock the sections The menus at the top of the main window contain functions used to perform tasks and set up Qbit DB Click a menu name and the menu drops down from the menu bar Click a function on the menu to select
32. an be hidden or shown Quantronix CubiScan Qbit DB Getting Started Main Window Resizing To resize a section move the mouse pointer over any side or corner until the pointer changes to directional arrows Click and hold the mouse button and drag the side or corner of the section until it is the size you want then release the mouse button Te a gt Length width Height weight idth Height 2U 12 g NOTE t You can resize the entire main window using the same method Moving Each section that can be separated has a docking bar at the top when the section is docked or in a fixed position in the window To move the section click the docking bar hold down the mouse button and drag the section to another location in the window As you drag it you will see an outline that indicates the position and size it will be When it is in the position you want release the mouse button If you move a section to a floating or undocked position the docking bar changes to a title bar To move a floating section click the title bar hold down the mouse button and drag the section When you move it into a docked position the docking bar appears again NOTE gt f you do not want the section to snap into a docked position hold down the lt Ctrl gt key as you drag it It then becomes a floating sec tion that can be positioned anywhere on the screen Docked positions are on either side of the measurement section If
33. aracters Numeric Charac ters or Y N Character yes no If you do not want to define any restrictions select Any Character Quantronix CubiScan Obit DB 55 User Fields Configuration 56 Notes Quantronix CubiScan Qbit DB Chapter 3 Database Management Item measurements and weights are stored in item records by item number in a Qbit DB database table Access database This chap ter provides information and instructions on managing your Qbit DB databases Most of the database functions are found on the Database menu The Import and Export functions are on the File menu When you start Qbit DB for the first time an empty database is opened with the default name Cubiscan All of the measurements and weights of the freight you measure are recorded and saved in the open database You can do either of the following e Record the information in the Cubiscan database table e Create a new database table using the New Table function see Creating a New Database on page 58 If you already have a Qbit DB database or databases the last data base loaded is opened when you start Qbit DB You can do any of the following e Save new measurements and weights in the open database table e Open a different database table using the Open Table function see Opening a Database on page 59 e Create a new database table using the New Table function see Creating a New Database
34. biScan Obit DB Database Management Exporting a Database e All Data Select this option to create a text file that contains all records in the current database e Updated Data Select this option to create a text file that contains only records updated or added since the last export e Date Range Select this option to create a text file containing all records updated or added within a specified period of time Refer to the following sections for information on each function Run Auto Export You can use the Run Auto Export function to start the automatic export that you have set up The export will take place immediately using the options that you set up in the Auto Export tab in Options refer to Auto Export on page 44 This function is useful if you want to manually upload the database to a network using FTP Set up auto export by selecting the Acti vate FTP Upload option and entering the required login and mode information Then select Run Auto Export to upload the data immediately Run Manual Export Select this function if you want to manually export all or part of the database to a text file Select one of the following options All Data Select the All Data option to create an export text file containing Updated Data all records in the current database or select the Updated Data option to create an export file containing only records updated or added since the last export An updated
35. ce through Items Select this option 1f you generally measure items in the order they are listed in the existing database If enabled after you select the first item Qbit DB automatically moves down the list in sequential order as each item is measured and updated However you can also manually click an item to select it if necessary Select this option if you want to be able to delete an item record from the database The Delete button in the main window becomes available otherwise it is grayed Tare Values Tare values are preset dimensions to be subtracted from a measure ment If a tare value is included and the resulting measurement or weight is less than zero the reading will be zero Tare values are not used in most applications but may be used in some circumstances Quantronix CubiScan Qbit DB Configuration Database Enable Tare Option If you use tare values all or part of the time click this option to enable tare If enabled you must apply the tare values after measur ing an item Length Enter tare values for measurements and weight as applicable Each Width specified value is subtracted from the dimension measurement or Height weight Weight To apply tare values to a measurement select Apply Tare Values from the Actions menu or press lt Ctrl gt lt T gt after measuring the item Description Field Enable Description Select this option to enable the Description field in the main win Field dow un
36. ctions by all users The message Password has been cleared 1s displayed This means that a password is no longer required to use any functions in Qbit DB Click OK When you attempt to access a function that has been password pro tected the following prompt appears Password Dialog x Enter Password Enter the password exactly as it was entered when set up case sen sitive and click OK to open the function 30 Quantronix CubiScan Qbit DB Configuration Import Import The Import option on the File menu is used to import data from an external ASCH text file source Refer to Importing a Database on page 63 for information Click the Import tab to set up the import options the layout of the imported database fields and the auto matic import function Import Type Select the Import Type tab to set up the options that define the type of files that can be imported Quantronix CubiScan Obit DB 31 Import Configuration Import File Type NOTE gt Import File Contains Header Information 32 Import Merge Options Select the file type to be used when importing database tables The default is delimited Delimited Variable length delimited files csv or txt file extension contain variable length records each separated by a carriage return line feed pair Fields may vary in length and are separated by field separators Leading and trailing spaces for numeric and character field
37. d To exit from test mode click Cancel Quantronix CubiScan Qbit DB 79 Values CubiScan Functions Values Use the Values function to display a table of sensor values that can be useful for troubleshooting problems with the CubiScan Cubi5 can Yalues CUBISCAN MODEL 100L SCALE CAPACITY 100 FIRMWARE VERSION 2 000 Sensor values 23 0 4 00 22 0 05 LENGTH 0235 WIDTH 23 0 0235 4 00 22 0 05 HEIGHT 41 0 0235 4 00 22 0 05 Click OK to return to the main window Calibrate Use Calibrate to recalibrate the CubiScan sensors or CubiScan 30 lasers and scale Refer to your CubiScan manual for information on when the CubiScan should be calibrated Before calibrating the CubiScan remove all packages or other mate rial from the platform and blow any dust off the sensor screens 80 Quantronix CubiScan Obit DB CubiScan Functions Calibrate Refer to your CubiScan manual for information on cleaning the sen sors To perform the calibration you will need the following e Official test weight The weight varies for each model of Cubi Scan refer to your CubiScan manual It is recommended that you calibrate with the maximum weight e Calibration cube supplied with the CubiScan remove the wrapping from the calibration cube before using Refer to the appropriate section below to proceed Sensors Take the following steps to calibrate the CubiScan s sensors 1 Select Calibrate from the Tools
38. der the primary and secondary fields You can then enter a description for each item which will appear in the database table Include this field Select this option if you want the item description included when when repeating you repeat an item number Repeat is only available if the second ary field is enabled refer to Secondary Field on page 22 Hide Field Select this option if you do not want the Description field dis played in the main window Convert Qbit Win Qbit WMS Database Because older versions of Qbit created Paradox databases and Qbit DB creates Access databases a database from an older version of Qbit cannot be loaded into the current version Take the following steps to convert a Paradox database to an Access database 1 Since the new database will be loaded into Qbit DB when the conversion takes place you must start with an empty database From the Database menu select either New Table and enter a name for the converted database table or select Empty Table to Quantronix CubiScan Qbit DB 25 Database Configuration erase all records from the currently loaded database table and replace 1t with the converted database table 2 Click Convert Qbit Win Qbit WMS Database to convert a database from a previous version of Qbit to the current version The following dialog box is displayed Convert Paradox To Access 3 Select the Qbit application in which the database you want to convert was c
39. descriptors in the primary field generally item number and the secondary field if it is enabled You cannot add an identical item to a database but you can change and update an item If the secondary field is not enabled an identical item is any item with the same item number If the secondary field is enabled an identical item is any item with the same item number and the same secondary field entry If you attempt to add an identical item the following warning mes sage 1s displayed ltem already exists Update Select Yes to overwrite the existing item or No if you did not intend to change the existing item Verify Item Exists Select this option if you update existing items or import data in a Before Update database more often than you add new items This option is used with its sub options to give you multiple variations as follows Quantronix CubiScan Qbit DB 23 Database Configuration 24 Enable Record Delete Button Allow New Items to be Added enabled If this option is enabled updating existing items is the default but items can also be added to the database Allow New Items to be Added disabled If this option is not enabled you can only update existing items you cannot add new items If you attempt to add a new item the following warning is displayed Error x ltem was not found and the option Allow Hew Items To Be Added i not enabled Acton has been canceled Auto Advan
40. displayed in the message box Run Manual Excel Export Select this function 1f you want to manually export all or part of the database to a file that can be loaded directly into Microsoft Excel You cannot change the layout of the database 1f you use this export option The items in the export file will be in the same physical order as in the database table with header information Select one of the following options 70 Quantronix CubiScan Obit DB Database Management Exporting a Database All Data Select the All Data option to create an export text file containing Updated Data all records in the current database or select the Updated Data option to create an export file containing only records updated or added since the last export An updated record is indicated by a Y Yes in the Updated last column in the database table After a record has been exported an N No 1s shown in the Updated column Take the following steps to export data using either the All Data or Updated Data option 1 Pull down the Tools menu and select Options 2 Click the Export tab and then the Export Type tab 3 Select the export file type and other applicable options see Export Type on page 40 4 Click OK to save and close the Options dialog box 5 Select All Data or Updated Data from the Run Manual Excel Export submenu The following dialog box is displayed Save As Save ire
41. e button to measure the item on the CubiScan Click the Update button to update the current item record You must update a record or clear it before you can measure a new item Click the Clear button to clear the data fields for the current record and start over Click the Delete button to delete the current record This button must be enabled refer to Database Options on page 23 Quantronix CubiScan Qbit DB 5 Main Window Getting Started CubiScan Picture Box After you specify the CubiScan model to which your computer is connected refer to CubiScan Model on page 19 a simulation of the CubiScan is displayed in the Picture box After you measure freight the freight and its measurements are also shown Information Box The information box lists any CubiScan activity and gives the status of the activity This includes any configuration changes measure ments taken and error messages Connected to Serial Port 1 Cubiscan Model 100 Selected 12 0000 12 0000 7 0000 in 3 0000 lb 1008 0000 m3 5 1959 194 3 0000 5 0000 12 0000 in 0 4500 lb 180 0000 ind 0 9278 194 12 0000 12 0000 7 0000 in 3 0000 lb 1008 0000 ins 5 1959 194 Mo communication with Cubiscan Check cables and port settings 6 Quantronix CubiScan Obit DB Getting Started Main Window Database View The Database View lists the items in the open database The col umns a
42. e following tabs contain the configuration options e CubiScan Set up the measurement and dimensional weight units select the CubiScan communications port select your CubiScan model and enter a site ID optional e Database Set up database fields options and tare values This tab also contains the option to convert an older Qbit DB database to the new format e Password Set up password security for selected functions e Import Select import options set up the layout of the imported database fields and set up the automatic import function e Export Select export options set up the layout of the exported database fields and set up the automatic export function e Factors Enter the values used for dimensional weight factors e Fields 1 4 Fields 5 8 Set up from one to eight user defined fields Quantronix CubiScan Obit DB 17 CubiScan Configuration CubiScan 18 Select Options from the Tools menu to open the Options dialog box Refer to the following sections for information on the options in each tab Click OK to save changes you made to any tab and exit the dialog box Click Cancel to exit without saving Click the CubiScan tab to set up the measurement and dimensional weight units select the CubiScan communications port select your CubiScan model and enter a site ID optional Lubiscan Database Password Import Esport Factors Field 14 Fields 5 6 Unit OF Measure Options Cubis ca
43. e list of fields ie To clear all of the fields and start over click Clear All Clear All 36 Quantronix CubiScan Qbit DB Configuration Import Auto Import To set up Qbit DB to automatically import a file at a specified time of day or at specified time intervals click the Auto Import tab Enable Time Enable tine 2 E Ime 12 00 At 12 00 At E Ea IE rn Salar imes Line 4 12 00 4M 12 00 4M NOTE gt You must set up the Import Type options and map the layout before you set up auto import see Import Type on page 31 and Import Layout on page 33 After you set up an auto import the number of hours minutes sec onds to the next scheduled import is displayed in the status bar of the main window see Main Window on page 2 Quantronix CubiScan Obit DB 37 Import Configuration Import File Location Enter the directory path and file name of the import file you want to and Name schedule or click Browse to find the file The following dialog box 1s displayed Open Fx import data tst tiy Network P File name import data ts Files of type Text Files txt csv Cancel Fe me Browse to the folder containing the import file select the file name and click Open The path and file name are inserted in the field Import Frequency Options Import Mode Select the mode for automatic importing as follows Off Select this option to disable automatic import
44. eld is the first field in the editable fields section of the main window with Item Number as the default label The primary field receives an item s identification number whether typed scanned or selected from an imported data file The follow ing options allow you to customize this field Field Name By default the primary field label is Item Number Type a new name in the text box to change the label The new label replaces Item Number in the main window and in the database view Quantronix CubiScan Qbit DB 21 Database Configuration Field Length Key Field Option Enter the maximum number of characters that can be entered in the key field from 1 to 35 You will not be allowed to enter more than the specified number of characters in the field This option can be used to limit the type of characters that can be entered in the primary field to help prevent data input errors Select the option for the type of characters to be allowed in the key field Any Character Alpha Numeric Characters Alphabetic Characters or Numeric Characters If you do not want to define any restrictions select Any Character Secondary Field Enable Secondary Field Allow Manual Entry in Addition to Pick 22 List Secondary Field Pick List In addition to the primary field you can enable a secondary field that can be used to enter an additional descriptor under the primary field label For example you ca
45. elds are labeled User Field 1 through User Field 8 by default however you can change the labels Two tabs are available to set up user fields Fields 1 4 and Fields 5 8 CubiScan Database Password Import Export Factors Fields 1 4 Fields 5 8 User Field 1 Attributes Field Name WEA Field Length 1 30 20 Enable Field TT Mandatory Entry IF Hide Field T Include this field when repeating User Field 3 Attributes Field Hame User 3 Field Length 1 30 30 F Enable Field F Mandatory Entry F Hide Field F Include this field when repeating Data Entry Type f Any Character C Alpha Numeric Characters C Alphabetic Characters Numeric Characters f YN Character Data Entry Type Any Character C Alpha Numeric Characters Alphabetic Characters C Numeric Characters CIN Character User Field 4 Attributes Field Name User 4 Field Length 1 30 30 Enable Field Mandatory Entry Hide Field F Include this field when repeating User Field 2 Attributes Field Name User 2 Field Length 1 30 30 TT Enable Field Mandatory Entry Hide Field 7 Include this field when repeating Data Entry Type f Any Character C Alpha Numeric Characters Alphabetic Characters Numeric Characters YN Character Data Entry Type f Any Character Alpha Numeric Characters Alphabetic Characters Numeric Characters Y N C
46. elds depends on your Windows regional settings If you select this option additional options to define the delimiter type become available at the bottom of the tab see Import Delimited File on page 33 Fixed Length Fixed length files txt file extension contain fixed length records each separated by a carriage return line feed pair Fields are fixed in length with no field separators Character fields are padded with trailing blanks and numeric fields are padded with leading blanks The format of date fields depends on your Windows regional settings Export Header Select Yes if you want to include header information in the file Information when it is exported Select No if you do not want to include it Export Delimited This option is only available if you selected Delimited as the File export file type Select the delimiter type used in the text file Comma Tab or Other If you select Other enter the delimiter in the Export File Delimiter box Add Double Select this option if you want quotation marks placed around char Quotation Marks acter strings in the exported file The double quotation marks will Around Character keep the characters within the quotation marks together in the Strings export file NOTE te To export a file that you want to load into Microsoft Excel choose comma delimited Quantronix CubiScan Qbit DB 41 Export Configuration Export Layout You can change the layout of t
47. em Number F User Fields CubiScan Fields Database Fields Measurement Buttons Measure F3 E lu Update F4 gt Clear F6 ill ele IZ T If you have enabled the secondary field see Secondary Field on page 22 this button is enabled You can use it to make an additional database entry with the same item number or other primary field descriptor so that you can add another item with the same number and a secondary descriptor to make 1t a unique item The user fields section contains user defined fields These are fields that can be set up to meet your specific requirements When enabled these fields are available for entry and can be edited in the main window Refer to User Fields on page 54 for information The dimensions and weight of the freight are entered as each item is measured with the CubiScan You can also enter or edit the entries in the Length Width Height and Weight fields Gf Cubi Scan Fields Read Only is not selected in the View menu These fields display the information of previously measured items or item information that was imported into the database You can compare the imported item information to the item information in the CubiScan fields to make sure the measurements have been updated in the database The measurement buttons include the buttons you will use to mea sure freight with the CubiScan as follows Click the Measur
48. ems are updated If you are importing data into a new empty database select either Append Only or Append Update Since you are adding the data to an empty database table there can be no duplicate records 5 If you have not already done so select the other import options and map the import file fields to the database fields in the Import Layout tab 6 Click OK to save and close the Options dialog box Quantronix CubiScan Obit DB Database Management Importing a Database NOTE gt You may want to back up an existing database table before import ing the file into it Refer to Copying a Database on page 62 for information 7 Select Import from the File menu The following dialog box is displayed Esport 1 txt import data txt Sample tet My Computer O E My Network P Files of type Text Files txt csv Cancel Ze and select the 8 If necessary at the Look in box click or drive folder containing the file you want to import 9 If necessary at the File of type box click and select the format of the imported file 10 Click the name of the text file to import and it is inserted in the File name field 11 Click Open to import the file into the open database table The status of the import process and any errors encountered are dis played in the message box Quantronix CubiScan Obit DB 65 Exporting a Database Database Man
49. eport pages for printing A Page Settings dialog box is displayed Select the size orientation and margins for each page of the report and click OK Page Settings x ize Letter l Width 27 94 cm Height 21 59 cm rientation i Portrait i Landscape Right cm Bottom cm ther Apply to the current page i Apply to all pages i E Cancel Click to display an outline of the report on the left side of the win dow Click to select the drag tool The cursor becomes a hand Click in the report window hold down the left mouse button and drag the report in any direction in the window Release the mouse button when it is in the position you want Click to select the zoom tool The cursor becomes a magnifying glass Click in the report window to zoom the report magnification by 25 each time you click Click to add a blank page to the end of the report Click to delete the displayed page of the report Click to go to the first page of the report Quantronix CubiScan Obit DB 99 Report Preview Reports 4 Click to go to the previous page of the report The number of the report page that is shown in the window is dis played in this text box You can type a page number and press lt Enter gt to display that page Click to go to the next page of the report Click to go to the last page of the report Close Click to close the report and return to the Qbit DB main window Pes 100 Quantroni
50. ferent folder select the folder Select the report you want and click Open to display it Current page Pages Enter page numbers and or page ranges separated by commas For example 1 3 5 12 Prime an pages hd E Open My Network F File name Report 1 fp3 Files of type Prepared Report fp3 Cancel Quantronix CubiScan Obit DB 97 Report Preview Reports al Click to save the displayed report A Save Report dialog box is dis played Reports are saved in the CubiScan Qbit DB Data folder with an fp3 extension by default If you want to save your reports in a different folder select the folder Save report files can be opened in the Qbit DB report viewer see above Save As Fi x Save ire Data d t cE E a Report 1 fp3 hy Computer hy Network F File name Save as type Prepared Report fp3 Cancel Z Click to size the report to fit a whole page in the window Click to size the report to fit the width of the window Click to zoom the report to its full size 100 Click to display two pages of the report in the window igg Click the drop down arrow and select a size to display the report or click in the text box and enter a percentage Click to display the report on your full computer screen m Jeana 98 Quantronix CubiScan Qbit DB Reports Report Preview El amp It Click to set up the r
51. file will be exported automatically at the specified time intervals For example 1f you select 2 hours the file will be exported every 2 hours All Data If you selected a time of day or time interval for the export select Updated Data whether you want to export All Data in the database or only the Updated Data Quantronix CubiScan Obit DB 47 Export Configuration 48 Destination Click the Destination tab to set up the type of output for the export file e eraribe Eset Hile ena Mataio File P reste Wnque Riles MEME nast ETA E ma TLDS Treat TL i RSet nT a Binan Remate atn ae locaton ana Mame EE EA ina Ae Toi Sa ata lin Ele E Append Watana taie Me Beate Omgue ties Select whether you want to upload the export file to a host using FTP or output the file to an ASCII text file You can select one or the other or both options Activate FTP Upload Select Activate FTP Upload to activate the FTP upload option The data is saved in a text txt file in the CubiScan Qbit DB FT folder The file name indicates the date and time the file was cre ated Quantronix CubiScan Qbit DB Configuration Export Set up the options to upload the database file to a host via FTP when it is exported automatically You can obtain this information from your network administrator Upload Mode User ID f Overvwrite Existing File Ts Append Data To File Password C Create Unique Files Remote Host Transfer Mode
52. from the sample file are listed under Sample Fields Fields are read left to right and are determined by the import file type you selected delimited fixed length or Excel and if delimited the delimiter you selected For example if you speci fied a tab delimited file each time a tab is encountered the data following it is set up as a new field Quantronix CubiScan Qbit DB 35 Import Configuration CubiScan Database Password Import Export Factors Fields 1 4 Fields 5 8 Import Type Import Layout Auto Import AE The data being imported must be mapped to the fields in the database table 1 Load a sample file of the data to be imported 2 Select the Table Field from the pulldown list for each field Map hs Presa fa This Field Sample Fields Table Fields 256980 Primary 3 0 Length 64 0 Width 18 0 Height o in Dim Uni Load Sample 0 0 Do Not Map Primary lb secondary ib 49 667 on Clear All ft Dini Upit en gt Unit 11 20 47 AM vol Uni hd Factor ga 2 Site Id Date Time Record 1 User User Users of OK Oseng ser rt 5 Click each sample field to select it then click the table field next to 1t and select from the drop down list the Qbit DB data base field to which you want to map the import file field See the illustration above for examples To move backwards and forwards from item to item in the sample Record 2 file click the arrows beneath th
53. haracter Use the following options to set up one or more user fields User Field 8 is numeric only Quantronix CubiScan Qbit DB Configuration User Fields Field Name Type a label for the field The label is displayed in the place of the User Field default label in the main window and as the column heading in the database table Field Length Enter the maximum number of characters that can be entered in the field from 1 to 30 You will not be allowed to enter more than the specified number of characters in the field Enable Field Select this option to enable the user field Once enabled the field Mandatory Entry Include This Field When Repeating Hide Field Data Entry Type becomes available after the item number 1s entered and remains available until the record is updated Select this option 1f you want an entry to the field to be mandatory A valid entry will be required in the field before the item record can be updated Select this option if you want the user field included when you repeat an item number Repeat 1s only available 1f the secondary field is enabled refer to Secondary Field on page 22 Select this option to hide a disabled user field in the main window This option can be used to limit the type of characters that can be entered in the field to help prevent data input errors Click the option for the type of characters to be allowed Any Character Alpha Numeric Characters Alphabetic Ch
54. he database table for the export file You can select which fields you want included change the length of the field change the decimal point location or even rearrange the fields You must set up the Export Type options before you change the layout see Export Type on page 40 Do the following to set up the fields in the database table for export Select the Export Layout tab CubiScan Database Password Import Export Factors Fields 1 4 Fields 5 8 Export Type Export Layout Auto Esport 1 Select the table held that pon want exported from the pulldown list 2 Enter the places after the decimal point Note Load defaults will export all of the table fields Expor his Feta oa Table Fields i ba Load Defaults aaa Secondary if Description Ele All Remove Insert Move up Site Id Date Time 0 0 1 1 1 E 3 a 0 0 0 0 0 0 Move down kekke Click Load Defaults if you want to export the database as 1t appears in Qbit DB or to display all of the fields in the database table so that you can edit the layout Fu Er Load Defaults 42 Quantronix CubiScan Obit DB Configuration Export Clear ll Remove Insert Move up Move down E le per Click Clear All to clear all of the fields from the layout list Click a table field and then click Remove to remove the field from the exported database Click a table field and then click Insert to
55. ick Update or press lt F4 gt Quantronix CubiScan Qbit DB 7 Main Window Getting Started Customizing the You can change the position and size of the columns in the database Database View view and you can sort the items by any column as follows To change the position of a column in the table click on the heading and drag it to a new position To change the width of a column move the mouse pointer over the side of the column heading until the pointer changes to direc tional arrows Click and hold the mouse button and drag the side of the column until it is the size you want then release the mouse button Description lltenatt i To sort by the entries in a column click the column heading Click once to sort in descending order click again to sort in ascending order To return the Database View to its default set up pull down the Database menu and click Default Column Order Refer to Chapter 3 Database Management for information on managing databases Customizing the Main Window You can move resize or hide some sections of the main window to customize the display The Stacked Quantities box CubiScan picture Message box Database View and Measurement section can be resized The Stacked Quantities box CubiScan picture and Message box can be separated from the main window and moved to a different position The Stacked Quantities box CubiScan picture Message box and Database fields c
56. it If a function has an arrow on the right a submenu is dis played when you click the function You can also select a function by typing the first letter in the func tion name Quantronix CubiScan Qbit DB Getting Started Menu Bar File Menu Following are the functions available on the File menu Import Use this function to manually import data from an external source file Refer to Importing a Database on page 63 Export Use this function to export all or a portion of the Qbit DB database to an FTP site an ASCII text file or a Microsoft Excel file Refer to Exporting a Database on page 66 Exit Use this function to exit Obit DB Database Menu New Table Open Table Delete Table Empty Table Save Copy As Default Column Order Following are the functions available on the Database menu Select this function to create a new database table Refer to Creat ing a New Database on page 58 Select this function to open an existing database table Refer to Opening a Database on page 59 Select this function to delete a database table Refer to Deleting a Database on page 60 Select this function to empty or clear the currently open database table Refer to Emptying a Database on page 61 Use this function to make a backup copy of the MSAccess mdb database Refer to Copying a Database on page 62 Select this function to arrange the database columns in their default orde
57. l database table remains unchanged 1 Select Save Copy As from the Database menu and the follow ing dialog box is displayed Save As Desktop 13 f My Computer ZAE My Network P Ti ut File name Cubis can Backup Save as type us Access mdb Cancel ve 62 Quantronix CubiScan Obit DB Database Management Importing a Database 2 Database tables are saved in the CubiScan Qbit DB folder by default If you want to save the copy to a different drive or folder select the drive letter and or folder at the Save in box 3 Type a name for the duplicate database table in the File name field The mdb file extension is added automatically 4 Click Save to save the duplicate database The original data base remains available in Qbit DB The database that was open when you performed the copy function remains open You should save backups on removable media e g thumb drive tape Zip disk etc and store them in a secure place so that they are available in the event of a hard disk or other com puter failure Importing a Database Use the Import function on the File menu to import data from an external ASCII text file source You must set up the import file options before importing a file refer to Import Type on page 31 Also the layout of the information in the text file must match the Qbit DB database layout to be imported correctly Refer to Impor
58. menu then select Sensors The following prompt is displayed 2 Continue with Sensor Calibration Cancel 2 Click OK to proceed and the following dialog box appears Quantronix CubiScan Obit DB 81 Calibrate CubiScan Functions 82 Calibrate Sensors This routine will run through a series of steps designed to determine the precise position of the ultrasound transducers This procedure should be performed periodically or any time the Dimensions are not within tolerance IF you wish to continue with the calibration click CONTINUE othermize you may exit without calibrating the Cubis car 3 Click Continue or press lt F7 gt 4 Click Step 1 or press lt F1 gt 5 Clear the CubiScan of all objects and click Step 2 or press lt F2 gt 6 Place the calibration cube on the CubiScan platform with the long dimension 12 inches facing left and click Step 3 or press lt F3 gt 7 Turn the calibration cube so that the long dimension 12 inches is facing right and click Step 4 or press lt F4 gt 8 Turn the calibration cube so that the long dimension 12 inches 1s facing up and click Step 5 or press lt F5 gt Quantronix CubiScan Obit DB CubiScan Functions Calibrate The sensor calibration 1s finished 9 Click Exit or press lt F6 gt to return to the main window Laser Take the following steps to calibrate the CubiScan 30 lasers A CubiScan 30 model
59. model of CubiScan you are using Options in some tabs may vary depending on the CubiScan model selected In addition the CubiScan measuring display and the menus and functions avail able in the main window will change to match the selected model NOTE US is important to select your CubiScan model and click OK to save it before continuing to set up configuration options If you select the CubiScan 30 with serial numbers starting with 9 or 20 to 24 you are prompted to enter the CubiScan serial number Quantronix CubiScan Obit DB 19 Database Configuration Site ID Database 20 Wenfy Serial Number x Enter Cubi5bcan Serial Number Enter the serial number and click OK to close the prompt and con tinue If measurement data from your site will be exported and merged with measurement data from other sites you may want to assign a Site ID number to each site to identify the site that supplied the data If used the site ID number 1s shown in the Site ID column in the database table Enter an identification code for your site using any alphabetic or numeric characters but no symbols or spaces Click the Database tab to set up database fields options and tare values This tab also contains the option to convert an older Qbit database to the new format Quantronix CubiScan Obit DB Configuration Database Fil ew tenso Be Added Autoedvence Through teme Primary Field The primary fi
60. n Options Dimension Unita Communication Ports i Inches C Milimeters Centimeters 1 Cubiscan Senal Port Number Weight Units O Ounces i Pounds Grams f Kilograms Cubisican Model CubiScan 100 CC CubiScan 150 7 Cubiscan 50 PS Volume Units Cubic Inches C Cubic Feet Cubic Millimeters Cubic Centimeters C Cubic Meters C CubiScan 30 Serial s starting with 9 or 20 24 Cubiscan 30 Serial H s starting with 25 7 Cubiscan 2008 Site ID A Dimensional weight Unita Domestic 7 International x Cancel Quantronix CubiScan Obit DB Configuration CubiScan Unit of Measure Options Dimension Units Select the measurement units you want used to measure length width and height dimensions Inches Millimeters or Centime ters Weight Units Select the units you want used for package weights Ounces Pounds Grams or Kilograms Volume Units Select the units you want used to measure volume Cubic Inches Cubic Feet Cubic Millimeters Cubic Centimeters or Cubic Meters Dimensional Weight Select whether you want to use Domestic or International dimen Units sional weight units Refer to Factors on page 52 for information on setting up dimensional weight factors CubiScan Options Communication Enter the number of the CubiScan serial port to which the computer Ports communications cable is connected CubiScan Model Select the
61. n Please select the destination Folder For the application Preparing installation 3 Adobe Type Manager e e O ee 3 Avance Sound Manager o Installing Finalizing installation mo Bruce s Unusual Typing Wizard ay anon Ciel a Common Files PE a ComPlus Applications Sy Cubisican Alz SERE Foe path c Program Files CubiscaniQbit DB To E ner INSLAAN T E H E Adobe af 6 Accept the default path for installation of Qbit DB or select a different drive and or folder Click Next to continue The fol lowing window is displayed Quantronix CubiScan Qbit DB 105 Installing Qbit DB Installation lz Qbit DB InstallAware Wizard Start Menu eel ee Se Sy a en oe Blass calar the Sear Me nw orouo da Fhe SMr ation ollectir iq Information A Le SLAE MENS SA r r aie f Pe s e rreparing il istallat IOTI AO fon may choose bo create shortcuts For all Users or SC OF Yi 7 Accept the default Start Menu group or enter a different name Select whether you want All Users to have access to Qbit DB or you want only yourself to have access to Qbit DB on this computer If you select Just Me a password is required to open Qbit DB Click Next to continue and the following window appears 106 Quantronix CubiScan Qbit DB Installation Installing Qbit DB
62. n enter a product number in the pri mary field and then enter a pack type in the secondary field Select this option to enable the secondary field The field becomes available for entry under the primary field in the main window and the Repeat Item Number button is enabled You use the Repeat Item Number button to make an additional database entry with the same item number or other primary field descriptor so that you can add another item with the same number and a secondary descriptor to make it a unique item After you enable the secondary field you can enter a pick list of items or descriptions from which to choose at the secondary field Select this option if you want to be able to make a manual entry in the secondary field in addition to selecting from the pick list Click in the text box and enter a list of items from which to choose at the secondary field Press lt Enter gt after each item The items entered become available for selection from a drop down list in the secondary field Quantronix CubiScan Qbit DB Configuration Database Database Options The database options determine how items are entered in the data base and whether or not you can delete item records Add Update Items Select this option if you add items to the database more often than you update existing items This makes adding items the default and a warning message appears when you update an existing item Item records are identified by the
63. n the Auto Export tab Quantronix CubiScan Obit DB 51 Factors Configuration Output Mode Factors 32 Select the option you want to use to create the exported file Overwrite Existing File Select this option to overwrite a previously uploaded file Append Data to File Select this option to append add the uploaded file to an existing file Create Unique Files Select this option to export the data into a unique file that will contain only the exported records The file format is the month day year hour minutes and seconds the file was created with a hyphen and the file name you entered e g 051209170159 unique xls Click the Factors tab to enter or edit the domestic and international dimensional weight factors for the CubiScan A dimensional weight is calculated for each measurement both domestic and interna tional Quantronix CubiScan Obit DB Configuration Factors An item s dimensional weight is its density based on volume and is calculated using the following equation Dimensional Weight Length Width Height Factor Defaults Click Defaults to use the default values provided by Quantronix Or click in each text box and enter your own values for each factor Quantronix CubiScan Qbit DB 53 User Fields Configuration User Fields NOTE gt 54 User fields are fields in which you can enter in the database any additional information you want about an item User fi
64. nd number of items visible may depend on how you have moved and resized the sections in the main window see Customi1z ing the Main Window on page 8 You can also resize and rear range the columns in the database view see Customizing the Data base View on page 8 Sequence ltem Number Pack Type Description Length Width Height Weight Volume Dim w gt FY PIR 729012343 E pack Soda Pop 10 E 8 1 4 480 2 47422 2 789012343 12 pack Soda 20 12 8 25 1920 989690 4 3 769022343 6 pack Soda Pop 3 11 7 0 8 693 357216 4 709023344 Liter 3 5 12 0 75 180 0 9278350 5 709123434 Case Canned goods 12 12 7 3 1008 5 195876 4 t Moving Through Use the horizontal scroll bar to move left and right through the col the Database umns and the vertical scroll bar to move down or up through the View items in the database Use the arrow buttons to move up and down through the items as follows ry Click to move to the first item in the database in Click to move up one item at a time Click to move down one item at a time ke Selecting an Item Click to move to the last item in the database Click an item to select it for measurement or remeasurement or to display the item s measurements and weight in the measurement section You cannot edit the fields in the Database View To edit an item click it to select it then edit the data in the measurement fields To update the line in the Database View with the new information cl
65. ng a Database on page 66 and Importing a Database on page 63 for information Quantronix CubiScan Obit DB 95 Report Preview Reports Report Preview When you select a report from the Report menu it is displayed in the Preview window as shown below amp s H opem ss B 1 00313 3 m4 bl Clase Product Level 20D 1 15 14 PM Len 3 O00 Whid 5 000 Hat 12 000 Whigt 0 r50 l 130 000 Factor 194 Product Level EOS 103 26 Ph 164 11 000 Hat 7 000 i Factor 194 in l b i 202008 4 48 06 Ph Len 10 000 Whid 6 000 Hat 8 000 Wigt 1 400 v 40 000 Factor 194 81402008 5243 Pha bt Report Page 1 of 2 AA Use the scroll bars as necessary to view the pages of the report Or use the drag tool as described on page 99 Use the buttons on the toolbar to view or print the report as follows 96 Quantronix CubiScan Obit DB Reports Report Preview a Click to print the report A standard Windows print dialog box is displayed Select a printer the number of copies you want to print the pages you want to print and click OK to print the report E Generic PostScript Printer Properties Type Generic PostScript Printer Print Eo File Reverse pages apies Mumber of copies mes Click to open a different report A Load Report dialog box is dis played Reports are saved in the CubiScan Qbit DB Data folder with an fp3 extension by default If you saved your reports in a dif
66. nix CubiScan Obit DB Main Window Getting Started Measurement Section The Measurement section contains all of the fields and buttons you use to measure the height width and length of freight record the weight and enter other appropriate data ltem Humber User 1 User 5 Fack Type User 2 User User Description User 3 User 4 User 8 Cubi5 can Database 0 0000 0 0000 0 0000 0 0000 q gt Q lt AAA A A O Delete Dim vigt 44 Entry Fields The fields in which you can make an entry include the primary or Item Number field can only be edited before the measurement is taken the secondary field 1f 1t is enabled the Description field 1f itis enabled any user fields that have been enabled and the freight s measurement and weight entries Some fields are enabled or dis abled using the Options on the Tools menu refer to Chapter 2 Configuration The item number may be selected from an imported database table entered by scanning a label or entered manually as you measure the freight You can select an item in the database table to edit its mea surement fields You can edit any field that is not grayed Click in a field to edit 1t and type over the existing entry Then click Update or press lt F4 gt to update the information in the database 4 Quantronix CubiScan Obit DB Getting Started Main Window Repeat Item Number gt Repeat lt
67. on page 58 Quantronix CubiScan Obit DB 57 Creating a New Database Database Management Creating a New Database Do the following to create a new database 1 Pull down the Database menu and select New Table and the following prompt is displayed Table Hame E Please enter a table name 2 Type the name that you want to give the new database table NOTE US you enter the name of an existing database table an error mes sage appears warning you that the database already exists 3 Click OK and the new empty database table 1s opened so you can begin entering data into it 58 Quantronix CubiScan Obit DB Database Management Opening a Database Opening a Database Do the following to open an existing database 1 Select Open Table from the Database menu and the following dialog box is displayed Click table name to open Cubi can New Table All of the database tables in Qbit DB are listed 2 Click the name of the database table that you want to open and the table is loaded into Obit DB Click Cancel if you do not want to open a new table Quantronix CubiScan Obit DB 59 Deleting a Database Database Management Deleting a Database Do the following to delete a database table 1 Select Delete Table from the Database menu and the following dialog box is displayed Click table name to delete New Table x Cancel All of the database tables in Qbit DB are listed 2
68. ooo 63 Exporting a Database diri srta 66 Run Alto EXPO metrics Lehe dad dre 67 Run Manual Export 0 0 cee o 67 AU Datay Updated Data estic 67 Pate Ranco o ee liad 69 Rum Manoa EXCelEx port saint cnt dba 70 AM Data Updated ata ou acces ence eet eee EA 71 DER oie alec A etre sana a eda eee eet E ms ate eee eS 72 CubiScan Functions 0 e eee eee 75 A oe eras ah aaah yee eee ee 76 SI Satie peti Urey ear toe enh eno eae 77 E EMO a 3 tine e et Ae Bees ace e a cadet ete a a gst e taht 79 A a O alk Am ETE te ee ai 80 RAE Ae oi bas y a cdo nie eh aha edie TE 80 DEMSOlS arma slds ta E EE EE E ETE EET E 81 A E eae deat et tg OS Meg S EEE 83 A A ae a eles 83 Measuring Freight 0 cece eee eee 87 Measuring Existine Mens sic baie si ease asec Sc 88 Meastrins New ems lt 2 040 9 6149 iros perdia 90 Measuring Stacked Quantities 0 0 0 0 ccc eens 92 Ediino Data serer correu teeter bass ras 93 BOE Sect eas Geeta a A ae suo ae ween 95 BULA A 95 Repor Preview o A ASAS 96 Quantronix CubiScan Qbit DB 111 Contents Appendix A Installation o0oooo oooocoooo ooo 101 System REGUIMCINGINS 2 a Bd OF aaa 101 Installing ObIeDB lt cortita uta ida 102 Appendix B Frequently Asked Questions 111 1V Quantronix CubiScan Qbit DB Chapter 1 Getting Started This chapter provides instructions for starting and exiting Qbit D
69. plicate items are updated Import Delimited This option is only available if you selected Delimited as the File import file type Select the delimiter type used in the text file Comma Tab or Other If you select Other enter the delimiter in the Import File Delimiter box Import Layout The layout of the information in the text file must match the Qbit DB database layout to be imported correctly You must set up the Import Type options before you map the layout see Import Type on page 31 Do the following to map the fields in the text file to the Qbit DB database fields Quantronix CubiScan Obit DB 33 Import Configuration 1 Select the Import Layout tab 2 Create a sample file from the file you want to import The file should contain a sample of every field in the import file so that all fields can be mapped to a corresponding field in Qbit DB The sample file must be the same type that you selected under Import File Type in the Import Type tab 34 Quantronix CubiScan Obit DB Configuration Import 3 Click Load Sample to load the sample file you created The following dialog box is displayed El E Look ir Data de import data tet My Computer ee File name Files of type Text Files tet ce Cancel Ee 4 If necessary browse to the folder containing the sample file select the file and click Open The fields
70. r Quantronix CubiScan Qbit DB 11 Menu Bar Getting Started View Menu Picture Stacking Message Box CubiScan Fields Read Only Database Fields Load Default View Save as Default View Lock View Click this function to show or hide the CubiScan Picture A check mark indicates 1t 1s shown Click this function to show or hide the Stacked Quantities box A checkmark indicates 1t 1s shown Click this function to show or hide the Message Box A checkmark indicates it is shown Click this function to make the CubiScan fields read only With this function selected you will not be able to make entries or edit infor mation in any of the CubiScan fields Click this function to show or hide the Database Fields A check mark indicates they are shown If you have changed the arrangement of sections of the main win dow see Customizing the Main Window on page 8 select this function to return it to the default view If you have changed the arrangement of sections of the main win dow see Customizing the Main Window on page 8 select this function to save the new arrangement as the default view If you have changed the arrangement of sections of the main win dow see Customizing the Main Window on page 8 select this function to lock the position of the sections so that cannot be moved Select Unlock View to unlock them Tools Menu 12 Following are the functions available on the
71. r instructions When using the CubiScan 30 caliper to manually measure an object select this function to measure the length When using the CubiScan 30 caliper to manually measure an object select this function to measure the width When using the CubiScan 30 caliper to manually measure an object select this function to measure the height Quantronix CubiScan Obit DB 13 Menu Bar Getting Started Actions Menu Following are the functions available on the Actions menu Swap Length for Select this function to switch the length and width measurement val Width ues for the current item Swap Width for Select this function to switch the width and height measurement val Height ues for the current item Swap Height for Select this function to switch the height and length measurement Length values for the current item Reports Menu Following are the functions available on the Reports menu Detail Select this function to generate a report that lists all information in the currently loaded database table The report can be viewed on screen or printed Refer to Chapter 6 Reports on page 95 Help Menu Following are the functions available on the Help menu About Select this function to display the current version and build of Qbit DB and information about Quantronix Inc 14 Quantronix CubiScan Qbit DB Getting Started Status Bar Status Bar The Status Bar 1s located at the bottom of the main window and pro
72. re going to measure Verify that all of the CubiScan options have been set up cor rectly see CubiScan on page 18 Place the item to be measured on the CubiScan refer to your CubiScan Operations Manual for details on correct freight placement In Qbit DB select the item to be measured using one of the methods described at the beginning of this section ARAAAAA Click Measure F3 to measure the item The measurement process 1s shown on the screen the measurements are inserted into the Quantronix CubiScan Obit DB Measuring Freight Measuring Existing Items dimension fields and a simulation of the measured freight is shown in the CubiScan picture box ey gt ltem Number Pack Number User 5 789230301 3321 Pack Type User 2 User 6 Case Description User 3 User Bottles User 4 User 8 Repeastitenn Wumen Ea o ILLL CubiScan Database Measure F3 Lenathtin 24 0000 24 0000 N 4 Wicthtiny 120000 120000 A rd Height in 12 0000 12 0000 af FG Weight lb 6 0000 6 0000 Opening Table gt CubiScan a z Connected to Serial Port 1 Volume in3 3456 0000 3456 0000 CubiScan Model 100 Selected i Connected to Serial Port 1 Delete Dim Wegt 194 17 8144 17 8144 CubiScan Model 100 Selected 10 0000 x 6 0000 x 8 0000 in 1 4000 lb 480 0000 in3 2 4742 194 x ltem Number Pack Type Description Length Width Height Weight Yolume Dim Wat Dim Unit Wot Unit Yol Unit Factor
73. re zeroed the following message is displayed eromng Completed 4 Click OK to return to the main window Status Use the Status function to verify that the CubiScan is operating properly 1 Select Status from the Tools menu and the following prompt is displayed AN The Cubiscan must be clear of all objects i Cancel 2 Verify that the CubiScan platform is free of ALL objects then click OK to proceed Quantronix CubiScan Qbit DB TI Status CubiScan Functions 3 The current status is checked and an appropriate message returned If there are no problems the following message is dis played Cubi can OF Return Code T400 4 Click OK to return to the main window If any problems are found an error message appears For exam ple TAXX error message where XX 1s the error number If you get an error message first verify that the CubiScan is turned on then refer to the Troubleshooting chapter in your CubiScan manual for further help 78 Quantronix CubiScan Obit DB CubiScan Functions Test Mode Test Mode Use the Test Mode function to set up the CubiScan for testing pur poses When you select this function the CubiScan measures weighs and displays the results continuously as shown below Cubi5can Test Mode Length Width Height weight The collected data continues to scroll on the screen until you exit test mode The data collected is not recorded or save
74. reated 4 Click Find Old Table to find the old Qbit database The fol lowing dialog box is displayed 26 Quantronix CubiScan Qbit DB Configuration Database lx Look ir Data amp E 02 26 04 db E My Network P File name Files of type Paradox Cancel Zi 5 If itis not already selected browse to the CubiScan Qbit Data folder containing the old database that you want to con vert All files with a db extension are listed Select the database file to convert and click Open The Paradox database table is displayed in the Old box with the number of records in the database shown Paradox record count 11 Tennis Ree Nin leran wah Het Brett wa Urabe ve g 2356380 1 b4 18 in 246 2 lb 45 667 ft 2306300 2 Ef TG in 222 0 lb 167 969 f El 2906391 4 oe o6 T4 in 325 lb 301 595 f 2356981 4 de 14 14 in 1123 lb 3 078 ft 4 Description Quantronix CubiScan Qbit DB 27 Database Configuration 6 Click Convert The database is converted and the following prompt appears Information x a l Q Database converted 7 Click OK to close the prompt The new Access database table is displayed in the New box and the record count is shown Paradox record count 11 Tennis Ree Nin leron wan Hogi Brett wa Urabe ve g 2356380 1 bd 18 in 246 2 lb 45 667 fk El 29596391 2 Ef TE in 22 8 lb 167 365 f El 2306900 4 oe
75. rs 1 to 59 minutes and 1 to 59 seconds Click once to scroll one at a time or click and hold to scroll quickly through the numbers in sequence The selected file will be imported automatically at the specified time intervals For example if you select 2 hours the file will be imported every 2 hours Quantronix CubiScan Obit DB 39 Export Configuration Export The Export option on the File menu is used to export data to an external ASCII text file or upload it via FTP File Transfer Proto col Refer to Exporting a Database on page 66 for information Click the Export tab to set up the export options the layout of the exported database fields and the automatic export function NOTE gt The options in the Export tab do not apply when you export a data base using the Run Manual Excel Export function see page 70 Export Type Select the Export Type tab to set up the options that define the type of files that can be exported 40 Quantronix CubiScan Obit DB Configuration Export Export File Type Select the file type to be used when exporting database files The default is delimited Delimited Variable length delimited files csv or txt file extension contain variable length records each separated by a carriage return line feed pair Fields may vary in length and are separated by field separators Leading and trailing spaces for numeric and character fields are truncated The format of date fi
76. rvals or after every update click the Auto Export tab You must set up the Export Type options and the Export Layout before you set up auto export see Export Type on page 40 and Export Layout on page 42 After you set up an auto export the number of hours minutes sec onds to the next scheduled export 1s displayed in the status bar of the main window see Main Window on page 2 Click the Frequency tab to set up the time s to export the file then click the Destination tab to select the type of output Quantronix CubiScan Obit DB Configuration Export NOTE gt The options in the Destination tab are not available until you select a frequency option in the Frequency tab Frequency Click the Frequency tab to set up the mode and times to export M erabe Tine Enable time 2 imei Imes 12 00 4M 12 00 AM Enable Time J Enable Time 4 mea lime 12 00 AM 12 00 AM pee eres O patea Wata Export Mode Select the mode for automatic exporting as follows Off Select this option to disable automatic export Export at Specified Time of Day Select this option to set up a time of day to export the database file The Export Times options become available to set up the time s of day for export Quantronix CubiScan Obit DB 45 Export Configuration Export Times 46 Export at Specified Time Interval Select this option to set up a time interval to export the database file The
77. s are truncated The format of date fields depends on your Windows regional settings If you select this option additional options to define the delimiter type become available at the bottom of the tab see Import Delimited File on page 33 Fixed Length Fixed length files txt contain fixed length records each separated by a carriage return line feed pair Fields are fixed in length with no field separators Character fields are padded with trailing blanks and numeric fields are padded with leading blanks The format of date fields depends on your Windows regional settings Microsoft Excel Files that are formatted for Microsoft Excel x s file extension The Excel sheet name must be Sheet to be imported correctly Only files created in Excel versions earlier than 2007 can be imported xls files Select Yes if the file to be imported contains header information If the file contains header information and you do not select Yes the header information will be imported as data Select the method you want to use to import the data into an existing database Append Only Only new items are added to the existing database Duplicate items items with the same item numbers are not added or updated Update Only Duplicate items are updated but new items are not added to the database Quantronix CubiScan Qbit DB Configuration Import Append Update New items are added to the existing database and any du
78. t Layout on page 33 for instructions on mapping the fields in an import file to the Qbit DB database fields NOTE gt Because older versions of Qbit create Paradox databases while Obit DB creates Access databases you cannot import a database from a previous version of Obit To load a database from a previous version of Obit use the Convert Qbit Win Qbit WMS Database function in the Database tab of the Options function Refer to Con vert Qbit Win Qbit WMS Database on page 25 Do the following to import data into a database Quantronix CubiScan Obit DB 63 Importing a Database Database Management 64 NOTE t 1 Open the database to which you want to add or update the new data see Opening a Database on page 59 If you want to create a new database with the imported data create a new empty database with a unique name in which you will insert the imported data see Creating a New Database on page 58 2 Pull down the Tools menu and select Options 3 Click the Import tab and then the Import Type tab 4 Select the method you want to use to import the data into the existing database Append Only Only new items are added to the existing database Duplicate items items with the same item numbers are not added or updated Update Only Duplicate items are updated but new items are not added to the database Append Update New items are added to the existing database and any duplicate it
79. tarted oo ooooccoooocooooooo 1 Sarns Exito Os DB ei nda paa aah hae ade ad sie wees l Mal WIdOWs dad di E ia ob 2 Stacked Quantities BOX o oooooococoooooooo Ea aa 3 Measurement SeCtiOn 62 5 os ashe Sa a 4 Pints Rda oo Gt Sets ae a eae ale a ats hus 4 Repeat Item Num Der asas ces ee oe lt n eee 5 senil coin rada tido 5 CubisScan PICS ostra ia ae 5 Database Fields 6 245 62020463 A aa 5 Measurement DUMONS cecilia IS eee Yee 5 CubisScar PAC UTE BOX cia da id tits 6 loformation BOX a ANA E wha aS 6 Database VIEW rastas Badd ida 7 Moving Through the Database VieW 7 Sclectine AAA A Sees 7 Customizing the Database View 0 0000 8 Customizing the Main Window 0 0 cece eee eee ees 8 Resize rs lara 9 A O A A a oat a en een eats 2 8 9 Edi SHOWING 125 424 Gone wee dee id oes 10 Sayinesa VIEW 242k hata he als Goes Sa aw ea ln ae 10 Mo neBa srt ie Sena Ak oe iiem eee 10 ULC A O ak se yaks ek anaes cee aoe 11 Database Men sins ea ae lS Gente ae hy he oes 11 VEW MENU a A deus edhe ed See Bee eS 12 TOO MIC Eras a bat oe aes Soe ee to Rib ede eeu pues 12 Caliper WG MW occa hha Rg Bie aah Oi bos ea gee at eee ee 13 Quantronix CubiScan Qbit DB 1 Contents Chapter 2 ACON MEL ia ale 14 Reports Men siste rito ds dae Ta ecos As 14 Help Menta ia Dee Sena ewe sees 14 Status Dal sap Ia debe eh een es 15 Configuration 0 0 0 00 ccc cece eee 17 CUBIS CA
80. x CubiScan Obit DB Appendix A Installation This appendix provides instructions for installing Qbit DB System Requirements Processor Memory Hard Disk Display Operating System Other Qbit DB is designed to operate with the following minimum com puter requirements PC Pentium III processor or better 256 MB RAM 40 MB disk space available VGA 1024 x 768 or higher resolution color display will not operate at a lower resolution e g 800 x 600 Microsoft Windows 95 Windows 98 Windows NT Windows 2000 or Windows XP Quantronix Inc CubiScan unit attached to computer Quantronix CubiScan Qbit DB 101 Installing Qbit DB Installation Installing Qbit DB Do the following to install Qbit DB on your computer 1 Close any open Windows applications 2 Insert the CubiScan CD ROM in your CD ROM drive The Setup Wizard should start automatically If it does not click Start click Run type d setup in which d is the letter of your CD ROM drive and click OK The following prompt is displayed Select Setup Language Fa Select the language For this installation From the choices below 3 If you want the installation in a language other than English select the language from the drop down list Click OK to pro ceed 102 Quantronix CubiScan Qbit DB Installation Installing Qbit DB The welcome window is displayed AZ Qbit DB Install ware Wizard Welcome to Obit DB

CubiScan® Qbit-DB™

Contents

Download Pdf Manuals

Related Search

Related Contents

CubiScan&reg; Qbit-DB&trade;

Contents

Download Pdf Manuals

Related Search

Related Contents

CubiScan® Qbit-DB™