johnnyc

Anonymous
I am new to GeekLog and I am creating a site about antiques.

I would like to be able to upload to table gl_stories, several hundred stories (or in my case info about a specific antique) with a CSV file which I can create, via phpAdmin.

I would also need to upload images for the stories.

What are the minimum fields I need to include other than the story detail fields.

What values would I need to include in the housekeeping fields and are there other tables that need to be updated.

Thanks

johnny

Status: offline

beewee

Forum User
Full Member
Registered: 08/05/03
Posts: 969
I'm no sql expert, but you also need the topics tables. Why not put in your topics, make a few test stories for each topic, download the database and have a look at it?
Dutch Geeklog sites about camping/hiking:
www.kampeerzaken.nl | www.campersite.nl | www.caravans.nl | www.caravans.net

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Hmm, let's see ...

At the very least: sid, uid, tid, date, title, introtext, owner_id

Well, technically uid/owner_id aren't necessary but then all your stories would be owned by "Anonymous".


Converters from other systems are always a problem. People use them once and then don't need them again, so they don't get updated - or even written in the first place. I would hope that changes now that we have out neat "internal API", at least for stories and static pages ...

bye, Dirk