| T O P I C R E V I E W |
| ComZiz |
Posted - 23 Apr 2009 : 17:08:19
All my "Date Puchased" & "Date Seen" datas has been deleted with the new version 7. These values are very, VERY critical for me and I personally and manually entered all the dates for hundreds of movies. 
Please tell me how to import the date values to the new & converted database, I got backups.
Also, I see that we can no longer add "Date Seen" & "Date Purchased" columns to the "Main Grid" which is another dissapointment for me, becuase I constantly need and use those values... 
Please help, thanks.
Erke |
| 6 L A T E S T R E P L I E S (Newest First) |
| ComZiz |
Posted - 30 Apr 2009 : 03:49:43
Date problem is perfectly fixed, thank you so much.
sorry for my late reply, my computer's power suply has gone unstable lately.
Erke |
| Alessio Viti |
Posted - 24 Apr 2009 : 11:02:38
Hi,
I have fix (I hope) definitely the date conversion problem, I am uploading just now the .5 release.
Will be ready in 30 minutes.
let me know,
Alessio |
| ternot |
Posted - 24 Apr 2009 : 09:56:00
Hi all,
the problem is related to the format of all date columns. In earlier versions these columns were just of type "text", now they are of type "date". Much better :-)
I think, the big problem with the date conversions are, as always, the different regional settings (To be found in the registry at "HKEY_CURRENT_USER\Control Panel\International\sShortDate")
Theoretically the date conversion could work like this:
- Read the regional date setting (e.g. "dd.mm.yyyy") as string
- Read the old date value (e.g. "20070109")
- Take the chars 1-4 as year, chars 5-6 as month, chars 7-8 as day (e.g. yyyy=207, mm=01, dd=09)
- Replace the placeholders in the date setting string -> 09.01.2007
- Add " 12:00:00" at the end -> 09.01.2007 12:00:00
- Write the new value into the database field
I tried this way manually with copying a date column of the old database to excel, altered the values as described before (For german date settings and in german excel the formula is like
'=TEIL(A3;7;2)&"."&TEIL(A3;5;2)&"."&TEIL(A3;1;4)&" 12:00:00"'
for english excel (also german date settings) like
'=MID(A3;7;2)&"."&MID(A3;5;2)&"."&MID(A3;1;4)&" 12:00:00"'
These values I copied into the date column of the new database, and Access accepted the values. XMM7 also ;-) So I can continue to use the fantastic new version (Thanks a lot, Alessio!)
I hope this helps
Best regards
ternot
|
| Alessio Viti |
Posted - 23 Apr 2009 : 22:10:43
The best way is make a backup and then... try 
Sorry for the stupid answer, but I have change the date from just a numbert to "Date" format, that is better for a database.
Let me know,
Alessio |
| ComZiz |
Posted - 23 Apr 2009 : 20:06:32
Before I do that, let me share something I figured out;
I opened both databases in MSACCESS and went to the DatePurchased column to see if I can copy the column to the new database.
But the old date format is like this: 20070109
while the new format also contains the hour like: 07 12:00:00 PM
I think this is the key issue.
My question is; what would happen if I copy the old format over the new one? Would it automatically assign a default hour or would it mess it up? |
| Alessio Viti |
Posted - 23 Apr 2009 : 18:28:47
Hi Comziz,
Please zip and send your "old" database to me, I will try to see what's wrong.
Alessio |
|
|
