Welcome to Geeklog, Anonymous Thursday, March 28 2024 @ 01:54 pm EDT
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
2
2
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
4
2
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
3
3
Quote
All times are EDT. The time is now 01:54 pm.
- 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