We use cookies to improve your experience. No personal information is gathered and we don't serve ads. Cookies Policy.

ExpressionEngine Logo ExpressionEngine
Features Pricing Support Find A Developer
Partners Upgrades
Blog Add-Ons Learn
Docs Forums University
Log In or Sign Up
Log In Sign Up
ExpressionEngine Logo
Features Pro new Support Find A Developer
Partners Upgrades
Blog Add-Ons Learn
Docs Forums University Blog
  • Home
  • Forums

CSVGrab--help me find what I'm doing wrong

Development and Programming

LHDonline's avatar
LHDonline
18 posts
16 years ago
LHDonline's avatar LHDonline

I have the code right, I think…

{exp:csvgrab url="http://www.religionnews.com/RNSPhotoExp.csv"
delimiter=","
encloser="QUOTE"
weblog="15"
title="1"
use="2|3"
fields="caption|photofilename"
}

What’s happening is that it’s somehow not recognizing the end of the first record, so the photofilename field ends up containing the file name of record #1, but then also includes the title of record 2. At this point, it gives up and doesn’t read any more data from the .csv. Ideas? I’ve tried .csv generated from Excel and FMPro, and it doesn’t seem to matter.

       
Andrew Weaver's avatar
Andrew Weaver
206 posts
16 years ago
Andrew Weaver's avatar Andrew Weaver

I’d guess that it is not recognising the line ending. Different systems use different characters to represent the end of a line.

See if you can re-save the file using LF (Unix) or CRLF (Windows) if possible.

Andrew

       

Reply

Sign In To Reply

ExpressionEngine Home Features Pro Contact Version Support
Learn Docs University Forums
Resources Support Add-Ons Partners Blog
Privacy Terms Trademark Use License

Packet Tide owns and develops ExpressionEngine. © Packet Tide, All Rights Reserved.