cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

Import values from sql server table

I need to import from a table into sql server the values for a list in SharePoint.

This list should be updated every day at same time.

How can i do this?

I can not find any workflow object that does this.

Labels: (2)
0 Kudos
Reply
3 Replies
Workflow Hero

Re: Import values from sql server table

Hi Jose,

you can use the "Execute SQL" workflow-action you'll find under "Integration".

Regarding the Edition Comparison Table, this action is available for Nintex 2007/2010/2013 and can be used in Standard and Enterprise Version. If you do not see this action, make sure its checked under "Allowed Workflow Actions" settings in Site Settings and Central Admin.

For the daily execution create a site workflow which can later be scheduled to run e. g. once a day.

Cheers

Philipp

Accept as Solution Reply
Workflow Hero

Re: Import values  from sql server table

thanks for the answer,

i had try do that.  how do to configurate.

Can you give me an example please

I have this situation:

The field of SQL QUERY  "BaseDescription" corresponds to the field called departament from the list.

regards

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: Import values from sql server table

Hi Jose Fidalgo

I recommend censoring your SQL post a bit, as the PW is shown ...

Moving forward, though..  you would put a variable into the "Store Result In" if the SQL process you are calling has a return item.

For example, in my Execute SQL, the action I call is called "exec spNintex_AddInspection" and then I have a bunch of data I feed it.

It takes that data, and then gives me back the ID of the new inspection it has created.

So your answer is ... it depends! But if you are only trying to PUT data, then you should be okay without one I think..

0 Kudos
Accept as Solution Reply