Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#1 2007-01-19 15:17:47

Zanza
Plugin Author
Registered: 2005-08-18
Posts: 699
Website

Import from file in the db

I have to import a long number of short articles from a text file format. Is there a way to use a sql syntax to do this automatically? Can someone post an example o reference to an existing one?

I don’t know how this could be done and how many db table are involved. I’m not a programmer, so any tips would be apreciated. Thanks.

Z-

Offline

#2 2007-01-19 15:55:02

mrdale
Member
From: Walla Walla
Registered: 2004-11-19
Posts: 2,215
Website

Re: Import from file in the db

Try formatting those articles in a text editor and using the Import feature . I did it once using movable type file format and it worked out pretty good.

You’ll have to check out the formatting rules first.

Updated to add link to MT import formatting rules

Last edited by mrdale (2007-01-19 16:11:51)

Offline

#3 2007-01-19 17:24:06

Zanza
Plugin Author
Registered: 2005-08-18
Posts: 699
Website

Re: Import from file in the db

Oh-oh-ooooh!… I totally missed that feature (thought was for importing from other blog tools only!).

Looks exactly what I was looking for! I’ll give it a check. Thanks very much, Mrdale!

Z-

Last edited by Zanza (2007-01-19 17:30:39)

Offline

#4 2007-01-19 17:27:33

mrdale
Member
From: Walla Walla
Registered: 2004-11-19
Posts: 2,215
Website

Re: Import from file in the db

:) no problem

Offline

Board footer

Powered by FluxBB