ID photo software
Сamera control software
ID card software

info@akond.net, akondsales@gmail.com

  Products >> Incardex >> Connect to Excel file
 
Home
News
Products
ID Photo Solutions
Download
Buy
Support
Applications
Company
Links
Contact
 
Connect to Excel file


Incardex software:
Connect to Excel file containing photo links


 

ID card software
Connect to Excel file
Import Excel file
Work with Access file
Multiple ID card templates
Printing by condition


Incardex features
 

 

 

Lesson #1. How Incardex can work with Excel files contaning the photo links.

ID card software - Incardex - is designed for ID card management and printing.

In some cases the user has ready Excel file with the card holders' data and also has card holders' photos on disk. Incardex provides an ability to connect with available Excel file, work with all data, design and print ID cards for card holders from Excel file.

Below we explain step by step how to connect with Excel file from within Incardex software.

 

ID card software
  • Create a folder on your disk contaning .jpg photo files with the names corresponding to Employees' ID (as example). This folder will be used to store photo files.

    You do not need to create this folder if you already have it on your computer.
  •  

    ID card software
  • Create Excel file with the following columns: Employee ID, Name, Position, Department (example), and one additional column named Photo and containing the .jpg photo file names.

    If you already have Excel file with the card holders' data just add Photo column to it.

    Save your Excel file on disk (book1.xls file in our example)
  •  

    ID card software
  • Run Incardex Designer module of Incardex software. This module is used to create ID card layouts, create internal database or connect with the external databases, including connection with Excel files.

  • Create New Card layout (Click New button on the Toolbar).
  •  

    ID card software
  • Go to Database menu - Database Setup - Database Type: External database.

  • Click Select Database and check Microsoft Office Excel File.

  • Browse your Excel file created before (book1.xls in our example). Click Next.
  •  

     
    ID card software
  • Select Table. Check Use First Row as Column Titles (The first row of Excel file will be used as the title of the columns). Click Finish. If necessary re-arrange the database fields, change their labels, and other options.
  •  

    ID card software
  • Select Photo row and click on the Image Link. Browse the photo folder name in Default Path field. Click OK.
  •  

    ID card software
  • Create ID card layout. Draw all required fields (Employee ID, Name, Position, Department - using the Text from DB button on the Toolbar and selecting the assigned database fields, and Photo - using the Image from DB button on the Toolbar and selecting assigned database field).
  •  

    ID card software
  • Save created ID card layout. Then open it in Incardex Producer. You will see all information from your Excel file and corresponding photos from the image folder.
  •  

     
    Home|News|Products|ID Photo Solutions|Download|Buy|Support|Applications|Company|Links|Contact
     


    Software Informer
    Contact: AKOND company
    Tel/Fax: +7-812-3846430
    Tel: +7-921-7578319
    Skype: alla.povarkova
    email: info@akond.net
    email: akondsales@gmail.com

    Copyright © 2006 - 2013, Akond
    Web site designed and developed by Memento Graphics