I have been using Money Manager EX for about a year now and it worked
fine. The use of encrypted database that is introduced in the last
versions is very handy. But today I played with settings and tried to
change the date format. The format I would like to use is 01.01.2007.
Since you suggested for a four digit year to use %Y I assumed %D and
%M will show day and month with leading zeros (01). But it introduced
a crash and now whenever I tried to open that database it reproduced
the crash of Money Manager EX. Since the database is encrypted I can
not open it and manually correct the date format. Is there a way to
open the database or at least export the data so it won't be lost?
I can try building a special version of MMEX that overwrites the dateformat field with some defaults and opens it. I will send it to you asap.
I have tried before to catch bad date formatting, but I wasn't able to do it. Maybe I should change it to be fixed formatting instead of allowing user defined formatting to prevent issues like this.
----- Original Message ---- From: Luka Oman <luka.o...@gmail.com> To: zealsupport <zealsupport@googlegroups.com> Sent: Thursday, November 15, 2007 12:37:12 PM Subject: [ZealSupport: 1850] Date format with dots
Hi!
I have been using Money Manager EX for about a year now and it worked fine. The use of encrypted database that is introduced in the last versions is very handy. But today I played with settings and tried to change the date format. The format I would like to use is 01.01.2007. Since you suggested for a four digit year to use %Y I assumed %D and %M will show day and month with leading zeros (01). But it introduced a crash and now whenever I tried to open that database it reproduced the crash of Money Manager EX. Since the database is encrypted I can not open it and manually correct the date format. Is there a way to open the database or at least export the data so it won't be lost?
If it is possible to create such a version that would fix the bad
dateformat field it would be great. If you can create separate app.
for fixing databases settings with defaults it would be perhaps even
better, because if somebody else make a mistake he would at least keep
his data.
I did not check the source code of your app. on how you check the
correctness of the strings and I do not know what strings can be
entered. In my case it seems that capital D in %D and capital M in %M
cause problems. You can perhaps bypass that if you manually check this
field for "%D" and "%M" and change them to lower case before the data
is saved to the database or even when the fiels content changes.
I hope you will be able to help me! Thanks in advance!
Luka
On 15 nov., 21:07, Madhan Kanagavel <mad...@yahoo.com> wrote:
> I can try building a special version of MMEX that overwrites the dateformat field with some defaults and opens it. I will send it to you asap.
> I have tried before to catch bad date formatting, but I wasn't able to do it.
> Maybe I should change it to be fixed formatting instead of allowing user defined formatting to prevent issues like this.
> -Madhan
> ----- Original Message ----
> From: Luka Oman <luka.o...@gmail.com>
> To: zealsupport <zealsupport@googlegroups.com>
> Sent: Thursday, November 15, 2007 12:37:12 PM
> Subject: [ZealSupport: 1850] Date format with dots
> Hi!
> I have been using Money Manager EX for about a year now and it worked
> fine. The use of encrypted database that is introduced in the last
> versions is very handy. But today I played with settings and tried to
> change the date format. The format I would like to use is 01.01.2007.
> Since you suggested for a four digit year to use %Y I assumed %D and
> %M will show day and month with leading zeros (01). But it introduced
> a crash and now whenever I tried to open that database it reproduced
> the crash of Money Manager EX. Since the database is encrypted I can
> not open it and manually correct the date format. Is there a way to
> open the database or at least export the data so it won't be lost?
> I can try building a special version of MMEX that overwrites the dateformat field with some defaults and opens it. I will send it to you asap.
> I have tried before to catch bad date formatting, but I wasn't able to do it.
> Maybe I should change it to be fixed formatting instead of allowing user defined formatting to prevent issues like this.
> -Madhan
> ----- Original Message ----
> From: Luka Oman <luka.o...@gmail.com>
> To: zealsupport <zealsupport@googlegroups.com>
> Sent: Thursday, November 15, 2007 12:37:12 PM
> Subject: [ZealSupport: 1850] Date format with dots
> Hi!
> I have been using Money Manager EX for about a year now and it worked
> fine. The use of encrypted database that is introduced in the last
> versions is very handy. But today I played with settings and tried to
> change the date format. The format I would like to use is 01.01.2007.
> Since you suggested for a four digit year to use %Y I assumed %D and
> %M will show day and month with leading zeros (01). But it introduced
> a crash and now whenever I tried to open that database it reproduced
> the crash of Money Manager EX. Since the database is encrypted I can
> not open it and manually correct the date format. Is there a way to
> open the database or at least export the data so it won't be lost?
Hi, I have uploaded a version of MMEX that has an option under Tools->Convert Encrypted DB. It will convert an encrypted db to non-encrypted DB (given the password) without opening it.
Once it is unencrypted, please change the date format to the correct format using SQLITE browser to open the DB, save the db and open it in MMEX.
----- Original Message ---- From: Luka Oman <luka.o...@gmail.com> To: zealsupport <zealsupport@googlegroups.com> Sent: Thursday, November 15, 2007 4:29:28 PM Subject: [ZealSupport: 1854] Re: Date format with dots
My bad, %M is OK, only %D is the string that is causing the crash.
On 15 nov., 21:07, Madhan Kanagavel <mad...@yahoo.com> wrote: > I can try building a special version of MMEX that overwrites the dateformat field with some defaults and opens it. I will send it to you asap.
> I have tried before to catch bad date formatting, but I wasn't able to do it. > Maybe I should change it to be fixed formatting instead of allowing user defined formatting to prevent issues like this.
> -Madhan
> ----- Original Message ---- > From: Luka Oman <luka.o...@gmail.com> > To: zealsupport <zealsupport@googlegroups.com> > Sent: Thursday, November 15, 2007 12:37:12 PM > Subject: [ZealSupport: 1850] Date format with dots
> Hi!
> I have been using Money Manager EX for about a year now and it worked > fine. The use of encrypted database that is introduced in the last > versions is very handy. But today I played with settings and tried to > change the date format. The format I would like to use is 01.01.2007. > Since you suggested for a four digit year to use %Y I assumed %D and > %M will show day and month with leading zeros (01). But it introduced > a crash and now whenever I tried to open that database it reproduced > the crash of Money Manager EX. Since the database is encrypted I can > not open it and manually correct the date format. Is there a way to > open the database or at least export the data so it won't be lost?
> Hi, I have uploaded a version of MMEX that has an option under Tools->Convert Encrypted DB.
> It will convert an encrypted db to non-encrypted DB (given the password) without opening it.
> Once it is unencrypted, please change the date format to the correct format using SQLITE browser to open the DB, save the db and open it in MMEX.
> ----- Original Message ----
> From: Luka Oman <luka.o...@gmail.com>
> To: zealsupport <zealsupport@googlegroups.com>
> Sent: Thursday, November 15, 2007 4:29:28 PM
> Subject: [ZealSupport: 1854] Re: Date format with dots
> My bad, %M is OK, only %D is the string that is causing the crash.
> On 15 nov., 21:07, Madhan Kanagavel <mad...@yahoo.com> wrote:
> > I can try building a special version of MMEX that overwrites the
> dateformat field with some defaults and opens it. I will send it to you
> asap.
> > I have tried before to catch bad date formatting, but I wasn't able
> to do it.
> > Maybe I should change it to be fixed formatting instead of allowing
> user defined formatting to prevent issues like this.
> > -Madhan
> > ----- Original Message ----
> > From: Luka Oman <luka.o...@gmail.com>
> > To: zealsupport <zealsupport@googlegroups.com>
> > Sent: Thursday, November 15, 2007 12:37:12 PM
> > Subject: [ZealSupport: 1850] Date format with dots
> > Hi!
> > I have been using Money Manager EX for about a year now and it worked
> > fine. The use of encrypted database that is introduced in the last
> > versions is very handy. But today I played with settings and tried to
> > change the date format. The format I would like to use is 01.01.2007.
> > Since you suggested for a four digit year to use %Y I assumed %D and
> > %M will show day and month with leading zeros (01). But it introduced
> > a crash and now whenever I tried to open that database it reproduced
> > the crash of Money Manager EX. Since the database is encrypted I can
> > not open it and manually correct the date format. Is there a way to
> > open the database or at least export the data so it won't be lost?
