Qdabra qRules

Re: Question for CopyTable command with seconday data source

poemstar — Tue, 10 May 2016 17:31:20 GMT

Hi ErnestoM,

Which version of qRule can I use to overcome that limitation?

I have some blank fields in secondary data source and I want to copy it to main data source.

I could not use CopyTable command?

Thanks.

Re: Question for CopyTable command with seconday data source

ErnestoM — Mon, 31 May 2010 13:52:46 GMT

Yes.

Re: Question for CopyTable command with seconday data source

Marzipan — Fri, 28 May 2010 18:17:00 GMT

Is this the same for MoveTable?

Re: Question for CopyTable command with seconday data source

tobiasa — Mon, 26 Apr 2010 11:42:35 GMT

Hi Ernesto,

thanks for the update and information.

Re: Question for CopyTable command with seconday data source

ErnestoM — Tue, 20 Apr 2010 16:59:24 GMT

Hi Tobias,

I have found out that this is a known issue in qRules, and we don't have a fix scheduled for it. You'll find this in the User Guide:

When using the CopyTable in a SharePoint library or list, it will only work if the nodes match, which also means each column has to have data in it (no blank fields). The reason your fields can’t be blank is because when there is a blank field, no placeholder for that field is brought down in the XML, so it’s as if that node doesn’t exist.

We apologize that this is a current limitation in qRules.

Re: Question for CopyTable command with seconday data source

ErnestoM — Mon, 19 Apr 2010 17:25:43 GMT

Hi Tobias,

I don't have a fix at the moment, but we'll investigate.

Thanks.

Re: Question for CopyTable command with seconday data source

tobiasa — Tue, 13 Apr 2010 15:36:21 GMT

Hi Ernesto,

yes, that's right, the empty values are the problem, if I added the missing descriptions the command works. Thanks for the long help.

Sometimes fields of different source lists are empty, is there a possibility to solve this case?

Re: Question for CopyTable command with seconday data source

ErnestoM — Tue, 13 Apr 2010 15:12:24 GMT

Hi Tobias,

Looks like the problem is that the source table has a blank description. I tested by adding a description and the command works. Do you expect to have many blank values in your secondary data source?

Re: Question for CopyTable command with seconday data source

tobiasa — Tue, 13 Apr 2010 14:48:48 GMT

Hi Ernesto,

I understand, so I have to change the group to a repeating field and add the attributes to the field. I changed the structure now (screenshot is attached) and got the same error. So the structure is still wrong?

Re: Question for CopyTable command with seconday data source

ErnestoM — Tue, 13 Apr 2010 13:11:38 GMT

Hi Tobias,

Your main data source still contains a repeating group instead of a repeating field, so there is still a mismatch with the secondary data source.

Re: Question for CopyTable command with seconday data source

tobiasa — Tue, 13 Apr 2010 12:53:40 GMT

Hi Ernesto,

I sent you an updated template to the support address, included is the XML source file (static).
I changed the fields to attributes, also the ordering and got still the error message.

Maybe you can modify the necessary settings so that I can see and compare what my wrong steps are.

Thanks a lot
Tobias

Re: Question for CopyTable command with seconday data source

ErnestoM — Tue, 13 Apr 2010 11:55:38 GMT

Hi Tobias,

The command is failing because your secondary data source has attributes, yet the main data source has elements. You'll need to change your main data source to have a repeating field with the four necessary attributes.

Also, when you re-design your main data source, make sure that the order of the attributes matches the secondary data source order: Title, ID, Description, Date.

Hope this helps.

Re: Question for CopyTable command with seconday data source

tobiasa — Tue, 13 Apr 2010 07:36:04 GMT

Hi Ernesto,

yes, I attached the screenshot of the main and secondary data source to this reply. I hope these pictures are enough?

Regards
Tobias

Re: Question for CopyTable command with seconday data source

ErnestoM — Mon, 12 Apr 2010 14:45:29 GMT

Hi Tobias,

The error message indicates that the source and destination have a different number of fields or attributes (and not a problem with the attribute names). Can you send me your latest XSN, or attach a screenshot of your source and destination?

Thanks.

Re: Question for CopyTable command with seconday data source

tobiasa — Mon, 12 Apr 2010 07:41:40 GMT

Hi Ernesto,

you are right, I try to copy some list entries from the Sharepoint list into a repeating table.

I changed the data source name and the fields to your example but now I get the error "An error has occurred executing the rule. The table row of the source and destination must contain the same number of elements and attributes." I have the same attributes in both tables, I changed also the order but the attribute names are different. I can't change the attribute names of the data source.

Regards
Tobias