 |
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows 7. The Windows 7 forum also covers news and updates and has an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.
Windows 7 - Importing Contacts to WLM |
01-19-2012
|
#1 | | |
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 | | |
01-19-2012
|
#2 | | |
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 Logitech M500 Laser Mouse PSU OCZ 600w Case Lian-Li PC8 acoustifoamed' aluminium tower Cooling Scythe 140mm Zipang Hard Drives Twin 1Tb Barracuda archivage, Twin TV/PVR 2Tb Samsungs, (80Gb Barracuda for the OS, but SSD envisaged...) Internet Speed ADSL2+ @14Mbps downstream & Cat6 Gigabit Ethernet Other Info Silicon Dust HD Homerun Dual FTA (Ethernet) TV Tuner, Billion BiPac 7800N router & ZyXEL 8x Gigabit Switch. Lian-Li CR26 Card Reader, Samsung SCX4300 AiO laser printer/scanner. NOD32 Anti-Virus. |
01-19-2012
|
#3 | | |
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 | | |
01-19-2012
|
#4 | | |
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 Logitech M500 Laser Mouse PSU OCZ 600w Case Lian-Li PC8 acoustifoamed' aluminium tower Cooling Scythe 140mm Zipang Hard Drives Twin 1Tb Barracuda archivage, Twin TV/PVR 2Tb Samsungs, (80Gb Barracuda for the OS, but SSD envisaged...) Internet Speed ADSL2+ @14Mbps downstream & Cat6 Gigabit Ethernet Other Info Silicon Dust HD Homerun Dual FTA (Ethernet) TV Tuner, Billion BiPac 7800N router & ZyXEL 8x Gigabit Switch. Lian-Li CR26 Card Reader, Samsung SCX4300 AiO laser printer/scanner. NOD32 Anti-Virus. |
01-19-2012
|
#5 | | |
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 | | |
01-19-2012
|
#6 | | |
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 Logitech M500 Laser Mouse PSU OCZ 600w Case Lian-Li PC8 acoustifoamed' aluminium tower Cooling Scythe 140mm Zipang Hard Drives Twin 1Tb Barracuda archivage, Twin TV/PVR 2Tb Samsungs, (80Gb Barracuda for the OS, but SSD envisaged...) Internet Speed ADSL2+ @14Mbps downstream & Cat6 Gigabit Ethernet Other Info Silicon Dust HD Homerun Dual FTA (Ethernet) TV Tuner, Billion BiPac 7800N router & ZyXEL 8x Gigabit Switch. Lian-Li CR26 Card Reader, Samsung SCX4300 AiO laser printer/scanner. NOD32 Anti-Virus. |
01-19-2012
|
#7 | | |
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 07:14 PM. |  |