Free Sample: Copying Repeating Data

re: Free Sample: Copying Repeating Data

Sproctor722 — Thu, 29 Aug 2013 19:48:23 GMT

I downloaded the form and repeated the rules in my form, but can't seem to get this to work. It's not returning any rows.

re: Free Sample: Copying Repeating Data

danilao — Thu, 22 Aug 2013 19:55:14 GMT

Patrick, I watched your video "InfoPath Dashboard - Displaying Repeating Data in Libraries -- February 28, 2013 Webinar".

Where I found a STEP by STEP to do that form?

re: Free Sample: Copying Repeating Data

Olgierd — Fri, 03 May 2013 11:42:51 GMT

Hi Patrick,

I am somehow struggling with this approach. I need to load huge tables from Excel, therefore I have an Excel files that saves the table in XML format in a SharePoint library, this XML is connected to my form and is supposed to dynamically update repeating table once a button is clicked. It works fine if table has 10 lines. If it is bigger than in my main data source repeating table I am only getting the first line. I checked the XML file and all 100 lines have been stored correctly in the secondary data source, so what might be the issue?

re: Free Sample: Copying Repeating Data

Olgierd — Fri, 03 May 2013 11:39:11 GMT

Hi Patrick,

I am really struggling with this approach. I am exporting data from Excel to XML schema, which is dynamically connected to my form. When I enter 10 lines of data - form loads the content correctly, but when I place 100 lines, it just loads the first line. I checked the XML schema and it contains all 100 lines, so what might be causing the issue?

Twitted by WonderLaura

Twitted by WonderLaura — Tue, 25 Oct 2011 17:30:31 GMT

Pingback from Twitted by WonderLaura

re: Free Sample: Copying Repeating Data

Patrick Halstead — Wed, 14 Sep 2011 05:45:51 GMT

Hi Keadlard,

To remove the blank line, go to the data tab in the designer's ribbon. Click on Default Values and find the repeating group that has the blank line. Uncheck it so that it doesn't include a default row.

Hope that does the trick!

re: Free Sample: Copying Repeating Data

Keadlard — Mon, 12 Sep 2011 21:41:51 GMT

Got it working now, but have a blank line at the top.

re: Free Sample: Copying Repeating Data

Keadlard — Fri, 09 Sep 2011 22:00:22 GMT

Patrick,

I seem to have gotten this working for 1 record, seems like I have missed something.

I have a button that starts the process and sets the first value (WebPart) as " ". Depending on a choice, it sets the value of the Lastitem and current. And finally if current item is less than Last Item and WebPart = " ", it copies the value to the main data connection. Unfortunately it stops after 1 record. What did I miss?

re: Free Sample: Copying Repeating Data

Patrick Halstead — Thu, 08 Sep 2011 06:31:08 GMT

Hi Jeff,

It doesn't require viewdata. Check the data type on the count. It should be the same as id. Probably something simple. It will work.

re: Free Sample: Copying Repeating Data

DC-jeff — Wed, 07 Sep 2011 19:27:47 GMT

Patrick -

Does the form require the use of "viewdata" as a secondary datasource? I've tried to incorporate the "count" and "lastitem" into my main datasource but am getting unexpected results.

i.e. replacing

xdXDocument:GetDOM("items")/items/item/a[../id = xdXDocument:GetDOM("viewdata")/viewdata/count]

with

xdXDocument:GetDOM("items")/items/item/a[../id = /my:myFields/my:count]

does not populate the values. I've hard coded the xpath for testing:

xdXDocument:GetDOM("items")/items/item/a[../id = 1]

and confirmed that it returns the correct row. Just curious about the "viewdata" secondary datasource as a dependency.

thanks

Jeff