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
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
10
14
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
Dutch Geeklog sites about camping/hiking:
www.kampeerzaken.nl | www.campersite.nl | www.caravans.nl | www.caravans.net
10
9
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
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
9
9
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