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

InfoPath Dev

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

Last post 05-09-2012 04:03 PM by jcsaavedra. 20 replies.
Page 1 of 2 (21 items) 1 2 Next >
Sort Posts: Previous Next
  • 05-08-2012 02:23 PM

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

    HELLO I HAVE INVESTIGATED FOR A COUPLE OF WEEKS AND CANT NOT DO MY REPEAT STRUCTURE OTHER STRUCTURE IS HAPPENING TO REPEAT.
    SO IF THIS:
    I HAVE A HIGH CONNECTION NODES WHICH HAS SEVERAL REPEAT LAST BUT WANT replicate NODOQUE IS A TABLE EXTENSION TO MAIN EXTENSION TABLE SO I'M concatenating

    concatenar("CopyTable /tablesrc=/dfs:myFields/dfs:dataFields/ns2:getestructuraResponse/ns2:getestructuraResult/ns2:cot_fa/ns2:coti_fase/ns2:cot_serv /rowsrc=ns2:coti_servicios /tabledest=/my:misCampos/my:datafield/my:getestructuraresponse/my:getestructuraresult/my:cotfa/my:cotifase/my:cotserv /rowdest=my:cotiservicios /empty=", empty)

    COULD GUIDE ME AS I AM WRONG
  • 05-08-2012 02:27 PM In reply to

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

    Any chance you could attach the form you are trying this with to a reply under the options tab? Or a screen shot of your main data source?

    Hilary Stoupa

  • 05-08-2012 05:32 PM In reply to

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

    This first picture is of my secondary data connection
    secondary data connection

    This second image is where I want to put data containing the secondary connection

     

    and I was trying and my concatenation is as follows

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

     I could help because I have a week with this thanks

     

  • 05-09-2012 07:17 AM In reply to

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

     NEED TO PASS THE DATA IS A TABLE coti_servicos AN EXTENSION CONNECTION IS SECONDARY TO QUES coti_servicios HOME IN CONNECTION

  • 05-09-2012 08:08 AM In reply to

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

    In my reply to one of your other posts on this, I suggested that the issue may be with your rowdest param:

    /rowdest=coti_servicios

    I'd expect:

    /rowdest=my:coti_servicios

    I also recommended that you put the error node from the QdabraRules data source on your form temporarily to see if you are getting any errors. Have you tried the above change? Have you added the error node?

    I see your source data is a nested repeating data source. I'd anticipate only the first instance of that table would be copied in - you may need to add some logic to loop through all instances, but if it were my form, I'd just try to get the basics working first.

    Hilary Stoupa

  • 05-09-2012 08:14 AM In reply to

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

     TRY AND CHANGE you suggested BUT WILL NOT WORK SO I HAVE MY Concatenation

    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=my:coti_servicios /empty=", Empty)

  • 05-09-2012 08:18 AM In reply to

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

    I'd really recommend you put the error node from the QdabraRules data source on your form temporarily to see if you are getting any errors. Have you added the error node? If so, what are your errors?

    Hilary Stoupa

  • 05-09-2012 08:23 AM In reply to

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

     ok now I'm adding

  • 05-09-2012 08:30 AM In reply to

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

     I get this error

    Failed to select the source table to copy from.

  • 05-09-2012 08:42 AM In reply to

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

     SO NOW I HAVE MY Concatenation

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

    I get this ERROR OTHER
     

    Failed to add rows to destination table copied.

  • 05-09-2012 09:05 AM In reply to

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

    Can you either attach your form here (under the options tab) or send it to Support AT Qdabra DOT com, referencing this thread, so I can see if I can figure out what is wrong?

    Hilary Stoupa

  • 05-09-2012 09:31 AM In reply to

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

     LET ME NOT MY FILE ATTACHED SAYS


    The maximum file size allowed is 128kB. Please select a valid file.

    HOW CAN I SEND YOU?????

  • 05-09-2012 09:42 AM In reply to

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

    I'd love it if you could lay off the caps lock key. I feel like you are yelling at me. :-)

    As I mentioned in the post above this, please send to support AT qdabra DOT com - replace the at and the dot with the usual characters. Thanks.

    Hilary Stoupa

  • 05-09-2012 10:02 AM In reply to

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

     In qdabra page in soprte not find where I could send my form guide you if so amabla as it has been until now

  • 05-09-2012 10:44 AM In reply to

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

    I've sent you an email via the forum - you can just reply to that with your template. It will probably be later today before I have a chance to take a look, but I'll take a look sometime today and get back to you.

    Hilary Stoupa

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