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...
CSV Import for Joomla and jReviews
 
Welcome, Guest. Please login or register.
Did you miss your activation email?
December 01, 2008, 08:46:18 PM
21661 Posts in 4948 Topics by 2838 Members
Latest Member: davidkan
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  |  Creating a CSV file on a Mac « previous next »
Pages: [1]
Author Topic: Creating a CSV file on a Mac  (Read 1975 times)
Alejandro
Global Moderator
Administrator
Hero Member
*****
Offline Offline

Posts: 8592


« on: March 16, 2008, 10:33:51 PM »

If you are creating a CSV file on Excel in a Mac make sure you use the option to Save As "CSV (Windows), otherwise the format will not be correctly recognized by CSV Import.
Logged

Please take the time to vote and to write a review: http://extensions.joomla.org
Reviews Ahoy! - Submit your jReviews site here.
podosenov
Newbie
*
Offline Offline

Posts: 1


« Reply #1 on: April 08, 2008, 10:17:13 AM »

I tried exporting to CSV using Numbers on my Mac after I imported CSV it asked me to match not only columns but all fields of the table. Which means that if you have a table with 10 columns and 10 rows you will have to match 100! fields.
Logged
kheruc
Sr. Member
****
Offline Offline

Posts: 149



WWW
« Reply #2 on: April 08, 2008, 10:30:26 AM »

The same problem is in linux also (Open Office).

I guess it is because Windows uses different End Of Line character than unix-based operating systems, so end of line is not recognized in CSV Import and all fields are treated as columns.

http://en.wikipedia.org/wiki/Line_feed
 
« Last Edit: April 08, 2008, 10:40:28 AM by kheruc » Logged

Alejandro
Global Moderator
Administrator
Hero Member
*****
Offline Offline

Posts: 8592


« Reply #3 on: April 08, 2008, 02:43:25 PM »

So in Mac Excel, saving as CSV (Windows) doesn't solve the problem?

Alternative you can search in admin.csv_import.php for this line, twice:

new CSV($separator, "\r\n", '"');

And try changing it to:

new CSV($separator, "\n", '"');

It is the second parameter that determines the new line "character".

Thanks Kheruc for the wikipedia reference. I am still not sure what the newline characater would be in Mac or Unix, but at least we know where to fine tune it.

Let me know if it works.
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: