Updating a Database with New Image Records in CardStudio

Article ID: 51471091

Details


 

Description

CardStudio Professional provides a large selection of database connectivity options and image capture options.

Applies To

Zebra CardStudio Standard or Professional Software

Overview

One common use of CardStudio is to take pictures for new ID badges and to insert that data into a local or remote database.  In this article we show how to set up CardStudio to be able to realize this scenario.  We will use an Excel file database in our walkthrough and will store the file paths pointing to our created image in the 'Picture' column.  The empty Excel file is attached to the bottom of this solution and may be downloaded.  It is assumed that you have a working camera attached to your computer.  For a samples excel sheet, Read More>>

Procedure

1.  To start, we load up CardStudio Professional and load one of the template files that come with the installation.  Once loaded, we insert an 'image from video source' object on the canvas.

User-added image

2.  Now we must link this image to our database source so that the pictures taken from our camera will be stored to it.  Select the image and select 'Source' from the dashboard on the right.  We will choose 'Database, Point to Image File' and select 'properties' if not prompted with a new screen. 

User-added image

3.   For our example, we will choose the 'Picture' column since this corresponds to the Excel field that will store our soon-to-be-saved image's file path.  You may have to perform a few additional steps to connect to your database if you haven't already done so.  For more information on connecting to Excel-based databases in CardStudio, see the details in the following link.  Read More>>

User-added image

 

4.  A new popup should appear allowing us to configure the default directory in which the images will be saved.  For our example, we use the default CardStudio directory.  We select 'User Input' as the file name so that the user can decide what to name the picture once it is taken.  Other options include automatically generated names and counter-based names.

User-added image

 

5.  We finish the dialog above and then select the 'properties' option from the 'Database' menu.  Here we make sure that our 'Picture' field (from our database) is associated with the Imager video source.  This links our webcam with the field 'Picture'.  When ready to insert data into this field, the imager should now pop up so that we can take a picture.

User-added image

 

6. From the 'Database' menu on top, select 'Add' so as to insert a new record into our database.  Enter values for 'ID', 'FirstName', and 'LastName'.  Click on the 'Picture' field (which should be empty) and hit the enter key.

User-added image

 

7. The imager should appear with the feed from your webcam or camera.  Select the 'Capture Image' button in the bottom left to take a picture from the webcam.  After modifying the picture to your liking, select the check box in the bottom right to save the picture and insert the file path to that image in your database.

User-added image

 

8.  You will be prompted to provide a name for the newly-taken picture.  Notice that the picture, by default, is being stored in the directory specified in step 4.  Here we save the picture with the record's name 'JohnDoe'.

User-added image

 

9.  At this point, the image JohnDoe.jpg should be saved to disk on the local computer, and the database will contain 'JohnDoe' in the 'Picture' column for this record.  We can now see our picture being displayed in CardStudio's canvas:

 

User-added image

Helpful Information

Download CardStudio Software  Read More>>