more quick actions
minimize quick actions
Topic starter
Hi,
One of our customer got an error while he using the FTP command in SB.
The error is
His coding is
Sub Up ()
Dim cFTPdestn As Str, cLocalSource As Str;
Dim cName As Str, cPass As Str, cStatusVar As Str, cFileName As Str;
Dim iReturn As Integer;
cFTPdestn = "************************************************";
cFileName = "customreport.xlsx";
cName = "************************************************";
cPass = "****************************************************";
cStatusVar = "@Report.StatusFTP";
iReturn = FTP("UPLOAD", cFileName, cFTPdestn, 1, cName, cPass, cStatusVar);
Print ("Return from FTP upload is ", iReturn);
End Sub
Output of CstatusVar comes 0 and iReturn is 7.
I tried to access the FTP via chrome it works good but in file explorer, it shows an error
My questions are:
1) What will be the issue?
2) Is FTP command in SB use functions of windows for uploading and downloading?
3) What is error 553?
Thanks in advance.
TM
Posted : 08/07/2019 2:41 pm
Hi,
First and foremost, I edited your post to remove all the credentials... even if its too late as we all recevied them with the notification email !
Regarding the error, did you try to connect the FTP Server with FileZilla ?
The 553 error indicates that you can't access create the file in the directory. You may need need to change the permissions.
Posted : 08/07/2019 2:48 pm
Topic starter
Thank you for removing the credentials.
Yes, it is working with FileZilla.
ftp client is able to do if there is any permission issue ftp client might not be able to do as well, right?
Posted : 08/07/2019 2:55 pm
Hi Tijo,
How are you? I did quick search on Google and found this topic that looks similar.
Symptom :
1. able to write file manually
2. when use script, user receives error 553 file name not allowed.
The issue stated in the article was because the user login used had a default directory so the supplied URL became invalid as it was trying to locate the whole path in the default directory.
So my suggestion, first check if the user login that you are using have any default directory. Secondly, try with cFTPdestn containing only the IP/host address.
Posted : 09/07/2019 2:52 pm