Level 3 training Main excercise 2 GetWorkItems returning null data table

[charliefik (Clark Coleman)]

Hi,

I’ m having some issues with the excercise. I’ve followed the problem back to the GetWorkItems sequence. Which Extracts structured data (all of the work items unfiltered and should put the result into a datatable variable which I have created, so why doesn’t it???!!!)

properties for the Extract data activity with the output going to dtWorkItems

Here is the variable definition

When I run the work flow in debug mode dtWorkItems shows as null in the locals window

I added a write range to excel activity to see the contents of the data table but as it’s null there isn’t a lot of joy there.

Here is the xaml if anyone can give me a clue please.

System1_GetWorkItems.xaml (8.5 KB)

I can see the extract going through the webpages until the last one so it should be picking up the data and the output datatable is there also (so what is going wrong?)

[irahmat (Indra Rahmat)]

Hi,

I did little bit change and it’s working

[Jersey_Practical_Sho (Jersey Practical Shooter “X X Sonic Loss Xx”)]

add this to your variable

in the Vb expression part

[charliefik (Clark Coleman)]

@Jersey_Practical_Sho. Thanks very much for the info putting that default value in enabled me to write range to excel (first column is blank don’t know why but at least there is now data there).

Do you know why this New Datatable default has to be added. Is it becasue it is an object rather than just a normal variable (most variables don’t need a default when they are created so why does this?) .

[charliefik (Clark Coleman)]

@irahmat could you please let me know what you did to get the workflow working.

@Jersey_Practical_Sho suggested to add New System.Data.Datatable to the ExtractDataTable definition but I’m not sure why this is necessary.

Maybe you did something different I’m not sure from your post what you did.

[Jersey_Practical_Sho (Jersey Practical Shooter “X X Sonic Loss Xx”)]

When I originally went through this exercise, I had exactly the same issue as yourself. So I Started over from the very beginning of the Scraping process and the system added New System.Data.Datatable in when I completed the extract data table part.

[irahmat (Indra Rahmat)]

Exactly, that just what I did.

[charliefik (Clark Coleman)]

Thanks guys hopefully I’m one step nearer to finishing this excercise

[Jersey_Practical_Sho (Jersey Practical Shooter “X X Sonic Loss Xx”)]

I am literally at the point just after you and now Im stuck on the Assign part or moreover where it goes. Ill add you as a friend on here and see how we get on?

[charliefik (Clark Coleman)]

Thanks Jersey good luck, of course I’ll let you know if I have any insights.

[irahmat (Indra Rahmat)]

please be careful of white space. Always use trim on the string. because u will don’t know the result will be same as their expected or not.

[charliefik (Clark Coleman)]

Thanks @irahmat for the info I think I had to do some regex (and I don’t know anything about regex I found an example in the forum somewhere so that the result would only allow letters and numbers to get rid of non printable characters like newline that wasn’t being removed by the trim function)

The split part finds the text between Client ID: and Client Name: (it takes the array index (1) )
The regex bit only allows characters and numbers so hidden characters are removed.
system.Text.RegularExpressions.Regex.Replace((Trim(AllWIDetails.Split({“Client ID:”, “Client Name:”}, StringSplitOptions.None)(1))), “[^a-z A-Z 0-9]”, “”)

I got the basis of this from the forums (I couldn’t find this material in any UiPath learning materials, which I think it should be if in the walkthrough it basically says

I don’t think that this was covered sufficiently in the learning materials (In my opinion).

As for the assign you need to create a out argument and then assign the datatable to it (it’s in my xaml from the first post, if that’s the assign you’re talking about)

[Jersey_Practical_Sho (Jersey Practical Shooter “X X Sonic Loss Xx”)]

This was the assign I was talking about

[charliefik (Clark Coleman)]

That select returns an array of data rows (I thought initially it returned a table so my WIList was a datatable variable which was wrong).

So you’ve sorted that now right?

I have that assignment after System1_Close Workflow in the init. However I have other issues with transaction items which I’m composing now

[Jersey_Practical_Sho (Jersey Practical Shooter “X X Sonic Loss Xx”)]

This is what I have so and it works, set it as an argument so that it can be used globally

its from there on that im stuck, here on

[charliefik (Clark Coleman)]

Yes I agree this is a very badly described section and where my process is messing up too. I’m writing out a post with my issue.

[charliefik (Clark Coleman)]

Level 3 training Exercise 2 Process Transaction problem

Hi All, In my process workflow the first activity I have is Invoke the System1_NavigateTo_WIDetails.xaml I have an error message on my in_transactionItem value. [image] The error message is this [image] This is my process (to not get the answer) First I need to work out where in_TransactionItem comes from So in REFFramework I go to main -> General Business Process -> Process Transaction In there is Invoke Process transaction workflow with input arguments in_Transaction coming from the v…

This is the new post with my gettransactiondata workflow (in the post)