still trying—- but I have not been able to add a csv file into my weblog.
1) I created a template called import in my Template Group - Membership
2) i saved my xls spreadsheet as a comma delimited file ssfv.csv and loaded into my files dir
4) here is the file (it only has two records for testing purposes):
TITLE;LAST NAME;FIRST NAME;ADDRESS;CITY;PROV.;AREA CODE;TELEPHONE;CELL PHONE;FAX;E-MAIL ADDRESS;MEMBER;MEMBERNUM;EXPIRY DATE;EXPIRY DATE2
SFV mem;fsdergel;Mattdw;848 Fender St.;Vadfee;WA;09281;345 655-44563;;;matt@gianft.com;FALSE;CA1000000022;31-03-2006; 06/03
;Adews;Micdad;171 dn d Farm;New Land;BC;V4K 1C9;555 537-1989;;;info@madfarm.com;TRUE;CA0001053349 & CA0001053350;30-06-2007; 07/06
3) I added ONLY the following to the import template:
{exp:csvgrab url="http://www.mydomain.com/files/ssfv.csv"
weblog="12"
title="1"
skip="2"
delimiter=";"
encloser="QUOTE"
use="2|3|4|5|6|7|8|9|10|11|12|13|14|15"
fields="first_name|last_name|address|city|prst|area_code|tel|cell|fax|email_address|office|member_status|member_number|expiry_date|expiry_dateMY"}
( I tried both delimiter=”;” and delimiter=”,” as i noticed the csv uses” ;” )
4) and then i do a VIEW RENDERED TEMPLATE while i have the import template open in my CP
5) the template is rendered but nothing gets loaded.
any clues as how to fix??
