Question

Processing Table Rows into a SQL Database with for each row activity

Updated June 20, 2017

asked on June 19, 2017

Hi,

I'm trying to insert each table row in my laser fiche form separately into SQL database and cannot manage to make the 'for each row ' activity to work! it simply does nothing! here is my workflow:

Not sure what exactly i'm missing.

I've been searching a lot and cannot simply find a step by step of how to do unfortunately. all I could find is to use the 'for each row' activity but no instruction of how exactly.

Thanks,

Mary

0 0

Replies

replied on June 20, 2017

Hello Mary,

Can you provide a little more information? I think where your issue lies is in the "Retrieve LF Forms Content" workflow action. Generally this is invoked from an Invoke Workflow event in a business process in Forms. I don't believe that there is a way to "tell" the workflow form which forms instance to retrieve the forms content from, thus, as your workflow runs, it does nothing at this step due to it action not returning any values to insert into you SQL table.

0 0

replied on June 20, 2017

Hello Glenn,

Thanks for your reply.

As you mentioned, it seems that my LF from content activity is not set up correctly. Will try to fix this part first and then try the for each row activity.

thanks, May

0 0

replied on June 20, 2017

Have you checked the instance details? Does your Retrieve Forms Content activity get the values you expect?

0 0

replied on June 20, 2017

Hi Miruna,

Thanks for your reply.

Yes I think you are right. It seems that my LF from content activity is not retrieving the values at all. it's my first workflow that I'm creating so no surprises that it hasen't been set up properly :) I will go through the activity to double check and see what happens.

Thanks,Mary

0 0

replied on June 20, 2017

Are you starting this workflow from Forms? If you're not, you need to specify a Forms instance ID and submission ID in the Retrieve Forms Content activity so it knows where to read fields from. If you're starting it from Forms, then Forms passes that information down.

0 0

replied on June 20, 2017

Now I'm struggling to get this LF form content activity to work! how would I specify instance ID and submission ID in the Retrieve Forms Content activity ???

0 0

You are not allowed to follow up in this post.

Question

Question

Processing Table Rows into a SQL Database with for each row activity

Replies

Sign in to reply to this post.