General

Re: Data source design issue

Jimmy — Fri, 05 Feb 2010 11:39:39 GMT

You should also be able to find it under the Data menu in VS.

Re: Data source design issue

Graeme — Fri, 05 Feb 2010 10:56:02 GMT

Spoke too soon above - the Default Values menu option is on the IP tools menu, but not when developing in Visual Studio. How can I set this value in VS designer?

UPDATE: Spoke too soone again - I just found that too - it is the same as Form Options - Advanced - Edit Default Values

Re: Data source design issue

Graeme — Thu, 04 Feb 2010 15:50:57 GMT

Thanks for that Jimmy.

One more - in the comments to Hilary's article she says about the extra blank row: "just don't include the blank row by default -- you'll find this under the default values"

http://www.infopathdev.com/blogs/hilary/archive/2008/07/04/how-do-i-copy-repeating-data-from-an-external-source-into-my-form.aspx

I can't find any such option - I'm looking at Repeating Table Properties - Edit Default Values...

UPDATE: OK, found it under Tools - Default Values.

Graeme

Re: Data source design issue

Jimmy — Thu, 04 Feb 2010 15:23:46 GMT

Graeme:
Is this namespace always set to the date and time that the template was first saved?

For forms created from a blank data source, it will be http://schemas.microsoft.com/office/infopath/2003/myXSD/, followed by the date and time (GMT) the template was created (not saved).

Does it ever change?

No.

Can I find it from within IP or do I always need to save a form as xml in order to see it?

Right-click any node in your main data source, select Properties, and then Details.

Re: Data source design issue

Graeme — Thu, 04 Feb 2010 14:52:41 GMT

Hi again Hilary,

Spent hours wondering why my code based on your sample wasn't working. It's because I was using your "my:" namespace. So I have a couple of questions about that:

Is this namespace always set to the date and time that the template was first saved?

Does it ever change?

Can I find it from within IP or do I always need to save a form as xml in order to see it?

TIA

Re: Data source design issue

Graeme — Thu, 04 Feb 2010 07:40:11 GMT

I'm working on the copying now based on sample code I found from you.

Thanks!

Re: Data source design issue

Hilary Stoupa — Wed, 03 Feb 2010 23:20:32 GMT

Or you need to copy the questions into the main data source as well -- because what if they change over time? Then you'd have answers that don't make sense....

Do you write code? You can do this with code. Or you can use qRules -- it has a command that will let you copy repeating data from one data source to another (along with any number of other cool commands). There's a free trial available here.

Data source design issue

Graeme — Tue, 02 Feb 2010 12:50:19 GMT

I am building a form where a user will reply to a list of questions. The list of questions comes from a secondary data source via a web service. The input box for the answers should appear under each question and there is a variable number of questions. But presumably the answers need to be on the main data source else they will not be saved when submitted.

If this is the case, then do I somehow need to copy the answers from the secondary source to the main source when saving or submitting? Then would I need to copy them back to the secondary source fields when re-opening the form so that they appear underneath the correct question?

All this sounds a bit complictated. Am I doing something wrong?