Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

General Questions /

General questions about getting started with SilverStripe that don't fit in any of the categories above.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

CSV Newsletter Database Import


Reply


6 Posts   1531 Views

Avatar
Briohny

Community Member, 199 Posts

2 April 2009 at 1:35am

Is there a limit to the number of entries you can upload to a newsletter member database? I tried uploading 2,240 email addresses and it all seemed to be going well until i had to refresh the list to update the members fields. Error appeared in red 'error loading page' - then the whole site crashed.

I went and emptied the members fields via phpMyAdmin. All started working properly again.

Then I divided my list into 10 smaller files. I got to file 7 and the same problem as above happened again... 'error loading page'

Any ideas anyone?

Many thanks

Avatar
Ronin

Community Member, 50 Posts

2 April 2009 at 10:32am

Hi,
From what you have described I'd be inclined to check the data in that 7th file. I have found that in similar circumstances there will be some issue with the data on a particular record. There maybe one or more characters such spaces, special characters, non printable characters or simply that the format has some issue in it.

Avatar
Briohny

Community Member, 199 Posts

3 April 2009 at 1:18am

Hey Ronin,

Thanks for your reply. That unfortunately wasn't the answer as it then began acting the same way no matter which of my 10 smaller files I tried to upload. I eventually found that if i just uploaded the entire csv file, hit confirm but then NOT refresh using the link given but instead using the ?flush... it worked. By hitting confirm the entries were being added to the database successfully it was just when i was hitting 'refresh' when the problems started. It took me ages to figure out and wrecked my head!! It's a cheesy fix but there must be something wrong in the code and I don't have time to figure it out.

I do have another question that you may be able to help me with though... now that i have my 2240 email addresses, i just sent my first newsletter. It's taking FOREVER to send to all recipients. Know of any way of speeding this up. The newsletter is a tiny text file with only 2 sentences. Hate to imagine if i had any more content!

My client won't be happy sending newsletters like this if it takes over 40min to send.

Many thanks.

Cheers.

Avatar
Ronin

Community Member, 50 Posts

3 April 2009 at 11:22am

Main thing is you got it working. Later on it will probably become clear what the problem is.

How are you sending out the emails?

Avatar
Briohny

Community Member, 199 Posts

3 April 2009 at 9:42pm

Just via the newsletter admin. It sends but just takes awhile as there over 2000 recipients. :)

Avatar
drye

Community Member, 49 Posts

30 April 2009 at 2:42pm

Briohny, Usually this would be desired as many hosts will shut your smtp access down if you send things too rapidly. As for the way silverstripe is processing the e-mails and if you could speed it up I'd have to dig in a bit deeper to see. 40min for over 2000 recipients sounds good to me.