Error : Export of csv from browser

Hello Team,

Getting below error while exporting csv from browser:

Neo.ClientError.Procedure.ProcedureCallFailed: Failed to invoke procedure apoc.export.csv.query: Caused by: java.io.FileNotFoundException: /datasan01/neo4japp/neo4j-enterprise-3.5.3/import/tmp/sample.csv (No such file or directory)

Best Regards
Akshat

You should create a folder named 'tmp' in 'import' folder and then run the export query.

Hi Akshat,

have you take a look at this part of the documentation?
https://neo4j.com/docs/labs/apoc/current/export/csv/#export-csv-file-export

Might help you, if not, could you share the exact Cypher query? Then we can have a look.

Cheers,
Ron

Hello Ron,

Below is my query:

call apoc.export.csv.query("MATCH p = (sc:SITE_CODE_TABLE)<-[:site2sitecode]-(s:SITE)-[:site2container]->(c:CONTAINER)-[:container2mostatic]->(m:MO_STATIC_TABLE)
where c.EQUIP_TYPE = 'BBU'
RETURN
CASE
WHEN s.SITE_OWNER = 'RCOM' THEN 'P1-RCOM'
WHEN s.SITE_OWNER = 'RJIL' THEN 'P1-RJIL' END AS OWNER,
c.EQUIP_NAME AS LOGICAL_NAME,
c.EQUIP_VENDOR AS VENDOR,
c.EQUIP_SITE_NAME AS LOCATION,
m.type AS TYPE,
'ucmdb' AS UPDATED_BY,
c.EQUIP_STATUS AS ISTATUS,
c.EQUIP_NATIVENAME AS ASSET_TAG,
c.EQUIP_MAINTENANCEPOINT AS CORP_STRUCTURE,
c.EQUIP_TYPE AS TEMP_TYPE,
s.SITE_CIRCLE AS RIL_CIRCLE,
s.SITE_AREACODE AS RIL_AREA,
c.CREATED_DATE AS CREATED_BY_DATE,
c.MODIFIED_DATE AS SYSMODTIME,
s.POST_CODE AS RIL_ZIP,
s.SITE_MAINTENANCEPOINT AS RIL_MNTPOINT,
s.SITE_CITY AS RIL_CITY,
c.EQUIP_MODEL AS RIL_MAKEMODEL,
c.EQUIP_NEID AS RIL_CIID,
sc.SITE_REGION AS RIL_REGION,
m.parentci AS PARENTCI,
c.EQUIP_TYPE AS RIL_GRANITETYPE,
s.SITE_R4G_STATE AS RIL_R4GSTATE,
s.SAPID AS RIL_SAPID,
s.SITE_OWNER AS RIL_SITEOWNER,
s.SITE_LEASED_REFERENCE_CODE AS RIL_SITELEASEDOWNER,
s.SITE_FRIENDLY_NAME AS RIL_FRIENDLYNAME,
'https://www.google.com/maps/place/'+s.SITE_LATITUDE+'+'+s.SITE_LONGITUDE+'/@'+s.SITE_LATITUDE+','+s.SITE_LONGITUDE+'z' AS RIL_GISURL,
s.JIO_CENTER AS RIL_JIOCENTRE,
m.devicetype AS RIL_DEVICETYPE,
'ucmdb' AS SYSMODUSER,
'ucmdb' AS CREATED_BY,
s.JIO_CENTER_CODE AS PSTATUS,
s.SITE_TYPE AS RIL_SITETYPE limit 6","/tmp/neo4j/sample.csv",{d:','});