SQL question

[shawnlg]

I know that you can export csv file or an excel file in my sql with the headings.  However I haven't figured out how to import them back in that way.   If I can do that I can make large scale article imports.  I need to add and modify a large number or articles.  Any suggestions.

[IchBin]

Are you exporting your articles from another database that isn't SMF or TP related? If so, you won't be able to just import them because the fields for the tables have to line up and be assigned properly etc.

If you're going to do it this way to try and save yourself time you're going to need some custom code to do it. Can you provide a sample backup so we can see how your articles are laid out in the other database or where ever you are storing them?

[shawnlg]

What I want to do is export the current article database in an excel file or cvs, make changes, add additional articles and then imput them back in.

Here is my current article database in sql format..

Code Select Expand



--
-- Dumping data for table `smf_tp_articles`
--

INSERT INTO `smf_tp_articles` VALUES(3, 1151931960, '<DIV style="PADDING-RIGHT: 1em; PADDING-LEFT: 1em; PADDING-BOTTOM: 1em; PADDING-TOP: 1em">Every time a new science fiction novel, movie or T.V. show comes out that seems to show Christian principles the Christian community wraps itsââ,¬â,,¢ self around it as it was its own.<SPAN style="mso-spacerun: yes">  </SPAN>The biggest example of this could be the Matrix.<SPAN style="mso-spacerun: yes">  </SPAN>The first movie poured forth multiple Christian principles.<SPAN style="mso-spacerun: yes">  </SPAN>It is easy to point our in favor of the characterââ,¬â,,¢s names to the basic plot of the move.<SPAN style="mso-spacerun: yes">  </SPAN>In fact I would say that as a whole the movie was something that could be embraced by Christians with few exceptions.<BR><BR><STRONG>From Embraced to Embarrassed</STRONG> \r\n<P class=MsoNormal style="MARGIN: 0in 0in 0pt">After the first Matrix movie, Christians poured money into the next two movies (myself included); Christians even wrote books and preached sermons off of it.<SPAN style="mso-spacerun: yes">  </SPAN>The problem... The next two movies werenââ,¬â,,¢t as friendly to the Christian worldview as the first one.<SPAN style="mso-spacerun: yes">  </SPAN>The second and third movie mixed not just Christian principles we remembered from the first movie, but now it also gave new revelations of the Authorââ,¬â,,¢s own personal perspective on religion and Philosophy.<SPAN style="mso-spacerun: yes">  </SPAN>As a result, Christian went out in droves to buy those tickets, take their non-believer buddies only to be embarrassed and speechless when they could no longer live with what the series became.</P>\r\n<P><STRONG>What went wrong?<BR></STRONG>Sci-fi, fantasy and fiction is just what it isââ,¬Â¦ fiction.<SPAN style="mso-spacerun: yes">  </SPAN>Fiction coming from what ever type medium you choose to enjoy it in should only be embraced as fiction.<SPAN style="mso-spacerun: yes">  </SPAN>You should expect that the authorââ,¬â,,¢s perspective on religion and philosophy will be exhibited through their work.<SPAN style="mso-spacerun: yes">  </SPAN>I think sometimes Christians want so bad to identify with something more modern or what they may perceive as relevant other than their Bible, latch onto movies or other books.<SPAN style="mso-spacerun: yes">  </SPAN>I believe it is easy to see that Christians these days fall under the attack of being irrelevant and archaic, however they desperately donââ,¬â,,¢t want to be looked at this way.<SPAN style="mso-spacerun: yes">  </SPAN><BR><BR>Christians shouldnââ,¬â,,¢t try to fit in at all costs. There does however need to be some resolution of whether these ââ,¬Å"new ideasââ,¬Â are more relevant than the older ones.  One thing for sure is there  are differences in thinking from what the bible teaches from those in conflict that need to be resolved.<SPAN style="mso-spacerun: yes">  </SPAN>Today, people who believe devoutly in Jesus and the Bible they cherish are under the scrutiny of ââ,¬Å"modern thinkingââ,¬Â / liberal thought.<SPAN style="mso-spacerun: yes">  </SPAN>It is hip in these days to embrace more widely talked about attitudes towards homosexuality, abortion and the abolishment of the deity of Christ.<SPAN style="mso-spacerun: yes">  </SPAN>In todayââ,¬â,,¢s culture it seams more favorable to demote Jesus to a good teacher. Some go so far as questioning his existence.<SPAN style="mso-spacerun: yes">  </SPAN>I believe it is because of these factors that Christians are looking for a point of agreement with the popular media.<BR><BR><STRONG>Is there anything wrong in usi<SPAN style="COLOR: #999999"></SPAN>ng fiction to illustrate or demonstrate a Christian Worldview?<BR></STRONG>The short and sweet answer is no!<SPAN style="mso-spacerun: yes">  </SPAN>I think it is a great idea to find points of agreement and distinction in pop-culture.<SPAN style="mso-spacerun: yes">  </SPAN>Paul did this in the book of Acts. <BR><BR><EM style="mso-bidi-font-style: normal"><SPAN style="COLOR: #999999"><EM style="mso-bidi-font-style: normal">"People of <?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-com:office:smarttags" /><st1:City w:st="on"><st1:place w:st="on">Athens</st1:place></st1:City>, I see that you are in every respect religiously exact. For as I walked about and looked carefully at your objects of worship, I even came upon an altar inscribed, ''To a God Unknown.'' Now what you thus worship unknowingly I would proclaim to you" (Acts 17:23).</EM></SPAN><BR><BR></EM>The problem is not pointing out these things, but rather leaning on these movies or books as if it were another testament of the bible.<SPAN style="mso-spacerun: yes">  </SPAN>I believe a site like this one can do exactly that by doing these thingsââ,¬Â¦<BR><BR>1. Reviewing and dissecting popular science fiction from a Christian world view.in hopes of better clarifying what we believe as Christians about a variety of topics including fate, supernatural powers and life outside of this planet. <BR>2. Promoting dialog between Christianââ,¬â,,¢s and Non-Christians through the enjoyment of fiction.<BR>3. Enjoying science fiction for what it is, but making it more flavorful to Christianââ,¬â,,¢s and not Christians alike through colorful articles, interviews and discussions.<BR>4. Helping sort out truth, non-truths and taking back concepts and ideas that have been relabeled or miscued.<BR>5. Promoting healthy dialog by asking a series of questions to users from television, movie or book reviews.<BR>6. Developing clubs and seminars for people to come together and share ideas.<BR>7. Encouraging the growth of new material from Christian world view.<BR>8. Offering resources and material on this website to further discuss and support the function of this website.<BR>9. Discuss areas of agreement and disagreement of popular science and philosophy in a relevant and interesting way.</P>\r\n<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><EM>About the Author: Shawn Larson is a Christian businessman who enjoys science fiction as a past time.<SPAN style="mso-spacerun: yes">  </SPAN>He hopes this site will open peoples minds to think but will also help encourage and challenge people into a proper view of truth.  The author is not a professional writer and will always listen to private critique to enhance his writing skils.  Saying this however, I would encourage people to talk about the ideas of the writings on this site rather than the english skills.  If you are interested in editing to solve readability issues please let us know.</EM></P></DIV>', '', 0, 4, 1, 'Welcome to SciFiandGod.com, Challenging Your Worldââ,¬Â¦ View', 1, 'TP', 'theme', 1, 0, 'title,top,cblock,rblock,lblock', 0, 0, '', 597, '', '', 0, 'Challenging Your Worldââ,¬Â¦ View');
INSERT INTO `smf_tp_articles` VALUES(5, 1151938740, '<p>In this article every possible visual option is turned on. You can rate and comment on it, and it will show both views number,author etc.</p><p> </p>', '', 0, 1, 0, 'Visual options A', 1, 'TP', 'theme', 1, 1, 'date,title,author,linktree,top,cblock,rblock,category,catlist,comments,views,rating,ratingallow,commentallow,commentupshrink', 0, 0, '', 10, '', '', 0, 'visual1');
INSERT INTO `smf_tp_articles` VALUES(4, 1151938260, 'Articles in TP have numerous visual options which you can turn on/off on a per-article-basis. In this article all of them , save for the &quot;show other articles in same category&quot;, have been turned off. It will depend on the TP theme, but basically it should allow you to have fully customized pages - with only the copyright at the bottom and the forum name at the top.', '', 0, 1, 0, 'Visual options B', 1, 'TP', 'title', 1, 1, 'title,category,catlist', 0, 0, '', 12, '', '', 0, 'visual2');
INSERT INTO `smf_tp_articles` VALUES(7, 1192469400, '&lt;SPAN style=&quot;FONT-SIZE: 12pt; FONT-FAMILY: ''Times New Roman''; mso-fareast-font-family: ''Times New Roman''; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA&quot;&gt;SAG Rating system is an accumulative score we use to determine the over watch ability of a TV show. &lt;SPAN style=&quot;mso-spacerun: yes&quot;&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style=&quot;mso-spacerun: yes&quot;&gt;&amp;nbsp;&lt;/SPAN&gt;Below are the factors we use to determine the overall score of a show.&lt;/SPAN&gt; ', '', 0, 7, 1, 'What is the SAG Rating', 1, 'shawnlg', 'theme', 1, 0, 'date,title,author,linktree,top,cblock,rblock,lblock,views,rating,ratingallow', 0, 0, '', 14, '', '', 0, '');
INSERT INTO `smf_tp_articles` VALUES(8, 1192472520, 'The user rating is generated by user feedback in the poll questions. ', '', 0, 7, 0, 'What is the User Rating?', 1, 'shawnlg', 'theme', 1, 0, 'date,title,author,linktree,top,cblock,rblock,lblock,views,rating,ratingallow', 0, 0, '', 9, '', '', 0, '');
INSERT INTO `smf_tp_articles` VALUES(9, 1192561440, 'echo ''Name of Show &lt;BR&gt;Star Trek Next Generation: Encounter At Farpoint &lt;BR&gt;&lt;BR&gt;Written By &lt;BR&gt;D.C. Fontana and Gene Roddenberry&lt;BR&gt;&lt;BR&gt;Directed By&lt;BR&gt;Corey Allen&lt;BR&gt;&lt;BR&gt;\r\n&lt;TABLE borderColor=#666666 cellSpacing=0 cellPadding=5 width=&quot;95%&quot; border=1&gt;\r\n&lt;TBODY&gt;\r\n&lt;TR bgColor=#333333&gt;\r\n&lt;TD width=&quot;22%&quot;&gt;Show Number&lt;/TD&gt;\r\n&lt;TD width=&quot;33%&quot;&gt;Episode &lt;/TD&gt;\r\n&lt;TD width=&quot;32%&quot;&gt;Air date&lt;/TD&gt;\r\n&lt;TD width=&quot;13%&quot;&gt;&lt;A href=&quot;http://www.scifiandgod.com/content/index.php?page=7&quot;&gt;SAG Rating&lt;/A&gt;&lt;/TD&gt;\r\n&lt;TD width=&quot;13%&quot;&gt;&lt;A href=&quot;http://www.scifiandgod.com/content/index.php?page=8&quot;&gt;User Rating&lt;/A&gt;&lt;/TD&gt;&lt;/TR&gt;\r\n&lt;TR&gt;\r\n&lt;TD&gt;#101&lt;/TD&gt;\r\n&lt;TD&gt;Encounter At Farpoint&lt;/TD&gt;\r\n&lt;TD&gt;09/28/87&lt;/TD&gt;\r\n&lt;TD&gt;N/A&lt;/TD&gt;\r\n&lt;TD&gt;'',$story[''rating_average''],'' &lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;BR&gt;\r\n&lt;H4&gt;&lt;A href=&quot;http://www.scifiandgod.com/content/index.php?page=What%20is%20the%20Synopsis?&quot;&gt;Synopsis&lt;/A&gt; &lt;/H4&gt;N/A &lt;BR&gt;\r\n&lt;H4&gt;&lt;A href=&quot;http://www.scifiandgod.com/content/index.php?page=What%20are%20the%20Measures%20You%20Critique%20the%20Shows%20by?&quot;&gt;Critique&lt;/A&gt;&lt;/H4&gt;N/A &lt;BR&gt;\r\n&lt;H4&gt;&lt;A href=&quot;http://www.scifiandgod.com/content/index.php?page=What%20do%20we%20evaluate%20in%20the%20key%20themes?&quot;&gt;Key Themes &lt;/A&gt;&lt;/H4&gt;N/A &lt;BR&gt;\r\n&lt;H4&gt;&lt;A href=&quot;http://www.scifiandgod.com/content/index.php?page=How%20do%20you%20determine%20what%20are%20challenging%20topics?&quot;&gt;Challenging Topics &lt;/A&gt;&lt;/H4&gt;N/A &lt;BR&gt;\r\n&lt;H4&gt;&lt;A href=&quot;http://www.scifiandgod.com/content/index.php?page=16&quot;&gt;Intersecting Ideas &amp;amp; Opposing World Views&lt;/A&gt; &lt;/H4&gt;N/A &lt;BR&gt;\r\n&lt;H4&gt;&lt;A href=&quot;http://www.scifiandgod.com/content/index.php?page=17&quot;&gt;Topical Questions&lt;/A&gt;&lt;BR&gt;&lt;/H4&gt;N/A''; ', '140|N/A|09-28-87', -1, 10, 1, 'Star Trek - The Next Generation: Encounter At Farpoint', 1, 'shawnlg', 'theme', 1, 0, 'title,linktree,top,cblock,rblock,lblock,comments,views,rating,ratingallow,commentallow', 0, 0, '', 89, '4,10', '1,3', 0, 'Star Trek - The Next Generation: Encounter At Farpoint');
INSERT INTO `smf_tp_articles` VALUES(12, 1192823640, 'The synopsis is&amp;nbsp;our brief review of the episode. ', '', 0, 7, 0, 'What is the Synopsis?', 1, 'shawnlg', 'theme', 1, 0, 'date,title,author,linktree,top,cblock,rblock,lblock,views,rating,ratingallow', 0, 0, '', 2, '', '', 0, 'What is the Synopsis?');
INSERT INTO `smf_tp_articles` VALUES(13, 1192829940, 'Coming Soon ', '', 0, 7, 0, 'What are the Measures You Critique the Shows by?', 1, 'shawnlg', 'theme', 1, 0, 'date,title,author,linktree,top,cblock,rblock,lblock,views,rating,ratingallow', 0, 0, '', 2, '', '', 0, 'What are the Measures You Critique the Shows by?');
INSERT INTO `smf_tp_articles` VALUES(14, 1192830480, '&lt;P&gt;&amp;nbsp;Either implied or strait forward the author is generally trying to communicate some ideas.&amp;nbsp; We just evaluate the show and give our perspective what they are.&amp;nbsp; As part of the review process we pull out the main points from the show.&amp;nbsp; From time to time we miss something please give us your oppions in the feedback section of the review.&lt;/P&gt;', '', 0, 7, 0, 'What do we evaluate in the key themes?', 1, 'shawnlg', 'theme', 1, 0, 'date,title,author,linktree,top,cblock,rblock,lblock,views,rating,ratingallow', 0, 0, '', 4, '', '', 0, 'What do we evaluate in the key themes?');
INSERT INTO `smf_tp_articles` VALUES(11, 1192743960, '$story[''rating_votes'']', '', -1, 0, 1, 'This is a test', 1, 'shawnlg', 'theme', 1, 0, 'date,title,author,linktree,top,cblock,rblock,lblock,views,rating,ratingallow', 0, 0, '', 2, '', '', 0, '');
INSERT INTO `smf_tp_articles` VALUES(10, 1195191420, 'echo ''Name of Show &lt;BR&gt;Star Trek Next Generation: The Naked Now &lt;BR&gt;&lt;BR&gt;Written By &lt;BR&gt;D.C. Fontana and Gene Roddenberry&lt;BR&gt;&lt;BR&gt;Directed By&lt;BR&gt;Corey Allen&lt;BR&gt;&lt;BR&gt;\r\n&lt;TABLE borderColor=#666666 cellSpacing=0 cellPadding=5 width=&quot;95%&quot; border=1&gt;\r\n&lt;TBODY&gt;\r\n&lt;TR bgColor=#333333&gt;\r\n&lt;TD width=&quot;22%&quot;&gt;Show Number&lt;/TD&gt;\r\n&lt;TD width=&quot;33%&quot;&gt;Episode &lt;/TD&gt;\r\n&lt;TD width=&quot;32%&quot;&gt;Air date&lt;/TD&gt;\r\n&lt;TD width=&quot;13%&quot;&gt;&lt;A href=&quot;http://www.scifiandgod.com/content/index.php?page=7&quot;&gt;SAG Rating&lt;/A&gt;&lt;/TD&gt;\r\n&lt;TD width=&quot;13%&quot;&gt;&lt;A href=&quot;http://www.scifiandgod.com/content/index.php?page=8&quot;&gt;User Rating&lt;/A&gt;&lt;/TD&gt;&lt;/TR&gt;\r\n&lt;TR&gt;\r\n&lt;TD&gt;#102&lt;/TD&gt;\r\n&lt;TD&gt;The Naked Now&lt;/TD&gt;\r\n&lt;TD&gt;10/05/87&lt;/TD&gt;\r\n&lt;TD&gt;N/A&lt;/TD&gt;\r\n&lt;TD&gt;'',$story[''rating_average''],'' &lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;BR&gt;\r\n&lt;H4&gt;&lt;A href=&quot;http://www.scifiandgod.com/content/index.php?page=What%20is%20the%20Synopsis?&quot;&gt;Synopsis&lt;/A&gt; &lt;/H4&gt;N/A &lt;BR&gt;\r\n&lt;H4&gt;&lt;A href=&quot;http://www.scifiandgod.com/content/index.php?page=What%20are%20the%20Measures%20You%20Critique%20the%20Shows%20by?&quot;&gt;Critique&lt;/A&gt;&lt;/H4&gt;N/A &lt;BR&gt;\r\n&lt;H4&gt;&lt;A href=&quot;http://www.scifiandgod.com/content/index.php?page=What%20do%20we%20evaluate%20in%20the%20key%20themes?&quot;&gt;Key Themes &lt;/A&gt;&lt;/H4&gt;N/A &lt;BR&gt;\r\n&lt;H4&gt;&lt;A href=&quot;http://www.scifiandgod.com/content/index.php?page=How%20do%20you%20determine%20what%20are%20challenging%20topics?&quot;&gt;Challenging Topics &lt;/A&gt;&lt;/H4&gt;N/A &lt;BR&gt;\r\n&lt;H4&gt;&lt;A href=&quot;http://www.scifiandgod.com/content/index.php?page=16&quot;&gt;Intersecting Ideas &amp;amp; Opposing World Views&lt;/A&gt; &lt;/H4&gt;N/A &lt;BR&gt;\r\n&lt;H4&gt;&lt;A href=&quot;http://www.scifiandgod.com/content/index.php?page=17&quot;&gt;Topical Questions&lt;/A&gt;&lt;BR&gt;&lt;/H4&gt;N/A''; ', '102|N/A|10-5-87', -1, 10, 0, 'Star Trek - The Next Generation - The Naked Now', 1, 'shawnlg', 'theme', 1, 0, 'date,title,author,linktree,top,cblock,rblock,lblock,comments,views,rating,ratingallow,commentallow', 0, 0, '', 34, '', '', 0, 'Star Trek - The Next Generation - The Naked Now');
INSERT INTO `smf_tp_articles` VALUES(15, 1192831080, '&lt;P&gt;The nature of this website is to challenge and enrich peoples'' Christian faith&amp;nbsp;so they&amp;nbsp;know better what they believe.&amp;nbsp; We believe this can help people have a much deeper relationship with Christ.&amp;nbsp; For those who don''t believe in God we hope to challenge their current world view through the questions.&lt;/P&gt;', '', 0, 7, 1, 'How do you determine what are challenging topics?', 1, 'shawnlg', 'theme', 1, 0, 'date,title,author,linktree,top,cblock,rblock,lblock,views,rating,ratingallow', 0, 0, '', 2, '', '', 0, 'How do you determine what are challenging topics?');
INSERT INTO `smf_tp_articles` VALUES(16, 1192831380, '&lt;P class=MsoNormal style=&quot;MARGIN: 0in 0in 0pt&quot;&gt;We use this heading to help people figure out what they believe from a Biblical perspective.&amp;nbsp; This is here to dissect what the author is trying to convey.&lt;SPAN style=&quot;mso-spacerun: yes&quot;&gt;&amp;nbsp; &lt;/SPAN&gt;So many things are passed over and are subsequently accepted that should rather be challenged.&lt;SPAN style=&quot;mso-spacerun: yes&quot;&gt;&amp;nbsp; &lt;/SPAN&gt;This category should do this. We realize that from time to time our biblical interpretation will not be the same as yours but again our purpose is to challenge you.&amp;nbsp;&lt;/P&gt;', '', 0, 7, 0, 'What is the Intersecting Ideas and Opposing World Views All About?', 1, 'shawnlg', 'theme', 1, 0, 'date,title,author,linktree,top,cblock,rblock,lblock,views,rating,ratingallow', 0, 0, '', 6, '', '', 0, 'What is the Intersecting Ideas and Opposing World Views All About?');
INSERT INTO `smf_tp_articles` VALUES(17, 1192932420, '&lt;P class=MsoNormal style=&quot;MARGIN: 0in 0in 0pt&quot;&gt;The topical questions are those questions we generate based on the various themes of the show.&amp;nbsp; You can expect that theses questions will challenge you intellectually and spiritually.&lt;/P&gt;', '', 0, 7, 0, 'How do you come up with the topical questions?', 1, 'shawnlg', 'theme', 1, 0, 'date,title,author,linktree,top,cblock,rblock,lblock,views,rating,ratingallow', 0, 0, '', 5, '', '', 0, 'How do you come up with the topical questions?');
INSERT INTO `smf_tp_articles` VALUES(18, 1192942200, 'global $db_prefix, $scripturl;\r\n\r\n// Change the category number to your category ID\r\n$category = 10;\r\n\r\n$query = db_query(\r\n    "SELECT id, subject, intro, rating\r\n     FROM {$db_prefix}tp_articles\r\n     WHERE category = $category\r\n     AND off = 0\r\n     AND approved = 1\r\n     ORDER BY id", __FILE__, __LINE__);\r\n\r\n\r\n\r\necho '' <div id="episodebox"> <table cellspacing="0" cellpadding="5px" border="1" width="470">\r\n <tr>\r\n <th width="14%">Show Number</th>\r\n <th width="45%">Episode </th>\r\n <th width="17%">Air date</th>\r\n <th width="12%"><a href="'' .$scripturl. ''?page=7">SAG Rating</a></th>\r\n <th width="12%"><a href="'' .$scripturl. ''?page=8">User Rating</a></th>\r\n </tr>'';\r\nwhile ($row = mysql_fetch_assoc($query)){\r\n $rate = array();\r\n $rate = explode(",", $row[''rating'']);\r\n $rating_votes = count($rate);\r\n \r\n if($row[''rating''] == '''')\r\n $rating_votes = 0;\r\n \r\n $total = 0;\r\n foreach($rate as $mm => $mval)\r\n $total = $total+$mval;\r\n\r\n if($rating_votes > 0 && $total > 0)\r\n $rating_average = floor($total/$rating_votes);\r\n else\r\n $rating_average=0;\r\n\r\n $sag = array();\r\n if (!empty($row[''intro''])){\r\n $sag = explode("|", $row[''intro'']);\r\n }\r\n else{\r\n $air_date = '''';\r\n $sag_rating = '''';\r\n                $episode_num = '''';\r\n }\r\n\r\n foreach ($sag as $key => $value){\r\n $air_date = $sag[0];\r\n $sag_rating = $sag[1];\r\n                $episode_num = $sag[2];\r\n }\r\n  echo ''<tr>\r\n  <td width="14%">'',$episode_num, ''</td>\r\n  <td width="14%"><a href="'' . $scripturl . ''?page='' . $row[''id''] . ''">'' . $row[''subject''] . ''</a></td>\r\n  <td width="14%">'',$air_date, ''</td>\r\n  <td width="14%">'',$sag_rating, ''</td>\r\n  <td width="14%">'',$rating_average, ''</td>\r\n  </tr>'';\r\n}\r\necho ''</table></div> <table cellspacing="0" cellpadding="5px" border="0" width="350" height="1000">\r\n <tr><td></td></tr></table>'';\r\necho ''</div>'';', '', -1, 6, 0, 'Star Trek - The Next Generation - The First Season', 1, 'shawnlg', 'theme', 1, 0, 'date,title,author,linktree,top,cblock,rblock,lblock,views,rating,ratingallow', 0, 0, '', 37, '', '', 0, 'Star Trek - The Next Generation - The First Season');
INSERT INTO `smf_tp_articles` VALUES(22, 1193439360, 'This is just an article for testing purposes. ', '10-26-07|10|105', 0, 10, 1, 'IchBin''s Article ', 1, 'shawnlg', 'theme', 1, 1, 'date,title,author,linktree,top,cblock,rblock,lblock,views,rating,ratingallow', 0, 0, '', 1, '', '', 0, '');

[lebisol]

why not just edit them in place in myPHPAdmin?
adding them would be a problem since databse is not present to do auto-increments and update relatedtables....besides, adding articels through TP is a lot easier with editor.

[IchBin]

Well if you're going to manually add the changes that easy enough. Export the file as as a sql file in phpMyAdmin. Add your changes to the file, then import the file with phpMyAdmin.

[shawnlg]

To lebisol..  With the changes that we made to the script moving back and forth between html and php is a pain.  If I can directly put it into the sql that would be great.  Are you saying I couldnt create my own numbers when adding new products that way?

To Ichbin I tried using my sql to do this but it would not import the csv file correctly.  I need to use the csv so I can have category heads so I can easily make changes.  I guess I just done know how to import that file I modify properly in SQL.  Any suggestions how to do this?  I can give you screen shots through the process if that would help you understand what I am doing or not doing right.  Thanks again!

[lebisol]

 have never had good luck with editing csv...if the csv file is not formated right after the edits you could be getting issues from that. You can create your own numbers following the sequence of increment.
if you just do a csv export and then re-import it back without edit are you getting any issues?

[shawnlg]

I will try but the edits I did make souldnt have caused any issues.  I made a few textual changes.  But I will try.  Maybe I should call my sys op and ask him if everything is working ok..