Jump to:

23001 Posts in 11702 Topics by 2827 members

General Questions

SilverStripe Forums » General Questions » CSV Newsletter Database Import

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

Page: 1
Go to End
Author Topic: 1390 Views
  • Briohny
    Avatar
    Community Member
    199 Posts

    CSV Newsletter Database Import Link to this post

    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

  • Ronin
    Avatar
    Community Member
    50 Posts

    Re: CSV Newsletter Database Import Link to this post

    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.

  • Briohny
    Avatar
    Community Member
    199 Posts

    Re: CSV Newsletter Database Import Link to this post

    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.

  • Ronin
    Avatar
    Community Member
    50 Posts

    Re: CSV Newsletter Database Import Link to this post

    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?

  • Briohny
    Avatar
    Community Member
    199 Posts

    Re: CSV Newsletter Database Import Link to this post

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

  • drye
    Avatar
    Community Member
    49 Posts

    Re: CSV Newsletter Database Import Link to this post

    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.

    1390 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.