apoc icon indicating copy to clipboard operation
apoc copied to clipboard

Data format discrepancy with and without using the option bulkImport: true

Open smallcat9603 opened this issue 1 year ago • 1 comments

I used apoc.export.csv.all() to export the graph data to local CSV files, but I found the data format discrepancy with and without using the option bulkImport: true. When not using bulkImport: true, the node properties are saved in an all-in-one CSV file, e.g, a string list ["a", "b", "c"]. When using bulkImport: true, the node properties are saved to multiple CSV files categorized by node labels. But in this case the string list becomes [a, b, c]. The quotes disappeared. This will introduce errors when directly using apoc.import.csv() to read data from these CSV files.

It seems that apoc.import.csv() works well with the data generated by apoc.export.csv.all() with the option bulkImport: true, except for the quote issue in the CSV files.

smallcat9603 avatar Jan 25 '24 14:01 smallcat9603