I could really need your help on importing contacts into Outlook (Please?)

Jos · Nov 14, 2003

Hi all,

I need to import literally 3000 contacts into Outlook. Unfortunately, the
list (in plain text) looks like the list on the bottom of my message (small
example). I'm faced So, clearly, the data is not in a databaserecordformat
(with fields from the left to the right). Thus, I can not assign headers to
it (in Outlook), and thus I can not map the fields during the import into
Outlook. I know I can use "transpose" in Excel to change rows into columns,
but this still requires a lot of manual work: I have to select each block,
Edit/Copy, Edit/Paste Special/Transpose. With 3000 contacts I'm not happy to
do so, since it may cause the RSI-problems very easily. So, could anybody
recommend a solution to my problem? I would really, really, really
appreciate this (!).

Thanks a lot,

Kind regards,

Jos

[Example of the list]
3. Application Software S.A.
Elvira Rawson de Dellepiane 150, P6
1107 Buenos Aires
Argentina Phone: 11 4510-7300
URL: http://www.grupoassa.com/
6. Byte Tech Argentina S.A.
Av. Libertador 15090
B1641ANT Acasusso
Argentina Phone: 54 11 4707-0070
Fax: 54 11 4707-0070
Email: (e-mail address removed)
URL: http://www.bytetech.com.ar/
7. Close Up Internacional S.A.
Luis María Campos 42
C1425GEN Buenos Aires
Argentina Phone: 54 11 4771-3800
Fax: 54 11 4774-2167

8. DCL S.A.
Moreno 584, piso 11, of. A
C1091AAL Capital Federal
Argentina Phone: 54-11-5219-0591
URL: http://ww.dcl.com.ar/
9. DMR Consulting
Della Paolera 265, piso 20
C1001ADA Capital Federal
Argentina Phone: 54-11-5776-1700
12. Paradigma Consultores Asociados
Reconquista 1166, p. 9
C1003ABX Capital Federal
Argentina Phone: 54 11 4312-6888
Fax: 54 11 4313-6814
URL: http://www.paradigma.com/
14. Sema Argentina S.A.
Av. Pte. Roque Saenz Peña 1149, p.1
C1035AAG Buenos Aires
Argentina Phone: 54-11-4315-8811
Fax: 54-11-6315-8834

16. Soluziona S.A.
Av. Leandro N. Alem 896 , piso 10°
C1001AAQ Capital Federal
Argentina Phone: 54-11-4891-1600
Fax: 54-11-4891-1601
URL: http://www.soluziona.com.ar/
17. Sun Microsystems Argentina S.A
Bouchard 547, Piso 26
1106 Buenos Aires
Argentina URL: http://www.sun.com.ar/
18. Tecosoft Argentina S.A.
Av. del Libertador 6550 8º Piso
C1428ARV Buenos Aires
Argentina Phone: 11-4706-0060
Fax: 11-4706-0813
URL: http://www.tecosoft.com.ar/

Jos · Nov 14, 2003

Sorry, of course I meant "Thus I can not assign headers to it (in Excel)",
not in Outlook.

Kind regards,

Jos

Milly Staples [MVP - Outlook] · Nov 14, 2003

clintonG · Nov 14, 2003

I've scripted solutions for merchants needing to reformat and transfer
contact information back and forth between their desktop database and
their shopping cart database. If you're in business hiring somebody to
script a solution may be your most effective choice...

--
<%= Clinton Gallagher
A/E/C Consulting, Web Design, e-Commerce Software Development
Wauwatosa, Milwaukee County, Wisconsin USA
NET (e-mail address removed)
URL http://www.metromilwaukee.com/clintongallagher/

Jos said:
Hi all,

I need to import literally 3000 contacts into Outlook. Unfortunately, the
list (in plain text) looks like the list on the bottom of my message (small
example). I'm faced So, clearly, the data is not in a databaserecordformat
(with fields from the left to the right). Thus, I can not assign headers to
it (in Outlook), and thus I can not map the fields during the import into
Outlook. I know I can use "transpose" in Excel to change rows into columns,
but this still requires a lot of manual work: I have to select each block,
Edit/Copy, Edit/Paste Special/Transpose. With 3000 contacts I'm not happy to
do so, since it may cause the RSI-problems very easily. So, could anybody
recommend a solution to my problem? I would really, really, really
appreciate this (!).

Thanks a lot,

Kind regards,

Jos

[Example of the list]
3. Application Software S.A.
Elvira Rawson de Dellepiane 150, P6
1107 Buenos Aires
Argentina Phone: 11 4510-7300
URL: http://www.grupoassa.com/
6. Byte Tech Argentina S.A.
Av. Libertador 15090
B1641ANT Acasusso
Argentina Phone: 54 11 4707-0070
Fax: 54 11 4707-0070
Email: (e-mail address removed)
URL: http://www.bytetech.com.ar/
7. Close Up Internacional S.A.
Luis María Campos 42
C1425GEN Buenos Aires
Argentina Phone: 54 11 4771-3800
Fax: 54 11 4774-2167

8. DCL S.A.
Moreno 584, piso 11, of. A
C1091AAL Capital Federal
Argentina Phone: 54-11-5219-0591
URL: http://ww.dcl.com.ar/
9. DMR Consulting
Della Paolera 265, piso 20
C1001ADA Capital Federal
Argentina Phone: 54-11-5776-1700
12. Paradigma Consultores Asociados
Reconquista 1166, p. 9
C1003ABX Capital Federal
Argentina Phone: 54 11 4312-6888
Fax: 54 11 4313-6814
URL: http://www.paradigma.com/
14. Sema Argentina S.A.
Av. Pte. Roque Saenz Peña 1149, p.1
C1035AAG Buenos Aires
Argentina Phone: 54-11-4315-8811
Fax: 54-11-6315-8834

16. Soluziona S.A.
Av. Leandro N. Alem 896 , piso 10°
C1001AAQ Capital Federal
Argentina Phone: 54-11-4891-1600
Fax: 54-11-4891-1601
URL: http://www.soluziona.com.ar/
17. Sun Microsystems Argentina S.A
Bouchard 547, Piso 26
1106 Buenos Aires
Argentina URL: http://www.sun.com.ar/
18. Tecosoft Argentina S.A.
Av. del Libertador 6550 8º Piso
C1428ARV Buenos Aires
Argentina Phone: 11-4706-0060
Fax: 11-4706-0813
URL: http://www.tecosoft.com.ar/

Jos · Nov 14, 2003

Hi Milly,

The point is not that I don't know the recordformat; the point IS about
"massaging" as you call it: how to avoid manually manipulating the data in
the right format? Do you have a suggestion for that?

Regards,

Jos

Milly Staples said:
Easiest method for seeing what you need to do...

Create a couple of contacts in Outlook - populate all relevant fields. Then
Export it to a .txt format and a .csv format. See how each format is
configured. Massage your file into the proper format and then import.

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. Due to the
Swen virus, all e-mails sent to my actual account will be deleted w/out
reading.

After searching google.groups.com and finding no answer
Jos <Reply in newsgroup please> asked:

| Hi all,
|
| I need to import literally 3000 contacts into Outlook. Unfortunately,
| the list (in plain text) looks like the list on the bottom of my
| message (small example). I'm faced So, clearly, the data is not in a
| databaserecordformat (with fields from the left to the right). Thus,
| I can not assign headers to it (in Outlook), and thus I can not map
| the fields during the import into Outlook. I know I can use
| "transpose" in Excel to change rows into columns, but this still
| requires a lot of manual work: I have to select each block,
| Edit/Copy, Edit/Paste Special/Transpose. With 3000 contacts I'm not
| happy to do so, since it may cause the RSI-problems very easily. So,
| could anybody recommend a solution to my problem? I would really,
| really, really appreciate this (!).
|
| Thanks a lot,
|
| Kind regards,
|
| Jos
|
|
|
|
| [Example of the list]
| 3. Application Software S.A.
| Elvira Rawson de Dellepiane 150, P6
| 1107 Buenos Aires
| Argentina Phone: 11 4510-7300
| URL: http://www.grupoassa.com/
| 6. Byte Tech Argentina S.A.
| Av. Libertador 15090
| B1641ANT Acasusso
| Argentina Phone: 54 11 4707-0070
| Fax: 54 11 4707-0070
| Email: (e-mail address removed)
| URL: http://www.bytetech.com.ar/
| 7. Close Up Internacional S.A.
| Luis María Campos 42
| C1425GEN Buenos Aires
| Argentina Phone: 54 11 4771-3800
| Fax: 54 11 4774-2167
|
| 8. DCL S.A.
| Moreno 584, piso 11, of. A
| C1091AAL Capital Federal
| Argentina Phone: 54-11-5219-0591
| URL: http://ww.dcl.com.ar/
| 9. DMR Consulting
| Della Paolera 265, piso 20
| C1001ADA Capital Federal
| Argentina Phone: 54-11-5776-1700
| 12. Paradigma Consultores Asociados
| Reconquista 1166, p. 9
| C1003ABX Capital Federal
| Argentina Phone: 54 11 4312-6888
| Fax: 54 11 4313-6814
| URL: http://www.paradigma.com/
| 14. Sema Argentina S.A.
| Av. Pte. Roque Saenz Peña 1149, p.1
| C1035AAG Buenos Aires
| Argentina Phone: 54-11-4315-8811
| Fax: 54-11-6315-8834
|
|
| 16. Soluziona S.A.
| Av. Leandro N. Alem 896 , piso 10°
| C1001AAQ Capital Federal
| Argentina Phone: 54-11-4891-1600
| Fax: 54-11-4891-1601
| URL: http://www.soluziona.com.ar/
| 17. Sun Microsystems Argentina S.A
| Bouchard 547, Piso 26
| 1106 Buenos Aires
| Argentina URL: http://www.sun.com.ar/
| 18. Tecosoft Argentina S.A.
| Av. del Libertador 6550 8º Piso
| C1428ARV Buenos Aires
| Argentina Phone: 11-4706-0060
| Fax: 11-4706-0813
| URL: http://www.tecosoft.com.ar/

Sue Mosher [MVP] · Nov 14, 2003

Without a standardized format, about the only way to convert this data is to massage it by hand or write code to try to parse it. Not an easy task in either case. If both the data and your time are value, you may want to consider paying for outside help.
--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers

After searching google.groups.com and finding no answer
Jos <Reply in newsgroup please> asked:

| Hi all,
|
| I need to import literally 3000 contacts into Outlook. Unfortunately,
| the list (in plain text) looks like the list on the bottom of my
| message (small example). I'm faced So, clearly, the data is not in a
| databaserecordformat (with fields from the left to the right). Thus,
| I can not assign headers to it (in Outlook), and thus I can not map
| the fields during the import into Outlook. I know I can use
| "transpose" in Excel to change rows into columns, but this still
| requires a lot of manual work: I have to select each block,
| Edit/Copy, Edit/Paste Special/Transpose. With 3000 contacts I'm not
| happy to do so, since it may cause the RSI-problems very easily. So,
| could anybody recommend a solution to my problem? I would really,
| really, really appreciate this (!).
|
| Thanks a lot,
|
| Kind regards,
|
| Jos
|
|
|
|
| [Example of the list]
| 3. Application Software S.A.
| Elvira Rawson de Dellepiane 150, P6
| 1107 Buenos Aires
| Argentina Phone: 11 4510-7300
| URL: http://www.grupoassa.com/
| 6. Byte Tech Argentina S.A.
| Av. Libertador 15090
| B1641ANT Acasusso
| Argentina Phone: 54 11 4707-0070
| Fax: 54 11 4707-0070
| Email: (e-mail address removed)
| URL: http://www.bytetech.com.ar/
| 7. Close Up Internacional S.A.
| Luis María Campos 42
| C1425GEN Buenos Aires
| Argentina Phone: 54 11 4771-3800
| Fax: 54 11 4774-2167
|
| 8. DCL S.A.
| Moreno 584, piso 11, of. A
| C1091AAL Capital Federal
| Argentina Phone: 54-11-5219-0591
| URL: http://ww.dcl.com.ar/
| 9. DMR Consulting
| Della Paolera 265, piso 20
| C1001ADA Capital Federal
| Argentina Phone: 54-11-5776-1700
| 12. Paradigma Consultores Asociados
| Reconquista 1166, p. 9
| C1003ABX Capital Federal
| Argentina Phone: 54 11 4312-6888
| Fax: 54 11 4313-6814
| URL: http://www.paradigma.com/
| 14. Sema Argentina S.A.
| Av. Pte. Roque Saenz Peña 1149, p.1
| C1035AAG Buenos Aires
| Argentina Phone: 54-11-4315-8811
| Fax: 54-11-6315-8834
|
|
| 16. Soluziona S.A.
| Av. Leandro N. Alem 896 , piso 10°
| C1001AAQ Capital Federal
| Argentina Phone: 54-11-4891-1600
| Fax: 54-11-4891-1601
| URL: http://www.soluziona.com.ar/
| 17. Sun Microsystems Argentina S.A
| Bouchard 547, Piso 26
| 1106 Buenos Aires
| Argentina URL: http://www.sun.com.ar/
| 18. Tecosoft Argentina S.A.
| Av. del Libertador 6550 8º Piso
| C1428ARV Buenos Aires
| Argentina Phone: 11-4706-0060
| Fax: 11-4706-0813
| URL: http://www.tecosoft.com.ar/

Click to expand...

Jos · Nov 14, 2003

Hi Sue,

The data IS in standardformat; see the example below. It is even possible to
get all the fields of the records in separate lines. The point is that they
should be in columns, because you have to add headers. And the second point
is that sometimes a field has the value "empty".

Without a standardized format, about the only way to convert this data is to
massage it by hand or write code to try to parse it. Not an easy task in
either case. If both the data and your time are value, you may want to
consider paying for outside help.
--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers

After searching google.groups.com and finding no answer
Jos <Reply in newsgroup please> asked:

| Hi all,
|
| I need to import literally 3000 contacts into Outlook. Unfortunately,
| the list (in plain text) looks like the list on the bottom of my
| message (small example). I'm faced So, clearly, the data is not in a
| databaserecordformat (with fields from the left to the right). Thus,
| I can not assign headers to it (in Outlook), and thus I can not map
| the fields during the import into Outlook. I know I can use
| "transpose" in Excel to change rows into columns, but this still
| requires a lot of manual work: I have to select each block,
| Edit/Copy, Edit/Paste Special/Transpose. With 3000 contacts I'm not
| happy to do so, since it may cause the RSI-problems very easily. So,
| could anybody recommend a solution to my problem? I would really,
| really, really appreciate this (!).
|
| Thanks a lot,
|
| Kind regards,
|
| Jos
|
|
|
|
| [Example of the list]
| 3. Application Software S.A.
| Elvira Rawson de Dellepiane 150, P6
| 1107 Buenos Aires
| Argentina Phone: 11 4510-7300
| URL: http://www.grupoassa.com/
| 6. Byte Tech Argentina S.A.
| Av. Libertador 15090
| B1641ANT Acasusso
| Argentina Phone: 54 11 4707-0070
| Fax: 54 11 4707-0070
| Email: (e-mail address removed)
| URL: http://www.bytetech.com.ar/
| 7. Close Up Internacional S.A.
| Luis María Campos 42
| C1425GEN Buenos Aires
| Argentina Phone: 54 11 4771-3800
| Fax: 54 11 4774-2167
|
| 8. DCL S.A.
| Moreno 584, piso 11, of. A
| C1091AAL Capital Federal
| Argentina Phone: 54-11-5219-0591
| URL: http://ww.dcl.com.ar/
| 9. DMR Consulting
| Della Paolera 265, piso 20
| C1001ADA Capital Federal
| Argentina Phone: 54-11-5776-1700
| 12. Paradigma Consultores Asociados
| Reconquista 1166, p. 9
| C1003ABX Capital Federal
| Argentina Phone: 54 11 4312-6888
| Fax: 54 11 4313-6814
| URL: http://www.paradigma.com/
| 14. Sema Argentina S.A.
| Av. Pte. Roque Saenz Peña 1149, p.1
| C1035AAG Buenos Aires
| Argentina Phone: 54-11-4315-8811
| Fax: 54-11-6315-8834
|
|
| 16. Soluziona S.A.
| Av. Leandro N. Alem 896 , piso 10°
| C1001AAQ Capital Federal
| Argentina Phone: 54-11-4891-1600
| Fax: 54-11-4891-1601
| URL: http://www.soluziona.com.ar/
| 17. Sun Microsystems Argentina S.A
| Bouchard 547, Piso 26
| 1106 Buenos Aires
| Argentina URL: http://www.sun.com.ar/
| 18. Tecosoft Argentina S.A.
| Av. del Libertador 6550 8º Piso
| C1428ARV Buenos Aires
| Argentina Phone: 11-4706-0060
| Fax: 11-4706-0813
| URL: http://www.tecosoft.com.ar/

Click to expand...

Jos · Nov 14, 2003

Hi Clinton,

I would, if I am in business. I need the data to perform a survey for my
thesis: it's scientific use only. I need to import the data in Outlook in
order to be able to send these about 3000 companies a survey via email. So,
as is allways the case with scientific research: the money :-(.

clintonG said:
I've scripted solutions for merchants needing to reformat and transfer
contact information back and forth between their desktop database and
their shopping cart database. If you're in business hiring somebody to
script a solution may be your most effective choice...

--
<%= Clinton Gallagher
A/E/C Consulting, Web Design, e-Commerce Software Development
Wauwatosa, Milwaukee County, Wisconsin USA
NET (e-mail address removed)
URL http://www.metromilwaukee.com/clintongallagher/

Jos said:

Hi all,

I need to import literally 3000 contacts into Outlook. Unfortunately, the
list (in plain text) looks like the list on the bottom of my message (small
example). I'm faced So, clearly, the data is not in a databaserecordformat
(with fields from the left to the right). Thus, I can not assign headers to
it (in Outlook), and thus I can not map the fields during the import into
Outlook. I know I can use "transpose" in Excel to change rows into columns,
but this still requires a lot of manual work: I have to select each block,
Edit/Copy, Edit/Paste Special/Transpose. With 3000 contacts I'm not

Click to expand...

happy

to
do so, since it may cause the RSI-problems very easily. So, could anybody
recommend a solution to my problem? I would really, really, really
appreciate this (!).

Thanks a lot,

Kind regards,

Jos

[Example of the list]
3. Application Software S.A.
Elvira Rawson de Dellepiane 150, P6
1107 Buenos Aires
Argentina Phone: 11 4510-7300
URL: http://www.grupoassa.com/
6. Byte Tech Argentina S.A.
Av. Libertador 15090
B1641ANT Acasusso
Argentina Phone: 54 11 4707-0070
Fax: 54 11 4707-0070
Email: (e-mail address removed)
URL: http://www.bytetech.com.ar/
7. Close Up Internacional S.A.
Luis María Campos 42
C1425GEN Buenos Aires
Argentina Phone: 54 11 4771-3800
Fax: 54 11 4774-2167

8. DCL S.A.
Moreno 584, piso 11, of. A
C1091AAL Capital Federal
Argentina Phone: 54-11-5219-0591
URL: http://ww.dcl.com.ar/
9. DMR Consulting
Della Paolera 265, piso 20
C1001ADA Capital Federal
Argentina Phone: 54-11-5776-1700
12. Paradigma Consultores Asociados
Reconquista 1166, p. 9
C1003ABX Capital Federal
Argentina Phone: 54 11 4312-6888
Fax: 54 11 4313-6814
URL: http://www.paradigma.com/
14. Sema Argentina S.A.
Av. Pte. Roque Saenz Peña 1149, p.1
C1035AAG Buenos Aires
Argentina Phone: 54-11-4315-8811
Fax: 54-11-6315-8834

16. Soluziona S.A.
Av. Leandro N. Alem 896 , piso 10°
C1001AAQ Capital Federal
Argentina Phone: 54-11-4891-1600
Fax: 54-11-4891-1601
URL: http://www.soluziona.com.ar/
17. Sun Microsystems Argentina S.A
Bouchard 547, Piso 26
1106 Buenos Aires
Argentina URL: http://www.sun.com.ar/
18. Tecosoft Argentina S.A.
Av. del Libertador 6550 8º Piso
C1428ARV Buenos Aires
Argentina Phone: 11-4706-0060
Fax: 11-4706-0813
URL: http://www.tecosoft.com.ar/

Click to expand...

Sue Mosher [MVP] · Nov 14, 2003

Instead of "standard" format, I should have said "rigidly structured." Because some "fields" are multiple lines and some are empty, it's not possible to consider it rigidly structured.

As I said, your items below probably *could* be parsed programmatically, but it will take some work and a fair amount of testing.
--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers

Jos said:
Hi Sue,

The data IS in standardformat; see the example below. It is even possible to
get all the fields of the records in separate lines. The point is that they
should be in columns, because you have to add headers. And the second point
is that sometimes a field has the value "empty".

Without a standardized format, about the only way to convert this data is to
massage it by hand or write code to try to parse it. Not an easy task in
either case. If both the data and your time are value, you may want to
consider paying for outside help.
--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers

After searching google.groups.com and finding no answer
Jos <Reply in newsgroup please> asked:

| Hi all,
|
| I need to import literally 3000 contacts into Outlook. Unfortunately,
| the list (in plain text) looks like the list on the bottom of my
| message (small example). I'm faced So, clearly, the data is not in a
| databaserecordformat (with fields from the left to the right). Thus,
| I can not assign headers to it (in Outlook), and thus I can not map
| the fields during the import into Outlook. I know I can use
| "transpose" in Excel to change rows into columns, but this still
| requires a lot of manual work: I have to select each block,
| Edit/Copy, Edit/Paste Special/Transpose. With 3000 contacts I'm not
| happy to do so, since it may cause the RSI-problems very easily. So,
| could anybody recommend a solution to my problem? I would really,
| really, really appreciate this (!).
|
| Thanks a lot,
|
| Kind regards,
|
| Jos
|
|
|
|
| [Example of the list]
| 3. Application Software S.A.
| Elvira Rawson de Dellepiane 150, P6
| 1107 Buenos Aires
| Argentina Phone: 11 4510-7300
| URL: http://www.grupoassa.com/
| 6. Byte Tech Argentina S.A.
| Av. Libertador 15090
| B1641ANT Acasusso
| Argentina Phone: 54 11 4707-0070
| Fax: 54 11 4707-0070
| Email: (e-mail address removed)
| URL: http://www.bytetech.com.ar/
| 7. Close Up Internacional S.A.
| Luis María Campos 42
| C1425GEN Buenos Aires
| Argentina Phone: 54 11 4771-3800
| Fax: 54 11 4774-2167
|
| 8. DCL S.A.
| Moreno 584, piso 11, of. A
| C1091AAL Capital Federal
| Argentina Phone: 54-11-5219-0591
| URL: http://ww.dcl.com.ar/
| 9. DMR Consulting
| Della Paolera 265, piso 20
| C1001ADA Capital Federal
| Argentina Phone: 54-11-5776-1700
| 12. Paradigma Consultores Asociados
| Reconquista 1166, p. 9
| C1003ABX Capital Federal
| Argentina Phone: 54 11 4312-6888
| Fax: 54 11 4313-6814
| URL: http://www.paradigma.com/
| 14. Sema Argentina S.A.
| Av. Pte. Roque Saenz Peña 1149, p.1
| C1035AAG Buenos Aires
| Argentina Phone: 54-11-4315-8811
| Fax: 54-11-6315-8834
|
|
| 16. Soluziona S.A.
| Av. Leandro N. Alem 896 , piso 10°
| C1001AAQ Capital Federal
| Argentina Phone: 54-11-4891-1600
| Fax: 54-11-4891-1601
| URL: http://www.soluziona.com.ar/
| 17. Sun Microsystems Argentina S.A
| Bouchard 547, Piso 26
| 1106 Buenos Aires
| Argentina URL: http://www.sun.com.ar/
| 18. Tecosoft Argentina S.A.
| Av. del Libertador 6550 8º Piso
| C1428ARV Buenos Aires
| Argentina Phone: 11-4706-0060
| Fax: 11-4706-0813
| URL: http://www.tecosoft.com.ar/

Click to expand...

Click to expand...

Jos · Nov 14, 2003

Where do you see multiple line fields? I don't.

"Sue Mosher [MVP]" <[email protected]> schreef in bericht
Instead of "standard" format, I should have said "rigidly structured."
Because some "fields" are multiple lines and some are empty, it's not
possible to consider it rigidly structured.

As I said, your items below probably *could* be parsed programmatically, but
it will take some work and a fair amount of testing.
--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers

Jos said:
Hi Sue,

The data IS in standardformat; see the example below. It is even possible to
get all the fields of the records in separate lines. The point is that they
should be in columns, because you have to add headers. And the second point
is that sometimes a field has the value "empty".

Without a standardized format, about the only way to convert this data is to
massage it by hand or write code to try to parse it. Not an easy task in
either case. If both the data and your time are value, you may want to
consider paying for outside help.
--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers

After searching google.groups.com and finding no answer
Jos <Reply in newsgroup please> asked:

| Hi all,
|
| I need to import literally 3000 contacts into Outlook. Unfortunately,
| the list (in plain text) looks like the list on the bottom of my
| message (small example). I'm faced So, clearly, the data is not in a
| databaserecordformat (with fields from the left to the right). Thus,
| I can not assign headers to it (in Outlook), and thus I can not map
| the fields during the import into Outlook. I know I can use
| "transpose" in Excel to change rows into columns, but this still
| requires a lot of manual work: I have to select each block,
| Edit/Copy, Edit/Paste Special/Transpose. With 3000 contacts I'm not
| happy to do so, since it may cause the RSI-problems very easily. So,
| could anybody recommend a solution to my problem? I would really,
| really, really appreciate this (!).
|
| Thanks a lot,
|
| Kind regards,
|
| Jos
|
|
|
|
| [Example of the list]
| 3. Application Software S.A.
| Elvira Rawson de Dellepiane 150, P6
| 1107 Buenos Aires
| Argentina Phone: 11 4510-7300
| URL: http://www.grupoassa.com/
| 6. Byte Tech Argentina S.A.
| Av. Libertador 15090
| B1641ANT Acasusso
| Argentina Phone: 54 11 4707-0070
| Fax: 54 11 4707-0070
| Email: (e-mail address removed)
| URL: http://www.bytetech.com.ar/
| 7. Close Up Internacional S.A.
| Luis María Campos 42
| C1425GEN Buenos Aires
| Argentina Phone: 54 11 4771-3800
| Fax: 54 11 4774-2167
|
| 8. DCL S.A.
| Moreno 584, piso 11, of. A
| C1091AAL Capital Federal
| Argentina Phone: 54-11-5219-0591
| URL: http://ww.dcl.com.ar/
| 9. DMR Consulting
| Della Paolera 265, piso 20
| C1001ADA Capital Federal
| Argentina Phone: 54-11-5776-1700
| 12. Paradigma Consultores Asociados
| Reconquista 1166, p. 9
| C1003ABX Capital Federal
| Argentina Phone: 54 11 4312-6888
| Fax: 54 11 4313-6814
| URL: http://www.paradigma.com/
| 14. Sema Argentina S.A.
| Av. Pte. Roque Saenz Peña 1149, p.1
| C1035AAG Buenos Aires
| Argentina Phone: 54-11-4315-8811
| Fax: 54-11-6315-8834
|
|
| 16. Soluziona S.A.
| Av. Leandro N. Alem 896 , piso 10°
| C1001AAQ Capital Federal
| Argentina Phone: 54-11-4891-1600
| Fax: 54-11-4891-1601
| URL: http://www.soluziona.com.ar/
| 17. Sun Microsystems Argentina S.A
| Bouchard 547, Piso 26
| 1106 Buenos Aires
| Argentina URL: http://www.sun.com.ar/
| 18. Tecosoft Argentina S.A.
| Av. del Libertador 6550 8º Piso
| C1428ARV Buenos Aires
| Argentina Phone: 11-4706-0060
| Fax: 11-4706-0813
| URL: http://www.tecosoft.com.ar/

Click to expand...

Click to expand...

Sue Mosher [MVP] · Nov 14, 2003

Maybe I misread. I know nothing about Argentinian address formats. Have you considered adding blank lines to fill in for empty fields, then use Word to convert it to a table with the right number of columns?
--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers

Jos said:
Where do you see multiple line fields? I don't.

"Sue Mosher [MVP]" <[email protected]> schreef in bericht
Instead of "standard" format, I should have said "rigidly structured."
Because some "fields" are multiple lines and some are empty, it's not
possible to consider it rigidly structured.

As I said, your items below probably *could* be parsed programmatically, but
it will take some work and a fair amount of testing.

Jos said:

Hi Sue,

The data IS in standardformat; see the example below. It is even possible to
get all the fields of the records in separate lines. The point is that they
should be in columns, because you have to add headers. And the second point
is that sometimes a field has the value "empty".

Without a standardized format, about the only way to convert this data is to
massage it by hand or write code to try to parse it. Not an easy task in
either case. If both the data and your time are value, you may want to
consider paying for outside help.
--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers

After searching google.groups.com and finding no answer
Jos <Reply in newsgroup please> asked:

| Hi all,
|
| I need to import literally 3000 contacts into Outlook. Unfortunately,
| the list (in plain text) looks like the list on the bottom of my
| message (small example). I'm faced So, clearly, the data is not in a
| databaserecordformat (with fields from the left to the right). Thus,
| I can not assign headers to it (in Outlook), and thus I can not map
| the fields during the import into Outlook. I know I can use
| "transpose" in Excel to change rows into columns, but this still
| requires a lot of manual work: I have to select each block,
| Edit/Copy, Edit/Paste Special/Transpose. With 3000 contacts I'm not
| happy to do so, since it may cause the RSI-problems very easily. So,
| could anybody recommend a solution to my problem? I would really,
| really, really appreciate this (!).
|
| Thanks a lot,
|
| Kind regards,
|
| Jos
|
|
|
|
| [Example of the list]
| 3. Application Software S.A.
| Elvira Rawson de Dellepiane 150, P6
| 1107 Buenos Aires
| Argentina Phone: 11 4510-7300
| URL: http://www.grupoassa.com/
| 6. Byte Tech Argentina S.A.
| Av. Libertador 15090
| B1641ANT Acasusso
| Argentina Phone: 54 11 4707-0070
| Fax: 54 11 4707-0070
| Email: (e-mail address removed)
| URL: http://www.bytetech.com.ar/
| 7. Close Up Internacional S.A.
| Luis María Campos 42
| C1425GEN Buenos Aires
| Argentina Phone: 54 11 4771-3800
| Fax: 54 11 4774-2167
|
| 8. DCL S.A.
| Moreno 584, piso 11, of. A
| C1091AAL Capital Federal
| Argentina Phone: 54-11-5219-0591
| URL: http://ww.dcl.com.ar/
| 9. DMR Consulting
| Della Paolera 265, piso 20
| C1001ADA Capital Federal
| Argentina Phone: 54-11-5776-1700
| 12. Paradigma Consultores Asociados
| Reconquista 1166, p. 9
| C1003ABX Capital Federal
| Argentina Phone: 54 11 4312-6888
| Fax: 54 11 4313-6814
| URL: http://www.paradigma.com/
| 14. Sema Argentina S.A.
| Av. Pte. Roque Saenz Peña 1149, p.1
| C1035AAG Buenos Aires
| Argentina Phone: 54-11-4315-8811
| Fax: 54-11-6315-8834
|
|
| 16. Soluziona S.A.
| Av. Leandro N. Alem 896 , piso 10°
| C1001AAQ Capital Federal
| Argentina Phone: 54-11-4891-1600
| Fax: 54-11-4891-1601
| URL: http://www.soluziona.com.ar/
| 17. Sun Microsystems Argentina S.A
| Bouchard 547, Piso 26
| 1106 Buenos Aires
| Argentina URL: http://www.sun.com.ar/
| 18. Tecosoft Argentina S.A.
| Av. del Libertador 6550 8º Piso
| C1428ARV Buenos Aires
| Argentina Phone: 11-4706-0060
| Fax: 11-4706-0813
| URL: http://www.tecosoft.com.ar/

Click to expand...

Click to expand...

Jos · Nov 16, 2003

Yes, I did. But MS Word does not seem to convert it into the right number of
columns.

"Sue Mosher [MVP]" <[email protected]> schreef in bericht
Maybe I misread. I know nothing about Argentinian address formats. Have you
considered adding blank lines to fill in for empty fields, then use Word to
convert it to a table with the right number of columns?
--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers

Jos said:
Where do you see multiple line fields? I don't.

"Sue Mosher [MVP]" <[email protected]> schreef in bericht
Instead of "standard" format, I should have said "rigidly structured."
Because some "fields" are multiple lines and some are empty, it's not
possible to consider it rigidly structured.

As I said, your items below probably *could* be parsed programmatically, but
it will take some work and a fair amount of testing.

Jos said:

Hi Sue,

The data IS in standardformat; see the example below. It is even

Click to expand...

possible

to
get all the fields of the records in separate lines. The point is that they
should be in columns, because you have to add headers. And the second point
is that sometimes a field has the value "empty".

Without a standardized format, about the only way to convert this data

Click to expand...

is

to
massage it by hand or write code to try to parse it. Not an easy task in
either case. If both the data and your time are value, you may want to
consider paying for outside help.
--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers

After searching google.groups.com and finding no answer
Jos <Reply in newsgroup please> asked:

| Hi all,
|
| I need to import literally 3000 contacts into Outlook. Unfortunately,
| the list (in plain text) looks like the list on the bottom of my
| message (small example). I'm faced So, clearly, the data is not in a
| databaserecordformat (with fields from the left to the right). Thus,
| I can not assign headers to it (in Outlook), and thus I can not map
| the fields during the import into Outlook. I know I can use
| "transpose" in Excel to change rows into columns, but this still
| requires a lot of manual work: I have to select each block,
| Edit/Copy, Edit/Paste Special/Transpose. With 3000 contacts I'm not
| happy to do so, since it may cause the RSI-problems very easily. So,
| could anybody recommend a solution to my problem? I would really,
| really, really appreciate this (!).
|
| Thanks a lot,
|
| Kind regards,
|
| Jos
|
|
|
|
| [Example of the list]
| 3. Application Software S.A.
| Elvira Rawson de Dellepiane 150, P6
| 1107 Buenos Aires
| Argentina Phone: 11 4510-7300
| URL: http://www.grupoassa.com/
| 6. Byte Tech Argentina S.A.
| Av. Libertador 15090
| B1641ANT Acasusso
| Argentina Phone: 54 11 4707-0070
| Fax: 54 11 4707-0070
| Email: (e-mail address removed)
| URL: http://www.bytetech.com.ar/
| 7. Close Up Internacional S.A.
| Luis María Campos 42
| C1425GEN Buenos Aires
| Argentina Phone: 54 11 4771-3800
| Fax: 54 11 4774-2167
|
| 8. DCL S.A.
| Moreno 584, piso 11, of. A
| C1091AAL Capital Federal
| Argentina Phone: 54-11-5219-0591
| URL: http://ww.dcl.com.ar/
| 9. DMR Consulting
| Della Paolera 265, piso 20
| C1001ADA Capital Federal
| Argentina Phone: 54-11-5776-1700
| 12. Paradigma Consultores Asociados
| Reconquista 1166, p. 9
| C1003ABX Capital Federal
| Argentina Phone: 54 11 4312-6888
| Fax: 54 11 4313-6814
| URL: http://www.paradigma.com/
| 14. Sema Argentina S.A.
| Av. Pte. Roque Saenz Peña 1149, p.1
| C1035AAG Buenos Aires
| Argentina Phone: 54-11-4315-8811
| Fax: 54-11-6315-8834
|
|
| 16. Soluziona S.A.
| Av. Leandro N. Alem 896 , piso 10°
| C1001AAQ Capital Federal
| Argentina Phone: 54-11-4891-1600
| Fax: 54-11-4891-1601
| URL: http://www.soluziona.com.ar/
| 17. Sun Microsystems Argentina S.A
| Bouchard 547, Piso 26
| 1106 Buenos Aires
| Argentina URL: http://www.sun.com.ar/
| 18. Tecosoft Argentina S.A.
| Av. del Libertador 6550 8º Piso
| C1428ARV Buenos Aires
| Argentina Phone: 11-4706-0060
| Fax: 11-4706-0813
| URL: http://www.tecosoft.com.ar/

Click to expand...

Click to expand...

Sue Mosher [MVP] · Nov 17, 2003

The Convert Text to Table command should let you set the number of columns you want. You will, of course, need to have the same number of paragraphs for each record.
--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers

Jos said:
Yes, I did. But MS Word does not seem to convert it into the right number of
columns.

"Sue Mosher [MVP]" <[email protected]> schreef in bericht
Maybe I misread. I know nothing about Argentinian address formats. Have you
considered adding blank lines to fill in for empty fields, then use Word to
convert it to a table with the right number of columns?

Jos said:

Where do you see multiple line fields? I don't.

"Sue Mosher [MVP]" <[email protected]> schreef in bericht
Instead of "standard" format, I should have said "rigidly structured."
Because some "fields" are multiple lines and some are empty, it's not
possible to consider it rigidly structured.

As I said, your items below probably *could* be parsed programmatically, but
it will take some work and a fair amount of testing.

Jos said:

Hi Sue,

The data IS in standardformat; see the example below. It is even

Click to expand...

possible

to
get all the fields of the records in separate lines. The point is that they
should be in columns, because you have to add headers. And the second point
is that sometimes a field has the value "empty".

Without a standardized format, about the only way to convert this data

Click to expand...

is

to
massage it by hand or write code to try to parse it. Not an easy task in
either case. If both the data and your time are value, you may want to
consider paying for outside help.
--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers

After searching google.groups.com and finding no answer
Jos <Reply in newsgroup please> asked:

| Hi all,
|
| I need to import literally 3000 contacts into Outlook. Unfortunately,
| the list (in plain text) looks like the list on the bottom of my
| message (small example). I'm faced So, clearly, the data is not in a
| databaserecordformat (with fields from the left to the right). Thus,
| I can not assign headers to it (in Outlook), and thus I can not map
| the fields during the import into Outlook. I know I can use
| "transpose" in Excel to change rows into columns, but this still
| requires a lot of manual work: I have to select each block,
| Edit/Copy, Edit/Paste Special/Transpose. With 3000 contacts I'm not
| happy to do so, since it may cause the RSI-problems very easily. So,
| could anybody recommend a solution to my problem? I would really,
| really, really appreciate this (!).
|
| Thanks a lot,
|
| Kind regards,
|
| Jos
|
|
|
|
| [Example of the list]
| 3. Application Software S.A.
| Elvira Rawson de Dellepiane 150, P6
| 1107 Buenos Aires
| Argentina Phone: 11 4510-7300
| URL: http://www.grupoassa.com/
| 6. Byte Tech Argentina S.A.
| Av. Libertador 15090
| B1641ANT Acasusso
| Argentina Phone: 54 11 4707-0070
| Fax: 54 11 4707-0070
| Email: (e-mail address removed)
| URL: http://www.bytetech.com.ar/
| 7. Close Up Internacional S.A.
| Luis María Campos 42
| C1425GEN Buenos Aires
| Argentina Phone: 54 11 4771-3800
| Fax: 54 11 4774-2167
|
| 8. DCL S.A.
| Moreno 584, piso 11, of. A
| C1091AAL Capital Federal
| Argentina Phone: 54-11-5219-0591
| URL: http://ww.dcl.com.ar/
| 9. DMR Consulting
| Della Paolera 265, piso 20
| C1001ADA Capital Federal
| Argentina Phone: 54-11-5776-1700
| 12. Paradigma Consultores Asociados
| Reconquista 1166, p. 9
| C1003ABX Capital Federal
| Argentina Phone: 54 11 4312-6888
| Fax: 54 11 4313-6814
| URL: http://www.paradigma.com/
| 14. Sema Argentina S.A.
| Av. Pte. Roque Saenz Peña 1149, p.1
| C1035AAG Buenos Aires
| Argentina Phone: 54-11-4315-8811
| Fax: 54-11-6315-8834
|
|
| 16. Soluziona S.A.
| Av. Leandro N. Alem 896 , piso 10°
| C1001AAQ Capital Federal
| Argentina Phone: 54-11-4891-1600
| Fax: 54-11-4891-1601
| URL: http://www.soluziona.com.ar/
| 17. Sun Microsystems Argentina S.A
| Bouchard 547, Piso 26
| 1106 Buenos Aires
| Argentina URL: http://www.sun.com.ar/
| 18. Tecosoft Argentina S.A.
| Av. del Libertador 6550 8º Piso
| C1428ARV Buenos Aires
| Argentina Phone: 11-4706-0060
| Fax: 11-4706-0813
| URL: http://www.tecosoft.com.ar/

Click to expand...

Click to expand...