Welcome to Geeklog, Anonymous Sunday, December 22 2024 @ 08:08 am EST

Geeklog Forums

Adding new stories: In Bulk


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
 Quote

Status: offline

beewee

Forum User
Full Member
Registered: 08/05/03
Posts: 969
Location:The Netherlands, where else?
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
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
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
 Quote

All times are EST. The time is now 08:08 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content