xoops forums

Zap_English

Quite a regular
Posted on: 2016/6/30 11:39
Zap_English
Zap_English (Show more)
Quite a regular
Posts: 381
Since: 2016/5/24
#11

Re: Is there a working newsletter module?

ok, thanks

now i just need to get the publisher problem fixed :(

zyspec

Module Developer
Posted on: 2016/6/30 14:17
zyspec
zyspec (Show more)
Module Developer
Posts: 1046
Since: 2004/9/21
#12

Re: Is there a working newsletter module?

@Zap_English

I created a SimpleNewsletter plugin. Please download xNewsletter again from my GitHub repository.

I imported a few users and it looks like it works but please try it and let me know...

Zap_English

Quite a regular
Posted on: 2016/7/1 9:53
Zap_English
Zap_English (Show more)
Quite a regular
Posts: 381
Since: 2016/5/24
#13

Re: Is there a working newsletter module?

Unable to install xnewsletter. Error(s):
Installing xNewsletter

BLOB/TEXT column 'template_description' can't have a default value

Zap_English

Quite a regular
Posted on: 2016/7/1 10:02
Zap_English
Zap_English (Show more)
Quite a regular
Posts: 381
Since: 2016/5/24
#14

Re: Is there a working newsletter module?

that error comes from the xoops25 github

i downloaded another version from your account

https://github.com/zyspec/xnewsletter/archive/master.zip

how do you run the plugin?

when you go to the second import screen "Options for CSV-file" and click on "Available plug-ins", it just takes you back to the first screen "Search available email addresses to import"

Mamba

Moderator
Posted on: 2016/7/1 12:11
Mamba
Mamba (Show more)
Moderator
Posts: 10798
Since: 2004/4/23
#15

Re: Is there a working newsletter module?

Quote:
BLOB/TEXT column 'template_description' can't have a default value

Just go to the /sql/mysql.sql file and remove the "default" designation after the "text", so it is something like:

`template_descriptionTEXT         NOT NULL,
`
template_content`     TEXT         NOT NULL,

And try to install it again...

I've fixed that in GitHub...
Support XOOPS => DONATE
Use 2.5.10 | Docs | Modules | Bugs

zyspec

Module Developer
Posted on: 2016/7/1 15:40
zyspec
zyspec (Show more)
Module Developer
Posts: 1046
Since: 2004/9/21
#16

Re: Is there a working newsletter module?

@Zap_English,

Maybe I misunderstood. I thought you were trying to import SimpleNewsletter users into xNewsletter. If so, you go to the xNewsletter Admin panel, select the Import tab and there should be a selection for SimpleNewsletter (as long as that module is installed on your server). You can see an example of a partial screenshot from my server.

Resized Image



Isn't this what you were asking to be able to do?

Zap_English

Quite a regular
Posted on: 2016/7/3 6:02
Zap_English
Zap_English (Show more)
Quite a regular
Posts: 381
Since: 2016/5/24
#17

Re: Is there a working newsletter module?

That's exactly what I wanted to do, but I didn't install simplenewsletter on my localhost. I was trying to import the csv from simplenewsletter.

I guess I'll have to install it, import the csv, the import to xnewsleter

goffy

Quite a regular
Posted on: 2016/7/5 17:44
goffy
goffy (Show more)
Quite a regular
Posts: 377
Since: 2010/12/27
#18

Re: Is there a working newsletter module?

hi zap_english

import csv only works, if your csv has the structure of sample1col.csv or sample4col.csv in folder plugins (same columns, same column names,...).
If you transform your csv exported from simplenewsletter to this structure, it should work

Zap_English

Quite a regular
Posted on: 2016/7/5 20:02
Zap_English
Zap_English (Show more)
Quite a regular
Posts: 381
Since: 2016/5/24
#19

Re: Is there a working newsletter module?

I think you misunderstood me.

I have to install simplenewsletter on the localhost. Import the simplenewsletter csv from the site to the simplenewsletter on the localhost, then use the xnewsletter plugin to import from the simplenewsletter on the localhost to the xnewsletter on the localhost

Zap_English

Quite a regular
Posted on: 2016/7/6 23:28
Zap_English
Zap_English (Show more)
Quite a regular
Posts: 381
Since: 2016/5/24
#20

Re: Is there a working newsletter module?

Ok, I got everything installed and it seems to have imported everything from simplenewsletter without any problems

But I would like to make a couple of questions

1) does a subscriber have to be a member of the website? I was considering removing the new user registration and login block on my site

2) will the file attachment send to each individual in the mailing list? Simplenewsletter said it did this but it never did

3) Is there an unsubscribe link automatically attached to the end of each email?

4) is there a block that will allow a user to sign up for the mailing list like simplenewsletter? I can't find it