qRules copy table function to copy a table from an external data source - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

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

Last post 05-08-2012 02:20 PM by Hilary Stoupa. 6 replies.
Page 1 of 1 (7 items)
Sort Posts: Previous Next
  • 01-06-2011 07:47 AM

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

    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!


  • 01-06-2011 08:05 AM In reply to

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

    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.

    Ernesto Machado
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™


  • 01-06-2011 08:59 AM In reply to

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

    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!

  • 01-07-2011 07:20 AM In reply to

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

    Great!

    Ernesto Machado
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™


  • 05-08-2012 02:09 PM In reply to

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

     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)

  • 05-08-2012 02:11 PM In reply to

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

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

  • 05-08-2012 02:20 PM In reply to

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

    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.

    Hilary Stoupa

Page 1 of 1 (7 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.