No subject


Mon Feb 14 09:53:07 CET 2011


/peter

On Wed, Feb 16, 2011 at 5:58 AM, vasko yordan <vasko.yordan at gmail.com> 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','sean at generalunited.net','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
>


More information about the User mailing list