[TYPO3-german] Powermail - Prefill befüllen aus Datenbank von der Extension news

Börge Hendrik sproede at gmx.de
Sat Apr 25 12:17:17 CEST 2015


Hallo,
nutze: Typo3 6.2
Extensions: Powermail und News

Nun wollte ich ein Formular generieren, welches als Thema aus Auswahlfeld nutzt,
in diesem Auswahlfeld sollen die Daten / Tag aus der News Extension angezeigt werden.

Schritt 1: 
- lib ausgedacht: lib.newsCategory

Schritt 2:
- Powermail -> Seite angelegt -> Formular angelegt -> Feld Thema angelegt als Typ "Auswahlfeld"
- In das Feld unter (Erweitert) unter "Aus TypoScript generieren (z.B. lib.fieldvalues)" eingetragen: lib.newsCategory
[FRAGE 1: Ich denke hier ist kein viewhelper notwendige oder?]

Schritt 3:
- Typoscriptdatei extern erstellt und eingebunden, die Datei hat folgendes Script:
lib.newsCategory = COA_INT
lib.newsCategory {
  plugin.tx_powermail{
    settings {
      setup {
        prefill {
          topic = CONTENT
          topic {
            table = tx_news_domain_model_tag
            #Name der Tabelle in der Tag gespeichert sind.
            select {
              pidInList = 19
              #ID in der die News/Nachrichten gespeichert werden
              andWhere {
                data = GP:title
                #Name des Feldes in der Tabelle in der die Inhalte von Tag gespeichert sind
                wrap = tx_news_domain_model_tag.uid=|
              }
            }
            renderObj = TEXT
            renderObj.field = title
          }
        }
      }
    }
  }
}

Im Frontent taucht im Auswahlfeld nun aber lediglich folgendes auf:
"<!--INT_SCRIPT.47ce8777ffc62d9420629e0e3b4ba7b8b-->"
Die Nummer ändern sich mit jeder aktualisierung.

Vor dem zuvor genannten Typoscript habe ich noch:
plugin.tx_powermail.settings.setup {
        # Save values to any table (example for tt_adress)
        dbEntry {
                #####################################################
                        ### EXAMPLE for adding values to table tt_address ###
                        #####################################################

                        # Enable or disable db entry for table tt_address
                        tx_news_domain_model_news._enable = TEXT
                        tx_news_domain_model_news._enable.value = 1

                        # Write only if any field is not yet filled with current value (e.g. test if an email is already in database)
                                # default: always add new records (don't care about existing values)
                                # update: update record if there is an existing entry (e.g. if email is already there)
                                # none: no entry if field is filled (do nothing if record already exists)
                        #tt_address._ifUnique.email = update

                        # Fill new record of table "tt_address" with field "email" with a static value => mail (at) mail.com
                        #tt_address.email = TEXT
                        #tt_address.email.value = mail (at) mail.com

                        # Fill new record of table "tt_address" with field "pid" with the current pid (e.g. 12)
                        tx_news_domain_model_news.pid = TEXT
                        tx_news_domain_model_news.pid.data = TSFE:id

                        # Fill new record of table "tt_address" with field "tstamp" with the current time as timestamp (like 123456789)
                        tx_news_domain_model_news.tstamp = TEXT
                        tx_news_domain_model_news.tstamp.data = date:U

                        # Fill new record of table "tt_address" with field "address" with the current formatted time (like "Date: 20.01.2013")
                        #tt_address.address = TEXT
                        #tt_address.address.data = date:U
                        #tt_address.address.strftime = Date: %d.%m.%Y

                        # Fill new record of table "tt_address" with field "name" with the value from powermail {firstname}
                        tx_news_domain_model_news.title = TEXT
                        tx_news_domain_model_news.title.field = title

                        # Fill new record of table "tt_address" with field "last_name" with the value from powermail {lastname}
                        tx_news_domain_model_news.teaser = TEXT
                        tx_news_domain_model_news.teaser.field = teaser

                        # Fill new record of table "tt_address" with field "company" with the value from powermail {company}
                        tx_news_domain_model_news.bodytext = TEXT
                        tx_news_domain_model_news.bodytext.field = news



                        ##############################################################
                        ### EXAMPLE for adding values to table tt_address_group_mm ###
                        ### Add relation to an existing address group with uid 123 ###
                        ##############################################################

                        # Enable or disable db entry for table tt_address_group_mm
                        #tt_address_group_mm._enable = TEXT
                        #tt_address_group_mm._enable.value = 1

                        # Fill new record of table "tt_address_group_mm" with field "uid_local" with uid of tt_address record that was just created before with .field=uid_[tablename]
                        #tt_address_group_mm.uid_local = TEXT
                        #tt_address_group_mm.uid_local.field = uid_tt_address

                        # Fill new record of table "tt_address_group_mm" with field "uid_foreign" with uid 123
                        #tt_address_group_mm.uid_foreign = TEXT
                        #tt_address_group_mm.uid_foreign.value = 123
        }
}
Mit diesem Code werden Inhalte in die Datenbank von der News Extension gespeichert.

Jemand eine Idee, wo mein Fehler liegt?


More information about the TYPO3-german mailing list