| Author |
 Topic  |
|
|
Crux
Starting Member
Russia
35 Posts |
 Posted - 17 Feb 2009 : 17:15:30
|
Hi,
I've looked & searched through the forum a couple of times to find the proper date format for CSV Date format to be imported correctly to the fields such as Date Seen, Date Purchased, etc.
It doesn't import dates from CSV at all, and remains field with 01.01.1900 as default.
I've tried many different formats, including yyyymmdd,ddmmyyyy,yyyy.mm.dd,dd.mm.yyyy,yyyy/mm/dd,dd/mm/yyyy,yyyy-mm-dd,dd-mm-yyyy.
I even tried to Export CSV previously and it succeeded, but when I tried to import this file the dates remains default and haven't been imported.
Please, help.
Here is an example of Excel_Export.csv:
"MovieID";"Title";"OriginalTitle";"Genre";"Year";"Rating";"SeenWhen";"Modified";"xHtml";
"1";"Bernard";"Bernard";"Animation";"2004";"6,2";"20070913";"20090213";"7";
"2";"Bean";"Bean";"Comedy";"1997";"5,5";"20070910";"20090212";"11";
"432";"Dark City";"Dark City";"Mystery";"";"7,7";"20080911";"20090212";"";
"91";"Dead Presidents";"Dead Presidents";"Action";"1995";"6,4";"20080829";"20090212";"20";
"433";"Deal";"Deal";"Comedy";"";"5,1";"20080905";"20090212";"";
|
|
|
Crux
Starting Member
Russia
35 Posts |
Posted - 20 Feb 2009 : 13:30:48
|
Hi, Alessio,
is there any suggestions? |
 |
|
|
Alessio Viti
Forum Admin
Italy
9171 Posts |
|
|
Crux
Starting Member
Russia
35 Posts |
Posted - 21 Feb 2009 : 00:07:42
|
Hi, Alessio,
thanks for the reply. It's really sad to hear such limitation & as I was in need to import almost 1000 movies with the SeenWhen dates. So I've found bypass way to import CSV directly into MDB file.
Hi, everybody,
here is a step-by-step instruction on how to import CSV with any dates to your XMM database. I've made it successfully for my own CSV with more than 1000 movies inside:
1. Download & unpack MDB Viewer Plus (freeware)
- http://www.alexnolan.net/software/mdb_viewer_plus.htm
- it needs to import CSV directly to MDB file of the XMM database
2. Create empty database in XMM, f.e. Test
- it needs to avoid possible issues with your own normal XMM database
3. Prepare your CSV file with date format equals 'yyyymmdd'
- it needs to proper import of date fields
- here is a couple of rows from my own CSV file as example:
MovieID;Seen;DateInsert;Modified;SeenWhen;Title;OriginalTitle;Year;Custom3
1;1;20090220;20090220;20051010;11:14;11:14;2003;from xls base
2;1;20090220;20090220;20051112;Cellular;Сотовый;2004;from xls base
3;1;20090220;20090220;20051214;Lord of the Rings: The Fellowship of the Ring, The;Властелин колец: Братство кольца;2001;from xls base
4. Make sure that you have MovieID, DateInsert & Modified fields in your CSV as well
- it needs to proper work of the database in XMM after the import
- sort out your CSV by Title as it is the default order for Export to CSV in XMM & you'll be able to compare Exported CSV with your originally prepared CSV by MovieID field, in the final whether all movies has been imported successfully
5. Open your Test.mdb file in MDB Viewer Plus & switch to Movies table
6. Press Import button:
7. Import Wizard will appear, on File Format page:
- choose Text file(*.txt) & press Next
8. On File Name page:
- browse & select the prepared CSV file
- make sure the ANSI (Windows) origin used & press Next
9. On Text Settings page:
- select Delimeted & field delimeter select Semicolon (;)
- Record separator CRLF
- Text qualifier None & press Next
10. On Data Formats page:
- set Data Order to custom & make other changes similar to the screenshot below
- press Next
11. On File Preview page:
- make sure that all fields in the top row are the same as you are expecting
- make needed changes to correct fields mapping between CSV file & movie database fields
- press Next
12. On Mapping page:
- make a final review of the fields mapping
- select MovieID as a Key
- press Next
13. Press Next couple of times as you can use default values on the next pages & finally press Execute on Summary page
14. After the Import is completed
- check that an entry with MovieID 0 doesn't exist, if it exists - just simply delete it by pressing Minus button
- you can close MDB Viewer Plus
15. Open XMM & check that everything imported correctly, afterwards you are free to exchange(merge) movies from this Test.mdb database with your normal movie database.
Hope it will help some of you to make a speed start of XMM usage by importing your own existing databases from any other sources.
Good Luck. |
|
|
| |
Topic |
|
|
|
Date in CSV Import.
