Page 1 of 1

Typo3 Extension - No Synchronization from fe_users

Posted: Tue Oct 27, 2009 11:31 am
by cyberopen
Hi!

I´ve two problems with the Typo3-Extension for OpenEMM 5.51.

I can´t synchronize the reciepents from fe_users. If I click on
"recipients" the message "No new recipients, no synchronization required.
Maybe a configuration problem? The setup contains the right ID from my
recipient folder.

Second, someone have a nice template to work with Typo3 News integration. I learn to use OpenEMM and this setting is so much complex.

Thanks for your help!
Mario

Posted: Fri Oct 30, 2009 10:06 am
by mhuber84
Hi Mario,

perhaps I can help you.

This is how the users are selected:
At first all users are selected from the fe_users table which are not deleted or disabled, which have the usergroup you configured in the Extensionmanager and which have in the field tx_teopenemmnewsletter_update a lower value than in the field tstamp.
Perhaps the SQL statement is more clear:

Code: Select all

$sql = 'SELECT uid, email, first_name, last_name, tstamp, gender, title, tx_teopenemmnewsletter_newsletter, tx_teopenemmnewsletter_newsletter_mailtype, tx_teopenemmnewsletter_newsletter_typ, tx_teopenemmnewsletter_targetgroups, tx_teopenemmnewsletter_delete, tx_teopenemmnewsletter_update, comments
	FROM fe_users
	WHERE deleted+disable = 0
	     AND usergroup = '.intval($this->usergroup).'
	     AND tx_teopenemmnewsletter_update < tstamp
	ORDER BY last_name, first_name, email ASC
	LIMIT 500';
If this statements returns nothing, the message "No new recipients, no synchronization required." will be shown.
Does this answer help you to find the error?

I'm not allowed to give you our complete Newsletter template, but I can give you a code snippet froum our Newsletter template to give you an idea how it could look like:

Code: Select all

[agnDYN name="ueber1unter1_title"]
      <tr>
        <td colspan="2" style="border-bottom: 1px solid #B1E002; padding-bottom:4px;">
          <table width="590" border="0" cellspacing="5" cellpadding="0" style="font-size: 11px; font-family: Verdana, Arial, Helvetica, sans-serif; color: #000033;">
            <tr>
              <td colspan="2">
                <h3 style="font-weight: bold; font-size:13px;">
                  <img src="http://www.marit.ag/newsletter/template/li-eckig.jpg" style="margin-bottom:1px;" /> &nbsp;
                  <a name=ueber1unter1></a> [agnDVALUE name="ueber1unter1_title"/]</h3></td>
            </tr>
            <tr>
              <td valign="top" align="center"> [agnDYN name="ueber1unter1_image1"]
                <div style="width: 150px; text-align: center;">
                  <img src='[agnDVALUE name="ueber1unter1_image1"/]'> [agnDYN name="ueber1unter1_imagecaption1"]<br /><br /> [agnDVALUE name="ueber1unter1_imagecaption1"/] [/agnDYN name="ueber1unter1_imagecaption1"]
                </div> [/agnDYN name="ueber1unter1_image1"]</td>
              <td valign="top"> [agnDYN name="ueber1unter1_short"/]</td>
            </tr>
          </table> [agnDYN name="ueber1unter1_links1"]
          <table width="590" border="0" cellspacing="5" cellpadding="0" style="font-size: 11px; font-family: Verdana, Arial, Helvetica, sans-serif; color: #000033;">
            <tr>
              <td> [agnDYN name="ueber1unter1_readmore"/]</td>
              <td style="text-align: right; color:#82A80F; text-decoration: none">
                <a href="[agnDVALUE name="ueber1unter1_links1"/]">[agnDYN name="ueber1unter1_linktitle"/]</a></td>
            </tr>
          </table> [/agnDYN name="ueber1unter1_links1"]</td>
      </tr>
 [/agnDYN name="ueber1unter1_title"]
If you want to see the whole Newsletter visit our website (click me). ;-)

Kind regards

Marco
www.marit.ag

Posted: Tue Nov 03, 2009 10:35 pm
by cyberopen
Hi Marco,

thanks for your great information. I used the ID Number from the tt_address users not for fe_users Group. So I cant´t sync my users into recipients. :(

1. It´s possible to use tt_address instead of the fe_users?

2. How can I set the right target group? I edit the file "ext_tables.php" f.e.

Code: Select all

"items" => Array (
Array('-- Allgemein --', 'allgemein'),	


and set them in OpenEMM but I got this error: "Unknown column 'targetgroups' in 'field list'".

3. Thanks for your code-snip of your newsletter. I try to make my own.
:wink:

Greetings

Mario

Posted: Wed Nov 04, 2009 10:06 am
by mhuber84
Hi Mario,

I'm sorry, but at the moment it is not possible to use tt_address instead of fe_users. Therefore you would have to change many things in the synchronization module.

To use targetgroups there has to be a field "tx_teopenemmnewsletter_targetgroups" in the fe_users table. This field should be created when you install the extension. In this field the targetgroup a recipient selected will be stored. Also there must be a field "targetgroups" in the OpenEMM database. How to create customs fields in OpenEMM is described in the OpenEMM documentation. When you synchronize your users the values from the field tx_teopenemmnewsletter_targetgroups in the TYPO3 database will be stored in the field targetgroups in the OpenEMM database. Then you have to create targetgroups in OpenEMM like it is described in the OpenEMM dokumentation. After that you can select a targetgroup when you create a newsletter in TYPO3.
I'm sorry that I have to say that you can only select a targetgroup for the whole newsletter. Targetgroup specific content isn't possible at the moment.

Bye
Marco

Re: Typo3 Extension - No Synchronization from fe_users

Posted: Fri Nov 04, 2011 8:53 am
by rockyrock
Hi,
accordingly manual I can use tt_address for locations and organizers, and it works too.
But can I use tt_address for this in conjunction with fe-users and fe-editing?
I’m in doubt about this because the tt_address table doesn’t contain a field for fe-user like tx_cal_location or tx_cal_organizer (field: shared_user_cnt).
Which means a fe-user will see all locations and organizers if he creates an event. That would be far too many.
I want only a short answer, does it work?
Many thanks