InfoPath Dev

Hi!

I'm trying to use the qRules copy table function to copy a table from an external data source.  I'm getting a Qdabra Rules Error: An error has occured executing the rule.  See below detail:

Usage is:

CopyTable
 [/dsnamesrc=Data Source Name (Source)]
 /tablesrc=XPath to Table (Source)
 /rowsrc=Relative XPath from Table to Row (Source)
 [/dsnamedest=Data Source Name (Destination)]
 /tabledest=XPath to Table (Destination)
 /rowdest=Relative XPath from Table to Row (Destination)
 [/empty=Clear the destination table before copy (yes | no)]

I have the following in the value of the action:

CopyTable /dsnamesrc=GeteRMDBXLActivity /tablesrc=/dfs:myFields/dfs:dataFields
/rowsrc=tns:GetColumnsXMLStrQueryResponse/tns:GetColumnsXMLStrQueryResult/Rows/row /tabledest=my:myFields/my:Activities /rowdest=my:row /empty=yes

Attached is a screenshot of my data source.  I suspect I did this part wrong: /rowsrc=Relative XPath from Table to Row (Source)
Please help!

Hi Sam,

The /rowsrc parameter is incorrect. It must point directly to the repeating node.

Please try this, where the full xpath (minus the repeating node) is provided as /tablesrc, then the repeating node is alone as /rowsrc.

CopyTable /dsnamesrc=GeteRMDBXLActivity /tablesrc=/dfs:myFields/dfs:dataFields/tns:GetColumnsXMLStrQueryResponse/tns:GetColumnsXMLStrQueryResult/Rows/
/rowsrc=row /tabledest=my:myFields/my:Activities /rowdest=my:row /empty=yes

Let us know if this works. Thanks.

Hi Ernesto,

Thanks for the fast response!  I just removed an extra backslash you had and it worked like a charm.  Here is the final that worked:

CopyTable /dsnamesrc=GeteRMDBXLActivity /tablesrc=/dfs:myFields/dfs:dataFields/tns:GetColumnsXMLStrQueryResponse/tns:GetColumnsXMLStrQueryResult/Rows /rowsrc=row /tabledest=my:myFields/my:Activities /rowdest=my:row /empty=yes

Thanks so much!

Great!

 concatenar("CopyTable /dsnamesrc=getestructura /tablesrc=/dfs:myFields/dfs:dataFields/ns2:getestructuraResponse/ns2:getestructuraResult/ns2:cot_fa/ns2:coti_fase/cot_serv /rowsrc=coti_servicios /tabledest=/my:misCampos/my:Servicios /rowdest=coti_servicios /empty=", Empty)

I have this structure and does not work could help me??

Hi - have you put the Error node from the Qdabra Rules data source on your form to see if you have any errors?

I think the issue is here:

/rowdest=coti_servicios

At the very least, I'd expect to see the same namespace prefix as in your /tabledest parameter:

/rowdest=my:coti_servicios

If the repeating node in your main data source has the same name as your source data.