Re: undefined field on CSV db import
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=60uid=2511766107mid=18900; WALTERDRAKE 24.99 1 -2121813460 Oregon Nike NCAA Twill Shorts - Mens - Green 00025305XODR http://image10.bizrate-images.com/resize?sq=60uid=2564249353mid=23598; Nike 44.99 3 -2121813456 Sudden Change Under Eye Firming Serum 091777 http://image10.bizrate-images.com/resize?sq=60uid=2564994087mid=18900; WALTERDRAKE 19.99 1 -2121813445 Global Keratin Leave-In Conditioner Cream 005248 http://image10.bizrate-images.com/resize?sq=60uid=2101271875mid=21473; Global Keratin 24 1 -2121813443 Oregon Nike NCAA Twill Shorts - Mens - White 00025305XODH http://image10.bizrate-images.com/resize?sq=60uid=2564226023mid=17345; Nike 59.99 3 -2121813441 Paul Brown Hawaii Shine Amplifier 4 oz. 000684 http://image10.bizrate-images.com/resize?sq=60uid=1171412855mid=21473; Paul Brown 20.1 1 -2121813437 Dish Drying Mat Large 077608 http://image10.bizrate-images.com/resize?sq=60uid=1371997268mid=18900; WALTERDRAKE 14.99 1 Solr Update URL: http://localhost:8983/solr/db/update/csv?commit=trueheader=trueseparator=%09escape=\\fieldNames=Product_ID,Product_Name,Product_ManufacturerPart,Product_Img,ImageURL,Manufacturer_Name,lowestPrice,vendorCount Error Output: - html head meta http-equiv=Content-Type content=text/html; charset=ISO-8859-1/ titleError 400 undefined field Product_ID/title /head body HTTP ERROR 400 pProblem accessing /solr/db/update/csv. Reason: preundefined field Product_ID/pre/phr //smallPowered by Jetty:///small/br/ -- 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.
undefined field on CSV db import
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=60uid=2511766107mid=18900; WALTERDRAKE 24.99 1 -2121813460 Oregon Nike NCAA Twill Shorts - Mens - Green 00025305XODR http://image10.bizrate-images.com/resize?sq=60uid=2564249353mid=23598; Nike 44.99 3 -2121813456 Sudden Change Under Eye Firming Serum 091777 http://image10.bizrate-images.com/resize?sq=60uid=2564994087mid=18900; WALTERDRAKE 19.99 1 -2121813445 Global Keratin Leave-In Conditioner Cream 005248 http://image10.bizrate-images.com/resize?sq=60uid=2101271875mid=21473; Global Keratin 24 1 -2121813443 Oregon Nike NCAA Twill Shorts - Mens - White 00025305XODH http://image10.bizrate-images.com/resize?sq=60uid=2564226023mid=17345; Nike 59.99 3 -2121813441 Paul Brown Hawaii Shine Amplifier 4 oz. 000684 http://image10.bizrate-images.com/resize?sq=60uid=1171412855mid=21473; Paul Brown 20.1 1 -2121813437 Dish Drying Mat Large 077608 http://image10.bizrate-images.com/resize?sq=60uid=1371997268mid=18900; WALTERDRAKE 14.99 1 Solr Update URL: http://localhost:8983/solr/db/update/csv?commit=trueheader=trueseparator=%09escape=\\fieldNames=Product_ID,Product_Name,Product_ManufacturerPart,Product_Img,ImageURL,Manufacturer_Name,lowestPrice,vendorCount Error Output: - html head meta http-equiv=Content-Type content=text/html; charset=ISO-8859-1/ titleError 400 undefined field Product_ID/title /head body HTTP ERROR 400 pProblem accessing /solr/db/update/csv. Reason: preundefined field Product_ID/pre/phr //smallPowered by Jetty:///small/br/ -- 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
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 pmcgov...@portal63.com 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=60uid=2511766107mid=18900; WALTERDRAKE 24.99 1 -2121813460 Oregon Nike NCAA Twill Shorts - Mens - Green 00025305XODR http://image10.bizrate-images.com/resize?sq=60uid=2564249353mid=23598; Nike 44.99 3 -2121813456 Sudden Change Under Eye Firming Serum 091777 http://image10.bizrate-images.com/resize?sq=60uid=2564994087mid=18900; WALTERDRAKE 19.99 1 -2121813445 Global Keratin Leave-In Conditioner Cream 005248 http://image10.bizrate-images.com/resize?sq=60uid=2101271875mid=21473; Global Keratin 24 1 -2121813443 Oregon Nike NCAA Twill Shorts - Mens - White 00025305XODH http://image10.bizrate-images.com/resize?sq=60uid=2564226023mid=17345; Nike 59.99 3 -2121813441 Paul Brown Hawaii Shine Amplifier 4 oz. 000684 http://image10.bizrate-images.com/resize?sq=60uid=1171412855mid=21473; Paul Brown 20.1 1 -2121813437 Dish Drying Mat Large 077608 http://image10.bizrate-images.com/resize?sq=60uid=1371997268mid=18900; WALTERDRAKE 14.99 1 Solr Update URL: http://localhost:8983/solr/db/update/csv?commit=trueheader=trueseparator=%09escape=\\fieldNames=Product_ID,Product_Name,Product_ManufacturerPart,Product_Img,ImageURL,Manufacturer_Name,lowestPrice,vendorCount Error Output: - html head meta http-equiv=Content-Type content=text/html; charset=ISO-8859-1/ titleError 400 undefined field Product_ID/title /head body HTTP ERROR 400 pProblem accessing /solr/db/update/csv. Reason: pre undefined field Product_ID/pre/phr //smallPowered by Jetty:///small/br/ -- 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.