Databases
StackOverflow2013
Postsdbo
POGetting data out of Typo3
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POGetting data out of Typo3
    primarykey
    data
    text
    <p>We have a site we're taking over and porting from typo3 to Orchard. As of right now, all we have is the database and none of the site files. I have the database setup on mysql and can query the data. I don't currently know what version of typo3 it's using. If necessary, I might be able to find out, but as I said, right now all I have is the database.</p> <p>I need to get the data out in a usable form so that I can massage it into the xml needed to import into Orchard. The problem is, I can't find any documentation on how typo3's database is setup, so I've not been able to get at the content...thus far, the only useful table I've found is the "pages" table, but that really seems to just store the instance of a page, minus the content. Here are the things I need:</p> <pre><code>Page Title Parent Page (for hierarchical concerns) Content for a page </code></pre> <p>Can someone shed some light onto what tables I need to look for to pull this content out?</p> <ul> <li>Edit * I was able to get something working using:</li> </ul> <p>What I did was gather the data using this query:</p> <pre><code>select p.Uid PageId, p.pid ParentId, Title, c.BodyText, concat('index.php?id=',p.Uid) OriginalUrl, p.deleted, c.deleted from pages p left join tt_content c on p.Uid = c.Pid where p.deleted = 0 and c.deleted = 0 </code></pre> <p>And then going through each of the tt_content records and concatenating them together to flatten and form somewhat coherent HTML for a page...this is better than nothing. I haven't done anything with the plugins yet, but I do see tx_ tables in there...regardless, this is a start... order by PageId, c.pid</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. UStjans
    1. UStjans
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POGetting data out of Typo3
      1. This table or related slice is empty.
      1. VTUpMod
    1. COAfter searching all morning, I decided to post this question to SO. After posting it, I went back and looked at the db, and apparently there's a tt_content table that I missed completely. I'll look into this...in the meantime, if anyone else has anything to add, please let me know.
      singulars
      1. POGetting data out of Typo3
      1. UStjans
    2. CO**pages** table contains all the pages, **tt_content** table contains all the content of the pages. However, I'm afraid you will soon run into one problem: the content saved in the database is not the same as the one outputted by TYPO3. There are transformations going on that you would have to apply to get the correct HTML output as produced by the original TYPO3 website.
      singulars
      1. POGetting data out of Typo3
      1. UStmt
    3. COSerious? So, is there any way to know how to apply these transformations, or is there a better way to get the data out? If I were able to get an instance of the website up and running, is there an export feature in there?
      singulars
      1. POGetting data out of Typo3
      1. UStjans
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload