We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
MODX Community Forums Archive

Support/Comments for Easy Newsletter

    • 4310
    • 2,310 Posts
    bunk58 Reply #61, 17 years, 10 months ago
    Jack
    Get your excel spreadsheet fields to match the columns in my example .xls file
    Save as subscribers.csv
    Upload to your assets/csv folder ( you will need to create a new csv sub folder )
    Create a snippet with the code I posted
    Name it UpdateSubscribers
    Add the snippet call [!UpdateSubscribers!] to an unpublished page
    Open the unpublished page from the document tree in the Manager
    The snippet should run & update your easynewsletter_subscribers table
    Open the EasyNewsletters module and check they are all there
    Job done, make a cup of tea  laugh

      • 15152
      • 360 Posts
      jwmsales Reply #62, 17 years, 10 months ago
      David
      Awesome! Worked like a charm. I’d be nice if someone could incorporate the into the module.

      Thanks a ton,
      Jack
        There are no boring projects. Only boring executions. ~ Etzkorn
        www.impress-design.com
        • 4310
        • 2,310 Posts
        bunk58 Reply #63, 17 years, 10 months ago
        Glad you got it working smiley
        I’d be nice if someone could incorporate the into the module
        One of those things you never seem to find the time for unless a client is paying wink
          • 15152
          • 360 Posts
          jwmsales Reply #64, 17 years, 10 months ago
          David
          I don’t want to take all of your time but I ran into this: I used the script on two different sites (different servers ) with no problems. Then I went to upload everything the same for my primary site (same server as one of the others) and I got this message

          « MODx Parse Error »
MODx encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 »
      SQL: SELECT fullname FROM `parkerco_parker`.`modx_user_attributes` WHERE `parkerco_parker`.`modx_user_attributes`.id =


          Any ideas where to look?

          Thanks, Jack
            There are no boring projects. Only boring executions. ~ Etzkorn
            www.impress-design.com
            • 4310
            • 2,310 Posts
            bunk58 Reply #65, 17 years, 10 months ago
            Jack,
            Is that error when you run the snippet?
            My code doesn’t use a ’SELECT’, ’FROM’ or ’WHERE’ statement, nor does it touch the ’modx_user_attributes’ table.
              • 20349 ☆ A M B ☆
              • 453 Posts
              Mproject Reply #66, 17 years, 10 months ago
              hmm... I installed module to my new future site... but when I send newsletter, my CSS rules are not displayed...

              Any ideas why?  huh



              Another issue that I’m troubled with is this error:

              « MODx Parse Error »
MODx encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed - Table 'vp_ads.easynewsletter_config' doesn't exist »
      SQL: SELECT * FROM `easynewsletter_config` WHERE `id` = 1
      [Copy SQL to ClipBoard]
 
Parser timing
  MySQL: 	0.0351 s	(3 Requests)
  PHP: 	0.2868 s	 
  Total: 	0.3219 s


              I’m using OpenX for my banners and this issue is related to it. When I hit refresh, everything works fine.

              Are you familiar with it?
                BASE - Web Design Studio
                MODX Ambassador

                Website
                • 26931
                • 2,314 Posts
                anonymized-26931 Reply #67, 17 years, 10 months ago
                Hi there!

                does anybody know how i get a page with the newsletter subscription to validate?
                i get some errors because of the inserted javascript:

                character "<" is the first character of a delimiter but occurred as data.
                if (apos<1||dotpos-apos<2)

                character "<" is the first character of a delimiter but occurred as data.
                if (apos<1||dotpos-apos<2)

                XML Parsing Error: StartTag: invalid element name.
                if (apos<1||dotpos-apos<2)

                XML Parsing Error: StartTag: invalid element name.
                if (apos<1||dotpos-apos<2)

                thank you, j

                  • 26931
                  • 2,314 Posts
                  anonymized-26931 Reply #68, 17 years, 10 months ago
                  i get some errors because of the inserted javascript
                  okay, i found out that wrapping the JS like this
                  <script type="text/javascript">
<!--
  JAVASCRIPT HERE
//-->
</script>

                  will fix it smiley
                    • 16034
                    • 107 Posts
                    Kleist Reply #69, 17 years, 10 months ago
                    I googled for the error string:
                    character "<" is the first character of a delimiter but occurred as data

                    It gives this as first hit: http://www.webmasterworld.com/forum91/4480.htm
                      MODx snippet-glossary 101:
                      Ditto = Content Lister -- Wayfinder == Menu Builder -- Jot = Comment Control
                      • 26931
                      • 2,314 Posts
                      anonymized-26931 Reply #70, 17 years, 10 months ago
                      @Kleist

                      thank you, that was the first page i found when i googled the error too smiley the second one i found did the fix (post above), i was a bit too fast posting the issue though wink

                      j