I am using this command: curl ' http://localhost:8983/solr/users/update/csv?commit=true&separator=%09&encapsulator=%20&escape=\&stream.file=/tmp/users.csv '
On Mon, Oct 21, 2019 at 1:22 PM Alexandre Rafalovitch <arafa...@gmail.com> wrote: > What command do you use to get the file into Solr? My guess that you > are somehow not hitting the correct handler. Perhaps you are sending > it to extract handler (designed for PDF, MSWord, etc) rather than the > correct CSV handler. > > Solr comes with the examples of how to index CSV command. > See for example: > > https://github.com/apache/lucene-solr/blob/master/solr/example/films/README.txt#L39 > Also reference documentation: > > https://lucene.apache.org/solr/guide/8_1/uploading-data-with-index-handlers.html > > Regards, > Alex. > > On Mon, 21 Oct 2019 at 13:04, rhys J <rhyssha...@gmail.com> wrote: > > > > I am trying to import a csv file to my solr core. > > > > It looks like this: > > > > > "user_id","name","email","client","classification","default_client","disabled","dm_password","manager" > > "A2M","Art Morse","amo...@morsemoving.com","Morse > > Moving","Morse","","X","blue0show","" > > "ABW","Amy Wiedner","amy.wied...@pyramid-logistics.com > ","Pyramid","",""," > > ","shawn","" > > "J2P","Joan Padal","jo...@bergerallied.com","Berger","",""," > > ","skew3cues","" > > "ALB","Anna Bachman","an...@bergerallied.com","Berger","",""," > > ","wary#scan","" > > "B1B","Bridget Baker","bba...@reliablevan.com","Reliable","",""," > > ","laps,hear","" > > "B1K","Bev Klein"," ","Nor-Cal","",""," ","pipe3hour","" > > "B1L","Beverly Leonard","bleon...@reliablevan.com","Reliable","",""," > > ","gail6copy","" > > "CMD","Christal Davis","christalda...@smmoving.com","SMMoving","",""," > > ","risk-pair","" > > "BEB","Bob Barnum","b...@bergerts.com","Berger","",""," ","mets=pol","" > > > > I have set up the schema via the API, and have all the fields that are > > listed on the top line of the csv file. > > > > When I finish the import, it returns no errors. But when I go to look at > > the schema, it's created a 2 fields in the managed-schema file: > > > > <field > > > name="_user_id___name___email___client___classification___default_client___disabled___dm_password___manager_" > > type="text_general"/> > > > > and > > > > <copyField > > > source="_user_id___name___email___client___classification___default_client___disabled___dm_password___manager_" > > > dest="_user_id___name___email___client___classification___default_client___disabled___dm_password___manager__str" > > maxChars="256"/> >
