Query large XML secondary data source - InfoPath Dev

InfoPath Dev

Use our Google Custom Search for best site search results.

Query large XML secondary data source

Last post 02-24-2013 04:56 PM by nikunj_mistry. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 02-22-2013 07:32 PM

    Query large XML secondary data source

    Hi, I am kind of newbie to Infopath. So it would be great if anyone can help me. I am using infopath 2010, solution requires just to run offline i.e. on desktop and tablets. i have xml secondary datasource, which is actually huge i.e. around 5000 items. I have set this not to load on form load. I want to give user kind of search functionality, on button click, it queries this xml and only brings the required data. Let me know how to go about it keeping performance in mind. Thanks, Nikunj
    Filed under: , , ,
  • 02-24-2013 12:23 PM In reply to

    Re: Query large XML secondary data source

    Hi Nikunj,

    You could cache the secondary data source in the form template so that it will be part of the XSN. It will require that the XSN be copied to the local desktop whenever you update it, but 5000 items is not that huge so maybe this is acceptable. On load performance should be quite fast if everything's local.

    Unfortunately, trying to use SharePoint Workspace and synchronize secondary XML file won't work because InfoPath data connections don't synch down.

    Yet another option is to use SQL Express locally, but that will require some installation and additional cost to set up. We have a solution that does this but it's not free.

    Patrick Halstead
    Project Manager at Qdabra
  • 02-24-2013 04:56 PM In reply to

    Re: Query large XML secondary data source

    Thanks Patrick. This is what i have tried, i created a Secondary connection, which i set to fetch on demand. I wrote a FileQueryConnection which then fetches the complete xml and loads it into memory xmldocument object, this done onload. Now on my button click i query this in memory xmldocument which is very fast and almost solves my issue. But now i have below two challenges: 1. how to show this data on screen in repeating table. 2. if result set returned by query is large again, i need to provide pagination Thanks, Nikunj
Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.