Support forums

Please check @brandnewbox_uk for support status updates.

Search     Advanced Search
Errors when trying ti import simple CSV file  
Posted: 16 December 2010 09:00 PM —  
Newbie
Rank
Total Posts:  12
Joined  2010-12-16

This is my template: I assume 1 is the first column? Or does title need to be “0” if it’s the actual first column in the CSV file? I tried it both ways and will post the error below (forum keeps saying I’m posting SPAM). I’m using EngineHosting.

{exp:csvgrab url="******.ehclients.***/csv/products.csv"
weblog="4"
title="1"
delimiter=","
use="2|3|4"
trace="true"
encloser=""
fields="count_number|code|price"}

Deprecated: Function split() is deprecated in /www/eh*****/public_html/EE/system/plugins/pi.csvgrab.php on line 88 Deprecated: Function split() is deprecated in /www/eh*****/public_html/EE/system/plugins/pi.csvgrab.php on line 93

TRACE: Array ( [title] => Array ( [is_custom] => 0 [field] => 1 ) [date] => Array ( [is_custom] => 0 [field] => ) [count_number] => Array ( [is_custom] => 1 [field] => 2 [id] => 11 [format] => none ) <pre><code> => Array ( [is_custom] => 1 [field] => 3 [id] => 10 [format] => none ) [price] => Array ( [is_custom] => 1 [field] => 4 [id] => 9 [format] => none ) [related_sub_cat] => Array ( [id] => 12 [format] => none ) )

TRACE: Resource id #52
Warning: fgetcsv(): enclosure must be a character in /www/eh*****/public_html/EE/system/plugins/pi.csvgrab.php on line 202


Thanks for your help,
John

Profile
 
Posted: 16 December 2010 09:06 PM —   [ # 1 ]  
Administrator
Avatar
RankRankRankRank
Total Posts:  1357
Joined  2006-04-12

Try using

encloser="QUOTE"

or leaving that parameter out altogether - I think it should work out the right setting.

Andrew

Profile
 
Posted: 16 December 2010 09:12 PM —   [ # 2 ]  
Newbie
Rank
Total Posts:  12
Joined  2010-12-16

That worked, thank you!

Profile
 

‹‹ Redirect after CSVGrab executes      CSVGrab importing other file type? ››

Select A Theme