Welcome to Geeklog, Anonymous Wednesday, November 27 2024 @ 11:58 am EST
Geeklog Forums
importing stories exported as doc
Status: offline
wheelsofterror
Forum User
Regular Poster
Registered: 09/02/06
Posts: 78
I'm not really sure about this next problem. It has been about 2 years since I used geeklog but I saved my stories in a huge 4 megabyte (600+ stories) doc file which I think was either exported as a doc or exported as XML and converted to doc. In any event, it is now a doc.
I'm just wondering what is the best way, if possible, to add these stories into the new database. It's only stories and none of the settings files, etc. I found a 2002 import plug-in for gl and it installed correctly but I can only do one file at a time. This is my backup plan if there is no way to import the entire doc file to the new database. This also brings up the problem of the 1mb limit for database files -- I believe I can send it to godaddy that they can upload it for me but I just need to know if it is a feasible idea.
Thanks again.
I'm just wondering what is the best way, if possible, to add these stories into the new database. It's only stories and none of the settings files, etc. I found a 2002 import plug-in for gl and it installed correctly but I can only do one file at a time. This is my backup plan if there is no way to import the entire doc file to the new database. This also brings up the problem of the 1mb limit for database files -- I believe I can send it to godaddy that they can upload it for me but I just need to know if it is a feasible idea.
Thanks again.
17
15
Quote
Status: offline
wheelsofterror
Forum User
Regular Poster
Registered: 09/02/06
Posts: 78
I never received a response guys. Any advice? Where should I have godaddy upload it?
14
14
Quote
Status: offline
::Ben
Forum User
Full Member
Registered: 01/14/05
Posts: 1569
Location:la rochelle, France
I found a 2002 import plug-in for gl
Hi,
Where is this tool?
Maybe we can make a little modification to allow you to make a multi import at once :
::Ben
I'm available to customise your themes or plugins for your Geeklog CMS
13
11
Quote
Status: offline
1000ideen
Forum User
Full Member
Registered: 08/04/03
Posts: 1298
Check out http://www.mysqldumper.net/ for uploading or downloading larger MySQL files than your webspace settings permit.
If you have a textfile to import, how does GL know e.g. who wrote the story and when and who is allowed to read it? I don`t think there is a tool for this.
If you have a textfile to import, how does GL know e.g. who wrote the story and when and who is allowed to read it? I don`t think there is a tool for this.
18
14
Quote
Status: offline
wheelsofterror
Forum User
Regular Poster
Registered: 09/02/06
Posts: 78
Quote by: cordiste
Hi,
Where is this tool?
Maybe we can make a little modification to allow you to make a multi import at once :
::Ben
I found a 2002 import plug-in for gl
Hi,
Where is this tool?
Maybe we can make a little modification to allow you to make a multi import at once :
::Ben
It's an old 2002 plugin, well, just a php file, so not sure how great it is or what you guys can do with it.
http://www.geeklog.net/filemgmt/index.php?id=70&query=import
thanks
John
16
15
Quote
Status: offline
wheelsofterror
Forum User
Regular Poster
Registered: 09/02/06
Posts: 78
Quote by: 1000ideen
Check out http://www.mysqldumper.net/ for uploading or downloading larger MySQL files than your webspace settings permit.
If you have a textfile to import, how does GL know e.g. who wrote the story and when and who is allowed to read it? I don`t think there is a tool for this.
The doc has categories, ratings, and other info in tables and it says "Dumping data for table gl_stories." I can send the near 4mb doc to you if you tell me where to see what I can do with what I have. LMK
John
17
16
Quote
Status: offline
wheelsofterror
Forum User
Regular Poster
Registered: 09/02/06
Posts: 78
what about this...is there a way to convert the doc back to an sql database?
15
14
Quote
Status: offline
::Ben
Forum User
Full Member
Registered: 01/14/05
Posts: 1569
Location:la rochelle, France
Hi;
Can you paste an excerpt from here (using code bbtag) to see what form information is stored.
Thanks,
::Ben
I'm available to customise your themes or plugins for your Geeklog CMS
Can you paste an excerpt from here (using code bbtag) to see what form information is stored.
Thanks,
::Ben
I'm available to customise your themes or plugins for your Geeklog CMS
12
14
Quote
Status: offline
wheelsofterror
Forum User
Regular Poster
Registered: 09/02/06
Posts: 78
is this good enough?
Database thebloodcafe41
Table structure for table gl_stories
Field Type Null Default
sid varchar(40) No
uid mediumint(8) No 1
draft_flag tinyint(3) Yes 0
tid varchar(20) No General
date datetime Yes NULL
title varchar(128) Yes NULL
introtext text Yes NULL
bodytext text Yes NULL
hits mediumint(8) No 0
numemails mediumint(8) No 0
comments mediumint(8) No 0
trackbacks mediumint(8) No 0
related text Yes NULL
featured tinyint(3) No 0
show_topic_icon tinyint(1) No 1
commentcode tinyint(4) No 0
trackbackcode tinyint(4) No 0
statuscode tinyint(4) No 0
expire datetime No 0000-00-00 00:00:00
postmode varchar(10) No html
advanced_editor_mode tinyint(1) Yes 0
frontpage tinyint(3) Yes 1
in_transit tinyint(1) Yes 0
owner_id mediumint(8) No 1
group_id mediumint(8) No 2
perm_owner tinyint(1) No 3
perm_group tinyint(1) No 3
perm_members tinyint(1) No 2
perm_anon tinyint(1) No 2
Dumping data for table gl_stories
Reviews-Movies-Slither-2006 2 0 Reviews-Movies 2006-09-10 17:45:36 Slither (2006) Reviewed by Jonathon Knight <img width="101" height="150" align="left" src="http://www.wheelsofterror.com/images/articles/Reviews-Movies-Slither-2006_1.jpg" alt=""> Taglines: What's Gotten Into You? Horror Has a New Face From the people that brought you 2004's Dawn of the Dead Slug it out. Synopsis: In this blend of the B movie classic The Blob (1958) and some Romero's zombies film, a meteorite collides in a small town. Grant finds it, and is infected by a parasite worm, which installs in his brain and causes him a creepy transformation into a monster. Starla, his wife, and Bill, a policeman, will try to stop him and the plague of worms generated by the creature. -IMDB Meat for the Beast: In my useless opinion, 2006 has been a great year for horror movies so far. When Slither was released in theaters in March, I missed it. I was disappointed that it bombed in theaters and now I have finally had the chance to sit down and view the well reviewed horror movie. What did I think of Slither? well, to tell you the truth, Slither was one hell of a good time, that's for sure! Slither reminded me of the 1986 horror film "Night of the Creeps" at times, with a mix of The Blob, The Thing, Basket Case and others, I mucho dug it! Slither had the gore, the laughs and all the action I needed in a 90 minute horror movie. I was busting a gut and looking away in disgust, at the same time! Thank you James Gunn for delivering a homage to those great horror film's of the 80's. The Cast is fantastic, no doubt about that. Elizabeth Banks was fantastic as Starla, the woman of everyone's desire. She was sexy, classy and kicked ass when ass needed to be kicked. Loved her! I've been a fan of Nathan Fillion since his Firefly days and loved him here. He's Funny, Charming and had some of the best reactions I've seen in a horror movie in awhile. Gregg Henry was great as the mayor who's delivery of the word "*censored* Sucker" was great, He says that magic word with such pride, you go boy! Michael Rooker is fantastic as Grant, who becomes the main villain of the movie. He plays an asshole with some heart, so to speak. Great Job all around! The Direction by James Gunn is great, doing great at both comedic timing and suspense (specially during the Slugs in the house scene). The movie has a fast pace and looks great, overall. Good Show Mr. Gunn! The Music by Tyler Bates was both Fun and Creepy at the same time and I really dug it. Not the forgettable trash I'm used to. The movie uses it "R" rating well. People are spilt in two (*censored*ing nice!), stabbed with tentacles, posts are jammed in necks, heads are blown off and some more. Good Stuff overall. The FX is practical with CGI enhancements. The Practical FX was done by Todd Masters (Of Demon Knight) and looks fantastic. The main monster of the movie looks like an overgrown version of Belial from Basket Case and looks great. The CGI looks good without looking crappy or fantastic but it serves the movie well and never distracts you. Did I have any problems with Slither? Well, to tell you the truth, I thought this movie would be much more. I thought there would be more gore, more zombie and slug action etc. What was there was enough, but being the greedy horror fan I am, I expected more. Slither was one hell of a fun time still and was one of the more entertaining movies of the year. On October 24th, pick a copy up and prepare to have a blast. "Baby, I love you, Now leave me the *censored* alone!" Yeah, you heard me! Highly Recommended. 4/5 Cast/Characters: Nathan Fillion .... Bill Pardy Elizabeth Banks .... Starla Grant Gregg Henry .... Jack MacReady Michael Rooker .... Grant Grant Tania Saulnier .... Kylie Strutemyer Don Thompson .... Wally Xantha Radley .... Uptight Mom Brenda James .... Brenda Gutierrez Jenna Fischer .... Shelby Dustin Milligan .... Drawing Boy Jennifer Copping .... Margaret Haig Sutherland .... Trevor Zak Ludwig .... Gina Kid Kathryn Kirkpatrick .... Karaoke Woman Lorena Gale .... Janene Bart Anderson .... Butcher Corby Lund .... Lead Singer (as Corb Lund) Rob Zombie .... Dr. Karl (voice) Lloyd Kaufman .... Sad Drunk Tom Heaton .... Tourneur Ben Cotton .... Charlie Dee Jay Jackson .... Dwight Matreya Fedor .... Emily Strutemyer Amber Lee Bartlett .... Jenna Strutemyer William MacDonald .... Mr. Strutemyer Iris Quinn .... Mrs. Strutemyer Michael Cromien .... Fitzgibbon Robert Musnicki .... Diseased Leader Stephen Park .... Gleeked-on Guy Mary Black .... Woman in Basement Malcolm Scott .... Dude Joining Grant Nicholas Podbrey .... Diseased Grant #1 Jeny Cassady .... Diseased Grant #2 Alette Falle .... Diseased Grant #3 Darren Shahlavi .... Brenda's Husband Matt McInnis .... Head-Shot Norman (as Matthew McInnis) James Gunn .... Hank (uncredited) Directed by James Gunn Writing credits (WGA) James Gunn (written by) [rating:Reviews-Movies-Slither-2006 0 5 141] 110 0 0 0 0 1 0 0 10 2006-09-10 17:45:36 plaintext 0 1 0 2 3 3 2 2 2
Reviews-Movies-13Seconds-2003 2 0 Reviews-Movies 2006-09-10 18:04:35 13 Seconds (2003) Reviewed by John Gugie <img width="133" height="150" align="left" src="http://www.wheelsofterror.com/images/articles/Reviews-Movies-13Seconds-2003_1.jpg" alt=""> Taglines: Time is running out Synopsis: A sprawling turn of the century academy, a billboard charts band fueled by deceit, and an art gallery that comes to life with graphic paintings revealing each character dying a horrible death that begins to hint at the real terror lurking behind every one of us. "13 Seconds" boldly mixes "The Shining"-like chills with the rapid action pacing of "The Terminator" which challenges the viewer to solve its mystery. It is a compelling thriller that devilishly destroys one cliché after another while speeding towards a shocking, surprise ending that comes complete with crawlspace chases, séances, a malevolent art gallery, and an unstoppable evil older than time itself. -IMDB Meat for the Beast: This review will cover this as a film and an independent film to be fair due to the different factors in budget and production. I don't sugar coat my reviews so it will be fair. First off, as a "regular" film, I found this mediocre in several ways. The weakest part is the acting. Most of the acting is horrendously bad - it's obviously most, if not all, of the actors have had no previous acting experience. Most of the dialogue isn't very good but a few parts near the end had slightly better lines. As a low-budget, independent horror film this is one of the better ones that I've seen. The acting is bad but you have to expect it with these type of films. Bare in mind that this is Jeff Thomas' first full-length film in which he directs, writes and acts. With that said, Jeff has talent which will get better with time and a better budget. This is in need of better editing and better dialogue and it would be much better. The story isn't very original but not bad. I found that a few different plot devices are employed, which might be better used separately and more fully developed. It needs more focus. Onto the good aspects of this film. The atmosphere. It has a great atmosphere considering the budget. It's moody with good use of shadow and angles. There is great tension, enhanced by the soundtrack. I've seen other reviews criticize the placement of the tense music versus the lighter music but I think it is fine. The most often used piece, the theme, is very tense and suspenseful. While listening to it, I feel the need to look behind me or run (roll) from a stalking killer. The setting is perfect for this type of film - an old school with lots of long, empty and turning corridors and places to hide, like a maze. Now, while most of the acting is bad, it's not a total waste. I found Robert Yensch, as Colin, to be the best actor of the lot. His face actually seemed to portray emotion while delivery his lines. Jeff Thomas, as Davis, is the second best actor here. He is definitely the most animated. The SFX are very good for an independent film. They're gory enough albeit the blood seems a little too light-colored at times. The arm through guy's chest is great! I had to re-watch that scene several times. The crucification-like scene is pretty good. But my favorite special effect is the under-used vampire boy, or as I like to call him "Mini Nosferatu". He gave me nightmares! The hooded axe men are okay but what's with their head shaking? Is it a low-budget emulation of their head turning around 360 degrees or to show a surreal nightmare-like world? I think it looks weird. Jason Voorhees is scary without the caffeine jitters. Some say the film looks gritty. I like it. It's sort of hazy which adds a realistic look to it. It's pretty uniform throughout. The audio needs work. At several points the volume level changed drastically. I found one outdoor scene in the beginning to be especially bad, to the point that I could barely hear it. Besides this scene, the rest is sufficient. Overall, this is a very good first-time effort from a promising new director. If you can overlook the irregularities and bad acting and judge this AS a low-budget independent horror film, you'll like this film. As a movie, I give this a 2 out of 3. But, judging it as an independent film, I give it a 3. If you like independent horror film, you'll like this. If you're new to independent films, this is a good start. Worth a view. Cast/Characters: April Cole .... Kara Daniel Rain .... Gage Kevin Kuras .... Mac Robert Yensch .... Colin Sarah Corbin .... Talia Spencer Stevens .... Musato Stuart Stevens .... Teen Killer Ren Smith .... Teen Killer Daniel Rowe .... Adramalech Melissa Hoffman .... Flashback Mother Nick Hoffman .... Musato #2 Emily Howard .... Musato #3 Esa Scott .... Shapiro Robert Miller .... Sidetrack Jeff Thomas .... Davis Directed by Jeff Thomas Writing credits Jeff Thomas [rating:Reviews-Movies-13Seconds-2003 0 5 141] 125 0 0 0 0 1 0 0 10 2006-09-10 18:04:35 plaintext 0 1 0 2 3 3 2 2 2
Text Formatted Code
Database thebloodcafe41
Table structure for table gl_stories
Field Type Null Default
sid varchar(40) No
uid mediumint(8) No 1
draft_flag tinyint(3) Yes 0
tid varchar(20) No General
date datetime Yes NULL
title varchar(128) Yes NULL
introtext text Yes NULL
bodytext text Yes NULL
hits mediumint(8) No 0
numemails mediumint(8) No 0
comments mediumint(8) No 0
trackbacks mediumint(8) No 0
related text Yes NULL
featured tinyint(3) No 0
show_topic_icon tinyint(1) No 1
commentcode tinyint(4) No 0
trackbackcode tinyint(4) No 0
statuscode tinyint(4) No 0
expire datetime No 0000-00-00 00:00:00
postmode varchar(10) No html
advanced_editor_mode tinyint(1) Yes 0
frontpage tinyint(3) Yes 1
in_transit tinyint(1) Yes 0
owner_id mediumint(8) No 1
group_id mediumint(8) No 2
perm_owner tinyint(1) No 3
perm_group tinyint(1) No 3
perm_members tinyint(1) No 2
perm_anon tinyint(1) No 2
Dumping data for table gl_stories
Reviews-Movies-Slither-2006 2 0 Reviews-Movies 2006-09-10 17:45:36 Slither (2006) Reviewed by Jonathon Knight <img width="101" height="150" align="left" src="http://www.wheelsofterror.com/images/articles/Reviews-Movies-Slither-2006_1.jpg" alt=""> Taglines: What's Gotten Into You? Horror Has a New Face From the people that brought you 2004's Dawn of the Dead Slug it out. Synopsis: In this blend of the B movie classic The Blob (1958) and some Romero's zombies film, a meteorite collides in a small town. Grant finds it, and is infected by a parasite worm, which installs in his brain and causes him a creepy transformation into a monster. Starla, his wife, and Bill, a policeman, will try to stop him and the plague of worms generated by the creature. -IMDB Meat for the Beast: In my useless opinion, 2006 has been a great year for horror movies so far. When Slither was released in theaters in March, I missed it. I was disappointed that it bombed in theaters and now I have finally had the chance to sit down and view the well reviewed horror movie. What did I think of Slither? well, to tell you the truth, Slither was one hell of a good time, that's for sure! Slither reminded me of the 1986 horror film "Night of the Creeps" at times, with a mix of The Blob, The Thing, Basket Case and others, I mucho dug it! Slither had the gore, the laughs and all the action I needed in a 90 minute horror movie. I was busting a gut and looking away in disgust, at the same time! Thank you James Gunn for delivering a homage to those great horror film's of the 80's. The Cast is fantastic, no doubt about that. Elizabeth Banks was fantastic as Starla, the woman of everyone's desire. She was sexy, classy and kicked ass when ass needed to be kicked. Loved her! I've been a fan of Nathan Fillion since his Firefly days and loved him here. He's Funny, Charming and had some of the best reactions I've seen in a horror movie in awhile. Gregg Henry was great as the mayor who's delivery of the word "*censored* Sucker" was great, He says that magic word with such pride, you go boy! Michael Rooker is fantastic as Grant, who becomes the main villain of the movie. He plays an asshole with some heart, so to speak. Great Job all around! The Direction by James Gunn is great, doing great at both comedic timing and suspense (specially during the Slugs in the house scene). The movie has a fast pace and looks great, overall. Good Show Mr. Gunn! The Music by Tyler Bates was both Fun and Creepy at the same time and I really dug it. Not the forgettable trash I'm used to. The movie uses it "R" rating well. People are spilt in two (*censored*ing nice!), stabbed with tentacles, posts are jammed in necks, heads are blown off and some more. Good Stuff overall. The FX is practical with CGI enhancements. The Practical FX was done by Todd Masters (Of Demon Knight) and looks fantastic. The main monster of the movie looks like an overgrown version of Belial from Basket Case and looks great. The CGI looks good without looking crappy or fantastic but it serves the movie well and never distracts you. Did I have any problems with Slither? Well, to tell you the truth, I thought this movie would be much more. I thought there would be more gore, more zombie and slug action etc. What was there was enough, but being the greedy horror fan I am, I expected more. Slither was one hell of a fun time still and was one of the more entertaining movies of the year. On October 24th, pick a copy up and prepare to have a blast. "Baby, I love you, Now leave me the *censored* alone!" Yeah, you heard me! Highly Recommended. 4/5 Cast/Characters: Nathan Fillion .... Bill Pardy Elizabeth Banks .... Starla Grant Gregg Henry .... Jack MacReady Michael Rooker .... Grant Grant Tania Saulnier .... Kylie Strutemyer Don Thompson .... Wally Xantha Radley .... Uptight Mom Brenda James .... Brenda Gutierrez Jenna Fischer .... Shelby Dustin Milligan .... Drawing Boy Jennifer Copping .... Margaret Haig Sutherland .... Trevor Zak Ludwig .... Gina Kid Kathryn Kirkpatrick .... Karaoke Woman Lorena Gale .... Janene Bart Anderson .... Butcher Corby Lund .... Lead Singer (as Corb Lund) Rob Zombie .... Dr. Karl (voice) Lloyd Kaufman .... Sad Drunk Tom Heaton .... Tourneur Ben Cotton .... Charlie Dee Jay Jackson .... Dwight Matreya Fedor .... Emily Strutemyer Amber Lee Bartlett .... Jenna Strutemyer William MacDonald .... Mr. Strutemyer Iris Quinn .... Mrs. Strutemyer Michael Cromien .... Fitzgibbon Robert Musnicki .... Diseased Leader Stephen Park .... Gleeked-on Guy Mary Black .... Woman in Basement Malcolm Scott .... Dude Joining Grant Nicholas Podbrey .... Diseased Grant #1 Jeny Cassady .... Diseased Grant #2 Alette Falle .... Diseased Grant #3 Darren Shahlavi .... Brenda's Husband Matt McInnis .... Head-Shot Norman (as Matthew McInnis) James Gunn .... Hank (uncredited) Directed by James Gunn Writing credits (WGA) James Gunn (written by) [rating:Reviews-Movies-Slither-2006 0 5 141] 110 0 0 0 0 1 0 0 10 2006-09-10 17:45:36 plaintext 0 1 0 2 3 3 2 2 2
Reviews-Movies-13Seconds-2003 2 0 Reviews-Movies 2006-09-10 18:04:35 13 Seconds (2003) Reviewed by John Gugie <img width="133" height="150" align="left" src="http://www.wheelsofterror.com/images/articles/Reviews-Movies-13Seconds-2003_1.jpg" alt=""> Taglines: Time is running out Synopsis: A sprawling turn of the century academy, a billboard charts band fueled by deceit, and an art gallery that comes to life with graphic paintings revealing each character dying a horrible death that begins to hint at the real terror lurking behind every one of us. "13 Seconds" boldly mixes "The Shining"-like chills with the rapid action pacing of "The Terminator" which challenges the viewer to solve its mystery. It is a compelling thriller that devilishly destroys one cliché after another while speeding towards a shocking, surprise ending that comes complete with crawlspace chases, séances, a malevolent art gallery, and an unstoppable evil older than time itself. -IMDB Meat for the Beast: This review will cover this as a film and an independent film to be fair due to the different factors in budget and production. I don't sugar coat my reviews so it will be fair. First off, as a "regular" film, I found this mediocre in several ways. The weakest part is the acting. Most of the acting is horrendously bad - it's obviously most, if not all, of the actors have had no previous acting experience. Most of the dialogue isn't very good but a few parts near the end had slightly better lines. As a low-budget, independent horror film this is one of the better ones that I've seen. The acting is bad but you have to expect it with these type of films. Bare in mind that this is Jeff Thomas' first full-length film in which he directs, writes and acts. With that said, Jeff has talent which will get better with time and a better budget. This is in need of better editing and better dialogue and it would be much better. The story isn't very original but not bad. I found that a few different plot devices are employed, which might be better used separately and more fully developed. It needs more focus. Onto the good aspects of this film. The atmosphere. It has a great atmosphere considering the budget. It's moody with good use of shadow and angles. There is great tension, enhanced by the soundtrack. I've seen other reviews criticize the placement of the tense music versus the lighter music but I think it is fine. The most often used piece, the theme, is very tense and suspenseful. While listening to it, I feel the need to look behind me or run (roll) from a stalking killer. The setting is perfect for this type of film - an old school with lots of long, empty and turning corridors and places to hide, like a maze. Now, while most of the acting is bad, it's not a total waste. I found Robert Yensch, as Colin, to be the best actor of the lot. His face actually seemed to portray emotion while delivery his lines. Jeff Thomas, as Davis, is the second best actor here. He is definitely the most animated. The SFX are very good for an independent film. They're gory enough albeit the blood seems a little too light-colored at times. The arm through guy's chest is great! I had to re-watch that scene several times. The crucification-like scene is pretty good. But my favorite special effect is the under-used vampire boy, or as I like to call him "Mini Nosferatu". He gave me nightmares! The hooded axe men are okay but what's with their head shaking? Is it a low-budget emulation of their head turning around 360 degrees or to show a surreal nightmare-like world? I think it looks weird. Jason Voorhees is scary without the caffeine jitters. Some say the film looks gritty. I like it. It's sort of hazy which adds a realistic look to it. It's pretty uniform throughout. The audio needs work. At several points the volume level changed drastically. I found one outdoor scene in the beginning to be especially bad, to the point that I could barely hear it. Besides this scene, the rest is sufficient. Overall, this is a very good first-time effort from a promising new director. If you can overlook the irregularities and bad acting and judge this AS a low-budget independent horror film, you'll like this film. As a movie, I give this a 2 out of 3. But, judging it as an independent film, I give it a 3. If you like independent horror film, you'll like this. If you're new to independent films, this is a good start. Worth a view. Cast/Characters: April Cole .... Kara Daniel Rain .... Gage Kevin Kuras .... Mac Robert Yensch .... Colin Sarah Corbin .... Talia Spencer Stevens .... Musato Stuart Stevens .... Teen Killer Ren Smith .... Teen Killer Daniel Rowe .... Adramalech Melissa Hoffman .... Flashback Mother Nick Hoffman .... Musato #2 Emily Howard .... Musato #3 Esa Scott .... Shapiro Robert Miller .... Sidetrack Jeff Thomas .... Davis Directed by Jeff Thomas Writing credits Jeff Thomas [rating:Reviews-Movies-13Seconds-2003 0 5 141] 125 0 0 0 0 1 0 0 10 2006-09-10 18:04:35 plaintext 0 1 0 2 3 3 2 2 2
16
18
Quote
Status: offline
::Ben
Forum User
Full Member
Registered: 01/14/05
Posts: 1569
Location:la rochelle, France
Maybe you could try this:
1. Remove the structure from your doc file
Database thebloodcafe41
Table structure for table gl_stories
Field Type Null Default
sid varchar(40) No
uid mediumint(8) No 1
draft_flag tinyint(3) Yes 0
tid varchar(20) No General
date datetime Yes NULL
title varchar(128) Yes NULL
introtext text Yes NULL
bodytext text Yes NULL
hits mediumint(8) No 0
numemails mediumint(8) No 0
comments mediumint(8) No 0
trackbacks mediumint(8) No 0
related text Yes NULL
featured tinyint(3) No 0
show_topic_icon tinyint(1) No 1
commentcode tinyint(4) No 0
trackbackcode tinyint(4) No 0
statuscode tinyint(4) No 0
expire datetime No 0000-00-00 00:00:00
postmode varchar(10) No html
advanced_editor_mode tinyint(1) Yes 0
frontpage tinyint(3) Yes 1
in_transit tinyint(1) Yes 0
owner_id mediumint(8) No 1
group_id mediumint(8) No 2
perm_owner tinyint(1) No 3
perm_group tinyint(1) No 3
perm_members tinyint(1) No 2
perm_anon tinyint(1) No 2
Dumping data for table gl_stories
2. Export your doc to a csv file
3. In phpmyadmin Import your new cvs file into your database.
::Ben
I'm available to customise your themes or plugins for your Geeklog CMS
1. Remove the structure from your doc file
Text Formatted Code
Database thebloodcafe41
Table structure for table gl_stories
Field Type Null Default
sid varchar(40) No
uid mediumint(8) No 1
draft_flag tinyint(3) Yes 0
tid varchar(20) No General
date datetime Yes NULL
title varchar(128) Yes NULL
introtext text Yes NULL
bodytext text Yes NULL
hits mediumint(8) No 0
numemails mediumint(8) No 0
comments mediumint(8) No 0
trackbacks mediumint(8) No 0
related text Yes NULL
featured tinyint(3) No 0
show_topic_icon tinyint(1) No 1
commentcode tinyint(4) No 0
trackbackcode tinyint(4) No 0
statuscode tinyint(4) No 0
expire datetime No 0000-00-00 00:00:00
postmode varchar(10) No html
advanced_editor_mode tinyint(1) Yes 0
frontpage tinyint(3) Yes 1
in_transit tinyint(1) Yes 0
owner_id mediumint(8) No 1
group_id mediumint(8) No 2
perm_owner tinyint(1) No 3
perm_group tinyint(1) No 3
perm_members tinyint(1) No 2
perm_anon tinyint(1) No 2
Dumping data for table gl_stories
2. Export your doc to a csv file
3. In phpmyadmin Import your new cvs file into your database.
::Ben
I'm available to customise your themes or plugins for your Geeklog CMS
12
13
Quote
Status: offline
wheelsofterror
Forum User
Regular Poster
Registered: 09/02/06
Posts: 78
Hmm, I'll try that but will the database recognize the tables and how to apply them to the site?
13
16
Quote
Status: offline
::Ben
Forum User
Full Member
Registered: 01/14/05
Posts: 1569
Location:la rochelle, France
You must remove the entire structure and all that is not related to the gl_stories table. Then under the gl_stories table import your cvs file.
::Ben
I'm available to customise your themes or plugins for your Geeklog CMS
::Ben
I'm available to customise your themes or plugins for your Geeklog CMS
13
14
Quote
Status: offline
wheelsofterror
Forum User
Regular Poster
Registered: 09/02/06
Posts: 78
I received the error: "Invalid field count in CSV input on line 1."
15
18
Quote
All times are EST. The time is now 11:58 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