03-02-2021 09:07 PM
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
03-03-2021 02:34 PM
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
03-11-2021 07:59 PM
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