Vasko, I just put the SQLImporter project on GIThub, https://github.com/peterneubauer/sql-import, so feel free to fork and fix the parsing bug and upgrade to a current Neo4j version (it's currently at 1.1), since I might not have time to look into it directly!
/peter On Wed, Feb 16, 2011 at 5:58 AM, vasko yordan <[email protected]> wrote: > Hello Peter, > > I love the idea of matching RDBMS to Neo4J but I am having a hard time > making it reality! I have very simple schema and SQLImporter fails to > recognise the relations.Please help.Example below: > > Thank you. > > INSERT INTO wp_bp_friends > (id,initiator_user_id,friend_user_id,is_confirmed,is_limited,date_created) > VALUES > (1,2,5,1,0,{ts '2010-04-26 13:09:10.'}); > INSERT INTO wp_users > (ID,user_login,user_pass,user_nicename,user_email,user_url,user_registered,user_activation_key,user_status,display_name,spam,deleted) > VALUES > (1,'admin','xxxxxxxxxxxxxxxx.','admin','[email protected]','http://test.com',{ts > '2010-03-06 05:56:33.'},'',0,'Admin',0,0); > > > ..... > > importer.autoLink("wp_users", "ID", > "wp_bp_friends","initiator_user_id","friend_of"); > importer.autoImport(SQL_FILE); > > > Result: > .. > .. > could not find target node for value INTO wp_users(ID in index > wp_bp_friends:initiator_user_id > created 0 relationships between > wp_users:ID--friend_of->wp_bp_friends:initiator_user_id index prop in 264ms > _______________________________________________ Neo4j mailing list [email protected] https://lists.neo4j.org/mailman/listinfo/user
