Saved Arrows Cypher export to Aura free?
mark.evans1960@yahoo.co.uk
Is there any way of pasting Cypher from Arrows into Aura Free Workspace (Query) . We are doing a Neo4J POC for a very large client and need this feature to prove out our Use Case examples (which are created in Arrows in some detail). Without this ability - the POC will stop and we'll need to look at a similar graph DB.
mark.evans1960@yahoo.co.uk
Hi Gregory, We have some complex versions of the following type of Cypher Query code which depicts Metadata Model structures from Industry Type Enterprise Data Models. This is just a simple example here: 'CREATE (:Party)-[:has Sub Type]->(:
Sub Type
{Discriminator Attribute
: "Party Type"})-[:_RELATED {Party Type
: "Individual"}]->(:Party). This is the end product of drawing up a 'use case model' in Arrows. I copy this or put it into the clip board but I cannot get it into Aura> Query > Neo4J$ prompt - I assume you would drop it in here? I've tried it in both Firefox & Chrome. If you look at the Arrows tool it suggests that you export it to Neo4J (i.e. Run in NEO4J Browser). If I had Desktop version then maybe I could do this, however I need Aura as we cannot set anything up on Machines locally for a POC in the short available time frame. I can bring in static elements of the model by CSV no problem. However, the variable paths through the model attach to the static structure as Mappings and are based upon 'Business Terms' e.g. 'Interest Rate', 'Tax Rate' etc. These are modelled within Arrows and hence the Query - which I need to 'Merge' into the static elements. I can do this - however, I just cannot get the code in there in the 1st place. Maybe I've missed something simple here? This is a use case which many firms will come up with in the future especially financial based companies. Thanks for the reply much appreciated. Mark Evans. .
Gregory King
mark.evans1960@yahoo.co.uk:
From what you have pasted, it appears arrows is not correctly quoting labels and relationship types that contain spaces. If you quote then with backticks when they have spaces then they will work. However it may be easier to follow established conventions on label and relationship type naming, so you don't have to contend with spaces and correcting the quoting.
Nonetheless, here are the two variants, one with quoted spaces and one that is more conventional:
Quoted:
CREATE (:Party)-[:`has Sub Type`]->(:`Sub Type` {`Discriminator Attribute`: "Party Type"})-[:`_RELATED` {`Party Type`: "Individual"}]->(:Party)
Following conventions:
CREATE (:Party)-[:HAS_SUB_TYPE]->(:SubType {discriminatorAttribute: "Party Type"})-[:RELATED {partyType: "Individual"}]->(:Party)
mark.evans1960@yahoo.co.uk
Gregory King: thanks for this Gregory, I have not got as far as this my immediate problem is how do you get it in there in the workspace version i.e. Aura> Query > Neo4J$ I assume you paste it into this line. It does not go in as no option to paste is shown. I just need a way of getting existing Cypher Code into a prompt so that I can run it against the DB. Thanks. When I get this to work I'll take note of what you've said concerning the actual code.
Gregory King
mark.evans1960@yahoo.co.uk: even though it's not shown in the context menu when you right click (we'll look into that), you should be able to use a keyboard shortcut to paste things into the editor (ctrl+v on windows and linux or cmd+v on mac).
mark.evans1960@yahoo.co.uk
Gregory King: Thanks Gregory, yes I tried ctrl+v and it didn't work, but did not do right click at all. Usually you just left click in the box to establish a presence there and do ctrl+v. Never thought of right click and then ctrl+v - anyway that's solved it, such a simple thing, but not at all obvious. Thanks. I note your comment on the Cypher syntax from Arrows and that's very useful to know. Arrows is very useful for visually mocking up complex use cases and due to the Cypher generation capability saves you much time, even if you need to edit the results later using the rules you prescribe above. We have 50+ complex Business Terms which we create in Arrows, save the Cypher and then merge into a pre-existing Meta Data Graph representation. It is an unusual use case as low data volumes with great complexity of relationship, the opposite of most Graph use Cases. Should work fine now. I'm new to Neo4J (2 days of experience so far) so sorry if I seem a little naive.
Gregory King
mark.evans1960@yahoo.co.uk: No worries Mark, I'm not sure what is happening causing you to need to right-click to enable paste. If you have anything like browser/os version that might help us reproduce, do let me know.
mark.evans1960@yahoo.co.uk
Gregory King: Hi Gregory, using Firefox on LInux Ubuntu Zorin OS Fork V16.3. Have to right click 1st otherwise does not paste in at all. Thanks.
Gregory King
mark.evans1960@yahoo.co.uk: Thanks for taking the time to post back. Since this works on Firefox on other OSs, I suspect this could be something at the OS level affecting you, for example there are historic reports of copy/paste breaking on some ubuntu variants. Will keep an eye out to see if others report to, but it might be that OS and/or Firefox updates fix this for you.
mark.evans1960@yahoo.co.uk
Gregory King: HI Gregory, thanks for you help much appreciated. One thing I meant to ask is what is the strategic path for the 'Arrows Tool' - for what we're doing it is extremely useful as we model at 'Business Term' level. Each Business Term can be contained within one Arrows diagram nicely - and many have up to 30 constituent parts to them. The POC I'm doing so far uses Arrows as an integral part, and I see this continuing to Production. Hopefully Arrows is 'strategic' within Neo4J as I'm not sure how we would manage without it. It is great to prototype and then you can easily save the results in many formats for later use and export. Thanks.
mark.evans1960@yahoo.co.uk
Gregory King: HI Gregory, thanks for you help much appreciated. One thing I meant to ask is what is the strategic path for the 'Arrows Tool' - for what we're doing it is extremely useful as we model at 'Business Term' level. Each Business Term can be contained within one Arrows diagram nicely - and many have up to 30 constituent parts to them. The POC I'm doing so far uses Arrows as an integral part, and I see this continuing to Production. Hopefully Arrows is 'strategic' within Neo4J as I'm not sure how we would manage without it. It is great to prototype and then you can easily save the results in many formats for later use and export. Thanks.
Gregory King
mark.evans1960@yahoo.co.uk: Arrows continues to be maintained as a Neo4j Labs project, we know it has a lot of followers.
We have fledgling "model only" support in the Import tab of Workspace, ie you can use it to sketch out and save models without doing an import. However it sounds like the way you are using Arrows is to create "instance data" rather than a pure graph data model and are interested in using that to generate sample data that you can, for example, load into the DB and rapidly perform test queries against. Does that fairly represent your use?
If you're willing, I'd be interested in talking more with you on you use of Arrows. I'll drop you an email.
Andreas Kollegger
mark.evans1960@yahoo.co.uk and Gregory King
I've created an issue on Arrows to fix the Cypher export problem, found here: https://github.com/neo4j-labs/arrows.app/issues/97
Mark, would you mind contributing your thoughts about Arrows to an ongoing survey? I'd appreciate any input. https://neo4j.typeform.com/arrows2023
Gregory King
Hey Mark, could you elaborate a little. It should be possible to paster Cypher generated from Arrows into Query, so maybe you're asking for something else?