General

Re: Copy several rows from one repeating table to another

JakeE — Mon, 17 Sep 2012 14:41:40 GMT

I solved my XPath problem, but now I have an even bigger problem. I received an error "Functions position() and last() are not supported." I'm using InfoPath 2010 and the form is not web enabled

Re: Copy several rows from one repeating table to another

JakeE — Mon, 17 Sep 2012 05:04:33 GMT

I got this far but I'm having a problem with the set field as well. Here is my XPath:

../../../my:task/my:tasks[../my:Copying = string(true())][position() = count(current()/preceding-sibling::PM_Tasks) + 1]/../../../my:task/my:tasks/my:Title

The error I receive is ""preceding-sibling::PM_Tasks" does not point to a valid location path of a field or group."

Re: Copy several rows from one repeating table to another

Jimmy — Tue, 15 Nov 2011 06:47:10 GMT

Could you check the Show XPath box to show the full formula, and also tell me what the error is?

Re: Copy several rows from one repeating table to another

jschemmel — Mon, 14 Nov 2011 20:29:09 GMT

Thanks. I was able to get that working and I am progressing a little. My insert command is working but now I am getting an error on my set fields command.

Any idea what might be wrong wiht my syntax:

BPCS_Bills[selected = "true"][position() = count(current()/preceding-sibling::group10) + 1]/BPCS_Part

@BPCS_Part[selected = "true"][position() = count(current()/preceding-sibling::group10) + 1]

My guess is the group10 is the problem??

Re: Copy several rows from one repeating table to another

Jimmy — Mon, 14 Nov 2011 17:41:14 GMT

The copy of qRules in that form is expired. You'll need to download and reinject a new trial version or purchase the full version.

Re: Copy several rows from one repeating table to another

jschemmel — Mon, 14 Nov 2011 17:03:02 GMT

Hello. I am trying to get this copy function working but I am not having success. I opened the CopySelectedRows form from the this forum string but the copy button does not seem to work. I create records in the top repeatijng table and check the button but the copy button does not show anything on the lower table.

Any help would be appreciated.

Re: Copy several rows from one repeating table to another

Jimmy — Fri, 04 Nov 2011 02:33:13 GMT

Hello JS,

I reckon that the group you're actually adding to is in the main data source, in which case you would not use the /dsname parameter. I reckon that if you check the Expand XPath option, you'll see that there's already an xdXDocument:getDOM("BCPS_Bills") in there to indicate that the count of those rows should be coming from the BCPS_Bills data source.

Re: Copy several rows from one repeating table to another

jschemmel — Thu, 03 Nov 2011 22:53:31 GMT

Jimmy. Skip that last question. I had missed the other functions. I am having trouble with the add rows command.

My command is (getting error):
concat("Insert /dsname=BPCS_Bills /parent=/my:Quote/my:Item_Detail/my:Bill_of_Material /child=/my:group10 /count=", count(BPCS_Bills[Selected = "yes"]))

Re: Copy several rows from one repeating table to another

jschemmel — Thu, 03 Nov 2011 22:53:29 GMT

Jimmy. Skip that last question. I had missed the other functions. I am having trouble with the add rows command.

My command is (getting error):
concat("Insert /dsname=BPCS_Bills /parent=/my:Quote/my:Item_Detail/my:Bill_of_Material /child=/my:group10 /count=", count(BPCS_Bills[Selected = "yes"]))

Re: Copy several rows from one repeating table to another

jschemmel — Thu, 03 Nov 2011 20:52:39 GMT

Thanks Jimmy. That helped a lot. Just one question. What controls the mapping of the fields from one reparting table to the other?

concat("Insert /parent=/my:myFields/my:group3 /child=my:group4 /count=", count(group2[selected = "yes"]))

Re: Copy several rows from one repeating table to another

Jimmy — Thu, 03 Nov 2011 18:51:09 GMT

Hello JS,

If you download the file I've attached above and inject your trial version of qRules into it, you should be able to sample the functionality I've added to it.

Re: Copy several rows from one repeating table to another

jschemmel — Thu, 03 Nov 2011 18:30:53 GMT

Hi Jimmy. Do you think you could send me the information on how to copy from one repeating table to another. I have the trial version of Qdabra.

Thanks

JS

Re: Copy several rows from one repeating table to another

Jimmy — Thu, 13 Oct 2011 19:13:10 GMT

Here's your form with the copy behavior added. All of the relevant logic is on the button that I added and in the rules on the my:group4 node.

I can't say anything relating to ShareVis because this is the first I've heard of it and I don't know what its limitations are (or if they're relevant here). And yes, this technique is perfectly applicable to copying data between data sources.

Re: Copy several rows from one repeating table to another

lenovo27 — Thu, 13 Oct 2011 18:06:26 GMT

Thank you. I've injected qRules in my simple test form (attached). I've setup rules to copy the selected row from the first table to the second table, and that works fine. But when I want to select multiple rows from the first table via my checkboxes it doesn't copy each of the selected rows into the second table as desired.

Looking forward to seeing what this can do. Also, is this solution supported in ShareVis? Also, in production, the first table I want to pull data from would be getting data from a query via a web service (I have a solution for that). Is that supported in qRules? Right now my web services are on an internal facing server.

Re: Copy several rows from one repeating table to another

Jimmy — Mon, 10 Oct 2011 17:31:14 GMT

You can't do this with InfoPath's builtin functionality, but we have a time-tested way to accomplish this relatively easily with qRules. If you can create a simple sample form to demonstrate the tables you want to copy, inject the trial version of qRules in it and attach it to this thread, I can modify it for you to demonstrate this technique.