Knowledgebase
View categorized listing of all common frequently asked questions.
Video Tutorials (jReviews 2.0)
Create a Movie & TV Show review website.
Customize the jReviews themes.
Review user profiles with the Everywhere addon.
Forum
Community forum
Submit a Ticket
Use your client area email to access the ticket system.
Downloads
Guides, modules and more...
Reviews Ahoy!

Extensions we recommend

CSV Import for Joomla and jReviews
 
Welcome, Guest. Please login or register.
Did you miss your activation email?
December 02, 2008, 07:38:30 PM
 21713 Posts in 4960 Topics by 2844 Members
Latest Member: chotchcala
News: Do not post any jReviews files or large amounts of code in the forums please. Only template files and code are allowed.
 
jReviews Support Forum  |  Extensions  |  CSV Import for Joomla and JReviews  |  Converting articles to CSV « previous next »
Pages: [1]
Author Topic: Converting articles to CSV  (Read 517 times)
bhakans
Newbie
*
Offline Offline

Posts: 2
« on: August 18, 2008, 08:09:04 AM »
Is there some convenient tool one could use to convert a set of articles (plain text files) into the appropriate CSV format, besides manually copying and pasting in Excel and then exporting from there?
Logged
Alejandro
Global Moderator
Administrator
Hero Member
*****
Offline Offline

Posts: 8613
« Reply #1 on: August 18, 2008, 10:25:02 AM »
If they are already in the database, you can use phpMyAdmin to export the tables to excel or CSV.
Logged
Please take the time to vote and to write a review: http://extensions.joomla.org
Reviews Ahoy! - Submit your jReviews site here.
bhakans
Newbie
*
Offline Offline

Posts: 2
« Reply #2 on: August 18, 2008, 11:32:10 AM »
No, what I am referring to is when you have several articles on your hard drive as separate .txt files.

I have tried googling for an application that would assist in formatting these separate files into one CSV file needed for the Import tool. I have had no luck so far...

Basically it would be something that would recognize the first line of text as the title and the rest of the text as the body.
Logged
Alejandro
Global Moderator
Administrator
Hero Member
*****
Offline Offline

Posts: 8613
« Reply #3 on: August 18, 2008, 12:35:21 PM »
I thought it wouldn't be that easy. I don't know of any tools, but I Googled it and found some tools that might make it easier for you:

http://jointtech.com/today-a-client-asked/xls-csv-convert/

http://www.rondebruin.nl/csv.htm
Logged
Please take the time to vote and to write a review: http://extensions.joomla.org
Reviews Ahoy! - Submit your jReviews site here.
Pages: [1]
« previous next »
    Jump to:  


    Powered by MySQL Powered by PHP Powered by SMF 1.1.7 | SMF © 2006-2008, Simple Machines LLC
    Joomla Bridge by JoomlaHacks.com     		Valid XHTML 1.0! Valid CSS!