RFDBMgr Manual
Contents
1. 1 2 4 la Uy Connect Convert Data Exit 1 3 Connect Save As 2 Start with Open Database 2 1 a File Conneck Open ATF 22 1 Connect Save As 12 Using RFDBManager 433 MHz 2 4 GHz User s Guide RF Reading Dialogue When the application template file ATF includes a form that doesn t make reference to lookup files the RF Reading dialog box pops up right after executing the Open ATF command After defining your RF Reading settings below there appears the RF Reading Toolbar on page 13 as well as the RF Reading Tab on page 13 X Note The data received can only be saved in text format txt Tin Reading E xX Date amp amp Time stamp Add to record s top Directory ES OCUNODES and S SEU ipods Separate Date stamp and Time stamp File name 1 TXT File made Overwrite Date Format Year 4 Digits rrr Month Day Separator EE Date Style Year Month Day Add Return character to each record Add Line Feed character to each record Character replacement ASCII 44 59 Add Date Time stamp lt lt OK Cancel Time Format Hour Minute Second Separator Option To Do Directory Specify where the data is to be saved by entering file path or click Browse to select a location File name Enter file name File mode Choose file mode Overwrite Append or2. Master or Slave Only one base station standalone Two or more one master the rest slave Baud rate 115200 57600 38400 Set the baud rate for RS 232 connection 19200 9600 4800 2400 bps gt Identification No ID Hold down the function key and press the Num key 1 or 3 to change ID 01 45 for 433 MHz RF 01 99 for 2 4 GHz RF FN 1 decrease number FN 3 increase number Channel CH Hold down the function key and press the Num key 4 or 6 to change channel 1 4 for 433 MHz RF 1 6 for 2 4 GHz RF FN 4 decrease number FN 6 increase number Power Level PW Hold down the function key and press the Num key 7 or 9 to change power level 1 5 for 433 MHz RF only FN 7 decrease number FN 9 increase number 52 Using RFDBManager 433 MHz 2 4 GHz User s Guide Editing After executing one of the following commands to create a database you can use the Editing Toolbar to manage the received data manually Convert Data Open Database Data Link Add a record 1 Click Add 2 The dialog box contains fields of a record for input 3 When input is completed click Update DATE 2005 04 11 ITEM Add a record CATEGORY Example QTY a TIME 14 48 31 Update Cancel Chapter 3 Demonstration 53 4 The new record will be added to the bottom of the list DATE IT EM CATEGORY 0OTPY TIME soa Coke Grmcey H 14335 DSa Candy TETTE TE
3. 2005 04 04 Cigarette 2005 04 04 Wine 2005 04 04 Pencil 2005 04 04 Book 2005 04 04 Notebook 2005 04 04 Charger 12005 04 04 Scanner Previous record Current record First record N P Total records a E 4 1 10 Records Chapter 2 The RFDBManager Interface 17 Status Bar OKO1 DT01010119958 DT01D119958 Charger 300 COMI 115200 None Ry The Status Bar is located at the bottom of the application window It gives information on the activities between the host computer and the Base Station Message Column Gives Information On OKO Command received from the Base Station 0701010119956 A Data received from the Base Station 07010119956 Book 777 Command or data sent out from the local port COM 115200 None Z4 Local COM port properties when it is open It will show COM Properties when the COM port is closed 19 CHAPTER 3 Demonstration This chapter gives more information on how to use the RFDBManager in your application In This Chapter EXeCUle Progra priori 19 General Application Window seen 20 Start with Open ATE E 20 Start with Open Database sse 45 Del up Connection su eoe edea deanna eon Nee ra 45 CORSO Morir intet esa 47 EE ratas 52 SVGA pat M 57 ji e nnenn A 59 Execute Program 1 Execute the
4. Margin Top margin size from top to the edge of paper in millimeter Bottom margin size from bottom to the edge of paper in millimeter Left margin size from left to the edge of paper in millimeter Right margin size from right to the edge of paper in millimeter Print 1 When in the RF Reading tab simply click Print When in the Database tab select a data sheet first Then click Print 2 Select the target printer and click Print Chapter 3 Demonstration 61 Preview You may click Preview to take a glance at the printout Zooming zoom 1002 Click the drop down menu to select an appropriate preview size Print When the print layout satisfies your needs simply click to print E Print el a Export oom 100 m Sample 1 DATE ITEH CATEGORY QTY TIME 2005 041 Coke Grocery 1000 11 20 43 2005 041 Candy Grocery eO 11 20 43 2005 041 Soft drink Grocery 300 11 20 43 0050411 Cigarette Grocery 11 20 43 25 04 11 Wine Grocery 11 20 43 2005 041 Pencil Grocery 11 20 43 2005 041 Book Grocery 11 20 43 2005 041 Notebook Grocery 11 20 43 2005 041 Charger Grocery 11 20 43 2005 041 Scanner Grocery 11 20 43 Pages M4 MI 62 Using RFDBManager 433 MHz 2 4 GHz User s Guide Export You may click Li to export it all or by page to different file formats c 3 xi HTML htm html Text txt Unicode HTML UTF 8 htm html Unicode Text
5. Sample 3 e005 04 12 9951 Candy 20000 10 45 52 2005 04 12 9952 Softdrink 300 10 45 52 2005 04 12 9953 Cigarette 4000 10 45 52 2005 04 12 9954 Wine 500 10 45 52 2005 04 12 9955 Pencil 6000 10 45 52 2005 04 12 9956 Book 777 10 45 52 2005 04 12 9957 Notebook 80 10 45 52 2005 04 12 9958 Charger 900 10 45 52 2005 04 12 9959 Scanner 10000 10 45 52 M 4 7 10 Records DT01050119956 Ds STMO1 00 COM1 115200 None 4 TM0105 gt Database When you click on the Database tab it displays in two panes title of data sheet on the left and its content on the right It can display up to three data sheets RFReading e When you click on the RF Reading tab it simply displays data received Note The data file tab s vary with the lookup file attributes 1 The Database tab will be brought up when the application template contains a form that makes reference to lookup file s 2 The RF Reading tab will be brought up when the application template contains a form that doesn t make reference to lookup file s Chapter 2 The RFDBManager Interface 7 Menu Bar The Menu Bar contains a number of menus that specify which task you want the system to perform Each menu contains a list of commands and sometimes sub menus Some of the options carry out commands immediately and others display a win
6. ATF hy Recent Ej RF Sample ATF Documents Dezkkho p My Documents my a My Computer File name HF Sample ATF y TIENE Fles of type Application Template Files ATF b Flaces Cancel Open as read only Now the application window is as shown below If the application template file ATF includes a form that specifies none for its lookup properties the RF Reading dialog box on page 12 will appear T RF Database Manager File RF Link Configure Help J ST D Connect Convert Data Data Link Exil Database K cn M Properties d 22 Using RFDBManager 433 MHz 2 4 GHz User s Guide 4 Proceed to click Convert Data to import text file or click Data Link on page 25 for access to a custom database Convert Data 1 Click Convert Data to convert lookup text file into data sheet Because up to three lookup files are allowed in the application template you ll have to make sure all of them are imported to our database here 2 The following window pops up for specifying file path When the file is located click Open My Recent Documents eskto p My Documents LL d My Computer k File name Lookup 5 ample Ext e TIENE Fles of ype Tex Files TT Cancel Open as read only Chapter 3 Demonstration 23 3 The application template may specify that the lookup file s data fields include date or time attribute Convert Data 1 X P Data
7. Fields include date or time attribute ww j Automatically generate date and for time stamp For each record w For the system to generate date and or time stamp for each record click Yes If the date and or time stamp has been joined to the text file simply click No to proceed If the text file includes no date and or time stamp an error message is generated when you click No Convert Data 1 l xX AN Lookup 5Sample ExE gt Invalid data X Note The Convert Data button won t go away as long as there is more data another lookup file needs conversion At last the application window shows data records in the data file tab Database tab TE AF Database Manager l mi x File RF Link Configure Help i OQ GO w ot molt e z Connect Save As Print Add Edit Delete Find Sark Exit Database DATE ITEM NAME QTY TIME feos eb Coke hom J M5786 eoma 54 Wine RB 57 Ens sss Penci 8000 35758 20050407 fese Bock 77 2005007 fos Notebook feo 195786 fesan foose Charger aoo 115786 Penne mati aaea ee inann MAEFEE 414 4 1710 Records gt Com Properties a 24 Using RFDBManager 433 MHz 2 4 GHz User s Guide Refer to ATF You may click Help on the Menu Bar and select About ATF File s Properties to view the settings of the template file It reveals the relationship between the application template and the RF Database Manager In t
8. New Name Add Return character When selected it will add Return character to each record Add Line Feed character When selected it will add Line Feed character to each record Character replacement When selected it will perform character replacement as specified ASCII Original value gt New value Chapter 2 The RFDBManager Interface 13 Add Date amp Time stamp When selected it will add system date and or time stamp to each record Click gt gt to open system date and time settings RF Reading Toolbar This RF Reading Toolbar appears after configuring the RF Reading setting Button To Do Setting To re define the RF Reading setting Stop Start To stop start the recording of the received data RF Reading Tab This RF Reading Tab appears after configuring the RF Reading setting RF Reading Receive 0 records X Note The Save As and Print commands are not accessible 14 Using RFDBManager 433 MHz 2 4 GHz User s Guide Editing Toolbar After executing one of these commands to create a database you can use the Editing Toolbar to manage the received data manually Convert Data Open Database Data Link Button To Do Add To add a record to the database Edit To edit the data of the selected record Delete To delete the selected record Find To search the database according to the specified key field Sort To sort the records based on the specified key field by ascending
9. RF Database Manager program 2 The version and copyright information pops up Click OK to proceed Jin Database Manager X CipherLab s RF Database Manager ver 1 23 00 Copyright c 2004 Syntech Information Co Ltd 3 The application window pops up 20 Using RFDBManager 433 MHz 2 4 GHz User s Guide General Application Window In this stage available functions are accessible in the Main Toolbar For the same function you may click the drop down menu from the Menu Bar as well Start with Open ATF on page 20 Click File and choose Open ATF to open the application template file Start with Open Database on page 45 Click File and choose Open Database to open the previously created database Click Connect to open the COM port Click Exit to end the program Note The application template file ATF has to be defined properly with the Application Generator before you can make use of it with the RF Database Manager TE RF Database Manager E loj xj File RF Link Configure Help iy E File k Connect Exit co M Properties 5 Start with n Open ATF Click Open ATF to start with a new application template file kA Connect Exit E Database Chapter 3 Demonstration 21 2 The following window pops up for specifying file path When the file is located click 3 Open Look irr C3 4G S amples x Fi Ed RF Read ATF RF read sample
10. RFDBManager 433 MHz 2 4 GHz User s Guide In the Connection tab select 1 Specify the source of data Use connection string and 3 provide other required information 4 Click Build to select data source E Data Link Properties Chapter 3 Demonstration 37 5 Inthe File Data Source tab click New to create new data source Select Data Source 7 x File Data Source Machine Data Source Look in DataSources DSN Name M e Select the file data source that describes the driver that you wish to connect to You can use any file data source that refers to an ODBC driver which is installed an Your machine Cancel Help 6 Select Microsoft Visual FoxPro Driver as the driver for your data source 7 Click Next Create New Data Source X Select a driver for which pon want to set up a data source m Microsoft FoxPro Driver dbf Micragaft FoxPro WFP Driver db Microsoft ODBC for Oracle Microsott Parados Driver db Microsott Parados Trelber db Microsoft Text Driver tek csv Microsoft Text Treiber tat csv Microsoft Visual FoxPro Driver Microsott Visual FoxPro Treiber cri srr Advanced i MS a ae Cancel d Tu 38 Using RFDBManager 433 MHz 2 4 GHz User s Guide 8 Specify new data source ODBC File Data Source DSN 9 Click Next Create New Data Source he m E x Type the name af the file data
11. found you ll find the triangular indicator gt points to it Otherwise you ll be prompted with the following message CT AN Data not Found Sort records 1 Ifyou need to sort information on a long list click Sort 2 The dialog box contains several key fields as many as one record contains and the sort methods Ascending or Descending for specifying your requirements 3 Click Start ieee Sort X Cancel Start Ascending C Descending 56 Using RFDBManager 433 MHz 2 4 GHz User s Guide 4 Examples Sorting by Item Ascending DATE ITEM 4 CATEGORY QTY TIME DSTI Book Goey 7 12048 Grocery 20000 12048 Charger Grocery 900 11208 Cigarete Grocery 4000 12048 Coke Grocery 143301 Editarecord Exemple i T H i 005 04 1 005 04 1 005 04 1 005 04 1 005 04 1 005 04 1 andy Tae Grocery 80 12048 005 04 17 Grocery e000 112048 005 04 11 Scanner Grocery 10000 11 20 49 11 20 LL 1I L Ll tl USDAT Sotarn Grocery 30 102048 amma Wine J Grocery 800 1312048 Sorting by Quantity Descending ITEM CATEGORY T Tr TIME DO5JOA Candy Gocey 20000 11 2043 ODD Scanner DEDE ODD Cigaret DEDE DEDE 005 0471 o n 005 04 11 Soft drink 00 005 04 17 DEAF 006 041 dit a record Example Po Boy Bo j Boy Bey hy j P3 he ee m Chapter 3 Demo
12. itself to real time data exchange by updating and or editing database on the host computer Working with the CipherLAB RF data collection terminals it can easily create or link to a back end database according to the pre defined properties of lookup file s Sparing your time from the tedious work of writing codes the RFDBManager gets your data linked to a number of legacy OLE database easily Note The properties of lookup file s must be defined through the RF Application Generator in advance In This Chapter TOW GWOT cocina 2 Typographical Conventions occocccccnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnininininos 3 Revision History cccccccccnncnnnnnnnnnnnnnnnnnnnnnonnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnss 3 2 Using RFDBManager 433 MHz 2 4 GHz User s Guide How it works Options of RF specifications include 433 MHz and 2 4 GHz depending on your application requirements MERITI Lm Base Station RF Database Manager Introduction 3 Typographical Conventions Before you start using this guide it is important to understand the terms and typographical conventions used in the documentation The following kinds of formatting in the text identify special information Formatting convention Numbers 1 2 3 Special Bold Emphasis CAPITALS KEY KEY Type of Information Step by step procedures You can follow these instructions to complete a specific task Items you must select such as menu
13. options command buttons or items in a list Use to emphasize the importance of a point or for variable expressions such as parameters Names of keys on the keyboard for example SHIFT CTRL or ALT Key combinations for which the user must press and hold down one key and then press another for example CTRL P or ALT F4 Revision History Version 1 23 01 Release Date April 22 2005 Notes Initial release CHAPTER 2 The RFDBManager Interface This chapter describes the main window and interface elements you need to get familiar with before getting started In This Chapter What M Ido A A 6 IVINS DU 13 AL oi doses o test date Pte ATE eo foe 7 MaM A a aa a aa 10 RFE Reading DIO TUS 12 Editing TODA edic EPA ee ee oat eus 14 Device Baba A 14 Database Ta coisa E O diia 16 SMS Bat ees rubet Ae NE AL a CaL M pecan N 17 6 Using RFDBManager 433 MHz 2 4 GHz User s Guide Main Window The RFDBManager s main window has menus and toolbars on the top and the rest of the window displays available database and or RF reading section 18 x TERF Database Manager File RFLink Configure Help ja S Disconnec Save 4s Print t Add Stop Exit E 2 Toolbars x n Editing Toolbar RF Reading ll Toolbar Database if RF Reading el 3 Data File Tabs o DATE ITEM NAME TIME Sample 2 2005 04 12 9950 Coke 1000 10 45 52
14. txt Save Int E Desktop dm a Gr ES My Documents 3 My Computer My Network Places File name AA e Cancel Save as type HTML htm html HTML htm html K Page A ange Text txt Unicode HTML LI TF 8 htm htral fe Al Unicode Text tst C Pages from to Index A Access Database 27 Add a record 53 B Base Station s ID 50 Base Station s Properties 51 C Configuration 9 48 Configure Menu 9 Convert Data 22 D Data Link 26 Database Tab 16 Delete a record 55 Demonstration 19 Device Bar 14 E Edit a record 54 Editing 53 Editing Toolbar 14 Execute Program 19 F File Menu 7 Find a record 55 FoxPro Database 36 G General Application Window 20 H Help Menu 9 How it works 2 Introduction 1 63 Main Toolbar 10 Main Window 6 Map Lookup File 44 Menu Bar 7 P Preview 62 Print 60 R Refer to ATF 24 Revision History 3 RF Link Menu 8 RF Reading Dialogue 12 RF Reading Tab 13 RF Reading Toolbar 13 RF System 49 S Save As 58 Set up Connection 46 Sort records 56 SQL Server 42 Start with Open ATF 21 Start with Open Database 46 status Bar 17 T Terminal 52 The RFDBManager Interface 5 Typographical Conventions 3
15. x File Data Source Machine Data Source Look ir DataSources DSN Name M e Select the file data source that describes the driver that you wish to connect to You can use any file data source that refers to an ODBC driver which is installed an Your machine Cancel Help 6 Select Microsoft Access Driver mdb as the driver for your data source 7 Click Next Create New Data Source X Select a driver Far which pon want to set up a data source Client Access ODBC Driver 32 bit Driver da Microsoft para arquivos texto Est csv Driver do Micrasaft Access mdb Driver do Microsoft dBase dbf Driver do Microsoft Excell xls Driver do Microsoft Paradox db Driver para o Microsoft Visual FoxPro iSeries Access ODBC Driver Microsoft Access Driver mdb hdieracnft Arras Treiber rad Ev 4 Advanced Back Cancel Chapter 3 Demonstration 8 Specify the name of the file data source ODBC File Data Source DSN 9 Click Next Create New Data Source i X Type the name af the file data source you want ta save this connection to Or find the location to save to by clicking Browse sample Browse Create New Data Source When you click Finish pou will create the data source which pon have just configured The driver may prompt you for mare information File Data Source Filename sample Driver Microsoft Acces
16. E DB Provider Microsoft I5 amp M 1 1 OLE DB Provider Microgott Jet 4 0 OLE DB Provider Micrasaft OLE DB Provider for Indexing Service Microsoft OLE DB Provider for Internet Publishing Microsoft OLE DB Provider for ODBC Drivers Microsoft OLE DB Provider for OLAF Services Microsoft OLE DB Provider for Oracle Microsoft OLE DB Provider for SQL Server Microsoft OLE DB Simple Provider MSD ataS hape OLE DB Provider for Microsoft Directory Services Next gt gt OF Cancel Help 26 Using RFDBManager 433 MHz 2 4 GHz User s Guide Access Database Microsoft Jet 4 0 OLE DB Provider 1 Inthe Provider tab select Microsoft Jet 4 0 OLE DB Provider 2 Click Next 77 E Data Link Properties E a x Provider Connection Advanced All Select the data wou want to connect to OLE OB Providerls IBM DB UDB far Senes OLE DB Provider Microsoft ISAM 1 1 OLE DB Provider Microsoft Jet 4 0 OLE DB Provider Microsoft OLE DB Provider Far Indexing Service Microsoft OLE DB Provider for Internet Publishing Microsoft OLE DB Provider for ODBC Drivers Microsoft OLE DB Provider for OLAF Services Microsoft OLE DB Provider for Oracle Microsoft OLE DB Provider for SQL Server Microgott OLE DB Simple Provider MSD ataS hape OLE DB Provider for Microsoft Directory Services OF Cancel Help Chapter 3 Demonstration 27 3 Inthe Connection tab specify the name of target database Microsoft Access Da
17. TTE TETTE TETTE USD Book Grocery 77 11204 USD Notebook Grocery 0 112048 DOBJOAPIT Charger Gay 00 12045 DEDE 2005 04 Edit a record Click on any part of a record so that the triangular indicator d points to the record Click Edit The dialog box contains fields of a record for editing bb N When input is completed click Update DATE 2005 04 11 ITEH Edit E record CATEGORY Example a TY 1 TIME 14 42 31 Update Cancel 5 The edited field s of the original record will be updated with new input 54 Using RFDBManager 433 MHz 2 4 GHz User s Guide Delete a record Click on any part of a record so that the triangular indicator d points to the record Click Delete The dialog box contains fields of a record grayed out bb c N If this 1s the record you don t want simply click Delete Tu Delete X DATE 2005 04 11 ITEH Edit a record CATEGORY Example QTY 1 14 48 31 Cancel 5 The record will be deleted for good Find a record 1 Ifyou need to check on something on a long list click Find 2 The dialog box contains several key fields as many as one record contains and its data content for specifying your requirements Chapter 3 Demonstration 55 3 Click Previous records before the current item or Next records after the current item to start searching 3i Find X When a certain record is
18. User s Guid Using RFDBManager For 433 MHz 2 4 GHz RF Version 1 23 01 Copyright Notice Copyright O 2005 Syntech Information Company Limited All rights reserved The software contains proprietary information of Syntech Information Company it is provided under a license agreement containing restrictions on use and disclosure and is also protected by copyright law Reverse engineering of the software is prohibited Due to continued product development this information may change without notice The information and intellectual property contained herein is confidential between Syntech Information and the client and remains the exclusive property of Syntech Information If you find any problems in the documentation please report them to us in writing Syntech Information does not warrant that this document is error free No part of this publication may be reproduced stored in a retrieval system or transmitted in any form or by any means electronic mechanical photocopying recording or otherwise without the prior written permission of Syntech Information For product consultancy and technical support please contact your local sales representative Also you may visit our web site for more information The CipherLAB logo is a registered trademark of Syntech Information Co Ltd Syntech Information Company Website http www cipherlab com Contents Chapter 1 Introduction 1 Inl A OS PEO E ETE RE A E ETE E EN 2 Typosrap
19. abase file doesn t have as many fields as the lookup file does the following message will pop up Map Lookup File i X Sample 1 does not have enough Fields to complete the mapping For 1st lookup File E 44 Using RFDBManager 433 MHz 2 4 GHz User s Guide 3 When data is mapped correctly click OK Data link to back end database is set up successfully Wi RF Database Manager E i E ml x File RFLink Configure Help DATE ITEM gt 200570408 9950 0 andy oft drink 2005 04 08 9953 Igarette 2005 04 08 9954 Wine ndi ebook arger 2005 04 08 canner T ol wl ol olz Im 2 o iD rm Lu e m il 7 0 C 4 4 17 10 Records gt l COM Properties Chapter 3 Demonstration 45 Start with Open Database 1 Ifthe target database has been created earlier you may simply click Open Database a File Connect Open ATF Exit 2 The application window shows data records in the Database tab TE RF Database Manager d ml x File FRF Link Configure Help rd 1al Connect DATE ITEM NAME TIME Pe 2005 04 07 9950 1000 11 57 56 2005 04 07 9951 Candy 20000 11 57 56 2005 04 07 9952 Saft drink 300 11 57 56 2005 04 07 9953 Cigarette 4000 11 57 56 2005 04 07 9954 Wine J500 11 57 56 2005 04 07 9955 Pencil 6000 11 57 56 2005 04 07 9956 Book 777 11 57 56 2005 04 07 9957 Notebook 80 11 57 56 2005 04 07 9958 Ch
20. arger 900 11 57 56 44 4 1 10 Records n 4 cn M Properties d e Note Apply the same procedures for executing the Open RF Reading command Set up Connection 1 Click Connect to open the COM port Ed SW File Connect Exit 46 Using RFDBManager 433 MHz 2 4 GHz User s Guide 2 Ifthe COM port has not yet been configured the COM Port Properties setting box will pop up first Click OK after configuration E Com Port Properties COM port COM1 Baud rate 115200 Flow control Hone 3 The COM port properties will be shown on the Status Bar when it is opened COMI 115200 Hone e 4 If the master or standalone Base Station has not been physically connected to the computer via RS 232 cable and powered on the RF Link dialog box will pop up to remind you Click OK when physical connection is set up run A Base station is nok connected 5 The system will auto detect any connected Base Station and or terminal and display symbolic icons on the Device Bar File Disconnect y Base 10 01 OR File Disconnect Exit Chapter 3 Demonstration 4T Configuration To set up RF link between terminal s and the host computer properties of the target Base Station master or standalone must be configured properly to act as a media of transmissions and receptions Define Base Station s properties here and the information can be viewed later whe
21. dow so that you can enter additional information If an option is followed by it will display a window Otherwise the command is carried out immediately Vip Database Manager File RFLink Configure Help File Menu File RF Link Configure Help he ATF Open Database Close RF sample amp TF convert ata k Data Links Save As Print Preferences Exit Command To Do Open ATF Open an existing application template file that was created by the RF Application Generator ATF refers to Application Template File Open Database If the database has been successfully created earlier you can directly open RF Reading it without having to open the application template first When the previously opened template includes RF Reading only the command is Open RF Reading When it includes Database or Database RF reading the command is Open Database Close Close the current application template file ATF file name 8 Using RFDBManager 433 MHz 2 4 GHz User s Guide Convert Data Data Links Save As Print Preferences Exit RF Link Menu Convert the source text data of a lookup file to database file It allows up to three lookup files Make sure that all required lookup files have been converted to database completely If the date time stamps in the ATF have been defined a dialog box will prompt to confirm whether the system is to generate the date time stamp for th
22. e d 3 Base Station s ID Discanneck Base Station s Properties Save As For more information go to Configuration on page 47 in the Demonstration Chapter Command To Do Base Station s ID Configure the Base Station s ID Base Station s Properties Configure the Base Station s properties Help Menu File RF Link Configure Help E About ATF File s Properties About RF Database Manager Disconnect Save s Command To Do About ATF File s Properties Show properties of the application template file About RF Database Show information about the RF Database Manager program Manager 10 Using RFDBManager 433 MHz 2 4 GHz User s Guide Main Toolbar o E m ta da Save As Connect Disconnect The Main Toolbar gives you quick access to available commands in current stage of application This Button Does The Same As This File gt Open ATF File gt Open ATF File gt Open Database RF Reading File gt Open Database RF Reading Exit File gt Exit Convert Data File gt Convert Data Data Link File gt Data Link Save As File gt Save As Print File gt Print Connect RF Link gt Connect Disconnect RF Link gt Disconnect e Chapter 2 The RFDBManager Interface 11 Note The Convert Data button won t go away as long as there is more data another lookup file needs conversion 1 Start with Open ATF 1 1 f al File Connect Exil Open Database
23. e records automatically It supports a variety of database types Configure the Data Link properties and link to any legacy back end database Save the current database to a new file either in database format mdb or in text format txt Print out data from the current database Configure custom settings for security concerns and others Close the RF Database Manager program SRF Database Manager Disconnect a i ann Properties File RF Help E E The RF terminal s must connect to the host computer through the Base Station master or standalone After a careful site survey you may decide to have a number of base stations to form your RF network In this case the base station directly being connected to the host computer 1s called Master the others are Slave Command Connect Disconnect Properties To Do Enable the RS 232 connection between PC and the Base Station so that the terminal s can be connected Disable the RS 232 connection between PC and the Base Station so that the terminal s are disconnected Configure the COM port settings for the connection between the PC and the Base Station Default settings COM 1 115200 bps no flow control Note The number of the symbolic icons on the Device Bar reveals how many devices are currently connected Chapter 2 The RFDBManager Interface 9 Configure Menu Ti RF Database Manager File RF Link Configur
24. he Application Generator s template In the RF Database Manager Ist lookup file Convert Data gt data sheet 1 2nd lookup file Convert Data gt data sheet 2 3rd lookup file Convert Data gt data sheet 3 SD Note The ATF s properties cannot be changed here ES ATE s Properties X ATF s Properties File name HF sample ATF Version 63xxA F100 Form s Properties Lookup s Properties Mame femi y Esc Main menu Lookup file Tst lookup file Font large Next form 1 No match action insert amp show warning Line Data type Prompt Input source Min length Max length Lookup Properties extension aaa s mr me Data Link Chapter 3 Demonstration 25 Click Data Link for link to a custom database The Data Link Properties box pops up for configuration In the Provider tab select your OLE DB provider See the following sections for details For example a number of connection options for three major database types are available Access Database on page 26 FoxPro Database on page 35 SOL Server on page 41 E Data Link Properties Provider Connection Advanced All Microsoft Jet 3 51 OLE DB Provider Microsoft Jet 4 0 OLE DB Provider Microsoft OLE DB Provider for ODBC Drivers Microsoft OLE DB Provider for ODBC Drivers Microsoft OLE DB Provider for SQL Server Select the data wou want to connect to OLE DB Providerls IBM DEUDE for Senes OL
25. hical C OnvetiblODSu su eres E R AA EEEE R EAA E E AA D ECL DE 3 Revision altiroa A O On E E 3 Chapter 2 The RFDBManager Interface 5 MATE WV TIO Weed ee sah oso a saat c E 6 AAA PP IM DE LU DCN D IL d ee eet E D 7 A A Ea Don eees 7 RE BT eh ioni pm coL E 8 Con eure Menim T 9 A E E A N ET AAA E E E 9 Mi Toolbar sermien aE E A MR E ee 10 RF Radins O adas 12 IRE ReaG iti Tona Rc 13 Ier Teeadino MAD ooh ais whedon tss E cesi pet O OE petu Lot EA 13 Edim Tobi D D TH 14 TS ACC Baltic ota 14 TAA DAS Cay eiii 16 Status Dat PTT 17 Chapter 3 Demonstration 19 Execute PO Ot Ai cack ML E A A A 19 General Application Wii OW p c A EEEE A A NE A A A AEA a 20 Start with Open ATE aiaa a a a a A 20 COD ED an a ee E ee eee E 22 Dad cece CR en O PE en ue E oer 25 Star With Open Database dodo ee ee ee iN e ie ee 45 A edocet nee Ten eet O PI 45 Co aT E24 INTIMIS LN PO e O EN 47 ed EE A MM A A o 48 o Pc eee 49 Base Sanon Ss Propertio Soest pe rS pen teu rv NEA 50 O NU ERNST PO 51 O o PN 52 P vo EC COLG ME EH 52 E diba T6 C18 A AAA AA tantu Red RC TL ee 53 Delete a Te COTA aot a eap GIN NUI M Gehe E fat a EUN ERES 54 A abel tire ROO M te fate ene eee we 54 SOTECO AAA 55 O 57 P MANN ae O NP MORE TANTI MERE RTT 59 Index Contents 63 CHAPTER 1 Introduction The RF Database Manager software lends
26. n you click on the Base Station s icon on the Device Bar Ti RF Database Manager File RF Link Configure Dd E Base Station s ID Base Station s Properties Disconnect Save As 48 Using RFDBManager 433 MHz 2 4 GHz User s Guide RF System 433 MHz RF System One 433 MHz RF system can support up to 45 terminals and 16 base stations To support all 45 terminals the 433 MHz RF base stations have to be configured into 3 groups Base Station s ID Base IDs 433 MHz 01 16 on page 49 Terminal on page 51 Terminal IDs 433 MHz 01 45 3 groups Base Station s Properties Group 1 Base Stations support terminals 01 15 on page 50 Group 2 Base Stations support terminals 16 30 Group 3 Base Stations support terminals 31 45 24 GHz RF System One 2 4 GHz RF system can support up to 99 terminals and 16 base stations Base Station s ID Base IDs 2 4 GHz 01 16 on page 49 Terminal on page 51 Terminal IDs 2 4 GHz 01 99 Chapter 3 Demonstration 49 Base Station s ID Each Base Station and terminal in the same RF system should have a unique ID for identification purpose Qi Base Station s ID X Current ID 1 Mew ID 1 E Cancel Option Function Current ID Click on the drop down menu to select Base Station by ID number New ID Assign a new ID to the selected Base Station 50 Using RFDBManager 433 MHz 2 4 GHz User s Guide Base Station s Pr
27. nstration 57 Save As In the database tab the received data can be saved in two different file formats Access mdb Text File txt 1 Click Save As Save As o E Save In Co HF Database Manager d t My Recent Documents My Computer File name XM Save as type Places Cancel yi es MOB Text Files FT 58 Using RFDBManager 433 MHz 2 4 GHz User s Guide 2 Ifyou open a database by using Data Link you ll have to configure its field properties before saving it as a text file txt Ti cave As Sample TXT de Left aligned padded with space oi 3 Select an appropriate file format and enter the file name 4 Click Save Chapter 3 Demonstration 59 Print Print Properties In the database tab you can print out the received data Before you print you may configure the layout settings to meet your needs Report Title Person Field mm Width 20 28 Height 6 08 Space mm Field Line Hargin mm Top Bottom Hight Option Description Report Title of the printout optional Person who produced the printout optional Space Field space between fields in millimeter Line space between lines or records 1n millimeter Field Width of each field in millimeter Height of each field in millimeter 60 Using RFDBManager 433 MHz 2 4 GHz User s Guide
28. onnection 17 Click OK when initial connection is set up successfully E Data Link Properties d xj Provider Connection Advanced All Specify the following to connect to ODBC data 1 Specity the source of data C Use data source name Hefresh Use connection string Connechon string DBG C D acuments and Setlingsscarne sDres Enter information to lag on to the server User name Password Blank password Allow saving password 3 Enter the initial catalog to use x Test Connection OF Cancel Help 18 Go to Map Lookup File on page 43 FoxPro Database 1 Inthe Provider tab select Microsoft OLE DB Provider for ODBC Drivers 2 Click Next gt gt Chapter 3 Demonstration EB Data Link Properties p X Frovider Connection Advanced All Select the data wou want to connect to OLE OB Providerls IBM DEUDE for Senes OLE DB Provider Microsoft ISAM 1 1 OLE OB Provider Micrasaft Jet 4 0 OL DB Provider Micrasaft OLE DB Provider for Indexing Service Microsoft OLE DB Provider for Internet Publishing Microsoft OLE DB Provider for ODBC Drivers Microsoft OLE DB Provider for OLAF Services Microsoft OLE DB Provider for Oracle Microsoft OLE DB Provider for SQL Server Microsoft OLE DB Simple Provider MSD ataS hape OLE DB Provider for Microsoft Directory Services Next gt gt OF Cancel Help 35 36 Using
29. operties The RF terminals must communicate with the host computer through at least one RF base stations Options of RF specifications include 433 MHz RF 2 4 GHz RF The connection between the host computer and the standalone or master Base Station is RS 232 while the connection between every two base stations is RS 485 Up to 16 base stations can be connected together in one RF system If two or more base stations are connected together the one directly connected to the host computer should be set to master mode and the others to slave mode Qi Base Station s Properties Link Terminal s ID Po Channel Group The information is revealed only when you click the Base station s icon on the Device Bar Power Time out Mode Master Baud rate 115200 Option Function ID Click on the drop down menu to select Base Station by ID number Channel 4 for 433 MHz RF Assign a channel to the Base Station 2 6 for 2 4 GHz RF Group NE 433 MHz RF assign group ID 1 3 to the Base Station 2 4 GHz RF all belong to group 1 by default Terminal Chapter 3 Demonstration 51 Power Power level 1 5 433 MHz RF set the RF output power to the 1 10 dbm Base Station ous dba 2 4 GHz RF all set to power level 1 by default max 100mW 3 4 dbm 4 0 dbm 5 5 dbm Time out 99 seconds Set the duration of re try for sending data Mode Standalone Set the operation mode to the Base Station
30. or descending Device Bar Terminal 10 01 The icons on the Device Bar quickly inform you how many devices are currently connected Move your cursor near to a symbolic icon and the information of its identification number will appear Button To Do Base Station To view Base Station s properties and the terminal s connected to it This button does almost the same as Configure gt Base Station s Properties except for the information on linked terminal s ID Terminal Simply show the terminal ID when moving your cursor closer to the icon No further information by clicking Chapter 2 The RFDBManager Interface 15 Click the Base Station s icon and it will also list all the terminal s currently being linked to it Ai Base Station s Properties araup 1 Power 1 16 Using RFDBManager 433 MHz 2 4 GHz User s Guide Database Tab The Database Tab lists up to three data sheets You may click on any record and then click the editing tools to edit it On the right pane ofthe database window you ll find the triangular indicator d points toward the current entry of record You may click on any other entry to move the indicator and then proceed to edit the record On the bottom of the database content is a horizontal scroll bar You may use the right left scroll arrows and to scroll through the list of records Database DS RF Reading Coke 2005 04 04 Candy 2005 04 04 Soft drink
31. rify connection 18 Click OK when initial connection is set up successfully E Data Link Properties m x Provider Connection Advanced All Specify the following to connect to ODBC data 1 Specity the source of data C Use data source name Hefresh Use connection string Connechon string DBG C D acuments and Setlingsscarne sDres Enter information to lag on to the server User name Password Blank password Allow saving password 3 Enter the initial catalog to use x Test Connection OF Cancel Help Chapter 3 Demonstration 41 SQL Server 1 Inthe Provider tab select Microsoft OLE DB Provider for SQL Server 2 Click Next gt gt EB Data Link Properties p X Frovider Connection Advanced All Select the data wou want to connect to OLE OB Providerls IBM DB UDB far Senes OLE DB Provider Microsoft ISAM 1 1 OLE DB Provider Microsoft Jet 4 0 OLE DB Provider Microsoft OLE DB Provider for Indexing Service Microsoft OLE DB Provider for Internet Publishing Microsoft OLE DB Provider for ODBC Drivers Microsoft OLE DB Provider for OLAF Services Microsoft OLE DB Provider for Oracle Micrasaft OLE DB Provider for SQL Server Microsoft OLE DB Simple Provider MSD ataS hape OLE DB Provider for Microsoft Directory Services OF Cancel Help 42 Using RFDBManager 433 MHz 2 4 GHz User s Guide 3 Inthe Connection tab pro
32. s Driver mdb ie Back Cancel 31 32 Using RFDBManager 433 MHz 2 4 GHz User s Guide 11 In the ODBC Microsoft Access Setup dialog box click Select to select a database ODBC Microsoft Access Setup Wate Source P ame Description opten Database 12 Specify the database you want to connect to and then click OK Select Database sample MDB sample MOE e gt Documents and 5 carie 23 Desktop Help File Toolb uer RFOB drw Access Databases rm 7 Chapter 3 Demonstration 33 13 Click OK in the ODBC Microsoft Access Setup dialog box ODBC Microsoft Access Setup E Data Source Mame OF Descriptor Cancel Database Database LA cameDesktopsample MDE Help Create Repair Compact Sistem Database 443 Advanced Mane C Database System Databaze Options gt 14 Click OK when the file data source is correct Select Data Source ES 7 x File Data Source Machine Data Source Look in DataSources sample dsn DSH Mame sample Mew Select the file data source that describes the driver that you wish to connect to You can use any file data source that refers to an ODBC diver which is installed an Your machine OF Cancel Help 34 Using RFDBManager 433 MHz 2 4 GHz User s Guide 15 Again click OK in the ODBC Microsoft Access Setup dialog box 16 Click Test Connection to verify c
33. source you want ta save this connection to Or Find the location ta save to by clicking Browse FoxPro sample Browse Back Nee n Cancel 10 Click Finish when the configuration of database is completed Create New Data Source When you click Finish pau will create the data source which vau have just configured The driver may prompt you hor more information File Data Source Filename FoxPro sample Driver Microsoft Visual FoxPro Driver E Back Cancel Chapter 3 Demonstration 39 11 In the Configure Connection dialog box select Free Table directory 12 Specify the database you want to connect to 13 Click OK Configure Connection X p Database type C Visual FoxPro database D BE Free Table directory Path EE Browse 14 Click OK when the data source is created Create Data Source 15 Click OK when the file data source is correct Select Data Source File Data Source Machine Data Source Look in DataSources M FoxPro sample d n DSH Name FoxPro sample Mew Select the file data source that describes the driver that you wish ta connect to Y ou can use any file data source that refers to an ODBC diver which is installed an your machine Cancel Help 40 Using RFDBManager 433 MHz 2 4 GHz User s Guide 16 Again click OK in the Configure Connection dialog box 17 Click Test Connection to ve
34. tabase mdb and provide other required information Click Test Connection to verify connection ESSIATITUE LI SD Note Apply the same procedures for Microsoft Jet 3 51 OLE DB Provider 28 Using RFDBManager 433 MHz 2 4 GHz User s Guide Microsoft OLE DB Provider for ODBC Drivers 1 Inthe Provider tab select Microsoft OLE DB Provider for ODBC Drivers 2 Click Next gt gt ES Data Link Properties P E xj Provider Connection Advanced All Select the data wou want to connect to OLE DB Providerls IBM DB2 UDB for Senes OLE DB Provider Microsoft ISAM 1 1 OLE DB Provider Micrasaft Jet 4 0 OLE DB Provider Microgott OLE DB Provider Far Indexing Service Microsoft OLE DB Provider for Internet Publishing Microsoft OLE DB Provider for ODBC Drivers Microsoft OLE DB Provider for OLAF Services Microsoft OLE DB Provider for Oracle Microsoft OLE DB Provider for SQL Server Microsoft OLE DB Simple Provider MSD ataS hape OLE DB Provider for Microsoft Directory Services Next gt gt OF Cancel Help Chapter 3 Demonstration 29 In the Connection tab select 1 Specify the source of data Use connection string and 3 provide other required information 4 Click Build to select data source E Data Link Properties 30 Using RFDBManager 433 MHz 2 4 GHz User s Guide 5 Inthe File Data Source tab click New to create new data source Select Data Source F
35. vide required information 1 Select or enter a server name 2 Enter information to log on to the server 3 Select the database on the server Click Test Connection to verify connection 5 Click OK when initial connection is set up successfully ES Data Link Properties Ix Provider Connection Advanced All Specify the following to connect to SOL Server data 1 Select ar enter a server name mj Refresh 2 Enter information to lag on to the server C Use Windows NT Integrated security Use a specific user name and password User name Password Blank password Allow saving password 3 Select the database on the server Attach a database file as a database name p Using the tlename x Test Cannectian Cancel Help Chapter 3 Demonstration 43 Map Lookup File 1 When being connected to database make sure the mapping between the database and lookup file is correct The table i e Sample 1 of database is mapped to the lookup file specified in the application template ATF The database fields are automatically mapped to the data fields of the lookup file TE map Lookup File xX Lookup 1st lookup file Table Sample 1 Prompt Data type Mapping field Data type NAME tet CATEGORY advarWChar QTY iege PALLET j aWawthe TIME timos y RECI Cancel 2 If your dat
Download Pdf Manuals
Related Search