Event Calander

This is the place to report bugs and get support. When posting in this forum, please always provide as much detail as possible.

Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum, do not report it as a bug.

This is the place to report bugs and get support

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.
Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum.
This thread is closed to new posts. You must sign in to post in the forums.
9/6/2008 8:26:40 AM
ashian
Gravatar
Total Posts 104
View Posts

Re: Event Calander

Ok,

I read current translation and will update them ( non translated and also some update for current translations ) after finishing I will send them to you and Asad , hope we have a complete Persain Language pack then.

best wishes

Mehdi Alidoost

9/6/2008 9:54:49 AM
Asad Samarian
Gravatar
Total Posts 550
View Posts

Re: Event Calander

Hi Joe
I test and review your solution for archived items in the Blog Module. Unfortunately your effort not solve problem. If look at mojoportal change blog you see that 2 items has been sent in 6th month of Persian calendar but in right side we see 1 Item for 6th month ((1) شهريور 1387), because another Item has been sent in August.
Only thing that is the same in two Calendars (Persian and English) is match of days:
Saturday=شنبه, Sunday=یکشنبه, Monday=دوشنبه, Tuesday=سه شنبه, Wednesday=چهارشنبه, Thursday=پنجشنبه.
As you know I convert a date (for example 20008/09/06) to equivalent Persian date (1387/06/16) in Blog and Forum modules in UI layer. But when we retrieve an aggregation selection from database we need a function that converts English date to Persian Date for any record in SELECT instruction.
For sum up in my opinion we have to apply a SQL function when we retrieve an aggregation selection from database.
Since I can't insert image in this forum I sent you this text with an image that depict overlapping of months and years in the two calendars.
 

Best Regards

Asad

9/6/2008 2:27:43 PM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Event Calander

Hi Asad,

I see you are correct, to make it come out perfect it  would need to be grouped correctly in the database. I will consider integrating your database changes. I noticed before you have some User Defined Functions in the sql script, my only concern is whether it will break compatibility with SQL 2000. Do you have access to a machine running SQL 2000 that you can test the script on to verify its compatible? If we can be sure it is compatible I will have more confidence to integrate it.

Best,

Joe

9/7/2008 5:31:57 AM
ashian
Gravatar
Total Posts 104
View Posts

Re: Event Calander

Hi Joe , Hi Asad.

Today I can update my source code and check your changes , I'm agree with Asad's idea , but if you want to dont change at your database script , I suggest that for persian Lanaguage using a Dataset for blog enteries(StartDate) , and in your data layer using DataSet group by (http://support.microsoft.com/kb/326145)

I know that , this is not a perfect solution but it will solve this issue.

also we have some UDF that worked correctly by SQL Server 2000 ( I think it's same as Asad provided ) I used it in some of my projects and work wihtout any problem on SQL 2000.

Thanks

Mehdi Alidoost

9/8/2008 6:46:08 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Event Calander

Hi Mehdi, Hi Asad,

I will look into integrating the SQL modifications as soon as I get a chance. I think it would not be good performance to do this using a dataset compared to doing it in SQL. If the blog has thousands of posts we would be retrieving all of them in the dataset just to count them using the right grouping and this will not scale very well.

I'll post again to let you know after I have integrated it.

Best,

Joe

9/8/2008 7:10:54 AM
ashian
Gravatar
Total Posts 104
View Posts

Re: Event Calander

That's right.

I offer this becuase I think you perrefer to solve problem wihtout changes on DB side.

Also becuase just we have to retrieve one column (StartDate) in many cases ( if we can't change on DB side) this solution will considerable.

another issue , in Calander can we change the Start day in a week? in Persian Calander Saturday is the first day of week , is there any setting that we can set for this?

Best regards

Mehdi

9/8/2008 7:40:18 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Event Calander

Yes I agree selecting only the date column into the dataset would help but still if its thousands of rows or more its not going to be a good solution. Even though that solution would have the benefit of working for all databases, I think on balance given the pros and cons we should solve this in the db. It will only be solved for MS SQL but that is the most popular db in use with mojoPortal.

Asad, I looked at the files you sent me a while back and they are very old patch files, it will be difficult to get what I need from them. Can you just generate the sql script with the UDF(s) and StoredProcedure(s) and send it to me as a .zip? When you generate the script in SQL 2005 Tasks > Generate Scripts, please choose the option for SQL 2000 compatibility.

Thanks,

Joe

9/8/2008 1:53:10 PM
Asad Samarian
Gravatar
Total Posts 550
View Posts

Re: Event Calander

Hi Joe

I generate the sql script with the UDF(s) and StoredProcedure(s) and send it to you  as soon as posible until end  of this week.I decide to complete problem and send it as a patch and a zip file of SQL scripts.

best,

Asad.

You must sign in to post in the forums. This thread is closed to new posts.