database import drops DATETIME content values
NSBase is a database management system.
Brought to you by:
neuts-jl
Menu
▾
▴
the format of the column is probably not in the right format, what is your type of import (sqlite, text ...), and your operating system: windows, linux 32 or 64 bits ?
Last edit: neuts-jl 2020-01-29
Thanks a lot for your quick answer!
The import source was an SQLite database; host system is Windows 10 pro 64bit.
NSBase binary is the 32bit one.
My first guess, too, was the format of the datetime data in the source table (2020-01-29 17:53:00), but "29.01.2020 17:53:00" does not work either.
BTW: is there some way to access the Git / SVN repository in order to take part in the development? It's really a great piece of software!
P.S.: I would be glad to contribute some corrections concerning the german translation.
I go through a flat format, I use the utility sqlite3.exe which is optimized for a quick import.
Send me a sample of your sqlite database so that I can test it.
I have not yet looked completely at these GIT / SVN products from SourceForge, but it seems to me not very intuitive.
But you can already participate by sending me the correctly translated "langs/german.lng" file I will of course add in the participants,
Please find attached the sqlite3 DB file.
FYI: import from CSV file does not work either for me (regardless of whether the datetime field is formatted according to SQL standard (2020-01-30) or as a localized string (30.01.2020)).
Hope this won't boil down to my own stupidity... ;-)
Update: while inspecting the resulting .NSB file after import using SQLite Studio I found out that the import itself work pretty well; seems as if there were some problem while rendering on the "Data sheet" tab.
Last edit: Thomas Hemmer 2020-01-30
This is fixed in the next version, it is a problem in the ZEOS lib. The data is in the imported table, but cannot be displayed in date / time format, you change the type to text and it can be displayed or you are waiting for the next version
Merci beaucoup pour vôtre aide, je vais rester patient jusqu'alors ;-)