[TYPO3-dev] Creating pages in Typo3 with external script

[Stephan Schuler]

Hey there.

I wouldn't try to inject data into the TYPO3 database without using the internal PHP API. There are tons of things to take care of. Like authors, workspace overlays, translations, history data, diffs inside of those history data, sorting, access privileges, maybe flex when it comes to different plugin inline configuration ...

You really should at least think about creating some kind of limited API. You could either create a specific web service or a CLI, depending on how you're going to push data to TYPO3.

There was some rest/restful/restlike API as a foreign project, but this seems to be out of date.

Whatever you do: Throwing plain insert/update queries against the database easily leads to corrupt data, even though you might not realize that in the first place. You definitively can solve your problem without that API, but depending on the complexity it might be a more stable thing with it.

Regards,


Stephan Schuler
Web-Entwickler

Telefon: +49 (911) 539909 - 0
E-Mail: Stephan.Schuler at netlogix.de
Website: media.netlogix.de



--------------------
Geben Sie Cyber-Kriminellen keine Chance
Lückenloser Schutz mit Security-Lösungen von Sophos: Erfahren Sie, wie Sie Ihr Unternehmen wirksam schützen und gewinnen Sie einen Boomball Pro Mini-Lautsprecher:
https://www.cyber-gesindel-a.de/netlogix
--------------------



--
netlogix GmbH & Co. KG
IT-Services | IT-Training | Media
Neuwieder Straße 10 | 90411 Nürnberg
Telefon: +49 (911) 539909 - 0 | Fax: +49 (911) 539909 - 99
E-Mail: info at netlogix.de | Internet: http://www.netlogix.de

netlogix GmbH & Co. KG ist eingetragen am Amtsgericht Nürnberg (HRA 13338)
Persönlich haftende Gesellschafterin: netlogix Verwaltungs GmbH (HRB 20634)
Umsatzsteuer-Identifikationsnummer: DE 233472254
Geschäftsführer: Stefan Buchta, Matthias Schmidt



________________________________________
Von: typo3-dev-bounces at lists.typo3.org [typo3-dev-bounces at lists.typo3.org]" im Auftrag von "Alexander Födisch [foedisch at eva.mpg.de]
Gesendet: Montag, 10. Februar 2014 10:21
An: List for Core-/Extension development
Betreff: Re: [TYPO3-dev] Creating pages in Typo3 with external script

Ok, I found this for doktype:
http://lists.typo3.org/pipermail/typo3-project-documentation/2010-January/002461.html



Am 10.02.2014 10:10, schrieb Stefan Neufeind:
> On 02/10/2014 10:08 AM, Alexander Födisch wrote:
>> Hi,
>>
>> how can I create pages scripted with SQL-statements?
>>
>> I need to create for example page1-page4:
>>
>> page-already-exists
>>      |-page1
>>              |-page2
>>              |-page3
>>              |-page4
>>
>>
>> Createing a page is quite easy:
>>      INSERT INTO pages (title) VALUES ('<title>');  (of course we have to
>> set also other values like timestamps, crdate.....)
>>
>> But how does Typo organize the relationship/assignment of pages and
>> their subpages?
> Their parent-pade is given in the column "pid". The new page is just a
> record that is placed "on the parent-page".
> Also note the sorting-number to properly order your pages.
>
>
> Kind regards,
>   Stefan
> _______________________________________________
> TYPO3-dev mailing list
> TYPO3-dev at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-dev

_______________________________________________
TYPO3-dev mailing list
TYPO3-dev at lists.typo3.org
http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-dev