how to take a value from collection to a text box widget and how to take a value from excel work sheet to textfield in a interface

[ii2team...@gmail.com]

I have one excel sheet and a interface, i want to take a value from spreadsheet to a text field in interface.

Excel worksheet name:enrollment
field name :customernumber
interface field type:text field
variable name:custnumber
identifer:id_custnumber

[Murali]

Hi,

Could you please let me know from where you are storing the excel, whether in same project, your personal google account?

Regards,

Murali 

[Jeremy Le Pré]

Hello,

About the collections, I recommand you to read the guide about it:
http://docs.runmyprocess.com/Developer_Guide/Collection/Collections_To_List

About the use of a spreadsheet, please, refer to the trainning:
http://docs.runmyprocess.com/Training/10-Minute_Application

From point 43. To configure the third activity as Connector to point 50.

You will need to adapt this to read and parse, instead of write to the document.

Regards,

______________________________________
Jérémy LE PRÉ

PreSales Engineer at RunMyProcess
Website: Fujitsu RunMyProcess

[Bidisha Das]

Hi,

In order to retrieve values from Excel Sheet which is in your Google Account to RMP,you need to use Google Spreadsheet Connectors available in RMP basically : Login Spreadsheet, Get the id of a spreadsheet [V 3.0], Get the id of a worksheet [V 3.0] and Get all rows [v3] .Using these 4 Connectors in your process activity,you will get all the values from spreadsheet in the computed parameters of your process.After getting the values,you can store it in a collection using freemarker code and then set it in a text box in your WI from collection.

There is also another way.You can download your spreadsheet in CSV format on RMP using 2 Connectors: Login Spreadsheet and Download a spreadsheet to RMP [v3] . In this case, you need to use ${import_objects("file id", "collection name", ",", "true")} to store in collection. File id would be the id of the file generated in RMP after it gets downloaded.

The description of the above mentioned connectors are very well given in the connectors itself.It would help you to find out what exactly the input parameters you should put in the process activities while using those connectors.

In order to set value in a WI field from Collection you can refer to : http://docs.runmyprocess.com/Developer_Guide/Collection/Collections_To_List

Hope it helps.

Thanks & Regards

Bidisha