| Windows 7: Importing Contacts to WLM |
19 Jan 2012
|
| | |
Importing Contacts to WLM Hi
I have created a csv file from excel with all the contacts on and am trying to load it up to WLM on Windows 7 x64. I have loaded them all up in WM Vista with out a problem so the csv file is ok. Now trying WLM in Windows 7 but it will only take the first 172 ish contacts and then close. I have deleted the contacts from the csv file that imported, in the hope that the next 172 contacts will load up, but no; nothing loads up. It will also load up duplicates and have had 878 contacts so the number is no a problem. Any ideas guys? | My System Specs |
| |
19 Jan 2012
|
| | W7 x64 4,027 posts 3rd Rock from the Sun |
When your .csv file is constructed is it correctly formatted throughout? Double comma after each complete field, single comma between field variables?
Are the headers constructed with a single comma between field variables and without any comma at the end of the header section? Quote: Name,E-mail Address
Trudi Ball,tball213@googlemail.com,,
Ted Armstrong,e.armstrong@hmcts.gsi.gov.uk,,
Tony Narbell,tony.narbell@torridge.gov.uk,, | My System Specs | | System Manufacturer/Model Number Custom built machine OS W7 x64 CPU Intel Q9300 2.5Ghz Quad LGA775 (Would like Q9650) Motherboard Gigabyte GA-EP45T-UD3R (F6 Bios) Memory 4Gb OCZ Gold 1,333Mhz Graphics Card Palit HD4850 O/C Sonic 512Mb DDR3, Dual DViD's Sound Card Azalia to twin Samson 50w Studio Monitors Monitor(s) Displays Twin Dell (E-IPS) U2311H 23.6" Screens Screen Resolution 1920 x 1080 @ 60Hz Keyboard Cherry PS/2 custom model Mouse Lenovo USB laser "Thinkpad" Mouse PSU OCZ 600w Case Lian-Li PC8 acoustifoamed' aluminium tower Cooling Scythe 140mm Zipang Hard Drives Crucial M4 SSD, archives on twin Western Digital Caviar Black WD2002FAEX, 2TB, 7200rpm HDD's, Samsung Ritemaster CD/DVD Burner... Internet Speed ADSL2+ @14Mbps downstream & Cat6 Gigabit Ethernet Antivirus NOD32 Browser Opera Other Info Silicon Dust HD Homerun Dual FTA (Ethernet) TV Tuners, Dray Tek Vigor 2850Vn router and 8x HP Gigabit Switch. Lian-Li CR26 Card Reader, Canon MF4430 iSensys laser printer/scanner. |
19 Jan 2012
|
| | |
The format is nothing like that. It all appears in different cells. I exported one contact to a csv file to see how it was constructed, and then typed the rest. It imports and exports fine, but only up to 172 contacts, and all the remaining ones are identical format. It imports to WM on vista but not WLM on Windows 7. | My System Specs | | |
19 Jan 2012
|
| | W7 x64 4,027 posts 3rd Rock from the Sun |
The excerpt shown in my earlier post is how a .csv archive suitable for WLM import should look.
You may have more fields, but the format must comply...
Simply right click your .csv file and open with notepad/wordpad, or your preferred text editor, to verify/modify | My System Specs | | System Manufacturer/Model Number Custom built machine OS W7 x64 CPU Intel Q9300 2.5Ghz Quad LGA775 (Would like Q9650) Motherboard Gigabyte GA-EP45T-UD3R (F6 Bios) Memory 4Gb OCZ Gold 1,333Mhz Graphics Card Palit HD4850 O/C Sonic 512Mb DDR3, Dual DViD's Sound Card Azalia to twin Samson 50w Studio Monitors Monitor(s) Displays Twin Dell (E-IPS) U2311H 23.6" Screens Screen Resolution 1920 x 1080 @ 60Hz Keyboard Cherry PS/2 custom model Mouse Lenovo USB laser "Thinkpad" Mouse PSU OCZ 600w Case Lian-Li PC8 acoustifoamed' aluminium tower Cooling Scythe 140mm Zipang Hard Drives Crucial M4 SSD, archives on twin Western Digital Caviar Black WD2002FAEX, 2TB, 7200rpm HDD's, Samsung Ritemaster CD/DVD Burner... Internet Speed ADSL2+ @14Mbps downstream & Cat6 Gigabit Ethernet Antivirus NOD32 Browser Opera Other Info Silicon Dust HD Homerun Dual FTA (Ethernet) TV Tuners, Dray Tek Vigor 2850Vn router and 8x HP Gigabit Switch. Lian-Li CR26 Card Reader, Canon MF4430 iSensys laser printer/scanner. |
19 Jan 2012
|
| | |
Ok, so opening it in notepad looks like you say, and also far more contacts that where it stops at as well; so they are all in there. | My System Specs | | |
19 Jan 2012
|
| | W7 x64 4,027 posts 3rd Rock from the Sun |
Then it should import OK.
If it's stopping part way through then have you got a double comma where there should be a single one, or vice-versa? Has Excel formatting in any way caused a line break?
Drag your notepad window size around a bit to look for errors... | My System Specs | | System Manufacturer/Model Number Custom built machine OS W7 x64 CPU Intel Q9300 2.5Ghz Quad LGA775 (Would like Q9650) Motherboard Gigabyte GA-EP45T-UD3R (F6 Bios) Memory 4Gb OCZ Gold 1,333Mhz Graphics Card Palit HD4850 O/C Sonic 512Mb DDR3, Dual DViD's Sound Card Azalia to twin Samson 50w Studio Monitors Monitor(s) Displays Twin Dell (E-IPS) U2311H 23.6" Screens Screen Resolution 1920 x 1080 @ 60Hz Keyboard Cherry PS/2 custom model Mouse Lenovo USB laser "Thinkpad" Mouse PSU OCZ 600w Case Lian-Li PC8 acoustifoamed' aluminium tower Cooling Scythe 140mm Zipang Hard Drives Crucial M4 SSD, archives on twin Western Digital Caviar Black WD2002FAEX, 2TB, 7200rpm HDD's, Samsung Ritemaster CD/DVD Burner... Internet Speed ADSL2+ @14Mbps downstream & Cat6 Gigabit Ethernet Antivirus NOD32 Browser Opera Other Info Silicon Dust HD Homerun Dual FTA (Ethernet) TV Tuners, Dray Tek Vigor 2850Vn router and 8x HP Gigabit Switch. Lian-Li CR26 Card Reader, Canon MF4430 iSensys laser printer/scanner. |
19 Jan 2012
|
| | |
Sorted. by trial and error and shifting data about..... My contacts are labelled as Mr & Mrs Bloggs as the first name. The middle name is down as their kids Tom, Dick & Harry. but 2 families are rather large - 6 kids and it is those 2 lines that WLM drops out on the imports.
Thanks for assisting. | My System Specs | | Importing Contacts to WLM problems? All times are GMT -5. The time now is 01:25 PM. | |