search

ANSSI-FR / AD-control-paths

Active Directory Control Paths auditing and graphing tools
https://www.sstic.org/2014/presentation/chemins_de_controle_active_directory/
Other
655 stars 99 forks source link

Error in inuput data; Extra column not present in header #15

Closed Nosako closed 7 years ago

Nosako commented 7 years ago

Hello, Firstly, thanks for the tools !

I have an issue when I try to import the csv files into Neo4j. I've got the following error :

Error in input data Caused by: Extra column not present in header on line 0 in ....\Ldap\OP_LDAp_obj.csv with value gPLink

This is the command line i ran : ".\bin\neo4j-import --into data/databses/adcp.db --id-type string --nodes $((dir PATH\Ldap\*.csv) -join ',')--relationships $((dir PATH\Relations*.csv -exclude *.deny.csv) -join ',') ` --input-encoding UTF-16LE --multile-fields=true --legacy-style-quoting=false"

I must precise that I'm working with a VM.

Have you any idea what's wrong with the import ?

gdedrouas commented 7 years ago

Yes, in the command you run, "--nodes $((dir PATH\Ldap*.csv)" is incorrect: it should only load the all_nodes.csv files. It contains every node harvested from all your ldap objects and relations files by the last step of the Dump script.

If this last step (MakeAllNodes) wasn't reached by the script, you can try -resume after fixing errors , or -generateCmdOnly to do it manually.

Nosako commented 7 years ago

Indeed, the command to dump files was wrong in the first place, I had to add the arg --ldpaonly to get the file "all_nodes.csv" Now it works like a charm ! Thanks !