Qdabra qRules

Re: Copy Table syntax

Hilary Stoupa — Wed, 02 Jun 2010 19:53:51 GMT

The CopyTable command requires that the destination node is the only child of its parent node. In general, this is the optimal way to structure your XML, so it encourages best practices.

We need to update our documentation to highlight this, however. Thanks for bringing it to our attention!

Re: Copy Table syntax

Marzipan — Fri, 28 May 2010 13:07:23 GMT

That worked!

Now can you explain why?

Re: Copy Table syntax

Mel Clemente — Thu, 27 May 2010 21:04:56 GMT

Hi Marzipan,

Please create another group to hold your Task repeating group, something similar to this:

So under the Tasks root node, add a new group (in this case I called it 'TaskGroup) and then move your Task repeating group inside it. Your command should then be:

CopyTable /dsnamesrc=GetListItemsStr /tablesrc=/dfs:myFields/dfs:dataFields/ns2:GetListItemsStrResponse/ns2:GetListItemsStrResult/Rows /rowsrc=row /tabledest=/my:Tasks/my:TaskGroup /rowdest=my:Task /empty=yes

That should hopefully resolve the issue. Please let us know otherwise.

Re: Copy Table syntax

Marzipan — Thu, 27 May 2010 19:45:19 GMT

I added the "yes" value, new error.

An error has occurred executing the rule. Failed to add copied rows to destination table.

Re: Copy Table syntax

ErnestoM — Thu, 27 May 2010 18:55:22 GMT

Can you give /empty a value? (/empty=yes) Though the error points elsewhere, I want to rule that out as the issue.

Thanks!

Re: Copy Table syntax

Marzipan — Thu, 27 May 2010 18:09:56 GMT

Since the source is elements, I changed the destination back to elements.

Still getting: An error has occurred executing the rule. Failed to select the destination row to copy to.

CopyTable /dsnamesrc=GetListItemsStr /tablesrc=/dfs:myFields/dfs:dataFields/ns2:GetListItemsStrResponse/ns2:GetListItemsStrResult/Rows /rowsrc=row /tabledest=/my:Tasks /rowdest=my:Task /empty

I attached my form.

Re: Copy Table syntax

ErnestoM — Thu, 27 May 2010 17:43:27 GMT

The destination needs to match the source. So if the source is attributes, the destination must be attributes as well.

/tabledest= is the container group and /rowdest= needs to point to the repeating node.

Re: Copy Table syntax

Marzipan — Thu, 27 May 2010 17:40:14 GMT

looking back over "Copy SharePoint List Data to Main Data Source" it looks like I need to create the Main fields as attributes. I'm trying that now.

Re: Copy Table syntax

Marzipan — Thu, 27 May 2010 17:07:17 GMT

Now it looks like the destination syntax is incorrect.

An error has occurred executing the rule. Failed to select the destination row to copy to.

Re: Copy Table syntax

ErnestoM — Thu, 27 May 2010 16:10:11 GMT

This

/rowsrc=dfs:row

Should probably be

/rowsrc=row

Can you try that out? Thanks!

Re: Copy Table syntax

Marzipan — Thu, 27 May 2010 15:58:49 GMT

Still getting error: An error has occurred executing the rule. Failed to select the source row to copy from.

CopyTable /dsnamesrc=GetListItemsStr /tablesrc=/dfs:myFields/dfs:dataFields/ns2:GetListItemsStrResponse/ns2:GetListItemsStrResult/Rows /rowsrc=dfs:row /tabledest=/my:Tasks /rowdest=my:Task /empty

Re: Copy Table syntax

ErnestoM — Thu, 27 May 2010 14:06:43 GMT

Hi Marzipan,

I believe that the /tablesrc parameter might be incorrect. I'm thinking it should be /dfs:myFields/dfs:dataFields/ns2:GetListItemsStrResponse/ns2:GetListItemsStrResult/Rows (which is the container) and then /rowsrc is the repeating field row.

As you create your command, you can display the qRules error node in the view, and this will provide you with information about the correct syntax, invalid parameters, errors encountered, etc.

Copy Table syntax

Marzipan — Thu, 27 May 2010 13:43:12 GMT

Here is the xpath for my source (sp list) and destination:

Source xpath: /dfs:myFields/dfs:dataFields/ns2:GetListItemsStrResponse/ns2:GetListItemsStrResult/Rows/row

Destination xpath: /my:Tasks/my:Task

Is this the proper syntax for Copy Table?

CopyTable /dsnamesrc=GetListItemsStr /tablesrc=/dfs:myFields/dfs:dataFields /rowsrc=dfs:Rows /tabledest=/my:Tasks /rowdest=my:Task /empty