topic RE: HELP in Product Forum

HELP

EstebanMontesi1 — Sat, 29 Aug 2020 03:38:00 GMT

I have an empty collection and I'm trying to add a field to it using the collection manipulation VBO add a field(text) however when I ran this stage nothing happens. I've used this action before working with queues and completed items and it worked before. What exactly is going on here?

------------------------------
Esteban Montesinos
------------------------------

RE: HELP

HarshitRawat — Sat, 29 Aug 2020 10:12:00 GMT

Hi Esteban ,
Can you please share more details about it?
Are the collection field defined already ?

------------------------------
Harshit Rawat
------------------------------

RE: HELP

NicholasZejdlik — Mon, 31 Aug 2020 13:31:00 GMT

Did you add a row after appending the field? If you append a field to a blank collection, it will appear to still be blank afterwards if you open the collection. The fields should appear once you add a row.

------------------------------
Nicholas Zejdlik
RPA Developer
------------------------------

RE: HELP

EstebanMontesi1 — Mon, 31 Aug 2020 16:46:00 GMT

I tried using the add field action (text) then I tried adding a row action using the same collection and I got the following error Internal: Cannot cast a collection value into a string and the field so I don't entirely understand why this is. The only way I find that it works is either pulling from a CSV file or xlxs or queue into a collection and then performing the add field text. While I get a decimal string type error when I add a number field.

------------------------------
Esteban Montesinos
------------------------------

RE: HELP

EstebanMontesi1 — Mon, 31 Aug 2020 16:47:00 GMT

While using an undefined collection I tried using this action and it did not work. Then I tried defining one field manually and tried to use the action and by the same token, it did not work. When I tried doing this using a queue and getting the completed items I was able to add a field(text) however when adding a field(number) I got a data error. Look for screenshots in the post below.

------------------------------
Esteban Montesinos
------------------------------

RE: HELP

NicholasZejdlik — Mon, 31 Aug 2020 18:00:00 GMT

The error is because the Collections business object is wonky and expects the name of the collection as opposed to the collection itself. That's why Add Row shows a Text data type for the Collection Name parameter, and why it's saying it cannot cast a collection into a string. Use "temporary collection" instead of [temporary collection] on Add Row and it should work.

------------------------------
Nicholas Zejdlik
RPA Developer
------------------------------

RE: HELP

EstebanMontesi1 — Wed, 02 Sep 2020 00:55:00 GMT

It does not solve the issue.Actually it throws a data type mismatch error right away.

------------------------------
Esteban Montesinos
------------------------------