|
»
»
»
not able to enter time with form
|
View:
New views
17 Messages
—
Rating Filter:
Alert me
|
 |
not able to enter time with form
by bill murphy-2
::
Rate this Message:
Hi all,
I'm using Rekall 2.4.6 with a mysql db, I have a table with a "time" field, on the table data view I am able to enter the time 12:50:00 and the db is updated accordingly, however when I use a form to enter the data, no time between 12:00 through 12:59 can be entered (am or pm) without throwing an error. No other entries regardless of time is affected. This is also showing up on a report built against the table, for instance if the db has a time of 12:50:00 entered in it, the report will show a time of 00:50, this only occurs for times between 12:00 through 12:59, am or pm. Is this a known problem? Is there a fix? Thanks Bill _______________________________________________ Rekall mailing list Rekall@... http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall |
|
|
Re: not able to enter time with form
by Andree Clausing
::
Rate this Message:
Hello Bill..
Try check Properties->Data->Format->force specified format Andree Am 11.03.2008, 04:43 Uhr, schrieb bill <bmurphy@...>: > Hi all, > > I'm using Rekall 2.4.6 with a mysql db, I have a table with a "time" > field, on the table data view I am able to enter the time 12:50:00 > and the db is updated accordingly, however when I use a form to enter > the data, no time between 12:00 through 12:59 can be entered (am or pm) > without throwing an error. No other entries regardless of time is > affected. > > This is also showing up on a report built against the table, for > instance if the db has a time of 12:50:00 entered in it, the report will > show a time of 00:50, this only occurs for times between 12:00 through > 12:59, am or pm. > > Is this a known problem? Is there a fix? > > Thanks > > Bill > > _______________________________________________ > Rekall mailing list > Rekall@... > http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall _______________________________________________ Rekall mailing list Rekall@... http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall |
|
|
Re: not able to enter time with form
by bill murphy-2
::
Rate this Message:
I did try that before posting, and also all validation is turned off
----- Original Message ----- From: "Andree Clausing" <andree@...> To: <rekall@...> Sent: Tuesday, March 11, 2008 1:17 AM Subject: Re: [Rekall] not able to enter time with form > Hello Bill.. > > Try check > > Properties->Data->Format->force specified format > > Andree > > Am 11.03.2008, 04:43 Uhr, schrieb bill <bmurphy@...>: > > > Hi all, > > > > I'm using Rekall 2.4.6 with a mysql db, I have a table with a > > field, on the table data view I am able to enter the time 12:50:00 > > and the db is updated accordingly, however when I use a form to enter > > the data, no time between 12:00 through 12:59 can be entered (am or pm) > > without throwing an error. No other entries regardless of time is > > affected. > > > > This is also showing up on a report built against the table, for > > instance if the db has a time of 12:50:00 entered in it, the report will > > show a time of 00:50, this only occurs for times between 12:00 through > > 12:59, am or pm. > > > > Is this a known problem? Is there a fix? > > > > Thanks > > > > Bill > > > > _______________________________________________ > > Rekall mailing list > > Rekall@... > > http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall > > > _______________________________________________ > Rekall mailing list > Rekall@... > http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall _______________________________________________ Rekall mailing list Rekall@... http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall |
|
|
Re: not able to enter time with form
by Andree Clausing
::
Rate this Message:
I have a small Python Script in the on_leave event.
def eventFunc (field, row) : import MyTools t = field.value if (t is not None) and (t != "") : field.value = MyTools.checkTime(t) return 1 ---------------------------------------------- def checkTime (ti): # Einen Zeitwert prüfen und zurückgeben import string import RekallMain if ti <> None : t = ti t = string.strip(str(t)) # Leerzeichen entfernen t = string.replace(t,",",":") # Komma zu Doppelpunkt tt = string.split(t,":") # muss ich noch umstricken, um split zu verwenden !! dpx = string.find(t,":") if (dpx == -1) : # Kein Doppelpunkt vorhanden if (len(t) == 4) : # 4 Zeichen, 2 für Stunde, 2 für Minute h = t[:2] # Stunden m = t[-2:] # Minuten else : h = t[:2] # Stunden m = "00" # Minuten else : # Doppelpunkt vorhanden h = t[:dpx] m = t[(dpx+1):] if (len(m) < 2) : m = m + "0" return h + ":" + m It's not directly usefull for you (I think..), but perhabs.. Andree Am 11.03.2008, 13:30 Uhr, schrieb bill murphy <bmurphy@...>: > I did try that before posting, and also all validation is turned off > > ----- Original Message ----- > From: "Andree Clausing" <andree@...> > To: <rekall@...> > Sent: Tuesday, March 11, 2008 1:17 AM > Subject: Re: [Rekall] not able to enter time with form > > >> Hello Bill.. >> >> Try check >> >> Properties->Data->Format->force specified format >> >> Andree >> >> Am 11.03.2008, 04:43 Uhr, schrieb bill <bmurphy@...>: >> >> > Hi all, >> > >> > I'm using Rekall 2.4.6 with a mysql db, I have a table with a > "time" >> > field, on the table data view I am able to enter the time 12:50:00 >> > and the db is updated accordingly, however when I use a form to > enter >> > the data, no time between 12:00 through 12:59 can be entered (am > or pm) >> > without throwing an error. No other entries regardless of time is >> > affected. >> > >> > This is also showing up on a report built against the table, for >> > instance if the db has a time of 12:50:00 entered in it, the > report will >> > show a time of 00:50, this only occurs for times between 12:00 > through >> > 12:59, am or pm. >> > >> > Is this a known problem? Is there a fix? >> > >> > Thanks >> > >> > Bill >> > >> > _______________________________________________ >> > Rekall mailing list >> > Rekall@... >> > http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall >> >> >> _______________________________________________ >> Rekall mailing list >> Rekall@... >> http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall > > > _______________________________________________ > Rekall mailing list > Rekall@... > http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall _______________________________________________ Rekall mailing list Rekall@... http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall |
|
|
Re: not able to enter time with form
by bill murphy-2
::
Rate this Message:
Andree:
it won't help with my immediate problem, but it's another tool in the box that may come in handy one day. I'm going to keep investigating the time issue and try to see the full extent of it. I'm not a programmer, so the chance of me fixing it is slim, but at least I can pass on what I learn to someone that can. Bill On Tue, 2008-03-11 at 13:54 +0100, Andree Clausing wrote: > I have a small Python Script in the on_leave event. > > def eventFunc (field, row) : > import MyTools > t = field.value > if (t is not None) and (t != "") : > field.value = MyTools.checkTime(t) > return 1 > > ---------------------------------------------- > def checkTime (ti): # Einen Zeitwert prüfen und zurückgeben > import string > import RekallMain > if ti <> None : > t = ti > t = string.strip(str(t)) # Leerzeichen entfernen > t = string.replace(t,",",":") # Komma zu Doppelpunkt > tt = string.split(t,":") # muss ich noch > umstricken, um split zu verwenden !! > dpx = string.find(t,":") > if (dpx == -1) : # Kein Doppelpunkt vorhanden > if (len(t) == 4) : # 4 Zeichen, 2 für Stunde, 2 > für Minute > h = t[:2] # Stunden > m = t[-2:] # Minuten > else : > h = t[:2] # Stunden > m = "00" # Minuten > else : # Doppelpunkt vorhanden > h = t[:dpx] > m = t[(dpx+1):] > if (len(m) < 2) : > m = m + "0" > return h + ":" + m > > It's not directly usefull for you (I think..), but perhabs.. > > Andree > > > Am 11.03.2008, 13:30 Uhr, schrieb bill murphy <bmurphy@...>: > > > I did try that before posting, and also all validation is turned off > > > > ----- Original Message ----- > > From: "Andree Clausing" <andree@...> > > To: <rekall@...> > > Sent: Tuesday, March 11, 2008 1:17 AM > > Subject: Re: [Rekall] not able to enter time with form > > > > > >> Hello Bill.. > >> > >> Try check > >> > >> Properties->Data->Format->force specified format > >> > >> Andree > >> > >> Am 11.03.2008, 04:43 Uhr, schrieb bill <bmurphy@...>: > >> > >> > Hi all, > >> > > >> > I'm using Rekall 2.4.6 with a mysql db, I have a table with a > > "time" > >> > field, on the table data view I am able to enter the time 12:50:00 > >> > and the db is updated accordingly, however when I use a form to > > enter > >> > the data, no time between 12:00 through 12:59 can be entered (am > > or pm) > >> > without throwing an error. No other entries regardless of time is > >> > affected. > >> > > >> > This is also showing up on a report built against the table, for > >> > instance if the db has a time of 12:50:00 entered in it, the > > report will > >> > show a time of 00:50, this only occurs for times between 12:00 > > through > >> > 12:59, am or pm. > >> > > >> > Is this a known problem? Is there a fix? > >> > > >> > Thanks > >> > > >> > Bill > >> > > >> > _______________________________________________ > >> > Rekall mailing list > >> > Rekall@... > >> > http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall > >> > >> > >> _______________________________________________ > >> Rekall mailing list > >> Rekall@... > >> http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall > > > > > > _______________________________________________ > > Rekall mailing list > > Rekall@... > > http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall > > > _______________________________________________ > Rekall mailing list > Rekall@... > http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall _______________________________________________ Rekall mailing list Rekall@... http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall |
|
|
Re: not able to enter time with form
by Andree Clausing
::
Rate this Message:
I have had also problems with date / time values in the past.
The problems are round how Reckall store values in the database. My solution was to check out, which values work good and which values work not. Make a new form and try a little with time values, perhabs you have to write 13:00, not 1:00pm. Look at the mySQL-manual how it wish time values. Andree Am 12.03.2008, 02:11 Uhr, schrieb bill <bmurphy@...>: > Andree: > > it won't help with my immediate problem, but it's another tool in the > box that may come in handy one day. > > I'm going to keep investigating the time issue and try to see the > full extent of it. I'm not a programmer, so the chance of me fixing it > is slim, but at least I can pass on what I learn to someone that can. > > Bill > > On Tue, 2008-03-11 at 13:54 +0100, Andree Clausing wrote: >> I have a small Python Script in the on_leave event. >> >> def eventFunc (field, row) : >> import MyTools >> t = field.value >> if (t is not None) and (t != "") : >> field.value = MyTools.checkTime(t) >> return 1 >> >> ---------------------------------------------- >> def checkTime (ti): # Einen Zeitwert prüfen und zurückgeben >> import string >> import RekallMain >> if ti <> None : >> t = ti >> t = string.strip(str(t)) # Leerzeichen entfernen >> t = string.replace(t,",",":") # Komma zu Doppelpunkt >> tt = string.split(t,":") # muss ich >> noch >> umstricken, um split zu verwenden !! >> dpx = string.find(t,":") >> if (dpx == -1) : # Kein Doppelpunkt vorhanden >> if (len(t) == 4) : # 4 Zeichen, 2 für Stunde, >> 2 >> für Minute >> h = t[:2] # Stunden >> m = t[-2:] # Minuten >> else : >> h = t[:2] # Stunden >> m = "00" # Minuten >> else : # Doppelpunkt vorhanden >> h = t[:dpx] >> m = t[(dpx+1):] >> if (len(m) < 2) : >> m = m + "0" >> return h + ":" + m >> >> It's not directly usefull for you (I think..), but perhabs.. >> >> Andree >> >> >> Am 11.03.2008, 13:30 Uhr, schrieb bill murphy <bmurphy@...>: >> >> > I did try that before posting, and also all validation is turned off >> > >> > ----- Original Message ----- >> > From: "Andree Clausing" <andree@...> >> > To: <rekall@...> >> > Sent: Tuesday, March 11, 2008 1:17 AM >> > Subject: Re: [Rekall] not able to enter time with form >> > >> > >> >> Hello Bill.. >> >> >> >> Try check >> >> >> >> Properties->Data->Format->force specified format >> >> >> >> Andree >> >> >> >> Am 11.03.2008, 04:43 Uhr, schrieb bill <bmurphy@...>: >> >> >> >> > Hi all, >> >> > >> >> > I'm using Rekall 2.4.6 with a mysql db, I have a table with a >> > "time" >> >> > field, on the table data view I am able to enter the time 12:50:00 >> >> > and the db is updated accordingly, however when I use a form to >> > enter >> >> > the data, no time between 12:00 through 12:59 can be entered (am >> > or pm) >> >> > without throwing an error. No other entries regardless of time is >> >> > affected. >> >> > >> >> > This is also showing up on a report built against the table, for >> >> > instance if the db has a time of 12:50:00 entered in it, the >> > report will >> >> > show a time of 00:50, this only occurs for times between 12:00 >> > through >> >> > 12:59, am or pm. >> >> > >> >> > Is this a known problem? Is there a fix? >> >> > >> >> > Thanks >> >> > >> >> > Bill >> >> > >> >> > _______________________________________________ >> >> > Rekall mailing list >> >> > Rekall@... >> >> > http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall >> >> >> >> >> >> _______________________________________________ >> >> Rekall mailing list >> >> Rekall@... >> >> http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall >> > >> > >> > _______________________________________________ >> > Rekall mailing list >> > Rekall@... >> > http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall >> >> >> _______________________________________________ >> Rekall mailing list >> Rekall@... >> http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall > > _______________________________________________ > Rekall mailing list > Rekall@... > http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall _______________________________________________ Rekall mailing list Rekall@... http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall |
|
|
Re: not able to enter time with form
by Andree Clausing
::
Rate this Message:
Some problems come, when i change the time format.
So dont change the time format until your problem has gone. Andree Am 12.03.2008, 07:53 Uhr, schrieb Andree Clausing <andree@...>: > I have had also problems with date / time values in the past. > > The problems are round how Reckall store values in the database. > > My solution was to check out, which values work good and which > values work not. > > Make a new form and try a little with time values, perhabs you > have to write 13:00, not 1:00pm. > > Look at the mySQL-manual how it wish time values. > > Andree > > Am 12.03.2008, 02:11 Uhr, schrieb bill <bmurphy@...>: > >> Andree: >> >> it won't help with my immediate problem, but it's another tool in the >> box that may come in handy one day. >> >> I'm going to keep investigating the time issue and try to see the >> full extent of it. I'm not a programmer, so the chance of me fixing it >> is slim, but at least I can pass on what I learn to someone that can. >> >> Bill >> >> On Tue, 2008-03-11 at 13:54 +0100, Andree Clausing wrote: >>> I have a small Python Script in the on_leave event. >>> >>> def eventFunc (field, row) : >>> import MyTools >>> t = field.value >>> if (t is not None) and (t != "") : >>> field.value = MyTools.checkTime(t) >>> return 1 >>> >>> ---------------------------------------------- >>> def checkTime (ti): # Einen Zeitwert prüfen und zurückgeben >>> import string >>> import RekallMain >>> if ti <> None : >>> t = ti >>> t = string.strip(str(t)) # Leerzeichen >>> entfernen >>> t = string.replace(t,",",":") # Komma zu Doppelpunkt >>> tt = string.split(t,":") # muss ich >>> noch >>> umstricken, um split zu verwenden !! >>> dpx = string.find(t,":") >>> if (dpx == -1) : # Kein Doppelpunkt vorhanden >>> if (len(t) == 4) : # 4 Zeichen, 2 für >>> Stunde, 2 >>> für Minute >>> h = t[:2] # Stunden >>> m = t[-2:] # Minuten >>> else : >>> h = t[:2] # Stunden >>> m = "00" # Minuten >>> else : # Doppelpunkt vorhanden >>> h = t[:dpx] >>> m = t[(dpx+1):] >>> if (len(m) < 2) : >>> m = m + "0" >>> return h + ":" + m >>> >>> It's not directly usefull for you (I think..), but perhabs.. >>> >>> Andree >>> >>> >>> Am 11.03.2008, 13:30 Uhr, schrieb bill murphy <bmurphy@...>: >>> >>> > I did try that before posting, and also all validation is turned off >>> > >>> > ----- Original Message ----- >>> > From: "Andree Clausing" <andree@...> >>> > To: <rekall@...> >>> > Sent: Tuesday, March 11, 2008 1:17 AM >>> > Subject: Re: [Rekall] not able to enter time with form >>> > >>> > >>> >> Hello Bill.. >>> >> >>> >> Try check >>> >> >>> >> Properties->Data->Format->force specified format >>> >> >>> >> Andree >>> >> >>> >> Am 11.03.2008, 04:43 Uhr, schrieb bill <bmurphy@...>: >>> >> >>> >> > Hi all, >>> >> > >>> >> > I'm using Rekall 2.4.6 with a mysql db, I have a table with a >>> > "time" >>> >> > field, on the table data view I am able to enter the time 12:50:00 >>> >> > and the db is updated accordingly, however when I use a form to >>> > enter >>> >> > the data, no time between 12:00 through 12:59 can be entered (am >>> > or pm) >>> >> > without throwing an error. No other entries regardless of time is >>> >> > affected. >>> >> > >>> >> > This is also showing up on a report built against the table, for >>> >> > instance if the db has a time of 12:50:00 entered in it, the >>> > report will >>> >> > show a time of 00:50, this only occurs for times between 12:00 >>> > through >>> >> > 12:59, am or pm. >>> >> > >>> >> > Is this a known problem? Is there a fix? >>> >> > >>> >> > Thanks >>> >> > >>> >> > Bill >>> >> > >>> >> > _______________________________________________ >>> >> > Rekall mailing list >>> >> > Rekall@... >>> >> > http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall >>> >> >>> >> >>> >> _______________________________________________ >>> >> Rekall mailing list >>> >> Rekall@... >>> >> http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall >>> > >>> > >>> > _______________________________________________ >>> > Rekall mailing list >>> > Rekall@... >>> > http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall >>> >>> >>> _______________________________________________ >>> Rekall mailing list >>> Rekall@... >>> http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall >> >> _______________________________________________ >> Rekall mailing list >> Rekall@... >> http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall > > > _______________________________________________ > Rekall mailing list > Rekall@... > http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall _______________________________________________ Rekall mailing list Rekall@... http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall |
|
|
Re: not able to enter time with form
by bill murphy-2
::
Rate this Message:
I can enter the data in "table>data view" and it is stored correctly
in the db, this is a little clunky but it works. The bigger problem to me is getting the "time" to show correctly in the reports pulled against the table, it's decipherable to me but not so good for others looking at the reports. Bill ----- Original Message ----- From: "Andree Clausing" <andree@...> To: <rekall@...> Sent: Wednesday, March 12, 2008 12:59 AM Subject: Re: [Rekall] not able to enter time with form > Some problems come, when i change the time format. > > So dont change the time format until your problem has gone. > > Andree > > > Am 12.03.2008, 07:53 Uhr, schrieb Andree Clausing <andree@...>: > > > I have had also problems with date / time values in the past. > > > > The problems are round how Reckall store values in the database. > > > > My solution was to check out, which values work good and which > > values work not. > > > > Make a new form and try a little with time values, perhabs you > > have to write 13:00, not 1:00pm. > > > > Look at the mySQL-manual how it wish time values. > > > > Andree > > > > Am 12.03.2008, 02:11 Uhr, schrieb bill <bmurphy@...>: > > > >> Andree: > >> > >> it won't help with my immediate problem, but it's another tool in > >> box that may come in handy one day. > >> > >> I'm going to keep investigating the time issue and try to see the > >> full extent of it. I'm not a programmer, so the chance of me fixing it > >> is slim, but at least I can pass on what I learn to someone that can. > >> > >> Bill > >> > >> On Tue, 2008-03-11 at 13:54 +0100, Andree Clausing wrote: > >>> I have a small Python Script in the on_leave event. > >>> > >>> def eventFunc (field, row) : > >>> import MyTools > >>> t = field.value > >>> if (t is not None) and (t != "") : > >>> field.value = MyTools.checkTime(t) > >>> return 1 > >>> > >>> ---------------------------------------------- > >>> def checkTime (ti): # Einen Zeitwert prüfen und zurückgeben > >>> import string > >>> import RekallMain > >>> if ti <> None : > >>> t = ti > >>> t = string.strip(str(t)) # Leerzeichen > >>> entfernen > >>> t = string.replace(t,",",":") # Komma zu > >>> tt = string.split(t,":") # muss ich > >>> noch > >>> umstricken, um split zu verwenden !! > >>> dpx = string.find(t,":") > >>> if (dpx == -1) : # Kein Doppelpunkt vorhanden > >>> if (len(t) == 4) : # 4 Zeichen, 2 für > >>> Stunde, 2 > >>> für Minute > >>> h = t[:2] # Stunden > >>> m = t[-2:] # Minuten > >>> else : > >>> h = t[:2] # Stunden > >>> m = "00" # Minuten > >>> else : # Doppelpunkt vorhanden > >>> h = t[:dpx] > >>> m = t[(dpx+1):] > >>> if (len(m) < 2) : > >>> m = m + "0" > >>> return h + ":" + m > >>> > >>> It's not directly usefull for you (I think..), but perhabs.. > >>> > >>> Andree > >>> > >>> > >>> Am 11.03.2008, 13:30 Uhr, schrieb bill murphy > >>> > >>> > I did try that before posting, and also all validation is turned off > >>> > > >>> > ----- Original Message ----- > >>> > From: "Andree Clausing" <andree@...> > >>> > To: <rekall@...> > >>> > Sent: Tuesday, March 11, 2008 1:17 AM > >>> > Subject: Re: [Rekall] not able to enter time with form > >>> > > >>> > > >>> >> Hello Bill.. > >>> >> > >>> >> Try check > >>> >> > >>> >> Properties->Data->Format->force specified format > >>> >> > >>> >> Andree > >>> >> > >>> >> Am 11.03.2008, 04:43 Uhr, schrieb bill <bmurphy@...>: > >>> >> > >>> >> > Hi all, > >>> >> > > >>> >> > I'm using Rekall 2.4.6 with a mysql db, I have a table with > >>> > "time" > >>> >> > field, on the table data view I am able to enter the time 12:50:00 > >>> >> > and the db is updated accordingly, however when I use a form to > >>> > enter > >>> >> > the data, no time between 12:00 through 12:59 can be entered (am > >>> > or pm) > >>> >> > without throwing an error. No other entries regardless of time is > >>> >> > affected. > >>> >> > > >>> >> > This is also showing up on a report built against the table, for > >>> >> > instance if the db has a time of 12:50:00 entered in it, the > >>> > report will > >>> >> > show a time of 00:50, this only occurs for times between 12:00 > >>> > through > >>> >> > 12:59, am or pm. > >>> >> > > >>> >> > Is this a known problem? Is there a fix? > >>> >> > > >>> >> > Thanks > >>> >> > > >>> >> > Bill > >>> >> > > >>> >> > _______________________________________________ > >>> >> > Rekall mailing list > >>> >> > Rekall@... > >>> >> > > >>> >> > >>> >> > >>> >> _______________________________________________ > >>> >> Rekall mailing list > >>> >> Rekall@... > >>> >> http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall > >>> > > >>> > > >>> > _______________________________________________ > >>> > Rekall mailing list > >>> > Rekall@... > >>> > http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall > >>> > >>> > >>> _______________________________________________ > >>> Rekall mailing list > >>> Rekall@... > >>> http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall > >> > >> _______________________________________________ > >> Rekall mailing list > >> Rekall@... > >> http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall > > > > > > _______________________________________________ > > Rekall mailing list > > Rekall@... > > http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall > > > _______________________________________________ > Rekall mailing list > Rekall@... > http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall _______________________________________________ Rekall mailing list Rekall@... http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall |
|
|
Re: not able to enter time with form
by Andree Clausing
::
Rate this Message:
Showing and formating values is easy.
But first it must work and then it must show good. Can you enter valid values in a form? Andree Am 12.03.2008, 14:10 Uhr, schrieb bill murphy <bmurphy@...>: > I can enter the data in "table>data view" and it is stored correctly > in the db, this is a little clunky but it works. > > The bigger problem to me is getting the "time" to show correctly > in the reports pulled against the table, it's decipherable to me > but not so good for others looking at the reports. > > Bill > > > ----- Original Message ----- > From: "Andree Clausing" <andree@...> > To: <rekall@...> > Sent: Wednesday, March 12, 2008 12:59 AM > Subject: Re: [Rekall] not able to enter time with form > > >> Some problems come, when i change the time format. >> >> So dont change the time format until your problem has gone. >> >> Andree >> >> >> Am 12.03.2008, 07:53 Uhr, schrieb Andree Clausing > <andree@...>: >> >> > I have had also problems with date / time values in the past. >> > >> > The problems are round how Reckall store values in the database. >> > >> > My solution was to check out, which values work good and which >> > values work not. >> > >> > Make a new form and try a little with time values, perhabs you >> > have to write 13:00, not 1:00pm. >> > >> > Look at the mySQL-manual how it wish time values. >> > >> > Andree >> > >> > Am 12.03.2008, 02:11 Uhr, schrieb bill <bmurphy@...>: >> > >> >> Andree: >> >> >> >> it won't help with my immediate problem, but it's another tool in > the >> >> box that may come in handy one day. >> >> >> >> I'm going to keep investigating the time issue and try to see the >> >> full extent of it. I'm not a programmer, so the chance of me > fixing it >> >> is slim, but at least I can pass on what I learn to someone that > can. >> >> >> >> Bill >> >> >> >> On Tue, 2008-03-11 at 13:54 +0100, Andree Clausing wrote: >> >>> I have a small Python Script in the on_leave event. >> >>> >> >>> def eventFunc (field, row) : >> >>> import MyTools >> >>> t = field.value >> >>> if (t is not None) and (t != "") : >> >>> field.value = MyTools.checkTime(t) >> >>> return 1 >> >>> >> >>> ---------------------------------------------- >> >>> def checkTime (ti): # Einen Zeitwert prüfen und zurückgeben >> >>> import string >> >>> import RekallMain >> >>> if ti <> None : >> >>> t = ti >> >>> t = string.strip(str(t)) # Leerzeichen >> >>> entfernen >> >>> t = string.replace(t,",",":") # Komma zu > Doppelpunkt >> >>> tt = string.split(t,":") # muss > ich >> >>> noch >> >>> umstricken, um split zu verwenden !! >> >>> dpx = string.find(t,":") >> >>> if (dpx == -1) : # Kein Doppelpunkt vorhanden >> >>> if (len(t) == 4) : # 4 Zeichen, 2 für >> >>> Stunde, 2 >> >>> für Minute >> >>> h = t[:2] # Stunden >> >>> m = t[-2:] # Minuten >> >>> else : >> >>> h = t[:2] # Stunden >> >>> m = "00" # Minuten >> >>> else : # Doppelpunkt vorhanden >> >>> h = t[:dpx] >> >>> m = t[(dpx+1):] >> >>> if (len(m) < 2) : >> >>> m = m + "0" >> >>> return h + ":" + m >> >>> >> >>> It's not directly usefull for you (I think..), but perhabs.. >> >>> >> >>> Andree >> >>> >> >>> >> >>> Am 11.03.2008, 13:30 Uhr, schrieb bill murphy > <bmurphy@...>: >> >>> >> >>> > I did try that before posting, and also all validation is > turned off >> >>> > >> >>> > ----- Original Message ----- >> >>> > From: "Andree Clausing" <andree@...> >> >>> > To: <rekall@...> >> >>> > Sent: Tuesday, March 11, 2008 1:17 AM >> >>> > Subject: Re: [Rekall] not able to enter time with form >> >>> > >> >>> > >> >>> >> Hello Bill.. >> >>> >> >> >>> >> Try check >> >>> >> >> >>> >> Properties->Data->Format->force specified format >> >>> >> >> >>> >> Andree >> >>> >> >> >>> >> Am 11.03.2008, 04:43 Uhr, schrieb bill <bmurphy@...>: >> >>> >> >> >>> >> > Hi all, >> >>> >> > >> >>> >> > I'm using Rekall 2.4.6 with a mysql db, I have a table with > a >> >>> > "time" >> >>> >> > field, on the table data view I am able to enter the time > 12:50:00 >> >>> >> > and the db is updated accordingly, however when I use a > form to >> >>> > enter >> >>> >> > the data, no time between 12:00 through 12:59 can be > entered (am >> >>> > or pm) >> >>> >> > without throwing an error. No other entries regardless of > time is >> >>> >> > affected. >> >>> >> > >> >>> >> > This is also showing up on a report built against the > table, for >> >>> >> > instance if the db has a time of 12:50:00 entered in it, > the >> >>> > report will >> >>> >> > show a time of 00:50, this only occurs for times between > 12:00 >> >>> > through >> >>> >> > 12:59, am or pm. >> >>> >> > >> >>> >> > Is this a known problem? Is there a fix? >> >>> >> > >> >>> >> > Thanks >> >>> >> > >> >>> >> > Bill >> >>> >> > >> >>> >> > _______________________________________________ >> >>> >> > Rekall mailing list >> >>> >> > Rekall@... >> >>> >> > > http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall >> >>> >> >> >>> >> >> >>> >> _______________________________________________ >> >>> >> Rekall mailing list >> >>> >> Rekall@... >> >>> >> > http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall >> >>> > >> >>> > >> >>> > _______________________________________________ >> >>> > Rekall mailing list >> >>> > Rekall@... >> >>> > http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall >> >>> >> >>> >> >>> _______________________________________________ >> >>> Rekall mailing list >> >>> Rekall@... >> >>> http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall >> >> >> >> _______________________________________________ >> >> Rekall mailing list >> >> Rekall@... >> >> http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall >> > >> > >> > _______________________________________________ >> > Rekall mailing list >> > Rekall@... >> > http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall >> >> >> _______________________________________________ >> Rekall mailing list >> Rekall@... >> http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall > > > _______________________________________________ > Rekall mailing list > Rekall@... > http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall _______________________________________________ Rekall mailing list Rekall@... http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall |
|
|
Re: not able to enter time with form
by bill murphy-2
::
Rate this Message:
Not if the time is between 12:00 to 12:59 pm or am, The form throws the error "not a valid date time" (form is set to "time" only, not "date time"). In other words, I can enter 1:01 pm, but not 12:59 pm, it has to be something to do with the way Rekall translates the 12. If I enter 12:59 in "table> data view" the entry shows up in the form and reports as 00:59 which would be mistaken as 59 mins past midnight. Which brings to mind, I have not tried to set db field and form to "date-time" and see if it would take entries that way. I'll try that when I get back to the machine in question. Thanks for your i |
