ListMailPRO Email Marketing Software Forums

ListMailPRO Email Marketing Software Forums => General Help & How-To => Topic started by: james2 on October 25, 2004, 10:06:35 am

Title: importing custom field information ??
Post by: james2 on October 25, 2004, 10:06:35 am

I would like to import/insert data into one of the custom fields depending upon the domain of the email address

To be specific,
- At the moment in the list there are email addresses ending in .com.au but the country field is blank. I would like to insert "Australia" into the this field.

There are about 1000 adresses ( i dont want to do this one by one through the browser).

What is the best way to do this ?

Title: importing custom field information ??
Post by: james2 on October 25, 2004, 10:39:09 am

Alternatively,
is there an SQL command that could do this ?[/i]

Title: importing custom field information ??
Post by: DW on October 25, 2004, 02:05:12 pm

Assuming your custom field is field #1, the following command would take care of it for all lists:

update lm_users set user1 = 'Australia' where email like '%.com.au'

Title: importing custom field information ??
Post by: james2 on October 26, 2004, 11:08:29 pm

thanks dean,
the quick response is much appreciated !