{"id":772,"date":"2013-02-04T01:40:08","date_gmt":"2013-02-04T01:40:08","guid":{"rendered":"http:\/\/garysieling.com\/blog\/?p=772"},"modified":"2013-02-04T01:40:08","modified_gmt":"2013-02-04T01:40:08","slug":"solr-csv-dataimporthandler-sample","status":"publish","type":"post","link":"https:\/\/www.garysieling.com\/blog\/solr-csv-dataimporthandler-sample\/","title":{"rendered":"Solr CSV DataImportHandler sample"},"content":{"rendered":"

The following will import a two field CSV file into solr, assuming two columns, name and count. The name field is always quoted.<\/p>\n

<dataConfig>
\n<dataSource name=”ds1″ type=”FileDataSource” \/>
\n<document>
\n<entity name=”ngrams”
\nprocessor=”LineEntityProcessor”
\nurl=”E:\/Projects\/Data\/words-txt.csv”
\ndataSource=”ds1″
\ntransformer=”RegexTransformer”>
\n<field column=”rawLine”
\nregex=”^&quot;(.*)&quot;\\t(.*)$”
\ngroupNames=”name,count”
\n\/>
\n<\/entity>
\n<\/document>
\n<\/dataConfig><\/p>\n","protected":false},"excerpt":{"rendered":"

The following will import a two field CSV file into solr, assuming two columns, name and count. The name field is always quoted. <dataConfig> <dataSource name=”ds1″ type=”FileDataSource” \/> <document> <entity name=”ngrams” processor=”LineEntityProcessor” url=”E:\/Projects\/Data\/words-txt.csv” dataSource=”ds1″ transformer=”RegexTransformer”> <field column=”rawLine” regex=”^&quot;(.*)&quot;\\t(.*)$” groupNames=”name,count” \/> <\/entity> <\/document> <\/dataConfig><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[4],"tags":[130,300,517],"aioseo_notices":[],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.garysieling.com\/blog\/wp-json\/wp\/v2\/posts\/772"}],"collection":[{"href":"https:\/\/www.garysieling.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.garysieling.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.garysieling.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.garysieling.com\/blog\/wp-json\/wp\/v2\/comments?post=772"}],"version-history":[{"count":0,"href":"https:\/\/www.garysieling.com\/blog\/wp-json\/wp\/v2\/posts\/772\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.garysieling.com\/blog\/wp-json\/wp\/v2\/media?parent=772"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.garysieling.com\/blog\/wp-json\/wp\/v2\/categories?post=772"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.garysieling.com\/blog\/wp-json\/wp\/v2\/tags?post=772"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}