Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#1 2007-12-03 22:45:58

Locutionist
Member
From: The mountains, central PA, USA
Registered: 2005-08-15
Posts: 57
Website

This might be dumb... edit db tables directly?

Greetings all, this might be a dumb question but I’m wondering if there’s any way to edit the pages and styles in Textpattern’s database directly? It would save a lot of time over copy/pasting everything.

Thanks,
—paula

Offline

#2 2007-12-03 23:04:36

ruud
Developer Emeritus
From: a galaxy far far away
Registered: 2006-06-04
Posts: 5,068
Website

Re: This might be dumb... edit db tables directly?

txp_page is a simple table to edit, just the name of the page and the user_html field which contains the page itself.

txp_css is more difficult, because the actual CSS is not stored as plain text, but base64 encoded in the ‘css’ column.

Offline

#3 2007-12-04 21:59:23

Mary
Sock Enthusiast
Registered: 2004-06-27
Posts: 6,236

Re: This might be dumb... edit db tables directly?

How is copying and pasting directly into the db easier than copying and pasting into the admin interface?

Offline

#4 2007-12-04 22:11:11

Locutionist
Member
From: The mountains, central PA, USA
Registered: 2005-08-15
Posts: 57
Website

Re: This might be dumb... edit db tables directly?

I was looking for some way to open up the contents of the database tables in Dreamweaver, or BBEdit, or some other text editor, so that when I save it would save my changes directly into the db rather than having to copy and paste into the Txp admin interface every time. It would speed things up greatly. But, I don’t know if that’s even possible, which is why I asked… but it doesn’t sound like it is given Ruud’s response.

—paula

Last edited by Locutionist (2007-12-04 22:11:52)

Offline

Board footer

Powered by FluxBB