Qdabra qRules

Re: qRules copy table function to copy a table from an external data source

Hilary Stoupa — Tue, 08 May 2012 21:20:58 GMT

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.

Re: qRules copy table function to copy a table from an external data source

jcsaavedra — Tue, 08 May 2012 21:11:12 GMT

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

Re: qRules copy table function to copy a table from an external data source

jcsaavedra — Tue, 08 May 2012 21:09:45 GMT

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)

Re: qRules copy table function to copy a table from an external data source

ErnestoM — Fri, 07 Jan 2011 15:20:40 GMT

Great!

Re: qRules copy table function to copy a table from an external data source

SamCamblin — Thu, 06 Jan 2011 16:59:47 GMT

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!

Re: qRules copy table function to copy a table from an external data source

ErnestoM — Thu, 06 Jan 2011 16:05:04 GMT

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.

qRules copy table function to copy a table from an external data source

SamCamblin — Thu, 06 Jan 2011 15:47:58 GMT

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!