Forum Discussion

Harsha3's avatar
Harsha3
New Contributor III
5 years ago

File writing using smb path

Hi Good day,

I am trying to write a file in the remote desktop server . Instead of hardcoding the data I have parametrized certain fields as we have sequential child execution running for each country.

This is my path:

‘smb://sgkcawveemwdv02.astrazeneca.net/D$/Dataloader/IE/REPORT_EXTRACT/’
+Country+‘/CALL_EXTRACT/EXTRACT_OUTBOUND/’+(Date.now().plusDays(1).toString()).substring(0,10).replaceAll(‘-’,‘’)+" AZ_Veeva_Activity_Call_Detail_OUTBOUND+“_”+_Country+“.csv”

It is showing parsing error at “EXTRACT_OUTBOUND” . Please help in getting this resolved.

Thanks,
Harshavardhana

pipeline

2 Replies

  • SpiroTaleski's avatar
    SpiroTaleski
    Valued Contributor
    5 years ago

    @Harsha3

    Please try with the below path :

    “smb://sgkcawveemwdv02.astrazeneca.net/D$/Dataloader/IE/REPORT_EXTRACT/Country/CALL_EXTRACT/EXTRACT_OUTBOUND/”+(Date.now().plusDays(1).toString()).substring(0,10).replaceAll(‘-’,‘’)+" AZ_Veeva_Activity_Call_Detail_OUTBOUND"+“_”+_Country+“.csv”

    Regards,
    Spiro Taleski

    • Harsha3's avatar
      Harsha3
      New Contributor III
      5 years ago

      Hi Taleski,

      Thanks so much it works when I changed the plex to Groundplex . Moreover for writing the files in SMB does “File operation” snap works , I could find that the operation is not supported when writing the file from source to target within a server , however the same approach works well in the case of S3 writer.

      Source:

      “smb://sgkcawveemwdv02.astrazeneca.net/D$/Dataloader/IE/REPORT_EXTRACT/”+_Country+“/CALL_EXTRACT/EXTRACT_OUTBOUND/”+(Date.now().plusDays(1).toString()).substring(0,10).replaceAll(‘-’,‘’)+“AZ_Veeva_Activity_Call_Detail_OUTBOUND"+"”+_Country+“.csv”

      Target:
      “smb://sgkcawveemwdv02.astrazeneca.net/D$/Dataloader/IE/REPORT_EXTRACT/”+_Country+“/CALL_EXTRACT/ARCHIVE/”+(Date.now().plusDays(1).toString()).substring(0,10).replaceAll(‘-’,‘’)+“AZ_Veeva_Activity_Call_Detail_OUTBOUND"+"”+_Country+“.csv”

      Operation performed : Copy

      Plex used :Groundplex ( by changing the plex to cloudplex the file writer snap fails )

      Thanks,
      Harshavardhana