Tracelyn
wading in the water
Posts:18
 |
| 09-25-2012 01:58 AM |
|
I have a server in mountain time and a DNN site set to eastern time. I want my form module to display only on certain days, so I set up the date in the module settings. However, the module displays at midnight on the server time zone, not the site time zone.
I have DNN 6.1.1 and Dynamic forms 4.1. The server is a shared environment and can not be changed.
Is there a workaround for this?
|
|
|
|
|
Ryan Bakerink
river guide
Posts:1900
|
| 09-25-2012 05:16 AM |
|
Hello Tracelyn,
Good news is that you know the time of the server timezone and your website's timezone.
If you want the Dynamic Form module to hide based on Eastern time then you may need to add a Hidden field to your form. This field will contain a date.
If you give this field a SQL Default of:
Select Convert(char(10),getDate(),108) As DefaultValue
Then you'll get the current time in the following format hh:mm:ss however note that this will be in Mountain time. So then you can use a simple DateAdd T-SQL function to add 2 hours to the time returned to reflect Eastern time.
So now your SQL Default for the hidden field should look like so:
select DateAdd(hh, 2, Convert(time, getdate(), 108)) As DefaultValue
Now add some JavaScript to conditionally show or hide the module based on the Default value returned from your Hidden Field.
Please let me know if you have any questions.
Thanks,
Ryan
|
|
|
|
|
Chad Nash
Posts:5260
|
| 09-25-2012 05:48 AM |
|
Hi guys - just a quick follow up here. If you are hiding the module using the standard DotNetNuke "Settings" area to display the module based only on selected dates, then I am not sure of another way around this with our module since that is DNN core code and not actually coded within our module directly.
Thanks,
Chad
|
|
|
|
|
Ryan Bakerink
river guide
Posts:1900
|
| 09-25-2012 05:52 AM |
|
Hello Chad,
I've been able to hide/show our modules many times over using JavaScript. So yes, this is not a supported feature in our modules, however my suggestion above is a workaround that works great.
Thanks,
Ryan |
|
|
|
|
Tracelyn
wading in the water
Posts:18
|
| 09-26-2012 01:36 AM |
|
I will give this a try and let you know. Thanks guys!
|
|
|
|
|
Tracelyn
wading in the water
Posts:18
|
| 09-26-2012 01:54 AM |
|
I was poking around the DNN website to see if this is a known issue and found this:
starting
with DNN 6, modules should move to using UTC instead of server time - the new
user time zone allows proper conversion to user time including DST. Of course,
this applies to modules supporting only DNN 6.0 and up
http://www.dotnetnuke.com/Resources...spx#441789
Not sure if this applies ... but what do you think? |
|
|
|
|
Ryan Bakerink
river guide
Posts:1900
|
| 09-26-2012 09:28 AM |
|
Hello Tracelyn,
This could very well be true, however does this seem to work for you?
If you can get this to work with JavaScript to hide/show the form then I would definitely proceed. I haven't been too involved with Hiding/Showing a module based on the time of the day.
However I know that you can have a Hidden field, set the Date based on the current time and take action using JavaScript(hide or show the module based on the time).
As Chad mentioned above, there's not a feature implemented in Dynamic Forms for this, so it sounds like you'll need to use an alternative workaround.
Thanks,
Ryan |
|
|
|
|
Tracelyn
wading in the water
Posts:18
|
| 10-15-2012 01:21 AM |
|
I've played around with this idea a bit. I am not a JS expert. I only know a little bit of sql. I can't get it to work.
|
|
|
|
|
Ryan Bakerink
river guide
Posts:1900
|
| 10-15-2012 10:24 AM |
|
Hello Tracelyn, If you'd like Data Springs to assist you with this functionality, you can purchase hours from us via Premium Services: http://www.datasprings.com/support/...rt-options Also the more hours that you purchase at a time results at a better hourly rate. Please explore our Hourly, Monthly and Quarterly Premium Service packages. You can use any time that you've purchased towards training, custom development, or any services that you'd wish. Regarding this functionality, we could have this implemented for you by EOD Thursday. My estimation is that it would require 1- 1.5 hours of development and possibly .5 hours for testing. If you're interested in utilizing Data Springs services, please purchase hours from us and we'll get started as early as Wednesday. Please let me know if you have any questions. Thanks, Ryan |
|
|
|
|
Tracelyn
wading in the water
Posts:18
|
| 11-13-2012 01:13 AM |
|
I am not going to purchase hours when it's clear that the modules and Dot Net Nuke are not playing nicely together. Someone needs to look into this issue and figure out the problem.
My client is quite unhappy.
I have been on the Dot Net Nuke forums as I stated above and there is alot of talk about this issue out there. Please go check it out.
|
|
|
|
|
Ryan Bakerink
river guide
Posts:1900
|
| 11-14-2012 12:05 PM |
|
Hello Tracelyn, Because you're unable to implement this solution via JavaScript or SQL, doesn't mean that our modules and DotNetNuke aren't playing together correctly. Unfortunately Dynamic Forms doesn't have a feature out of the box that allows a User to hide or show a Dynamic Form instance based on the User's time in their timezone. This will require a custom implementation by using SQL or JavaScript. By knowing a User's timezone you can perform a calculation to find out the current time for that user. Obviously your DNN instance is going to be reflective to the Server time. I would recommend looking into forum threads for SQL or JavaScript to learn how to perform this calculation: JavaScript Example resources: http://www.w3schools.com/jsref/jsre...offset.asp http://www.onlineaspect.com/2007/06...avascript/ SQL Example resources: http://msdn.microsoft.com/en-us/lib...30289.aspx http://blog.mikecouturier.com/2009/...erver.html Please let us know if you have any questions. Thanks, Ryan |
|
|
|
|