Tunabelly Software

QR Factory

Multiple Codes using CSV Files

How to create multiple codes:

  • Create a file in Numbers or Excel.
  • In the first row, fill in the column name (one name per column).
  • In the rows below, fill in the appropriate values for each column.
  • Export to a CSV file.
  • Open up QR Factory, click the "Create Multiple Codes…" button, choose the file to use, the export folder, and optionally the icons folder.
  • Click the "Create QR Codes" button, and soon all your QR codes will be available in the export folder you chose.

Tips:

  • If a column is key based, then use the format key=value separated by a semicolon ";". Ex: latitude=-30;longitude=40
  • If you need a comma in one of the values (ex: "Company Name, Inc."), use a back slash before the comma. So the example would become "Company Name\,Inc.". This is called escaping the comma.
  • New Feature in v2.7: All keys for vCards can be used in columns instead of key/value pairs. See Example Exported CSV File (with vCard Columns) for an example.
  • New Feature in v2.7.3: The IconSize column now requires a value between 1-100 which is the percent size to use for the icon. For example, 35 will scale the icon to 35% of its original size.
  • New Feature in v2.9.6: The IconBorderPercent column is now available with a value between 0-100 for the percent of the icon's size to use for the border around it.
  • New Feature in v2.9.8: The RotationAngle column is now available with a value of 0 (or leave it blank), 90, 180 or 270 for the degrees to rotate the saved code.
  • New Feature in v2.9.8: The ColorSpace column is now available with a value of RGB, CMYK or Grayscale. This is the color space that the code will be saved in. Please note that the only format that supports all three color spaces is TIFF.

CSV Format:

Column Name
Key
Value
Type
Text
Content
Any text up to 240 characters
Type
Email
Content
email
Any email address
Content
subject
The subject of the email
Content
body
The body of the email
Content
cc
Email address to cc (carbon copy)
Content
bcc
Email address to bcc (blind carbon copy)
Type
URL
Content
Any URL including the scheme (ex: http:// or https://)
Type
GPS
Content
latitude
Latitude as a decimal number
Content
longitude
Longitude as a decimal number
Type
Phone
Content
type
PhoneNumber or SMS
Content
number
Any phone number
Type
Person
Content
nameTitle
Person's title (ex: Mr, Mrs, Dr, etc)
Content
firstName
First name
Content
lastName
Last name
Content
nickname
Person's nickname
Content
company
Company name
Content
jobTitle
Job title
Content
jobDepartment
Job department
Content
phoneHome
Home phone number
Content
phoneMobile
Mobile/cell phone number
Content
phoneWork
Work phone number
Content
phoneFax
Fax phone number
Content
phoneNumberPreferredType
Home, Work, Mobile, or Fax
Content
email
Email address
Content
url
Homepage URL
Content
street
Street address
Content
city
City
Content
provinceState
Province or state
Content
postalZipCode
Postal or zip code
Content
country
Country
Content
addressType
Home or Work
Content
cardType
VCARD or MECARD
Content
encoding
ASCII or Unicode
Type
WiFi
Content
ssid
Name of the WiFi network
Content
password
Password for the WiFi network
Content
authenticationType
None, WEP, WPA or WPA2
Content
hidden
Yes or No
Type
Calendar
Content
title
The name of the event
Content
location
The location of the event
Content
start
Start time of the event in format YYYY-MM-DDThh:mm
Content
end
End time of the event in format YYYY-MM-DDThh:mm
Content
timeZone
Time zone of the event. Ex: "America/Vancouver"
Type
SocialTwitter
Content
Twitter username
Type
SocialFacebook
Content
Facebook page name
Type
SEPA
Content
bic
BIC (Business Identifier Code) of the beneficiary bank. Maximum of 11 characters.
Content
name
Name of the beneficiary. Maximum of 70 characters.
Content
iban
IBAN (International Bank Account Number) of the beneficiary. Maximum of 34 characters.
Content
euroAmount
Amount in Euros. EUR is an optional prefix that will automatically get filled in if missing. Ex: "EUR10.5". Maximum of 12 characters.
Content
purposeCode
Purpose of the transfer. Maximum of 4 characters.
Content
remittanceText
Remittance information. If using a reference, maximum of 35 characters, otherwise 140.
Content
info
Extra info. Maximum of 70 characters.
FileName (optional)
The name of the file
FileType (optional)
PNG, TIFF, PDF or EPS
ColorSpace (optional)
RGB, CMYK or Grayscale. Please note that the only format that supports all three color spaces is TIFF.
RotationAngle (optional)
0, 90, 180 or 270
PixelRoundness (optional)
From 0.0 (square) to 1.0 (fully rounded)
PixelColorType (optional)
Solid, LinearGradient or RadialGradient
PixelColorStart (optional)
For "Solid", the pixel color. For "LinearGradient and RadialGradient", the start color of the gradient. It must be in the web format of #RRGGBB where RR, GG and BB are the hex values for each colour channel. Ex: #FF0000 is pure red.
PixelColorEnd (optional)
For "Solid", this is ignored. For "LinearGradient and RadialGradient", the end color of the gradient. It must be in the web format of #RRGGBB where RR, GG and BB are the hex values for each colour channel. Ex: #00FF00 is pure green.
BackgroundColorType (optional)
Solid or Transparent
BackgroundColor (optional)
For "Transparent", this is ignored. For "Solid", the background colour of the code. It must be in the web format of #RRGGBB where RR, GG and BB are the hex values for each colour channel. Ex: #0000FF is pure blue.
ReliabilityLevel (optional)
The amount of deterioration of the code that can occur where it is still readable.

Low, Medium, High or Highest.
AddIcon (optional)
Yes or No
IconPath (optional)
The full path to the icon file to overlay in the middle of the code. It must reside inside the icons folder that was chosen in the app (because of Mac App Store sandboxing rules).
IconSize (required if IconPath is used)
The percentage (1-100) that the icon should be scaled to. The icon will always retain its original aspect ratio. Note that the icon cannot be scaled to larger than its original size.
IconWidth (optional if IconPath is used)
This can be used instead of IconSize for the width in pixels that the icon should be scaled to. Note that the icon cannot be scaled to larger than its original size.
IconHeight (optional if IconPath is used)
This can be used instead of IconSize for the height in pixels that the icon should be scaled to. Note that the icon cannot be scaled to larger than its original size.
IconBorderPercent (optional)
The percentage (0-100) of the icon's size to use for drawing a border around the icon. The border is used to visually separate the icon and the qr code. Use 0 to draw no border.
OutputSize (optional)
The output size of the code. It can be between 64 and 4096. Note that the size will always be a square (width and height are the same).