Thursday, May 16, 2013

Using Photo Uploader widget

After playing around with the photo uploader widget for a while, I decided to document the procedure I used for posterity...

1. I create two tables in my database:
  One is the photo place holder table (this is the table that determines how many photos you can upload) = tbl_1
One is the actual table where I store the photo path, desc and uploaded flag = tbl2

Both tables have the following columns - 

photo_id(int) (auto incriment)
photo_location (varchar)
photo_uploadedFlag (int)

I then  add 10 rows to tbl_1 (normal blank records will do) 
you can add more, or less records, I use 10 because android devices need at least 10 records

2. In MSTR, create 1 Attribute and 1 Metric

Attribute "PhotoLoad" 
ID = photo_id
DESC = photo_descr
Location = photo_location

Metric "PhotoUploaded"

3. Create a new report in MSTR that has "PhotoLoad" attribute in rows (hide the ID form) and "PhotoUploaded" metric in columns
You will use this report in your dashboard

4. Create a new Transaction Report that insert data into tbl_2

Begin Transaction
insert intotbl_2(photo_descr,photo_location,photo_uploadedFlag)VALUES(<inp_photo_descr>,<inp_photo_location>,<inp_photo_uploadedFlag>)End Transaction

5. In Web, create a new document
add the first report you created
set the report widget properties to Mobile > Photo Uploader

Right click on table and Configure Transactions
Choose the Transaction Report you created and map the table columns to the corresponding input values (mark all of them as editable)

Add a submit button
Test on an iPad


  1. 다만, 배송받은 상품을 반환하는데 드는 비용은 소비자가 부담해야 합니다. ※익명으로 후원하시면 프레시안은 개인정보를 수집하지 않으나, 향후 결제를 취소할 때 처리가 지연될 수 있습니다. 이 부분 또한 진부한 클리셰를 많이 찾아볼 수 있었는데, 패를 마지막에 토토 까는 사람이 이기는 것과 올인 단판 승부로 게임이 끝나는 점이 그러했다.