Navigate to your Call For Papers and click the ‘Export Submissions’ menu item.
To export in a spreadsheet format choose Excel or ‘ODS’ (Open Document).
To export your submissions in a format that is easy for a developer to use then use the JSON format.
To export all the files attached to your submissions, like photos, slides etc. choose the ‘Zip’ option.
How do I export a selection of submissions?
On the page with the list of submissions select the rows you want to export.
Then in the ‘bulk actions’ menu scroll down to ‘Export Submissions’ and choose the export format that you want.
To export in a spreadsheet format choose Excel or ‘ODS’ (Open Document).
To export your submissions in a format that is easy for a developer to use then use the JSON format.
To export all the files attached to your submissions, like photos, slides etc. choose the ‘Zip’ option.
How do I export files that have been uploaded to submissions?
When exporting your submissions choose the ‘Zip’ export format, this will export all the files attached to your submissions, like photos, slides etc.
Why does the export spreadsheet have several worksheets?
Your data is presented across multiple sheets to accommodate submissions with multiple speakers.
Combined Overview - This sheet shows all your submission data in a single sheet. In the following sets of columns
The submission title
The submitters name and email
The state of the submission
The submission created and submitted date
The submission questions
The speaker questions are repeated as many times as necessary. For example if you have a submission with three speakers associated to it then the there will be 3 sets of speaker columns.
The count of accept/maybe/decline review answers and the weighted average
The unique identifiers for the submission, the speakers and the reviews. These are useful if you are going import the data into another system, they are persistent identifiers, so you can use them to track changes.
Submissions - This sheet shows the details on the submission questions. In the following sets of columns
The submission title
The submitters name and email
The state of the submission
The submission created and submitted date
The submission questions
The count of accept/maybe/decline review answers and the weighted average
The unique identifiers for the submission, and the reviews. These are useful if you are going import the data into another system, they are persistent identifiers, so you can use them to track changes.
Speakers - This sheet shows the answers to the speakers question. There is one row per speaker so one submission may have multiple rows in this table. You can identify rows from the same submission using the ‘Submission Title’ or ‘Submission Id’ columns. It has the following set of columns
The submission title
The speaker questions
The submission id and th speaker id. These are useful if you are going import the data into another system, they are persistent identifiers, so you can use them to track changes.
Submission Reviews - This sheet shows the answers given to reviewers to the submission questions. It has the following set of columns
The submission title
The reviewers name and email address
The state of the review, ASSIGNED, IN_PROGRESS and COMPLETED
The reviewers recommendation, if any
The weighted score
The answers given by the reviewer
The answer given by the speaker and in the next column the comments given by the reviewer for that answer
The submission id and review id. These are useful if you are going import the data into another system, they are persistent identifiers, so you can use them to track changes.
Speaker Reviews - This sheet shows the answers given to reviewers to the speaker questions. It has the following set of columns
The submission title
The reviewers name and email address
The state of the review, ASSIGNED, IN_PROGRESS and COMPLETED
The reviewers comment on the speaker
The speaker answers
The submission id, speaker id and review id. These are useful if you are going import the data into another system, they are persistent identifiers, so you can use them to track changes.
Answers To Table Questions - If you have asked the ‘Table’ question then the answers will appear in this table. The submissions are grouped into rows.
The first row shows ‘Submission Details’, followed by the title, name and email address of the submitter
The following rows are the answer the submitter gave to the question