Send invites to ALL people who have not yet submitted a CloudCard photo

  1. Open CloudPhoto Connect
  2. Go to File > Config > Database
  3. Enter the following SQL query in the Upload Records Where input box

              EMAIL_ADDRESS IS NOT NULL AND CCUPLOAD IS NULL AND PHOTO IS NULL

  1. Click OK
  2. In the Invites Emailed section the blue underlined number represents the number of records that will be sent an invite. Click the blue number to preview the list of records.
  3. Click the Resend Invites button to send the invite emails


Use a list to flag specific database records

  1. Use SQL Management Studio to add a new varchar column named CCFLAG (length=25) to the IDCARD table:

               ALTER TABLE IDCARD

               ADD CCFLAG varchar(25)

  1. Use RapIDutilities (RapIDutilties User Guide) and a CSV or TAB file containing rows of IDNumbers to populate a flag column
    1. Use the Text/Function option to populate a unique data value in the CCFLAG column for all records in the import file. You can use any unique CCFLAG value up to 25 characters. The below example uses a date value.

    2. Enable the RapIDutilities Import Option’s Update Only checkbox to ensure only existing records are updated and new records won’t be created.
    3. Run the import
    4. Open the RapIDutilties log to view the number of updated records
    5. Exit RapIDutilties
  2. Open CloudPhoto Connect
  3. Go to File > Config > Database
  4. Reference the CCFLAG column in the Upload Records Where input box

(sample query that returns records matching the CCFLAG example value who also have not submitted a CloudCard photo)

Upload Records Where: CCFLAG = '7-17-2018' and EMAIL_ADDRESS IS NOT NULL AND CCUPLOAD IS NULL AND PHOTO IS NULL

  1. Click OK
  2. In the Invites Emailed section the blue underlined number represents the number of records that will be sent an invite. Click the blue number to preview the list of records. This number should match the number of records from step 2d.
  3. Click the Resend Invites button to send the invite emails