antp.be forum

I have tried to import my movie collection through CSV. Everything works fine except the field Date Added.

Even when I set a date in an Ant Movie catalog, export it to CSV and then again import to a new catalog, the date isn't imported.

I tried this in 3.5.1.2 and 3.8.2 with Slovak interface a Slovak regional settings (short date: "d. M. yyyy"; long date: "d. MMMM. yyyy").

I use Win7 x64.

Thank you for your help.

Here is the heading and one row from CSV as an example.

Kód;Číslo;Označené;Štítok média;Druh média;Zdroj;Dátum pridania;Požičané;Ohodnotenie;Pôvodný názov;Preložený názov;Formátovaný názov;Režisér;Producent;Štát;Kategória;Rok;Dĺžka;Herci;URL;Popis;Komentáre;Formát Videa;Bitrate Videa;Formát Audia;Bitrate Audia;Rozlíšenie;Framerate;Jazyky;Titulky;Veľkosti súborov;Počet diskov;Picture
CD 01;1;TRUE;;CD;;7. 2. 2005;;6.6;Analyze This;Analyzuj;Analyze This (Analyzuj);Harold Ramis;Kenneth Lonergan (story), Peter Tolan (story) , (more);USA, Austrálie;Komedie, Krimi;1999;100;Robert De Niro, Billy Crystal, Lisa Kudrow, Chazz Palminteri, Kresimir Novakovic, Bart Tangredi, Michael Straka, Joseph Rigano, Joe Viterelli, Richard C. Castellano, Molly Shannon, Max Casella, Frank Pietrangolare, Kyle Sabihy, Bill Macy;http://www.csfd.cz/film/7566-preber-si- ... ;;;katalog filmov_1.jpg

Hi prorokrak,

For now, date need to be in this format dd/mm/yyyy.
I will see to add a date format pattern to import/export in CSV.

Soulsnake.

Great, now it works. Thank you very much for your help.

Maybe, as default, Ant could expect date format according to user regional settings set in system -> that's the format that is used during export. It could be fine for the most of users who are not very techy. And adding the option for setting date format pattern would be great for others who like playing with different settings :-)

Until then, it would be great at least document required date format for CSV in help file.

Because of this problem, I put default pattern dd/mm/yyyy for all during export/import of CSV and XML (AMCU 4.0.0 [BETA]).
Actually, user regional settings is a problem if user import database on other system with others settings!

Until then, it would be great at least document required date format for CSV in help file.

I will add it .