Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Importing members into Newspad using CSV
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Forum LockedImporting members into Newspad using CSV

 Post Reply Post Reply
Author
123Simples View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 July 2007
Location: United Kingdom
Status: Offline
Points: 1192
Post Options Post Options   Thanks (0) Thanks(0)   Quote 123Simples Quote  Post ReplyReply Direct Link To This Post Topic: Importing members into Newspad using CSV
    Posted: 17 December 2010 at 7:41pm
Sad as they may sound, one of the reasons why I have never really used Newspad, is trying to understand the software and how it works. One of the issues I had was actually trying to work out how to import members using a CSV or txt file. Now I've managed to achieve that, I'd like to share what I did so others can find it a bit easier.

Whether or not my actual method is the easiest option, I cannot say - I'm not that smart LOL, but here it goes:

Step 1:
Open up notepad and for example type:
Fictional Name,fictional@someaddress.com
New Character,newcharacter@another.co.uk
Simply Sally,simplesally@hotmail-pretend.com

And so forth. Leave no spaces on each line, but obviously drop down a line to enter the new real name, and then their email address. If you are quick on clicking mouse buttons, you can copy and paste into the Notepad document.
When you have finished, File - Save As, and save as again for example names.csv

You have now created the CSV file

Step 2:
Copy this file to your csv_import FOLDER inside newspad directory, and upload

Step 3:
Choose Import Tools, and then Import Subscribers from CSV or Text File and you will see a blank box but I've already filled in what I did, just so you can know what to do:



Make sure you select All Categories if you want these people to receive your email newsletters, and then hit Import
Give it a few seconds, or minutes, and then you should have a new list of Subscribers. If you make an error, then just delete the Subscribers you have, and start again. It may not be the easiest way, but it works, and as a final tip, for extra security and peace of mind, I then deleted the uploaded csv file from the csv_import FOLDER on the server, as this information is now stored in the newspad database
Back to Top
dfrancis View Drop Down
Senior Member
Senior Member


Joined: 16 March 2005
Location: United States
Status: Offline
Points: 442
Post Options Post Options   Thanks (0) Thanks(0)   Quote dfrancis Quote  Post ReplyReply Direct Link To This Post Posted: 18 December 2010 at 10:47am
sweet!
Back to Top
123Simples View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 July 2007
Location: United Kingdom
Status: Offline
Points: 1192
Post Options Post Options   Thanks (0) Thanks(0)   Quote 123Simples Quote  Post ReplyReply Direct Link To This Post Posted: 18 December 2010 at 6:47pm
Originally posted by dfrancis dfrancis wrote:

sweet!


Thanks Smile
It was the laymans terms on how to do an import, but I hope it helped, and will help others. Now all I've got to figure out is how to do the actual newsletters LOL
Back to Top
123Simples View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 July 2007
Location: United Kingdom
Status: Offline
Points: 1192
Post Options Post Options   Thanks (0) Thanks(0)   Quote 123Simples Quote  Post ReplyReply Direct Link To This Post Posted: 19 December 2010 at 6:19pm
Further to this, say if you want to add some more names at a later date, rather than actually delete the ones you already have, just create a new CSV file using the steps outlined above, and this time save it as for example names-2.csv
Upload that file, tick the boxes or categories that you wish these users to be added to, and then choose Import

Back to Top
dfrancis View Drop Down
Senior Member
Senior Member


Joined: 16 March 2005
Location: United States
Status: Offline
Points: 442
Post Options Post Options   Thanks (0) Thanks(0)   Quote dfrancis Quote  Post ReplyReply Direct Link To This Post Posted: 20 December 2010 at 3:15pm
Originally posted by MrTWS MrTWS wrote:

Further to this, say if you want to add some more names at a later date, rather than actually delete the ones you already have, just create a new CSV file using the steps outlined above, and this time save it as for example names-2.csv
Upload that file, tick the boxes or categories that you wish these users to be added to, and then choose Import
 
Yeah, that's the part I like the most. I do wish there was a form to manually add new recipients, kind of forcing them on the list with the option to remove themselves. But, I know how Bruce feels about spamming so I would probably have to create that one myself.
“If you want things to be different, you must be willing to do different things!”David Francis



Back to Top
123Simples View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 July 2007
Location: United Kingdom
Status: Offline
Points: 1192
Post Options Post Options   Thanks (0) Thanks(0)   Quote 123Simples Quote  Post ReplyReply Direct Link To This Post Posted: 20 December 2010 at 5:32pm
Actually the way we did it was to ask these users in our case, permission by including on our contact forms the question: Subscribe to 123 Simples news? And they had two options (both of which were unticked), so it then gave them the option to choose yes or no. Users who complete our online forms generate an email from the forms, which we then keep on file, and if they have ticked yes, at least we have a way of proving that they registered to receive newsletters.

Options that were not chosen (for example some users may not have selected either yes or no), were not automatically added into the newspad using the method I have shown above.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.