Having trouble with the video? Try this link.

Sometimes you want to initiate lots of items at the same time, and doing them one by one will take forever. In KiSSFLOW, you can now do a bulk import of items.

To start, you will need to make a copy of this spreadsheet:


Start with the Setup sheet. You can find your API key, and Appspot ID in the Admin tab. For the App name, enter the exact name of the App you want to upload to. In lines 4, 5, and others, enter the name of any table in the App. Delete any lines you are not using. If you need to add additional tables, call them TableName3 and so on.

Then go to the Parent sheet. Every line needs to have its own serial number. Each serial number will represent a different item. The serial number is not a field in your App, it will just help this spreadsheet give the right information. The CreatedBy column is mandatory for all Apps. Enter the name of the person whom you want to be the initiator of the item. This process will import items into the Initiator’s Drafts folder.

Starting from Column C, change the headings of each column to the field ID for each field in your App. You can add as many columns as you need to match the number of fields you have. Do not insert columns for computed fields or for fields that are filled later on in the process. Only include those fields that are required by the initiator. Don’t put anything in the Import Status column, and make sure it is the last column.

Then create a new sheet for each table that you have. For example, I have one table called LineItems, so I’ve made a separate sheet for it here. In the sheet, enter all the information that needs to go in the table. It is important that you keep the serial number the same for each item. If there are 10 entries for an individual request, they should all have the same serial number. Adjust the headings of the columns to meet your needs.

Do the same thing for any other tables you have. Make sure that the names of the sheets you create match exactly with those listed on the Setup sheet. You can delete additional sheets if you want.

Once you are finished, go back to the Parent tab. There is a menu item called KiSSFLOW. Click the menu and then click Upload. You can see if there were any errors in the Import Status column.

All of these items will go to the draft folder of whoever is the initiator. From there, the initiator can submit the request.

Did this answer your question?