Menu Content/Inhalt
Click on the slide!

3B help you build relationships with your users

Email newsletters are one of the most important ways to communicate with customers on the Internet. 3B specialise in providing customised templates and managed databases to help you drive targeted spam-proof emails to your customer base.

Click on the slide!

3B just got even sharper!

Websites are now just one aspect of a multi-disciplined approach to Digital Marketing; 3B offers a complete service to all companies and brands looking to fully exploit everything that new media has to offer...

Click on the slide!

Build it and they will come..?

It's a line from a great movie - but it just doesn't work in Digital Marketing; simply building a website and hoping people will find it doesn't get you anywhere - read about the various and varied tricks and tips used by 3B to get your message "out there".

Frontpage Slideshow (version 2.0.0) - Copyright © 2006-2008 by JoomlaWorks
email: info@3bweb.com call us now: 0844 414 0906
PHPList - Importing data
Written by Fraser Shipsides   
Tuesday, 13 May 2008
To send a newsletter to a new e-mail list you will need to create a completely new list. (i.e. not a general newsletter list).
  • Select "list" from the right menu bar. Then scroll down to the bottom of the page and select the "add a list" link.
  • Give your new list and name and then select the save option.
You will then need to check what attributes that PHPList recognises/requires from your importing spreadsheet.
  • Select "main page" from the right hand menu bar and select "attributes" from the "Configurations functions" list.
  • Scan the list and take note of the corresponding attributes (e.g. a users firstname should be under the title "Forename")
  • Note the e-mail addresses should be listed under the title of "email" (there should be no "-").
You would then need to change your spreadsheet so that PHPList can process it properly.
  • Change the column titles so they match those in the attributes list.
  • Then create a column called "send this user HTML emails".
  • Enter a "1" into the first field. Select the bottom right corner of the cell and copy the cell down the entire column so that all users have a "1" in this field.
  • You will then need to save your spreadsheet as the appropriate file type:
  • Select "File", "Save as" and change the file type from "xls" to "Text (Tab delimited)"
  • Click yes/ok to any warnings that might show
Go back into PHPList
  • Select "manage users" and then select the "import users" link.
  • Select the first link from the list "import emails with different values for attributes".
  • Tick the name of the list that you created initially and then scan to the bottom of the list.
  • Select "Browse" and add your spreadsheet.
  • Tick all the checkboxes in the form except the second to last field "Retain Old User Email:"
  • Select "Make confirmed immediately"
  • Then "Import"
Note: Don't worry about any warnings saying "record has more values than header indicated".
  • Then "Confirm Import" and upload the file
Notes:
Make sure your text files are not larger than 1MB by splitting them into multiple text files.

For more information on PHPList, including setup, please contact us .


Add this page to your favorite Social Bookmarking websites
Reddit! Del.icio.us! Google! Live! Facebook! StumbleUpon! MySpace! Yahoo!
» No Comments
There are no comments up to now.
» Post Comment
Email (will not be published)
Name
Subject
Comment
 remaining characters
Captcha Image Regenerate code when it's unreadable
 
"3bweb delivered a complete revision of our web site to tight timescales. The web site now gets consistently good feedback from our customers and prospects - a job well done." Stewart Walker, Portfolio Manager, Softlab Ltd.

Portfolio example:


FESPA


more examples...
Open Source MattersJoomla! Content Management Systemphplist_logo_bottom.jpgPayPal - accept payments from anyone with a credit or debit card!GoogleCoppermine GalleryRSS Feeds
© 1998-2009 3B Web Design - Bremer and Bremer trading as 3B Web Design
VAT Registration No: 936007044