background image

MarkVision Professional 10.2

June 1, 2004

MarkVision Professional 10.2

Page 6

2.2.1 Microsoft 

Access

From the System DSN dialog box, click “Add” and the following dialog box will appear.  Select
Microsoft Access Driver (*.mdb) and click “Finish.”

After clicking “Finish”, the following dialog box will appear.  Think of a name for your connection
and type it into the “Data Source Name” (DSN) field, and then type a description for the data

Содержание MarkVision Professional

Страница 1: ...MarkVision Professional 10 2 Data Export June 1 2004 Lexmark International Inc 740 New Circle Road Lexington KY 40550...

Страница 2: ...information you supply in any way it believes appropriate without incurring any obligation to you You can purchase additional copies of publications related to this product by calling 1 800 553 9727...

Страница 3: ...OPTION 22 3 2 9 RAWPIINPUTOPTION 23 3 2 10 RAWPIINPUT 24 3 2 11 RAWPIOUTPUTOPTION 24 3 2 12 RAWPIOUTPUT 25 3 2 13 RAWPIDEVICESTATUS 27 3 2 14 RAWPISTATSJOBS 27 3 2 15 RAWPISTATSPAPER 28 3 2 16 RAWPIST...

Страница 4: ...MarkVision Professional 10 2 June 1 2004 MarkVision Professional 10 2 Page 4 6 Data Type Conversion 54...

Страница 5: ...7 2000 2002 Comma separated variable CSV NOTE The Oracle database option is only available after installing the up to date MVP Plug in for Oracle JDBC Driver support 2 1 2 UNIX Oracle versions 8i thro...

Страница 6: ...System DSN dialog box click Add and the following dialog box will appear Select Microsoft Access Driver mdb and click Finish After clicking Finish the following dialog box will appear Think of a name...

Страница 7: ...ready created for this purpose or choose Create to define a new database and location Click on Create and the following dialog box will appear Browse to the desired directory and specify a name to be...

Страница 8: ...the path to the actual database file this was defined while creating the connection For the example just described enter jdbc odbc MVP If you have enabled security features while creating the database...

Страница 9: ...ng the properties button in Windows 2000 and beyond Select This Account to log on to the new machine as a user with appropriate network access privileges and click OK 2 2 2 SQL Server The method for c...

Страница 10: ...r the user name and password and click on OK 2 4 CSV Users may elect to export database information to a CSV format In MarkVision Professional after selecting the CSV database selection the Directory...

Страница 11: ...ation gathered by the printer inventory process to answer questions such as How many printers do we have on our server s network What types of printers do we have What options are installed on our pri...

Страница 12: ...arkVision Professional 10 2 Page 12 3 1 Configuring MarkVision Professional Open the MarkVision Professional client Select Actions on the toolbar and then Printer Inventory from the drop down list or...

Страница 13: ...Follow database specific instructions in the Configuring Database Driver section 3 2 Table and Field Descriptions The tables and descriptions of each field are listed below The data types listed for e...

Страница 14: ...ntory was initiated MONTH NUMBER 2 MVP 7 1 Month in which this device inventory was initiated DAY NUMBER 2 MVP 7 1 Day of the month in which this device inventory was initiated DAY_OF_WEEK NUMBER 1 MV...

Страница 15: ...VP 7 1 Model name of device SERIAL_NUMBER VARCHAR2 32 MVP 7 1 Device serial number RAM_SIZE NUMBER 10 MVP 7 1 Total amount of main memory on this device SPEED NUMBER 10 MVP 7 1 Speed at which this dev...

Страница 16: ...lable on certain older printers WARNING Only valid with job buffering version 1 See the device s capability list IS_COMMUNICATING VARCHAR2 1 MVP 7 1 Always set to Y MAC_ADDRESS VARCHAR2 12 MVP 7 1 The...

Страница 17: ...performs SQL queries on the printer inventory data should check the DATA_READY field before displaying that data to the user If DATA_READY N this row should be ignored along with any data correspondin...

Страница 18: ...itiated in seconds elapsed since 0 00 00 Jan 1 1900 GMT VERSION NUMBER 5 MVP 7 1 Version of the data format used in this table NAME VARCHAR2 64 MVP 7 1 Physical port name Possible Values Fax n 4 n 1 I...

Страница 19: ...is interpreter supports in this printer defined as the resolution in the direction 90 degrees to the feed or motion of the print media VERT_RESOLUTION NUMBER 5 MVP 7 1 This value defines the maximum v...

Страница 20: ...the type of supply This attribute is always present Possible Values Container Drum Fuser Ink Oil Process Cartridge Staples Toner Transfer Belt Print Head Thin Coat Fuser Cleaner Pickup Roller COLOR VA...

Страница 21: ...is information will not be available on every printer family 3 2 6 RAWPIFONTOPTION This table contains records pertaining to the fonts available on the selected device Field Name Data Type Supported M...

Страница 22: ...e data format used in this table NAME VARCHAR2 64 MVP 7 1 Item to which the listed CODE_LEVEL applies e g engine flash panel etc CODE_LEVEL VARCHAR2 50 MVP 7 1 Code version of the item indicated by NA...

Страница 23: ...T_TIME_UTC NUMBER 10 MVP 7 3 Time at which this device inventory was initiated in seconds elapsed since 0 00 00 Jan 1 1900 GMT DEVICE_ID VARCHAR2 255 MVP 7 3 String identifier MarkVision uses to ident...

Страница 24: ...name CAPACITY NUMBER 10 MVP 7 1 The capacity CAPACITY_UNITS VARCHAR2 40 MVP 7 1 The units CURRENT_LEVEL NUMBER 10 MVP 7 1 The current level FORM_SIZE VARCHAR2 40 MVP 7 1 The form size FORM_TYPE VARCH...

Страница 25: ...ome fields For more specific information please contact Lexmark Customer Support at http support lexmark com START_TIME_UTC NUMBER 10 MVP 7 1 Time at which this device inventory was initiated in secon...

Страница 26: ...pports this feature Possible values Y for true N for false IS_COLLATION VARCHAR2 1 MVP 7 1 Specifies if this output device supports this feature Possible values Y for true N for false IS_SEPARATION VA...

Страница 27: ...Empty Input Low Tray Missing LOCATION_ID VARCHAR2 64 MVP 10 0 Specifies the Input Trays like Tray 1 Tray 2 GRAPHIC_ID NUMBER 3 MVP 10 0 Specifies the graphic Id SEVERITY VARCHAR2 32 MVP 10 0 Specifies...

Страница 28: ...the data is expressed Possible Values Pages Percent DATA NUMBER 10 MVP 10 0 Column Column value will exist For Single record Type CAPACITY NUMBER 10 MVP 10 0 Column Column value will exist For List re...

Страница 29: ...Plain Paper Colored Paper Transparency Card Stock Labels Letterhead Preprinted Bond Envelope Coated Paper Glossy Paper Iron On Photo Paper Greeting Card Custom Type 1 Custom Type 2 Custom Type 3 Custo...

Страница 30: ...please contact Lexmark Customer Support at http support lexmark com DEVICE_ID VARCHAR2 255 MVP 10 0 String identifier MarkVision uses to identify this device START_TIME_UTC NUMBER 10 MVP 10 0 Time at...

Страница 31: ...r Statistics Field Name Data Type Supported MVP Release Description Note All printers may not support some fields For more specific information please contact Lexmark Customer Support at http support...

Страница 32: ...MVP 10 0 The type of value Possible Values Integer Date Float UNITS VARCHAR2 64 MVP 10 0 The unit in which the data is expressed Possible Values Pages Percent DATA NUMBER 10 MVP 10 0 Column Column val...

Страница 33: ...AR2 255 MVP 10 0 String identifier MarkVision uses to identify this device START_TIME_UTC NUMBER 10 MVP 10 0 Time at which this device inventory was initiated in seconds elapsed since 0 00 00 Jan 1 19...

Страница 34: ...Inventory is RAWPRNINV with one to many relationships established between the top two fields DEVICE_ID and START_TIME_UTC NOTE The new table for MVP 7 3 RAWPIINPUTOPTION has the same relationship val...

Страница 35: ...MarkVision Professional Job Statistics Trend Analysis tells the printer to send an alert to the server each time a job is sent Job Statistics Collect From Disk tells the selected printer s to store t...

Страница 36: ...abase Follow database specific instructions in the Configuring Database Driver section The Selected Printers list display any printers you have asked the server to monitor for Job Statistics alerts Th...

Страница 37: ...e status tables when an error or warning condition is encountered Please see the Device Status section for more information This will increase network traffic 4 1 2 Job Statistics Collect From Disk Op...

Страница 38: ...ng screen should be displayed Select the Add button to add scheduled events for Job Statistics Collect From Disk The Add Schedule Wizard screen should be displayed Select the Job Statistics Collect Fr...

Страница 39: ...e scheduling parameters as desired and click Next Step 3 of the Add Schedule Wizard should be displayed Select the appropriate database Follow database specific instructions in the Configuring Databas...

Страница 40: ...and Field Descriptions The tables and descriptions of each field are listed below The data types listed for each field listed are specific to Oracle databases Please reference the Data Type Conversio...

Страница 41: ...was detected by MarkVision MONTH NUMBER 2 MVP 7 1 Month in which this job was detected by MarkVision DAY NUMBER 2 MVP 7 1 Day of the month on which this job was detected by MarkVision DAY_OF_WEEK NUMB...

Страница 42: ...The sheet count ERROR_CODE VARCHAR2 32 MVP 7 1 Possible Values None No Dial Tone No Answer Busy Line Dropped Error In T30 Protocol Modem Error Out Of Memory Cancelled ACCOUNT_NUMBER VARCHAR2 32 MVP 7...

Страница 43: ...device JOB_ID NUMBER 5 MVP 7 1 Job id assigned by device VERSION NUMBER 5 MVP 7 1 Version of the data format used in this table YEAR NUMBER 4 MVP 7 1 Year in which this job was detected by MarkVision...

Страница 44: ...hat submitted this job FORMAT VARCHAR2 32 MVP 7 1 Possible Values PDF JPEG TIFF COMPOSITION VARCHAR2 32 MVP 7 1 Possible Values 1 Bit 3 Bit 4 Bit 8 Bit 24 Bit 32 Bit DESTINATION_TYPE VARCHAR2 32 MVP 7...

Страница 45: ...ected by MarkVision DAY_OF_WEEK NUMBER 1 MVP 7 1 Day of week on which this job was detected by MarkVision HOURS NUMBER 2 MVP 7 1 Hour of the day in which this job was detected by MarkVision MINUTES NU...

Страница 46: ...n 4 n 1 Internal n 3 n 1 LocalTalk n 4 n 1 Network n 6 n 1 Parallel n 4 n 1 Serial n 4 n 1 USB n 4 n 1 NetworkStd JOB_SIZE_IN_BYTES NUMBER 10 MVP 7 1 The size of the job INTERPRETER_NAME VARCHAR2 32...

Страница 47: ...t the time of this job DESTINATION_TYPE NUMBER 3 MVP 7 1 The destination type JOB_NAME VARCHAR2 150 MVP 7 1 Name associated with this job HOST_NAME VARCHAR2 55 MVP 7 1 The name of the host machine USE...

Страница 48: ...Failure Staple Too Many Pages Failure Printer Sent Command To Flush Output Bin Changed Failure Paper Jam Failure Staple Jam failure Other Failure PUNCHED VARCHAR2 1 MVP 10 0 Indicates punching status...

Страница 49: ...VARCHAR2 64 MVP 7 1 Possible Values Envelope Feeder Feeder 2 Manual Envelope Feeder Manual Paper Feeder Multipurpose Feeder Tray n where 5 n 1 SHEET_COUNT NUMBER 10 MVP 7 1 Number of physical sheets e...

Страница 50: ...acity of the supply CURRENT_LEVEL NUMBER 10 MVP 7 1 The current level Used by MarkVision Professional to calculate the percentage full CURRENT_PRINT_LEVEL NUMBER 10 MVP 7 1 The current print level Les...

Страница 51: ...Card Stock Labels Letterhead Preprinted Bond Envelope Coated Paper Glossy Paper Iron On Photo Paper Greeting Card Custom Type 1 Custom Type 2 Custom Type 3 Custom Type 4 Custom Type 5 Custom Type 6 SH...

Страница 52: ...curred Only the oldest and most significant status condition is populated in this table Reference the RAWDSDEVICESTATUS table for a complete description of all status conditions Field Name Data Type S...

Страница 53: ...sion server is running MESSAGE_ID VARCHAR2 255 MVP 7 1 The description of the alert LOCATION_ID VARCHAR2 255 MVP 7 1 The location of the device status alert SEVERITY VARCHAR2 32 MVP 7 1 The severity o...

Страница 54: ...he printer s op panel NOTE This information is not available on every printer model 5 3 Field Relationships 6 Data Type Conversion Data types are listed specific to Oracle databases When writing to Mi...

Страница 55: ...MarkVision Professional 10 2 June 1 2004 MarkVision Professional 10 2 Page 55 Oracle Microsoft SQL Server NUMBER x NUMERIC x VARCHAR2 x VARCHAR x...

Отзывы: