csv Address Conversion

This page will convert from a number of formats to a tab-ascii/csv file. The tab-ascii input format can be used as a way of generating aliases.

Instructions

Note: Read all instructions before doing anything.

Tab delinieated ascii or csv

The input file is a tab or comma separated ascii file, which can be produced by a spreadsheet, database, and perhaps some mail programs. It contains a number of columns. Only the first is necessary. all other columns are optional, but must be there, even if empty, if a column to the right is being used.

Spry

Spry users, ignore all the instructions below, just point the Browse button to the "spry.als" file in the Spry directory and start the process.

Juno

Juno users. Use your ".nv" file as input.

Unix mail/.mailrc

.mailrc conversions. If you know what.mailrc is, you don't neet detailed instructions. Just be sure to ftp the file as ascii.

Compuserve

Compuserve recently made available a download address book add-on that enables the user to do a number of things with their address book files, including EXPORT them. Use GO:UKHF and look in the essentials for Win 3.1 file library for ABM_INST.exe . When the export option is chosen, the resulting dialogue box allows you to chose different delimiting options, including any keyboard characters or tabs. Use the tab option, and then use a spreadsheet to re-arrange the columns To help Compuserve users, addresses in the Compuserve format are converted to the correct Internet format.

Tab ascii examples

Two Examples:

Using only column 1
nobody@nobody.com
Using Columns 1 and 4
nobody@nobody.com<tab><tab>jhd

The columns are described below. Only the first one is mandatory.

E-mail address.
Name 1 Usually first name or full name.
Name 2 Usually last name or leave blank
Alias A unique alias, if it is not unique, it will be made unique. If it is left blank, a unique alias will be produced from the name portion of the e-mail address (the part to the left of the "@" sign).
Comment

In the following columns, as many as needed, put the names of any mailing lists (address list, distribution lists, etc.) that you want this address to be included in.

You can look at a sample input file to clarify the above instructions.

A note on mailing lists: Mailing lists can contain other lists. For example the list "extended family" may contain the lists "parents", "grandparents", "siblings", "aunts/uncles", etc. This input does not give you the opportunity to do this, you will have to do it after importing into Pine. You will automatically get a list with the alias "everybody" which has in it (as you guessed) everybody on the file.

Using the Browse button below, select the tab-separated ascii file you have produced.

Using the Browse button below, select this file
Using the File Menu: Save As save the ouput file on some convenient place on your disk.

Technical Notes

To avoid overburdening the server, we have limited the file to 120k bytes and 1200 lines

InterGuru Home Page

How to Contact InterGuru

Telephone: 301-593-4152

Fax: 301-593-2541

E-Mail: jhd at interguru.com ( change the ' at ' to '@' before sending )

Postal Mail: 1501 Dublin Drive, Silver Spring, MD 20902