Create a transaction services photo uploader

Create a transaction services photo uploader 

1.  Create a new table "photo_upload" in Tutorial warehouse database

(the default location: C:\Program Files\MicroStrategy\Tutorial Reporting\TUTORIAL_DATA_7200.mdb), as shown below:

 

 2. The 'photo_upload' table has to be pre-populated with *exactly* 10 rows of data, the values for the 'ID' column should be 1-10 and the values for the 'uploaded' column should all be 0

3.  In MicroStrategy Desktop, create a freeform report "R1" based on the new table "photo_upload" in Tutorial data created at step 1, as shown below:

 

SELECT Location, Description, ID, uploaded, numbers
FROM PHOTO_UPLOAD

4.  Create another table for transaction insert SQL. Make sure to create an 'autonumber' type ID as primary key for this table, or auto_increment ID for different DBs.

         

         

5. Create a transaction service report "T1" with "output objects" and "input objects" based on the second table in Tutorial data created at step 4, as shown below:

 

Begin Transaction
INSERT INTO Photo_Upload_Result (Location, Description, ID, Uploaded, Numbers)
VALUES([upload Location@ID],[upload Description@ID],[upload@ID],[uploaded],1)
End Transaction

Place cursor inside the parenthesis and right click to bring up the context menu, then click on define new input to create attribute form or metrics.

 

 Make sure the final output looks like this one

 

6.  Create a Report Services document with report "R1" created at step 2 as dataset and associate "Photo uploader" widget with it. 

7.  Right click the grid and select "configure transaction", configure the transaction as shown below:

 

8.  Create the Action Button for this transaction

9. Make sure the Action button is set to 'Submit'

10. Right click on the Grid object and select Properties and Formatting to set Photo Uploader as the widget under Widget setting unchecking full screen for android phone as following

11. Run the document on iPad, as shown below:

 

12.  Click "Add Photo" and select photos to upload.