Welcome to Geeklog, Anonymous Tuesday, May 07 2024 @ 03:03 pm EDT

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.









 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?
 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 Confused:

::Ben
I'm available to customise your themes or plugins for your Geeklog CMS
 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.
 Quote

Status: offline

wheelsofterror

Forum User
Regular Poster
Registered: 09/02/06
Posts: 78
Quote by: cordiste

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 Confused:

::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
 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
 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?
 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
 Quote

Status: offline

wheelsofterror

Forum User
Regular Poster
Registered: 09/02/06
Posts: 78
is this good enough?


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 &quot;Night of the Creeps&quot; 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 &quot;*censored* Sucker&quot; 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 &quot;R&quot; 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. &quot;Baby, I love you, Now leave me the *censored* alone!&quot; 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. &quot;13 Seconds&quot; boldly mixes &quot;The Shining&quot;-like chills with the rapid action pacing of &quot;The Terminator&quot; 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 &quot;regular&quot; 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 &quot;Mini Nosferatu&quot;. 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

 
 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

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
 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?
 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
 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."
 Quote

All times are EDT. The time is now 03:03 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