Important By default, the Approval workflow is not activated and is not listed in the Select a workflow template list box of the association form.Nintex Workflow Parse CSV and Create a List.Tuesday, December 1.AM. Thursday, April 1.PM. re Nintex Workflow Parse CSV and Create a List.Does the Execute SQL action only store a single column if stored in a collection Thanks you have some great information here I really appreciate the time you have taken to post Thursday, April 1.PM. re Nintex Workflow Parse CSV and Create a List.Hi,yes the Execute SQL action store the first column of your query into the collection variable.But, if you have a newer build, you can specify which columsn you want and store each in their own Collection variables.One action to rule them allVadim.Monday, September 3.AM. re Nintex Workflow Parse CSV and Create a List.Hi, that example is great.I have a question How can I read a csv file from a network drive no http For example a file at the server servernameordnername is updated every month and has to be readed by the nintex workflow.Is there a common action, which can handle such a taskMonday, September 3.AM. re Nintex Workflow Parse CSV and Create a List.Hi Andy,theres no action out of the box that Im aware of, to read from a network share.You may need to look at putting it into a library or building a custom action.Vadim. Tuesday, October 1, 2.AM. re Nintex Workflow Parse CSV and Create a List.Hi Vadim,Thank you for your response Putting the file into a library is the way we work at the moment.Ok, looks like that would not change.Great blog and great work Cheers,Andi.Tuesday, October 1, 2.AM. re Nintex Workflow Parse CSV and Create a List.Hi Vadim,is there a way to import a csv using Nintex 2.Cheers, Dirk. Tuesday, October 1, 2.AM. re Nintex Workflow Parse CSV and Create a List.SmUjD1c/TuhFmNE8EDI/AAAAAAAAAwU/1S-VWRFIiVQ/s1600/query-list.png' alt='Update Multiple List Items Sharepoint Workflow Template' title='Update Multiple List Items Sharepoint Workflow Template' />Hi Dirk,Not that Im aware of.Theres a Copy to File Share action, but not a Copy from File Share.There was some talk a while back about Web.DAV, but I dont know much about that.Vadim. Tuesday, October 1, 2.AM. re Nintex Workflow Parse CSV and Create a List.Andi,thanks for the kind comments.Vadim. Thursday, November 2.PM. Thursday, February 2.I have come across some pretty beefy workflow implementations, and considerably complex large listcontent scenarios.I would need more information to make an.AM. re Nintex Workflow Parse CSV and Create a List.Hi Vadim,I downloaded your sample Workflow and the list templates in the hope of reusing it with modifications.The sample workflow stops on Runif Action even though the workflow status message says that it is complete. Dvd Da Galinha Pintadinha Completo Download Games on this page. I havent done any modifications to your sample except to the user name and password where it calls the Web Request action.I am quite new to Nintex and I am learning as I work with these samples.Workflow history shows it is completing the steps up to Run.If and the rest of the steps are all grayed out.Any pointers or tips would be helpful.Thank you. Basmall.Saturday, February 2.AM. re Nintex Workflow Parse CSV and Create a List.Hi Basmall,I would recommend you use the Log in the History List action and log the values of some of the variables.Such as the ones being used in the Run If action.That should give you an idea of why the workflow isnt going into the Run If.Vadim. Tuesday, March 1.AM. re Nintex Workflow Parse CSV and Create a List.Hey Vadim, First of all thanks for the post.Saved me a lot of effort.I have one issue though.When I split the CSV using nr I get all my rows in one line.Basically it doesnt split.Then I tried this instead I cleaned the pattern textbox in the split action and just hit ENTER once in the pattern textbox i.ENTER. Now it splits fine but adds a blank line at the end of the collection.Is there something I am missing Thanks Surya.Monday, March 3. AM.Kunal Patel. Nintex Workflow Parse CSV and Create a List.Hi Vadim,Your worflow is not working for me.I have 3 columns first second are an alphanumeric while 3rd one has the domain name1.If I keep r then it wont run actions inside Run If.If I remove r then it stores the first column value in all 3 variables under Run Parallel actionI am not sure what Im doing wrong Please advise.Thanks,KP. Monday, March 3.AM. re Nintex Workflow Parse CSV and Create a List.Hi Kunal,can you email me an example of your CSV and Ill see why the workflow isnt workingVadim.Monday, March 3. PM.Bryan Malone. Friday, April 4, 2.AM. re Nintex Workflow Parse CSV and Create a List.Hi Bryan,the For Each is configured to go through one of the collections and store the value in the appropriate variable and also the index into a number variable.ITs then using the Collection Operation action to do a Get from another collection and using the index we have.So we are getting the related value from each collection.Tae a look at this http www.Vadim. Wednesday, April 9, 2.AM. Bcobra. Thursday, April 1.AM. bcobra. Nintex Workflow Parse CSV and Create a List.What regular expression would you use to remove commas in quoted strings within the CSV before splitting on the commas EX 0.IT0. OBLG,IT 0. 04 BENSON,F ATLANTA 13 9,5.D5. 84,2. 14. 3,5.CDC0. 1,4. 2. 0. Thursday, April 1.AM. re Nintex Workflow Parse CSV and Create a List.Hi bcobra,Im not sure what Regex would do that.You might need to come up with something a little more elaborate.Vadim. Friday, April 1.AM. bcobra. Friday, April 1.PM. re Nintex Workflow Parse CSV and Create a List.HI bcobra,Im sorry, I wouldnt know of another way to do that.But then, Im not a regex expert.Im not sure what that would be slow though.Vadim. Wednesday, April 2.AM. BBasmall. Nintex Workflow Parse CSV and Create a List.Hi Vadim,I am able to run your workflow without issues once i did the switch from nr to rn as suggested in bcobras post.The workflow runs and populates the list as expected and then it errors out at the end.I have an idea why it is doing it, but have no idea how to fix the issue.What I believe the issue is, that the workflow runs and after adding all the items from the string errors out as it cannot find any more items to process at For Each loop.Is there a way to stop the loop after all the items are processed I have created an other work flow based on your example and it exhibits the same behavior after cycling through the loop it errors out at For Each loop once it encounters a blank value at the end of the string.I have pasted the error message at the bottom.Event Message Outcome Workflow Comment Error operating on collection variable.Index property is greater than the number of items in the collection.Thank you. Basmall.Wednesday, April 2.AM. re Nintex Workflow Parse CSV and Create a List.Hi Basmall,this is happening because your collection variables are not all the same size.It looks like your first collection may have n number of items in it, and one of your other collections has less than that, and that is what is causing the Collection Operation GET to fail with this error.This can happen if you have some number of rows, but one of the rows has less columns in it.What I would recommend, is before the For Each, you run a Collection Operation action on each collection and configure it to do a Count and log that to the workflow history, Youll find that the one or more of your collections are different sizes.Vadim. Thursday, April 2.PM. Basmall. Nintex Workflow Parse CSV and Create a List.Hi Vadim,Thank you very much for the clarification.You are bang on. I checked the collections and out of the 4 collections I have 3 of them are giving me a count of 4 and the remaining one shows a count of 1.Could this be an issue with the CSV fileThough I am getting this error the workflow is copying the data that I need.If it is an issue with the data file is their a a way in Nintex to stop the loop when it encounters the error and bypass the workflow to completion.We may get source files that could some times be corrupted.Thank you. Basmall.Thursday, May 1, 2.AM. bcobra. Thursday, May 8, 2.AM. re Nintex Workflow Parse CSV and Create a List.Hi,Thank you for the great article I have imported the workflow and when I run it, it is failing with the error Coercion Failed Unable to transform the input lookup data into the requested type.Looking at the history log, the for each is running for the first line, because the index is 0 the run if doesnt run as expected.The for each then processes the second line in the CSV file but this then fails at the Run If step with the above error message.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
November 2017
Categories |