I'm trying to import an excel file with just nodes at the moment, with a lot of custom attributes. A shortened example:
id |
email |
superuser |
key_type |
description |
organisation |
ttl |
886 |
my.mail@ddr.es |
false |
read |
Testkey für Stephan Hradek |
memyself |
1513318963 |
887 |
my.mail@ddr.es |
false |
read |
Stephan Test 1 |
|
1544882709 |
888 |
my.mail@ddr.es |
false |
read |
Stephan Test 3 |
|
1545122505 |
889 |
my.mail@ddr.es |
false |
read |
shk |
|
1545312219 |
890 |
my.mail@ddr.es |
false |
read |
shk |
|
1545312807 |
891 |
my.mail@ddr.es |
true |
write |
test Hradek 2 |
|
1545312966 |
892 |
my.mail@ddr.es |
false |
read |
botfrei-cheater |
|
1547197043 |
The custom properties should be "Integer" for "id" and "ttl" and "binary" for "superuser".
Integer is not recognized. It gets imported as "Decimal". Also binary is not regognized but imported as "Text"
My property mapping is
Data Source |
Map To |
Conversion |
id |
Label Text |
Automatic |
key_type |
Fill Color |
Distinct Values |
superuser |
Fill Color |
Distinct Values |
Just the key_type mapping works.
id is not shown unless I switch the Custom Properties to "Integer" and reapply. Same for superuser. I have to manually switch it to binary and reapply the mapping.
Is there any way I can define a (kind of) import schema for excel files?
Additionally I'm wondering whether or not it is possible to group my nodes by a property (email here) and have the property value become the group's label.