General

Re: Time Difference Calc works in IP07 not IP10

Hilary Stoupa — Mon, 04 Nov 2013 15:55:47 GMT

Attach your form under the Options tab if you'd like me to take a look...

Re: Time Difference Calc works in IP07 not IP10

Mark C. — Sun, 03 Nov 2013 19:09:33 GMT

Hello Hilary - I compared your timeTest Rules and settings to what I had on my form, that I found in a book. Large difference, so I decided to delete the rules, etc., from my form and retyped your rules. The form has an error in the Total Hours, red dash and: (((Num... is all that is visible. If I mouse over, the message shows "Only numbers allowed". Not sure why this error is happening. The GrandTotal shows: NaN. I had a DatePicker and another box but not bound at all and actually deleted from my form...no joy. I could build on your sample but already have some cosmetic changes made on mine, plus I wanted to learn and understand what your code is doing. I can't see a difference and checked the Text Box, Language, etc. settings. I also encountered a weird and unrelated problem when trying to Publish to email, but I won't go off topic for this issue. Thanks for any suggestions.

Re: Time Difference Calc works in IP07 not IP10

Mark C. — Sun, 03 Nov 2013 02:40:23 GMT

Hello Hilary - glad I found this website and QDABRA...the solution that you provided here was exactly what I needed. I am new to IP and needed to create a Time Sheet for my consulting business. This is great since I've been struggling with this issue on and off for several months and was going to give up on IP and create the Time Sheet in Excel. I viewed one of the QDABRA training videos and am considering a training course. Great! I'm using IP13, FYI. Cheers.

Re: Time Difference Calc works in IP07 not IP10

Hilary Stoupa — Tue, 12 Feb 2013 00:45:35 GMT

Wonderful, glad it is all working for you now!

Re: Time Difference Calc works in IP07 not IP10

dsanchez — Tue, 12 Feb 2013 00:39:20 GMT

Nice .. you were right in reference to the default values!

All good with your custom pattern too, thanks for all your help Hilary!

*Bows*

Re: Time Difference Calc works in IP07 not IP10

Hilary Stoupa — Mon, 11 Feb 2013 16:02:34 GMT

I would think you could use the original custom pattern and just change to using a substring of the start time - I'm attaching your sample with this modification. Save it locally, right click and select Design to open in design mode and you can see how I've changed that condition on both start and end time. As to your other question - if a node you expect to see is not in the end XML, you may want to check the Default Values (under the Data tab) and be sure it is being included by default.

Re: Time Difference Calc works in IP07 not IP10

dsanchez — Mon, 11 Feb 2013 00:57:50 GMT

Ok so I've tried to add the custom pattern of 00:00 and the rule isnt firing. The rule works as you mentioned when I remove the custom pattern.

I took a look at the XML and the data is showing a value of +11:00 (obviously based on the time chosen) but its still not working. I am not even sure I need that rule there?

I also sent you a pm about the grandTotal column not populating. I extracted the XML and the actual column isnt even being generated in 2010. It does in 2007 though. The attached XML is the newer version, so this is a little bit different to the one I had previously used. The rules and everything are still the same

Re: Time Difference Calc works in IP07 not IP10

dsanchez — Sat, 09 Feb 2013 01:06:14 GMT

ohhh didnt see that .. nice pick up!

Dont have access to the form till monday, will definitely check that when i go in and post the results

Question though, how would i modify the pattern to handle the UTC offset? Would i use another pattern for it instead of the 00:00:00?

Re: Time Difference Calc works in IP07 not IP10

Hilary Stoupa — Fri, 08 Feb 2013 15:26:00 GMT

Okay - looks like there is a difference in the XML, at least between 2007 & 2013 (my 2010 VM is feeling a bit sulky this morning). In 2013, the rules aren't firing because the pattern condition isn't being met - the time now includes the UTC offset (see attached screenshot). I removed the custom pattern requirement and the rule fired - but you'll probably want to modify the pattern to handle for the UTC offset instead in your form. Can you check the XML from 2010? Does it contain the UTC offset?

Re: Time Difference Calc works in IP07 not IP10

dsanchez — Fri, 08 Feb 2013 04:36:48 GMT

Thanks Hilary, appreciate it.

This form I had initially created in 07, tested and works fine. Trying to run this or even replicate the calcs in 2010 just isnt happening

Hope you can assist as to why this might be happening?

Re: Time Difference Calc works in IP07 not IP10

Hilary Stoupa — Fri, 08 Feb 2013 02:13:18 GMT

Well- if you want to attach a copy that is working for you under the Options tab, I can take a quick look & see if I can find anything...

Re: Time Difference Calc works in IP07 not IP10

dsanchez — Thu, 07 Feb 2013 23:53:47 GMT

Everything is working as expected using 2007, browser included. XML seems fine also, nothing out of the ordinary

Absolutely stumped how the same form can work fine in one and not in the other. I even went through all the calcs and re did it in 2010 on a blank form and still the same thing!!!!

GRRR!

Re: Time Difference Calc works in IP07 not IP10

Hilary Stoupa — Thu, 07 Feb 2013 23:30:56 GMT

I'd fill out both forms with the same data and compare the XML values. Have you tested your 2007 form in the browser already?

Re: Time Difference Calc works in IP07 not IP10

dsanchez — Thu, 07 Feb 2013 23:22:38 GMT

I will be using this form as a web browser for a SharePoint environment. I havent published it yet, so coming across the issue in design (Preview mode)

Re: Time Difference Calc works in IP07 not IP10

Hilary Stoupa — Thu, 07 Feb 2013 23:17:17 GMT

Microsoft usually works really hard to maintain backward compatibility. I've not run into any calc problems yet using templates from IP 2007 in IP 2010 - you are using this in filler, right? Not in the browser?