Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Concern regarding Excel Report Formating (ver 3.7.2)-Not addressed in ver 4.0 upgrade

usage
projects
custom-fields

The last communication on this issue indicated that ver 4.0 would resolve the date formatting mismatch experience in ver 3.7.2. After upgraing to ver 4.0 the problem has gotten worse. All previously created projects in ver 3.7.2 do not have the custom date field populated in Excel following the upgrade to ver 4.0 Is there a fix to the issue. (Review the attachment). This issue is related to the one titled "unable to save date value?" submitted on 6/30/11 by mmatos

Samwel

RE Storage Format of Custom Date Field.msg ]
User15255
· 1
User15255
Replies (4)
helpful
0
not helpful

Did you run the date upgrade when first logged in as admin?


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

What is the link to the "date upgrade"

The only link provided for the upgrade from ver 3.7.2 to ver 4.0 did not reference any date upgrade requirement.

http://support.geminiplatform.com/docs/all/page/4/upgrading-3-7-x-to-4-0


User15255
· 1
User15255
helpful
0
not helpful

http://your gemini url/admin/upgrade/upgrade.aspx


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

error.

System > System Log

Are you sure you want to delete ?

ID Dated Message Type Message Source Entry User 13637 7/1/2011 10:26:49 AM Error Gemini SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. at System.Data.SqlTypes.SqlDateTime.FromTimeSpan(TimeSpan value) at System.Data.SqlTypes.SqlDateTime.FromDateTime(DateTime value) at System.Data.SqlClient.MetaType.FromDateTime(DateTime dateTime, Byte cb) at System.Data.SqlClient.TdsParser.WriteValue(Object value, MetaType type, Byte scale, Int32 actualLength, Int32 encodingByteSize, Int32 offset, TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.TdsExecuteRPC(SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj, Boolean isCommandProc) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at CounterSoft.Gemini.DataProvider.UpgradeProvider.UpgradeCustomFieldDates() at CounterSoft.Gemini.Business.Upgrades.Upgrade40() at CounterSoft.Gemini.Web.Admin.Upgrade.Upgrade.btnUpgradeClick(Object sender, EventArgs e) at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) Samwel Ndungu


User15255
· 1
User15255