collection

[ideasandinno...@gmail.com]

Hi

I have used a collection named user for autocomplete process. The colection have 3 fields
1. customer code no
2. customer name
3. address
The datas are fetched from google spreadsheet to the collection. I have used a code as given below.

<#assign object>
{
"customername":"${result[P_index].customername?default("")}",
"customercodeno":"${result[P_index].customercodeno?default("")}",
"address":"${result[P_index].address?default("")}"
}
</#assign>
${save_object(object,"user")}

The collection is put inside a loop with Array ${result}

The collection will throw out an error whenever the spreadsheet is empty. How can I fix this issue?
Please find attachments

[banerjee...@gmail.com]

WHAT TYPE OF ACTIVITY ARE YOU USING FOR ADD TO COLLECTION??

[ideasandinno...@gmail.com]

Hi

I am using this collection for autocomplete in another process.

[Hamza Maghous]

Hi, 

  

Result is not an array in this case, you can use freemarker function P_to_array(result) on you array to resolve this problem

see : http://docs.runmyprocess.com/API_Reference/FM/Utilities.html

On Wed, Jul 9, 2014 at 8:46 AM, <ideasandinno...@gmail.com> wrote:

Hi

I am using this collection for autocomplete in another process.

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "RunMyProcess Support Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum...@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at http://groups.google.com/a/runmyprocess.com/group/supportforum/.

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/fe32ad65-037c-42a0-a52b-d3913663f3da%40runmyprocess.com.

For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

--

Hamza MAGHOUS

PreSales Consultant

Website: Fujitsu RunMyProcess

[ideasandinno...@gmail.com]

Hi

Can you show me an example? I didnt get what you have meant.

Thanks

[Hamza Maghous]

Alright, my bad, you can't use P_to_array to resolve the problem in this case.

If you have an error only when the spreadsheet is empty, you can use <#attempt> in freemarker so  you will not have the  error :

<#attempt>

Code that may return an error

<#recover>

code to execute in case of error

</#attempt>

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "RunMyProcess Support Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum...@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at http://groups.google.com/a/runmyprocess.com/group/supportforum/.

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/45ccf203-63b0-454e-8654-0751a4318d1c%40runmyprocess.com.

For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

[ideasandinno...@gmail.com]

Hi

Sorry. I cant understand what you meant. Can you be more specific?
Where should I add the extra codes to?

[Richard Manga]

Hi,

try to use the following code:

<#if (result?default([])?size!=0)>

> <#assign object>

>   {

>        "customername":"${result[P_index].customername?default("")}",

>       "customercodeno":"${result[P_index].customercodeno?default("")}",

>       "address":"${result[P_index].address?default("")}"

>   }

>   </#assign>

>   ${save_object(object,"user")}

</#if>

Regards,

Richard

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "RunMyProcess Support Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum...@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at http://groups.google.com/a/runmyprocess.com/group/supportforum/.

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/1dc2b1df-24b7-401d-956b-12294c2cfb56%40runmyprocess.com.

[ideasandinno...@gmail.com]

Hi

Sorry. It is not working. Shows the same error as before.

Thanks

[Richard Manga]

Good morning,

Please, can you send me the content of the parameter "result" (you can find it in computed parameters).

Specify also data you want to extract from the result in order to build the object we use in our saveObject function.

Regards,

Richard

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "RunMyProcess Support Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum...@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at http://groups.google.com/a/runmyprocess.com/group/supportforum/.

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/c7e788a3-beb6-4765-8b6c-88d92ae7ca83%40runmyprocess.com.

[ideasandinno...@gmail.com]

Hi

The computer parameters screenshot is attached with this mail. I need to store
1. customername
2. customercodeno
3. address
values into the collection.
The collection will store datas whenever the spreadsheet contains more than one row of details. But when the spreadsheet has only one row the collection will not get updated.

Thanks