Collection to HTML table

[bestfri...@gmail.com]

Hi,

Is it possible to display collection to HTML table in RMP?

Collection name: testcsv123

Column names in collection - Item Number,Part Number,Name

[Sabine El Rassy]

Hello Nagasai,

You need to build your HTML table manually. Here's a code that can inspires you:

 var my_pattern = {};
 col_name.listCallback(my_pattern, {}, load_ok, load_ko);
 
function load_ok(result) {
var html_table="<table><tr><td>Item Number</td><td>Part Number</td><td>Name</td></tr>";
var my_object = result;
for(var i =0;i<result.length;i++){
my_object= result[i];
html_table=html_table+"<tr><td>"+my_object.item_nb+"</td><td>"+my_object.part_nb+"</td><td>"+my_object.name+"</td></tr>";
}
html_table=html_table+"</table>";
id_your_html.setHtml(html_table);
}

function load_ko(result) {alert("ko " + JSON.stringify(result));}

Regards,

Sabine

[bestfri...@gmail.com]

Hi Sabine,

In process flow ,can i use collection as a staging table and display content in HTML in every process step?


Thanks alot in advance

[Sabine El Rassy]

Hello Nagasai,

I didn't get exactly what you mean. If you set a variable with a specific content in your interface, the value of this variable will be available in your process as well. 

Hope you got your answer.

Regards,

Sabine EL RASSY

PreSales Consultant

Contact: selr...@runmyprocess.com

Website: Fujitsu RunMyProcess

     

Fujitsu RunMyProcess user? Please add a review on GoogleApps Marketplace

Afin de contribuer au respect de l'environnement, merci de n'imprimer ce message qu'en cas de nécessité.

Be environmentally friendly: do not print this email unless it is entirely necessary.

--
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/3ca0ad32-5f30-4157-8279-4cd98cab4d49%40runmyprocess.com.

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

[bestfri...@gmail.com]

On Wednesday, September 4, 2013 11:35:27 AM UTC-4, Sabine El Rassy wrote:
> Hello Nagasai,
>
>

> I didn't get exactly what you mean. If you set a variable with a specific content in your interface, the value of this variable will be available in your process as well. 
>
> Hope you got your answer.
>
>
> Regards,
>
>
>
>
> Sabine EL RASSY
>
>
>
>
> PreSales Consultant
> Contact: selr...@runmyprocess.com
>
> Website: Fujitsu RunMyProcess
>
>
>
>      
>
>
>
>
>
>
>
>

Hi Sabine,

I am using the collection data from the post..

https://groups.google.com/a/runmyprocess.com/forum/?hl=en&fromgroups=#!mydiscussions/supportforum/q5ipN7_jhlA


Data coming from that collection , i am trying to display in HTML table.

I am getting below error like - undefined for the cells in HTML table.

[bestfri...@gmail.com]

Hi Sabine,

I found that the issue is the name of the Property - which has space

Property- Item Number in collection report setting


How to use it while using table,

my_object.Item Number wont work


Could you please suggest how to proceed?

[Sabine El Rassy]

Hello Nagasi,

In deed, the name of your variable should not contain any spaces. When you import your excel file, the title of the columns will be the name of your variable so make sure that it does not contains any spaces before you do your import.

Regards,

Sabine

Sabine EL RASSY

PreSales Consultant

Contact: selr...@runmyprocess.com

Website: Fujitsu RunMyProcess

     

Fujitsu RunMyProcess user? Please add a review on GoogleApps Marketplace

Afin de contribuer au respect de l'environnement, merci de n'imprimer ce message qu'en cas de nécessité.

Be environmentally friendly: do not print this email unless it is entirely necessary.

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/e908a900-771f-42f1-854f-487d472e60c0%40runmyprocess.com.

[bestfri...@gmail.com]

On Wednesday, September 4, 2013 1:10:51 PM UTC-4, Sabine El Rassy wrote:
> Hello Nagasi,
>
>
> In deed, the name of your variable should not contain any spaces. When you import your excel file, the title of the columns will be the name of your variable so make sure that it does not contains any spaces before you do your import.
>
>
>
>
>
> Regards,
> Sabine
>
>
>
>
> Sabine EL RASSY
>
>
>
>
> PreSales Consultant
> Contact: selr...@runmyprocess.com
>
> Website: Fujitsu RunMyProcess
>
>
>
>      
>
>
>
>
>
>
>
>

is there any work around for it, because the column names are difficult to change as it will be generated as it is from DB?

[Sabine El Rassy]

Hello Nagasai,

You must change the name of your variables. You cannot have spaces in the variable name and expect to not have problems later.

Regards,

 

Sabine EL RASSY

PreSales Consultant

Contact: selr...@runmyprocess.com

Website: Fujitsu RunMyProcess

     

Fujitsu RunMyProcess user? Please add a review on GoogleApps Marketplace

Afin de contribuer au respect de l'environnement, merci de n'imprimer ce message qu'en cas de nécessité.

Be environmentally friendly: do not print this email unless it is entirely necessary.

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/1e644ac0-3a0a-4b97-8a0b-f7f0fc76be9e%40runmyprocess.com.