Android Paperless Event Checking In Import/Export
At the top you have a message field that will provide information depending on the actions you take.
Here is the import file info:
- It can be any valid name
- comma delimited
- File placed in the internal storage/peci folder
-
The following fields are required
- Event Id1
- Event Name2
- Event Date(MM-DD-YYYY)3
- Code4
-
The following fields are optional. The order of the field is checked
- Guest Id5
- Name6
- Phone7
- Email8
- Group Count9
- Table/Row10
- Seat Number11
- User Field 112
- User Field 213
- User Field 314
- User Field 415
- User Field 516
Sample GuestList.csv file
Here is the export file info:
- It can be any valid name. The extension csv/json can be used.
- csv extension will produce a CSV file
- json extension will produce a JSON file
- File saved on the internal storage/peci folder
-
All fields will be exported, including checking status and checked in date, if avaialble.
CSV Output Sample
ID,Event ID,Event Name,Event Date,Code,Guest Id,Guest Name,Guest Phone,Guest Email,Group Count,Table/Row,Seat,User Field 01,User Field 02,User Field 03,User Field 04,User Field 05,Checked In Date,Was Checked In?,Action,Action Date
10010-19-202010001,100,Event 100,10-19-2020,10001,20000,Sondra Borey,916-555-1213,sondra.borey@poncesolutions.com,99,1,1,User Field 1,User Field 2,User Field 3,User Field 4,User Field 5,,false,,
10010-19-202010002,100,Event 100,10-19-2020,10002,20001,Neely Saint,916-555-1212,neely.saint@poncesolutions.com,1,1,2,User Field 1,User Field 2,User Field 3,User Field 4,User Field 5,,false,,
10010-20-202010002,100,Event 100,10-20-2020,10002,20001,Neely Saint,916-555-1212,neely.saint@poncesolutions.com,1,1,2,User Field 1,User Field 2,User Field 3,User Field 4,User Field 5,,false,,
10010-21-202010002,100,Event 100,10-21-2020,10002,20001,Neely Saint,916-555-1212,neely.saint@poncesolutions.com,1,1,2,User Field 1,User Field 2,User Field 3,User Field 4,User Field 5,,false,,
10010-19-2020039800108173,100,Event 100,10-19-2020,039800108173,20002,Doloris Harwood,916-555-1212,doloris.harwood@poncesolutions.com,1,1,3,User Field 1,User Field 2,User Field 3,User Field 4,User Field 5,,false,,
10010-19-2020887276971476,100,Event 100,10-19-2020,887276971476,20003,Chuck Cassady,916-555-1212,chuck.cassady@poncesolutions.com,1,1,4,User Field 1,User Field 2,User Field 3,User Field 4,User Field 5,,false,,
10010-19-202004963406,100,Event 100,10-19-2020,04963406,20004,Roselyn Giordano,916-555-1212,roselyn.giordano@poncesolutions.com,1,1,5,User Field 1,User Field 2,User Field 3,User Field 4,User Field 5,,false,,
10010-19-202004963406,100,Event 100,10-19-2020,04963406,20004,Roselyn Giordano,916-555-1212,roselyn.giordano@poncesolutions.com,1,1,5,User Field 1,User Field 2,User Field 3,User Field 4,User Field 5,,false,In,10-19-2020 10:51:46 PM
10010-19-202004963406,100,Event 100,10-19-2020,04963406,20004,Roselyn Giordano,916-555-1212,roselyn.giordano@poncesolutions.com,1,1,5,User Field 1,User Field 2,User Field 3,User Field 4,User Field 5,,false,Out,10-19-2020 10:51:58 PM
10010-19-202004963406,100,Event 100,10-19-2020,04963406,20004,Roselyn Giordano,916-555-1212,roselyn.giordano@poncesolutions.com,1,1,5,User Field 1,User Field 2,User Field 3,User Field 4,User Field 5,,false,In,10-19-2020 10:55:37 PM
10010-19-202004963406,100,Event 100,10-19-2020,04963406,20004,Roselyn Giordano,916-555-1212,roselyn.giordano@poncesolutions.com,1,1,5,User Field 1,User Field 2,User Field 3,User Field 4,User Field 5,,false,Out,10-19-2020 10:55:48 PM
10010-19-202004963406,100,Event 100,10-19-2020,04963406,20004,Roselyn Giordano,916-555-1212,roselyn.giordano@poncesolutions.com,1,1,5,User Field 1,User Field 2,User Field 3,User Field 4,User Field 5,,false,In,10-19-2020 10:57:07 PM
10010-19-202004963406,100,Event 100,10-19-2020,04963406,20004,Roselyn Giordano,916-555-1212,roselyn.giordano@poncesolutions.com,1,1,5,User Field 1,User Field 2,User Field 3,User Field 4,User Field 5,,false,Out,10-19-2020 10:57:14 PM
10010-20-202004963406,100,Event 100,10-20-2020,04963406,20004,Roselyn Giordano,916-555-1212,roselyn.giordano@poncesolutions.com,1,1,5,User Field 1,User Field 2,User Field 3,User Field 4,User Field 5,,false,,
JSON Output Sample
{
"data": [
{
"Event ID": "100",
"Event Name": "Event 100",
"Event Dates": [
{
"Event Date": "10-17-2020",
"Guests": [
{
"QR Code Value": "10001",
"Guest ID": "20000",
"Guest Name": "Sondra Borey",
"Guest Phone": "916-555-1213",
"Guest Email": "sondra.borey@poncesolutions.com",
"Group Count": "99",
"Table/Row": "1",
"Seat Number": "1",
"User Field 01": "User Field 1",
"User Field 02": "User Field 2",
"User Field 03": "User Field 3",
"User Field 04": "User Field 4",
"User Field 05": "User Field 5",
"checkedInDate": "",
"hasCheckedIn": "false",
"actions": [
{
"action": "In",
"actionDate": "10-17-2020 03:17:23 AM"
},
{
"action": "Out",
"actionDate": "10-17-2020 03:17:26 AM"
},
{
"action": "In",
"actionDate": "10-17-2020 03:17:27 AM"
},
{
"action": "Out",
"actionDate": "10-17-2020 03:17:29 AM"
},
{
"action": "In",
"actionDate": "10-17-2020 03:33:54 AM"
},
{
"action": "Out",
"actionDate": "10-17-2020 03:33:56 AM"
},
{
"action": "In",
"actionDate": "10-17-2020 03:33:58 AM"
},
{
"action": "Out",
"actionDate": "10-17-2020 03:34:00 AM"
}
]
},
{
"QR Code Value": "10002",
"Guest ID": "20001",
"Guest Name": "Neely Saint",
"Guest Phone": "916-555-1212",
"Guest Email": "neely.saint@poncesolutions.com",
"Group Count": "1",
"Table/Row": "1",
"Seat Number": "2",
"User Field 01": "User Field 1",
"User Field 02": "User Field 2",
"User Field 03": "User Field 3",
"User Field 04": "User Field 4",
"User Field 05": "User Field 5",
"checkedInDate": "10-17-2020 03:19:00 AM",
"hasCheckedIn": "true",
"actions": [
{
"action": "In",
"actionDate": "10-17-2020 03:19:00 AM"
}
]
},
{
"QR Code Value": "039800108173",
"Guest ID": "20002",
"Guest Name": "Doloris Harwood",
"Guest Phone": "916-555-1212",
"Guest Email": "doloris.harwood@poncesolutions.com",
"Group Count": "1",
"Table/Row": "1",
"Seat Number": "3",
"User Field 01": "User Field 1",
"User Field 02": "User Field 2",
"User Field 03": "User Field 3",
"User Field 04": "User Field 4",
"User Field 05": "User Field 5",
"checkedInDate": "",
"hasCheckedIn": "false",
"actions": []
},
{
"QR Code Value": "887276971476",
"Guest ID": "20003",
"Guest Name": "Chuck Cassady",
"Guest Phone": "916-555-1212",
"Guest Email": "chuck.cassady@poncesolutions.com",
"Group Count": "1",
"Table/Row": "1",
"Seat Number": "4",
"User Field 01": "User Field 1",
"User Field 02": "User Field 2",
"User Field 03": "User Field 3",
"User Field 04": "User Field 4",
"User Field 05": "User Field 5",
"checkedInDate": "",
"hasCheckedIn": "false",
"actions": []
},
{
"QR Code Value": "04963406",
"Guest ID": "20004",
"Guest Name": "Roselyn Giordano",
"Guest Phone": "916-555-1212",
"Guest Email": "roselyn.giordano@poncesolutions.com",
"Group Count": "1",
"Table/Row": "1",
"Seat Number": "5",
"User Field 01": "User Field 1",
"User Field 02": "User Field 2",
"User Field 03": "User Field 3",
"User Field 04": "User Field 4",
"User Field 05": "User Field 5",
"checkedInDate": "",
"hasCheckedIn": "false",
"actions": []
},
{
"QR Code Value": "498636652629065006002",
"Guest ID": "20005",
"Guest Name": "Jerlene Malcomb",
"Guest Phone": "916-555-1212",
"Guest Email": "jerlene.malcomb@poncesolutions.com",
"Group Count": "1",
"Table/Row": "1",
"Seat Number": "6",
"User Field 01": "User Field 1",
"User Field 02": "User Field 2",
"User Field 03": "User Field 3",
"User Field 04": "User Field 4",
"User Field 05": "User Field 5",
"checkedInDate": "",
"hasCheckedIn": "false",
"actions": []
},
{
"QR Code Value": "10007",
"Guest ID": "20006",
"Guest Name": "Francis Bowes",
"Guest Phone": "916-555-1212",
"Guest Email": "francis.bowes@poncesolutions.com",
"Group Count": "1",
"Table/Row": "1",
"Seat Number": "7",
"User Field 01": "User Field 1",
"User Field 02": "User Field 2",
"User Field 03": "User Field 3",
"User Field 04": "User Field 4",
"User Field 05": "User Field 5",
"checkedInDate": "",
"hasCheckedIn": "false",
"actions": []
},
{
"QR Code Value": "10008",
"Guest ID": "20007",
"Guest Name": "Randee Webster",
"Guest Phone": "916-555-1212",
"Guest Email": "randee.webster@poncesolutions.com",
"Group Count": "1",
"Table/Row": "1",
"Seat Number": "8",
"User Field 01": "User Field 1",
"User Field 02": "User Field 2",
"User Field 03": "User Field 3",
"User Field 04": "User Field 4",
"User Field 05": "User Field 5",
"checkedInDate": "",
"hasCheckedIn": "false",
"actions": []
},
{
"QR Code Value": "10009",
"Guest ID": "20008",
"Guest Name": "Roosevelt Hetrick",
"Guest Phone": "916-555-1212",
"Guest Email": "roosevelt.hetrick@poncesolutions.com",
"Group Count": "1",
"Table/Row": "1",
"Seat Number": "9",
"User Field 01": "User Field 1",
"User Field 02": "User Field 2",
"User Field 03": "User Field 3",
"User Field 04": "User Field 4",
"User Field 05": "User Field 5",
"checkedInDate": "",
"hasCheckedIn": "false",
"actions": []
},
{
"QR Code Value": "10010",
"Guest ID": "20009",
"Guest Name": "Micha Mixson",
"Guest Phone": "916-555-1212",
"Guest Email": "micha.mixson@poncesolutions.com",
"Group Count": "1",
"Table/Row": "1",
"Seat Number": "10",
"User Field 01": "User Field 1",
"User Field 02": "User Field 2",
"User Field 03": "User Field 3",
"User Field 04": "User Field 4",
"User Field 05": "User Field 5",
"checkedInDate": "",
"hasCheckedIn": "false",
"actions": []
}
]
},
{
"Event Date": "10-18-2020",
"Guests": []
},
{
"Event Date": "10-19-2020",
"Guests": []
}
]
},
{
"eventId": "1001",
"Event Name": "Event 1001",
"Event Dates": [
{
"Event Date": "10-17-2020",
"Guests": []
}
]
}
]
}
Sample Import CSV files
Event Id,Event Name,Event Date,Code,Guest ID,Name,Phone,Email,Group Count,Table/Row,Seat Number,User Field 1,User Field 2,User Field 3,User Field 4,User Field 5
100,Event 100,09-01-2020,10001,20000,Sondra Borey,916-555-1213,sondra.borey@poncesolutions.com,99,1,1,User Field 1,User Field 2,User Field 3,User Field 4,User Field 5
100,Event 100,09-01-2020,10002,20001,Neely Saint,916-555-1212,neely.saint@poncesolutions.com,1,1,2,User Field 1,User Field 2,User Field 3,User Field 4,User Field 5
100,Event 100,09-02-2020,10002,20001,Neely Saint,916-555-1212,neely.saint@poncesolutions.com,1,1,2,User Field 1,User Field 2,User Field 3,User Field 4,User Field 5
100,Event 100,09-03-2020,10002,20001,Neely Saint,916-555-1212,neely.saint@poncesolutions.com,1,1,2,User Field 1,User Field 2,User Field 3,User Field 4,User Field 5
Four fields
Event Id,Event Name,Event Date,Code
100,Event 100,09-01-2020,10001
Five fields
Event Id,Event Name,Event Date,Code,Guest ID
100,Event 100,09-01-2020,10001,20000
Six fields
Event Id,Event Name,Event Date,Code,Guest ID,Name,Phone
100,Event 100,09-01-2020,10001,20000,Sondra Borey,916-555-1213
Seven fields
Event Id,Event Name,Event Date,Code,Guest ID,Name,Phone,Email
100,Event 100,09-01-2020,10001,20000,Sondra Borey,916-555-1213,sondra.borey@poncesolutions.com
Eight fields
Event Id,Event Name,Event Date,Code,Guest ID,Name,Phone,Email,Group Count
100,Event 100,09-01-2020,10001,20000,Sondra Borey,916-555-1213,sondra.borey@poncesolutions.com,99
Nine fields
Event Id,Event Name,Event Date,Code,Guest ID,Name,Phone,Email,Group Count,Table/Row
100,Event 100,09-01-2020,10001,20000,Sondra Borey,916-555-1213,sondra.borey@poncesolutions.com,99,1
Ten fields
Event Id,Event Name,Event Date,Code,Guest ID,Name,Phone,Email,Group Count,Table/Row,Seat Number
100,Event 100,09-01-2020,10001,20000,Sondra Borey,916-555-1213,sondra.borey@poncesolutions.com,99,1,1
11 fields
Event Id,Event Name,Event Date,Code,Guest ID,Name,Phone,Email,Group Count,Table/Row,Seat Number,User Field 1
100,Event 100,09-01-2020,10001,20000,Sondra Borey,916-555-1213,sondra.borey@poncesolutions.com,99,1,1,User Field 1
12 fields
Event Id,Event Name,Event Date,Code,Guest ID,Name,Phone,Email,Group Count,Table/Row,Seat Number,User Field 1,User Field 2
100,Event 100,09-01-2020,10001,20000,Sondra Borey,916-555-1213,sondra.borey@poncesolutions.com,99,1,1,User Field 1,User Field 2
13 fields
Event Id,Event Name,Event Date,Code,Guest ID,Name,Phone,Email,Group Count,Table/Row,Seat Number,User Field 1,User Field 2,User Field 3
100,Event 100,09-01-2020,10001,20000,Sondra Borey,916-555-1213,sondra.borey@poncesolutions.com,99,1,1,User Field 1,User Field 2,User Field 3
14 fields
Event Id,Event Name,Event Date,Code,Guest ID,Name,Phone,Email,Group Count,Table/Row,Seat Number,User Field 1,User Field 2,User Field 3,User Field 4
100,Event 100,09-01-2020,10001,20000,Sondra Borey,916-555-1213,sondra.borey@poncesolutions.com,99,1,1,User Field 1,User Field 2,User Field 3,User Field 4
