Home

User Manual

1. Column name Range value Length Meaning id 1to 11 Id 42 147 483 647 Unique record number assigned by system employee 1to 12 bytes 12 Employee ID Employee ID number login id 1to 8 bytes 8 Login Name Operator UNIX login name terminal 1to 11 Terminal 2 147 483 647 Terminal ID number xact_type 1to9 15 Transaction type 1 Login 2 Logout 3 Update 4 Delete 5 Query 6 Command Event 7 Status Request 8 Shutdown 9 Insert table_id 1 to 100 11 Table Table number affected record_desc 1to 60 bytes 60 Record Description Description column of affected record field_id 1to 1T Field 2 147 483 647 Column number affected starting with column 0 value 1to 60 bytes 60 Value New value opr activity date gt 19000101 11 Date Transaction date in the form yyyymmdd Time zone context of operator opr activity time 0 to 235959 11 Time Transaction time in the form hhmmss Time zone context of operator host activity date gt 19000101 11 Host Activity Date Form yyyymmdd in the time zone context of host host activity time O to 235959 11 Host Activity Time Form hhmmss in the time zone context of host utc activity date 19000101 11 UTC Activity Date Form yyyymmdd in UTC GMT time utc activity time 0 to 235959 11 UTC Activity Time Form hhmmss in UTC GMT time facility 1to 11 Facility 2 147 483 647 Foreign key to id field in facility table Record number of the facility this record is in
2. Person user Table 21 Person user COL Column name Range value Length Meaning 1 id 1to 11 Id 2 147 483 647 Unique record number assigned by system except when using transaction type 35 2 description 1to 60 bytes 60 Description User field description value 3 person_id 1to maximum 11 Person Id record number Foreign key to id field in person table Record number of the person the in person table user field is in 4 slot number 1to 40 11 Slot Number Slot number the user field is assigned to the user field number 5 facility 1to 11 Facility 2 147 483 647 Foreign key to id field in facility table Record number of the facility this record is in 6 modify date gt 19700101 11 Modify Date Modification date in the form yyyymmdd System will supply the current date if no date is provided 7 modify time Oto 235959 11 Modify Time Modification time in the form hhmmss System will supply the current time if no time is provided 73 74 Picture Perfect Import Export User Manual Person category Table 22 Person category COL Column name Range value Length Meaning 1 id 1to 11 Id 2 147 483 647 Unique record number assigned by system except when using transaction type 35 2 person_id 1tomaximum 11 Person Id record number Foreign key to id field in person table Record number of the person the in person table category is in 3 category_id 1tomaximum 11 Category Id record number Foreign k
3. e filename for appending Check the name and permissions of the error file designated in the header or on the command line Error opening error file filename for writing Check the name and permissions of the error file designated in the header or on the command line Error opening import file The filename specified does not exist or cannot be opened Error opening output file The filename specified does not exist or can not be opened Check the name and permissions of the filename Error opening output file filename for appending Check the permissions of the filename Error opening output file filename for writing Check the permissions of the filename 49 50 Picture Perfect Import Export User Manual Table 10 Communication failure error messages Error message Description Error you may not insert or update a category department or permission_group table from a subhost in a network The network host is the only place you may insert or update one of the above listed tables if your system is configured as an enterprise version of Picture Perfect Field required for import The column identified requires data and it does not contain any Field value is too big The value exceeds the limit of the field Header error error file name is required The header record must contain an error file name Header
4. 0 Do not care 1 Single 2 Double 27 apb_duration 1 to 2 147 11 Timed APB Duration 483 647 Value represents number of seconds for timed APB 28 door_lock 0 1 2 6 Door state 0 Do not care 1 Unlocked 2 Locked Table 24 Area_event COL Column name Range value Length Meaning 29 open_too_long 0 1 2 6 Held Open Sensing 0 Do not care 1 Detected 2 Ignored 30 forced open 0 1 2 6 Forced Open Monitoring 0 Do not care 1 Detected 2 Ignored 31 too long routing 1to 2 147 11 Held Open Routing 483 647 Foreign key to id field in routing table Record number for the type of routing to do for door held open alarm 32 forced routing 1to 2 147 11 Forced Open Routing 483 647 Foreign key to id field in routing table Record number for the type of routing to do for door forced open alarm 33 two man rule Oto 4 6 2MR Control Flag 0 Do not care 1 Disabled 2 Standard 3 Modified Door Control 4 Modified No Door Control 34 facility 1to 11 Facility 2 147 483 647 Foreign key to id field in facility table Record number of the facility this record is in 35 modify_date gt 19700101 11 Modification date in the form yyyymmdd System will supply the current date if no date is provided 36 modify_time 0 to 235959 11 Modification time in the form hhmmss System will supply the current time if no time is provided 37 68 category1 1to 11 Foreign keys to id s in category table There are up to 32 categor
5. 0 Do not care 1 Disabled 2 Standard 3 Modified Door Control 4 Modified No Door Control 27 occupancy_ctrl Oto2 6 Occupancy Control 0 Do not care 1 Disabled 2 Enabled 28 facility 1to 11 Facility 2 147 483 647 Foreign key to id field in facility table Record number of the facility this record is in 29 modify date gt 19700101 11 Modify Date Modification date in the form yyyymmdd System will supply the current date if no date is provided 30 modify_time 0 to 235959 11 Modify Time Modification time in the form hhmmss System will supply the current time if no time is provided 31 category1 1to 11 Foreign keys to id s in category table There are up to 32 category 62 category32 2 147 483 647 fields on an area record Area_event Table 24 Area_event COL Column name 1 id Range value 1to 2 147 483 647 Length 11 Meaning Id Unique record number assigned by system except when using transaction type 35 description 1 to 60 bytes 60 Description Area event description mode_id 1to 2 147 483 647 11 Mode Foreign key to id field in modes table Record number of the mode this event is a part of time_of_day 0 to 235959 11 Time of Day Event time in the form hhmmss Time of day the event will run context 0 1 2 11 Context Time zone context 0 Host 1 Micro 2 Operator sunday 0 1 Sun Indicates if the event is to run on t
6. selectcol category An example of the output from the above command would be column name type 1 id integer 2 description char 31 3 permission grp integer 4 m2mr type integer 5 facility integer 6 modify date integer 7 modify time integer query Syntax query table name Description Displays all rows and all columns from table to the screen in an undelimited format Chapter 4 25 Exporting data Example query operator more An example of the output from the above command would be 1 Systems Administrator 0000 install 1 1 1 9e05e6832caffca519722b 608570b8ff4935b94d O 1 20041006 170806 1 System System system 1 1 1 0 1 20041018 194738 selectit Syntax selectit SELECT statement Description Displays results of the SQL Select Statement to the screen in undelimited format This command s output is similar to query except that the output is limited to those rows matching the selection criteria and those columns selected Note that the SELECT statement must be enclosed in matching single or double quotes or in order for the shell to interpret the statement as a single parameter Example selectit select id from badge where modify date gt 20020201 An example of the output from the above command would be 851 852 853 854 selectrpt Syntax Selectrpt SELECT statement Description Displays results of SQL Select Statement to the screen one column per line with column names follo
7. 16 bytes 16 Badge Encode Number 3 pin 1to 10 bytes 10 Pin Keypad personal ID number 4 employee 1to 12 bytes 12 Employee ID Employee number 5 first name 1to 40 bytes 40 First Name Badgeholder s first name 6 last name 1to 40 bytes 40 Last Name Badgeholder s last name 7 area 1tothe maximum record 11 Area number in the area table Foreign key to id field in area table Record number that the reader is in 8 category 1 to the maximum 11 Category record number in the Foreign key to id field in category table Category record category table number that granted access 9 xact type Oto 45 17 Transaction type 0 Open 1 Reader Unknown Micro 2 Reader Offline 3 Reader Type Unknown 4 Area Unknown to Micro 5 Area Offline 6 No Category Match 7 Invalid APB In 8 Invalid APB Out 9 Invalid PIN Entered 10 Unknown Badge 11 Lost Badge 12 Suspended Badge 13 Deleted Badge 14 Learn Timeout Table 14 Badge History export only COL Columnname Range value Length Meaning 15 Invalid T A In Attempt 16 Invalid T A Out 17 Invalid Shunt 18 Expired Badge 19 APB In 20 APB Out 21 T A In 22 T A Out 23 Passive APB In 24 Passive APB Out 25 Invalid Func Code 26 KP Resp Invalid Badge 27 KP Invalid Open Door 28 KP Resp Not Enabled 29 Not Validated 30 Degraded Open 31 Usa
8. 483 647 Foreign key refers to id field in facility table Record number of the facility this record is in Person Table 13 Person COL Column name Range value Length Meaning 1 id 1to 11 id 2 147 483 647 Unique record number assigned by system 2 pin 1to 10 bytes 10 Pin Keypad personal ID number 3 status 0 4 5 6 6 Status Badge status O Active 4 Lost 5 Suspended 6 Deleted 4 type 1to the number of 11 Type records in the Foreign key to id field in person_type table person_type table 5 person_kp_resp 1to the number of 11 Keypad Response records in the person Foreign key to id field in person table table 6 person trace 0 1 11 Card Trace Enable Person Trace O No 1 Yes 7 person trace alarm 0 1 12 Generate Alarm when Person Traced If Person Trace is enabled an alarm is generated every time the badge is read OzNo 1 Yes 8 employee 1 to12 bytes 12 Employee ID Employee number 9 department 1 to the number of 11 Department records in the Foreign Key id to department table with header byte 123 I department table 30 bytes for department description with header byte D 10 first_name 1 to 40 bytes 40 First Name Badgeholder s first name 11 last_name 1 to 40 bytes 40 Last Name Badgeholder s last name 12 initials 1to 6 bytes 6 Initials Badgeholder s initials 13 title 1 to 20 bytes 20 Title Badgeholder s title 14 address1 1 to 40 bytes 40 Address 1 15 address2 1 t
9. 888 437 3287 F 561 998 6224 E rs bctinfo ge com Asia T 852 2907 8108 F 852 2142 5063 Australia T 61 3 9259 4700 F 61 3 9259 4799 Europe T 32 2 725 11 20 F 32 2 721 86 13 Latin America T 305 593 4301 F 305 593 4300 www gesecurity com 2005 General Electric Company All Rights Reserved imagination at work
10. MSVC 4 X ONC RPC MS Windows 2000 MSVC 4 X ONC RPC Red Hat Linux 4 0 AS ES or WS GNU gcc RedHat Inc Red Hat Linux 3 0 AS ES or WS GNU gcc RedHat Inc IBM AIX 5L version 5 3 for RISC 6000 IBMC IBM AIX 5 3 IBM AIX 5L version 5 2 for RISC 6000 IBMC IBM AIX 5 3 MVS MVS MVS Sources for PC based TCP IP Software The companies listed below are suppliers of TCP IP development and runtime environments for DOS Windows environments Netmanage Inc 10725 North De Anza Boulevard Cupertino CA 95014 2030 Phone 408 973 7171 http www netmanage com Distinct Corporation 3315 Almaden Expressway Ste 10 San Jose CA 95118 Phone 408 445 3270 Copyright Martin F Gergeleit http www onc rpc xdr com 36 Picture Perfect Import Export User Manual The Import Export Interface RPC Toolkit The toolkit consists of seven C Language source files a header file and a make file The C source files when compiled and linked with the RPC libraries supplied by one of the above vendors create a demonstration client program called client This can be used as a boilerplate for developing the production version of the intended client application The toolkit is delivered in source code form rather than relocatable object form so the software can be run on a wide variety of machines and developed with a wide range of compilers linkers and libraries Although the standard RPC and XDR routines are 99 percent compatible ac
11. and link layers Verification is performed by passing a number to the Picture Perfect server which sends the number back to the client If the number received back from the server is the same as the number sent it can be assumed that the server is operational A useful by product of the verify call is the ability to set the server s level of debugging for the next operation After the next operation completes the server s debug level is automatically reset to 0 The debug level is determined by the modulus 10 ofthe least significant digit of the number sent to the server The maximum debugging levelis 9 Debug information is written to the current day s import log file located in the cas log directory The import log files are named imp mmdd where mm is the month and dd is the day of month The types of diagnostics associated with debug levels are shown below Table 7 Debug level diagnostics Debug level Result 0 No debugging information 1 Temporary file names of imported files are logged 2 3 Input output and error files are preserved 4 5 Additional file 1 0 diagnostics are logged 6 Each error file line is logged import only 7 Each output file line is logged import and export 8 Each received line is logged import and export 9 All possible diagnostics Note Debug levels are cumulative that is a level of 7 includes the capabilities of levels 1 through 6 Chapter 5 41 Remote Procedure Call Inter
12. cli import usr rpc cli export Qa Qa a Q usr rpc cli_create usr rpc imex_xdr c usr rpc makefile cli Table 9 Source code file types File type Description imex h This is a common header used by client and server It contains definitions of the data structures used for data transfer as well as ANSI prototypes for all functions used within the subsystem cli c This is a sample program whose source code is made available to the customer We provide a front end to each procedure which can be customized for the particular application imex xdr c This file contains all of the custom written XDR routines to handle data transfer These functions are common to client and server Although it is unlikely that any of these routines will need modification on the client machine they have been provided to aid in porting to new architectures 46 Picture Perfect Import Export User Manual Chapter 6 Troubleshooting and support This section provides information to help you diagnose and solve various problems that may arise while configuring or using your GE product and offers technical support contacts in case you need assistance In this chapter EI MERE asd and M t ed e vite pite e t o e ut 48 Contacting technical support 53 Picture Perfect Import Export User Manual Error Messages Error messages that you may encounter while using the Import Export program are explaine
13. content of the dept column 35 Insert new record s in any table Import records must include record ids 41 Insert new record s to table specified in the application header The id field must be blank and the description field must never be blank e If the table is the badge table the id field must be blank and the bid field must never be blank Logging of Operator History will be based on the login id field obtained from the contents of Application Header bytes 24 31 Picture Perfect operator login name 42 Update existing record s of table specified in the application header Ifthe table is not the badge table the id field must never be blank e Ifthe table isthe badge table either the id orthe bid must be included Logging of Operator History will be based on the 1ogin id field obtained from the contents of Application Header bytes 24 31 Picture Perfect operator login name Bytes 42 59 Picture Perfect Table Name 18 bytes Name of the Picture Perfect table to be modified by the import if the transaction code is 30 or 34 the table name must be badge Byte 60 Column Delimiter Character 1 byte The character usually the vertical bar that separates columns in the import records Byte 61 Record Delimiter Character 1 byte The character usually a new line that separates import records in the file Bytes 62 75 Output File Name 14 bytes The name of the file where importdb writes the import informational
14. log in to the Picture Perfect host to execute command line queries or run the importdb program manually In this chapter d r7 rM 34 How EEC WOR e du eI e teda soto ae 34 Software TEGUREMENIR u eee ua ee he eas e eee pere dee 35 The TER Program UE nn eich 37 Application Layer Services iia nn 38 A eee DUM 39 cir PME 40 ds A 42 e TURN M ba oa we 43 Running Concurrent Clients 44 0075 0 7 AA E E S T T T T T 45 Inventory of source code supplied with Import Export 45 34 Picture Perfect Import Export User Manual Overview The Remote Procedure Call RPC Interface provides remote hosts or workstations with real time access to the Picture Perfect database eliminating the need to log in to the Picture Perfect host to run the importdb program manually By compiling and linking the supplied routines with the client application import and export functions can be performed on the Picture Perfect host as though they were executing locally Three high level functions or services are supported e Verify existence of Picture Perfect database server e Import records into Picture Perfect database e Export records from Picture Perfect database When one of the above services is requested the results are almost immediately available in the form of a local data structure within the client s address space Delay time is generally proportional to the amount of data being exchanged and th
15. lost routing 1to 11 Lost Routing 2 147 483 647 Foreign key to id field in the routing table Record number of the type of routing to do for lost badge reads for an area 7 unk routing 1to 11 Unknown Routing 2 147 483 647 Foreign key to id field in the routing table Record number of the type of routing to do for unknown badge reads for an area 8 apb routing 1to 11 Antipassback Routing 2 147 483 647 Foreign key to id field in the routing table Record number of the type of routing to do for anti passback badge reads for an area 9 escort routing 1to 11 Escort Routing 2 147 483 647 Foreign key to id field in the routing table Record number of the type of routing to do for escort badge reads for an area 10 inv input group 1to 11 Invalid Grp 2 147 483 647 Foreign key to id field in input_group table Record number of the input group for an invalid badge alarm read for an area 11 susp input group 1to 11 Suspended Grp 2 147 483 647 Foreign key to id field in input_group table Record number of the input group for a suspended badge alarm read for an area 12 lost_input_group 1to 11 Lost Grp 2 147 483 647 Foreign key to id field in input_group table Record number of the input group for a lost badge alarm read for an area 13 unk_input_group 1to 11 Unknown Grp 2 147 483 647 Foreign key to id field in input_group table Record number of the input group for an unknown badge alarm read for an area 14 apb_input_group 1to 11 Antipassback Grp 2 1
16. manufacturers or vendors of the respective products Use this product only for the purpose it was designed for refer to the data sheet and user documentation For the latest product information contact your local supplier or visit us online at www gesecurity com Contents Chapter 1 Chapter 2 Chapter 3 db cs vi Pr face ep ee A E vii Conventions used in this document 22 vii Safety terms and symbols 2 vii Installing Import Export 2 ebd dq QUEE TR d AR ERR RR RA a wav ERR RR 1 Installation ee ne ale ee 2 Functional overvieW user 5 IMPOM boi sts E ae 6 Preparation for Import cision pement REA RA AQ ne anses 6 EXPO Dm 6 Preparation for Export 06 ssec senken u ste 6 Things to Think About ur er ee 7 Importing data A A A EOR 9 OVEFVIBW TET 10 The importdb Command see depend CHUEU RE het 10 OPIO ii 10 Examples of importdb command pe ci eh a RUE UR Ra dd 11 Database lrnsetts rore bere rre ev pr ELTE PER E Rr E Ex e te elite es ee tient 11 Database Updates ee Ba aa Bee 12 Table changes Picture Perfect versions 2 0 and 4 0 12 Import DataiFiles cocidas eme mp D pibe ea HR I ae Di a A elei 13 Header Tormats said ps a k ekaiak nd dd 13 Example of hedder ii AA ata 17 Examples Of Import Dataifiles so ccicciccnaanadianneninidaaadiwna
17. messages if a full path name is not provided the file will be written into cas export ifthe o option is used on the importdb command line this field is ignored Byte 76 Output File Append or Overwrite 1 byte A Append 16 Picture Perfect Import Export User Manual e Ifthe file doesn t exist create and write e If the file does exist add import informational messages to the end of the file N New e Any character other than A e Ifthe file doesn t exist create and write e If the file does exist overwrite and destroy any previous content Bytes 77 90 Error File Name 14 bytes The name of the file where importdb writes error messages generated during the attempted import function If a full path name is not provided the file will be written into cas export Ifthe e option is used on the importdb command line this field is ignored Byte 91 Error File Append or Overwrite 1 byte A Append e Ifthe file doesn t exist create and write e If the file does exist add error information to the end of the file N New e Any character other than A e If the file doesn t exist create and write e If the file does exist overwrite and destroy any previous content Bytes 92 106 Application Control Field 1 15 bytes User defined field content not used by importdb Bytes 107 121 Application Control Field 2 15 bytes User defined field content not used by importdb Byte 122 Reserved 1 byte Must be a space
18. populated first as well When populating the person table the format of the record being inserted MUST include the pipe delimiters at the end of the basic structure to accommodate the possibility of 40 user fields 96 categories and the 31 fields of a badge record even if there is no accompanying data for the person record The file sample imp inthe cas import directory specifies the format required to import a complete Person record with a category and badge An example follows Figure 6 Table Layout Example 1 221111111101 er field 40 PEPLEFDED Dz The above example shows a person record with the first User field 1 and fortieth User field 40 user field populated and the first 1 and ninety sixth 1 category field populated and no data in the badge portion of the record the last 31 fields The total number of fields for a person record is 203 If an update transaction type 31 Update existing records in any table with an operator activity transaction for each modification is being performed then the required extra employee number field will occur after the person record and before the required additional 40 user fields 96 categories and the 31 fields of a badge record An example follows Figure 7 Table Layout Example 2 Note Hiro p 111111 ser field 40 The above example shows the employee number 0004 inserted at the end of the person record data and just before the first person user field Use
19. table Record number of the type of routing to do for suspended badge reads for an area 18 lost routing 1to 11 Lost Routing 2 147 483 647 Foreign key to id field in the routing table Record number of the type of routing to do for lost badge reads for an area 19 unk routing 1to 11 Unknown Routing 2 147 483 647 Foreign key to id field in the routing table Record number of the type of routing to do for unknown badge reads for an area 20 apb routing 1to 11 Antipassback Routing 2 147 483 647 Foreign key to id field in the routing table Record number of the type of routing to do for anti passback badge reads for an area 21 escort routing 1to 11 Escort Routing 2 147 483 647 Foreign key to id field in the routing table Record number of the type of routing to do for escort badge reads for an area 22 reader online 0 1 2 6 Reader Online Indicates if the reader is to be put online or offline 0 Do not care 1 Online 2 Offline 23 phys_reader_type 0 1 2 4 8 6 Physical Reader Type 0 Do not care 1 Badge only 2 Badge and Keypad 4 Keypad only 8 Badge or Keypad 24 log_reader_type 0 16 32 128 6 Logical Reader Type 256 512 2048 0 Do not care 16 APB In 32 APB Out 128 TSA In Out 256 T amp A In 512 T amp A Out 2048 Normal 25 swipe_reader_type 0 1 2 6 Swipe and Show Reader Type 0 Do not care 1 Authorization Required 2 No Authorization Required 26 nbadge 0 1 2 0 Num of Badges Indicates if it is a single or a double badge transaction reader
20. tables as needed For example last name and first name data will be stored in the person table while category ids will be stored in the person category table The badge table in Picture Perfect 2 0 was split into the badge and person tables in Picture Perfect 4 0 So the person record MUST include placeholders for the 31 fields of a badge record The file sample imp inthe cas import directory specifies the format required to import a complete person record along with user fields categories and badge data Note You can only attach one badge record to a person record when using Import Export Example 1 Person record insert The example below shows a simple insert of a person record The first 36 slots are the person table data the next 40 slots are the user field data the next 96 slots are the category data and the last 31 slots are the badge data Make sure you have a total of 203 pipe delimiter symbols for each record to be imported Figure 1 Example of person record insert A0000000yourpphost install zen m out m err Ir 7334 Joe Smith JS DDN 20041215 181322 um gll Example 2 Person record update The example below shows an update of a person record The first 36 slots are the person table data the next slot is the employee number used for a transaction code type of 31 0004 in this case the next 40 slots are the user field data the next 96 slots are the category data and the last 31 slots are the badge data
21. the Picture Perfect platform using asynchronous or Local Area Network LAN communications This manual provides information for a knowledgeable SQL programmer to interface external programs to the Picture Perfect database It is not intended as a tutorial on SQL programming If you need additional information on SQL please contact your GE Customer Support Representative for a list of recommended sources Read these instructions and all ancillary documentation entirely before installing or operating this product The most current versions of this and related documentation may be found on our website Refer to Online publication library on page 53 for instructions on accessing our online publication library Note A qualified service person complying with all applicable codes should perform all required hardware installation Conventions used in this document The following conventions are used in this document Bold Menu items and buttons Italic Emphasis of an instruction or point special terms File names path names windows panes tabs fields variables and other GUI elements Titles of books and various documents Blue italic Electronic version Hyperlinks to cross references related topics and URL addresses Monospace Text that displays on the computer screen Programming or coding sequences Safety terms and symbols These terms may appear in this manual A CAUTION Cautions ident
22. the number of rows selected The bad component corresponds to the number of lines of error messages returned It is possible for both components to be non zero Linkedlist export r u list will always contain the selected rows followed by any error messages Like the import service the errnum and cause components should be inspected for file I O errors on the host The length of a returned row will not exceed 4096 characters If the RPC call fails completely a NULL pointer is returned 43 44 Picture Perfect Import Export User Manual Running Concurrent Clients The Picture Perfect server process importd handles incoming requests serially Therefore if a client s request takes a long time to execute another client can potentially time out waiting for the server to become available Server Configuration During installation the Picture Perfect host can be configured to start up multiple importd servers Each server is started up with a unique integer argument which the server uses to register itself with the portmapper The base program number for Picture Perfect RPC server is 540 000 000 If importd is invoked without arguments the base program number is registered The numeric value of the first argument is added to the base program number to yield the program number registered with the portmapper For example if the commands cas bin importd 0 cas bin importd 1 cas bin importd 2 cas bin importd 3 are executed on the P
23. using the ping command supplied with your TCP IP software If this is unsuccessful then either your network interface is not configured properly or you are experiencing some other network problem First check your client interface to verify that it is configured for the correct type of interface for instance Ethernet Token Ring and that it is using the correct Internet address If you are using a gateway or domain name service the gateway and or name servers may need to be updated with the Picture Perfect host address Contact your network administrator for assistance with this rpc error the remote program is not registered The specified host is not running the importd server To check this log on to the Picture Perfect host as root andtype ps e grep importd Verify it was correctly installed by typing the following cas bin profile query tps daemons You should see entries similar to the following 10 cas bin importd 0 tps RA 20030114 101507 11 cas bin importd 1 tps RA 20030114 101507 If these entries do not exist then there was an error during the impexp package installation and it should be removed and then re installed If the entries exist then possibly the process died Re start Picture Perfect and check again to see if the any ofthe importa server processes are running Also check the cas log log MMDD file to see if there is any explanation for the failure For further help call your GE Security technical
24. 0 ee ae Den ae ee ste ias 37 Application Layer Services 222 n ee ee u ent CRI 38 Troubleshooting vi ses n erre pere ee a oe eb ie tas 39 Communication Fl US zoe opto TR rte au ER 39 Application Related ErFOrs ci eus E P IE nahen nenn 40 V rily SEVICE sesioni er 244 o 40 Veny Prototype kst sena a er ados ec PETI 41 Verify DIAGNOSTICS 2 5 ee a DT RR EE RAAE aT 41 IMPOrE SERVICE 2a ee E nee ose ee eee 42 IMPOLTEIPFOTSWYPe PPP 42 IMPOLL DIAGNOSES par 42 Export Service nre sn Da ean en er alee a RAS 43 Export Prototy PE en ae hed starter E E rm 43 EXPOriDIGGMOSUCS etian oeei aa penile SHAG aed NON Va Ke C DR IURI A aod 43 Running Concurrent Clients 444444 hh hh hne 44 Server Configuration ibid E EE r onni raan AE unes 44 Client Contig ration 228s ss seele M AE ERE E RM 44 Uu mec 45 Inventory of source code supplied with Import Export 45 Chapter 6 Appendix A Troubleshooting and support 47 Error Messages seo nement den al UNDO ERG UC UE CE ER OM e 48 Contacting technical support 4444 44e 53 Online publication libraries sites each 53 TODOS near red nan Ni tante dt ad et er 55 Notes iii nr ken 56 Alarm History export only 00 c cece cece cece ence een ence nee e
25. 1 11 53 15 EST 2005 This package has no nls or help files to save IMPEXP INST Picture Perfect Installation Version 1 6 11 15 04 Copyright C 1990 2002 GE Security Loading Import Export Import Export Programmer Interface from media 2504 blocks The source files to the Programmer Interface have been installed in the directory usr rpc Import Export can be configured to run multiple copies of the importd server to improve RPC response time at sites using multiple clients For example if you will be using two remote badging systems and also intend to export data to a mainframe you can configure Import Export to run 3 copies of the server Refer to the Import Export Guide for client implementation How many instances of the server do you wish to configure Enter a number from 1 to 16 10 Enter the number of Import Export server copies you wish to run then press Starting the Informix database Done Adding record to terminal Adding 1 record to tps daemons Adding entry to services Starting the portmapper Shutting down the Informix database Done The IMPEXP INST installation has completed successfully Checking if need to update nls files Picture Perfect NLS Check 2 0 01 16 05 Copyright C 1997 2005 GE Security Tue Jan 21 11 15 59 EST 2005 No nls files for impexp package Running cas bin fixperm on tmp impexp perm file No errors detected cas bin fixperm finished Updati
26. 3 6 M2MR Personnel Type Modified Two Man Rule Personnel Type OzNone 1 Team Member 2 Guest 3 Escort Required facility 1to 11 Facility 2 147 483 647 Foreign key to id field in facility table Record number of the facility this record is in modify_date gt 19000101 11 Modify Date Modification date in the form yyyymmdd System will supply the current date if no date is provided modify_time Oto 235959 11 Modify Time Modification time in the form hhmmss System will supply the current time if no time is provided Facility Table 17 Facility Column name Range value Length Meaning id 1to 11 Id 2 147 483 647 Unique record number assigned by system except when using transaction type 35 description 1to 60 bytes 60 Description modify_date gt 19000101 11 Modify Date Modification date in the form yyyymmdd System will supply the current date if no date is provided modify time 0 to 235959 11 Modify Time Modification time in the form hhmmss System will supply the current time if no time is provided 70 Picture Perfect Import Export User Manual Department Table 18 Department Column name Range value Length Meaning id 1to 11 Record number Assigned by system except when using transaction type 35 2 147 483 647 description 1 to 60 bytes 60 Description division 1to 3 bytes 3 Division Customer s division number location 1to 20 bytes 20 Location Geographic location manager 1
27. 47 483 647 Foreign key to id field in input_group table Record number of the input group for an anti passback badge alarm read for an area 75 76 Picture Perfect Import Export User Manual Table 23 Area COL Column name Range value Length Meaning 15 duress input group 1 to 11 Duress Grp 2 147 483 647 Foreign key to id field in input_group table Record number of the input group for a duress badge alarm read for an area 16 escort input grp 1to 11 Escort Input Group 2 147 483 647 Foreign key to id field in input_group table Record number of the escort input group this area is a member of 17 permission group 1to 6 Foreign key to id field in permission group table Record number of 2 147 483 647 the permission group this area is a member of 18 logical_state 0 1 6 Logical State 0 Offline 1 Online 19 physical_state 0 2 6 Physical State O Disabled 2 Enabled 20 shunting 0 4 6 Shunting O Disabled 4 Enabled 21 scheduling 0 8 6 Scheduling O Disabled 8 Enabled 22 apb_enforcement 0 16 6 APB Enforcement 0 Normal 16 Passive 23 route_def 1to 11 Route Definition 2 147 483 647 Foreign key to id field in route_def table Record number of the route definition for Activity Monitor routing 24 m2mr_door_rel to Oto 32 767 6 M2MR Door Release Timeout 25 occupancy_count 1to 11 Occupancy Count 2 147 483 647 Number of occupants in the area 26 two_man_rule 0to4 6 Two Man Rule
28. Byte 123 Person Department Control 1 byte I Integer in department column e If the department column in a person record is not NULL it must be an integer pointer to a valid record in the department table D Description in department column e Ifthe department columnina person record is not NULL it must contain the full description of a valid department inthe department table e Any character other than I causes this action ona person import e Unused for imports to other tables Byte 124 Badge Update Control 1 byte A Update any badge record s as requested regardless of status V Update only badge records with a valid status Chapter 3 17 Importing data e Any character other than A causes this action on a badge import e Unused for imports to other tables Byte 125 126 Picture Perfect Export Signature 2 bytes Must be CR Byte 127 Header Section Terminator 1 byte Must be a carriage return ASCII 0x04 Example of header Requirement Update existing badge records with valid badge status only which includes badge encode numbers in each input record and carriage returns only to the Picture Perfect host saturn login name ccolvin overwrite output file cas export badgeimp out append to error file cas export badgeimp err one operator activity record for the entire function separate the columns with a vertical bar and the records with a new line M A0000000 saturn ccolvin 32badge badgeimp out Nbadgeim
29. In this case there is no badge being updated on the person record Figure 2 Example of person record update A0000000yourpphost install 31person L OP a BER n allol1 James Smith 23 lo 1 20041213 220905 0004 User nr 1 VIR er LLL tn pete erm Example 3 Badge record insert Badge records can be inserted into the badge table without other employee person data The following sample import file contains a header followed by a badge record insert This example shows the minimum required fields on the badge record Figure 3 Example of badge record insert Al 3 99 999 39 install 34badge BdgIns out NbadgIns err N ACR Test Badge 4 2233433346 o0 LLL HE LEE LEE LEE E EE EE 22 E I Picture Perfect Import Export User Manual Illegal Characters The Informix database manager does not allow certain characters in data fields Make sure you filter out the following characters For names containing an apostrophe such as O MALLEY you may replace the apostrophe with a back quote The back quote is on the key with the tilde Or you may leave a space for example O MALLEY single quote or apostrophe double quote i asterisk less than gt greater than exclamation point equal amp ampersand pipe A carat Chapter 3 21 Importing data Multiple Host BID Formats If you have multiple badge formats and the badge records you are importing are of a format that is not the default you mus
30. Security User Manual Picture Perfect v4 Import Export Picture Perfect 4 0 Import Export llamas AA sana ISer IVICYIn n iui o A d AU DT D as Wy VA B SA SA E Copyright Disclaimer Trademarks and patents Intended use Copyright O 2007 GE Security Inc All rights reserved This document may not be copied or otherwise reproduced in whole or in part except as specifically permitted under US and international copyright law without the prior written consent from GE Document number 4602190078 January 2007 THE INFORMATION IN THIS DOCUMENT IS SUBJECT TO CHANGE WITHOUT NOTICE GE ASSUMES NO RESPONSIBILITY FOR INACCURACIES OR OMISSIONS AND SPECIFICALLY DISCLAIMS ANY LIABILITIES LOSSES OR RISKS PERSONAL OR OTHERWISE INCURRED AS A CONSEQUENCE DIRECTLY OR INDIRECTLY OF THE USE OR APPLICATION OF ANY OF THE CONTENTS OF THIS DOCUMENT FOR THE LATEST DOCUMENTATION CONTACT YOUR LOCAL SUPPLIER OR VISIT US ONLINE AT WWW GESECURITY COM This publication may contain examples of screen captures and reports used in daily operations Examples may include fictitious names of individuals and companies Any similarity to names and addresses of actual businesses or persons is entirely coincidental GE and the GE monogram are registered trademarks of General Electric Picture Perfect product and logo are trademarks of GE Security Other trade names used in this document may be trademarks or registered trademarks of the
31. TPS not running Picture Perfect must be running in order to update operator activity history Data is too long The value of the column is too long for the field Chapter 6 Troubleshooting and support Table 10 Communication failure error messages Error message Description Department description column is required for update You must use a description in the proper field Employee employee num has multiple badges The badge record selected for updating based on employee num has more than one record therefore the record cannot be updated You must update the desired record through Picture Perfect Error accessing process control in TPS Make sure Picture Perfect is up and running then try again Error fetching hostname for network insert for host id The host table is not setup correctly and you are in a networked system Verify by using the Control Host options from the Picture Perfect menu Error importing data There is an error in the data you are trying to import Verify the data you are importing Error incorrect header layout The header in the import file contains an error Verify each byte to make sure it contains the correct layout login id2 login name data type num table table name Error opening error file Check the name and permissions of the error file designated in the header or on the command line Error opening error fi
32. _hissize the alarm history table is renamed to alarm historytmp and the system pops up a window telling the operator to archive the alarm history data The system then drops the current alarm history table and recreates it as an empty table New transactions are then inserted into the empty alarm history table while the older transactions reside in the alarm historytmp table until overwritten by the next rollover of alarm history Chapter 4 Exporting data When exporting alarm history data you may select data from either table The most recent history data is in the alarm history table The older alarm history is in alarm historytmp Both have the same table layout Badge History Picture Perfect maintains two badge history tables badge history and badge historytmp Badge transactions are inserted into the badge history table until it reaches the bdg_hissize parameter located in the system config table accessed through the System Parameters form When the number of badge history transactions reaches the threshold or percentage of the bdg_hissize the badge history table is renamed to badge historytmp and the system displays a window telling the operator to archive the badge history data The system then drops the current badge history table and recreates it as an empty table New transactions are then inserted into the empty badge history table while the older transactions reside in the badge historytmp table until overwritten by the next rollo
33. and department information are the most common types of data imported into Picture Perfect Import data can come from removable media or directly from another computer using a network One or more import records can be taken from a single file Once the data file resides on Picture Perfect s hard disk import data may be submitted by the system scheduler using a cron or at job or from the Unix command line Transaction and error status messages are posted in the output and error files given in the application header Preparation for Import The imported data must be extracted from a source system formatted to conform with the appropriate Picture Perfect record structure and written to a file Records to be imported must observe column positioning with all columns represented in all records Null fields are represented by adjacent field separators In some records specific columns must contain data not null for successful import This requirement may depend on either the database schema or the transaction code included in the application header of the input file The data file must then be transferred to the hard disk on the Picture Perfect host Typically a system administrator imports the data from the operating system command line or sets up a scheduled event to import the data at a particular day date and or time The output and error files should be checked upon completion of the import operation Export Export means to retrieve
34. at o out stat In this example importdb references the file cas import badge dat forheaders and import data and writes standard output stdout messages into cas export out stat Error file names are taken from the application header importdb i tmp badge dat o tmp out stat In this example importdb references the file tmp badge dat for headers and import data and writes standard output stdout messages into tmp out stat Error file names are taken from the application header importdb i badge dat o out dat e err dat In this example importdb references the file cas import badge dat forheaders and import data and writes standard output stdout to the file cas export out dat It writes error stderr messages into the file cas export err dat importdb i u imp badge dat o u exp out dat e tmp err dat In this example importdb references the file u imp badge dat for headers and import data and writes standard output stdout to the file u exp out dat It writes error stderr messages into tmp err dat Database Inserts Adds inserts to any table must conform to the following requirements e The Modify Date and Modify Time fields should always be completed Use the current date YYYYMMDD and current time HHMMSS If these fields are not filled in the current date and time on the server will be used Refer to Header formats on page 13 for Person table options regarding use of either Department ID or De
35. ate Form yyyymmdd in the time zone of host 20 host xact time 0 to 235959 11 Host Transaction Time Form hhmm ss in the time zone of the host 21 utc_xact_date gt 19000101 11 UTC Date Form yyyymmdd in UTC GMT time 22 utc_xact_time Oto 235959 11 UTC Time Form hhmmss in UTC GMT time 23 nbadge lor2 16 Number of Badges Number of badges in transaction 1 Single 2 Double 24 sequence lor2 6 Badge Sequence 1 1st Badge in Transaction 2 2nd Badge in Transaction 25 kp_alarm_resp 0 1 21 Keypad Alarm Response 0 Normal 1 Keypad 26 personnel type 1 to number of records in 11 Personnel Type personnel type table Foreign key to id field in personnel type table 27 swipe show Oor1 21 Swipe and Show 0 Normal 1 Swipe and Show Table 14 Badge History export only COL Columnname Range value Length Meaning 28 floor accessed 0 to 64 14 Floor Accessed Floor accessed on an elevator 29 tzcorr 24 to 24 6 Time Zone Correction Time zone offset of micro relative to the host location 30 facility 1to 2 147 483 647 11 Facility Foreign key refers to id field in facility table Record number of the facility this record is in 65 66 Picture Perfect Import Export User Manual Badge Table 15 Badge COL Column name Range value Length Meaning 1 id 1to 11 Id 2 147 483 647 Unique record number assigned by system 2 description 1to 60 bytes 60 Badge D
36. ch as the category and department fields in a badge record are integer pointers to corresponding records in other tables This may require somewhat complex queries to retrieve enough information for the user to understand the generated report The design that is the size table name column names and attributes of a relational database is referred to as its schema Much of the Picture Perfect schema is available to the system administrator under the REPORTS interface Things to Think About e Do the source and Picture Perfect databases need to stay synchronized If a field is imported then changed on the Picture Perfect system the databases will not be identical synchronized If synchronization is required an export is required e The badge encode number the number inside the badge is a required column in a badge record If it is not available on the source system how will it be assigned It must be a real badge encode number because it cannot be changed from the badge window after it is in the Picture Perfect database e s the data that is being exported consistent with your site s security requirements and or union rules e Is the system configured to route all required transactions to history Activity not routed to history cannot be retrieved which can distort transaction reporting on a foreign system Personnel Picture Perfect Information gt Person Table Company Department Picture Perfect Listing gt Department Tab
37. ct Import Export User Manual Examples Export Queries Requirement Retrieve the last name badge encode number reader description transaction date and transaction time that occurred between January 5 and January 7 2005 sorted by last name using only the current history table Statement SELECT last name bid reader desc host xact date host xact time FROM badge history WHERE host xact date BETWEEN 20050105 AND 20050107 ORDER BY last name Requirement Retrieve the last name badge encode number and reader description of all badges with 00124 as the first 5 digits of the badge encode number that were used between January 1 and January 5 2005 in the current history table sorted descending by badge encode number Statement SELECT last name bid reader desc FROM badge history WHERE bid LIKE 00124 AND host xact date BETWEEN 20050101 AND 20050105 ORDER BY bid DESC Merging Table Rows Columns listed with the SELECT verb are reported left to right in the order listed When rows from multiple tables need to be merged the UNION keyword is used to connect two separate selections The sorting column is given positionally with the ORDER BY clause given only after the last statement Requirement Retrieve the last name badge encode number and reader description of all badges with 00124 as the first 5 digits of the badge encode number that were used January 1 through 5 2005 sorted by last name mergi
38. d below and listed in alphabetical order Table 10 Communication failure error messages Error message Description Bad date must be YYYYMMDD The date must be in the format of year month day Bad time must be 0 235959 The time must be within the range of 000000 to 235959 Badge for employee employee numhas no BID The record on the host badge table does not have a BID Check the employee number to see if it is correct Blank field requires data This particular field requires data and was left blank Can t find system config record for setup Check the environment and make sure Picture Perfect is running Can t get internet address for host The specified host is unknown to the client Check the client s host table to ensure that it contains an entry for the Picture Perfect host Can t open filename errno num Error occurred when trying to open the filename to read Can t read presentation header errno num Error occurred trying to read the presentation header Can t update department description using id num not in database Updating a department requires an id in the department id column Can t update department with no database ID Updating a department requires an id inthe department id column Can t update micro TPS is not running Picture Perfect must be running in order to update the micros Can t update operator activity
39. d to the job must be that of a Picture Perfect operator with permission to access the tables involved in the operation The login ID must also have read and execute rights to the directory structure for the input output and error file paths read permission for the input file itself and write permission to the output and error files and their parent directories An import file is made up of three parts a Presentation header an Application header and data records The import file begins with a two part header The first eight bytes make up the presentation header which defines the ASCII data type and carriage control new lines carriage returns or both The next 120 bytes make up the application header which defines the Picture Perfect computer s network hostname the import owner s login name and password the import transaction type the affected table the field and record delimiters the output and error file names two user comment fields and the import signature There is only one header per file although the file may have many import records There are examples of header files in the cas import directory See Header formats on page 13 for more information on headers The importdb Command Syntax importdb i filename o filename e filename Usage importdb i input fileisa required argument o output file default use header record e error file default use header record m usemodify dateandmodify time supplied in
40. def struct node char buf struct node next node typedef node buflist typedef struct int errnum int cause int good int bad union buflist list export r u export r Pointer to a line of data Pointer to the next item on the list Contains the host system s errno if any Contains a server specific error code Number of good transactions Number of error transaction Linked list of returned data or error records Chapter 5 39 Remote Procedure Call Interface Troubleshooting Failure to execute falls into two general categories Communication failures e Application related errors Communication Failures Communications failures cause a pointer to NULL to be returned These errors most commonly result in the following error messages Table 6 Communication failure error messages Error message Description can t get internet address for host The specified host is unknown to the client Check the client s host table to ensure that it contains an entry for the Picture Perfect host rpc error the pmapper failed in its call The client host table entry for the specified host contains the wrong Internet address Check the client host table to verify that the Internet address is correct for the Picture Perfect host The network is not operational or the client s network interface is not up Try to ping the Picture Perfect host
41. der desc FROM badge historytmp WHERE bid LIKE 00124 AND badge history area area id AND host xact date BETWEEN 20050101 AND 20050105 ORDER BY 1 Subqueries A selection criterion can depend on the result of another select statement This requires the use of a subquery the result of which is passed back as one or more conditions to be met The inner query functions as the subquery and is resolved first It may return one or more values of the data type needed as criteria as in the following example Requirement Retrieve the last name badge encode number reader and area descriptions and transaction dates and times for all badge activity by badgeholders in the SECURITY department sorted by date and time Statement SELECT last name bid area description reader desc host xact date host xact time FROM badge history area WHERE badge history dept SELECT id FROM department WHERE description SECURITY UNION SELECT last name bid area description reader desc host xact date host xact time FROM badge historytmp area WHERE badge history dept SELECT id FROM department WHERE description SECURITY ORDER BY host xact date host xact time 31 32 Picture Perfect Import Export User Manual Chapter 5 Remote Procedure Call Interface This chapter describes the Remote Procedure Call RPC Interface which provides remote hosts or workstations with real time access to the Picture Perfect database eliminating the need to
42. ds are case sensitive for clarity in the following statements the SQL keywords are given in upper case and everything else in lower case Also for clarity example statements are broken into multiple lines since SQL is unconcerned with carriage control The format of a basic SQL statement is SELECT columns FROM tables WHERE criteria ORDER BY columns columns These are the names of columns within tables Multiple column names are separated by commas When using multiple tables column names should include the table name table column to avoid ambiguity and a failed export An asterisk following the SELECT verb indicates that all columns are to be retrieved for selected rows Columns are written to the output file in the left to right order listed after the SELECT verb tables These may be one or more Picture Perfect tables Multiple table names are separated by commas Any table referenced in any clause in the statement must be listed criteria These specify the conditions the rows must meet to be selected criteria may be tested for equality or inequality with multiple tests connected through the use of logical conjunctions such as AND or OR ORDER BY Within the ORDER BY clause rows are sorted by the given columns The first column listed serves as the primary sort field and additional columns sort rows where the primary sort field is identical The default sorting order is ascending To sort in descending order use the key
43. e Perfect Network System Host package 6 pprs Picture Perfect Redundant System package 7 subhost Picture Perfect Network System Subhost package 8 tours Picture Perfect Guard Tours package Enter product number s separated by to select q to quit 7 To select the Picture Perfect Import Export package select the appropriate number for the impexp product and press Your package selection will now be displayed and you will be asked to confirm You have selected the following product s 4 impexp Picture Perfect Import Export package Is this correct y n y 8 To make a different selection type n and you will be returned to step 7 of this section where you will be prompted again for your selection To continue the installation type y or press to accept the default y Chapter 1 3 Installing Import Export The installation will begin and messages similar to the following will appear on the screen Installing impexp Picture Perfect Multi package Installation 3 0 02 10 05 Copyright C 1991 thru 2005 GE Security Installing from image in mnt cdrom pp 296 blocks Do you want to install the Picture Perfect IMPEXP Package y n yl 9 Type y and press to confirm that you want to install the Picture Perfect Import Export package You will see messages similar to the following Checking if need to save nls or help files Picture Perfect NLS Text Save 3 0 1 16 05 Copyright C 1994 2005 GE Security Tue Jan 2
44. e are handled as follows e Any column that contains data is updated in the Picture Perfect database except for the ID or Badge ID bid columns For security reasons these columns cannot be updated through the import program e f you do not want to update the data of a particular column do not place any data between the column delimiters The current data will remain intact e To remove data from a column in the Picture Perfect database insert the word NULL in that column The current information will be erased This applies to both integer and character data types e For changes to the Badge Table the id and bid fields are required in order to automatically update all the micros where the badge resides If the bid is not provided then an attempt will be made to acquire it using the id field if present e After the changes are made any column that resides on the microcontroller is automatically updated if the data is different from the data already existing in the database Table changes Picture Perfect versions 2 0 and 4 0 Beginning in Picture Perfect 2 0 the area table was split and the category data was moved to a separate tables Two new tables now contain that data area category andarea event category In Picture Perfect 2 0 categories were increased from 10 to 32 For all of the new sub tables the foreign key back to the parent table is the table id of the parent table that is Thearea category area id fieldis a forei
45. e badge records using the exported person id forthe person_id field 4 Inserting the person category records using the exported person id forthe person id field 5 Inserting the person_user records using the exported person id for the person_id field In order to simplify the import update of records into these tables the Import Export program was modified When inserting records into these tables the extra columns for the sub tables must be specified The Import Export program will handle the creation of the sub table records into their appropriate tables See Examples of Import Data Files on page 19 Import Data Files The import data file contains the records to be imported into the database Header formats Use the Presentation Header and Application Header formats when creating import files There are examples of header files in the cas import directory Presentation Header The first eight bytes in the input file make up the presentation header Important points about the presentation header are Fields are positionally dependent Each field must start on the exact character listed below for a file to import successfully e Fields may be less than but never more than the indicated number of characters If the content of the field doesn t fill the entire field fill the remaining character positions with spaces Use of tabs is discouraged as they may be interpreted either as a single character or as multiple spaces and cou
46. e byte in the import header is set to allow only badges with a status of valid to be updated If you want to update badges with a status of 4 5 or 6 change the header Chapter 6 53 Troubleshooting and support Contacting technical support For assistance installing operating maintaining and troubleshooting this product refer to this document and any other documentation provided If you still have questions you may contact technical support and or pre sales For pre sales and technical support assistance we provide customers with several options see Table 11 Our support phone number is available Monday through Friday 8 a m to 7 p m Eastern Time Protection plans are available for extended coverage Table 11 Pre sales and support contact information Pre sales Technical support 1 800 428 2733 1 888 GE SECURITY 437 3287 561 998 6160 561 998 6224 None rs bctsupport ge com Note Be ready at the equipment before calling for technical support Online publication library Another great resource for assistance with your GE product is our online publication library available to all of our customers To access the library go to our website at the following location http www gesecurity com In the Tools area at the top click the Publication Library link After you register and log on you may search through our online library for the documentation you need 54 Picture Perfect Import Ex
47. e type of service the caller is requesting Note The function bidgen is no longer supported How RPC Works An RPC client requests a known service from the server by creating a connection to the RPC server on the specified host for the duration of the RPC Data is then sent to the server by passing it through a set of XDR filters that convert it to a format understood by all types of computers These filters pass the converted data through the connection and across the network to the specified RPC server The server converts the data to its own machine s data format and performs the requested service The results are sent back to the client in the same fashion by passing the returned data through the same set of XDR filters These XDR routines are included with the client RPC libraries Software requirements Chapter 5 35 Remote Procedure Call Interface In order to write to the RPC Interface the following items are required e RPC Toolkit for Picture Perfect included with Import Export software e Picture Perfect Import Export User Manual this manual e Third party RPC and XDR Library e Third party TCP IP Socket Library e Third party TCP IP Runtime Services e Third party C Language compiler and linker When running the RPC interface with Picture Perfect 4 0 the following customer environments are supported Table 3 Supported systems Operating System Compiler TCP IP Library MS Windows XP Professional
48. ed 8 Purged LT priority 1to 500 6 Priority Alarm priority 12 response 1to 255 bytes 255 Response Alarm responses selected 13 opr_respond_date gt 19000101 11 Respond Date Form yyyymmdd in the time zone of the operator 14 opr respond time 0 to 235959 11 Respond Time Form hhmmss in the time zone of the operator 15 host_respond_date gt 19000101 11 Host Respond Date Form yyyymmdd in the time zone of the host 16 host respond time 0 to 235959 11 Host Respond Time Form hhmmss in the time zone of the host 17 utc respond date 19000101 11 UTC Respond Date Form yyyymmdd in UTC GMT time 18 utc respond time 0 to 235959 11 UTC Respond Time Form hhmmss in UTC GMT time 19 happened date 19000101 11 Happened Date Form yyyymmdd in the time zone of the operator 57 58 Picture Perfect Import Export User Manual Table 12 Alarm History export only eo RE Column name Range value Length Meaning 20 happened_time 0 to 235959 11 Happened Time Form hhmmss in the time zone of the operator 21 host happened dote 19000101 11 Host Happened Date Form yyyymmdd in the time zone of the host 22 host happened time 0 to 235959 11 Host Happened Time Form hhmmss in the time zone of the host 23 utc_happened_date gt 19000101 11 UTC Happened Date Form yyyymmdd in UTC GMT time 24 utc happened time 0 to 235959 11 UTC Happened Time Form hhmmss in UTC GMT time 25 facility 1to 2 147 11 Facility
49. eld Chapter 6 Troubleshooting and support Table 10 Communication failure error messages Error message Description The data for the field contains an error Check your data Invalid data is causing a syntax error Refer to the statement in the input file and check your data Invalid data is causing SQL error num Use the utility program sqlmsgnbr num to obtain more information regarding the SQL error Invalid presentation header size num The format of your header does not match the required layout Invalid table table name in header is causing SQL error Check the spelling of the table name Invalid table table name in header record Check the spelling of the table name Memory allocation error The import records are most likely coming in too fast for Picture Perfect Re start Picture Perfect and send the records in slower This can happen on updates since the badge update must also update all the micros that contain the badge No operator login id for employee employee num Verify that the username or operator login id specified in the header actually exists as an operator in Picture Perfect No operator permission The import is trying to update or insert a record containing a category that the operator does not have permission to use From the menu check the Picture Perfect permissions and permission group setup for the operator The operator for t
50. eraaaaiiiuwddodaaheeddcansansekahie 19 WEGOWENGRGCtErS sx TEE E 20 Multiple Host BID Formats 2 2 c ans emer e rr IT eR RITR ETC Ober n detente 21 iv Picture Perfect Import Export User Manual Chapter 4 Chapter 5 EXBONING COU muessen 23 Command Line Queries 5282424 we wen v RE E a rl area s RE RR SES 24 Hec 24 eU P H 24 Hep AIDE 25 clero E D 25 Haag te edades 26 SOU OWS M M 27 SVO rta AA petebat aa eee bed PETERS uina M EU Oe hae aaa 27 Special Mords and Symbols sieh ia 28 Exporting History Data coi inc nn aaa en prex RE UMEN 28 Alar HISTON c siste AAA aaa a a a ea 28 Badge HISTORY mer PEE 29 Operor RITON ar dettes cken at eine E G rede 29 Examples 24 0 ii RETO ie Run ebene DEP Pd 30 Export QUERIES ne Ren a 30 Merging Table ROWS sus ose Arsen na ee ehe 30 Resolving Intertable Dependencies 31 SUbaUBrIeS esse ote aae NT eoe pe bete d bei ER beer TCU EE BEAT Y 31 Remote Procedure Call Interface 33 OVEIVIEW EM 34 HOW RPC nic cm 34 Software requirements nn ee ansehen 35 Sources for PC based TCP IP Software 35 The Import Export Interface RPC Toolkit nn ren 36 The Test Program client 2 onbel u 0
51. error invalid signature The format of your header does not match the required layout Header error output file name is required The header record must contain an output file name Header error unknown transaction type The transaction type must be a valid one listed in the manual such as 31 or 32 Header option requires id for department description The header is indicating that the import wants to use a department description in the person department column andit is not there Id column is required for update The id of the record is needed to do an update and the import program was unable to retrieve it Put it in the import file and try again D is null for department dept name Id is required and there is none in the id field of the import file llegal duplicate insert attempted The record has already been inserted into Picture Perfect mport file ilename rejected no transactions processed There is an error locating or using the filename specified with importdb Verifythatthe filename is correct and that it exists mport file ilename rejected unknown transaction type type The transaction type must be a valid one listed in the manual such as 31 or 32 mport rejected on Backup host Perform import on Primary host Import operations are permitted only on the primary host in a redundant Picture Perfect system nvalid data in fi
52. escription 3 bid 1to 16 bytes 16 Badge Encode Number 4 status 0 4 5 6 6 Status Badge status O Active 4 Lost 5 Suspended 6 Deleted 5 badge_tour 0 1 11 Badge Tour Designates a badge as a tour badge used to conduct guard tours of a facility at specified intervals This badge will not operate for normal access control O Disabled 1 Enabled 6 badge_temp 0 1 11 Temporary Badge Designates a badge as a temporary badge A pool of badges can be created and used repeatedly for this purpose OzNo 1 Yes 7 person_id 1to 11 bytes 11 Person Id Note If Import Export is used to unassign a badge from a person this field must be set to 0 zero If it is set to NULL the operation will fail 8 reader 1to 11 Reader 2 147 483 647 The reader that last granted access to this badge 9 access_date gt 19000101 11 Access Date Date in the form yyyymmdd Automatically supplied by the system 10 access time O to 235959 11 Access Time Date in the form yyyymmdd Automatically supplied by the system 11 access tz 1tothe number 11 Access Time Zone of records in the Time zone of last access Automatically supplied by the system time zone table 12 issue date 19000101 11 Issue Date Date in the form yyyymmdd Automatically supplied by the system if left blank during inserts 13 issue time O to 235959 11 Issue Time Time in the form hhmmss Automatically supplied if left blank during inserts 14 issue context Q 1 2 11 Issue Context Time zone context O Host 1 M
53. export performing a SELECT FROM person area or area event will include records from the original table structure as well as from the associated sub tables appended to the end of each record as shown in Table 8 Table 8 Updated table structure Original table structure New table structure area area area_category area event area event area event cat person person person user person category badge If the user wishes to get records from just the base person area or area event table then an accommodation has been made so for these three tables if the user uses a SELECT ofthe form SELECT FROM the additional sub table records will not be retrieved This feature is applicable whether the provided client program is being used or the user s own RPC client program is being used Export Prototype export r client export V1 char host char statement The host parameter must be a character pointer to the Picture Perfect host name or its Internet address Host names may also include the complete domain name provided that the client s TCP IP subsystem is configured to use a domain name server The statement parameter must be the address of a pointer to a string containing an SQL SELECT statement The length ofthe SELECT statement cannot exceed 4096 characters Export Diagnostics Upon successful completion a pointer to an export r structure is returned The good component corresponds to
54. ey to id field in category table Record number of the category in category on the badge with badge_id table 4 slot number 1 to 96 11 Slot Number Slot number the user field is assigned to the user field number 5 facility 1to 11 Facility 2 147 483 647 Foreign key to id field in facility table Record number of the facility this record is in 6 modify date gt 19700101 11 Modify Date Modification date in the form yyyymmdd System will supply the current date if no date is provided 7 modify_time 0 to 235959 11 Modify Time Modification time in the form hhmmss System will supply the current time if no time is provided Area Table 23 Area COL Column name Range value Length Meaning 1 id 1to 11 Id 2 147 483 647 Unique record number assigned by system except when using transaction type 35 2 description 1to 60 bytes 60 Description User field description value 3 valid_routing 1to 11 Valid Routing 2 147 483 647 Foreign key to id field in the routing table Record number of the type of routing to do for valid badge reads for an area 4 inv_routing 1to 11 Invalid Routing 2 147 483 647 Foreign key to id field in the routing table Record number of the type of routing to do for invalid badge reads for an area 5 susp_routing 1to 11 Suspended Routing 2 147 483 647 Foreign key to id field in the routing table Record number of the type of routing to do for suspended badge reads for an area 6
55. face Verify Prototype long client verify V1 char host long argp The host parameter must be a character pointer to the Picture Perfect host name or its Internet address Host names may also include the complete domain name provided that the client s TCP IP subsystem is configured to use a domain name server The argp parameter must be a pointer to a long integer representing the number to be sent to the server Verify Diagnostics If the function completes successfully a pointer to a long integer is returned The integer should be inspected to ensure that it is equal to the contents at argp since part of the verification should include checking byte and word ordering between machine architectures If the function fails the appropriate error message is outputto stderr and a long pointer to NULL is returned If the function returns a non NULL pointer but it points to a different value your client software may have a problem Contact your GE Security technical support representative for further assistance 42 Picture Perfect Import Export User Manual Import Service The Import service is used to import data into Picture Perfect and to update the microcontrollers with pertinent changes As explained in Chapter 3 Importing data data to be imported consists of a file containing an application and presentation header followed by one or more delimited records With RPC however the import file is created by the client applicatio
56. ge Exhausted 32 Valid No Passage 33 2nd Badge Door Lock 34 Valid Toggle Reader 35 Valid Door Was Not Locked 36 Tour Badge 37 Valid No Door 38 Swipe and Show 39 Valid Floor 40 Invalid Floor 41 N A 42 Valid Timed APB In 43 Invalid Timed APB In 44 Valid Timed APB Out 45 Invalid Timed APB Out 63 64 Picture Perfect Import Export User Manual Table 14 Badge History export only COL Columnname Range value Length Meaning 10 duress YorN 1 Duress 11 shunt YorN 1 Shunt 12 reader type lo 0 8 16 32 64 128 256 6 Logical Reader Type g 512 1024 2048 0 Normal 8 Elevator 16 APB In 32 APB Out 64 Console 128 Double Badge 256 T A In 512 T A Out 1024 Authorization Required 2048 No Authorization Required 13 reader_type_p 1 2 4 17 Physical Reader Type hy 1 Badge Only 2 Badge amp Keypad 4 Keypad Only 14 reader_desc 1 to 60 bytes 60 Reader Reader description 15 dept 1 to the number of 11 Department records in the Badgeholder s department record number department table 16 status 0 4 5 6 11 Status Badge status O Active 4 Lost 5 Suspended 6 Deleted 17 dev xact date gt 19000101 11 Transaction Date Form yyyymmdd in the time zone of device 18 dev xact time 0 to 235959 11 Transaction Time Form hhmmss in the time zone of device 19 host xact date gt 19000101 11 Host Transaction D
57. gn key to the area id field in the area table Thearea event cat area event idfieldis a foreign key to the area event id field in the area event table Also beginning in Picture Perfect 2 0 the badge table was split and the category and user data was moved to separate tables In Picture Perfect 4 0 the badge table was further split into a badge and person table Categories that can be assigned to personnel records were increased to 96 For the person table the Chapter 3 13 Importing data categories were moved to the person category table and the user data was movedtotheperson user table For all of the new sub tables the foreign key back to the parent table is the table id of the parent table that is e Theperson user person id field is a foreign key to the person id field in the person table e The badge person_id field is a foreign key to the person id field in the person table e Theperson category person id field is a foreign key to the person id field in the person table As a result of the above mentioned changes an insert into one of the above tables that included data in one or more of the sub tables would have resulted in 3 area or area event or 4 person additional steps An insert into the person table for example that included badge user and category data would have involved 1 Inserting the basic personnel record 2 Exporting it to get back the person id of the inserted record 3 Inserting th
58. he import is specified in the header record No operator record found with employee id employee num Verify that an operator exists in Picture Perfect based onthe employee num No permission for opera tor user name to assign category description in field category position You are trying to insert a category on a badge and you do not have operator permission set up in Picture Perfect for that category or id based on the operator user name in the import file No transactions processed An error was encountered and no transactions were inserted or updated Record st invalid badge format in field bid data bid The bid number does not match the badge format specified in system config badge id format Record value is too long in field bid data bid The bid number contains more numbers than allowed according to system config badge id format 51 Picture Perfect Import Export User Manual Table 10 Communication failure error messages Error message Description Record value is too short in field bid data bid The bid number contains fewer numbers than allowed according to system config badge id format Related table requires data The particular column identified is a foreign key to another table Data must be inserted into the other table before it can be referenced Rpc error the pmapper failed in its call The client ho
59. his day O No 1 Yes monday 0 1 Mon Indicates if the event is to run on this day O No 1 Yes tuesday 0 1 Tue Indicates if the event is to run on this day O No 1 Yes wednesday 0 1 Wed Indicates if the event is to run on this day O No 1 Yes 10 thursday 0 1 Thu Indicates if the event is to run on this day O No 1 Yes 11 friday 0 1 Fri Indicates if the event is to run on this day O No 1 Yes 12 saturday 0 1 Sat Indicates if the event is to run on this day O No 1 Yes 13 record_id 1to 2 147 483 647 11 Area Foreign key to id field in the area table Record number of the area this event is for 77 78 Picture Perfect Import Export User Manual Table 24 Area_event COL Column name Range value Length Meaning 14 area_online 0 1 2 6 Area Online Indicates if the area is to be put online or offline O Do not care 1 Online 2 Offline 15 valid_routing 1to 11 Valid Routing 2 147 483 647 Foreign key to id field in the routing table Record number of the type of routing to do for valid badge reads for an area 16 inv_routing 1to 11 Invalid Routing 2 147 483 647 Foreign key to id field in the routing table Record number of the type of routing to do for invalid badge reads for an area 17 susp routing 1to 11 Suspended Routing 2 147 483 647 Foreign key to id field in the routing
60. icro 2 Operator Table 15 Badge COL Column name Range value Length Meaning 15 expired_date gt 19000101 11 Expiration Date Date in the form yyyymmdd 16 expired_time 0 to 235959 11 Expiration Time Time in the form hhmmss 17 expired_context 0 1 2 11 Expired Context Time zone context O Host 1 Micro 2 Operator 18 return date 19000101 11 Return Date Date in the form yyyymmdd 19 return time 0 to 235959 11 Return Time Time in the form hhmmss 20 return_tz 1 to the number 11 Return Time Zone of records in the Time zone of return time_zone table 21 usage_count 1to 11 Usage Count 2 147 483 647 Number of badge swipes allowed before badge becomes exhausted Swipes through limited usage reader types are the only ones that decrement this field 22 usage_exhausted 0 1 6 Usage Exhausted O N A 1 Exhausted 23 tour_badge 0 1 11 Tour Assigned Internal Use Only for Tour Badge O No 1 Yes if tour package is installed 24 bid_format_id 1 tothe number 11 Badge Encode Format of entries in the Foreign key refers to id field in host bid format table If left host_bid_forma blank on Insert it will automatically be assigned to the default t table badge id format set in the system config table using the Setup System Parameters form 25 reissue cnt 1to 99 2 Reissue Count Used for seed counter Number of times a badge is re issued DO NOT PUT DATA IN THIS FIELD 26 reprint cnt 1to 99 2 Repr
61. icture Perfect host the program numbers 540 000 000 through 540 000 003 are registered with the portmapper Client Configuration In order for the client to take advantage of this feature it must specify which server it intends to use This is accomplished through the manipulation of the global unsigned long integer impprog which defaults to the value of IMPPROG defined in imex h To connect to the server invoked as cas bin importd 1 forexample the client program should set its impprog variable to IMPPROG 1 asin impprog IMPPROG 1 Chapter 5 45 Remote Procedure Call Interface Timeouts The header file imex h contains default time out values for each of the three RPC services These time outs are used to specify the maximum allowable time in seconds an RPC may execute before the RPC is considered to fail The import and export service can take longer than the defaults which can cause the procedure to terminate prematurely with a time out error If this occurs modify the time out values The defaults are currently defined in imex h as follows define VERIFY TIMEOUT 5 Shouldn t take long at all define IMPORT TIMEOUT 60 Depends on number of records file define EXPORT TIMEOUT 120 Depends on complexity of the query Inventory of source code supplied with Import Export The following files comprise the Import Export Interface RPC Toolkit usr rpc imex h usr rpc cli main c usr rpc cli verify usr rpc
62. ify conditions or practices that may result in damage to the equipment or other property A WARNING Warnings identify conditions or practices that could result in equipment damage or serious personal injury viii Picture Perfect Import Export User Manual Chapter 1 Installing Import Export This chapter covers the background information needed to successfully install your Picture Perfect Import Export package In this chapter PIU C ECL 2 Picture Perfect Import Export User Manual Installation To install Picture Perfect Import Export after the base system has been installed do the following 1 Log in to the system as root 2 From a command prompt open a terminal window 3 Type the following to shut down Picture Perfect cas bin profile rc pperf k 4 Insert the Picture Perfect CD into the CD ROM drive Linux The CD mounts automatically AIX Mount the CD by typing mntCD If this command is not found type mount v cdrfs o ro dev cd0 mnt 6 To display a list of installation options type Linux media cdrom INSTALL o AIX mnt INSTALL o Messages similar to the following will display The following BASE OPTIONS product s are available Prod Name and Descriptions 0 base Picture Perfect Base package 1 EIF Picture Perfect External Interface package 2 graph Graphics Monitoring and Control package 3 image Picture Perfect Imaging package 4 impexp Picture Perfect Import Export package 5 netlan Pictur
63. information usually transaction history records from the Picture Perfect database and place it as delimited text records in a hard disk file making it available for transportation to another system for reporting or data synchronization purposes Exporting does not change or remove any information from the Picture Perfect database Data retrieval is done through the use of command line queries using SQL syntax Preparation for Export You must define exactly what information is required on the destination system content order sorting type etc The SQL query that retrieves this information must be created and thoroughly tested on the Picture Perfect system using the REPORTS form When it meets your needs save the SQL statement In a relational database data is stored on the disk in areas set aside for it during installation As installation continues these areas are divided into tables such as the badge table reader table and badge history table Data is stored in the tables as records with records divided into columns Each record in the same table represents the same type of data Columns are positional within a record with the same type of information stored in the same position in each record in the table Additionally one of the main objectives of a relational Chapter 2 Functional overview database management system RDBMS is to eliminate the need for data redundancy through the use of record pointers so that many fields su
64. input file Options i filename Input File filename is the file containing the data for import including headers If filename is not a full pathname denoted by a leading slash the file is assumed to be located in the cas import directory o filename Output File filename receives the redirection of standard output stdout If filename is not a full pathname denoted by a leading slash the file is written to the cas export directory This command line option has precedence over the application header output file field The application header determines whether the output file is overwritten or appended Chapter 3 11 Importing data e filename Error File filename receives the redirection of standard error stderr If filename is not a full pathname denoted by a leading slash the file is written to the cas export directory This command line option has precedence over the application header error file field The application header determines whether the error file is overwritten or appended Examples of importdb command importdb i badge dat In this example importdb references the file cas import badge dat for headers and import data output and error files are taken from the application header importdb i tmp badge dat In this example importdb references the file tmp badge dat for headers and import data output and error files are taken from the application header importdb i badge d
65. int Count Used for seed counter Number of times a badge is printed DO NOT PUT DATA IN THIS FIELD 27 unique id 1to 16 bytes 16 Unique Id Used for seed counter Unique id assigned to each badge comprised of the WorkStation id and sequential counter DO NOT PUT DATA IN THIS FIELD 28 badge design 1tothe number 11 Badge Design of entries in the badge design table Designates a badge design to be used when printing this badge 67 68 Picture Perfect Import Export User Manual Table 15 Badge COL Column name Range value Length Meaning 30 facility 1to 11 Facility 2 147 483 647 Foreign key refers to id fieldin facility table Record number of the facility this record is in 31 modify_date gt 19000101 Modify Date Date in the form yyyymmdd System will supply the current date if no date is provided 32 modify time O to 235959 Modify Time Time in the form hhmmss System will supply the current time if no time is provided Category Table 16 Category Column name Range value Length Meaning id 1to 11 Id 42 147 483 647 Unique record number assigned by system except when using transaction type 35 description 1to 60 bytes 60 Description permission grp 1to 6 Permission Group 2 147 483 647 Foreign key to id field in permission_group table use value previously set up in Picture Perfect by System Administrator m2mr_type 0 1 2
66. ld therefore jeopardize the success of the import e Headers are case sensitive Keep upper case and lower case characters consistent and inviolate 14 Picture Perfect Import Export User Manual Byte 0 Data Coding Format 1 byte A ASCII Byte 1 Carriage Control for the Import File 1 byte The type of line ending used by the exporting system 0 New lines only 1 Carriage returns only 2 Carriage returns followed by new lines Bytes 2 7 Reserved 6 bytes Must be all zeros 000000 Application Header After the eight byte presentation header the next 120 bytes make up the application header Important points about the application header are e Fields are positionally dependent Each field must start on the exact character listed below for a file to import successfully e Fields may be less than but never more than the indicated number of characters If the content of the field doesn t fill the entire field fill the remaining character positions with spaces Use of tabs is discouraged as they may be interpreted either as a single character or as multiple spaces and could therefore jeopardize the success of the import Headers are case sensitive Keep upper case and lower case characters consistent and inviolate Bytes 8 23 Picture Perfect Computer Network Hostname 16 bytes The internet hostname of the Picture Perfect system where the database resides on disk Configured in the etc hosts file can be displayed fr
67. le Company Security Picture Perfect Access Security Levels gt Category Table Activity Report Picture Perfect Generators gt History 8 Picture Perfect Import Export User Manual Chapter 3 Importing data This chapter describes how to import data into the Picture Perfect database through the use of the importdb command and import files In this chapter VEFPIBW u Gere eed Be HN HEN dq V Vd hos ved deis TRE PAPE Commana Los set Ded Reese Ware he e e te Reg Database Mer eire ana bbe RI OPERI RE OE RAR Vos Database DIOE ae qa es ie SE S a er v Wes Table changes Picture Perfect versions 2 0 and 4 0 P sfr rl E Multiple Host BID Formats 10 Picture Perfect Import Export User Manual Overview Data imported into Picture Perfect is handled by the importdb command In a redundant Picture Perfect system data may be imported only to the primary host Imported data records can perform either an add or a change to the Picture Perfect database depending on the transaction type in the application header When importdb is used to add or change records updates are downloaded to the appropriate microcontrollers just as if the changes were made through Picture Perfect itself The import operation may involve one or more records in a single file Import data may be submitted by the system scheduler using a cron or at job or from the Unix command line The login ID assigne
68. n on the client machine Since RPC performs all presentation layer conversions the data type first byte of the presentation header must be the character A and the carriage control second byte should be the character 0 zero The application header should be formatted as specified in Header formats on page 13 Import Prototype typedef struct FILE fp Pointer to the open import file char name Pointer to the name of the file impexp export r client import V1 char host impexp args The host parameter must be a character pointer to the Picture Perfect host name or its Internet address Host names may also include the complete domain name provided that the client s TCP IP subsystem is configured to use a domain name server The args parameter must be a pointer to an impexp datatype whose fp component is a pointer to the open import file The name component should point to a string containing the file s name Import Diagnostics If the function returns successfully a pointerto an export r structure is returned This should be inspected for application layer errors The good component ofthe export r structure contains the number of records successfully imported The bad component contains the number of records rejected for one reason or another If the bad component is non zero and the errnum component is zero then the linked list pointed to by the export r u list component should be traversed which will yield o
69. ne e nnn ene n eee nennen 57 PerSon oos sce le pH Tears ieee agence NEM DI te REEL REI I ees 59 Badge History export only 62 Badge nn san RE 66 Category use ee ee ee AAA E A 69 FOCI 5 5 ect cnet 2 aa has en ai een 69 Department aa nee ee 70 Host BID Form t un ei pe 71 Operator History export only 42222 72 Person User ii ne Masai REF INR YR en ee ti AES E 73 Person category u ee ee neh RIPE aer ERREUR ER RI RO eee RR EE eR IE 74 Aled zo oh coe are Mbps De ee OPE DM AE PORE ICE E IL ISI IE LIE 75 Ared event 1eme sess OE beet en eu os testi dune ion aa de IA eet 77 Ared cdtegory essi Aer dos EEE see V IR HORDE EE anse 80 Area event category c esse ove VEO XA epe RR CHE E eis Va ee e ey 81 vi Picture Perfect Import Export User Manual Figures Figure l Examipleof person TECOS aiii e eee una ln aa 19 Figure 2 Example of person record update sette ttttttetteenennnntnntnntestntsttoctttttttttte 19 Figure Example of badge record Mi a recette tertii dedere Ete i RU eio 19 Figure 4 Default Badge Encode Format nn 21 Figures Sample query host bid Todocoleccion 21 Figure 6 Table layout Example Linn ici idos elites 56 Figure 7 Table Layout EXAMPlS linia alleine 56 vii Preface This manual is intended for systems integrators and or network programmers seeking methods for connecting to
70. ne or more meaningful error messages for each rejected record Each error message is preceded by the input file s record number and is terminated with a newline character If the errnum component is non zero the server was unable to open or read either the output or error file The errnum component corresponds to the server s errno value The cause component indicates the file and the access mode that failed conforming to the following conventions define SRV OUTFILE OPEN ERR define SRV ERRFILE OPEN ERR define SRV OUTFILE READ ERR define SRV ERRFILE READ ERR define SRV EXPORT EXEC ERR Couldn t open the output file Couldn t open the error file Couldn t read the output file Couldn t read the error file Couldn t exec a database program H HH OP 0 NN H If the RPC call fails completely a NULL pointer is returned Chapter 5 Remote Procedure Call Interface Export Service The Export service is used to request records from the Picture Perfect database using standard SOL SELECT statements The exception to this rule occurs when a select is made for all of the columns of either the area area event or person table forexample SELECT FROM person WHERE id 100 Because the table structure has changed in Picture Perfect to accommodate the user s ability to export data modify it then import it back into the Picture Perfect database the importd server s export function has been modified so an
71. ng hwdata 0 14 1 1 noarch rpm package hwdata 0 14 1 1 is already installed INFO Updating Red Hat patches was successful The INSTALLation has completed The system needs to be rebooted for the changes to take effect Reboot the system y n y Installation of the Import Export package is complete Type y to reboot your system 4 Picture Perfect Import Export User Manual Chapter 2 Functional overview This chapter provides an overview of the functions of your Picture Perfect Import Export package and things you should consider when using it In this chapter p rg PP ee 6 Preparation TOF TUPO dc erede Ree mot Wine tto b Menke Rh dn 6 BOOTS ise ESPERE pose xn edi olo eie polen pce olor tique 6 Preparation Tor BB en hob eS Deeds ede ee us 6 Things to Think About eec de na eR CUR eR ev RA eg 7 Picture Perfect Import Export User Manual Import Import means bringing information into the Picture Perfect database from another source and is used to eliminate entering identical information into more than one database For example if personnel information such as name address department identification number and employment status is already available in a Human Resources database that information can be imported into Picture Perfect as personnel data Access control information can then be added to it either as it is being formatted for import or after it has been imported Personnel
72. ng rows from the current and rollover badge history tables Statement SELECT last name bid reader desc FROM badge history WHERE bid LIKE 00124 AND host xact date BETWEEN 20050101 AND 20050105 UNION SELECT last name bid reader desc FROM badge historytmp WHERE bid LIKE 00124 AND host xact date BETWEEN 20050101 AND 20050105 ORDER BY 1 Chapter 4 Exporting data Resolving Intertable Dependencies Many columns contain pointers into other tables to conserve space and minimize data redundancy Pointers indicate the record identification number of the record in a referenced table To retrieve the record description rather than the pointer compare the pointer value to the record ID in the referenced table as in the following example Also note the use of the qualified column names badge history area and area id to remove all doubt as to where the column resides badge history or area Requirement Retrieve the last name badge encode number area and reader descriptions of all badges with 00124 as the first 5 digits of the badge encode number that were used January 1 through 5 2005 sorted by last name merging rows from the current and rollover badge history tables Statement SELECT last name bid area description reader desc FROM badge history area WHERE bid LIKE 00124 AND badge history area area id AND host xact date BETWEEN 20050101 AND 20050105 UNION SELECT last name bid area description rea
73. o 40 bytes 40 Address 2 16 address3 1 to 40 bytes 40 Address 3 17 address4 1 to 40 bytes 40 Address 4 18 address5 1 to 40 bytes 40 Address 5 59 60 Picture Perfect Import Export User Manual Table 13 Person o0 E Column name Range value Length Meaning 19 phone 1 to 30 bytes 30 Phone 1 Primary phone number 20 phone2 1 to 30 bytes 30 Phone 2 Alternate phone number 21 reissue_cnt 1to 99 2 Reissue Count The number of times the badge has been issued 22 apb 0 1 2 3 11 Anti passback Should be set to 0 for new badge inserts Antipassback status O Neutral 1 In 2 Out 3 Privileged 23 reader 1to 11 Reader 2 147 483 647 The reader that last granted access to this person 24 access_date gt 19000101 11 Access Date Date in the form yyyymmdd Automatically supplied by the system 25 access_time 0 to 235959 11 Access Time Date in the form yyyymmdd Automatically supplied by the system 26 access tz 0 11 Time Zone UTC Automatically supplied by the system 27 active date 19000101 11 Activation Date Date in the form yyyymmad Automatically supplied by the system if left blank during inserts 28 active time 0 to 235959 11 Activation Time Time in the form hhmmss Automatically supplied if left blank during inserts 29 active_context 0 1 2 11 Time Context Time zone context O Host 1 Micro 2 Operator 30 deactive_date gt 19000101 11 Deactivation Date Date in the form yy
74. om the command line using the hostname command Bytes 24 31 Picture Perfect Operator Login Name 8 bytes A valid Picture Perfect operator login name with a Permission that allows access to the table being modified by the import write and execute access to the input output and error file directories and write access to the input output and error files themselves Bytes 32 39 Reserved 8 bytes Must be spaces Bytes 40 41 Transaction Code 2 bytes Controls the import function 31 Update existing records in any table with an operator activity transaction for each modification e Each input data record must have the employee number of a valid Picture Perfect operator added as an extra field at the end of the record Ifthe table is not the badge table the id field must never be blank e Ifthe table isthe badge table either the id orthe bid must be included Chapter 3 15 Importing data 32 Update existing records in any table with one operator activity transaction for the entire import function e Ifthe table is not the badge table the id field must never be blank e Ifthe table isthe badge table either the id orthe bid must be included 33 Insert new records in any table e Badge encode number must be included for badge records e Import creates record id 34 Insert new badge record s e Badge encode number must be included for badge records e Import creates record id e Application Header byte 123 controls the
75. ord number Foreign key to id field in area event table Record number in badge table ofthe area event the category is in 3 category id 1tomaximum 11 Category Id record number Foreign key to id field in category table Record number of in category the category onthe area event with area event id table 4 slot number 1to 96 11 Slot Number Slot number the category is assigned to 5 facility 1to 11 Facility 2 147 483 647 Foreign key to id field in facility table Record number of the facility this record is in 6 modify_date gt 19700101 11 Modify Date Modification date in the form yyyymmdd System will supply the current date if no date is provided 7 modify time 0 to 235959 11 Modify Time Modification time in the form hhmmss System will supply the current time if no time is provided 81 82 Picture Perfect Import Export User Manual Title of this book Picture Perfect 4 0 Import Export User Manual My overall rating of this book Excellent Very good Good What liked most about this book Satisfactory Fair Poor What I would change add delete etc in future editions of this book Please return this form to Attn Technical Writing GE Security 791 Park of Commerce Blvd Suite 100 Boca Raton FL 33487 or e mail your comments to betdocs ge com North America T 561 998 6100 T 888 GE SECURITY
76. p err ABadge Table Update by Colvin VCR 0 24 ciclo l v in 32 40 42 60 6162 b la 76 77 d g eli Imp po lu ft N b la Id 91 92 gei mp er Ir A B a Id g 107 e Tlalbllle Ulp d a ti e 122 123 124 125 127 Picture Perfect Import Export badgeimp out N badgeimp err A Badge Table Update by Colvin V CR User Manual b Col vi mn C IR A ASCII input data 0000000 New lines saturn Computer s network hostname ccolvin Operator to own the import 32 Transaction code update records in table badge Name of Picture Perfect table to be modified Column delimiter vertical bar Record delimiter new line Output data filename in cas export Overwrite the output file Error file name in cas export Append to the error file User comment fields 1 and 2 Update valid badges only Import signature Header terminator carriage return Chapter 3 19 Importing data Examples of Import Data Files Person and Badge record inserts and updates Employee information is stored in several different tables in the Picture Perfect database These include person badge person user andperson category Import Export allows you to create a single record containing all relevant data for an employee and the system will automatically insert the appropriate information into the various
77. partment Description Refer to Appendix A Table layouts for any required fields for the particular table to which you are adding records Be sure to read the notes on page 56 12 Picture Perfect Import Export User Manual e When adding personnel records make sure the departments referenced already exist in the Picture Perfect database If not add the required departments to the Department table before adding the personnel records If the departments do not exist when the personnel records are added an error will result e Adds to a Picture Perfect Enterprise system are handled as follows e Any inserts into the Badge or Person table on a subhost are inserted into the network host Badge or Person table first Then upon a successful insert into the network host Person table if there is any user or category data on the personnel record the associated person user and person category records are first created on the network host then on the local subhost If the person user and person category records are inserted successfully the personnel record is inserted into the local subhost with the same ID obtained from the network host If the network is down a badge or person insert will not be allowed e Import Export prevents insertion of a category department or permission group record on a subhost Since these tables are global in a network they can only be inserted on the network host Database Updates Changes updates to any tabl
78. port User Manual Appendix A Table layouts This appendix provides layouts for the various Picture Perfect tables In this appendix D rl EET 56 Alarm History export only 2 57 POP 20 O E E E E E T 59 Badge History export only 62 Doo RCM EE ETT 66 IE COPY cere quus eere es verd ene VUE Senate d eia ea eben deg ace 69 4 70 EE 69 LED Le oix serm Ana ie DERE UC ee p COO Ota 70 Iu DI PER na en nee na ws 71 Operator History export only loue een en 72 PORON MEI ia bh ees en UR V rdi die 73 Person CERO UE Su Notar MUR NR Rate e a et 74 Dio CDL 75 UE E URINE cursus a Ayan do da de Dos IRA ahh Du net 77 A ci lois ee eh ee Fae E E ER ta 80 RAT EVER CAISEOFY ossidi dreda eoe e e Race BAH OHS 81 56 Picture Perfect Import Export User Manual Notes Note Note Note In some cases certain fields require data in order to import the record successfully In the following tables required fields are marked with a double asterisk Fields which may be required depending on transaction type are marked with a single asterisk When populating the badge table from a one time download it will be absolutely necessary to populate the host bid format tables before attempting to insert any badge records In addition if the badge record contains a value inthe bid format id or facility field then the Picture Perfect host bid format and facility tables must be
79. r Command Line Queries 5 eg ee en Lo E A besa ii das 24 SOT OBEREN ie D Luna etr esee ede e e ette 27 FOOTING History Dia ae cere eR CAS weeks eR CREAR S 28 30 o ba Oke DE RE doo woe Pome i 24 Picture Perfect Import Export User Manual Command Line Queries There are several selection commands available for exporting data Picture Perfect selection commands reside in cas bin If your PATH environment variable does not contain the cas bin directory it is necessary to add cas bin to your PATH or prepend each of the commands with cas bin When displaying information one screen at a time follow the command below with a broken vertical bar pipe sign andthe word more as shown in the following example query badge more Press for the next screen for one more line and Q to quit early and return to the command line prompt Note String or character values must be surrounded by quotes The quotes surrounding strings must be different from the type used to envelop the SELECT statement For example since single quotes are used to envelop the SELECT statement below double quotes must surround the like CAFE96 clause selectrpt select id description from area where description like CAFE This rule applies to all of the commands discussed in this manual selectcol Syntax selectcol table name Description Displays the column name and type of each field in the table name to the terminal only Example
80. r field 1 When populatingthe area or area event tables the format of the record being inserted MUST include the pipe delimiters at the end of the basic structure to accommodate the possibility of an extra 32 categories even if no categories are being assigned If an update transaction type 31 Update existing records in any table with an operator activity transaction for each modification is being performed then the required extra employee number field will occur afterthe area or area event record and before the required additional 32 category fields Alarm History export only Table 12 Alarm History export only COL Column name Range value Length Meaning 1 id 1to 11 Unique Id 2 147 483 647 Unique record number assigned by system 2 input_group 1to 11 nput Group 2 147 483 647 Foreign key to id field in input_group table 3 input desc 1 to 60 bytes 60 nput description 4 alarm desc 1 to 60 bytes 60 Alarm description 5 micro 1to 4096 20 Micro Micro address 6 operator 1 to 8 bytes 8 Operator Responding operator login name 7 bid 1to 16 bytes 16 Badge Encode Number Responding operator badge encode number 8 physical state 1to5 8 Input State 1 Short 2 Cut 3 Open 4 Closed 5 N A 9 logical_state 1to3 7 Condition 1 Alarm 2 Reset 3 Tamper 10 process_state 1to8 9 Process State 1 Active 2 Bumped 3 Notified 4 Remote Notified 5 Pending 6 Completed 7 Remov
81. ross vendors libraries there could be nuances specific to a given vendor s library that would make it impossible to compile and link to relocatable object files without the ability to make minor modifications The client application programmer should begin by getting the demonstration program to compile and link Very few changes to the source code should be needed to accomplish this The program should then be tested with a Picture Perfect host upon which the Import Export package is installed After the program is functional and all of the services are verified it is suggested that the programmer make a copy of the working version of code and replace the top level functions supplied with the demonstration program with his or her own customized functions designed to be called from within the customer s application After the Import Export package has been installed the toolkit will be found in the directory usr rpc A makefile must be written for DOS Windows environments It is necessary to set the following flags and pass them to the compiler depending upon the environment Table 4 Set flags OS type define Microsoft C define MSDOS AIX 5L define _AIX52 define _AIX53 Linux define LINUX VM define VM MVS define MVS Chapter 5 37 Remote Procedure Call Interface The Test Program client This program when operational exercises each of the three services Its usage is shown below notice tha
82. s export function has been modified so an export performing a SELECT FROM person area Ofarea event Will result in records from the updated table structure plus the categories from the associated sub table appended to the end of each record If the user wishes to get records from just the base table then an accommodation has been made so for these three tables if the user uses a SELECT ofthe form SELECT FROM the additional sub table records will not be retrieved This feature is applicable whether the client program is being used or the user s own RPC client program is being used p num Optional Requests that the client connect to a specific server process at sites where multiple instances of the server are running Each server running is invoked with a numeric parameter beginning with zero This allows the Picture Perfect host to handle multiple requests concurrently 38 Picture Perfect Import Export User Manual Application Layer Services Each of the three services are accessed by calling the function associated with that service The three functions are long client verify V1 export r client import V1 export r client export V1 The results of the successful execution of these functions are interpreted based on the operation being performed With the exception ofthe verify service a pointerto an export r data type is returned The structure ofthe export r datatype is shown below type
83. st table entry for the specified host contains the wrong Internet address Check the client host table to verify that the Internet address is correct for the Picture Perfect host Rpc error the remote program is not registered The specified host is not running the importd server Shared memory allocation error You are sending in updates with operator history logging too fast for the system to process Restart Picture Perfect and send your import transactions in slower SQL error num connecting to database Verify that Picture Perfect is up and running then check your environment to make sure it can reach the database Too few fields in record Check the import record to see if it has less fields than the table in Picture Perfect Verify that the table layout is followed Too many fields in record Check the import record to see if it has more fields than the table in Picture Perfect Verify that the table layout is followed Total valid transactions num Total error transactions num Total transactions valid error This is the summary report of what happened at the end of the import 4 PS must be running operation not allowed Verify that Picture Perfect is running Update attempted on non existent record Check the id of the record to make sure it exists in Picture Perfect c pdate not allowed on badge with invalid status 4 5 6 The status updat
84. support representative 40 Picture Perfect Import Export User Manual Application Related Errors Application errors will always result in the successful execution of the remote procedure call and a non NULL export r pointer but the requested operation fails due to some application dependent problem An application error is indicated by a non zero bad component It is possible for both the good and bad components to be non zero An example of an application error might be a syntax error in the SOL SELECT statement that contains an export request Another example might be an incorrectly formatted application header A third example might be the inclusion of a department ID ina person record where the department is non existent in the Picture Perfect database These types of errors are slightly more difficult to diagnose since a working knowledge of Picture Perfect s operation may be required The best way to approach these problems is to enable full debugging using the verify function and repeat the procedure After the operation completes check the import log on the Picture Perfect host for further diagnostics Verify Service The Verify service is used to check connectivity between the client and server application programs It is similar to the TCP IP ping command except that it tests the communications link between the application and presentation layers whereas the ping command tests the communications link at the network
85. t h host is required with all variations of the program s usage cas bin client p num h host v integer verify cas bin client p num h host f file import cas bin client p num h host s select export Table 5 Test program options Usage Description h host Required Specifies the name or dotted decimal Internet address of the Picture Perfect host running the server v num Specifies that the number num is to be used to verify that the Picture Perfect server is responding The value of num also forces the debug level at the host The debug level is set to the value num mod 10 for the duration of the next operation When debugging is set to a high level detailed information about the server process is written to the Picture Perfect log The server automatically resets the debug level to zero after the next import or export operation in order to prevent log files from growing too large f input file Specifies the name of a file containing one or more records to be imported into Picture Perfect preceded by a valid presentation and application header s select Specifies that the string inside the quotation marks is an SQL SELECT statement Note To accommodate the user s ability to export data modify it then import it back into the Picture Perfect database for the three tables which have had their categories and in the case of the person the user fields as well stripped out the importd server
86. t enter the ID corresponding to that badge format when creating the input record To determine your default badge format From the Picture Perfect primary navigation menu select Setup then Parameters then click the Badging tab The current default badge format will be displayed Figure 4 Default Badge Encode Format Sf System Parameters System Parameters Printers Imaging Terminals Badge Designs Custom Lists System Parameters Backup Dirt 2 m E me A AI FAX SEO Parameters tars Y Badging Defautt Badge Encode Format E Standard 10 Digit Badge lt GLOBA w EY m Badge Design LI image Types Results 1 records To import badge records that are of a different format than the default 1 From a command prompt type query host bid format A screen similar to the following will display Figure 5 Sample query host bid format dtterm Window Edit Options This column represents the ID corresponding to the p gt host BID format C Cn Lo MM E xn J 2 Make a note of the ID corresponding to the host BID format you will be importing This number must be entered as the bid_format_id field when inserting badges 22 Picture Perfect Import Export User Manual Chapter 4 Exporting data This chapter describes how to export data through the use of command line queries using SQL syntax In this chapte
87. to 24 bytes 24 Manager Manager s name phone 1to 30 bytes 30 Phone Telephone number userl 1to 60 bytes 60 User 1 user 1to 60 bytes 60 User 2 facility 1to 11 Facility 42 147 483 647 Foreign key to id field in facility table Record number of the facility this record is in modify date 19000101 11 Modify Date Modification date in the form yyyymmdd System will supply the current date if no date is provided modify time 0 to 235959 11 Modify Time Modification time in the form hhmmss System will supply the current time if no time is provided Host BID Format Table 19 Host BID Format Column name Range value Length Meaning id 1to 11 Id 2 147 483 647 Unique record number assigned by system except when using transaction type 35 description 1 to 60 bytes 60 Description bid_format 1 to 22 bytes 22 Badge Id Format C style format string used to verify and display BID facility 1to 11 Facility 2 147 483 647 Use 1 when inserting a new badge record modify_date gt 19000101 11 Modify Date Modification date in the form yyyymmdd System will supply the current date if no date is provided modify_time 0 to 235959 11 Modify Time Modification time in the form hhmmss System will supply the current time if no time is provided 71 72 Picture Perfect Import Export User Manual Operator History export only Table 20 Operator History export only
88. ver of badge history When exporting badge history data you may select data from either table The most recent history data is in the badge history table The older badge history is in badge historytmp Both have the same table layout For tracking time and attendance information use one of the transaction date xxx xact date and transaction time xxx xact time columns from the badge history table Operator History Picture Perfect maintains two operator history tables operator his andoperator histmp Operator transactions are inserted into the operator his table until itreachesthe opr hissize parameter located in the system config table accessed through the System Parameters form When the number of operator history transactions reaches the threshold or percentage of the opr hissize the operator his table is renamed to operator histmp and the system displays a window telling the operator to archive the operator history data The system then drops the current operator his table and recreates it as an empty table New transactions are then inserted into the empty operator his table while the older transactions reside in the operator histmp table until overwritten by the next rollover of operator history When exporting operator history data you may select data from either table The most recent history data is in the operator his table The older operator history is in operator histmp Both have the same table layout 30 Picture Perfe
89. wed by corresponding data Example selectrpt select id description from area where description like CAFE An example of the output produced by the above command might be id 1 description CAFETERIA MAIN DINING ROOM id 2 description CAFETERIA HIGH SECURITY id 3 description CAFETERIA LASER LAB id 4 description CAFETERIA OIL RECOVERY RESEARCH id 5 description CAFETERIA HYDROCARBONIC LAB 26 Picture Perfect Import Export User Manual selectfile Syntax selectfile SQL statement file Description Writes results of SQL Select Statement with delimiters to the disk file file one record per line Lines exceeding 80 characters in length will wrap to the next line Example Selectfile select from person where id 9 person dat There will be no visible output for this command unless an error occurs An example of the output from the above command might be contents of person dat Selectfile select from person where id 4 person dat jo 234 John smitn ss 0 2 20061113 150632 1 20061110 1 a4359 o o 1 20061114 194827 2 0 3 4567 dohnny Smitka gs loJ2 20061113 150632 1 2006121 155351 0 1 20061212 205442 3 o 1 7890 John Rice JR Jo 2 20061113 150632 1 20061212 15 626 0 1 20061212 205648 Chapter 4 27 Exporting data SQL Queries Syntax Since SQL keywor
90. word DESC after the column name in the ORDER BY clause 28 Picture Perfect Import Export User Manual Special Words and Symbols Table 1 Wildcard Selection Criteria KEYWORD SYMBOL MEANING LIKE 96 Multiple characters underscore Single character MATCHES Multiple characters Single character IN Compare something to any one of the values within the parentheses BETWEEN x and y Any valid value in the contiguous range x through y inclusive Table 2 Equality Comparison Operators SYMBOL MEANING Equal to Character strings must be defined using either quotations string or apostrophes string gt Greater than gt Greater than or equal to lt Less than lt Less than or equal to Not IS NULL Column has no data not the same as a value of zero IS NOT NULL Column has data entered Exporting History Data Three types of history transactions can be exported from the Picture Perfect system These are Alarm History Badge History and Operator History Alarm History Picture Perfect maintains two alarm history tables alarm history andalarm historytmp Alarm transactions are inserted into the alarm history table until it reaches the alm hissize parameter located in the system config table accessed through the System Parameters form When the number of alarm history transactions reaches the threshold or percentage of the alm
91. y category32 2 147 483 647 fields on an area event record 79 80 Picture Perfect Import Export User Manual Area category Table 25 Area category COL Column name Range value Length Meaning 1 id 1to 11 Id 2 147 483 647 Unique record number assigned by system except when using transaction type 35 2 area_id 1tomaximum 11 Area Id record number Foreign key to id field in area table Record number of the in badge table area the category is in 3 category id 1tomaximum 11 Category Id record number Foreign key to id field in category table Record number of the in category category on the area with area id table 4 slot number 1to 96 11 Slot Number Slot number the category is assigned to 5 facility 1to 11 Facility 2 147 483 647 Foreign key to id field in facility table Record number of the facility this record is in 6 modify_date gt 19700101 11 Modify Date Modification date in the form yyyymmdd System will supply the current date if no date is provided 7 modify time 0 to 235959 11 Modify Time Modification time in the form hhmmss System will supply the current time if no time is provided Area event category Table 26 Area event category COL Column name Range value Length Meaning 1 id 1to 11 Id 2 147 483 647 Unique record number assigned by system except when using transaction type 35 2 area event id 1tomaximum 11 Area Event Id rec
92. yymmdd 31 deactive_time 0 to 235959 11 Deactivation Time Time in the form hhmmss 32 deactive_context 0 1 2 11 Time Context Time zone context O Host 1 Micro 2 Operator 33 force_download 0 11 Download Upon Save Set to 0 Not used by Import Export 34 facility 1 to 11 Facility 2 147 483 647 Foreign key refers to id field in facility table Record number of the facility this record is in Table 13 Person o0 E Column name Range value Length Meaning 35 modify_date gt 19000101 11 Modify Date Date in the form yyyymmdd System will supply the current date if no date is provided 36 modify time 0 to 235959 11 Modify Time Time in the form hhmmss System will supply the current time if no time is provided 37 76 userl user40 40 bytes each 40 User comment column There are 40 user fields user1 through user40 77 172 Category1 1to 2 147 483 647 11 Foreign keys to id s in category table There are 96 category Category96 fields category 1 through category 96 173 203 Badge fields 1 The badge portion of the record 1 1 For information on the badge fields see Badge on page 66 61 62 Picture Perfect Import Export User Manual Badge_History export only Table 14 Badge History export only COL Columnname Range value Length Meaning 1 id 1to 11 Unique Id 2 147 483 647 Unique record number assigned by system 2 bid 1to

User Manual

Contents

Download Pdf Manuals

Related Search

Related Contents