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:
Here is the export file info:

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
  
Home Settings Review Inventory Import/Export