Information Request List Checking Process 20221228<\/div>
This is a system for checking the validity of delivered material request lists (TSV strings). Duplicate lines, missing email addresses, etc. are checked and non-valid results are notified to the source of delivery.<\/div><\/div>\n\n\n
<\/span>Worker (Number of swimlanes: 1)<\/div>
\n\n\n\n
- \n
- <\/i><\/span><\/span> Marketing Department<\/strong> <\/li>\n<\/ul>\n\n\n<\/div><\/div>\n\n\n<\/span>Workflow (Workflow diagram complexity: 11)<\/div>\n\n\n\n
- \n
- 1. Delivery: Material request list entry<\/strong>\n
- \n
- The Marketing Department staff member registers the list from the deliverable “Request for Information List” Excel file.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- x1. Delete duplicate lines<\/strong>\n
- \n
- The workflow platform deletes duplicate rows of the material request list and stores them in a checked Table-type data item.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- x2. Validity check<\/strong>\n
- \n
- The workflow platform will check the validity of the email address and the availability of the phone number and describe the results.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- <\/i><\/span><\/span>x3. List file creation<\/strong>\n
- \n
- The workflow platform converts the checked data into a file and stores it.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- x4. Upload files<\/strong>\n
- \n
- The workflow platform stores files in a Google Drive designated folder.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n<\/div><\/div>\n\n\n<\/span>Workflow Diagram (click to open)<\/div>\n\n\n\n
![\"\"](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/05\/document-request-list-check-process-202212-diagram-en.jpg?resize=898%2C213&ssl=1\")
<\/figure>\n\n\n\n- \n
- BPMN Icons\n
- \n
- Start Event<\/li>\n\n\n\n
- End Event<\/li>\n\n\n\n
- Exclusive Gateway (XOR)<\/a><\/li>\n\n\n\n
- Message Start Event (email)<\/a><\/li>\n\n\n\n
- Human Task<\/a><\/li>\n\n\n\n
- Update Data<\/a><\/li>\n\n\n\n
- Converter (Table type data to Excel-CSV File)<\/a><\/li>\n\n\n\n
- Google Drive: File Upload<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n<\/div><\/div>\n\n\n
<\/span>Business process variables to be passed (number of data items: 7)<\/div>\n\n\n\n- \n
- <\/i><\/span>Delivery Date<\/strong> q_delivery_date<\/span>
4<\/code>\n- \n
- processInstanceStartDatetime<\/span><\/li>\n<\/ul>\n<\/li>\n\n\n\n
- <\/i><\/span>Deliverables: List of Information Requests<\/strong> q_table<\/span>
0<\/code>*<\/span>\n- \n
- The list of material requests delivered from contracted media companies will be stored.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- <\/i><\/span>Checked: Request for Information List (duplicate rows deleted)<\/strong> q_table_for_delete_dupicated_rows<\/span>
2<\/code>\n- \n
- The list of requests for information is stored with the results of the checks appended.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- <\/i><\/span>Duplicate Rows<\/strong> q_duplicate_rows_count<\/span>
3<\/code>\n- \n
- The number of duplicate rows in the document request list is stored.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- <\/i><\/span>Check Error Count<\/strong> q_error_count<\/span>
1<\/code>\n- \n
- The number of rejected rows is stored as a result of the validity check of the list of material requests.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- <\/i><\/span>Information Request List File<\/strong> q_document_file<\/span>
5<\/code>\n- \n
- The TSV format file of the checked material request list is stored.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- <\/i><\/span>File: Download URL<\/strong> q_document_file_download_url<\/span>
6<\/code>\n- \n
- The download URL for files stored in Google Drive will be stored.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n<\/div><\/div>\n\n\n\n
<\/i> Field name<\/span>,
Num<\/code>, Initial value<\/span><\/p>\n\n\n\n<\/i> Download<\/h3>\n\n\n\n
- \n
- document-request-list-check-process-202212-en.qar<\/a>\n
- The download URL for files stored in Google Drive will be stored.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n<\/div><\/div>\n\n\n\n
- <\/i><\/span>Deliverables: List of Information Requests<\/strong> q_table<\/span>
- processInstanceStartDatetime<\/span><\/li>\n<\/ul>\n<\/li>\n\n\n\n
- Message Start Event (email)<\/a><\/li>\n\n\n\n
- BPMN Icons\n
- The workflow platform stores files in a Google Drive designated folder.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n<\/div><\/div>\n\n\n
- 1. Delivery: Material request list entry<\/strong>\n
![\"\"](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/05\/document-request-list-check-process-202212-img0-en.png?resize=960%2C540&ssl=1\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/05\/document-request-list-check-process-202212-img1-en.png?resize=960%2C540&ssl=1\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/05\/document-request-list-check-process-202212-img2-en.png?resize=960%2C540&ssl=1\")
<\/figure>\n\n\n\n