eMedia Cards knowledge base - sample files
Article: How to connect a card template to MySQL or MariaDB (connect-template-to-mysql)

Larkspur Hill School Student Card.eccs
  A one-sided CR80 student card template, not yet connected to a database.
  Text objects LastName, FirstName, Class and StudentID, the picture object
  Photo and the Code128 barcode Barcode read the database columns of the same
  name. The logo and the background are stored in the template.

larkspur_school.sql
  Creates the database larkspur_school and the table students, then adds 20
  students. Run it on your own MySQL 8 or MariaDB server with a user allowed to
  create a database, for example:
    mysql -u <admin user> -p < larkspur_school.sql
  Columns:
    Id         INT AUTO_INCREMENT PRIMARY KEY  filled in by the server
    StudentID  VARCHAR(12) UNIQUE              for example LHS-26001, also the barcode
    FirstName  VARCHAR(40)
    LastName   VARCHAR(40)
    Class      VARCHAR(8)                      7A, 7B, 8A or 8B
    Photo      VARCHAR(64)                     file name in the Photos folder
  The end of the script shows, as comments, how to create a login with read
  and write rights on this table only.

Photos\LHS-26001.jpg ... LHS-26020.jpg
  The student photos named in the Photo column. Keep the Photos folder next to
  the template: the template looks for pictures in its Photos subfolder.

students.csv
  The same 20 records as a CSV file (UTF-8, semicolon separated), for review.

Larkspur Hill School is a fictional school. The students, their names and
their photos are invented: the faces were generated and show no real person.
