I am converting a blog site from GoDaddy "QuickBlogCast" to a mySQL database. The Go Daddy admin will only give me an export to .txt that is not formatted to be easily uploaded into mySQL.
This project is to take 133 blog posts and put them into a tab-delimited format so I can upload it into mySQL.
Here are the fields:
Author:
Title:
Status:
Allow Comments:
Allow Pings:
Category:
Date/Time:
BlogPost:
Picture:
Here is a typical post:
AUTHOR: Wade Nelson
TITLE: Best Insulation Layer Jacket - Marmot TR6 Jacket - Best Insulation Liner Jacket
STATUS: Published
ALLOW COMMENTS: 1
ALLOW PINGS: 1
CATEGORY: Insulation Layer
DATE: 3/15/2008 9:04:00 PM
-----
BODY:
<FONT size=3>I have had a chance to spend some&nbsp;more time in&nbsp;my new&nbsp;<A href="http://marmot.com/fall_2007/mens/outerwear/insulated/tr6_jacket/" target=_blank>TR6 Jacket from Marmot</A>.&nbsp; As my regular readers know, my favorite insulation layer jacket has been the Cirrus Jacket from Moonstone but Moonstone is out of business and the Cirrus is no longer available.&nbsp; I like the Cirrus because it is a no non-sense, short waisted liner,&nbsp;no hood, just two pockets and pit zips.&nbsp; The Cirrus has performed admirably for me in many, many situations.&nbsp; But since this site exists to recommend great gear to you, I had to find something comparable that is&nbsp;available.<BR><BR><IMG src="http://images.quickblogcast.com/41813-38276/wade_marmot_TR6_web.jpg" width=640 border=0><BR><EM><FONT size=1><FONT size=2>The TR6 jacket is a little longer then the Cirrus Jacket.&nbsp;&nbsp;Man, I gotta cut some weight.&nbsp;&nbsp;Pizza and chips and salsa are my weakness.&nbsp;&nbsp;Not together.&nbsp; Well, sometimes.&nbsp; No&nbsp;ice cream though.&nbsp; Never ice cream.<BR></FONT><BR></FONT></EM>There are a lot of these kinds of jackets on the market but dam few of them have <STRONG>pit zips</STRONG> which is a big deal with me.&nbsp; In fact, the TR6 might be the only liner jacket currently available with that feature.&nbsp; Why?&nbsp; I don't know but it makes no sense to me.&nbsp; Well, actually, I think it is because most designers are not hardcore users and have never had to keep their insulation layer on why they broke a sweat.&nbsp; But the whole designer thing is a much bigger issue that&nbsp;requires it's own rant, er, article.&nbsp; Don't worry, it is coming and I can assure you that it is going to ruffle some feathers.&nbsp; <BR><BR>Anyway, the Cirrus Jacket is 20 ounces and insulated with Thermolite.&nbsp; The TR6 Jacket is 26 ounces and&nbsp;uses Marmaloft.&nbsp; It is not as short as the Cirrus but it does have elastic draw cords at the hem so you can blouse it if you need to.&nbsp; The TR6 has two hand pockets and a&nbsp;Napoleon&nbsp;pocket on the left chest.&nbsp; I like the Napoleon pocket for keeping batteries warm or my IPod or cel phone close.&nbsp; The TR6 is not as light as the Cirrus because it has more insulation and I am just fine with that.&nbsp; It is not belay thickness,&nbsp;I would go with a&nbsp;</FONT><A href="http://www.westernmountaineering.com/index.cfm" target=_blank><FONT size=3>Western Mountaineering</FONT></A><FONT size=3> Meltdown Jacket or a&nbsp;</FONT><A href="http://www.nunatakusa.com/site07/garments/torre.htm" target=_blank><FONT size=3>Nunatak Torre Down Parka (Microlight)</FONT></A><FONT size=3>&nbsp;but it is not liner wispy either.&nbsp; For that I would go to the </FONT><A href="[login to view URL];amp;p_id=2301221" target=_blank><FONT size=3>Mont-Bell U.L. Thermawrap Jacket</FONT></A><FONT size=3>&nbsp;which&nbsp;uses&nbsp;synthetic insulation.&nbsp; It is a very nice&nbsp;piece but would be better if I can get them to put pit zips in this year like they did with some of their other products.<BR><BR><IMG src="http://images.quickblogcast.com/41813-38276/wade_ranger_carhart_web.jpg" width=640 border=0><BR><EM><FONT size=1><FONT size=2>The Marmot TR6 Jacket fits nicely under the&nbsp;</FONT><A href="[login to view URL];amp;catalogId=10101" target=_blank><FONT size=2>Carhartt</FONT></A><FONT size=2> Waterproof/Breathable Jacket.&nbsp;&nbsp;Those are&nbsp;</FONT><A href="http://www.511tactical.com/" target=_blank><FONT size=2>5.11</FONT></A><FONT size=2> TRT&nbsp;Pants,&nbsp;</FONT><A href="http://www.danner.com/home.do" target=_blank><FONT size=2>Danner</FONT></A><FONT size=2> Quarry GTX boots and&nbsp;</FONT><A href="http://www.danalco.com/Hanz.shtml" target=_blank><FONT size=2>Hanz</FONT></A><FONT size=2> Nomex Gloves.&nbsp; It was cold but I was warm even at speed.<BR></FONT><BR></FONT></EM>The TR6 is a nice tweener and it fits&nbsp;beautifully under any of my shells.&nbsp; By-the-way, I have grown fond of my Carhartt jacket and I have decided that if they want it back, they are gonna have to&nbsp;come and get it, if they can find it.&nbsp;&nbsp;The TR6&nbsp;comes in black or a stealthy tan color called Burnish.&nbsp; So far, I like this jacket.&nbsp; It is warm, efficient and flexible.<BR><BR>Thanks.<BR><BR>Wade Nelson<BR>Editor<BR><BR>
<P><EM><FONT size=3>Sorting through the fads and fashion of the outdoor equipment industry to identify and promote the very best wilderness gear for high end recreational users, backcountry professionals and government agencies.</FONT></EM></P>
<P><FONT size=3><EM>Hardcore Outdoor is dedicated to those who won't or&nbsp;can't turn back.<BR></EM></FONT><BR><BR></FONT><BR>&nbsp;&nbsp;&nbsp;</P>
-----
EXTENDED BODY:
-----
EXCERPT:
-----
KEYWORDS:
Please provide a quote and time estimate to convert. Thanks!!
George
Hi, I am very much interested with the position you are offering. I am confident that I can meet all the requirements and qualifications you need. I believe that my skills are enough to render you my quality and efficient service. I have my own pc and broadband connection at home. I am always available through skype or yahoo messenger. I can start as soon as needed and can work full time to finish the project at earliest time. Thank you and hope to hear from you soon. I can deliver that earlier than 5 days because I have a group to help me complete the project in earliest time.
Hi, I got 2 options for you:
1- let me take a look at your text file, i can analyse the patter and retrieve all informations you need and save them to a database.
2- i make a crawler that can capture all the post from your site.
Let me know, i can provide you a demo.
Take care