Home

Qbit-DB Software User Manual

Contents

1. Export on page 39 Select export options set up the layout of the exported database fields and set up the automatic export function Factors on page 50 Enter the values used for dimensional weight factors User Fields on page 52 Setup from one to eight user defined fields Tolerances on page 54 Setup tolerance values validation options or validation events Orientation on page 57 Setup the orientation settings of measurements Login on page 59 Setup user ID options and settings Camera on page 61 Setup a network or digital camera with Qbit DB This tab is a special feature that does not appear on the Options menu unless you have purchased the camera add on package from Quantronix 16 Configuration CubiScan CubiScan Qbit DB e Reports on page 68 Setup label report printing and select label setup options e Nesting on page 69 Enable nesting and select nesting settings This tab is not available when the CubiScan 200TS 210 or 225 is selected 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 The User Fields tab has a unique saving mechanism for more information see Select User Field on page 61 Click the CubiScan tab to set up the measurem
2. 3 Place the item to be measured on the CubiScan refer to your CubiScan Operations Manual for details on correct object placement 4 In Qbit DB select the item to be measured using one of the methods described at the beginning of this section 5 Click to measure the item The measurement process is shown on the screen the measurements are inserted into the dimension fields and a simulation of the measured object is shown in the CubiScan picture box File Database View Tools Actions Reports Help Language sx Stacked Qty s Hn Length 1 H wan T Pros PRA opr provide Width in 202000 amn measurement t Height in 135000 M z Weight Ib 231300 Ma Volume in3 22700 i M DimWgt 166 ABRI 16 5920 Height Weight Volume Dim Wgt Dim Unit Wat Unit Vol Unit Factor Site ld Date Time 27 3 40 44 12869 766 77 5287 in 166 3 16 2015 9 26 11 AM 124 85 503 616 3 0338 lin in 166 3 16 2015 9 26 19 AM 27 62 7047 94 42 4575 in in 166 3 16 2015 9 26 30 AM 23 13 2754 27 16 592 in in 166 3 16 2015 9 26 40 AM 106 28 110422 66 5193 in in 166 3 16 2015 9 26 48 AM 6 2345452487 5 21 03 4711 941 28 3852 in in 166 3 17 2015 1 27 25 PM 7 Book1 8 3 78 27 2119 32 12 767 in in 166 3 17 2015 1 29 31 PM 8 77YJ2 54 18 17573 76 105 866 in in 166 3 16 2015 9 27 20 AM 9 2355 7 2 2 6188 0 37 2771 in in 166 3 16 2015 3 43 19 PM 10 34656547 5 8 31 34 134 676 0 8113 lin in 166 3 16 2015
3. Access record count 0 Figure 13 Convert Paradox to Access QbitWMS Window 5 Click Find Old Table to find the old Qbit database 6 Ifitis not already selected browse to the folder containing the old database that you want to convert All files with a db extension are listed Select the database file to convert and click Open Qbit DB 28 Configuration Database The Paradox database table is displayed in the Old box with the number of records in the database shown C Convert Paradox To Access Qbit Application C QbitWin a QbitWMS OLD PE Convert Qbit30Win Pallet Pack la f Close C Qbit50PS Master Pack lb C Qbitb0WMS C Qbit150 C Qbit1I50WMS Inner Pack Each Pack Paradox record count 1 _ Productio Factor__ PPUPC gt 234545555 Access record count 0 Sequence Primary Secondo Figure 14 Convert Paradox to Access Conversion Window 7 Click Convert The database is converted and the following prompt appears Information O Database converted 8 Click OK to close the prompt Qbit DB 29 Configuration Password The new Access database table is displayed in the New box and the record count is shown Convert Paradox To Access i x Qbit Application Pack Types Useri User2 User3 Userg 4 gt Find Old Table C QbitWin cues op MEM Qbit30Win Pallet Pack la C QbIt50PS Master Pack lb C QbitSOWMS C Qbit
4. 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 Enable Tare Option Length Width Height Weight Show Error on Zero Tare values are preset dimensions to be subtracted from a measurement 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 If you use tare values all or part of the time click this option to enable tare If enabled two new options appear on the Actions menu The Apply Tare Values or lt Ctrl gt lt T gt applies the tare values to the current measurement The Enable Automatic Tare or lt Ctrl gt lt Alt gt lt T gt automatically applies the tare values to each measurement until it is disabled Enter tare values for measurements and weight as applicable Each specified value is subtracted from the dimension measurement or weight Select this function if you want Qbit DB to alert you if an item number s measurement information is zero or less than zero once the tare values have been applied Description Field Enable Field Qbit DB Select this option to enable the Description field in the main window under the primary and secondary fields You can then enter a description for each item which will appear in the
5. ix Stacked Qty s wni H tei wih Stacked Oly is the nu items ltem Number Length in Width in Height in Weight Ib 09 51 47 832 Application Startup Vol ins aa 1109 51 47 967 Opening Table gt Tuesday May 5 2015 lume in3 09 51 49 960 CubiScan Model 100 Selected 09 51 50 557 Connected to Serial Port 5 Dim Wat 166 A Dim Wat Dim Unt Wat Uni Vol Unt Facto a Table Tuesday May 5 2015 Record 0 of 0 Updated Records 0 Next Import Disabled Next Export Disabled Figure 1 Main Window 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 Qbit DB 6 Getting Started Main Window The following functions are performed at the main window e Measure and weigh objects see Chapter 5 Measuring Objects on page 93 e Add update database entries see Database Window on page 11 e Access all other Qbit DB functions using the menus see Menu Bar on page 1 The main window is divided into several windows as described in the following windows You can move resize or hide some windows to make it easier to view only what your needs require refer to Customizing the Main Window on page 13 Stacking Window The stacking window can be used to stack like items that fall beneath the minimum measuring requirements
6. 106 28 11042 2 66 5193 lin in 3 16 2015 9 26 48 AM 6 2345452487 21 03 7 28 3852 in in 3 17 2015 1 27 25 PM 7 Book1 5 8 3 78 27 12 767 in in 3 17 2015 1 29 31 PM 8 77YJ2 54 18 7573 71 105 866 in in 3 16 2015 9 27 20 AM 9 2355 7 2 7 2771 lin in 3 16 2015 3 43 19 PM 10 34656547 8 31 34 Y in in 3 16 2015 4 28 02 PM 11 346546 6 in in 3 17 2015 11 10 43 AM 12 23535 4 767448 0 4623 1807 in in 3 17 2015 1 29 51 PM 13 45757 2 8 0 0 0482 in in 3 17 2015 10 18 46 AM 14 3246346 120 0 0 7229 in in 3 17 2015 1 31 46 PM 15 345435 454 937710 0 5648 8554 lin in 3 17 2015 3 58 23 PM Record 4 of 15 Updated Records 15 7 This step is only necessary if tare is enabled and the object 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 Values on page 24 for information 8 Edit the data as required see Editing Data on page 99 9 When you are finished click to update the item record To clear an item s measurement data and start over or to measure a different item click Ea 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 M
7. D Qbit DB ice General options h Open folder to view files using Windows Explorer View more AutoPlay options in Control Pane 3 Click Open folder to view files 4 Double click the Qbit DB Setup file 5 If you want the installation in a language other than English select the language from the drop down list Click OK to proceed Select Setup Language Select the language for this installation from the choices below English y Installation Installing Qbit DB The welcome window is displayed F y Qbit DB InstallAware Wizard Welcome to Qbit DB Setup Figure 48 Obit DB Installation Welcome Window 6 Click Next to continue and the license agreement window is displayed Fj Qbit DB InstallAware Wizard License Agreement QUANTRONIX INC LICENSE AGREEMENT This License Agreement governs your use of the enclosed Software E product By installing and or using the Software you agree to be bound by the terms of this Agreement If you 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 Figure 49 Qbit DB Installation License Agreement Qbit DB 108 Installation I
8. Digital Camera Installation Sixth Screen 0 cece cece een een enee 120 Digital Camera Installation Seventh Screen 0 0 ccc ee eee ene 121 HOS Wier acc auaa ween ae aes Ai dao aaa 123 EOS Utility Basic Settings Screen o ooooooooconcroncrrnrrnrrnnmo monos 123 EOS Utility Destination Folder oooooooooooooomoronrsrnnrrn roo 124 Camera aa ii a aa 125 Remote Image Capturing WindOW 0 ce cc cece eee o 126 Camera Image WiINdOW iis bubs ed Rh des iii 127 Device Manar sil dE A AA See Res 129 Figure 71 Text Import Wizard Chapter 1 Getting Started This chapter provides instructions for starting and exiting Qbit DB and describes the different areas and the functions performed at the main window Starting Exiting Qbit DB Menu Bar 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 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 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 it If a function has an arrow on the right a sub menu is displayed when
9. Open Qbit DB The following window appears Database Utility To copy data from the cubiscan mdb database to the new QbitDB mdb database select a table name from the list and dick the Transfer Data button Note The current Obit DB database table must be empty Transfer Data eT Do Not Display This Dialog Again Figure 54 Database Utility Window 2 Select the database that you would like to copy 3 Click Transfer Data If your current database is not empty you will receive an error message Empty your current database and restart Qbit DB The following message appears ice Information J Successfully copied 5003 records from old database to new database 4 Ifyou have copied all the database information that you want select the Do Not Display This Dialog Again option If you do not select this option the Database Utility window will appear each time you open Qbit DB Your old version of Qbit DB will be automatically deleted when the new version is installed The name of the database that is being imported cannot contain any spaces If the database that you are tying to import does have spaces in the name contact Quantronix Technical Support at 801 451 0500 NOTE t amp Qbit DB 113 Installation Installing a Network Axis Camera Installing a Network Axis Camera Ensure that you have received all of the correct parts and quantities for the Axis network camera kit by refer
10. Time 1 text box in a 12 hour clock format i 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 available Timer to set up the 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 Qbit DB 38 Configuration Export Import at Program Startup Prompt for Confirmation When Importing Delete File After Auto Import Export NOTE gt Qbit DB 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 When this function is enabled the selected file will automatically be imported each time Qbit DB is started When this function is enabled Qbit DB will prompt you for confirmation when importing the file When this function is enabled the file that was imported into Qbit DB will be deleted 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 Protocol Refer to Exporting a Database Table on page 80 for information Cli
11. pull down the View menu and click the window you want to hide Pull down the menu and click it again to show a hidden window You can also click the x on the docking bar or title bar of the stacking window CubiScan picture window or message window To show the window again select it from the View menu After you have customized the view of the main window you can lock the windows 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 Lock View Select this function to lock the position of the windows so they cannot be moved Select Unlock View to unlock the windows The Status Bar is located at the bottom of the main window and provides the following information Updated Records 1 Table CubiScan Qbit DB Name of the currently loaded database table Record 1 of 1 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 14 Getting Started Status Bar Qbit DB 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 upd
12. you are measuring Verify that all of the CubiScan options have been set up correctly see CubiScan on page 17 Place the item to be measured on the CubiScan refer to your CubiScan Operations Manual for details on correct object placement Verify that the cursor is in the Item Number field If not click to save the last measurement or click 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 Click to measure the item The measurement process is shown on the screen the measurements are inserted into the dimension fields 95 Measuring Objects Measuring Items with XRef Lookup Enabled and a simulation of the measured object is shown in the CubiScan picture box User 4 ls 0 ly l CubiScan Database tdi AE Length in 10 1000 10 1000 d to provide m Width in 20 2000 20 2000 Update F4 Height in 13500 135000 Weight Ib 23 1300 23 1300 Clear F6 Volume in3 Zz AA it Dim Wot 166 16 5920 16 5920 Nesting F11 Wei Volume Dim Wot Dim Unit Wat Unit Vol Unit Factor Site Id Date Time 40 44 12869 766 77 5287 in lb in 166 3 16 2015 9 26 11 AM 124 85 503 616 3 0338 in in 3 16 2015 9 26 19 AM 27 62 7047 94 42 4575 in in 3 16 2015 9 26 30 AM 23 13 2754 27 16 592 lin in 3 16 2015 9 26 40 AM
13. 1 6309 166 Figure 30 Automatic Dimension Orientation In this field you can select a dimension that is excluded from the automatic orientation sorting process The dimensions that you can exclude are None Length Width and Height Choose the value you would like associated with the CubiScan measurements length width and height The drop down values are Smallest Middle and Largest 58 Configuration Login Login From this tab you can select a user ID and the field in which it will appear CubiScan Database Password Import Export Factors User Fields Tolerances Orientation Login Camera Reports Nesting Options Select a user D option and the user field that the user ID will be saved in for each measument taken Close and restart the application for the changes to take effect User ID OF f Capture Windows User Account ID f Prompt for User ID at Application Startup i Prompt for User ID at Application Startup Using Drop Down List f Prompt for User ID and Password at Application Startup Select User Field D Figure 31 Login Tab Options Select User ID options After making these changes Qbit DB must be closed and restarted for the changes to take effect User ID Select your preferred User ID option from the following options Off Select this option if you do not want Qbit DB to prompt the user for an ID or password Capture Windows Select this option if you want Qb
14. DB The file must be the same type that you selected under Import File Type in the Import Type tab 3 Click Load Sample to view sample records of the data contained within the file 4 Ifnecessary browse to the folder containing the file select the file and click Open The fields from the 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 specified a tab delimited file each time a tab is encountered the data following it is set up as a new field Qbit DB 35 Configuration Import CubiScan Database Password Import Export Factors User Fields Tolerances Orientation Login Camera Reports Nesting Import Type Import Layout Auto Import 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 held Map This Field To This Field cc Primary Secondary E Load Sample P Clear All x Cancel Figure 19 Import Layout Load Sample 5 Click each sample field to select it then click the table field next to it and select from the drop down list the Qbit DB database field to which you want to map the import file field The Primary database field is usually always associat
15. DIGITAL Solution Disk Digital Camera Software Easy Installation e Automatically installs all software gt Custom Installation Select the software that you want to install CANON iMAGE GATEWAY Register gt A ANON Figure 60 Digital Camera Installation Fourth Screen Qbit DB 119 Installation Installing a Digital Camera Qbit DB 7 Uncheck everything except EOS Utility Click Next Select Digital Photo Professional Confirmation EOS Utility Picture Style Editor ZoomBrowser EX Installation EOS Sample Music Registration Movie Uploader for YouTube 30 MB Da Finish View a description of the software by passing your mouse over the name of the software C Program Files x86 Canon Select the software that you want to install 4 Back A Next gt Figure 61 Digital Camera Installation Fifth Screen On the Confirmation screen make sure that EOS Utility is the only software that is going to be installed then click Install Fa EOS Utility Confirmation Installation Registration Finish View a description of the software by passing your mouse over the name of the software C Program Files x86 Canon Click Install to start installing q Back instali Pp Figure 62 Digital Camera Installation Sixth Screen Select Yes on the License screen if you agree with the License Agreement 120 Installation Installing a
16. Digital Camera 10 On the Installation screen EOS Utility will be installed The results of the installation will be displayed Click Next OK E EOS Utility fa Installed Step A Installation Step 5 Step 6 Figure 63 Digital Camera Installation Seventh Screen 11 On the Registration screen you can register your camera if you wish Registration is not required to connect your camera to Qbit DB Make your selection and click Next 12 When you are finished with the installation process click Finish Loading the Digital Camera Driver Before loading the digital camera driver ensure that your camera s battery is charged To load the digital camera driver onto your computer complete the following steps 1 Locate the camera to USB cable that came in the camera box 2 Plug one end of the cable into the camera and the other end into an available USB port on your computer Use the USB extension cable if needed 3 Make sure that the camera is set to Auto Mode 4 Turn the camera on Qbit DB 121 Installation Installing a Digital Camera 5 The driver should automatically be installed onto your computer Canon EOS REBEL T3i installed Canon EOS REBEL T3i off Ready to use The following message will appear telling you that the driver has been successfully installed Connecting Your Camera to Qbit DB NOTE I Qbit DB To connect your camera to Qbit DB you will need to configure the EOS
17. Qbit DB Qbit DB 110 Installation Installing Qbit DB 10 Click Next to continue and the following window appears Fj Qbit DB InstallAware Wizard Ready to Install Collecting information Setup is ready to start installing Qbit DB Preparing installation Installing Please dick Next to install now Click Back to review your installation settings Finalizing installation InstallAware Figure 52 Qbit DB Installation Ready to Install 11 If you want to review or change any of the settings click Back If not click Next to continue Qbit DB 111 Installation Installing Qbit DB 12 When the installation is complete the following window appears Fj Qbit DB InstallAware Wizard Qbit DB Setup Complete Collecting information Qbit DB has been installed successfully Preparing installation Installing Finalizing installation to Run Qbit DB now InstallAware Figure 53 Qbit DB Installation Setup Complete 13 If you do not want to start Qbit DB now click to remove the checkmark Click Finish to exit and close the installation window Installing a New Version or Update of Qbit DB If you are installing a new version or update of Qbit DB that is older than version 02 13 0006 or installed prior to March 2015 complete the installation steps listed above You will then need to complete the following steps listed in this section Qbit DB 112 Installation Installing Qbit DB 1
18. When you are finished click Calculate F11 or use the measuring gate to take a measurement If you wish to quit without calculating the nesting factor click Cancel 5 The nesting factor is calculated and placed in the selected user field 6 Click Update to save Special Features The following special features that Qbit DB offers are Windows system manual configuration ini files The ini files can be found in the CubiScan folder or you can find the shortcut under Start gt All Programs gt CubiScan These ini files can be edited and configured to fit your specifications Making changes to these files will require you to close and restart Qbit DB Barcode ini The barcode ini file can be used to configure a barcode scanner with Obit DB The RS232 serial barcode scanner will not need Windows focus to feed data into the Qbit DB primary field If the barcode has unique piece information it can be parsed to different fields Piece number information is fed into user field 6 Piece count information is fed into user field 7 Qbit DB 71 Configuration Special Features Qbit DB Database Maintenance ini Log ini ODBC ini The database maintenance ini file allows you to setup a time for your database records to be automatically moved or deleted depending on the settings that you specify The log ini file can record and delete daily logs according to your specifications The log ini file can also control the type of mess
19. 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 You can remove these boxes from the measurement window by selecting View gt Database Fields The measurement buttons include the buttons you will use to measure objects with the CubiScan as follows Click the Measure button to measure the object 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 item and start over Click the Delete button to delete the current record This button must be enabled refer to Enable Record Delete Button on page 24 CubiScan Picture Window Qbit DB After you specify the CubiScan model to which your computer is connected refer to CubiScan on page 17 a simulation of the CubiScan is displayed Getting Started Main Window in the picture window After you measure objects the object and its measurements are also shown Figure 4 CubiScan Picture Window Camera Image Window The camera image window displays the image that was taken of the object This is an optional feature that requires the camera add on package For more information on this feature see Camera on page 61 If no image is available the window displays the message No Image This
20. You can select an item in the database table to edit its measurement fields You can edit any field that is not disabled Click in a field to edit it and type over the existing entry Then click Update or press lt F4 gt to update the information in the database Repeat Item Ifyou have enabled the secondary field see Secondary Field on page 21 Number _ 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 it a unique item User Fields The user fields section contains user defined fields These are fields that can be set up to meet your specific requirements When enabled these Qbit DB 8 Getting Started Main Window CubiScan Fields Database Fields Measurement Measure F3 Update F4 Clear F6 Delete Uy c s ix Be n a O U fields are available for entry and can be edited in the main window Refer to User Fields on page 52 for information The dimensions and weight of the object 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 if CubiScan 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
21. a ti rara 70 A O acy hee ty a E ET ORES 88 CUBIS CAH Valles oi Ue WG athe ease cree cc BO eee eee 89 Calibrate Sensorial Bae a DOE aa whee ees 90 Scale CADERA AAA E SOON RS 92 XREF GD Xai Cl xi acca ands a deewctaes aa ea a 97 Detail Report Pre vie Wal id ted dt a a PEA 101 abel Report PECVICW ves sra it iii e 102 FastReport Win dOW s sica ada iii 105 Qbit DB Installation Welcome Window 0 cc ccc ee ec eee eee eee eens 108 Qbit DB Installation License Agreement 0 0c ccc cece eee teenies 108 Qbit DB Installation Destination Folder 0 0 0 0c ccc ce eee eens 109 Qbit DB Installation Start Menu 0 ee ee eee eee eee eees 110 Qbit DB Installation Ready to Install ooooooooooooomoooooo 111 Qbit DB Installation Setup Complete 0 00 ccc eee enn en 112 Database Utility Window 0 ccc ccc ee cence nee nee e eee en ees 113 Axis Camera Kit Components ccc cee cece cee e eee e eee e neces eeeseesees 114 Digital Camera Kit Components 0 0 ccc ccc cee eee teen eeeaee 116 Digital Camera Setup First Screen oooooooooomoonorrncrrncrrnmnmoooso 118 Digital Camera Setup Second Screen 0 e eee e eens 118 Digital Camera Setup Third Screen 0 0 ccc ce eee eee eee nee nee 119 Digital Camera Installation Fourth Screen 0 0 ccc cee een eens 119 Digital Camera Installation Fifth Screen 0 ccc een cence nee 120
22. camera setup options Enter the IP address in this field The IP address that you should enter is printed on the Axis camera box The default IP address setting is usually 10 1 100 40 but check your Axis camera box to be sure The IP port number should automatically be filled in Enable this field if you want a snapshot to be taken automatically after you measure an item In this field you can edit the number of seconds for which the snapshot is displayed in the camera image window after a snapshot has been taken Enable this field if you want to be able to take multiple snapshots of an item For the Multiple Snapshots function to work properly Qbit DB needs to be closed and restarted when this field is enabled or disabled 63 Configuration Camera Test Connection Stop Connection Qbit DB When you enable this option a new Slide Show View button appears at the bottom of the camera image window Figure 34 Slide Show View To view all the snapshots associated with an item number click on Slide Show View Use the Prev and Next arrows to scroll back and forth through the snapshots Click Live View to display the live feed from the camera When both Auto Snapshot After Measure and Enable Multiple Snapshots are enabled at the same time only the first snapshot will be automatic To obtain additional snapshots click Snapshot Click this button to test the camera connection If the connection is successful t
23. database table 24 Configuration Database Include this field Select this option if you want the item description included when you when repeating repeat an item number Repeat is only available if the secondary field is enabled refer to Secondary Field on page 21 Hide Field Select this option if you do not want the Description field displayed 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 directly 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 erase all records from the currently loaded database table and replace it with the converted database table 2 Ifyou are converting a Qbit WMS database the Enable Secondary Field found under Tools gt Options gt Database gt Secondary Field must be enabled for the conversion to work correctly Qbit DB 25 Configuration Database 3 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 X Convert Pa
24. get them to show up again Answer Goto the Database menu found on the main window and select Default Column Order Question When l export a txt file and open it in Excel each number has zeros preceding the actual number How can I eliminate these zeros Answer Complete the following steps 1 Export the file to a txt file For information on how to do this see Exporting a Database Table on page 80 2 Open Excel and then open the desired txt file using Excel make sure that All Files is selected under the drop down list located next to the File Name field 3 The Text Setup Wizard will open and allow you to format the various columns shown below Qbit DB 129 Frequently Asked Questions Text Import Wizard Step 1 of 3 The Text Wizard has determined that your data is Delimited If this is correct choose Next or choose the data type that best describes your data Original data type Choose the file type that best describes your data Delimited Characters such as commas or tabs separate each field Fixed width Fields are aligned in columns with spaces between each field Startimportatrow 1 File origin 437 OEM United States Preview of file C CubiScan Export CubiScan txt j Figure 71 Text Import Wizard csu files can be opened in Excel but will not open up the Text Import Wizard NOTE I because csv files are associated with Excel Question How can I move the camera image windo
25. of Measure Options 0 ccc ce cece nce ee teenees 18 CubiScan OPONE eisses risie daa ere psa boba 18 CubiscanModel snoot ad sarta aaa caia 19 Le AAA nn ASA 19 Databases apro oe a6 ot ura edad ads aaa en 20 Primal FCG destete en eae eed ene 20 Secondary Field 0 0 ccc ccc cece cee e teen eee eteeeees 21 Database OPIO edecanes 22 Are VMAlES taa aia aaa ee 24 Description Field oooooooooomoormoormcrrrnrrnm oso 24 Convert Qbit Win Qbit WMS Database ooooooomoooommo o 25 PASGWOLG esoo rara aa e ees 30 IMPUTA ai odes ao Srila ba as 32 a A 32 DMPO Lavoro aa e piedad sis wee ee ee 34 AUTO POE coosprscrpar roo sa aaa ea 37 Chapter 3 EDO io a a dde dado 30 104910 4 0 VV 0 RR n PP A cal eee ee bee 40 Expo La yOu cora tocada aw 41 AUTO EPO 52 MSs ias aras caiste 44 O O 50 Dimensional Weight Factors ooooooooooonooonoronooooos 51 User EC CS aia ii sde 52 Select User Eleld imei e Aus Boe ee aaa eee eR 52 User Meld Attributes cd cae a sade ada waa ar 53 POMC TAT CCS ity ite a ae ees hows ao beads Gee Ae cea eee eae a Be ee 54 Tolerance Y ales ot idee eat eae aces ted dad ded ded be eee aes 55 Validation OPUS des 56 Validation Penta AA RIO Fae a 56 OnentacOls isso io is dota 57 Dimension Orientation 0 0 ccc ee cc cee eee eee eee e eee 57 A A O ee ee 59 ODIOS onc ai RR So 59 o PESEE E A hg Weather eee E BGR E E Uti erases anaes 61 Camera ODUONS 552 sacchari dare
26. of the tab see Import Delimited File on page 34 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 33 Configuration Import Microsoft Excel NOTE IF Import File Contains Header Information Import Merge Options Append Only Update Only Append Update Import Delimited File Delimiter Type Files that are formatted for Microsoft Excel xls file extension The Excel sheet name must be named Sheet1 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 No if the file to be imported does not contain header information Select the method you want to use to import the data into an existing database If the secondary field is enabled this will affect the data that is imported For example duplicate item numbers will not be considered duplicates if the secondary fields are different Only new items are added to the existing database Duplicate items items with the same item numbers
27. scheduled export is displayed in the status bar of the main window see Main Window on page 6 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 The options in the Destination tab are not available until you select a frequency option in the Frequency tab 44 Configuration Export Frequency Click the Frequency tab to set up the mode and times to export CubiScan Database Password Import Epor Factors User Fields Tolerances Orientation Login Camera Reports Nesting Export Type Export Layout Auto Export Frequency Destination Export Frequency Options Export Mode e OF Export at specified Time Of Day f Export at specified Time Interval C Export after each Update Export Times Export Interval Timer Enter times in 12 hour clock format fey Eli Epot at Program Shutdown l Prompt for confirmation when exporting Figure 23 Auto Export Frequency Export Frequency Select how often a file will be exported Qbit DB Options 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 Export at Specified Time Interval Select this option to set
28. 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 is 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 81 Database Management Exporting a Database Table O Click the Export tab and then the Export Type tab Select the export file type and other applicable options see Export Type on page 40 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 41 Click OK to save and close the Options dialog box Select All Data or Updated Data from the Run Manual Export submenu Navigate to your preferred file location Enter a name for the export file in the File Name field including the extension which can be any ASCII text file extension e g xt 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 Click Save to export the database table to the file The status of the export and any errors are
29. up a time interval to export the database file The Export Interval Timer options become available to set up the time interval for export 45 Configuration Export Export Times Export Interval Timer All Data Updated Data Qbit DB Export at Program Shutdown 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 is available to set up the time of day you want the file exported 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 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 If you selected Export at Specified Time Interval this section is available to set up the interval timer Export 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 file will be exported automatically at the specified time intervals For ex
30. utility software To configure this software complete the following steps 1 Open up the EOS Utility software This software will need to be started each time you operate the digital camera with Qbit DB This software may open automatically when you plug the camera into your computer and turn it on Your digital camera must be connected to the computer and turned on before you can access the EOS Utility software 122 Installation Installing a Digital Camera 2 Click Preferences Control Camera Accessories Figure 64 EOS Utility 3 Under the Basic Settings tab select Show main window under Startup Action Deselect all other options except Start EOS Utility automatically when the camera is connected Basic Settings Destination Folder File Name Download Images Remote Shooting L Startup Action Show main window Show Lets you select and download images screen 5 Show Camera settings Remote shooting screen Execute Starts to download images Start EOS Utility automatically when the camera is connected A Auto power off except when using an AC power supply Add WET Pairing Software to the Startup folder A Automatically display Quick Preview window Figure 65 EOS Utility Basic Settings Screen Qbit DB 123 Installation Installing a Digital Camera 4 Click on the Destination Folder tab Under Destination Folder browse to CubiScan gt TempImages Deselect all option
31. values and the division result will be stored to the database 98 Measuring Objects Editing Data Editing Data Edit Fields Swap Measurements Qbit DB At any time after measuring an item you can edit any of its measurements using one of the following methods Click the item in the database table to select it You can edit any field that is not grayed has a white background Click in a field to edit it and type over the existing entry Then click to update the information in the database You can change the orientation of an item using one of the swap functions Pull down the Actions menu and select a function or use the specified keyboard shortcut as follows 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 Y When you have finished click to update the information in the database 99 Chapter 6 Reports The Reports menu contains one standard report This menu also contains the option to generate and design labels that can be viewed or printed by the user The standard report option is a Detail report explained below For inf
32. window can be placed in one of the docking positions on the Main Window or it can be left to float To move the window click in the top left corner No Image Figure 5 Camera Image Window Qbit DB 10 Getting Started Main Window Previous Measurement Window This window displays the measurement information of the previous item that was measured This feature can be used with in motion CubiScan systems such as the CubiScan 200 TS 210 SS or the 210 DS This window can be placed in one of the docking positions on the Main Window or it can be left to float To move the window click in the top left corner Figure 6 Previous Measurement Window Message Window The message window lists any CubiScan activity and gives the status of the activity This includes any configuration changes measurements taken and error messages Tools Option ning Table gt CubiScan iScan Model 125 Selected l n is 223102 2 ul lect Tools Options to set the Serial Port Number alue must be in the Pack Type pi Scan Model 125 Selected ul SONO On y osos snaa A A S rial port number is set to zero S ubiScan Model 125 Selected port number is set to zero Figure 7 Message Window Database Window Qbit DB The database window lists the items in the open database The columns and number of items visible may depend on how you have moved and resized the windows in th
33. window can be sorted by the entries in a column by clicking on the column heading For more information see Customizing the Database Window on page 12 Allow Duplicates Select this option if you want to allow duplicate item numbers to exist in the same database When you select this option item numbers can no longer be updated or edited Selecting this option also causes the Replicate Last Scan function to appear under the Actions menu Selecting this function will allow you to make duplicates of an item number in your database When you select Replicate Last Scan the following window appears Sequence Enter the number of times to replicate the listed information and y then click Replicate Replicate This window shows the item number and all of its associated information To replicate the item number enter the desired value into the field and click Replicate Qbit DB 23 Configuration Database NOTE t amp Auto Update Enable Record Delete Button A warning window will appear asking if you are sure that you want to replicate If you do want to replicate click Yes If you do not want to replicate click No Selecting this option also removes the Import tab found in the Tools gt Options window Select this option if you want Qbit DB to automatically store item information in the database You only need to enter the item number and click Measure You do not need to click the Update button
34. you click the function You can also select a function by typing the first letter in the function name File Menu Qbit DB Following are the functions available on the File menu Getting Started Menu Bar Import Export Exit Use this function to manually import data from an external source file Refer to Importing to a Database Table on page 78 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 Table on page 80 Use this function to exit Qbit DB Database Menu New Table Open Table Delete Table Empty Table Save Copy As Default Column Order Delete Current Following are the functions available on the Database menu Select this function to create a new database table Refer to Creating a New Database on page 74 Select this function to open an existing database table Refer to Opening a Database on page 75 Select this function to delete a database table Refer to Deleting a Database on page 76 Select this function to empty or clear the database table that is currently open Refer to Emptying a Database on page 77 Use this function to make a backup copy of the MSAccess mdb database Refer to Copying a Database on page 78 Select this function to arrange the database columns in their default order Select this function to delete th
35. 0 440 Vol 12 869 766 Factor 166 in lb i 3 16 2015 9 26 19 AM Wgt 124 850 Vol 503 616 Factor 166 in lb i 3 16 2015 9 26 30 AM Wot 27 620 Vol 7 047 940 Factor 166 Qbit Report 1 of 3 3 16 2015 10 17 59 AM Figure 45 Detail Report Preview Qbit DB 101 Reports Label Report 4G04 Q o QO Bg ug ma Length 30 5 in Width 21 8 in Height 10 6 in Weight 27 62 lb March 16 2015 09 26 am Figure 46 Label Report Preview In this report view the cursor becomes a hand when it hovers over the report You can use this hand to navigate throughout the report You can also scroll through pages using your mouse or the scroll bars located on the right side of the screen Use the buttons on the toolbar to view or print the report as follows 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 All Current page C Pages Enter page numbers and or page ranges separated by commas For example 1 3 5 12 Direct 1 9 v Duplex Default v Qbit DB 102 Reports Label Report Click to open a different report A Load Report dialog box is displayed Reports are saved in the gt CubiScan gt Reports folder with an fp3 extension by default If you saved your reports in a different folder select the folder Select the repo
36. 150 C QbitiSOWMS Inner Pack lc Each Pack ld Paradox record count 1 Productld Description DimUnit wgtUnitvolUniFactor PP UPC gt 234545555 Access record count 4 1 234545555 21234545555 3 234545555 4 234545555 Figure 15 Convert Paradox to Access Conversion Complete 9 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 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 Qbit DB 30 Configuration Password Options function is always included when password protection is enabled for any function CubiScan Database Password Import Export Factors User Fields Tolerances Orientation Login Camera Reports Nesting Password Options Selectthe menus you wish to have password protected Note Setting a password will protect the Options menu automatically Zem New Table Heo T Open Table impot Delete Table Export Empty Table Sort on Column Unlock View qj Clear Password Set Password Figure 16 Password Tab Password Options Select the functions for which a password will be required Set Password Click this button to set up or change the password The following dia
37. 30 model must be selected in the Tools menu gt Options gt CubiScan tab 1 Select Calibrate from the Tools menu then select Laser The following prompt is displayed Warning x Place the calibration block onto the CubiScan platform 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 1 Select Calibrate from the Tools menu then select Scale The following prompt is displayed Confirm iii O Continue with Scale Calibration Cancel Qbit DB 91 CubiScan Functions Calibrate 2 Click OK to proceed and the following dialog box appears Scale Calibration This routine will run through a series of steps designed to calibrate the scale This procedure should be performed periodically or any time the Weight is not within tolerance F you wish to continue with the calibration click CONTINUE otherwise you may exit without calibrating the CubiScan Figure 43 Scale Calibration 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 recommend
38. 4 28 02 PM 11 346546 6 60 0 0 3614 lin in 166 3 17 2015 11 10 43 AM P 12 23535 4 767448 0 4623 1807 in in 166 3 17 2015 1 29 51 PM Ponies 13 45757 2 8 0 0 0482 in in 166 3 17 2015 10 18 46 AM CML 14 3246346 5 120 0 0 7229 in in 166 3 17 2015 1 31 46 PM Cassie 15 345435 937710 0 5648 8554 in in 3 17 2015 3 58 23 PM Ponies y Table CubiScan Record 4 of15 Updated Records 15 6 This step is only necessary if tare is enabled and the object 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 Values on page 24 for information Qbit DB 94 Measuring Objects Measuring New Items Ti 8 Edit the data as required see Editing Data on page 99 When you are finished click to update the item record To clear an item s measurement data and start over or to measure a different item click Arecord 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 measure them 1 Qbit DB If necessary open the database in which you want to enter the items
39. Asked Questions Qbit DB Question Answer Question Answer Question Answer 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 Do updated records that are exported contain data records from previous sessions 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 I am not able to edit the Length Width Height and Weight fields What should 1 do Select View from the menu and disable the CubiScan Fields Read Only option This enables these fields to be edited I am unable to communicate with the CubiScan unit What should I do Make sure the serial communications cable is properly connected with a NULL MODEM cable Verify that the NULL MODEM cable is plugged into the correct controller box port If your CubiScan model is the CubiScan 100 make sure that the port closest to the CubiScan display is the port being used Then try measuring an item using the CubiScan display Place an item on the CubiScan platform and press MSR If you see a 01 or in the length width height or weight fields one of the sensors or scale may be causing a communication error If this occurs contact CubiScan Service and Support for assistance contact information listed below Ve
40. CUBISCAN OBIT DB USER GUIDE Version 1 1 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 Y GCUBISCAN CUBING amp WEIGHING systems BY QUANTRONIX CubiScan Qbit DB User Guide CubiScan and the Quantronix logo are registered trademarks of Quantronix Inc Scanning New Dimensions Qbit QbitWIN and The FreightWeigh System are trademarks of Quantronix Inc Windows is a registered trademark of Microsoft Corporation CubiScan software and firmware are protected by international and domestic copyrights CubiScan 150 measurement products are protected by one or more of U S Patents Re42 430 and D490 328 and foreign patents CubiScan 110 measurement products are protected by one or more of U S Patent Re42 430 and foreign patents CubiScan 125 measurement products are the subject of U S Patent 8 928 896 Another U S patent is pending CubiScan 225 measurement products are the subject of a pending U S patent application This document and website Copyright 2015 by Quantronix Inc All rights reserved This document was created with the purpose of providing the most accurate and complete information If you have comments or suggestions for improving this manual contact Quantronix at manual cubiscan com Manual updated June 11 2015 Tabl
41. Dimensional Weight Length Width Height Factor This equation is used to compute a dimensional weight a density calculation based on an item volume Freight carriers often compare the dimensional weight to actual weightwhen applying shipping charges Defaults Figure 26 Factor Tab Dimensional Weight 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 Qbit DB 51 Configuration User Fields User Fields User fields are fields in which you can enter in the database any additional information you want about an item User fields are labeled User Field 1 through User Field 8 by default however you can change the labels Option n CubiScan Database Password Import Export Factos User Fields Tolerances Orientation Login Camera Reports Nesting Select User Field User Field Attributes User Field 1 dia Field Name C User Field 2 Usei Field Length 1 60 i User Field 3 eo Enable Field C User Field 4 E Hide Field Use Default Text Default or Static Text i User Field 5 t User Field 6 c User Field 7 Data Entry Option f Any Character Alpha Numeric Characters Alphabetic Characters Nume
42. Individual dimensions will be calculated and stored in the database Refer to Chapter 5 Measuring Objects for information Stacked Qty s Height a Length p lt Width mm Stacked Qty is the number of like items placed in an axis The net dimensions and weight are calculated to provide an lt Each gt measurement Figure 2 Stacking Window Qbit DB 7 Getting Started Main Window Measurement Window The measurement window contains all of the fields and buttons you use to measure the length width height weight and other appropriate data ltem Number Pack Type Description Repeat Item Number F9 0 CubiScan Database Length in 00000 go000 Width in 90000 o00000 Height in 00000 j 0000 i Weight Ib 00000 00000 Clear F6 Volume in3 0 0000 0 0000 T Dim Wgt 166 0 0000 0 0000 Figure 3 Measurement Window Entry Fields The fields in which you can make an entry include the primary or Item Number field which can only be edited before the measurement is taken the secondary field if it is enabled the Description field if it is enabled any user fields that have been enabled and the object s measurement and weight entries Some fields are enabled or disabled using the Options on the Tools menu refer to Chapter 2 Configuration The item number may be selected by scanning a label or entered manually as you measure the object
43. Prev and Next allow you to scroll through all images that are associated with an item number If Auto Accept Image is not enabled each image will need to be accepted or discarded before you can scroll through the images Qbit DB 66 Configuration Camera Image File Options From this tab you can select the image file name convention settings CubiScan Database Password Export Factors User Fields Tolerances Onentation Login Camera Reports Nesting Camera Options Image File Options Image File Name Format Select 1 5 prefix values that will make up the file name convention for the stored images Prefix 1 File Name Prefie Separator None f Dash f Underscore Prefix 2 C Plus Static Text Static Text Image tem Number Da Date 4 Time Date amp Time kai Ivyyy mm dd Afile name cant contain any of the following characters Y e ar Prefix 4 User 2 r Date 4 Time Format Examples ye mm dd hh nn ss mm_dd_yway_hh_nn_ss Prefix 5 E NA hany 4 digit year mm 2 digit month dd digit day hh digit hour nn 2 digit minute ss 2 digit second in 24 hour format Figure 37 Image File Options Image File Select the image file name conventions from the following options Name Format Prefix 1 5 You can select 5 prefixes that make up the image file name Prefix 1 is a mandatory field and must have an option selected The options available for Prefix 1 are User 1 8 The op
44. Qbit DB to validate new item numbers and item numbers that are updated against the tolerance values Tolerance Values The table in the figure shown below is where you can enter the tolerance values for Length Width Height Weight and Volume To enable a tolerance value complete the following steps 1 Enable the Enable Tolerance Checking field 2 Enter the desired tolerance values into the appropriate field in the Tolerance Values table You can enter a Max Min or Allowed Difference value for the length width height weight or volume of an object 3 Enable the corresponding fields located below the Tolerance Values table These fields must be enabled for the tolerance values that were entered into the Tolerance Values table to be checked 55 Configuration Tolerances If one of these fields is enabled without a corresponding tolerance value being entered into the Tolerance Values table an error will display after attempting to Measure or Update an item Enable Leng Enable Width Enable Height Enable Weight Enable Volume Enable Length Enable Width Enable Height Enable Weight Enable Volume Enable Width Enable Height values Enable Weight Enable Volume using the tolerance Validation Options Allow Errors to be Overridden Turn Off Message Dialog Notifications Clear Measurement Data on Errors Bypass Update When Item is in Tolerance The Validation Options field is where
45. Table Run Manual Excel 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 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 Activate FTP Upload option and entering the required login and mode information Then select Run Auto Export to upload the data immediately Run Manual Export All Data Updated Data Qbit DB Select this function if you want to manually export all or part of the database to a text file Because the layout does affect Excel exports 1t cannot contain any duplicate field names Select one of the following options Select the All Data option to create an export text file containing all records in
46. The options available are True Rounding Round Up and Round Down Type in the number of digits that you want to appear after the decimal on weight measurement dimensions From this tab you can view and change nesting settings Enabling nesting will allow you to calculate and save the nesting factor of an item The nesting feature should be used when you are measuring multiples of an item that can be stacked inside one another like cups or Russian nesting dolls 69 Configuration Nesting Options Enable Nesting Functionality Select User Field Qbit DB CubiScan Database Password Import Export Factors User Fields Tolerances Orientation Login Camera Reports Nesting Options Enabling the Nesting feature will allow a userto calcuate a nesting factor to be stored in a selected user field Nesting Flow 1 Measure single item 2 Place nested item on CubiScan 3 Click Nesting button 4 Enter nested quantity 5 Nesting factor will be calculated and placed in selected user field 6 Click Update button or press F4 to save data e Enable Nesting Functionality Select User Field f User Field 1 User Field 2 f User Field 3 C User Field 4 f User Field 5 User Field 6 C User Field 7 Figure 39 Nesting Tab This window includes the instructions to calculate a nesting factor Enable this field to allow for a nesting factor to be calculated and saved When you e
47. 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 objects 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 74 If you already have a Qbit DB database or databases the last database 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 75 e Create a new database table using the New Table function see Creating a New Database on page 74 Creating a New Database Do the following to create a new database Qbit DB 74 Database Management Opening a Database 1 Pull down the Database menu and select New Table and the following prompt is displayed Please enter a table name EA 2 Type the name that you want to give the new database table If you enter the name of an existing database table an error message appears NOTE gt warning you that the database already exists 3 Click OK and the new empty database table is opened so you can begin entering data into it Opening a Database Do the follo
48. ad the database file to a host via FTP when it is exported automatically You can obtain this information from your network administrator Y Activate FTP Upload FTP Upload Mode le Overwrite Existing File Append Data To File Create Unique Files User ID Password Remote Host Transfer Mode le Ascii Remote Port Binary Network Mode la Passive Active Trace Mode fe Off On Remote Path Remote File Name Figure 25 Auto Export Destination 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 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 48 Configuration Export Transfer Mode Network Mode Trace Mode FTP Transfer Process ASCII Text File Information Qbit DB Create Unique Files Sel
49. ages that are displayed in the message window and stored in the daily log file The ODBC ini file enables Qbit DB to be configured to store data to a third party database such as SQL Server A Database Administrator will need to configure the ODBC ini file Files are pushed to the third party database when the user updates data in Qbit DB Records that are not successfully transfered to the third party database will be stored in a file called ODBC Seq Num Errors txt and will attempt to retransmit the data when the connection to the third party database has been established To enable the Obit DB database to communicate with another database a 32 bit data source must be created If you are using a 32 bit machine complete the following steps to create a data source 1 Goto Control Panel gt System and Security gt Administrative Tools 2 Click on Data Sources ODBC 3 The ODBC Data Source Administrator window will appear Select the desired file and click Add 4 Have your Database Administrator complete the process 5 Map the Qbit DB database fields within the ODBC ini file to the appropriate fields in the ODBC database If you are using a 64 bit machine complete the following steps to create a data source 1 Open Command Prompt 2 Type in the following command c Windows SysWOW64 odbcad32 exe 72 Configuration Special Features Qbit DB Scale ini The ODBC Data Source Administrator window will appea
50. ailable at the bottom of the tab see Import Delimited File on page 34 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 40 Configuration Export Export Header Information Export Delimited File Delimiter Type Add Double Quotation Marks Around Character Strings NOTE gt Select Yes if you want to include header information in the file when it is exported Select No if you do not want to include it Select export options for delimited file types This option is only available if you selected Delimited as the 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 Select this option if you want quotation marks placed around character strings in the exported file The double quotation marks will keep the characters within the quotation marks together in the export file To export a file that you want to load into Microsoft Excel choose Delimited under Options gt Export Type gt Export File Type Export Layout Qbit DB You can change the layout of the database table for the export file You can sel
51. ailable on the Actions menu Select this function to switch the length and width measurement values for the current item Select this function to switch the width and height measurement values for the current item Select this function to switch the height and length measurement values for the current item Select this function to apply tare values This option is only available after the Enable Tare Option has been enabled under Tools gt Options gt Database Getting Started Menu Bar Enable Automatic Tare Replicate Last Scan Change User Selecting this function automatically applies tare values to CubiScan measurements This option is only available after the Enable Tare Option has been enabled under Tools gt Options gt Database This function appears after the Allow Duplicates field has been enabled under Tools gt Options gt Database Selecting this function will allow you to make duplicates of an item number in your database For more information on this function see Allow Duplicates on page 23 This function appears when Prompt for User ID at Application Startup using Drop Down List or Prompt for User ID and Password at Application Startup is enabled under the Tools gt Options gt Login tab If you select this option a window will appear that enables you to switch users Reports Menu Detail Label Designer NOTE gt Following are the functions available on the Repor
52. among the drop down values The Enable Field option must also be enabled 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 Characters Numeric Characters Y N Character yes no or 53 Configuration Tolerances Alphabetic Character Option Tolerances Qbit DB Drop Down List If you do not want to define any restrictions select Any Character If you select Drop Down List you will be required to enter the desired values into the box that appears to the right of the Data Entry Options This option can be used to restrict the type of alphabetic characters that are entered in the field to help prevent data input errors Click the option for the type of alphabetic characters to be allowed Mixed Case Upper Case or Lower Case Ensure that your alphabetic character option does not interfere with your Data Entry Option For example if you select alpha numeric characters for your data entry option and upper case as your alphabetic character option you will be unable to enter any lower case options into the selected user field This section may be grayed out depending on the data entry option that was selected Click this tab to enable tolerance checking This is the tab where you can set your exclusion criteria You can set a Max or Min value f
53. ample if you select 2 hours the file will be exported every 2 hours If you selected a time of day or time interval for the export select whether you want to export All Data in the database or only the Updated Data If you enable this function the database file will be exported automatically each time Obit DB is shutdown 46 Configuration Export Prompt for confirmation when exporting Destination Activate FTP Upload Qbit DB If you enable this function Qbit DB will prompt you for confirmation when a database file is about to be exported Click the Destination tab to set up the type of output for the export file CubiScan Database Password Import Export Factors User Fields Tolerances Orientation Login Camera Reports Nesting Frequency Destination Export Destination Options Acti FTP E Upload Mode MA de HFH H O ALA 1 le DS A Transfer Mode m qe 21 Siete Network Mode Pos r Trace Mode E afi M ASCII Text File Infomation Output Mode E Overwrite E f Append e Figure 24 Auto Export Destination Export Destination Options 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 Select Activate FTP Upload to activate the FTP upload option 4 Configuration Export FTP Upload Mode Qbit DB Set up the options to uplo
54. an manual for further help Test Mode Use the Test Mode function to set up the CubiScan for testing purposes When you select this function the CubiScan measures weighs and displays the results continuously as shown below Figure 40 Test Mode Qbit DB 88 CubiScan Functions Values Values Calibrate Qbit DB The collected data continues to scroll on the screen until you exit test mode The data collected is not recorded or saved To exit from test mode click Cancel Use the Values function to display a table of sensor values that can be useful for troubleshooting problems with the CubiScan Cubiscan Values CUBISCAN MODEL SCALE CAPACITY FIRMWARE VERSION LENGTH 1 4 00 LENGTH 2 0296 4 00 02 0296 4 00 02 D2 0296 4 00 Figure 41 CubiScan Values Click OK to return to the main window 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 material from the platform and blow any dust off the sensor screens Refer to your CubiScan manual for information on cleaning the sensors To perform the calibration you will need the following 89 CubiScan Functions Calibrate e Official test weight The weight varies for each model of CubiScan refer to your CubiScan manual It is recommended that you calib
55. are not added or updated Duplicate items are updated but new items are not added to the database New items are added to the existing database and any duplicate items are updated Select import options for delimited file types This option is only available if you selected Delimited as the 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 Qbit DB 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 32 Do the following to map the fields in the text file to the Qbit DB database fields 34 Configuration Import 1 Select the Import Layout tab CubiScan Database Password Import Export Factors User Fields Tolerances Orientation Login Camera Reports Nesting Import Type Import Layout Auto Import 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 This Field To This Field SE ee Figure 18 Import Layout 2 Select the file you want to import The file should contain every field in the import file so that all fields can be mapped to a corresponding field in Qbit
56. ated records in the current database Enter a unique number used to identify this item Move the mouse over a menu or function and a description of the menu or function is displayed 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 Disabled is shown If you scheduled an automatic export see Auto Export on page 44 the number of hours minutes seconds to the next export is displayed If you have not set up auto export Next Export Disabled is shown 15 Chapter 2 Configuration Qbit DB This chapter provides information and instructions to configure and set up defaults for Qbit DB using the Tools gt Options function The following tabs contain the configuration options CubiScan on page 17 Setup the measurement and dimensional weight units select the CubiScan communications port select your CubiScan model and enter a site ID optional Database on page 20 Setup primary secondary description and database fields as well as other database options This tab also contains the option to convert an older Qbit DB database to the new format Password on page 30 Setup password security for selected functions Import on page 32 Select import options set up the layout of the imported database fields and set up the automatic import function
57. ations 5 Click Step 1 or press lt F1 gt 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 is completely clear of all objects and select Zero from the Tools menu to zero the CubiScan Qbit DB 92 Chapter 5 Measuring Objects NOTE gt Qbit DB 1 445734 2 56875468 3 W5987 EJ 99008 5 411224 6 2345452487 7 Book1 8 77YJ2 This chapter describes how to measure objects 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 objects in Qbit DB depending on how you enter items in your database as follows Ls Measure items that are already listed in an imported database refer to Importing to a Database Table on page 78 for information on import ing 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 on page 20 for information If Auto A
58. bitWMS Database Enable Field Hide Field Include This Field When Repeating Figure 10 Database Tab Primary Field The primary field 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 following 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 window Qbit DB 20 Configuration Database Enable XRef Enabling this function allows the primary field to be populated with a Lookup cross referenced value from the xref mdb database For more information on this function see Measuring Items with XRef Lookup Enabled on page 96 Field Length Enter the maximum number of characters that can be entered in the key Key Field Option field from 1 to 50 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
59. boxes Basic Settings Destination Folder File Name Download Images Remote Shooting L Destination Folder CiCubiScantTemplmages A subfolder into which the image will be saved will automatically be created in this folder Create subfolder next time this function is used E Download Images Remote Shooting E Monitor Folder Shooting Date Customize Example 3 CACubiScan Templmages Figure 66 EOS Utility Destination Folder 5 When you are finished click OK to exit the Preferences window 6 From the EOS Utility Software home screen click Camera settings Remote shooting This will bring up a window that allows you to capture images remotely using the computer Minimize this window for the next few steps Qbit DB 124 Installation Installing a Digital Camera 7 Open Qbit DB and navigate to the Camera tab located under Tools gt Options Options Database Password Import Export Factors User Fields Fields 1 4 Fields 5 8 Tolerances Orientation Login Camera Rep Axis Camera Options Enable Network Camera Snapshots Camera Setup IP Address Auto Snapshot After Measure Enable Multiple Snapshots IP Port Number 0 00 Seconds to Show Snapshot Test Connection Stop Connection Digital Camera Options Y Enable Digital Camera Snapshots Camera Setup Auto Accept Image Enable Multiple Snapshots Figure 67 Camera Tab 8 Under Digital Camera Options enable the fi
60. ck the Export tab to set up the export options the layout of the exported database fields and the automatic export function Because the layout does affect Excel exports it cannot contain any duplicate field names For more information on Excel exports see Run Manual Excel Export on page 83 39 Configuration Export Export Type Export File Type Delimited Fixed Length Qbit DB Select the Export Type tab to set up the options that define the type of files that can be exported CubiScan Database Password Import Export Factors User Fields Tolerances Orientation Login Camera Reports Nesting Export File Type f Delimited Fixed Length Export Header Information e Yes C No Export Delimited File Delimiter Type Comma t Tab t Other Export File Delimiter Add Double Quotation Marks Around Character Strings y OK X Cancel Figure 21 Export Type Select the file type to be used when exporting database files The default is delimited Variable length delimited files csu 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 fields depends on your Windows regional settings If you select this option additional options to define the delimiter type become av
61. d iia 62 Image File OPUS ida tied dea 67 ICBO A O pore ews hawt ee Sadie exe cas 68 REDOrU O DUlONS ad ane Os 68 NCSU int Ahh os disap Rake BGs eee haa ee twee ee eeae 69 O O eer oe ee Ce eno ae 70 Calculating and Saving a Nesting Factor ooooooooooooooo 71 Special Features us ett de the eee She Mek ad toe twa ee ek 7A Barcode 1 4234 0 26 di cave eae eh hain an eee aa ack 71 Database Maintenance ini ee ee eee eee eee 72 NSO UNNI es oo Si O rae ete see eet 72 ODBC II aaa ocre iia ne ae 72 A II 73 Database Management 00 c cece eens 74 Creating a New Database ooooooooooooomoo morro rroooo 74 Openin a Database 4026S oo ea b he eS a ia 75 Deleting a Database 0 ccc cee eect eect eee ooo 76 Emptying a Database is woth Mia dina ale dS areihod oO a 7 Copying a Databases 78 Importing to a Database Table 2 ee ee eet eee eens 78 Exporting Database Vable s cies des Peo eheard eye ei wee eee ee 80 RUMANO EXDOTO saraaa A 81 Run Manta EXPO ii AAA SAA E 81 Run Manual Excel EXPO ad a E 83 Chapter 4 Chapter 5 Chapter 6 Appendix A Appendix B CubiScan Functions 0 c cece ccc eee eee ees 86 TNO cs AAA AAA is decd A AAA 86 SIG eS vee tag res a een eae a a aca 87 A O 8 88 NS ite recite wath EEEE E eid Toa Ww rea Ase edt bah enamored 89 Cabres ao ad Sethe ee eee ba eee wate a eee 89 SG FSO Sr A eek area ee ee ee a ee eR ee ee 90 o A A Oe eC 91 A dates baa e
62. 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 Ls 25 Qbit DB Select Date Range from the Run Manual Export submenu and the following dialog box is displayed Export Date Range Paramete Please Select Desired Date Range From Date To Date 2 23 2015 El 2 24 2015 E x Cancel By default the From date is yesterday s date and the To date is today s date To change a date click E and a calendar is displayed from which to choose the date as follows 82 Database Management Exporting a Database Table February 2075 Mon Tue Wed KT i S14 rea 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 Run Manual Excel Export All Data Updated Data Qbit DB Select this function if you want to manually export all or part of the database to a file that can be loaded directly into Microsoft Excel You must set up the import file options before importing a file refer to Import Type on page 32 You can also change the layout of the Qbit DB database table to be exported Beca
63. dvance is set up you select the first item and Qbit DB automatically moves down the database list in sequential order as you measure and update each item However you can also manually click an item to select it Select Items Manually Click the item in the database table to select the item as shown below gt Dim Unit Wat Unit Vol Unit Factor 77 5287 lin in 3 16 2015 9 26 11 AM 3 0338 in in 3 16 2015 9 26 19 AM 42 4575 lin in 3 16 2015 9 26 30 AM 16 592 in in 3 16 2015 9 26 40 AM 66 5193 lin in 3 16 2015 9 26 48 AM 28 3852 lin in 3 16 2015 9 26 57 AM 12 767 in in 3 16 2015 9 27 06 AM 105 866 in in 3 16 2015 9 27 20 AM Enter items 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 Type the item number in the Item Number field and press lt Enter gt An lt Enter gt key can be programmed into a barcode scanner see your system or hardware administrator for assistance 93 Measuring Objects Measuring Existing Items Measuring Existing Items Do the following to measure items listed in an existing database 1 Ifnecessary open the database that contains the items you are going to measure 2 Verify that all of the CubiScan options have been set up correctly see CubiScan on page 17
64. e current highlighted record You can also Record tap the delete button on the keyboard to delete individual item numbers from the database table View Menu CubiScan Picture Stacking Message Window Camera Image Qbit DB Click this function to show or hide the CubiScan picture window A checkmark indicates it is shown Click this function to show or hide the stacking window A checkmark indicates it is shown Click this function to show or hide the message window A checkmark indicates it is shown Click this function to show or hide the camera image window A checkmark indicates it is shown Getting Started Menu Bar Scan Ahead Previous Measurement CubiScan Fields Read Only Database Fields Load Default View Save as Default View NOTE I Lock View This function allows Qbit DB to scan ahead one label at a time to increase the performance of in motion systems This function is only available when the CubiScan 200B 200TS 210 or 225 is selected Click this function to show or hide the previous measurement window 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 information in any of the CubiScan fields Click this function to show or hide the database fields A checkmark indicates they are shown If you have changed the arrangement of windows of the main window see Cu
65. e drop down list This option overrides the secondary drop down list and imports a drop down list from a specified import file For more information on importing a file see Import on page 32 This will also provide a result set to choose from within the secondary 21 Configuration Database Secondary Field Drop Down List drop down list values when you enter an item number into the primary field Click in the text box and enter a list of items Press lt Enter gt after each item The items entered become available for selection from a drop down list in the secondary field on the main window Database Options Data Mode Add Update Items Verify Item Exists Before Update Qbit DB The database options determine how items are entered in the database and whether or not you can delete item records The following options determine how information is entered into the database Select this option if you want to 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 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 seconda
66. e main window You can also resize and rearrange the columns in the database view see Customizing the Database Window on page 12 11 Getting Started Main Window Moving Through the Database Window 4 Selecting an Item Customizing the Database Window Qbit DB Volume DimWat DimUUnt wgt Unt 136 0 0 8193 in i Figure 8 Database Window Use the horizontal scroll bar to move left and right through the columns and the vertical scroll bar to move up or down through the items in the database Use the arrow buttons to move up and down through the items as follows Click to move to the first item in the database Click to move up one item at a time Click to move down one item at a time Click to move to the last item in the database Click an item to select it for measurement or remeasurement or to display the object s measurements and weight in the measurement window 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 click Update or press lt F4 gt You can change the position and size of the columns in the database view and you can sort the items by any column as follows e To change the position of a column in the table click on the heading and drag it to a new position e To change the width of a column move the mouse pointer over th
67. e of Contents Chapter 1 Chapter 2 Getting Started oooooocococcccococconrnr o 1 Starting Exiting Qbit DB ooooocooooooomormnomno ooo 1 Men Da aida peroo nseries cabins one bes bebe oe oes 1 File MENU se aewe ace scree antac dee peep ead eae wa ae eae ea eae wend 1 Database Mentes sostenerse ran sao os tee aireado se 2 View Menu sens ir iio ii a A RAR 2 A A E II ee ere ae oe ee ees 3 Caliper Menu ccc ccc cee cece cen teen eee a eee eteeaes 4 ACTIONS WEN os 62th oka 5 baba ene seh een carnada ei dea 4 REDOF Es MEN cor ca E E E E 5 Help MONU curro trar ais 5 Lan enases MONU se cooxrsrcsar hea toe tan en ewe eee eee ee pos Ed 5 IMAI WINGOW er siuedun ou cotas ek wend eee iaa 6 Stacking Window otr nas rro een ee ent 7 Measurement Window 0 ce cece eee cee eee teen eee n nena 8 CubiScan Picture Window 0 ccc ccc eee eee ee eee eee eens 9 Camera Image Window 2 ccc cece eee tent ee ene eens 10 Previous Measurement Window 0c cee cece eee eee et ee eee 11 Message Window 1 cc eee ee ee cee eee eee e eee e eee resero 11 Database WindOW lt ic4s06s4 lt 44000han0d8SR PAR GSS dede desd 11 Customizing the Main Window cece eee eee eee e eens 13 Pld Us EA DUD shone tiweenbete sen e reenter EEE E sues 14 Configuration 0 ccc ccc cnc ence eens 16 CUDISCAL amp dara e g GA ore 6b baa hE HE Sa 6 oe eo eed Eee eee 17 Unit
68. e side of the column heading until the pointer changes to directional 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 e 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 e To return the Database View to its default set up pull down the Database menu and click Default Column Order 12 Getting Started Main Window Refer to Chapter 3 Database Management for information on managing databases Customizing the Main Window Resizing NOTE t Moving NOTE I Qbit DB You can move resize or hide some windows of the main window to customize the display The measurement window cannot be moved and acts as a point of reference for all of the other Qbit DB windows e The stacking window CubiScan picture window message window camera image window previous measurement window and database window can be resized e The stacking window CubiScan picture window message window camera image window and previous measurement window can be separated from the main window and moved to a different docking position or left to float on the screen e The stacking window CubiScan picture window message window camera image window previous measurement window and Database fields can be hidden or shown To resize a window move the mouse pointer over an
69. easuring Items with XRef Lookup Enabled Do the following to measure items using the xref lookup functionality This function should be used with a barcode scanner If using a barcode Qbit DB 96 Measuring Objects Measuring Items with XRef Lookup Enabled scanner it may be helpful to program your scanner with an automatic carriage return feed N When using a barcode scanner you must have Windows focus on Qbit DB for the OTE 12 barcode information to be fed into the program 1 Open Windows Explorer and locate the XREF mdb file located under gt CubiScan gt Database 2 Open this file and format it as needed An example is shown below You will need to have Microsoft Access or another program that can open mdb files installed on your computer in order to do this All Access Objects Y xREF Search p Primary Barcode ClicktoAdd Tables Rr 9 0560940929 XREF 9 0560940935 9 0560946662 E o 10000067392 0000067393 0000067394 0000067395 0000067396 0000067617 0000138408 0000139931 0000139932 0000237320 7322371495753 0000237321 7322371495760 0000237328 0000237329 0000237331 0000237332 0000237415 0000237468 0000237491 0000237492 0000237493 0000237494 0000237495 0000237496 0000237497 0000256481 0000500415 0000500416 0000500519 0000515062 7330725008757 Figure 44 XREF mdb Example 3 Open Qbit DB and enable the Enable XRef Lookup field located under Tools gt Options g
70. ecified number of characters in the field Default values will be shortened to fit the specified field length Select this option to enable the user field Once enabled the field becomes available after the item number is entered and remains available until the record is updated You cannot make this field mandatory or include it when repeating unless it is enabled You cannot hide this field if it is enabled Select this option if 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 is only available if the secondary field is enabled refer to Secondary Field on page 21 Select this option to hide a disabled user field in the main window Select this option if you want a default or static value to appear in the selected user field Type a default value for the field This value will appear by default in the selected user field If both the Enable Field and Use Default Value fields are enabled the default will appear in the user field but can be overridden by manual entry You can also disable the Enable Field option while using a default value Doing this will enable you to use the default value and not allow it to be edited during the cubing and weighing process If you are using a default value with a drop down list your default value must also be listed
71. ect 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 051215170159 unique txt 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 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 Activate ASCII Text File Output Select this option to output the exported data to an ASCII text file V Activate ASCII Text File Output ASCII Text File Information File Location and Name PE Browse Output Mode Overwrite Existing File C Append Data To File Create Unique Files Enter a directory path and complete file name for the exported file in the File Location and Name text box or click Browse Browse to the folder in which you want to save the file If you want to write over or appe
72. ect 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 41 Configuration Export Select the Export Layout tab Optio q CubiScan Database Password Import Epot Factors User Fields Tolerances Orientation Login Camera Reports Nesting Export Layout Auto Export 1 Select the table field that you want exported from the pulldown list 2 Enter the places after the decimal paint Note Load defaults will export all of the table fields Export This Field a E Load Defaults Clear All Site ld Move Down Date Time 0 0 4 4 4 4 4 4 0 0 0 0 0 0 Figure 22 Export Layout s Click Load Defaults if you want to export the database as it appears in ETR Qbit DB or to display all of the fields in the database table so that you can edit the layout a 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 Remove Click a table field and then click Insert to insert a field above the selected Insert field Click a table field and then click Move Up to move the selected field up one Move Up position in the table Click a table fie
73. ect which user field you would like to correspond with a user ID This user ID will be stored in the selected user field each time the Update button is clicked The options available are User Fields 1 7 or None When you select the user field that you wish to use you will automatically be directed to the corresponding user field under the User Fields tab For further information on the user field options see User Fields on page 52 When selecting which user field you want associated with an ID be sure that the user field you select is not already in use From this tab you can enable a network or digital camera to work with Qbit DB or select your image file options Camera kits are available from Quantronix to purchase The camera tab is a special feature that requires a camera This tab does not normally appear on the Options menu If you are interested in purchasing this feature contact Quantronix at 801 451 7000 For information on installing a network camera see Installing a Network Axis Camera on page 114 For information on installing a digital camera see Installing a Digital Camera on page 116 61 Configuration Camera Camera Options From this screen you can configure and select the settings for a network Axis or digital camera CubiScan Database Password Import Export Factors User Fields Tolerances Orientation Login Caner Reports Nesting Camera Options Image File O
74. ed tea ed ws 91 Measuring Objects 00 ccc cece cee ene eee 93 Measuring Existing Items 24 2 2 054 e404 dae sds bed a 94 Measuring New tens ud ad dio Sa 95 Measuring Items with XRef Lookup Enabled o o o oo 96 Measuring Stacked Quantities 0 cece eee ec eee eee ooo 98 FGM Dalarnas 99 A cueeo ated ese eee ees 100 Detall RED OTUs arias ee sed ne de ace a tadas 100 Label Report A oO mae Ke ae a ess 100 Report PEI WEE A eee he eee tt 101 Destener ROD OIE tus sisi eine coe on Aa 104 Installation cuca den raro teta 106 System Requirements oooooooooooo oro oo 106 stalin ODEDE e sta a ee ree 106 Installing a New Version or Update of Qbit DB 112 Installing a Network Axis Camera ooooooocoocooormor roo 114 Parts List for the Axis Network Camera Kit ooooooooooo o 115 Installing a Digital Camera ooooooooocorooonororoo ooo 116 Installing the Digital Camera Software ooooooooommoooo ooo 117 Loading the Digital Camera Driver oooooooooomooomoooo 121 Connecting Your Camera to Qbit DB o ooooooooooomoo o 122 Parts List for the Digital Camera Kit o oooooooooomooo o 127 Frequently Asked Questions o o ooooooo o 128 List of Figures Figure 1 Figure 2 Figure 3 Figure 4 Figure 5 Figure 6 Figure 7 Figure 8 Figure 9 Figure 10 Figure 11 Figure 12 Figu
75. ed with the Item Number as shown above The Secondary database field is usually always associated with the Pack Type as shown above If the secondary field is enabled then it must be mapped to a field in the import file To move backwards and forwards from item to item in the sample file click Record 1 the arrows beneath the list of fields To clear all of the fields and start over click Clear All Qbit DB 36 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 CubiScan Database Password Import Export Factors User Fields Tolerances Orientation Login Camera Reports Nesting Import Type Import Layout Auto Import Import File Location and Name Import Frequency Options Import Mode e OF C Import at Specified Time of Day C Import at Specified Time Interval Import Times Import Interval Timer Enter times in 12 hour clock impot at Program Startup Prompt for Confirmation When Importing Delete File After Auto Import Figure 20 Auto Import You must set up the Import Type options and map the layout before you set up NOTE I auto import see Import Type on page 32 and Import Layout on page 34 After you set up an auto import the number of hours minutes seconds to the next scheduled import is displayed in the status bar of the main window see Ma
76. el files such as Label2x2 3x3 4x4 or 4x6 located in the CubiScan folder The label must have the file extension of fr3 rastheport le Edit Report View Help ITESO 5 add existing ri r swi T ll Ili create new datasets 7 A Length Length s e Taf Width Width s IM Height Height s Weight Weight s UpdateDateTime dmmmm d yyyy Figure 47 FastReport Window If you have problems or questions regarding the FastReport label designer window refer to the FastReport Help menu Qbit DB 105 Appendix A Installation This appendix provides instructions for installing Qbit DB as well as instructions for installing a network or digital camera to work with Qbit DB System Requirements Qbit DB is designed to operate with the following minimum computer requirements Processor PC Pentium III processor or better Memory 1GBRAM Hard Disk 40 MB disk space available Display VGA 1024 x 768 or higher resolution color display will not operate at a lower resolution e g 800 x 600 Operating System Microsoft Windows 200008 Windows XP Windows 7 or Windows 8 1 Other Quantronix Inc CubiScan unit attached to computer Installing Qbit DB Do the following to install Qbit DB on your computer 1 Close any open Windows applications Qbit DB 106 2 Insert the CubiScan CD ROM in your CD ROM drive The following prompt is displayed 6 3 DVD RW Drive
77. eld Enable Digital Camera Snapshots Click OK when you are finished to close the Options window 9 Enter the item number for the item that you want associated with the picture into the Item Number field primary field 10 Maximize the remote image capturing window shown below Qbit DB 125 Installation Installing a Digital Camera 11 Click the black round button located in the top right corner of the window This should cause the digital camera to take a picture Make sure that the camera lens cover has been removed Live View shoot Other Functions Figure 68 Remote Image Capturing Window If the camera was connected to Qbit DB successfully the picture should be displayed in the camera image window on the main Qbit DB screen shown below This remote picture taking method only needs to be used the first time to help the camera connect to the Qbit DB software accurately After Qbit DB 126 Installation Installing a Digital Camera using the remote method once you should be able to take pictures using any method you prefer Y Accept F2 X Discard F5 Figure 69 Camera Image Window For further information on the settings available with the digital camera see Camera on page 61 Parts List for the Digital Camera Kit Following is the parts list for the digital camera kit Quantity Unit Integration Software Included with Qbit DB Qbit DB 127 Appendix B Frequently
78. ent and dimensional weight units select the CubiScan communications port select your CubiScan model and enter a site ID optional 17 Configuration CubiScan CubiScan Database Password Import Export Factors User Fields Tolerances Orientation Login Camera Reports Unit of Measure Options CubiScan Options Dimension Units Inches C Centimeters Weight Units f Ounces f Pounds f Grams f Kilograms Volume Units f Cubic Inches C Cubic Feet C Cubic Milimeters C Cubic Centimeters C Cubic Meters Dimensional Weight Units Communication Ports le R5232 Serial Port PC Port Network Port USB Port CubiScan Model f CubiScan 100 E f CubiScan 110 if T Model t CubiScan 125 CubiScan 150 nl CubiScan 25 f CubiScan 30 Se al s starting with 9 or 20 24 f CubiScan 30 Se al Hs starting with 25 t CubiScan 50 PS CubiScan 2008 CubiScan 200TS 210 225 Site ID Domestic eS C Intemational Figure 9 CubiScan Tab Unit of Measure Options Dimension Units Select the measurement units you want used to measure length width and height dimensions Inches Millimeters or Centimeters 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 Dimen
79. er to add or update Password Admin Rights iCML passw ord Existing Users User Password Admin gt Add Update User Exit Inactivity Timer f None f 15 Min 30 Min f 45 Min 60 Min f 90 Min Figure 32 User Password Management Window Enter the User ID and password into the appropriate fields You can select if the user will have administration rights which allows the user to manage the user accounts There must be at least one administration account The Existing Users box shows all the current records of user IDs 60 Configuration Camera NOTE gt Select User Field NOTE t Camera Qbit DB passwords and administration rights status Passwords that are shown in this box are encrypted You can arrow through or delete these records using the arrows found at the bottom of the Existing Users box Make sure that all records have an associated user ID and password delete all incomplete records The Inactivity Timer box is where you can select how often a user will be prompted to enter their ID and password The options are None 15 Min 30 Min 45 Min 60 Min and 90 Min Depending on which option was selected the user will need to enter their information again if Qbit DB is left inactive for the selected amount of time Use the Add Update User button to add a user ID and password or to update an existing record When you are finished click Exit In this box you can sel
80. f it has been connected incorrectly 6 To connect the camera with Qbit DB see Camera on page 61 Parts List for the Axis Network Camera Kit Following is the parts list for the Network Camera Kit ao PE aga USB to Ethemetadaper o o NET 13413 Ethernet Ethernet Cable 10 ft 10 ft MA P Integration Camera e Included with 9414 Qbit DB O a Qbit DB 115 Installation Installing a Digital Camera Installing a Digital Camera Ensure that you have received all of the correct parts and quantities for the digital camera kit by referring to the figure below or the parts list on page 127 Figure 56 Digital Camera Kit Components A Tripod B USB Extension Cable C Digital Camera Your camera may appear different depending on the brand of digital camera that you received To install your digital camera you will need to complete the following steps 1 Install the digital camera software onto your computer For instructions on how to do this see Installing the Digital Camera Software on page 117 2 Load the digital camera driver onto your computer For instructions on how to do this see Loading the Digital Camera Driver on page 121 Qbit DB 116 Installation Installing a Digital Camera 3 Connect your camera to Qbit DB For instructions on how to do this see Connecting Your Camera to Qbit DB on page 122 Installing the Digital Camera Software N gt The fo
81. he box will display the live camera feed If the connection is unsuccessful an error message will be displayed Click this button to stop the camera connection 64 Configuration Camera Digital Camera Options Enable Digital Camera Snapshots Auto Accept Image Qbit DB This field contains all the settings for a digital camera Enable this field to allow a digital camera to connect to Qbit DB Camera Setup Select your digital camera setup options Enable this field if you want the image you took to be automatically accepted The default setting is that each image must be accepted or discarded before it will be saved to the item number that has been entered into the Item Number field as shown below If multiple images are taken each image will appear as the previous image is accepted or discarded by clicking the Accept or Discard buttons found at the bottom of the camera image window A Accept F2 Discard F5 Figure 35 Auto Accept Image Disabled If you enable Auto Accept Image then you will not need to accept or discard 65 Configuration Camera each image as it is taken The Accept and Discard buttons are no longer avallable Figure 36 Auto Accept Image Enabled Enable Multiple Enable this field if you want the system to allow multiple snapshots per Snapshots item number When this function is enabled two new buttons appear at the bottom of the camera image window These buttons
82. hese functions are selected from the Tools menu and include the following e Zero Use this function to zero the CubiScan weight and dims values e Status Use this function to verify that the CubiScan is operating properly 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 The Zero Status Test Mode Values and 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 function Use the Zero function to zero the CubiScan Zeroing sets all dims 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 operate properly A CubiScan zeros itself automatically every five seconds 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 86 CubiScan Functions Status e If you suspect that the last zeroing was in error e g something was on
83. ich you want to delete all records is the open table 2 Select Empty Table from the Database menu and the following prompt is displayed Warning all records will be lost f Empty table Books e e 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 The following message is displayed 4 Click OK to close the message Qbit DB 71 Database Management Copying a Database 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 Making a backup of your database table is highly recommended Ask your IT administrator how often a backup should be created Do the following to save a copy of the database the original database remains unchanged 1 Select Save Copy As from the Database menu and a Save As dialog box is displayed 2 To save the copy to a drive or folder select the drive letter and or folder at the Save in box 3 Type a name for the duplicate database in the File name field The mdb file extension is added automatically 4 Click Save to save the duplicate database The original database 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 st
84. in Window on page 6 Import File Enter the directory path and file name of the import file you want to Location and schedule or click Browse to find the file Name 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 Select how often a file will be auto imported into Qbit DB Frequency Options Qbit DB 37 Configuration Import Import Mode Select the mode for automatic importing as follows Off Select this option to disable automatic import 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 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 clock format Enable Time 1 Enable Time 2 Time 1 Time 2 12 00 AM 12 00 AM Enable Time 3 Enable Time 4 Time 3 Time 4 12 00 AM 12 00 AM 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
85. ion to display a table of sensor values that can be useful for troubleshooting the CubiScan Refer to Values on page 89 This function is not available when the CubiScan 50 200B 200TS 210 or 225 is selected Use this function to calibrate the scale and or sensors Refer to Calibrate on page 89 This function is not available when the CubiScan 50 200B 200TS 210 or 225 is selected Use this function to configure Qbit DB Configuration options include 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 16 for details Caliper Menu Length Width Height This menu is only displayed if a CubiScan 30 model is selected in the Tools menu gt Options gt CubiScan tab The following functions are available Refer to the CubiScan 30 Operations and Technical Manual for 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 Actions Menu Swap Length for Width Swap Width for Height Swap Height for Length Apply Tare Values Qbit DB Following are the functions av
86. it DB to capture your Windows user User Account ID account ID and store it in the selected user field each time the Update button is clicked Qbit DB 59 Configuration Login Prompt for User ID at Application Startup Prompt for User ID at Application Startup Using Drop Down List Prompt for User ID and Password at Application Startup Qbit DB Select this option if you want Qbit DB to prompt the user to enter an ID each time Qbit DB starts up Select this option if you want Qbit DB to prompt the user to select an ID from the drop down list each time Qbit DB starts up When you select this option a new field appears called the User ID Drop Down List Enter the desired values into this field When this option is selected a new option appears under the Actions menu that allows you to change users To change a user select Actions gt Change User Ctrl U and select the new user from the drop down list Select this option if you want Qbit DB to prompt the user for an ID and password each time Qbit DB starts up When you select this option a new button called Manage User Passwords appears When this option is selected a new option appears under the Actions menu that allows you to change users To change a user select Actions gt Change User Ctrl U and login using the desired user ID and password Click on this button to bring up the User Password Management window that is shown below User Password Management Us
87. ld and then click Move Down to move the selected field Move Down down one position in the table i Qbit DB 42 Configuration Export Click the drop down arrow at a table field to display a list of available fields and select a field name to add or change a field The SPACE FILLER option in the drop down list can be used to specify an NOTE ts 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 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 Qbit DB 43 Configuration Export 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 and volume Auto Export NOTE gt NOTE gt Qbit DB To set up Qbit DB to automatically export a file at a time of day at specified time intervals 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 41 After you set up an auto export the number of hours minutes seconds to the next
88. llowing screenshots were taken from a Windows 7 operating system Your OTE screenshots may appear different if you are using a different operating system To install your digital camera software complete the following steps 1 Locate your EOS DIGITAL Solution Disk that came in the camera box and load it into your computer s CD drive The following window will pop up 3 AutoPlay Za DVD RW Drive D NES CanonEOS241W Always do this for software and games Install or run program from your media C Run SETUP EXE j Published by Canon Inc General options z Open folder to view files p USING dows EXP e View more AutoPlay options in Control Panel 2 Click Run SETUP EXE Qbit DB 117 Installation Installing a Digital Camera Qbit DB 3 Select the area you live in Please select the area in which you live USA Canada Latin America D m Europe Middle East Africa e Es Figure 57 Digital Camera Setup First Screen 4 Select the country you live in Select the country where you live a Canada Panama Brazil Chile Mexico Argentina Other country n Figure 58 Digital Camera Setup Second Screen 118 Installation Installing a Digital Camera 5 Select your language Please select your language English Francais Espa ol Figure 59 Digital Camera Setup Third Screen 6 Select the Custom Installation option EOS
89. log box is displayed Set Password Dialog Enter password AA o o Re Enter password mooo Cancel 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 Qbit DB 31 Configuration Import Clear Password When you attempt to access a function that has been password protected the following prompt appears Password Dialog Enter Password Enter the password exactly as it was entered when set up case sensitive and click OK to open the function Click Clear Password to remove an existing password This allows access to all functions by all users The message Password has been cleared is displayed This means that a password is no longer required to use any functions in Qbit DB Click OK Import The Import option on the File menu is used to import data from an external source Refer to Importing to a Database Table on page 78 for information Click the Import tab to set up the import options the layout of the imported database fields and the automatic import function Import Type Qbit DB Select the Import Type tab to set up the options that define the type of files that can be imported 32 Configuration Import Import File T
90. nable this feature a new button appears on the home screen called Nesting the shortcut is lt F11 gt You may need to rearrange your main window to display the new nesting button The Nesting button will appear below the Delete button Select which user field will contain the nesting factor The options available are User Fields 1 7 Make sure you select a user field that is not already in use When you select a user field you will be automatically directed to the User Fields tab so that you can select the settings for the selected user field See User Fields on page 52 for more information on the options available for the user fields 70 Configuration Special Features Calculating and Saving a Nesting Factor To calculate and save a nesting factor complete the following steps 1 Measure a single item When the measurement process is complete remove the item from the CubiScan platform 2 Place the nested item on the CubiScan 3 Click the Nesting button The following window appears Enter a nested quantity total number of items on CubiScan and select the direction of nested items i e height direction width direction or length direction Nesting Quantity fa Nested Direction Height Width Length A Calculate F11 X Cancel 4 Enter the nested quantity into the field and select the nesting direction The nesting direction refers to the direction that the items are stacked
91. nd 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 csu Click 49 Configuration Factors Output Mode Factors Qbit DB Save The path and file name are inserted in the File Location and Name field 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 051215170159 unique txt Click the Factors tab to enter or edit the domestic and international dimensional weight factors A dimensional weight is calculated for each measurement both domestic and international 50 Configuration Factors CubiScan Database Password Import Export Factors User Fields Tolerances Orientation Login Camera Reports Nesting Dimensional Weight Factors DOMESTIC INTERNATIONAL Cubic Inches per Pound ES Cubic Inches per Kilogram Bee Cubic Centimeters per Pound za Cubic Centimeters per Kilogram 6000 NOTE
92. not want to define any restrictions select Any Character Secondary Field Field Name Enable Secondary Field Hide Field Allow Manual Entry in Addition to Drop Down List Auto Fill Drop Down List From Existing Data Qbit DB 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 can enter a product number in the primary field and then enter a pack type in the secondary field Type a field name in the text box to change the label The new label appears in the main window and in the database window Select this option to enable the secondary field When this field is enabled a new Repeat Item Number button appears above the Measure button in the measurement window If you click the Repeat Item Number button after measuring an item it will automatically identify the same item number as the previous measurement It will then automatically select the next item in the secondary field drop down list if applicable It will also update the description and user field values Select this option to hide the secondary field in the main window After you enable the secondary field you can enter a drop down list of items or descriptions from which to choose at the secondary field on the main window Select this option if you want to be able to make a manual entry in the secondary field in addition to selecting from th
93. nstalling Qbit DB 7 Read the license agreement and click the radio button next to I accept the license agreement if you agree Click Next to continue and the following window appears Fj Qbit DB InstallAware Wizard Destination Folder Collecting information Preparing installation Installimg Finalizing installation To InstallAware Please select the destination folder for the application a E os c Dll apps o bE cule Folder path l Space Required 28 282 KB Available Disk Space 392 011 MB Remaining Disk Space 391 984 MB Figure 50 Obit DB Installation Destination Folder Qbit DB 109 Installation Installing Qbit DB 8 Accept the default path for the installation of Qbit DB or select a different drive and or folder Click Next to continue The following window is displayed Fj Qbit DB InstallAware Wizard Start Menu Collecting information Please select the Start Menu group for the application Prepari ci AE Installing You may choose to create shortcuts for all users or just for yourself Finalizing installation All Users ES Just Me InstallAware Figure 51 Qbit DB Installation Start Menu 9 Accept the default Start Menu group or enter a different name Select whether you want All Users to have access to Qbit DB or if you want only yourself to have access to Qbit DB on this computer If you select Just Me a password is required to open
94. ntaining 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 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 1 Select Date Range from the Run Manual Excel Export submenu Name the export file and click Save The following dialog box is displayed Please Select Desired Date Range From Date To Date 2 23 2015 E 2 24 2015 E x Cancel 2 By default the From date is yesterday s date and the To date is today s date To change a date click E and a calendar is displayed from which to choose the date as follows February 2015 Mon Tue Wed Thu E e Qbit DB 84 Database Management Exporting a Database Table 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 Qbit DB 85 Chapter 4 CubiScan Functions NOTE gt Zero Qbit DB This chapter provides information on the Qbit DB functions used to verify reset and test the CubiScan T
95. nter Name Copies Mo Me Auto Print After Update Dimension Rounding True Rounding Y Dimension Digts After the Decimal 3 Weight Rounding True Rounding Weight Digits After the Decimal E Figure 38 Reports Tab Report Options This field contains label report settings Qbit DB 68 Configuration Nesting Enable Label Report Printing Label Setup Label Size Printer Name Copies Auto Print After Update Dimension Rounding Dimension Digits after the Decimal Weight Rounding Weight Digits after the Decimal Nesting Qbit DB Enable this field to allow label reports to be printed This field contains label setup options Select the size of the label from the drop down box The sizes available are a 2x2 3x3 4x4 and a 4x6 inch label Select the printer that the label will print to Type in the number of labels that you want to print Enable this field if you want a label to print each time you hit Update Select the dimension rounding option that you prefer This option will round the length width and height measurements to the option that you select The options available are True Rounding Round Up and Round Down Type in the number of digits that you want to appear after the decimal on length width and height measurement dimensions Select the weight rounding option that you prefer This option will round the weight measurement to the option that you select
96. of the import process and any errors encountered are displayed in the message box Exporting a Database Table Qbit DB Use the Export option to export an entire Qbit DB database table or a portion of a database table to a variable or fixed length format ASCII text file 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 Because the layout does affect Excel exports it cannot contain any duplicate field names Refer to Export Layout on page 41 for instructions To export to an ODBC data source see ODBC ini on page 72 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 80 Database Management Exporting a Database
97. or the length width height weight or volume of an item s measurements You can also set an Allowed Difference tolerance which is the difference allowed between an item s current dimension versus the new dimension that has been manually inputed or received from the CubiScan 54 Configuration Tolerances Enable Tolerance Qbit DB Checking CubiScan Database Password Import Export Factors User Fields Tolerances Orientation Login Camera Reports Nesting After enabling the tolerance validation feature enter the Max Min or Allowed Difference values and enable the dimensions that need to be validated Dimension validations can occur after clicking the Measurement ar Update button Enable Tolerance Checking Tolerance Values MaxVawe MinValue Allowed Difference Enable only those items Enable Length Enable Length Enable Length that you want validated Enable Width Enable Width Enable Width using the tolerance Enable Height Enable Height Enable Height a Enable Weight Enable Weight Enable Weight Enable Volume Enable Volume Enable Volume Validation Options J Tum Of Message Dialog Notifications Validation Event f After Clicking Measure Buttton After Clicking Update Buttton Clear Measurement Data on Emors j j Ti gt 7 an p T Y a i nr Tat 3 1 F Bypass Update When tem isin Tolerance A ee Blan Figure 28 Tolerances Tab Enabling this function allows
98. ore them in a secure place so that they are available in the event of a hard disk or other computer failure Importing to a Database Table Qbit DB Use the Import function on the File menu to import data from an external ASCII text file source or Excel file You must set up the import file options before importing a file refer to Import Type on page 32 Also the layout of the information in the text file must match the Qbit DB database layout to be imported correctly Refer to Import Layout on page 34 for instructions on mapping the fields in an import file to the Qbit DB database fields Do the following to configure import data options 1 Open the database table to which you want to add or update the new data see Opening a Database on page 75 If you want to create a new database table with the imported data create a new empty database table with a unique name in which you 78 Database Management Importing to a Database Table NOTE I NOTE gt Qbit DB will insert the imported data see Creating a New Database on page 74 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
99. ormation on creating a label report see Label Report on page 100 For information on designing a label see Designer Report on page 104 Detail Report NOTE gt 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 in Figure 45 on page 101 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 You can also generate reports on your measurement data by exporting it from Qbit DB in a text file and importing it into another application such as a word processing or spreadsheet program Refer to Exporting a Database Table on page 80 and Importing to a Database Table on page 78 for information Label Report Qbit DB The Label report lists the information for the item number that was selected when the Reports gt Label option was selected The default label displays the item number barcode measurement dimensions date and time An example is shown in Figure 46 on page 102 100 Reports Label Report To create a label report the option Enable Label Report Printing must be enabled under the Tools gt Options gt Reports tab Report Preview When you select Detail or Label from the Report menu it is displayed in the Preview window as shown below 3 16 2015 9 26 11 AM Wot 4
100. pot Factors User Fields Tolerances Orientation Login Camera Reports Nesting Dimension Orientation To automatically orient the CubiScan data from largest to smallest enable the check box and then use the pick lists to select the order A specific dimension can be excluded from the sort Enable Automatic Dimension Orientation Exclude Dimension from Sort iv m o m Length Dimension O_O O O O Width Dimension Height Dimension Figure 29 Orientation Tab Dimension Orientation In this field you can enable automatic dimension orientation select dimensions that should be excluded from the automatic option and select dimension settings The orientation tab settings occur when you click the Measure button Enable Automatic Enabling this field automatically sorts the item s measurements according Dimension to the selections made in the drop down length width and height Orientation Qbit DB 5 Configuration Orientation Exclude Dimension from Sort Length Width and Height Dimensions Qbit DB dimension boxes The message window will notify you of the automatic dimension orientation that took place An example is shown below 16 3352347 Cubiscan Model 100 Selected 16 3302 9 4 Connected to Seral Port 5 16 34 25 979 Sorted onentation Len 35 7 Wid 6 5 Hot 1 7 2 16 35 14 365 Sorted onentation Len 21 8 Wid 3 2 Hot 3 9 16 30 41 467 21 8000 3 2000 x 3 9000 in 52 7200 lb 272 0640 ing
101. ptions Axis Camera Options e Enable Network Camera Snapshots Camera Setup IP Addre 110 1 100 40 lw Auto Snapshot After Measure W Enable Multiple Snapshots IP Port Number E 2 00 Seconds to Show Snapshot Test Connection Stop Connection Digital Camera Options Enable Digital Camera Snapshots Camera Setup Auto Accept Image Enable Multiple Snapshots Figure 33 Camera Options Axis Camera This field contains all the settings for a network Axis camera Options Enable Network Enable this field to allow a network camera to connect to Obit DB Camera Snapshots Anew Snapshot button will also appear in the measurement window Click this button to take a snapshot e Once a snapshot has been taken Qbit DB automatically names and saves the file as a jpg To see the file name use the arrows to scroll to the far right of the database window until you reach the SnapShot File section This section displays the file names of each snapshot taken To select the image file name settings see Image File Options on page 67 Qbit DB 62 Configuration Camera IP Address IP Port Number Auto Snapshot After Measure Seconds to Show Snapshot Enable Multiple Snapshots NOTE I Qbit DB If there are multiple snapshots associated with an item number then Qbit DB displays in the file name as shown below 453 Master jpg 2345345 Inner jpg 245345 Each_ jpg Camera Setup Select your network
102. r Select the desired file and click Add Have your Database Administrator complete the process Map the Qbit DB database fields to the appropriate fields in the other database The scale ini file allows you to configure Qbit DB with a third party scale This will enable a new button on the Qbit DB main window called Weigh F8 Clicking this button will capture the weight data from the third party scale Weight data can only be captured after requesting data from the CubiScan except for the CubiScan 225 and 210 which can capture weight data before or after requesting data The following list contains the piece count options and information PIECE COUNT ENABLED O False 1 True Enable the piece count if you want to place multiple pieces on the external scale and have the software divide the weight received by the piece count The piece count information will be taken from User Field 8 Therefore User Field 8 must be enabled and must be entered before the weight is requested It will default to 1 each time a new measurement is taken Piece Count Enabled o 73 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 chapter 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
103. radox To Access fo A Qbit Application Find Old Table QbitWin C QbitWMS Convert C Qbit30Win C Qbit50PS ose O C Qbit50WMS C Qbit150 C Qbit150WMS Old Figure 11 Convert Paradox to Access Window 4 Select the Qbit application in which the database you want to convert was created If the database you are converting came from a Qbit WMS system you must enter which Pack Type you want to use in the new Access database Qbit DB 26 Configuration Database Convert Paradox To Access Qbit Application Pack Type FindOldTable e QbitWin S C QbitWMS Comet C Qbit30Win C QbitS0PS o C QbitSOWMS C Qbit150 C QbitI5S0WMS Paradox record count 1 Access record count 0 y Figure 12 Convert Paradox to Access QbitWin Window If you are converting a database from QbitWMS you must enter the equivalents to the Pallet Pack Master Pack Inner Pack and Each Pack fields found under the Pack Types tab You can also enter additional information into the User 1 through User 8 tabs if needed Use the arrows to scroll from tab to tab Qbit DB 27 Configuration Database Convert Paradox To Access Qbit Application Pack Types User User2 User3 Userg 4 gt Find Old Table C QbitWin QbiWMS OLD NEW C Qbit30Win Pallet Pack C Qbit50PS Master Pack C Qbit50WMS Inner Pack C Qbit150 Each Pack C QbitI50WMS Paradox record count 1
104. rarr eee e eee eeees 36 AMOT POr sc cececeoeeheonsaehes tastes ed ENERE EEE REEERE EREA 37 Do A lt P tered sae ohseee eeease seasons 40 EXPO bay OUL 55555 bau orense jo ande aaa eee 42 AUTO EXPO PrequUenCr sr sda rota barons das anat ds be Seas 45 Auto Export Destinatl0N ooooooooooooororrrrrrrcrrrrnrrrrrsnon o 47 Auto Export Destination FTP oooooooooooooocncorrnnrrsrrrnnon s 48 Pacto Va aconcac eo ari ete eave kat dah ee bus bon ica nda 51 User Fields Tabernas ao ene e eas 52 Tolerantes Tabo sesionar a i ed wd OEE 55 Onenta don LAN rana ia iia 57 Automatic Dimension Orlentati0O oooooooooooorooo ee cee ee eee o ooo 58 LO TA rones wae oes ob ee ee ee wee ee ee reece aa 59 User Password Management Window 200 e cece eee eee o 60 Figure 33 Figure 34 Figure 35 Figure 36 Figure 37 Figure 38 Figure 39 Figure 40 Figure 41 Figure 42 Figure 43 Figure 44 Figure 45 Figure 46 Figure 47 Figure 48 Figure 49 Figure 50 Figure 51 Figure 52 Figure 53 Figure 54 Figure 55 Figure 56 Figure 57 Figure 58 Figure 59 Figure 60 Figure 61 Figure 62 Figure 63 Figure 64 Figure 65 Figure 66 Figure 67 Figure 68 Figure 69 Figure 70 Camera OPON dada 62 Side SHOW VIEW ina a iia A ae 64 Auto Accept Image Disabled o ooooooocoorocronmcorncrrnnmomm os 65 Auto AcceptImare Enabled sisi des 66 Image Hle OPUS DD Bs 67 Reports Tabanera dos dd it iia di ae A 68 Nest Taba a
105. rate 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 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 the CubiScan s sensors 1 Select Calibrate from the Tools menu then select Sensors The following prompt is displayed 2S Confirm O Continue with Sensor Calibration 2 Click OK to proceed and the following dialog box appears alibrate Sensors This routine will run through a se es of steps designed to determine the precise position of the ultrasound transducers This procedure should be performed penodically or any time the Dimensions are not within tolerance F you wish to continue with the calibration click CONTINUE otherwise you may exit without calibrating the CubiScan e Continue FF x Cancel FE Figure 42 Calibrate Sensors 3 Click Continue or press lt F7 gt to begin the process of calibrating the CubiScan s sensors Follow the instructions for steps 1 5 until the sensor calibration is finished Qbit DB 90 CubiScan Functions Calibrate 4 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
106. re 13 Figure 14 Figure 15 Figure 16 Figure 17 Figure 18 Figure 19 Figure 20 Figure 21 Figure 22 Figure 23 Figure 24 Figure 25 Figure 26 Figure 27 Figure 28 Figure 29 Figure 30 Figure 31 Figure 32 Mat WIAdOWas rar trotar a RS Da 6 SLACKING WIAdoW ceresarcqarsen casa Det is 7 Measurement Window 0 c cece cece eee cee eee tence atte teen ee eeeeees 8 CubiScan Picture WindOW 0 ccc ce cece eee cent ee eee ro 10 Camera Image WindOW ccc ccc ccc eet ee ee eee tee eee ete eeeeeeeeaes 10 Previous Measurement WindOW 20 e cece ce eee eee teen een e ene nee eens 11 Message Window ccc ec ce cee ce eee cee tee ete ence ates seen seen eeeaes 11 Database WINdOW spretni eeaeee Ea e dE props nia ee eee 12 Cubiocan MAD podr RT ts pa 18 Database Laos corroe van oes roer a 20 Convert Paradox to Access WindOW 0c cece ccc cent ence nee n een eenee 26 Convert Paradox to Access QbitWin Window 0 00 cece eee eee eee tenes 97 Convert Paradox to Access QbItWMS Window 0 000 c cece cece ee eee neces 28 Convert Paradox to Access Conversion Window 0c cece cece eee eee 29 Convert Paradox to Access Conversion Complete oo oooooooooomoooooo 30 PassWord Diarra isa ida 31 IMPOrCINDO 201 coe nos son tas eran oats pee dae a aa A in E 33 Importe LbavOlts ven sais veo dime pato bate te heres E TE E E E oe tae 35 Import Layout Load Sample oooooooooororonrr
107. ric Characters t User Field 8 id User Field 8 is a numeric only CY IN Character i Drop Down List Alphabetic Character Option E Save Changes e Mixed Case Upper Case Lower Case wW OK X Cancel Figure 27 User Fields Tab Use the following options to set up one or more user fields Select User Field Select the user field that you would like to edit You must save the changes made at each field using the Save Changes button before moving on to the next field If you make a change to a user field and forget to save you will be prompted to save your changes If you are only editing one user field you can simply click OK after you have made your changes and the changes will automatically be saved User Field 8 is numertc only NOTE I Qbit DB 52 Configuration User Fields User Field Attributes Requirements Field Name Field Length Enable Field Mandatory Entry Include This Field When Repeating Hide Field Use Default Value Default or Static Value Data Entry Option Qbit DB Select the attributes of user fields 1 8 Setup the requirements for the selected user field 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 Enter the maximum number of characters that can be entered in the field from 1 to 60 You will not be allowed to enter more than the sp
108. rify that the proper COM port is selected in the setup options in Qbit DB If there is still no communication verify that the serial port on your computer is operational refer to your computer s documentation If you are using a USB to serial adapter check which COM port your 128 Frequently Asked Questions computer is using This information can be found under your computer s Device Manager see below y Device Manager File Action View Help e968 mia a y Cassie 12 14 3 Batteries 2 Biometric Devices Bluetooth Radios Mi Computer a Disk drives E Display adapters 3 DVD CD ROM drives oS Human Interface Devices Imaging devices amp Intel WiUSB gt Keyboards F Mice and other pointing devices amp Monitors Network adapters Y Ports COM amp LPT Y Communications Port COM1 Y ECP Printer Port LPT1 gt Intel R Active Management Technology SOL COM3 gt Prolific USB to Serial Comm Port COM5 a Processors Sound video and game controllers lt gt Storage controllers JE System devices Universal Serial Bus controllers Figure 70 Device Manager In the example shown in the figure above the prolific port was assigned to COM5 Make sure that you are using the same port number in Qbit DB located in the PC Port field under the Tools gt Options gt CubiScan tab Question All of the records at the bottom of the Qbit DB page have disappeared how do I
109. ring to the figure below or the parts list on page 115 Figure 55 Axis Camera Kit Components USB to Ethernet Adapter Axis Camera Tripod PoE Switch Ethernet Cables 2 Jawe To install your network camera complete the following steps 1 Locate your white TRENDnet USB to Ethernet adapter cable and plug it into an available USB port on your computer Wait for the appropriate drivers to load If there are any problems with this process refer to the TRENDnet User s Guide that came in the box with the adapter 2 Locate your TRENDnet PoE Switch and connect it to a power source 3 Locate one of two of the Ethernet cables and plug one end of the cable into the USB to Ethernet adapter cable and the other end into the TRENDnet PoE Switch You can plug the Ethernet cable into any of the Qbit DB A Installation Installing a Network Axis Camera PoE switch ports 1 8 but slots 5 8 are recommended because power will not be required Set up your camera using the tripod included or the cart mount system not included as desired Locate the remaining Ethernet cable and plug one end of the cable into the PoE Switch You must plug it into one of the PoE switch ports labeled 1 4 or PoE so that the camera will receive power Plug the other end of the Ethernet cable into the back of the Axis camera A green light should appear at the back of the Axis camera if it has been connected correctly The light will be orange i
110. rt you want and click Open to display it Click to save the displayed report A Save Report dialog box is displayed Reports are saved in the gt CubiScan gt Reports 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 Click to display the Find Text dialog window This window will allow you to search the report for specific word s by typing the desired word s into the Text to find field You can also enable the options Search from beginning or Case sensitive Search from the beginning option searches the document from the beginning and the case sensitive option makes your search case sensitive Search from beginning Case sensitive o cone Click to zoom in Each time you click the report is magnified by 25 Click the drop down arrow and select a size to display the report or click in the text box and enter a percentage a 88 Og fla Click to zoom out Each time you click the report is minimized by 25 Click to display the report in the full window view Right click anywhere on the screen and select Full Window to return to the default view This report outline button is not applicable in the report or label preview Click to display a sidebar that contains thumbnails of all the report pages Click this button again to return to the normal display Click to set
111. ry 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 message is displayed Warning A Item already exists Update Yes No Select Yes to overwrite the existing item or No if you did not intend to change the existing item Select this option if you update existing items or import data in a database more often then you add new items This option is used with its sub options to give you multiple variations as follows 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 22 Configuration 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 x Item was not found and the option Allow New Items To Be Added is not enabled Action has been canceled OK Auto Advance through Items Select this option if 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 The database
112. sional Select whether you want to use Domestic or International dimensional Weight Units weight units Refer to Factors on page 50 for information on setting up dimensional weight factors CubiScan Options Communication Select which method you will use to connect your CubiScan to a computer Ports The options are RS232 Serial Port Network Port or USB Port depending Qbit DB 18 Configuration CubiScan Qbit DB on which CubiScan model is selected If you are using the serial port enter the PC Port If you are using the Network Port enter the IP Address and the IP Port CubiScan Model Site ID Select the 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 available in the main window will change to match the selected model The T Model is the touchscreen model for the CubiScan 100 110 and 150 If you have the touchscreen model for one of these CubiScans enable this field when selecting your model If you select one of these models a new USB port option appears under the communications ports section 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 Enter the serial number and click OK to close the prompt and continue If measurement data from your site will be exported and merged with measuremen
113. stomizing the Main Window on page 13 select this function to return it to the default view If you have changed the arrangement of windows of the main window see Customizing the Main Window on page 13 select this function to save the new arrangement as the default view Saving a new default view will erase the factory setting default view If you have changed the arrangement of windows of the main window see Customizing the Main Window on page 13 select this function to lock the position of the windows so that it cannot be moved Select Unlock View to unlock them Tools Menu Zero Status Test Mode Qbit DB Following are the functions available on the Tools menu The Zero Status Test Mode Values and Calibrate functions may not be available depending on whether or not the functions are available on the selected CubiScan model Use this function to zero the CubiScan Refer to Zero on page 86 This function is not available when the CubiScan 50 200B 200TS 210 or 225 is selected Use this function to verify that the CubiScan is operating properly Refer to Status on page 87 This function is not available when the CubiScan 30 50 200B 200TS 210 or 225 is selected Use this function to set up the CubiScan for testing purposes Refer to Test Mode on page 88 Getting Started Menu Bar Values Calibrate Options Use this funct
114. t Database Click OK when you are finished 4 When you exit the Tools gt Options window the following window appears Scan Barcode Scan Barcode Qbit DB 97 Measuring Objects Measuring Stacked Quantities 5 Scan or type the barcode number Qbit DB will find the primary field information typically the item number that is associated with the barcode number information that you entered and will automatically populate the primary field 6 Qbit DB is now ready to measure an item Measuring Stacked Quantities Qbit DB If you want to stack like items for measurement but want the dimensions for each item included separately in the database use the Stacked Quantities box 1 Ifthe Stacked Quantities box is not visible pull down the View menu and select Stacking Stacked Qty s Height mm Length ho H Width Zz Stacked Qty is the number of like items placed in an axis The net dimensions and weight are calculated to provide an lt Each gt measurement 2 Place the stack of objects on the CubiScan platform Make sure all the edges of the objects 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 4 Measure the item by clicking the Measure button F3 or using the measuring gate The CubiScan values will be calculated using the stack quantity
115. t 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 is 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 19 Configuration Database Database Click the Database tab to 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 CubiScan Database Password Import Export Factores User Fields Tolerances Orientation Login Camera Reports Nesting Primary Field Database Options Field Name Data Mode item Number Enable XRef Lookup Add Update tems Field Length 1 50 Venfy tem Exists before Update B5 E Key Field Option E Ary Character C Allow Duplicates Alpha Numeric Characters Auto Update C Alphabetic Characters Up Numeric Characters Enable Record Delete Button Secondary Field Tare Values Field Name Pack Type Enable Tare Option Enable Secondary Field Hide Field Length 0 0000 Allow Manual Entry in Addition to Drop Down List Width 0 0000 Auto Fill Drop Down List from Existing Data Height 0 0000 Show Error on Zero Secondary Field Drop Down List Weight 0 0000 Positive values are subtracted from the CubiScan measurements Description Field Convert QbitWin Q
116. the platform Make certain that the CubiScan platform is free of all objects before using Zero If NOTE gt not the zero reading will not be accurate 1 Pull down the Tools menu and select Zero The following prompt is displayed Warning ES i The CubiScan must be clear of all objects Cancel 2 Verify that the CubiScan platform is free of ALL objects then click OK to proceed 3 After the scale and sensors are zeroed the following message is displayed Cubiscan Zero Zeroing 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 Warning es i The CubiScan must be clear of all objects Cancel 2 Verify that the CubiScan platform is free of ALL objects then click OK to proceed Qbit DB 8 CubiScan Functions Test Mode 3 The current status is checked and an appropriate message returned If there are no problems the following message is displayed Cubiscan Status CubiScan OK Retum Code TADO 4 Click OK to return to the main window If any problems are found an error message appears For example TAXX error message where XX is 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 CubiSc
117. tions available for Prefix 2 are Item Number Pack Type and User 1 6 The options available for Prefix 3 5 are None Item Number Pack Type and User 1 5 File Name Prefix You can select the symbol that will separate the file name prefixes from the Separator following options None Dash Underscore or Plus Static Text You can enter any desired text here that you want included in image file names To add the static text to the file name select Static Text in one of the Prefix 1 5 drop down lists Date amp Time You can enter the date and time here To add the date and time to the file name select Date amp Time in one of the Prefix 1 5 drop down lists The acceptable date amp time formats are found below the Date amp Time field Qbit DB 67 Configuration Reports Using these formats will ensure that the file is saved with the correct information Make sure that none of the following characters are being using in the Prefix 1 5 Static Text or Date amp Time fields because a file name cannot contain them P lt gt NOTE gt Reports Access this tab to enable label report printing and select label setup options For information on designing your label see Designer on page 5 CubiScan Database Password Import Export Factors User Fields Tolerances Orientation Login Camera Reports Nesting Report Options Enable Label Report Printing Label Setup Label Size Pri
118. ts menu 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 100 Select this function to generate a label that can be printed For information on customizing this label see Label Report on page 100 Selecting this function brings up the FastReport Window This window allows you to customize the label that Qbit DB generates When saving your customized label you must save it under one of the existing label files such as Label 2 x 2 3x3 4X4 0r4X6 The label and designer functions are only available if the Enable Label Report Printing field is enabled under Tools gt Options gt Reports Help Menu About Following are the functions available on the Help menu Select this function to display the current version and build of Qbit DB and information about Quantronix Inc Languages Menu Qbit DB From this menu you can choose from the following languages e Chinese PRC e Danish Getting Started Main Window e English e French e Japanese e Portuguese e Russian e Spanish 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 Quit DB ae a ls A l ae e e e PA Se File Database View Tools Actions Reports Help Languages
119. up the report pages for printing A Page Settings dialog box is displayed Select the size orientation margins and other options for each page of the report and click OK Qbit DB 103 Reports Designer Report Width 27 94 cm Height 21 59 om Orientation Portrait f y Landscape a 1 cm Right 1 cm 1 cm Bottom 1 cm Apply to the current page Apply to all pages o cence The edit page option is grayed out and not applicable in the report or label previewer Click to go to the first page of the report Click to go to the previous page of the report 4 The number of the report page that is shown in the wndow is displayed in 7 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 Dr Click to go to the last page of the report Close Click to close the report and return to the Qbit DB main window Designer Report The Designer option is found under the Reports menu Select this option if you would like to customize a label To enter the label designer the option Enable Label Report Printing must be enabled under the Tools gt Options gt Reports tab When the Designer option is selected the FastReport Window appears This window allows you to customize the label that Qbit DB generates Qbit DB 104 Reports Designer Report When saving your customized label you must save it under one of the existing lab
120. updated but new items are not added to the database Append Update New items are added to the existing database and any duplicate items are updated If you are importing data into a new empty database select either Append Only or Append Update Because 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 You may want to back up an existing database table before importing the file into it Refer to Copying a Database on page 78 for information Click Import on the File menu and a submenu is displayed with the following functions Run Auto Import Select this function to start the automatic import that you have already set up See Auto Import on page 37 Run Manual Import Complete the following steps to run a manual import 1 Select Import gt Run Manual Import from the File menu 2 Ifnecessary navigate to the file location and select the file you want to import 79 Database Management Exporting a Database Table 3 Ifnecessary select the format of the imported file e g xls 4 Click the name of the text file to import and it is inserted in the File name field 5 Click Open to import the file into the open database table The status
121. use the layout does affect Excel exports it cannot contain any duplicate field names Select one of the following options Select the All Data option to create an export text file containing 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 is 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 83 Database Management Exporting a Database Table 5 Select All Data or Updated Data from the Run Manual Excel Export submenu A dialog box is displayed 6 Export files are saved in the gt CubiScan gt Export folder by default If you want to save the file to a different drive and or folder navigate to your preferred location 7 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 co
122. w Answer Click on the top left corner of the window and drag it to where you would like it Question When I am using an ODBC connection and the following error is received ODBC transfer queue item not found sequence number how do I fix this error condition Answer Open the CubiScan folder Locate the file called ODBC Seq Num Errors txt and rename it to ODBC Seq Num Errors txt old Restart Qbit DB If you have additional questions or require further help please contact CubiScan Service and Support for assistance at 801 451 0500 or at sup port cubiscan com Qbit DB 130
123. wing 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 Tuesday May 5 2015 All of the database tables in Obit DB are listed 2 Click the name of the database table that you want to open and the table is loaded into Obit DB Qbit DB 75 Database Management Deleting a Database Click Cancel if you do not want to open a new table 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 x Cancel All of the database tables in Qbit DB are listed 2 Click the name of the database table that you want to delete and the following warning is displayed Warning all records will be lost Delete table Books 3 All records in the selected database table will be deleted and cannot be recovered Click Yes if you want to delete the specified database table Qbit DB 76 Database Management Emptying a Database The following message is displayed Information 4 Click OK to close the message You cannot delete a database that is currently open Either create a new database or open an existing database so that you will be allowed to delete the correct database NOTE gt Emptying a Database Do the following to delete all of the records from a database table 1 Make sure the table from wh
124. y side or corner until the pointer changes to directional arrows Click and hold the mouse button and drag the side or corner of the window until it is the size you want then release the mouse button You can resize the entire main window using the same method Each window that can be separated has a docking bar at the top when the window is docked or in a fixed position in the window To move the window click the docking bar hold down the mouse button and drag the window 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 window to a floating or undocked position the docking bar changes to a title bar To move a floating window click the title bar hold down the mouse button and drag the window When you move it into a docked position the docking bar appears again If you do not want the window to snap into a docked position hold down the lt Ctrl gt key as you drag it It then becomes a floating window that can be positioned anywhere on the screen 13 Getting Started Status Bar Hiding Showing Saving a View Status Bar Docked positions are on either side of the measurement window To hide the stacking window CubiScan picture window message window camera image window previous measurement window or the Database fields in the measurement window
125. you can enable and disable various validation options Enabling this field allows you to override tolerance exceptions that are found Enabling this field turns off the tolerance exception notifications Enabling this field will clear all the measurement data when tolerance exceptions are found Enabling this field will allow the system to bypass updating the database when items are in tolerance This means that if you attempt to update and change an item s measurements the system will not retain the changes if the measurements are within the tolerance values When this option is enabled the Validation Event field is grayed out Validation Event After Clicking Measure Button After Clicking Update Button After Clicking Measure or Update Button Qbit DB The Validation Event field allows you to select when you would like the system to check for tolerance exceptions Selecting this field will prompt the Qbit DB system to check for tolerance exceptions when the Measure button is clicked Selecting this field will prompt the Qbit DB system to check for tolerance exceptions when the Update button is clicked Selecting this field will prompt the Qbit DB system to check for tolerance exceptions when the Measure or Update button is clicked 56 Configuration Orientation Orientation From this tab you can select the orientation settings of the CubiScan s measurements CubiScan Database Fassword Import E
126. ype Delimited Fixed Length Qbit DB CubiScan Database Password Import Export Factors User Fields Tolerances Orientation Login Camera Reports Nesting Import Type Import Layout Auto Import Import File Type f Delimited Fixed Length Microsoft Excel Note The Excel SHEET name must be named Sheet 1 Import File Contains Header Information fe Yes t No Import Merge Options f Append Only Existing items will not be updated new items will be added f Update Onby Existing items will be updated new items will not be added Append Update Existing items will be updated new items will be added Import Delimited File Delimiter Type Comma t Tab t Other Import File Delimiter Figure 17 Import Type This tab is not available if you have enabled the Allow Duplicates field under Tools gt Options gt Database gt Database Options Select the file type to be used when importing database tables The default is delimited Variable length delimited files csu 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 fields depends on your Windows regional settings If you select this option additional options to define the delimiter type become available at the bottom

Download Pdf Manuals

Related Search

Related Contents

Dataflash User Manual  StarTech.com 10 ft Beige A to B USB 2.0 Cable - M/M  The Audit Plan – template user guide  Manual de Montagem e Preparação - Kawasaki ER-6N  SoftWall Finishing Systems SW3223352035 Instructions / Assembly  Módulos tipo TX  取扱説明書 - タカショー  Optoma DX609 data projector  Owner`s Manual GB Manuel d`Installation F  Fujitsu LIFEBOOK U904  

Copyright © All rights reserved. Failed to retrieve file