I am making good use of Nintex Data Tables now. It is especially good for getting a quick response in your workflow form. Sometimes calls to our on-prem SQL database take several seconds. But I ran into a problem whenever I moved my data from Test into Production. While there is a nice “Import” feature to Tables, there is no Export. So I built one, and I’ll display that here below.
The “Import” process takes a CSV (Comma Separated Values) file, so I will generate that using a workflow in my Test environment.
First, create a workflow and set the Start Event as a Nintex Component workflow.
Insert the following actions that we will configure:
- Query a table
- Create a text string
- Loop for each
- (inside your loop) Create a text string
- Send an email (or substitute some other method of obtaining your output
Configuring these actions:
For “Query a table” you simply select your Table and select all the columns you want. If you want all the rows, then don’t add any Conditions. Complete the other settings and create an output object.
In “Create a text string” you will be creating a header line, including the newline at the end. In my case, I had these column headers:
"Name","Facility","Address","County","City","Number","Manager"<br/>
Send the result to a text variable.
In “Loop for each” set the Target Collection to the “Rows” from your data table variable.
Inside the loop, in Create a text string, you will create a row in your text file, like this:
send the result into the same variable. You are appending a new row to the text variable with each pass through the loop.
Now, outside the loop, send the output to yourself. I used “Send an email” but you can also develop another method to obtain the output.
Now you can use this output text file in the Import table process in your Nintex Production environment.
