Importing to listserv
Importing to listserv
Is there any way to import names into a list? I have over 200 addresses and I don't look forward to inputting them all.
-
- Posts: 15
- Joined: Thu Aug 15, 2002 1:12 am
use excel
hi,
I have pasted below earlier postings inthis forum.
hope this helps
to bulk load a list of users first create a list with a few names in it...
then browse through the directorys and you will find a text file
that has the list of names in it...
use excel and create your list and then export it to txt file.
i did like 600 names in 3 minutes...
--------------------------------------------------------------------------------
The lists and group files (the ones that contain the email addresses), are in the same format, with each line like:
[SMTP:emailaddress]
You can bulk load into the group using the administration program, but this hasn't been added into the list server component yet. You could add all the emails to a group and copy the group file to the list directory (and rename to the list name). The group file is found in the config directory
Mail Enable\Config\Postoffices\postofficename\Groups and lists is found in
Mail Enable\Config\Postoffices\postofficename\Lists
You must add lists and groups first via the admin, or they will not be recognised. Then you can add emails to the file.
Using Excel is the fastest way, due to the provider DLLs that handle the text files being a lot slower for adding large lists.
I have pasted below earlier postings inthis forum.
hope this helps
to bulk load a list of users first create a list with a few names in it...
then browse through the directorys and you will find a text file
that has the list of names in it...
use excel and create your list and then export it to txt file.
i did like 600 names in 3 minutes...
--------------------------------------------------------------------------------
The lists and group files (the ones that contain the email addresses), are in the same format, with each line like:
[SMTP:emailaddress]
You can bulk load into the group using the administration program, but this hasn't been added into the list server component yet. You could add all the emails to a group and copy the group file to the list directory (and rename to the list name). The group file is found in the config directory
Mail Enable\Config\Postoffices\postofficename\Groups and lists is found in
Mail Enable\Config\Postoffices\postofficename\Lists
You must add lists and groups first via the admin, or they will not be recognised. Then you can add emails to the file.
Using Excel is the fastest way, due to the provider DLLs that handle the text files being a lot slower for adding large lists.
venkata subramanian
-
- Posts: 15
- Joined: Thu Aug 15, 2002 1:12 am
use excel
hi,
I have pasted below earlier postings inthis forum.
hope this helps
to bulk load a list of users first create a list with a few names in it...
then browse through the directorys and you will find a text file
that has the list of names in it...
use excel and create your list and then export it to txt file.
i did like 600 names in 3 minutes...
--------------------------------------------------------------------------------
The lists and group files (the ones that contain the email addresses), are in the same format, with each line like:
[SMTP:emailaddress]
You can bulk load into the group using the administration program, but this hasn't been added into the list server component yet. You could add all the emails to a group and copy the group file to the list directory (and rename to the list name). The group file is found in the config directory
Mail Enable\Config\Postoffices\postofficename\Groups and lists is found in
Mail Enable\Config\Postoffices\postofficename\Lists
You must add lists and groups first via the admin, or they will not be recognised. Then you can add emails to the file.
Using Excel is the fastest way, due to the provider DLLs that handle the text files being a lot slower for adding large lists.
I have pasted below earlier postings inthis forum.
hope this helps
to bulk load a list of users first create a list with a few names in it...
then browse through the directorys and you will find a text file
that has the list of names in it...
use excel and create your list and then export it to txt file.
i did like 600 names in 3 minutes...
--------------------------------------------------------------------------------
The lists and group files (the ones that contain the email addresses), are in the same format, with each line like:
[SMTP:emailaddress]
You can bulk load into the group using the administration program, but this hasn't been added into the list server component yet. You could add all the emails to a group and copy the group file to the list directory (and rename to the list name). The group file is found in the config directory
Mail Enable\Config\Postoffices\postofficename\Groups and lists is found in
Mail Enable\Config\Postoffices\postofficename\Lists
You must add lists and groups first via the admin, or they will not be recognised. Then you can add emails to the file.
Using Excel is the fastest way, due to the provider DLLs that handle the text files being a lot slower for adding large lists.
venkata subramanian
-
- Site Admin
- Posts: 4441
- Joined: Tue Jun 25, 2002 3:03 am
- Location: Melbourne, Victoria Australia
As railwayvenkat says, the list content files are located in the following directory:
Mail Enable\Config\Postoffices\postofficename\Lists
Each file in this directory will have the name {ListName}.TAB.
This file contains the list members (in ME's internal address formating) ie:
[CONNECTOR:Address] . Each list member is delimited by a new line.
(Note: ensure the last line does not contain a CRLF at the end of it though).
Mail Enable\Config\Postoffices\postofficename\Lists
Each file in this directory will have the name {ListName}.TAB.
This file contains the list members (in ME's internal address formating) ie:
[CONNECTOR:Address] . Each list member is delimited by a new line.
(Note: ensure the last line does not contain a CRLF at the end of it though).
Regards, Andrew
TAB File import from external server
Thanks for this last line - I was having trouble - I have a client who creates the TAB files and FTPs them to our mail server... we pick them up and dump them in the appropriate directory... our lists haven't been working since they started this... we are going to try the remove of the CRLF on the last line (we can see they are inlcuding this)... however does anyone else do this and is there anything else we should watch for?support wrote:As railwayvenkat says, the list content files are located in the following directory:
Mail Enable\Config\Postoffices\postofficename\Lists
Each file in this directory will have the name {ListName}.TAB.
This file contains the list members (in ME's internal address formating) ie:
[CONNECTOR:Address] . Each list member is delimited by a new line.
(Note: ensure the last line does not contain a CRLF at the end of it though).
OzLady
*******
Remember amateurs built the ark - Professionals built the Titanic
*******
Remember amateurs built the ark - Professionals built the Titanic
TAB File import from external server
Just to polish off the conclusion from my previous post...
my client puts together TAB files on his web server based on a database that he has... it's a security policy between our organisations that we do it this way. At any rate... he runs the following:
When this file was then saved to the appropriate directory in mailenable, the list ceased to work. By testing for the last line in the recordset, and using write instead of writeline, this problem ceased to exist and the list now works. Probably obvious for a lot of people, however I am posting code just in case it is useful, as loads of times I haven't had time to fiddle and the posting of code has helped me.
Thanks.
my client puts together TAB files on his web server based on a database that he has... it's a security policy between our organisations that we do it this way. At any rate... he runs the following:
- so the file is created and we ftp all files from a directory on their web server that we have been given access to. Our client was using writeline for all text file writes, resulting in a blank crlf at the end of the file.strName = "d:\directory\someotherdirectory\lists\filename.tab"
set filetxt = filesys.CreateTextFile(strName, True)
path = filesys.GetAbsolutePathName(strName)
getname = filesys.GetFileName(path)
' after having created a database connection and calling the recordset...
while not rsreg.eof
strTemp = RSReg("email")
rsreg.movenext
if RSreg.eof then
filetxt.Write("[SMTP:" & strTemp & "]")
else
filetxt.WriteLine("[SMTP:" & strTemp & "]")
end if
wend
filetxt.Close
set filetxt=nothing
When this file was then saved to the appropriate directory in mailenable, the list ceased to work. By testing for the last line in the recordset, and using write instead of writeline, this problem ceased to exist and the list now works. Probably obvious for a lot of people, however I am posting code just in case it is useful, as loads of times I haven't had time to fiddle and the posting of code has helped me.
Thanks.
OzLady
*******
Remember amateurs built the ark - Professionals built the Titanic
*******
Remember amateurs built the ark - Professionals built the Titanic