Head's Up! These forums are read-only. All users and content have migrated. Please join us at community.neo4j.com.
05-18-2021 09:32 PM
hello
I am using neo4j 3.5.14 version. I need to import csvs through bulk import operation. after configuring the nodes and relationship files I executes commands in script file'
but getting this error
unexpected error: Duplicate header entries found first RAJSHAHI:string, other (and conflicting) RAJSHAHI:string
neo4j-admin import \
--id-type=string \
--ignore-missing-nodes=true \
--ignore-extra-columns=true \
--max-memory=200g \
--ignore-duplicate-nodes=true \
--nodes=AGENT= **"AGENT_HEADER.csv,nodes_AGENT.csv"** \
--nodes=CUSTOMER= **"CUSTOMER_HEADER.csv,nodes_CUSTOMER.csv"** \
--nodes=MERCHANT= **"MERCHANT_HEADER.csv,nodes_MERCHANT.csv"** \
--nodes=DM= **"DM_HEADER.csv,nodes_DM.csv"** \
--nodes=BILLER= **"BILLER_HEADER.csv,nodes_BILLER.csv"** \
--nodes=BANK= **"BANK_HEADER.csv,nodes_BANK.csv"** \
--nodes=NONLABEL= **"NONLABEL_HEADER.csv,nodes_NON.csv"** \
--nodes=ATM= **"ATM_HEADER.csv,nodes_ATM.csv"** \
--nodes=CARD= **"CARD_HEADER.csv,nodes_CARD.csv"** \
--nodes=REMITTER= **"REMITTER_HEADER.csv,nodes_REMITTER.csv"** \
--relationships=SENDMONEY= **"relationship_SENDMONEY-HEADER.csv,relationship_SENDMONEY.csv"** \
--relationships=CASHOUT= **"relationship_CASHOUT-HEADER.csv,relationship_CASHOUT.csv"** \
--relationships=CASHIN= **"relationship_CASHIN-HEADER.csv,relationship_CASHIN.csv"** \
--relationships=PAYMENT= **"relationship_PAYMENT-HEADER,relationship_PAYMENT.csv"** \
--relationships=DISBURSE= **"relationship_DISBURSE-MERCHANT-HEADER.csv,relationship_DISBURSE-MERCHANT.csv"** \
--relationships=DISBURSE= **"relationship_DISBURSE-DM-HEADER.csv,relationship_DISBURSE-DM.csv"** \
--relationships=PAYBILL= **"relationship_PAYBILL-HEADER.csv,relationship_PAYBILL.csv"** \
--relationships=IBANKING= **"relationship_IBANKING-HEADER.csv,relationship_IBANKING.csv"** \
--relationships=REMIT= **"relationship_REMIT-HEADER.csv,relationship_REMIT.csv"** \
--relationships=C2W= **"relationship_C2W-HEADER.csv,relationship_C2W.csv"** \
--relationships=ATMCO= **"relationship_ATMCO-HEADER.csv,relationship_ATMCO.csv"** \
--relationships=AIRTIME= **"relationship_AIRTIME-AGENT-HEADER.csv,relationship_AIRTIME-AGENT.csv"** \
--relationships=AIRTIME= **"relationship_AIRTIME-CUSTOMER-HEADER.csv,relationship_AIRTIME-CUSTOMER.csv"** \
--relationships=AIRTIME= **"relationship_AIRTIME-MERCHANT-HEADER.csv,relationship_AIRTIME-MERCHANT.csv"** \
--relationships=AIRTIME= **"relationship_AIRTIME-DM-HEADER.csv,relationship_AIRTIME-DM.csv"** \
--relationships=AIRTIME= **"relationship_AIRTIME-NONLABEL-HEADER.csv,relationship_AIRTIME-NON.csv"** \
--relationships=AIRTIME= **"relationship_AIRTIME-BILLER-HEADER.csv,relationship_AIRTIME-BILLER.csv"** \
--relationships=AIRTIME= **"relationship_AIRTIME-ATM-HEADER.csv,relationship_AIRTIME-ATM.csv"** \
--relationships=AIRTIME= **"relationship_AIRTIME-BANK-HEADER.csv,relationship_AIRTIME-BANK.csv"** \
--relationships=AIRTIME= **"relationship_AIRTIME-CARD-HEADER.csv,relationship_AIRTIME-CARD.csv"** \
--relationships=AIRTIME= **"relationship_AIRTIME-REMITTER-HEADER.csv,relationship_AIRTIME-REMITTER.csv"** \
--high-io=true
this is my command script file . how could I solve this issue
05-19-2021 11:38 AM
I would grep RAJSHAHI *.csv
for RAJSHAHI
in your csv files to see which file contains the offending string.
My wild guess is that RAJSHAHI
is actually data and not the name of a column, which would infer that one of your .csv files is missing a header row.
But hard to say for sure...
01-12-2022 05:18 PM
Did you find a solution to this? I am having a very similar issue. my error gives a bit more detail.
org.neo4j.internal.batchimport.input.DuplicateHeaderException: Duplicate header entries found in /var/lib/neo4j/import/node_mara_conc.csv, first 0.0:string, other (and conflicting) 0.0:string
I'm not sure what this means or what needs to be corrected. Anyone have any explanation or suggestions for me to look into?
All the sessions of the conference are now available online