Qdabra qRules

Re: Multiple IP fields mapped to one SP list field

Hilary Stoupa — Wed, 14 Nov 2012 22:17:09 GMT

Hah - I barely helped at all, just kind of asked silly questions while you figured it out on your own. Glad you are up and running!

Re: Multiple IP fields mapped to one SP list field

Jenny Slagle — Wed, 14 Nov 2012 22:11:46 GMT

It is a decimal, and I just got it to work after I changed it from auto to 2 decimal places. Oh the little things. Thank you so much for your help again Hilary, I really appreciate it!!

Re: Multiple IP fields mapped to one SP list field

Hilary Stoupa — Wed, 14 Nov 2012 22:04:21 GMT

The amount field in your list is currency? Is it just a decimal in your form?

Re: Multiple IP fields mapped to one SP list field

Jenny Slagle — Wed, 14 Nov 2012 21:14:40 GMT

Ok, I learn something new everyday. I didn't know that I can drop the Event Type into all the sections it needs to, and be able to change the drop down values. I re-mapped the one Event Type to the Type in SP and it is working perfectly. It isn't giving me an error when I add new entries or update. It still isn't liking the Amount field; is it because I have both fields set to currency?

Re: Multiple IP fields mapped to one SP list field

Hilary Stoupa — Wed, 14 Nov 2012 20:52:30 GMT

That may be worth a try - you could try it with just two types of Entry - if it works for you, then you could proceed with the others.

Re: Multiple IP fields mapped to one SP list field

Jenny Slagle — Wed, 14 Nov 2012 20:48:08 GMT

One thought I had was to create mapping (and submit data connections) for eacy type of Entry then apply a filters. The one submit button would actually submit new and updates to the list. What do you think?

Re: Multiple IP fields mapped to one SP list field

Hilary Stoupa — Wed, 14 Nov 2012 20:47:49 GMT

I think you are getting that error because you have multiple fields mapped to the same column. I was hoping that setting the mapping to not submit Amount / Type unless they had a value would work around that, but apparently not. I'll try this out later today or sometime tomorrow with a tool I use for testing and see if I can come up with a work around. You could also consider normalizing your form schema, so you don't have to map a number of fields to the same column....

Re: Multiple IP fields mapped to one SP list field

Jenny Slagle — Wed, 14 Nov 2012 20:37:19 GMT

Neither Amount or Event Type are still populating. This form is an ongoing shift log where entries are added, and at times, the user would submit it. I need to be able to submit one, then maybe multiple entries the next time, etc. Since I have the entry ID set on submit, I thought it would update the previous records (even if there weren't any changes), and add the additional ones. Instead, I'm getting this message:

Failed to submit to SharePoint. URL = 'http://www..portalname.local/_vti_bin/lists.asmx'. Full error node text: Item has already been added. Key in dictionary: 'Amount' Key being added: 'Amount': Exception from HRESULT: 0x8004304D

Re: Multiple IP fields mapped to one SP list field

Hilary Stoupa — Wed, 14 Nov 2012 20:03:24 GMT

Okay, what I did was make the assumption that only one of the fields mapped to the amount column would be filled out (same with type) and manually added XPath filters to only use the field if it was not blank - give this a try and see if we get any closer.

Re: Multiple IP fields mapped to one SP list field

Hilary Stoupa — Wed, 14 Nov 2012 20:01:49 GMT

So, I modified this a little - I'll add more detail in a second post so I can attach a screenshot.

Re: Multiple IP fields mapped to one SP list field

Jenny Slagle — Wed, 14 Nov 2012 16:34:03 GMT

Here's the mapping, thank you

Re: Multiple IP fields mapped to one SP list field

Hilary Stoupa — Wed, 14 Nov 2012 14:49:37 GMT

I think your mapping is going to need to be slightly more complex. Can you attach a copy of the mapping.XML and I can show you what I think needs to change?

Re: Multiple IP fields mapped to one SP list field

Jenny Slagle — Tue, 13 Nov 2012 20:08:34 GMT

The form is a daily activity form. The user chooses an event type, and depending on what entry type they choose, that section appears. Each repeating section is an entry in the sp list. The Event Type associated with entries have different drop down choices but all need to be written to the SP Event Type field. Same with the Amount, but after thinking about it, I can take it out of the inner section and make it an optional field for what ever event type is chosen. I hope I am explaining it well enough :)

Re: Multiple IP fields mapped to one SP list field

Hilary Stoupa — Tue, 13 Nov 2012 19:58:44 GMT

Hi, Jenny - I'm confused by this. Are you wanting to create a new list item for each of these sets of fields?

Re: Multiple IP fields mapped to one SP list field

Gennady Vanin (Геннадий Ванин, Новосибирск) — Tue, 13 Nov 2012 19:30:03 GMT

What you show on a screenshot is really controls - visual containers for rendering underlying data fields.
You can have multiple controls for the same data field.

And in this controls to filter what they show.

So, you will have one data field for one sharepoint list field appearing in different controls with different content.