JMP Discovery App Instructions
The JMP Discovery survey applications are intended to be a convenient and easy way for the JMP Discovery Steering Committee(s) to review and rate submitted abstracts. For each conference, the following process can be followed. Detailed steps are included below.
- Create a Survey to Rate JMP Discovery Papers
- Jeff’s instructions to export abstracts from Salesforce
- Run ImportAbstracts.jsl
- Run createDiscoveryPapersPDF.jsl
- Create the Survey add-in using Add-in Builder.
- Send out the Survey app to committee members
- Receive feedback via email, with ratings tables attached
- Aggregate Results and create a Review add-in
- Run Rank.jsl (creates PDFs also)
- Create the Review add-in using Add-in Builder
A. Create Survey
1. Run this report from Salesforce. Be sure to change the campaign to the appropriate Call for Papers campaign. The report must be run by (or as) Kathy Walker in order to see all the necessary fields. https://na79.salesforce.com/00O1O0000099Rxr
S Export the report as a .CSV file.
2. Run ImportAbstracts.jsl script to convert to correct format <Jeff, Audrey may need to update this section, based on what columns actually come out of Salesforce. As of Sept 2015, we don’t have a ‘real’ set of data to work with yet.>
a. Open() statement should be changed to point to the correct file. See SalesForce section above.
b. The expectation is that a column :xcfp_submission_type exists in the raw format, and each cell has either “Poster”, “30 Minute Paper”, or “45 Minute Paper” in this column. If you have rows that do not conform, you will be shown an interim table and a dialog telling you which rows do not match. Examine the rows, in particular the columns for xcfp_submission_type and xcfp Paper Length (columns 2 & 3 in your interim table).
c. If some values need to be corrected, then update the interim table and choose Rerun.
d. If no values need to be corrected and the “bad rows” are simply garbage rows, choose Exclude Selected Rows.
e. Next, you will be presented with your final table, named DiscoveryPapers. You will see a Success message. If you chose Exclude Selected Rows, you will see all your excluded rows at the top. Review them one more time before modifying or deleting them.
f. Important! You must SAVE DiscoveryPapers.jmp.
g. DiscoveryPapers must have these column names (they can be empty, but must exist). Double check these column names.
i. Number
ii. xcfp_submission_type
iii. xcfp Paper Length
iv. First Name
v. Last Name
vi. Company
vii. Industry
viii. xcfp_versions
ix. xcfp_webpage
x. xcfp Paper or Poster Title
xi. xcfp Percent using JMP
xii. xcfp_abstract
xiii. xcfp_Authors_titles
xiv. xcfp_Application Area PTR1
xv. xcfp_Application Area PTR2
xvi. xcfp_Addtl_Authors
xvii. xcfp_Demo_JMP
xviii. xcfp_Biographies
xix. xcfp_Job Function
xx. xcfp_Level
xxi. xcfp_Platforms
3. Set up the meta table.
a. language should be “English,” “Japanese,” or “Simplified Chinese.”
b. number of points should be the rating scale (5).
c. county should be the country code of the conference (US, EU, CH, JA).
d. year should be the year of the conference.
e. random should be empty (will be auto generated later). This is the anonymous identifier for unique individuals.
f. auto accept is the number of papers in each category that you would like the accept the highest rated of automatically.
g. addin_id is the Add-in ID for the survey add-in. It must be the same as the name you set in step 5 below.
h. email is the email that the results of the survey should be sent to. Currently this is Audrey – <Jeff, you may want to set up a generic account for this.>
i. first launch is an indicator column the application uses to perform actions the first launch, but not later.
j. Note: Only the first row of the meta table is actually used. You could add additional rows to quickly copy and paste to
4. Run createDiscoveryPapersPDF.jsl. It will create the PDF of all abstracts, which will be included in the add-in.
5. Create Survey Add-in
a. File > New > Add-in
b. Set Add-in name to a descriptive title ex. ‘Rate JMP Discovery Papers’
Important: Set Add-in ID to the same unique ID you used in the meta table for addin_id
c. Add menu item
i. Go to Menu Items tab
ii. Click Add Command
iii. Change Menu Item Name to “Rate JMP Discovery Papers”
iv. In the Run this JSL: box, add the following:
open("$ADDIN_HOME(Rate JMP Discovery Papers)\DiscoverySurvey.jmpapp");
d. Add Additional Files
i. Go to Additional Files tab
ii. Add these five files, which should all exist in the same directory
1. meta.jmp
2. translate.jmp
3. DiscoveryPapers.jmp
4. DiscoverySurvey.jmpapp
5. 2015 JMP Discovery US Papers.pdf (or similar name)
e. Save and the add-in is created and ready for distribution.
B. Send out the Survey app to committee members
C. Receive feedback via email, with ratings tables attached
D. Aggregate Results and create a Review add-in
6. Run Rank.jsl
a. Make sure all ratings tables received from committee members reside in one folder.
b. On the first line of Rank.jsl, assign the “path” variable to the location of the tables
c. Aggregate.jmp and two summary PDF files are auto-saved to the same location where Rank.jsl resides.
7. Create Review Add-in
a. File > New > Add-in
b. Set Add-in name to a descriptive title ex. ‘Review JMP Discovery Papers’
c. Set Add-in ID to the same unique ID you used in the meta table for addin_id2
d. Add menu item
i. Go to Menu Items tab
ii. Click Add Command
iii. Change Menu Item Name to “Review JMP Discovery Papers”
iv. In the Run this JSL: box, add the following:
open("$ADDIN_HOME(Review JMP Discovery Papers)\DiscoveryReview.jmpapp");
e. In the Additional Files tab, add the following six files:
i. meta-review.jmp
ii. translate-review.jmp
iii. Aggregate.jmp
iv. DiscoveryReview.jmpapp
v. 2015 JMP Discovery US Papers with Ratings and Comments.pdf
vi. 2015 JMP Discovery US Rankings.pdf
f. Save and the add-in is created and ready for distribution.
