title: How to import data into neo4j (neo4j-community-2.0.0) in windows 7?
body: <p>I got the below link to do this but the problem is that it's for linux users !!! </p>
  
  <p><a href="http://blog.neo4j.org/2013/03/importing-data-into-neo4j-spreadsheet.html" rel="nofollow">http://blog.neo4j.org/2013/03/importing-data-into-neo4j-spreadsheet.html</a></p>
  
  <p>Please help me to get this done on windows ? Thanks in advance.</p>
  
  <p>I am new to neo4j and got only a little hands on experience on java.</p>
  
  <hr>
  
  <p>I added neo4jtools to my neo4j server from the below link</p>
  
  <p><a href="https://github.com/jexp/neo4j-shell-tools" rel="nofollow">https://github.com/jexp/neo4j-shell-tools</a></p>
  
  <p>then I follow this command to import few data to a graph database</p>
  
  <pre><code>neo4jshell -path C:\Program Files\neo4j-community-2.0.0\data\test5.db -config C:\Program Files\neo4j-community-2.0.0\conf\neo4j.properties -file C:\Users\admin\Downloads\import.txt
  </code></pre>
  
  <p>and I get a message like this on the command prompt</p>
  
  <pre><code>&gt; Transaction started
  &gt; +-------------------+ | No data returned. |
  &gt; +-------------------+ Nodes created: 20 Properties set: 60 3586 ms Transaction committed Transaction started ERROR (-v for expanded
  &gt; information):
  &gt;         MissingIndexException: Index `node_auto_index` does not exist
  </code></pre>
  
  <p>my import.txt file contents are these</p>
  
  <pre><code>BEGIN
  
  create ({id:'1', name:'Amada Emory', type:'Female'})
  create ({id:'2', name:'Rana Seely', type:'Female'})
  create ({id:'3', name:'Detra Thatcher', type:'Female'})
  create ({id:'4', name:'Melda Reza', type:'Female'})
  create ({id:'5', name:'Shana Willems', type:'Female'})
  create ({id:'6', name:'Sharonda Peele', type:'Female'})
  create ({id:'7', name:'Dagny Agee', type:'Female'})
  create ({id:'8', name:'Tisa Woodman', type:'Female'})
  create ({id:'9', name:'Shelba Mutchler', type:'Female'})
  create ({id:'10', name:'Anderson Spagnola', type:'Male'})
  create ({id:'11', name:'Pamala Forward', type:'Female'})
  create ({id:'12', name:'Melva Fairchild', type:'Female'})
  create ({id:'13', name:'Antione Selman', type:'Male'})
  create ({id:'14', name:'Carmelia Cali', type:'Female'})
  create ({id:'15', name:'Fairy Daughtery', type:'Female'})
  create ({id:'16', name:'Stefany Mcamis', type:'Female'})
  create ({id:'17', name:'Kermit Meaney', type:'Male'})
  create ({id:'18', name:'Williemae Dossantos', type:'Female'})
  create ({id:'19', name:'Marth Sparling', type:'Female'})
  create ({id:'20', name:'Jarvis Noland', type:'Male'});
  
  COMMIT
  
  BEGIN
  
  start n1=node:node_auto_index(id='1'),n2=node:node_auto_index(id='11') create n1-[:MOTHER_OF]-&gt;n2;
  start n1=node:node_auto_index(id='1'),n2=node:node_auto_index(id='12') create n1-[:MOTHER_OF]-&gt;n2;
  start n1=node:node_auto_index(id='1'),n2=node:node_auto_index(id='13') create n1-[:MOTHER_OF]-&gt;n2;
  start n1=node:node_auto_index(id='2'),n2=node:node_auto_index(id='14') create n1-[:MOTHER_OF]-&gt;n2;
  start n1=node:node_auto_index(id='2'),n2=node:node_auto_index(id='15') create n1-[:MOTHER_OF]-&gt;n2;
  start n1=node:node_auto_index(id='2'),n2=node:node_auto_index(id='16') create n1-[:MOTHER_OF]-&gt;n2;
  start n1=node:node_auto_index(id='3'),n2=node:node_auto_index(id='17') create n1-[:MOTHER_OF]-&gt;n2;
  start n1=node:node_auto_index(id='3'),n2=node:node_auto_index(id='18') create n1-[:MOTHER_OF]-&gt;n2;
  start n1=node:node_auto_index(id='3'),n2=node:node_auto_index(id='19') create n1-[:MOTHER_OF]-&gt;n2;
  start n1=node:node_auto_index(id='10'),n2=node:node_auto_index(id='20') create n1-[:FATHER_OF]-&gt;n2;
  start n1=node:node_auto_index(id='14'),n2=node:node_auto_index(id='1') create n1-[:MOTHER_OF]-&gt;n2;
  start n1=node:node_auto_index(id='11'),n2=node:node_auto_index(id='2') create n1-[:MOTHER_OF]-&gt;n2;
  start n1=node:node_auto_index(id='11'),n2=node:node_auto_index(id='3') create n1-[:MOTHER_OF]-&gt;n2;
  start n1=node:node_auto_index(id='12'),n2=node:node_auto_index(id='4') create n1-[:MOTHER_OF]-&gt;n2;
  start n1=node:node_auto_index(id='12'),n2=node:node_auto_index(id='5') create n1-[:MOTHER_OF]-&gt;n2;
  start n1=node:node_auto_index(id='12'),n2=node:node_auto_index(id='6') create n1-[:MOTHER_OF]-&gt;n2;
  start n1=node:node_auto_index(id='17'),n2=node:node_auto_index(id='7') create n1-[:FATHER_OF]-&gt;n2;
  start n1=node:node_auto_index(id='13'),n2=node:node_auto_index(id='8') create n1-[:MOTHER_OF]-&gt;n2;
  start n1=node:node_auto_index(id='13'),n2=node:node_auto_index(id='9') create n1-[:MOTHER_OF]-&gt;n2;
  start n1=node:node_auto_index(id='20'),n2=node:node_auto_index(id='1') create n1-[:FATHER_OF]-&gt;n2;
  
  COMMIT
  
  EXIT
  </code></pre>
  
  <p>And I can see lot of thing are created inside the test5.db folder,</p>
  
  <p>but when I go to my browser console I cant see any nodes there ?</p>
  
  <p>Is there anything more to do ? Am on the right way ? Please help me to move on !!!</p>
  
  <p>+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++</p>
  
  <p>My ne04j.properties contents are </p>
  
  <pre><code># Default values for the low-level graph engine
  #neostore.nodestore.db.mapped_memory=25M
  #neostore.relationshipstore.db.mapped_memory=50M
  #neostore.propertystore.db.mapped_memory=90M
  #neostore.propertystore.db.strings.mapped_memory=130M
  #neostore.propertystore.db.arrays.mapped_memory=130M
  
  # Enable this to be able to upgrade a store from an older version
  #allow_store_upgrade=true
  
  # Enable this to specify a parser other than the default one.
  #cypher_parser_version=2.0
  
  # Keep logical logs, helps debugging but uses more disk space, enabled for
  # legacy reasons To limit space needed to store historical logs use values such
  # as: "7 days" or "100M size" instead of "true" keep_logical_logs=true
  
  # Autoindexing
  
  # Enable auto-indexing for nodes, default is false node_auto_indexing=true
  
  # The node property keys to be auto-indexed, if enabled
  #node_keys_indexable=name,age node_keys_indexable=id,name,type
  
  
  # Enable auto-indexing for relationships, default is false relationship_auto_indexing=true
  
  # The relationship property keys to be auto-indexed, if enabled
  #relationship_keys_indexable=name,age relationship_keys_indexable=id,name,type,age
  
  # location of the database directory  org.neo4j.server.database.location=data/test5.db
  </code></pre>
  
  <p>and neo4j-server.properties are here</p>
  
  <pre><code>################################################################
  # Neo4j configuration
  #
  ################################################################
  
  #***************************************************************
  # Server configuration
  #***************************************************************
  
  # location of the database directory  org.neo4j.server.database.location=data/test7.db
  
  # Let the webserver only listen on the specified IP. Default is localhost (only
  # accept local connections). Uncomment to allow any connection. Please see the
  # security section in the neo4j manual before modifying this.
  #org.neo4j.server.webserver.address=0.0.0.0
  
  #
  # HTTP Connector
  #
  
  # http port (for all data, administrative, and UI access) org.neo4j.server.webserver.port=7474
  
  #
  # HTTPS Connector
  #
  
  # Turn https-support on/off org.neo4j.server.webserver.https.enabled=true
  
  # https port (for all data, administrative, and UI access) org.neo4j.server.webserver.https.port=7473
  
  # Certificate location (auto generated if the file does not exist) org.neo4j.server.webserver.https.cert.location=conf/ssl/snakeoil.cert
  
  # Private key location (auto generated if the file does not exist) org.neo4j.server.webserver.https.key.location=conf/ssl/snakeoil.key
  
  # Internally generated keystore (don't try to put your own
  # keystore there, it will get deleted when the server starts) org.neo4j.server.webserver.https.keystore.location=data/keystore
  
  #*****************************************************************
  # Administration client configuration
  #*****************************************************************
  
  # location of the servers round-robin database directory. Possible values:
  # - absolute path like /var/rrd
  # - path relative to the server working directory like data/rrd
  # - commented out, will default to the database data directory. org.neo4j.server.webadmin.rrdb.location=data/rrd
  
  # REST endpoint for the data API
  # Note the / in the end is mandatory org.neo4j.server.webadmin.data.uri=/db/data/
  
  # REST endpoint of the administration API (used by Webadmin) org.neo4j.server.webadmin.management.uri=/db/manage/
  
  # Low-level graph engine tuning file org.neo4j.server.db.tuning.properties=conf/neo4j.properties
  
  # The console services to be enabled org.neo4j.server.manage.console_engines=shell
  
  
  # Comma separated list of JAX-RS packages containing JAX-RS resources, one
  # package name for each mountpoint. The listed package names will be loaded
  # under the mountpoints specified. Uncomment this line to mount the
  # org.neo4j.examples.server.unmanaged.HelloWorldResource.java from
  # neo4j-examples under /examples/unmanaged, resulting in a final URL of
  # `http://localhost:7474/examples/unmanaged/helloworld/{nodeId}`
  #org.neo4j.server.thirdparty_jaxrs_classes=org.neo4j.examples.server.unmanaged=/examples/unmanaged
  
  
  #*****************************************************************
  # HTTP logging configuration
  #*****************************************************************
  
  # HTTP logging is disabled. HTTP logging can be enabled by setting this
  # property to 'true'. org.neo4j.server.http.log.enabled=false
  
  # Logging policy file that governs how HTTP log output is presented and
  # archived. Note: changing the rollover and retention policy is sensible, but
  # changing the output format is less so, since it is configured to use the
  # ubiquitous common log format org.neo4j.server.http.log.config=conf/neo4j-http-logging.xml
  </code></pre>