Importing emails to newsletter module.

Thanks LG, I'll do that.

Thanks chip, saves me thinking up a load of fake emails lol. I will take a look at importing into mine and see what happens.

I am pretty sure there is a problem with this. I took Chips list and tried importing it into my clean install. I will do you screen shots Chris when i get a chance. I tried all the various ways of doing it. I get various messages depending on how i import. many of them telling me i have added 35 members.

the one problem i noticed with chips list is 5 or 6 members dont have ID numbers, apart from that the file looks fine.

After importing at no point do the users show up on any screen, or anywhere in the database (i looked using my php admin).

I tried both normal CSV and saving as DOS csv nothing worked.

When i get a moment i will screen shot for you exactly what id did and what the messages were. Bug or not, the system tells you that you have imported or you have unsubscribed (depending on what you have supposedly done), However the reality is the information is never actually imported into the site or database.

I also looked at newsletter members by both screen method and downloading as csv, at no point did the imported users show up. I think what chip saw was a list of his members not the news letter subscribers. I say that because i have 3 members on the site i tried, at one point after importing i could see my 3 members but none of the imported news letter members.


Now obviously i have made a pigs ear of explaining that. So let me go install a new copy and screen shot it all for Chris..

scrub the database thing, i can see them in the database, but i cant see them on screen anywhere.

Ok this is screen shot heavy Chip, its mainly for Chris to see exactly what i am doing importing your emails.

It might save soime time for him, he might also be able to spot if we are doing something wrong on importing.
So i have some of Chips email addresses in a CVS file.

I have it in excell and one copy is CSV saved under normal excell CSV the other is saved under DOS CSV and later i will pull the addresses from the database directly using export CSV from php my admin.

I wont be able to do this post in one hit, so this is part one.

Here we go a brand new install with nothing done to it, this is straight out the box.

So first attempt we goto ACP and as shown we goto TOOLS-NEWSLETTER-IMPORT NEWSLETTER SUBSCRIBERS




So i have chosen the general cat as i havnt added any, and new subscribers, the other option tells you it is for unsubscribing. Now we choose the file.





This is a screen shot of the excel file, i have cut off the actual email addresses for obvious reasons, but they are there.






We click proceed.
We are then told we have unsubscribed 0 users and 35 have been processed. Well thats good is it not? Unsure but here is the shot

Part 2
It was getting difficult to write and edit with large pics in the posts. next job before we try and find our users is to look at the database, see if it imported into it. So this is the screen shot of the server database.

this is the database view, i have redacted the addresses but they are there and in the correct order.

SO lets look in Composr.

Lets goto ACP and look here, under tools newsletter view subscribers.


Lets use the screen first, so we make sure we are set to look at the same place we put the users, in out instance we only have general which is chosen by default.





For brevity i wont show all the permutations but it dosnt matter what screen you goto or if you try and download the csv file. You dont get to see the imported information anywhere.

Hopefully that helps. if you want me to try something else Chris let me know.

Sorry for the delayed reply, I was bogged down working on the Purchasable downloads sponsored feature.

Definitely the first row that starts 'Level' should not be there, that may be breaking it.

I will review all in detail now though.

lg11 said

Part 2
It was getting difficult to write and edit with large pics in the posts. next job before we try and find our users is to look at the database, see if it imported into it. So this is the screen shot of the server database.

this is the database view, i have redacted the addresses but they are there and in the correct order.

SO lets look in Composr.

Lets goto ACP and look here, under tools newsletter view subscribers.


Lets use the screen first, so we make sure we are set to look at the same place we put the users, in out instance we only have general which is chosen by default.





For brevity i wont show all the permutations but it dosnt matter what screen you goto or if you try and download the csv file. You dont get to see the imported information anywhere.

Hopefully that helps. if you want me to try something else Chris let me know.

From “Post #1,781”, 23rd January 2017, 6:28 pm

Ignore my last post.

What's in the newsletter_subscribe table? (the other one)

Ok, I have worked it out .

The issue is that the "Subscription level" column (column L) still exists, but is blank. Composr is taking that to mean '0', which is 'not subscribed'.

So it is importing all the users, but setting them to a not-subscribed status on that newsletter.

Actually I'd fixed it with my tweaks earlier, but I wasn't specifically aware of this trigger case. I'll make it smarter here too, blank should not mean '0' it should mean default.

Just delete column L and it will be fine in the current RC.

Ok great. the excel file is how Composr exports the CVS as well, so does the SQL database.


Ok Chip if you need a hand altering your excel file for now let me know.

Chris is saying in the excel file you have to delete all of column L including the title i guess. If you need a hand mate send me the entire file and i will sort it out for you if thats easier. Or i can try the one you gave me first. But i cant do that until later.

Thanks Chris.

Chip is way ahead in using different parts of Composr than i am, but when he posts about things i try them out as well.

At least the software is getting a thorough testing . Also i will go through your site this weekend Chip, i noticed a couple of tiny tweaks. So i will grab a couple of hours at the weekend and go through it with you.

Ok cool! So I deleted column L and try the import and got the message: That verabe led me to belive that there wasn't any emails imported, but I downloaded a csv of my subscribers and it did indeed import 36 email addresses. Thanks for everything guys. I feel confident that I can now add the three hundred or so emails from my POS in to the newsletter module now.

Glad it worked . What this is saying is that the newsletter accounts had been created successfully before for them, but now they are also on your actual newsletter (this distinction exists because you can have multiple newsletters in Composr).

I gotcha. Makes sense

Happy days! And all good info .