undefined field on CSV db import

2012-02-23 Thread pmcgovern
I am trying to import a csv file of values via curl (PHP) and am receiving an
'undefined field' error, but I am not sure why, as I am defining the field.
Can someone lend some insight as to what I am missing / doing wrong? Thank
you in advance.

Sample of CSV File:
---
"Product_ID"  "Product_Name"  "Product_ManufacturerPart"  "Product_Img" 
"ImageURL"  "Manufacturer_Name"  "lowestPrice"  "vendorCount"
"-2121813476"  "Over-the-Sink Dish Rack"  "123478"  "" 
"http://image10.bizrate-images.com/resize?sq=60&uid=2511766107&mid=18900"; 
"WALTERDRAKE"  "24.99"  "1"  
"-2121813460"  "Oregon Nike NCAA Twill Shorts - Mens - Green" 
"00025305XODR"  "" 
"http://image10.bizrate-images.com/resize?sq=60&uid=2564249353&mid=23598"; 
"Nike"  "44.99"  "3"  
"-2121813456"  "Sudden Change Under Eye Firming Serum"  "091777"  "" 
"http://image10.bizrate-images.com/resize?sq=60&uid=2564994087&mid=18900"; 
"WALTERDRAKE"  "19.99"  "1"  
"-2121813445"  "Global Keratin Leave-In Conditioner Cream"  "005248"  "" 
"http://image10.bizrate-images.com/resize?sq=60&uid=2101271875&mid=21473"; 
"Global Keratin"  "24"  "1"  
"-2121813443"  "Oregon Nike NCAA Twill Shorts - Mens - White" 
"00025305XODH"  "" 
"http://image10.bizrate-images.com/resize?sq=60&uid=2564226023&mid=17345"; 
"Nike"  "59.99"  "3"  
"-2121813441"  "Paul Brown Hawaii Shine Amplifier 4 oz."  "000684"  "" 
"http://image10.bizrate-images.com/resize?sq=60&uid=1171412855&mid=21473"; 
"Paul Brown"  "20.1"  "1"  
"-2121813437"  "Dish Drying Mat Large"  "077608"  "" 
"http://image10.bizrate-images.com/resize?sq=60&uid=1371997268&mid=18900"; 
"WALTERDRAKE"  "14.99"  "1"  


Solr Update URL:

http://localhost:8983/solr/db/update/csv?commit=true&header=true&separator=%09&escape=\\&fieldNames=Product_ID,Product_Name,Product_ManufacturerPart,Product_Img,ImageURL,Manufacturer_Name,lowestPrice,vendorCount


Error Output:
-



Error 400 undefined field "Product_ID"


HTTP ERROR 400

Problem accessing /solr/db/update/csv. Reason:
undefined field "Product_ID"/Powered by
Jetty:///

--
View this message in context: 
http://lucene.472066.n3.nabble.com/undefined-field-on-CSV-db-import-tp3770552p3770552.html
Sent from the Solr - User mailing list archive at Nabble.com.


Re: undefined field on CSV db import

2012-02-24 Thread pmcgovern
Product_ID was defined - Turns out I was encapsulating all data when 
encapsulation was only required for a couple field types. 
Erik Hatcher walked me through everything I was doing wrong and brought me to a 
solution.
Thank you for responding, though - tis greatly appreciated.

Thanks,
Patrick McGovern


On Feb 23, 2012, at 8:40 PM, Erick Erickson [via Lucene] wrote:

> What does your schema.xml file look like? Is Product_ID defined 
> as a field? 
> 
> Best 
> Erick 
> 
> On Thu, Feb 23, 2012 at 1:24 PM, pmcgovern <[hidden email]> wrote:
> 
> > I am trying to import a csv file of values via curl (PHP) and am receiving 
> > an 
> > 'undefined field' error, but I am not sure why, as I am defining the field. 
> > Can someone lend some insight as to what I am missing / doing wrong? Thank 
> > you in advance. 
> > 
> > Sample of CSV File: 
> > --- 
> > "Product_ID"  "Product_Name"  "Product_ManufacturerPart"  "Product_Img" 
> > "ImageURL"  "Manufacturer_Name"  "lowestPrice"  "vendorCount" 
> > "-2121813476"  "Over-the-Sink Dish Rack"  "123478"  "" 
> > "http://image10.bizrate-images.com/resize?sq=60&uid=2511766107&mid=18900"; 
> > "WALTERDRAKE"  "24.99"  "1" 
> > "-2121813460"  "Oregon Nike NCAA Twill Shorts - Mens - Green" 
> > "00025305XODR"  "" 
> > "http://image10.bizrate-images.com/resize?sq=60&uid=2564249353&mid=23598"; 
> > "Nike"  "44.99"  "3" 
> > "-2121813456"  "Sudden Change Under Eye Firming Serum"  "091777"  "" 
> > "http://image10.bizrate-images.com/resize?sq=60&uid=2564994087&mid=18900"; 
> > "WALTERDRAKE"  "19.99"  "1" 
> > "-2121813445"  "Global Keratin Leave-In Conditioner Cream"  "005248"  "" 
> > "http://image10.bizrate-images.com/resize?sq=60&uid=2101271875&mid=21473"; 
> > "Global Keratin"  "24"  "1" 
> > "-2121813443"  "Oregon Nike NCAA Twill Shorts - Mens - White" 
> > "00025305XODH"  "" 
> > "http://image10.bizrate-images.com/resize?sq=60&uid=2564226023&mid=17345"; 
> > "Nike"  "59.99"  "3" 
> > "-2121813441"  "Paul Brown Hawaii Shine Amplifier 4 oz."  "000684"  "" 
> > "http://image10.bizrate-images.com/resize?sq=60&uid=1171412855&mid=21473"; 
> > "Paul Brown"  "20.1"  "1" 
> > "-2121813437"  "Dish Drying Mat Large"  "077608"  "" 
> > "http://image10.bizrate-images.com/resize?sq=60&uid=1371997268&mid=18900"; 
> > "WALTERDRAKE"  "14.99"  "1" 
> > 
> > 
> > Solr Update URL: 
> >  
> > http://localhost:8983/solr/db/update/csv?commit=true&header=true&separator=%09&escape=\\&fieldNames=Product_ID,Product_Name,Product_ManufacturerPart,Product_Img,ImageURL,Manufacturer_Name,lowestPrice,vendorCount
> >  
> > 
> > 
> > Error Output: 
> > - 
> >  
> >  
> >  
> > Error 400 undefined field "Product_ID" 
> >  
> >  
> > HTTP ERROR 400 
> > 
> > Problem accessing /solr/db/update/csv. Reason: 
> > undefined field "Product_ID"/Powered by 
> > Jetty:/// 
> > 
> > -- 
> > View this message in context: 
> > http://lucene.472066.n3.nabble.com/undefined-field-on-CSV-db-import-tp3770552p3770552.html
> > Sent from the Solr - User mailing list archive at Nabble.com. 
> 
> 
> If you reply to this email, your message will be added to the discussion 
> below:
> http://lucene.472066.n3.nabble.com/undefined-field-on-CSV-db-import-tp3770552p3771545.html
> To unsubscribe from undefined field on CSV db import, click here.
> NAML



--
View this message in context: 
http://lucene.472066.n3.nabble.com/undefined-field-on-CSV-db-import-tp3770552p3772879.html
Sent from the Solr - User mailing list archive at Nabble.com.