{"text_format":"3","workbook":"xlsx","n_sheets":14,"sheets":["Overview","Exhibitors","Sessions","sub-sessions","Multi-Level Tracks","Speaker-Authors","Poster sessions","Poster session posters","Posters-Abstracts","SpeakerAssociations","Alerts","Products","ExploreScreen","AttendeeScheduleImport"],"not_rendered":{"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Overview","index":0,"n_rows":180,"n_cols":3,"rows_kept":180,"merged":[[0,1,0,2],[2,1,2,2],[94,1,94,2],[95,1,95,2],[96,1,96,2]]}
[null,"Overview of data required, as CSV"]
[]
[null,"* Denotes Required Field for that specific file"]
[]
[null,"Exhibitor  Data","Description"]
[null,"Exhibitor ID*","AN ID THAT NEVER CHANGES (ie customer number, CRM ID, etc.)"]
[null,"Name*","Name of the exhibiting company"]
[null,"Address","Address of exhibiting company"]
[null,"Website","The url for the exhibiting company (ex: www.acmecorp.com)"]
[null,"Phone","The phone number of the exhibiting company"]
[null,"Fax","The fax number of the exhibiting company"]
[null,"Public email address","Public contact email for the exhibiting company, will be desplayed in the app"]
[null,"Description","This Is a 50-200 word description of the exhibiting company"]
[null,"Booth Number(s)","Booth Number that coorisponds to the DWG or other map"]
[null,"Category(s)","Category(s) listed semi-colon delimited ie…Pumps;Hoses... Used to create additional \"Browse by\" filters"]
[null,"Private Contact email","Private contact email for the exhibiting company, might be used to communcate Green Package; not shown in the app"]
[null,"Sub-Category(s)","Sub-Category(s) listed semi-colon delimited ie…Pumps;Hoses... Used to create additional \"Browse by\" filters"]
[null,"Contact Name","first and last name of company contact"]
[null,"Contact Title","title of company contact"]
[null,"Sort Text","text used for sorting"]
[null,"Exhibitor Logo","URL to logo for exhibitor"]
[null,"Extended Attributes Field","label for custom field (such as CEM credit)"]
[null,"Extended Attributes Value","attribute value for the above field"]
[null,"Row Color","use this for highlighting the exhibitor row, format is hex code, 6 digits"]
[]
[null,"Session Data","Description"]
[null,"Session ID*","AN ID THAT NEVER CHANGES (ie customer number, CRM ID, etc.)"]
[null,"Title*","Title of the session"]
[null,"Location","Location of session, cannot be the same as a booth number"]
[null,"Description","Description of the session"]
[null,"Date*","Date of the session, must be in this format MM/DD/YYYY"]
[null,"Start time*","Start time of the session, must be in this format hh:mm p.m."]
[null,"End time*","End time of the session, must be in this format hh:mm p.m."]
[null,"abstract ID(s)","Abstract IDs of any abstracts that you want to associate with the session separate by semi-colons"]
[null,"Level 1 Track Name (Parent Track)","Tracks(s) listed semi-colon delimited ie…Poster Sessions;Oral Session"]
[null,"Level 2 Track Name (Sub-Track)","Sub-Tracks listed "]
[null,"Level 3 Track Name (Sub-Sub-Track)","Sub-Sub Tracks listed"]
[null,"EventType","Used \"like\" tracks but for creating multible event icons"]
[null,"TrackType","Used to create additional \"Browse by\" filters"]
[null,"SubTrack","SubTracks listed semi-colon delimited ie…Poster Sessions;Oral Session"]
[null,"ExhibitorID","Used to Link sessions to exhibitors"]
[null,"Handout Name","Name of Handout"]
[null,"Handout URL","URL to handout"]
[null,"HandoutStartDate","The date that the handouts are allowed to be seen in the app"]
[null,"HandoutEndDate","The date that the handouts are hiddent from the app"]
[null,"SessionCheckInEnabled","Y or N (Default is N, and blank)"]
[null,"CustomButtonLabel","Label for a custom button"]
[null,"CustomButtonTarget","Target for the custom button; not searchable"]
[null,"AllowAdd?","Y, N or 2 (Default is Y, and blank)"]
[null,"Prepopulate?","Y or N (Default is N, and blank)"]
[null,"Listed?","Y or N (Default is Y, and blank)"]
[null,"RowColor","Set the colour of the session row in the lists ex…000080"]
[null,"SpeakerID","You can put the speaker ID here that will be assocated with the session (not required if you are using Session ID in the Speaker session)"]
[]
[null,"Sub-Session Data","Description"]
[null,"Sub-Session ID*","AN ID THAT NEVER CHANGES"]
[null,"Session ID*","ID of the session that this sub-session is part of"]
[null,"Abstract ID(s)","Abstract IDs of any abstracts that you want to associate with the sub-session separate by semi-colons"]
[null,"Sub-Session Title*","Title of the session"]
[null,"Sub-Session Description","Description of the session"]
[null,"Sub-session Start time*","Start time of the session, must be in this format hh:mm p.m."]
[null,"Sub-session End time*","End time of the session, must be in this format hh:mm p.m."]
[null,"Location","Location of session, cannot be the same as a booth number"]
[null,"Handout Name","Name of Handout"]
[null,"Handout URL","URL to handout"]
[null,"SpeakerID","You can put the speaker ID here that will be assocated with the session (not required if you are using Session ID in the Speaker session)"]
[]
[null,"Speaker/Author Data","Description"]
[null,"Speaker ID*","AN ID THAT NEVER CHANGES"]
[null,"Prefix","Speaker Prefix (Mr., Mrs., Ms, Dr., etc)"]
[null,"FirstName*","Speaker First Name"]
[null,"MiddleName","Speaker Additional Names"]
[null,"LastName*","Speaker Last Name"]
[null,"Suffix","Speaker Honors"]
[null,"Title","Speaker Title"]
[null,"Company","Speaker Company"]
[null,"Biography","Bioagraphy of the speaker"]
[null,"URL to Photo","Image of the speaker"]
[null,"List of session ID(s)","Sessions this speaker is participating in by Session ID # listed semi-colon delimited ie…3;5;88;31"]
[null,"list of sub-session ID(s)","Sub-sessions this speaker is participating in - separate multiple with semi-colons (optional)"]
[null,"List of poster/abstract ID(s)","Abstracts that are associate with persson - separate  multiple with semi-colons (optional)"]
[null,"Speaker Role","Role the speaker holds…Default if left blank is \"Speaker\""]
[null,"Speaker Order","Display order of speaker and/or role"]
[null,"Sort Text","Text used to sort the speakers"]
[null,"Speaker Type","Used to sperate speakers into types ie…Author, Chair, Speakers"]
[null,"Disclosures","Disclosures if required by peers or law"]
[null,"Private Contact Email","Contact email address of the speaker not shared with public, Required if using Audience Response System; not displayed in the app"]
[null,"LinkedinHandle","Social Media address or Handle"]
[null,"TwitterHandle","Social Media address or Handle"]
[null,"FacebookHandle","Social Media address or Handle"]
[null,"Website","Website of the speaker"]
[null,"PublicContactEmail","Contact email address of the speaker shared with the public"]
[null,"Phone","Phone number of the speaker"]
[]
[null,"Notes about speakers:"]
[null,"**A session can have mulitple speakers"]
[null,"**Speakers can be associated with multiple sessions"]
[]
[null,"Poster Sessions Data","Description"]
[null,"Poster Session ID*","AN ID THAT NEVER CHANGES"]
[null,"Title","Title of poster-Session"]
[null,"Location","Location of poster-session, cannot be the same as booth number"]
[null,"Descriptions","Description of the Poster-session"]
[null,"Track(s)","If listing more than 1, please use semi-colons to separate them"]
[null,"Date*","Date of the poster session, must be in this format MM/DD/YYYY"]
[null,"Poster-session Start time*","Start time of the session, must be in this format hh:mm p.m."]
[null,"Poster-session End time*","End time of the session, must be in this format hh:mm p.m."]
[]
[null,"Poster Session Posters Data","Description"]
[null,"Poster Session ID*","AN ID THAT NEVER CHANGES"]
[null,"Abstract ID","Abstract to assocaite with the poster"]
[null,"Poster Number","The poster number"]
[null,"Poster Title*","The title of the Poster"]
[]
[null,"Posters/Abstracts Data","Description"]
[null,"Abstract ID*","AN ID THAT NEVER CHANGES"]
[null,"Title*","title of the poster/abstract"]
[null,"Keywords","list of keywords for the Poster/Abstract"]
[null,"Authors","Author Block"]
[null,"Date Published","(optional)"]
[null,"Body","Body of the abstract - app is text only, if you have many graphics, consider using URL to full Body"]
[null,"URL to full body","Used to link out to Internet for full Abstract body - for long abstracts over 3000 words(Optional)"]
[]
[null,"Speakers Associations","Description"]
[null,"Speaker ID*","ID of the speaker (taken from speakers file)"]
[null,"Session ID*","session ID this speaker is associated with"]
[null,"Sub-Session ID","list of sub-session ID this speaker has a role in"]
[null,"Role","role for speaker in that individual session"]
[]
[null,"Alerts","Description"]
[null,"Alert ID*","AN ID THAT NEVER CHANGES"]
[null,"Summary*","title of the alert"]
[null,"Alert Date*","date you wish to have the alert go out on the app (format must be MM/DD/YYYY)"]
[null,"Alert Time*","time you wish the alert to go out (format must be 10:00 A.M.)"]
[null,"Description*","description/body of the alert"]
[null,"Exhibitor ID","ID of the exhibitor you wish to have the alert associated with"]
[null,"Show on iPhones","Valid values are Y or N"]
[null,"Show on Android","Valid values are Y or N"]
[null,"Show on Blakcberry","Valid values are Y or N"]
[null,"Show on Web","Valid values are Y or N"]
[null,"Show on Blackberry Web","Valid values are Y or N"]
[null,"Push to iOS and Android","Valid values are Y or N"]
[]
[null,"Products","Description"]
[null,"Product ID*","AN ID THAT NEVER CHANGES"]
[null,"Exhibitor ID*","Exhibitor ID of the exhibitor associated with the product (taken from Exhibitor file)"]
[null,"Booth Number","booth/location where the product is displayed"]
[null,"Company Name","company that produces/owns the product"]
[null,"Category","Category(s) listed semi-colon delimited ie…Pumps;Hoses... Used to create additional \"Browse by\" filters"]
[null,"Product Name*","Name of product or service"]
[null,"Description","description of the product/service, typically 50-100 words"]
[null,"URL to photo","URL to photo of the product"]
[]
[null,"Registrants","Description"]
[null,"First name *"]
[null,"Last name *"]
[null,"Title"]
[null,"Company"]
[null,"Phone"]
[null,"Email"]
[null,"Address1"]
[null,"Address2"]
[null,"City"]
[null,"State"]
[null,"Zip"]
[null,"Country"]
[null,"Type"]
[null,"Registrant ID:*"]
[]
[]
[null,"Discovery Screen","Description"]
[]
[null,"ESID","AN ID THAT NEVER CHANGES (ie customer number, CRM ID, etc.)"]
[null,"Order","The order you want the posts to occur in.  (numerical or Random)"]
[null,"Graphics file name","Provide a URL to a creative or attach with the data (PNG required, size does not matter)"]
[null,"Caption","Friendly name you want to display in bottom left of the creative"]
[null,"Destination when Tapped","Where will the app land when the creative is tapped."]
[null,"Date it should appear","When do you want the creative to apper in the Explorer Screen Feed"]
[null,"Half/Full","Should the creative be half of the row or the full row"]
[null,"Notes","Any notes you want to include"]

{"sheet":"Exhibitors","index":1,"n_rows":1,"n_cols":11,"rows_kept":1}
["Exhibitor ID*","Name*","Address","Website","Phone","Fax","Public email address","Description","Booth Number(s)","Category(s)","Private Contact email"]

{"sheet":"Sessions","index":2,"n_rows":1,"n_cols":23,"rows_kept":1}
["Session ID","Title","Location","description","Date","Start time","End time","abstract ID(s)","Level 1 Track Name (Parent Track)","Level 2 Track Name (Sub-Track)","Level 3 Track Name (Sub-Sub-Track)","EventType","TrackType","ExhibitorID","Handout Name","Handout URL","SessionCheckInEnabled","CustomButtonLabel","CustomButtonTarget","AllowAdd?","Prepopulate?","Listed?","RowColor"]

{"sheet":"sub-sessions","index":3,"n_rows":1,"n_cols":10,"rows_kept":1}
["Sub-Session ID","Session ID","abstract ID(s)","Sub-session Title","Sub-session description","sub start time","sub end time","Location","Handout Name","Handout URL"]

{"sheet":"Multi-Level Tracks","index":4,"n_rows":1,"n_cols":9,"rows_kept":1,"hidden":true}
["Level 1 Track Name for Structure 1 (Parent Track)","Level 2 Track Name for Structure 1 (Sub-Track)","Level 3 Track Name for Structure 1 (Sub-Sub-Track)","Level 1 Track ID for Structure 1 ","Level 2 Track ID for Structure 1","Level 3 Track ID for Structure 1","Level 1 Track Name for Structure 2 (Parent Track)","Level 1 Track Name for Structure 2 (Sub-Track)","Level 3 Track Name for Structure 2 (Sub-Sub-Track)"]

{"sheet":"Speaker-Authors","index":5,"n_rows":1,"n_cols":25,"rows_kept":1}
["Speaker ID","Prefix","FirstName","MiddleName","LastName","Suffix","Title","Company","Biography","URL to Photo","List of session ID(s)","list of sub-session ID(s)","List of poster/abstract ID(s)","Speaker Role","Speaker Order","Sort Text","SpeakerType","Disclosures","Private Contact Email","TwitterHandle","LinkedinHandle","FacebookHandle","Website","PublicContactEmail","Phone"]

{"sheet":"Poster sessions","index":6,"n_rows":1,"n_cols":12,"rows_kept":1}
["Poster Session ID","Title","Location","Description","Topic(s)","Date","Start time","End time","AbstractIDs","Handouts Name(s)","Handout(s)","ScheduleID"]

{"sheet":"Poster session posters","index":7,"n_rows":1,"n_cols":5,"rows_kept":1}
["Poster Session ID","Abstract ID","Poster Number","Poster Title","Abstract Type"]

{"sheet":"Posters-Abstracts","index":8,"n_rows":1,"n_cols":15,"rows_kept":1}
["Abstract ID","Title","Keywords","Date published","Body","full_paper_is_download","URL to full body","Category","Authors","Abstract Type","EmbargoDate","EmbargoTime","Embargo Type","Number","Abstract Session ID"]

{"sheet":"SpeakerAssociations","index":9,"n_rows":1,"n_cols":4,"rows_kept":1}
["SpeakerID","SessionID","SubsessionID","Role"]

{"sheet":"Alerts","index":10,"n_rows":1,"n_cols":12,"rows_kept":1}
["AlertID","Summary","Date","Time","Description","From Exhibitor","Iphone","Android","Web","Blackberry","Push","Custom"]

{"sheet":"Products","index":11,"n_rows":1,"n_cols":8,"rows_kept":1}
["Product ID","Exhibitor ID","Booth Number","Company Name","Category","Product Name","Description","URL to Photo"]

{"sheet":"ExploreScreen","index":12,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"AttendeeScheduleImport","index":13,"n_rows":1,"n_cols":8,"rows_kept":1}
["Attendee ID","Email address","First Name","Last Name","Company","Title","Phone","Session ID(s)"]