[TYPO3-project-formidable] renderlet:LISTER examples?

[Fabien Udriot]

Hi,

I see, once upon a time, a demo from Jerome that shows a LISTER with a 
translucent panel that contains the update form. In other words, if the 
user clicks on a row of the table, the update form appears over the 
table. The informations are sent, then, via a AJAX request.

Is such an example available ? Where should it be to be coded ? In the 
*.xml or in the template ?

Have a nice evening, FABIEN

Raphael GEYER a écrit :
> Hi Valery,
> 
> External Databases can also be accessed by using the link configuration in 
> the datasource see following xml code which is used at 
> http://www.wickersheim-wilshausen.com/meteo/derniers-releves.html
> 
> 
> <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
> <formidable version="0.7.76"
>  xmlns:datahandler="http://www.ameos.com/formidable/080/datahandler"
>  xmlns:datasource="http://www.ameos.com/formidable/080/datasource"
>  xmlns:renderer="http://www.ameos.com/formidable/080/renderer"
>  xmlns:renderlet="http://www.ameos.com/formidable/080/renderlet"
>  xmlns:validator="http://www.ameos.com/formidable/080/validator"
>  xmlns:actionlet="http://www.ameos.com/formidable/080/actionlet">
> 
>  <meta>
>   <name>Renderlet:LISTER, cached lists</name>
>   <form formid="newlisterpi1"/>
>   <displaylabels>true</displaylabels>
>   <debug>false</debug>
>  </meta>
> 
>  <control>
> 
>   <datahandler:VOID />
>   <renderer:STANDARD />
> 
>   <datasources>
>    <datasource:DB name="weather_T-RH">
>     <link>
>      <user>db-login</user>
>      <password>db-pass</password>
>      <host>localhost</host>
>      <dbname>weather</dbname>
>     </link>
>     <sql><![CDATA[
> 
>      SELECT
>       (UNIX_TIMESTAMP(th_sensors.datetime) + 7200) as th_sensors_datetime,
>       th_sensors.T as th_sensors_T,
>       th_sensors.H as th_sensors_H,
>       rain.diff as rain_diff,
>       pressure.P as pressure_P,
>       wind.speed as wind_speed
>      FROM
>       th_sensors
>       LEFT JOIN rain ON th_sensors.datetime = rain.datetime
>       LEFT JOIN pressure ON th_sensors.datetime = pressure.datetime
>       LEFT JOIN wind ON th_sensors.datetime = wind.datetime
>      WHERE
>       th_sensors.sensid = 1
> 
>     ]]></sql>
>    </datasource:DB>
>   </datasources>
> 
>  </control>
> 
>  <elements>
> 
>   <renderlet:LISTER name="mylist">
>    <datasource use="weather_T-RH" />
>    <columns>
>     <column name="th_sensors_datetime" type="renderlet:DATE" label="Heure">
>      <data>
>       <datetime format="%d/%m/%Y %H:%M" />
>      </data>
>     </column>
>     <column name="th_sensors_T" type="renderlet:TEXT" label="T (�C)" />
>     <column name="th_sensors_H" type="renderlet:TEXT" label="H (%)" />
>     <column name="rain_diff" type="renderlet:TEXT" label="Pluie ml/15min" />
>     <column name="pressure_P" type="renderlet:TEXT" label="Pression" />
>     <column name="wind_speed" type="renderlet:TEXT" label="Vent km/h" />
>    </columns>
>    <pager>
>     <rows perpage="96" />
>     <sort column="th_sensors_datetime" direction="DESC" />
>    </pager>
>   </renderlet:LISTER>
> 
>  </elements>
> 
> </formidable>
> 
> 
> Regards,
> 
> Raphael GEYER
> http://www.ameos.com
> 
> 
> 
> "Valery Romanchev" <info at typo3lab.ru> a �crit dans le message de news: 
> mailman.1.1193675641.25575.typo3-project-formidable at lists.netfielders.de...
>> Hello
>>
>> First of all many thanks for formidable!
>>
>> Now I am trying to learn it and use for simple task of output records of 
>> an external MySQL database with page browsing.
>>
>> It seems that external MySQL database is no problem because we have 
>> datasource:PHPARRAY
>>
>> But now I have lots of problems with renderlet:LISTER
>> I can not find any simple working example of it.
>>
>> I see screenshots with the functionality, that I need: 
>> http://wiki.typo3.org/index.php/Formidable_documentation#Screenshots
>>
>> It will be very good to see real life examples of renderlet:LISTER of some 
>> complexity (list records by custom nested templates) in wiki.
>>
>>
>> Thank you in advance
>>
>> Regards,
>> Valery 
> 
>