IDpack 9
IDpack ID Card Software for ID Card and ID Badge Design and Printing
Home Products Download Purchase How-To Video Support Contact
Home Products Download How to Buy How-To Video Support Contact
 Home » Support » IDpack Professional » IDP_USER

IDpack Professional v9
Online Help

Search the help

Get IDpack Help in your language

IconWelcome to IDpack 9
IconIntroduction
IconWhat's New
IconAbout IDpack 9
IconSystem Requirements
IconDocumentation conventions
IconLicense Agreement
IconInstall - Uninstall
IconInstall Instructions
IconUninstall Instructions
IconGetting started
IconIDpack Designer
IconIDpack Producer
IconIDpack File Extensions
IconKeyboard shortcuts
IconIDpack Designer Keyboard Shortcuts
IconIDpack Producer Keyboard Shortcuts
IconIDpack Designer
IconGetting Started
IconWorkspace
IconMenu
IconFile
IconNew Badge
IconNew From Template
IconOpen Badge
IconOpen Recent
IconOpen File Location
IconInsert
IconTools
IconBadge Setup
IconBadge Layout
IconPlastic ID Card
IconMagstripe Encoder
IconSmartcard Docking Station
IconPaper Format
IconCreate or Modify Paper Format
IconDymo LabelWriter
IconLabel Printer
IconProducer Setup
IconFolders
IconColor Code
IconSecurity
IconNone
IconBasic
IconAdvanced
IconDatabase Type
IconMicrosoft Access Database
IconODBC Database
IconField Definitions
IconImage Editor
IconOriginal Image Properties
IconEffects
IconCrop
IconFlip
IconResize
IconRotate
IconFilters
IconBrightness and Contrast
IconColorize
IconSharpen or Soften
IconLock Guidelines
IconHide Guidelines
IconClear all Guidelines
IconShow Dot Grid
IconIDpack Conversion
IconIDpack Update
IconBadge Properties
IconOptions
IconLanguages
IconToolbar
IconToolbox
IconPick Tool
IconGraphic Tool
IconDynamic Graphic Tool
IconDynamic Graphic File Tool
IconRectangle Tool
IconText Tool
IconDynamic Text Tool
IconDynamic Text Graphic Tool
IconNanoText
IconColor Code Tool
IconCustom Dynamic Text Tool
IconPicture Tool
IconBarcode Tool
IconBarcode
Icon2D Barcode
IconQR Code
IconDate Tool
IconSignature Pad Tool
IconFingerprint Tool
IconK-panel
IconColor Palette
IconStatus Bar
IconIDpack Producer
IconGetting Started
IconMenu
IconFile
IconOpen Badge
IconOpent Recent
IconOpen File Location
IconExport
IconPage Setup
IconPrint Buffer
IconPrint Badge List
IconLogout
IconEdit
IconReload List
IconSimple Find
IconFind Next
IconExtended Find
IconBadge List Find
IconBadge
IconAdd Badge
IconEdit Badge
IconDuplicate Badge
IconDelete Badge
IconSend to Buffer
IconMultiple Send to Buffer
IconActivity Log
IconCapture Picture
IconImport Picture
IconExport Picture
IconCapture Signature
IconImport Signature
IconCapture Fingerprint
IconTools
IconPrint all Badges in Badge List
IconPrint Selected Badges
IconPrint with Hologram Ribbon
IconGlobal Statistics
IconGlobal Activity Log
IconLock IDpack
IconCompact Database
IconDirect Command with Printer
IconClear Buffer
IconCamera Setting
IconPicture Filters
IconOptions
IconGeneral
IconBarcode
IconSignature pad / Fingerprint / Magstripe
IconContactless Smartcard
IconLanguage
IconToolbar
IconBuffer
IconQuick Find
IconPrint Activity
IconBadge List
IconExport Badge To
IconSort Order
IconList Find
IconBadge Information
IconPrint Preview
IconActivate in Designer
IconActivate in Producer
IconFind or Search Methods
IconSDK command Line
IconDatabase
IconDatabase
IconIDpack Database Structure
IconIDP_USER
IconIDP_STAT
IconIDP_SECURITY

IDP_USER

TABLE: IDP_USER

Field name

Data type

Length

Description

idp_id

AutoNumber, Primary Key

n/a

Unique Serial Number to identify a record

idp_colorcode

Number (Long Integer)

n/a

Number from 0 to 13 to specify a Color Code. If you are using a different coding system, you can create a table with 2 fields to match our system and link to it. If you do not use it, put NULL by default.

idp_desc1

Text, Number or Date/Time

250

Content field #1

idp_desc2

Text, Number or Date/Time

250

Content field #2

idp_desc3

Text, Number or Date/Time

250

Content field #3

idp_desc4

Text, Number or Date/Time

250

Content field #4

idp_desc5

Text, Number or Date/Time

250

Content field #5

idp_desc6

Text, Number or Date/Time

250

Content field #6

idp_desc7

Text, Number or Date/Time

250

Content field #7

idp_desc8

Text, Number or Date/Time

250

Content field #8

idp_desc9

Text, Number or Date/Time

250

Content field #9

idp_desc10

Text, Number or Date/Time

250

Content field #10

idp_desc11

Text, Number or Date/Time

250

Content field #11

idp_desc12

Text, Number or Date/Time

250

Content field #12

idp_desc13

Text, Number or Date/Time

250

Content field #13

idp_desc14

Text, Number or Date/Time

250

Content field #14

idp_insertdate

Date/Time

n/a

Insertion date of the record

idp_moddate

Date/Time

n/a

Last modification date of the record

idp_barcode

Date/Time

n/a

Last barcode scan date of the record

idp_picture

Date/Time

n/a

Last capture date of the record

idp_photos

OLE_Object

n/a

Picture saved to database table

idp_picturesize

Number

n/a

Binary size of saved picture to database table

idp_rdif


n/a

ART Code And/Or UID (Card ID) of a HID proximity card. Supports only HID's Omnikey reader.

clip0076Note

1.Field name can be changed to match your database fields. This will not affect the field labels used within IDpack Designer and

IDpack Producer as the labels are based on the Description field.

 

2.idp_id data type can be changed within IDpack Designer to one of the following data types.
String
Numeric (default data type)

 

3.idp_photos is the field where the capture or imported photo will be saved in the database.
OLE_Object is the MS Access data field type.
Varbinary(Max) is the Microsoft SQL data field type.
MediumBLOB is the MySQL data field type.

 

4.idp_picturesize is the field where the size of the data contain in the idp_photos field will be saved. The field will be automatically

    created when the badge is first open in Producer only if the option to save the picture to the database is selected

     in IDpack Designer.

     if not you will need to add this field manually.

 

 

You must set the data type when creating the Badge Layout and before opening the badge in IDpack Producer for the first time.

IDpack from InnoTechnix is the most comprehensive and flexible solution for ID card and ID badge production on the market. IDpack helps organizations enhance their security requirements with access control cards, membership cards, convention badges, Student ID cards, employee ID, event passes, library cards, and other identification needs.

About | Products | Partners | Download | Purchase | Support | News | Contact | All prices are in USD Dollars Terms of Use | Privacy Policy
IDpack is part of the InnoTechnix Network. © 1999 - 2013 - u:16