All Posts

The Short & Sweet Guide: Formatting Data for Plastic Cards

Learning how to format data the correct way can remarkably speed up the process of ordering plastic cards. In order to properly process data, the data needs to be transformed from one format to another. Following these guidelines on what types of file formats are accepted, best practices, and data and card layout will ensure your card personalization process is seamless.

woman working on computer

Standard File Formats

Using these standard file formats, your data will be easy to read and process.

  • Excel (.xls or .xlsx)
  • Comma Separated Value (.csv Dos Formatted)
  • Tab Delimited (.txt Dos formatted)
  • Pipe Delimited (.txt Dos formatted)
  • Fixed Length Text File with carriage returns at each record (.txt Dos Formatted)

Standard File Format Best Practices

Using these best practices will streamline the process of personalizing your plastic cards.

  • Provide a clear header in the file that accurately lists what the data in the file represents.
  • Make sure that there are no floating lines of data. Keep all the data fields lined up in the file.
  • Ensure that text Casing is correct for how you want it to print. Unless specifically requested, the data will be printed as is on the document.
  • If you're supplying multiple files, ensure that file names are uniquely identified per version of card.
  • Make sure your data is scrubbed and ready for the transformation processes.

Data and Card Layout

If a third-party like CARDSource is creating the data, they will need:

  • The starting number as it needs to be printed on the cards.
  • A layout of the card with the fields shown for printing position.
  • Any specific fonts or barcode symbology needed.
  • If you need a check digit added to the barcode data.

If you are supplying the data to be used for personalization, you will need to provide:

  • A data layout of where to pull the information from in the inbound data or a header records in the data that states what each field represents.
  • A layout of the card with the fields shown for printing position.
  • Specific Font types or barcode symbology needed.
  • If you need a check digit added to the barcode data.

Data Services From Third Party Vendors

If you have data and you aren't sure how to format it or you need help, a third party vendor like CARDSource could help you with:

  • Data Scrubbing
  • Truncation or concatenation of data fields
  • Presort services for mailing files including NCOA services
  • Data cleansing, reformatting or manipulation of data files other than the standard data transformation processes.

By following these guidelines for formatting data, your data will be clean and easy to use for any processing team. If you need help with formatting data, let us know. We would be happy to help. 

CONTACT US

 

Jade Beaver
ABOUT THE AUTHOR | Jade Beaver
Marketing Coordinator
book cover

 

Plastic Card Solutions: A Guide to Quality

Understand the differences in quality for plastic cards and printing companies. We touch on quality, price, risk assessment and trustworthiness! Get your free copy!

Get Your Copy
Recent Posts

Press Release - CARDSource DE&I Accreditation

Read more

Spring is in the air!

Warmer weather has reached us here in Minnesota and the CARDSource crew is ready for your spring projects! We have been busy over the past few months ...

Read more

CARDSource is a Great Printer!

CARDSource has earned Great Printer Status! We are really excited to share our Certification in the Printing Industry Midwest (PIM) Great Printer Envi...

Read more

Announcement

Read more