[TYPO3] External database table entry with TCA
abhijit kakade
abhikakade at gmail.com
Wed Apr 23 07:46:43 CEST 2008
Hello
Thanks for your help.
I used dbal,adodb to connect external database using TCA and it works.
On Wed, Apr 23, 2008 at 11:09 AM, <
typo3-english-request at lists.netfielders.de> wrote:
> Send TYPO3-english mailing list submissions to
> typo3-english at lists.netfielders.de
>
> To subscribe or unsubscribe via the World Wide Web, visit
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
> or, via email, send a message with subject or body 'help' to
> typo3-english-request at lists.netfielders.de
>
> You can reach the person managing the list at
> typo3-english-owner at lists.netfielders.de
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of TYPO3-english digest..."
>
>
> Today's Topics:
>
> 1. Re: Realurl, possible to automate multidomains?
> (Dmitry Dulepov [typo3])
> 2. External database table entry with TCA (abhijit kakade)
> 3. Re: [Typo3] headerData -> with rlmp_tmplselector
> (Christopher Torgalson)
> 4. Re: Menu problem/bug - alternativeSortingField
> (Christopher Torgalson)
> 5. Re: External database table entry with TCA (Francois Suter)
> 6. Re: External database table entry with TCA
> (Dmitry Dulepov [typo3])
> 7. print the url of the actual page with simulatestatic (micho edo)
> 8. Re: print the url of the actual page with simulatestatic
> (Christopher Torgalson)
> 9. Re: print the url of the actual page with simulatestatic (micho)
> 10. Re: print the url of the actual page with simulatestatic (micho)
> 11. Typo3 server for virtual domains (Ronald Wiplinger)
> 12. Re: print the url of the actual page with simulatestatic
> (Christopher Torgalson)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Tue, 22 Apr 2008 20:31:31 +0300
> From: "Dmitry Dulepov [typo3]" <dmitry at typo3.org>
> Subject: Re: [TYPO3] Realurl, possible to automate multidomains?
> To: typo3-english at lists.netfielders.de
> Message-ID:
> <mailman.1.1208885491.16121.typo3-english at lists.netfielders.de>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Elijah wrote:
> > I have an installation with many domains and fe automatic registrations.
> > Registered Users get their own page tree and domain name and currently
> > set to simulatestatic for friendly urls.
> >
> > I would like to change how it handles urls using realurl but do you
> > think it's possible to automate this without adding domains and
> > rootpid's in the realurl_conf.php file? Maybe by typoscript instead or
> > is this not possible?
>
> No. PHP only. Sorry :(
>
> --
> Dmitry Dulepov
> TYPO3 core team
> Web: http://typo3bloke.net/
> Skype: callto:liels_bugs
> "Nothing is impossible. There are only limits to our knowledge"
>
>
> ------------------------------
>
> Message: 2
> Date: Tue, 22 Apr 2008 23:57:03 +0530
> From: "abhijit kakade" <abhikakade at gmail.com>
> Subject: [TYPO3] External database table entry with TCA
> To: typo3-english at lists.netfielders.de
> Message-ID:
> <mailman.13795.1208888868.3430.typo3-english at lists.netfielders.de>
> Content-Type: text/plain; charset=ISO-8859-1
>
> Hello
>
> I have a external database (not typo3 database) which should get
> updated
> when I create new record through TCA , I have created tca.php for external
> database tables. i dont know how to connect external database through TCA.
>
> --
> Abhijit Kakade
> LAMP Developer,
> MCP,CCNA
> Mob : +91-9923729250
>
>
> ------------------------------
>
> Message: 3
> Date: Tue, 22 Apr 2008 21:08:21 +0200
> From: "Christopher Torgalson" <bedlamhotel at gmail.com>
> Subject: Re: [TYPO3] [Typo3] headerData -> with rlmp_tmplselector
> To: "TYPO3 English" <typo3-english at lists.netfielders.de>
> Message-ID:
> <mailman.13844.1208891342.3430.typo3-english at lists.netfielders.de>
> Content-Type: text/plain; charset=ISO-8859-1
>
> Hi,
>
> On Tue, Apr 22, 2008 at 2:16 PM, Hanspeter Jakober <rigigasse at gmail.com>
> wrote:
> > Christopher Torgalson schrieb:
> >
> >
> > > Typoscript is case-sensitive. There is no such cObject as "Text,"
> > > though there is one called "TEXT"...
> >
> > That is my fault - of course there is no cObject called "Text".
> > But it is not the solution... Any other ideas?
>
>
> This is just a suspicion--I have a dim memory of perhaps encountering
> this problem myself--but what happens if you remove the comments from
> inside the style tags?
>
>
> --
> Christopher Torgalson
> http://www.typo3apprentice.com/
>
>
> ------------------------------
>
> Message: 4
> Date: Tue, 22 Apr 2008 21:12:54 +0200
> From: "Christopher Torgalson" <bedlamhotel at gmail.com>
> Subject: Re: [TYPO3] Menu problem/bug - alternativeSortingField
> To: "TYPO3 English" <typo3-english at lists.netfielders.de>
> Message-ID:
> <mailman.13845.1208891619.3430.typo3-english at lists.netfielders.de>
> Content-Type: text/plain; charset=WINDOWS-1252
>
> Hi,
>
> On Tue, Apr 22, 2008 at 6:34 PM, Tyler Kraft
> <tyler.kraft at netefficiency.co.uk> wrote:
> > Hi
> >
> > I've got a menu built and it works fine for the most part. But I want
> to
> > use the alternativeSortingField property and it seems to be buggy.
> Below
> > I've copied the relevant TS (I've obviously omitted parts of it, but it
> > is valid and working).
> > (* Note : I'm building a menu of custom doctype pages we've created via
> > an extension.)
> >
> > 10 = HMENU
> > 10{
> > special = directory
> > special.value =
> >
> 119,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214
> > excludeDoktypes = 1,2,3,4,5,6,7,199,254,255
> > 1 = TMENU
> > 1{
> > alternativeSortingField = tx_neevents_sort_date,title
> >
> > What seems to be happening is that the only field it wants to sort on
> is
> > the title - can I not use other fields? Can I sort on custom fields? Am
> > I limited in any way to the fields I can sort on?
> >
> > Likewise when I try to use either 'asc' or 'desc' with the sort it just
> > simply stops working, and I've tested it using the below setting
> >
> > alternativeSortingField = title desc
> >
> > So is this actually a bug or am I doing something wrong?
>
>
> Just a guess: have you added "tx_neevents_sort_date" to
> [FE][addRootLineFields] in the install tool? (In fact, I'm not even
> positive it should be necessary?)
>
>
> --
> Christopher Torgalson
> http://www.typo3apprentice.com/
>
>
> ------------------------------
>
> Message: 5
> Date: Tue, 22 Apr 2008 21:20:42 +0200
> From: Francois Suter <fsuter at cobweb.ch>
> Subject: Re: [TYPO3] External database table entry with TCA
> To: typo3-english at lists.netfielders.de
> Message-ID:
> <mailman.1.1208892049.12175.typo3-english at lists.netfielders.de>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Hi,
>
> > I have a external database (not typo3 database) which should get
> > updated
> > when I create new record through TCA , I have created tca.php for
> external
> > database tables. i dont know how to connect external database through
> TCA.
>
> DBAL can do that.
>
> HTH
>
> --
>
> Francois Suter
> Cobweb Development Sarl - http://www.cobweb.ch
>
>
> ------------------------------
>
> Message: 6
> Date: Tue, 22 Apr 2008 23:07:03 +0300
> From: "Dmitry Dulepov [typo3]" <dmitry at typo3.org>
> Subject: Re: [TYPO3] External database table entry with TCA
> To: typo3-english at lists.netfielders.de
> Message-ID:
> <mailman.1.1208894824.27381.typo3-english at lists.netfielders.de>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> abhijit kakade wrote:
> > I have a external database (not typo3 database) which should get
> > updated
> > when I create new record through TCA , I have created tca.php for
> external
> > database tables. i dont know how to connect external database through
> TCA.
>
> TCA does not such updates (unless you have two way relations between
> tables). However you can make a hook to t3lib_TCEmain and catch when records
> are saved to database. At that moment you can update another table. Use
> Google to find something about processDatamap_afterDatabaseOperations.
>
> --
> Dmitry Dulepov
> TYPO3 core team
> Web: http://typo3bloke.net/
> Skype: callto:liels_bugs
> "Nothing is impossible. There are only limits to our knowledge"
>
>
> ------------------------------
>
> Message: 7
> Date: Wed, 23 Apr 2008 00:02:16 +0200
> From: micho edo <micho2 at gmx.de>
> Subject: [TYPO3] print the url of the actual page with simulatestatic
> To: typo3-english at lists.netfielders.de
> Message-ID:
> <mailman.13929.1208901777.3430.typo3-english at lists.netfielders.de>
> Content-Type: text/plain; charset=ISO-8859-15; format=flowed
>
> Hi,
>
> how can I print the url of my page "simulateStatic"-like
>
> TEMP= TEXT
> TEMP {
> field = uid
> wrap = "http://index.php?id=| <http://index.php?id=%7C>"
> }
>
> works, but I want "simulateStatic"-Links
>
>
> ------------------------------
>
> Message: 8
> Date: Wed, 23 Apr 2008 00:08:06 +0200
> From: "Christopher Torgalson" <bedlamhotel at gmail.com>
> Subject: Re: [TYPO3] print the url of the actual page with
> simulatestatic
> To: micho2 at gmx.de, "TYPO3 English"
> <typo3-english at lists.netfielders.de>
> Message-ID:
> <mailman.13934.1208902127.3430.typo3-english at lists.netfielders.de>
> Content-Type: text/plain; charset=ISO-8859-1
>
> Hi,
>
> On Wed, Apr 23, 2008 at 12:02 AM, micho edo <micho2 at gmx.de> wrote:
> > Hi,
> >
> > how can I print the url of my page "simulateStatic"-like
> >
> > TEMP= TEXT
> > TEMP {
> > field = uid
> > wrap = "http://index.php?id=| <http://index.php?id=%7C>"
> > }
>
>
> Search the web (and the TSref!) for "typolink"...
>
>
> --
> Christopher Torgalson
> http://www.typo3apprentice.com/
>
>
> ------------------------------
>
> Message: 9
> Date: Wed, 23 Apr 2008 00:23:38 +0200
> From: micho <micho2 at gmx.de>
> Subject: Re: [TYPO3] print the url of the actual page with
> simulatestatic
> To: typo3-english at lists.netfielders.de
> Message-ID:
> <mailman.1.1208903013.27361.typo3-english at lists.netfielders.de>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> >> how can I print the url of my page "simulateStatic"-like
> >>
> >> TEMP= TEXT
> >> TEMP {
> >> field = uid
> >> wrap = "http://index.php?id=| <http://index.php?id=%7C>"
> >> }
> >
> >
> > Search the web (and the TSref!) for "typolink"...
>
> Thanks.
> I don?t want to produce a Link but to output the url.
>
> Is that possible with typolink?
>
>
> ------------------------------
>
> Message: 10
> Date: Wed, 23 Apr 2008 00:41:33 +0200
> From: micho <micho2 at gmx.de>
> Subject: Re: [TYPO3] print the url of the actual page with
> simulatestatic
> To: typo3-english at lists.netfielders.de
> Message-ID:
> <mailman.1.1208904089.30577.typo3-english at lists.netfielders.de>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> micho schrieb:
> >>> how can I print the url of my page "simulateStatic"-like
> >>>
> >>> TEMP= TEXT
> >>> TEMP {
> >>> field = uid
> >>> wrap = "http://index.php?id=| <http://index.php?id=%7C>"
> >>> }
> >>
> >>
> >> Search the web (and the TSref!) for "typolink"...
> >
> > Thanks.
> > I don?t want to produce a Link but to output the url.
> > Is that possible with typolink?
>
> More Info:
> I want to produce a bookmarklet like this.
>
> <a
> href="
> http://www.mister-wong.de/addurl/?bm_url=URL_OF_ACTUAL_PAGE_SIMULATESTATIC_LIKE&bm_description=TITLE_OF_ACTUAL_PAGE&plugin=soc
> ">
> <img src="images/misterwong.gif"/>
> </a>
>
>
>
> ------------------------------
>
> Message: 11
> Date: Wed, 23 Apr 2008 11:02:16 +0800
> From: Ronald Wiplinger <ronald at elmit.com>
> Subject: [TYPO3] Typo3 server for virtual domains
> To: TYPO3 English <typo3-english at lists.netfielders.de>
> Message-ID:
> <mailman.13985.1208919224.3430.typo3-english at lists.netfielders.de>
> Content-Type: text/plain; charset=ISO-8859-1
>
> I would like to setup a typo3 server as a space for virtual domains.
> Each domain should have its own editing system. I guess we can still use
> only one typo3 installation.
>
> What advices do you have for me?
> It will be an Ubuntu server on a AMD64 environment with LUV harddisk
> architecture.
> After a couple of virtual domains we will move the mysql server onto a
> dedicated only internal reachable machine (private IP).
> How many virtual domains can I handle with Typo3? Where is the limitation?
>
> Can I limit access for some of the extensions to certain users?
> Can I limit the database quota within typo3 or need to limit via mysql?
>
> Spinning that thoughts further, I would like to have a second server at
> another location (far away) and use mysql in a cluster. Do you have any
> hints to that idea? or even experience?
>
>
> bye
>
> R.
>
>
>
>
> ------------------------------
>
> Message: 12
> Date: Wed, 23 Apr 2008 07:38:31 +0200
> From: "Christopher Torgalson" <bedlamhotel at gmail.com>
> Subject: Re: [TYPO3] print the url of the actual page with
> simulatestatic
> To: "TYPO3 English" <typo3-english at lists.netfielders.de>
> Message-ID:
> <mailman.13998.1208929152.3430.typo3-english at lists.netfielders.de>
> Content-Type: text/plain; charset=ISO-8859-1
>
> Hi,
>
> On Wed, Apr 23, 2008 at 12:41 AM, micho <micho2 at gmx.de> wrote:
> > micho schrieb:
> >
> > >>> how can I print the url of my page "simulateStatic"-like
> > >>>
> > >>> TEMP= TEXT
> > >>> TEMP {
> > >>> field = uid
> > >>> wrap = "http://index.php?id=| <http://index.php?id=%7C>"
> > >>> }
> > >>
> > >>
> > >> Search the web (and the TSref!) for "typolink"...
> > >
> > > Thanks.
> > > I don?t want to produce a Link but to output the url.
> > > Is that possible with typolink?
> >
> > More Info:
> > I want to produce a bookmarklet like this.
> >
> > <a
> > href="
> http://www.mister-wong.de/addurl/?bm_url=URL_OF_ACTUAL_PAGE_SIMULATESTATIC_LIKE&bm_description=TITLE_OF_ACTUAL_PAGE&plugin=soc
> ">
> > <img src="images/misterwong.gif"/>
> > </a>
>
>
> As I mentioned, you should check the TSref section on typolink. There
> is a property specifically for this purpose.
>
> --
> Christopher Torgalson
> http://www.typo3apprentice.com/
>
>
> ------------------------------
>
> _______________________________________________
> TYPO3-english mailing list
> TYPO3-english at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
>
> End of TYPO3-english Digest, Vol 55, Issue 73
> *********************************************
>
--
Abhijit Kakade
LAMP Developer,
MCP,CCNA
Mob : +91-9923729250
More information about the TYPO3-english
mailing list