![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
![]()
I'm testing the import procedures and capabilities of Outlook 2007. I have a
small csv file which has 3 contacts in it. For this particular import I have allowed duplicates to be created. In the custom mapping area all fields have been mapped. When I click "next" it moves from the 1st contact to the second. When I click "next" again it moves to the 3rd contact. However, when I click "next" a third time it doesn't take me back to the 1st contact. It takes me back to the 2nd contact, and if I click "next" again it takes forward to the 3rd contact....moving back and forth between 2 and 3. Only when I click "previous" it will take me back to the 1st contact. This may be relevant when I get to my problem, but for now I'm confirming that 3 contacts are in the .csv file (they are listed in Excel when I open in Excel). In Outlook I select "import from another program or file" then "comma separated values (Windows)" then I select the .csv file created (with 3 contacts) then "allow duplicates to be ceated" then I select the contact folder I want these contacts in. I have three different contact folders to sort contacts by type. Afte all of this Outlook only imports contact 2 and 3.....NOT contact 1. I have tried rebooting, deleting the csv file and reexporting/reimporting...all with no luck. It won't import the 1st contact in that file. Any ideas? Thanks |
#2
|
|||
|
|||
![]()
By the sounds of things, you have a CSV file with no header row (first
record containing field names for all the columns in the subsequent rows). Suggest you add a header row, map your fields and then just import the file without cycling thru the records from the left hand side of the field map screen. Think you'll find that all of your contacts will be imported (barring any other issues in your CSV file). Karl __________________________________________________ _ Karl Timmermans - The Claxton Group ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter "Power contact importers/exporters for MS Outlook '2000/2007" http://www.contactgenie.com "Jason" wrote in message ... I'm testing the import procedures and capabilities of Outlook 2007. I have a small csv file which has 3 contacts in it. For this particular import I have allowed duplicates to be created. In the custom mapping area all fields have been mapped. When I click "next" it moves from the 1st contact to the second. When I click "next" again it moves to the 3rd contact. However, when I click "next" a third time it doesn't take me back to the 1st contact. It takes me back to the 2nd contact, and if I click "next" again it takes forward to the 3rd contact....moving back and forth between 2 and 3. Only when I click "previous" it will take me back to the 1st contact. This may be relevant when I get to my problem, but for now I'm confirming that 3 contacts are in the .csv file (they are listed in Excel when I open in Excel). In Outlook I select "import from another program or file" then "comma separated values (Windows)" then I select the .csv file created (with 3 contacts) then "allow duplicates to be ceated" then I select the contact folder I want these contacts in. I have three different contact folders to sort contacts by type. Afte all of this Outlook only imports contact 2 and 3.....NOT contact 1. I have tried rebooting, deleting the csv file and reexporting/reimporting...all with no luck. It won't import the 1st contact in that file. Any ideas? Thanks |
#3
|
|||
|
|||
![]()
Karl, Thanks for the reply. You have me going in the right direction now. I
went back to my "exporting" program and selected "export heading" in the export process. Now when I go to import into OL 2007 and am in the mapping window I have some "fields" before the 1st contact. I still have to "next" to the first contact so I can map first/last name busines addy and phone and home addy and phone etc etc. When I do the import I get the 1st contact now, but I also get a contact "first name" "last name". So now instead of importing 2 contacts I'm importing 4 (3 accurate conatcts and 1 FirstName, LastName) I'm definitely on the right track though. "Karl Timmermans" wrote: By the sounds of things, you have a CSV file with no header row (first record containing field names for all the columns in the subsequent rows). Suggest you add a header row, map your fields and then just import the file without cycling thru the records from the left hand side of the field map screen. Think you'll find that all of your contacts will be imported (barring any other issues in your CSV file). Karl __________________________________________________ _ Karl Timmermans - The Claxton Group ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter "Power contact importers/exporters for MS Outlook '2000/2007" http://www.contactgenie.com "Jason" wrote in message ... I'm testing the import procedures and capabilities of Outlook 2007. I have a small csv file which has 3 contacts in it. For this particular import I have allowed duplicates to be created. In the custom mapping area all fields have been mapped. When I click "next" it moves from the 1st contact to the second. When I click "next" again it moves to the 3rd contact. However, when I click "next" a third time it doesn't take me back to the 1st contact. It takes me back to the 2nd contact, and if I click "next" again it takes forward to the 3rd contact....moving back and forth between 2 and 3. Only when I click "previous" it will take me back to the 1st contact. This may be relevant when I get to my problem, but for now I'm confirming that 3 contacts are in the .csv file (they are listed in Excel when I open in Excel). In Outlook I select "import from another program or file" then "comma separated values (Windows)" then I select the .csv file created (with 3 contacts) then "allow duplicates to be ceated" then I select the contact folder I want these contacts in. I have three different contact folders to sort contacts by type. Afte all of this Outlook only imports contact 2 and 3.....NOT contact 1. I have tried rebooting, deleting the csv file and reexporting/reimporting...all with no luck. It won't import the 1st contact in that file. Any ideas? Thanks |
#4
|
|||
|
|||
![]()
Not sure I fully understand your description of the problem but taking
Outlook out of the equation for a moment, your exported output file should have 4 rows (one header row and 3 contact data rows) - just have to open the file in a text editor or Excel to see what you're getting. Anything other then that - the issue is with the program creating the file. Other then that, if the file is correctly constructed, only other thing that I can think of that may "remotely" even have an impact is your previous mapping considering that you originally started with a non-header based CSV file etc. If that's the case, completely clear the Outlook field map and explicitly re-map all your fields. Bottomline - if the CSV file is correctly constructed and the fields are properly mapped - the Outlook import wizard works as advertised for the functionality included (but it can get "cranky" real quick if there are errors/exceptions in the file to be imported). Karl __________________________________________________ _ Karl Timmermans - The Claxton Group ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter "Power contact importers/exporters for MS Outlook '2000/2007" http://www.contactgenie.com "Jason" wrote in message ... Karl, Thanks for the reply. You have me going in the right direction now. I went back to my "exporting" program and selected "export heading" in the export process. Now when I go to import into OL 2007 and am in the mapping window I have some "fields" before the 1st contact. I still have to "next" to the first contact so I can map first/last name busines addy and phone and home addy and phone etc etc. When I do the import I get the 1st contact now, but I also get a contact "first name" "last name". So now instead of importing 2 contacts I'm importing 4 (3 accurate conatcts and 1 FirstName, LastName) I'm definitely on the right track though. "Karl Timmermans" wrote: By the sounds of things, you have a CSV file with no header row (first record containing field names for all the columns in the subsequent rows). Suggest you add a header row, map your fields and then just import the file without cycling thru the records from the left hand side of the field map screen. Think you'll find that all of your contacts will be imported (barring any other issues in your CSV file). Karl __________________________________________________ _ Karl Timmermans - The Claxton Group ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter "Power contact importers/exporters for MS Outlook '2000/2007" http://www.contactgenie.com "Jason" wrote in message ... I'm testing the import procedures and capabilities of Outlook 2007. I have a small csv file which has 3 contacts in it. For this particular import I have allowed duplicates to be created. In the custom mapping area all fields have been mapped. When I click "next" it moves from the 1st contact to the second. When I click "next" again it moves to the 3rd contact. However, when I click "next" a third time it doesn't take me back to the 1st contact. It takes me back to the 2nd contact, and if I click "next" again it takes forward to the 3rd contact....moving back and forth between 2 and 3. Only when I click "previous" it will take me back to the 1st contact. This may be relevant when I get to my problem, but for now I'm confirming that 3 contacts are in the .csv file (they are listed in Excel when I open in Excel). In Outlook I select "import from another program or file" then "comma separated values (Windows)" then I select the .csv file created (with 3 contacts) then "allow duplicates to be ceated" then I select the contact folder I want these contacts in. I have three different contact folders to sort contacts by type. Afte all of this Outlook only imports contact 2 and 3.....NOT contact 1. I have tried rebooting, deleting the csv file and reexporting/reimporting...all with no luck. It won't import the 1st contact in that file. Any ideas? Thanks |
#5
|
|||
|
|||
![]()
So the origin of my contacts could be causing the problem. When I open the
..csv file in Excel I have 5 rows. In the origin software you have to identify "import/export definitions". You can have a number of different definitions based on what you want to export. For now I have one called "CDS Contacts". Row 1 in Excel contains the definition name. Row 2 in Excel contains the field names Row 3-5 in Excel contain the contact details. So if I unuderstand you correctly OL 2007 is treating row 1 as the header and picking up row 2 as a contact. Thus the person with the first name "firstname" and last name "lastname". I will have to consult with our tech deparment to see is it's possible to avoid exporting that definition title. Thanks for your help. jason "Karl Timmermans" wrote: Not sure I fully understand your description of the problem but taking Outlook out of the equation for a moment, your exported output file should have 4 rows (one header row and 3 contact data rows) - just have to open the file in a text editor or Excel to see what you're getting. Anything other then that - the issue is with the program creating the file. Other then that, if the file is correctly constructed, only other thing that I can think of that may "remotely" even have an impact is your previous mapping considering that you originally started with a non-header based CSV file etc. If that's the case, completely clear the Outlook field map and explicitly re-map all your fields. Bottomline - if the CSV file is correctly constructed and the fields are properly mapped - the Outlook import wizard works as advertised for the functionality included (but it can get "cranky" real quick if there are errors/exceptions in the file to be imported). Karl __________________________________________________ _ Karl Timmermans - The Claxton Group ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter "Power contact importers/exporters for MS Outlook '2000/2007" http://www.contactgenie.com "Jason" wrote in message ... Karl, Thanks for the reply. You have me going in the right direction now. I went back to my "exporting" program and selected "export heading" in the export process. Now when I go to import into OL 2007 and am in the mapping window I have some "fields" before the 1st contact. I still have to "next" to the first contact so I can map first/last name busines addy and phone and home addy and phone etc etc. When I do the import I get the 1st contact now, but I also get a contact "first name" "last name". So now instead of importing 2 contacts I'm importing 4 (3 accurate conatcts and 1 FirstName, LastName) I'm definitely on the right track though. "Karl Timmermans" wrote: By the sounds of things, you have a CSV file with no header row (first record containing field names for all the columns in the subsequent rows). Suggest you add a header row, map your fields and then just import the file without cycling thru the records from the left hand side of the field map screen. Think you'll find that all of your contacts will be imported (barring any other issues in your CSV file). Karl __________________________________________________ _ Karl Timmermans - The Claxton Group ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter "Power contact importers/exporters for MS Outlook '2000/2007" http://www.contactgenie.com "Jason" wrote in message ... I'm testing the import procedures and capabilities of Outlook 2007. I have a small csv file which has 3 contacts in it. For this particular import I have allowed duplicates to be created. In the custom mapping area all fields have been mapped. When I click "next" it moves from the 1st contact to the second. When I click "next" again it moves to the 3rd contact. However, when I click "next" a third time it doesn't take me back to the 1st contact. It takes me back to the 2nd contact, and if I click "next" again it takes forward to the 3rd contact....moving back and forth between 2 and 3. Only when I click "previous" it will take me back to the 1st contact. This may be relevant when I get to my problem, but for now I'm confirming that 3 contacts are in the .csv file (they are listed in Excel when I open in Excel). In Outlook I select "import from another program or file" then "comma separated values (Windows)" then I select the .csv file created (with 3 contacts) then "allow duplicates to be ceated" then I select the contact folder I want these contacts in. I have three different contact folders to sort contacts by type. Afte all of this Outlook only imports contact 2 and 3.....NOT contact 1. I have tried rebooting, deleting the csv file and reexporting/reimporting...all with no luck. It won't import the 1st contact in that file. Any ideas? Thanks |
#6
|
|||
|
|||
![]()
Seems like the program creating your export file is doing it in some
structure that is required for itself. No program could correctly deal with your CSV file if it contains 5 discrete records to import 3 contacts with a header row (total of 4 records). Simple solution if the export program can't eliminate the extraneous row- - - - - - - - - - -just open up the file (either in Excel or a text editor) and delete the needless row then re-save the CSV file. Karl __________________________________________________ _ Karl Timmermans - The Claxton Group ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter "Power contact importers/exporters for MS Outlook '2000/2007" http://www.contactgenie.com "Jason" wrote in message ... So the origin of my contacts could be causing the problem. When I open the .csv file in Excel I have 5 rows. In the origin software you have to identify "import/export definitions". You can have a number of different definitions based on what you want to export. For now I have one called "CDS Contacts". Row 1 in Excel contains the definition name. Row 2 in Excel contains the field names Row 3-5 in Excel contain the contact details. So if I unuderstand you correctly OL 2007 is treating row 1 as the header and picking up row 2 as a contact. Thus the person with the first name "firstname" and last name "lastname". I will have to consult with our tech deparment to see is it's possible to avoid exporting that definition title. Thanks for your help. jason "Karl Timmermans" wrote: Not sure I fully understand your description of the problem but taking Outlook out of the equation for a moment, your exported output file should have 4 rows (one header row and 3 contact data rows) - just have to open the file in a text editor or Excel to see what you're getting. Anything other then that - the issue is with the program creating the file. Other then that, if the file is correctly constructed, only other thing that I can think of that may "remotely" even have an impact is your previous mapping considering that you originally started with a non-header based CSV file etc. If that's the case, completely clear the Outlook field map and explicitly re-map all your fields. Bottomline - if the CSV file is correctly constructed and the fields are properly mapped - the Outlook import wizard works as advertised for the functionality included (but it can get "cranky" real quick if there are errors/exceptions in the file to be imported). Karl __________________________________________________ _ Karl Timmermans - The Claxton Group ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter "Power contact importers/exporters for MS Outlook '2000/2007" http://www.contactgenie.com "Jason" wrote in message ... Karl, Thanks for the reply. You have me going in the right direction now. I went back to my "exporting" program and selected "export heading" in the export process. Now when I go to import into OL 2007 and am in the mapping window I have some "fields" before the 1st contact. I still have to "next" to the first contact so I can map first/last name busines addy and phone and home addy and phone etc etc. When I do the import I get the 1st contact now, but I also get a contact "first name" "last name". So now instead of importing 2 contacts I'm importing 4 (3 accurate conatcts and 1 FirstName, LastName) I'm definitely on the right track though. "Karl Timmermans" wrote: By the sounds of things, you have a CSV file with no header row (first record containing field names for all the columns in the subsequent rows). Suggest you add a header row, map your fields and then just import the file without cycling thru the records from the left hand side of the field map screen. Think you'll find that all of your contacts will be imported (barring any other issues in your CSV file). Karl __________________________________________________ _ Karl Timmermans - The Claxton Group ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter "Power contact importers/exporters for MS Outlook '2000/2007" http://www.contactgenie.com "Jason" wrote in message ... I'm testing the import procedures and capabilities of Outlook 2007. I have a small csv file which has 3 contacts in it. For this particular import I have allowed duplicates to be created. In the custom mapping area all fields have been mapped. When I click "next" it moves from the 1st contact to the second. When I click "next" again it moves to the 3rd contact. However, when I click "next" a third time it doesn't take me back to the 1st contact. It takes me back to the 2nd contact, and if I click "next" again it takes forward to the 3rd contact....moving back and forth between 2 and 3. Only when I click "previous" it will take me back to the 1st contact. This may be relevant when I get to my problem, but for now I'm confirming that 3 contacts are in the .csv file (they are listed in Excel when I open in Excel). In Outlook I select "import from another program or file" then "comma separated values (Windows)" then I select the .csv file created (with 3 contacts) then "allow duplicates to be ceated" then I select the contact folder I want these contacts in. I have three different contact folders to sort contacts by type. Afte all of this Outlook only imports contact 2 and 3.....NOT contact 1. I have tried rebooting, deleting the csv file and reexporting/reimporting...all with no luck. It won't import the 1st contact in that file. Any ideas? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Import vCard should be able to import multiple contact in one file | pingel | Outlook - Using Contacts | 1 | February 29th 08 02:31 PM |
Import contact from outlook 2003 to windows vista contact | Nicolas | Outlook - Using Contacts | 1 | June 1st 07 03:43 PM |
I'm missing L4561412.CAB and can't import Contacts as a .csv file | RagtimeSAE | Outlook - Using Contacts | 0 | May 25th 07 12:17 AM |
How to drag a Windows Live map into a contact file in Outlook? | CleanGene | Outlook - Using Contacts | 0 | April 17th 07 04:04 AM |
excel file type missing from import a file window in outlook | xanadufl | Outlook - Using Contacts | 9 | February 28th 06 09:55 AM |