ext_tables.php and foreign_table - please explain

View: New views
5 Messages — Rating Filter:   Alert me  

ext_tables.php and foreign_table - please explain

by Søren Malling :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi,

I've been having a look at the use of foreign_table in my ext_tables.php
files, but without any real luck. I'm not able to get any output from my
table, and i feel like I'm missing somewhere to define what field to take
values from, in my table.

Can some one please explain me the lack of configuration, or maybe a link to
a page desribing/documentating the foreign_table possibility? I've already
been through this page

http://typo3.org/documentation/document-library/core-documentation/doc_core_api/4.1.0/view/4/2/#id4104498

Without any real luck or better understanding for why it isn't working

        "user_extendfeuser_testfield" => Array (
                "exclude" => 0,
                "label" => "test field", #hardcoded label, just for testing
purpose
                "config" => Array (
                        "type" => "select",
                        "foreign_table" => "tx_fdforginfo_fields", #name of
my extension table
                        "size" => "5",
                        "minitems" => 0,
                        "maxitems" => 1,
                )
        ),


Thanks and regards,

Søren
_______________________________________________
TYPO3-english mailing list
TYPO3-english@...
http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english

Re: ext_tables.php and foreign_table - please explain

by Søren Malling :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I'd like to bring this question up again, does nobody know how to use
foreign_table or are they just on vacations? :-)

Regards,

Søren

On Thu, Jul 24, 2008 at 10:29 AM, Søren Malling <soren.malling@...>wrote:

> Hi,
>
> I've been having a look at the use of foreign_table in my ext_tables.php
> files, but without any real luck. I'm not able to get any output from my
> table, and i feel like I'm missing somewhere to define what field to take
> values from, in my table.
>
> Can some one please explain me the lack of configuration, or maybe a link
> to
> a page desribing/documentating the foreign_table possibility? I've already
> been through this page
>
>
> http://typo3.org/documentation/document-library/core-documentation/doc_core_api/4.1.0/view/4/2/#id4104498
>
> Without any real luck or better understanding for why it isn't working
>
>        "user_extendfeuser_testfield" => Array (
>                "exclude" => 0,
>                "label" => "test field", #hardcoded label, just for testing
> purpose
>                "config" => Array (
>                        "type" => "select",
>                        "foreign_table" => "tx_fdforginfo_fields", #name of
> my extension table
>                        "size" => "5",
>                        "minitems" => 0,
>                        "maxitems" => 1,
>                )
>        ),
>
>
> Thanks and regards,
>
> Søren
> _______________________________________________
> TYPO3-english mailing list
> TYPO3-english@...
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
>
_______________________________________________
TYPO3-english mailing list
TYPO3-english@...
http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english

Re: ext_tables.php and foreign_table - please explain

by Alexander Stehlik :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi Søren,

I think the easiest way to figure out how to use foreign tables is to
create an extension in the kickstarter (in the Extension Manager).

There you can create a new table and a field with the type Database
relation. This should be quite self-explaining.

Now you can view the result and inspect the source code.

Good luck.

Greetz,

Alex.

2008/7/28 Søren Malling <soren.malling@...>:

> I'd like to bring this question up again, does nobody know how to use
> foreign_table or are they just on vacations? :-)
>
> Regards,
>
> Søren
>
> On Thu, Jul 24, 2008 at 10:29 AM, Søren Malling <soren.malling@...>wrote:
>
>> Hi,
>>
>> I've been having a look at the use of foreign_table in my ext_tables.php
>> files, but without any real luck. I'm not able to get any output from my
>> table, and i feel like I'm missing somewhere to define what field to take
>> values from, in my table.
>>
>> Can some one please explain me the lack of configuration, or maybe a link
>> to
>> a page desribing/documentating the foreign_table possibility? I've already
>> been through this page
>>
>>
>> http://typo3.org/documentation/document-library/core-documentation/doc_core_api/4.1.0/view/4/2/#id4104498
>>
>> Without any real luck or better understanding for why it isn't working
>>
>>        "user_extendfeuser_testfield" => Array (
>>                "exclude" => 0,
>>                "label" => "test field", #hardcoded label, just for testing
>> purpose
>>                "config" => Array (
>>                        "type" => "select",
>>                        "foreign_table" => "tx_fdforginfo_fields", #name of
>> my extension table
>>                        "size" => "5",
>>                        "minitems" => 0,
>>                        "maxitems" => 1,
>>                )
>>        ),
>>
>>
>> Thanks and regards,
>>
>> Søren
>> _______________________________________________
>> TYPO3-english mailing list
>> TYPO3-english@...
>> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
>>
> _______________________________________________
> TYPO3-english mailing list
> TYPO3-english@...
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
>
_______________________________________________
TYPO3-english mailing list
TYPO3-english@...
http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english

Re: ext_tables.php and foreign_table - please explain

by Søren Malling :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi Alex,

As shown in my mail, I've already created a extension and tried using the
foreign_table, but i need to know how to "choose" the fields to be shown,
from my table.

If i write "fe_users" as my foreign_table, it automaticly write the
usernames ini my selector, but how do I define the fields I would like to
see?

Regards,

Søren

On Mon, Jul 28, 2008 at 12:02 PM, Alexander Stehlik <
alexander.stehlik@...> wrote:

> Hi Søren,
>
> I think the easiest way to figure out how to use foreign tables is to
> create an extension in the kickstarter (in the Extension Manager).
>
> There you can create a new table and a field with the type Database
> relation. This should be quite self-explaining.
>
> Now you can view the result and inspect the source code.
>
> Good luck.
>
> Greetz,
>
> Alex.
>
> 2008/7/28 Søren Malling <soren.malling@...>:
> > I'd like to bring this question up again, does nobody know how to use
> > foreign_table or are they just on vacations? :-)
> >
> > Regards,
> >
> > Søren
> >
> > On Thu, Jul 24, 2008 at 10:29 AM, Søren Malling <soren.malling@...
> >wrote:
> >
> >> Hi,
> >>
> >> I've been having a look at the use of foreign_table in my ext_tables.php
> >> files, but without any real luck. I'm not able to get any output from my
> >> table, and i feel like I'm missing somewhere to define what field to
> take
> >> values from, in my table.
> >>
> >> Can some one please explain me the lack of configuration, or maybe a
> link
> >> to
> >> a page desribing/documentating the foreign_table possibility? I've
> already
> >> been through this page
> >>
> >>
> >>
> http://typo3.org/documentation/document-library/core-documentation/doc_core_api/4.1.0/view/4/2/#id4104498
> >>
> >> Without any real luck or better understanding for why it isn't working
> >>
> >>        "user_extendfeuser_testfield" => Array (
> >>                "exclude" => 0,
> >>                "label" => "test field", #hardcoded label, just for
> testing
> >> purpose
> >>                "config" => Array (
> >>                        "type" => "select",
> >>                        "foreign_table" => "tx_fdforginfo_fields", #name
> of
> >> my extension table
> >>                        "size" => "5",
> >>                        "minitems" => 0,
> >>                        "maxitems" => 1,
> >>                )
> >>        ),
> >>
> >>
> >> Thanks and regards,
> >>
> >> Søren
> >> _______________________________________________
> >> TYPO3-english mailing list
> >> TYPO3-english@...
> >> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
> >>
> > _______________________________________________
> > TYPO3-english mailing list
> > TYPO3-english@...
> > http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
> >
> _______________________________________________
> TYPO3-english mailing list
> TYPO3-english@...
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
>
_______________________________________________
TYPO3-english mailing list
TYPO3-english@...
http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english

Re: ext_tables.php and foreign_table - please explain

by Dmitry Dulepov [typo3] :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi!

Søren Malling wrote:
> As shown in my mail, I've already created a extension and tried using the
> foreign_table, but i need to know how to "choose" the fields to be shown,
> from my table.
>
> If i write "fe_users" as my foreign_table, it automaticly write the
> usernames ini my selector, but how do I define the fields I would like to
> see?

TYPO3 always shows "label" field there. For fe_users it is "username" field. You can define your own function to return alternative label but it will be used everywhere in the Backend. See about labels in "TYPO3 core API".

--
Dmitry Dulepov
TYPO3 Core team
Latest article: http://typo3bloke.net/post-details/do_not_ask_more_than_you_need/
More about TYPO3: http://typo3bloke.net/
Subscribe: http://typo3bloke.net/rss.xml
_______________________________________________
TYPO3-english mailing list
TYPO3-english@...
http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
LightInTheBox - Buy quality products at wholesale price