Starting Processing in Bulk from Customer List on Google Spreadsheet

A Tool that allows registration of Tasks (Starting the Process) from the list Data on Google Spreadsheet or in Excel, all at once.

 

In using Questetra BPM Suite, if you are in the position of assigning jobs of the next month, you might have felt that, ‘I know it is my duty that registering all the Task for this month to be assigned to workers at the beginning of the month, but it is annoying to me to register one by one…’
For solving this problem, we have prepared a tool that allows registration of Tasks (Starting the Process) from the list Data on Google Spreadsheet or in Excel, all at once.

Using this tool, you can easily achieve these performance such as,

  • Registering all the customers that need to be updated the contract within this month, into the Contract Updating Process by the list at once.
  • Registering the data that was brought from elsewhere for the purpose of migrating etc., at once.
  • Starting Processes at once, by csv file or by the list that created with Excel.

Below, I’ll explain in detail about the tool.

== Outline==

Start processes on Questetra BPM Suite by Google Spreadsheet data. (Google Drive Add-on)
「Questetra BPM Suite add-on」

== Preparation ==

  • You need a G Suite (Google Apps) account or a gmail account, because it works on Google Spreadsheet.
  • You need to set [Message Start Event (HTTP)] on the Process Model of Questetra BPM Suite for receiving data via HTTP to Start the Process.

*Click HERE to see the detail of ‘Message Start Event (HTTP)’

== How to Use ==

    1. Get the Questetra BPM Suite add-on through [Add-ons] menu on ‘Google Spreadsheet’.
      addon選択_2

 

    1. ‘Initialize’ the Tool.
      addon初期化_新

 

    1. Set up to match with the property of Message Start Event of the receiving Process Model. Then Save.
      addonサイドバー_2

 

    1. Prepare the list data to be registered. (Copy and Paste the data on Excel.)
      addonデータ準備_新3

 

  1. Execute the Processing
    addonサイドバー_start2

== Mechanism ==

The Tool will read the Google Spreadsheet data one line by one. Send data to the target Process Model (via HTTP). The Process will be Started.
addon仕組み_新

== Notes ==

If the list contains more than 101 lines, it need to be separated to avoid the Limitation of Questetra BPM Suite that Less than 100 Processes to be Started in 15 minutes.

For your questions about this tool, please contact us via Contact Form.
* This tool is published using the service that is available since March 2014, add-ons that created with Google Apps Script on Google Drive to be published.
http://googledrive.blogspot.jp/2014/03/add-ons.html

About Kusaka Tsuyoshi

営業をやってますが、もともとエンジニアなので、プログラミングもやります。
View all posts by Kusaka Tsuyoshi

Recommendations
Prev article - 50. Questetra Tips Cases of Cooperation with BPM products and Office365, Salesforce, Cybozu, etc. (List of Examples of Cooperation: part 1)
Next article - 50. Questetra Tips FAQ. Can I Download the Data of Issues?
Another article - Kusaka Tsuyoshi Business Improvement Case using kintone + box + Questetra

Archive

 RSS