如何将数据导入到Windows 7的Neo4j（Neo4j的社区-2.0.0）？(How to im

2019-10-29 21:22发布

站内文章 / 移动开发
70 0 0

我得到了下面的链接要做到这一点，但问题是，它是针对Linux用户！

http://blog.neo4j.org/2013/03/importing-data-into-neo4j-spreadsheet.html

请帮我得到这个在Windows上做了什么？ 提前致谢。

我是新来的Neo4j和只拿到上的Java经验的小手。

我加neo4jtools到我的Neo4j服务器从下面的链接

https://github.com/jexp/neo4j-shell-tools

然后我按照这个命令将一些数据导入到图形数据库

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

我得到这样一个消息在命令提示符

> Transaction started
> +-------------------+ | No data returned. |
> +-------------------+ Nodes created: 20 Properties set: 60 3586 ms Transaction committed Transaction started ERROR (-v for expanded
> information):
>         MissingIndexException: Index `node_auto_index` does not exist

我IMPORT.TXT文件内容是这些

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]->n2;
start n1=node:node_auto_index(id='1'),n2=node:node_auto_index(id='12') create n1-[:MOTHER_OF]->n2;
start n1=node:node_auto_index(id='1'),n2=node:node_auto_index(id='13') create n1-[:MOTHER_OF]->n2;
start n1=node:node_auto_index(id='2'),n2=node:node_auto_index(id='14') create n1-[:MOTHER_OF]->n2;
start n1=node:node_auto_index(id='2'),n2=node:node_auto_index(id='15') create n1-[:MOTHER_OF]->n2;
start n1=node:node_auto_index(id='2'),n2=node:node_auto_index(id='16') create n1-[:MOTHER_OF]->n2;
start n1=node:node_auto_index(id='3'),n2=node:node_auto_index(id='17') create n1-[:MOTHER_OF]->n2;
start n1=node:node_auto_index(id='3'),n2=node:node_auto_index(id='18') create n1-[:MOTHER_OF]->n2;
start n1=node:node_auto_index(id='3'),n2=node:node_auto_index(id='19') create n1-[:MOTHER_OF]->n2;
start n1=node:node_auto_index(id='10'),n2=node:node_auto_index(id='20') create n1-[:FATHER_OF]->n2;
start n1=node:node_auto_index(id='14'),n2=node:node_auto_index(id='1') create n1-[:MOTHER_OF]->n2;
start n1=node:node_auto_index(id='11'),n2=node:node_auto_index(id='2') create n1-[:MOTHER_OF]->n2;
start n1=node:node_auto_index(id='11'),n2=node:node_auto_index(id='3') create n1-[:MOTHER_OF]->n2;
start n1=node:node_auto_index(id='12'),n2=node:node_auto_index(id='4') create n1-[:MOTHER_OF]->n2;
start n1=node:node_auto_index(id='12'),n2=node:node_auto_index(id='5') create n1-[:MOTHER_OF]->n2;
start n1=node:node_auto_index(id='12'),n2=node:node_auto_index(id='6') create n1-[:MOTHER_OF]->n2;
start n1=node:node_auto_index(id='17'),n2=node:node_auto_index(id='7') create n1-[:FATHER_OF]->n2;
start n1=node:node_auto_index(id='13'),n2=node:node_auto_index(id='8') create n1-[:MOTHER_OF]->n2;
start n1=node:node_auto_index(id='13'),n2=node:node_auto_index(id='9') create n1-[:MOTHER_OF]->n2;
start n1=node:node_auto_index(id='20'),n2=node:node_auto_index(id='1') create n1-[:FATHER_OF]->n2;

COMMIT

EXIT

我可以看到很多东西都在test5.db文件夹内创建，

但是当我去我的浏览器控制台我不能看到任何节点呢？

有什么更多的事情要做？ 上午的正确方法？ 请帮我继续前进！

++++++++++++++++++++++++++++++++++++++++++++++++++ +++++++++++++++++

我ne04j.properties内容

# 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

和neo4j-server.properties在这里

################################################################
# 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

Answer 1:

什么是你的配置是什么样子？

你有没有启用自动索引，就像这样： 

# 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=id,name,type

取出哈希，并确保该id属性被列出。 你可能会或可能不会添加name和type的索引查找性能以及。

你也看不到任何东西在你的浏览器，因为你创建data/test5.db但服务器默认寻找data/graph.db 。

  1. 因此，无论使用此目录。
  2. 或启动服务器，然后离开关-path参数和外壳将连接到您正在运行的服务器。


Answer 2:

你的最终目标是要导入的sheet.So按照你所提供的链接中给出的步骤，把暗号查询在file.Then使用Java代码来读取文件（ BufferReader ），并使用ExecutionEngine运行CYPHER查询。

虽然复制的查询不要忘记把将认识到循环暗号queries.Run查询的开始和结束的任何分离器。



Answer 3:

如果你正在寻找从其他来源的数据导入到Neo4j的，你可以使用ETL软件一样了Talend。 这里是一个一步一步后显示如何在一个简单的方法： 数据导入到Neo4j的直接使用了Talend 。 它展示了如何从MS SQL Sever的导入数据，但你可以很容易地更改源



文章来源: How to import data into neo4j (neo4j-community-2.0.0) in windows 7?
标签： neo4j cypher neo4jclient node-neo4j neo4j-spatial
举报

收藏的人(0)

Ta的文章 更多文章
登录 后发表评论
0条评论
还没有人评论过~