I am using the FTP Advanced 'Long_List' command to get files from an FTP server and populating the results to a dataset. All the sample tasks show you should loop on the dataset to download the individual files, but if there are not files to download, the task fails with 'myDataSet' variable does not exist. If there are files, the task works as expected. So, how to you test for this condition to exit gracefully?

Category Survey

Hi PeteMeyer,

Can you please tell me your Server Connection type?

Category Survey

-------------------------
// Ronak Patel,
// Automate Development Team
// Network Automation, Inc. - No Code, No Limits Business Process Automation

I'm using SFTP, port 22

Category Survey

Hi Pete,

This will be corrected in the next maintenance release.

http://www.networkautomation.c...sueid=a20099883028144

There are 2 workarounds for this issue:

1. Connect using the standard FTP connection rather than SFTP.
2. Use compatibility mode.

Category Survey AutoMate 7 version: Windows version:

-------------------------

Leonard Amabile | Director, Cross Platform Support
AutoMate | InterMapper | Skybot | Divisions of HelpSystems
T: +1.213.738.1700 | F: +1.213.738.7665

Arrgh... this bug also exists when trying to connect to a FTP server using Explicit SSL, passive mode.

Category Survey

Hi Pete,

Are you running v7.1.1.0?

Category Survey AutoMate 7 version: Windows version:

-------------------------

Leonard Amabile | Director, Cross Platform Support
AutoMate | InterMapper | Skybot | Divisions of HelpSystems
T: +1.213.738.1700 | F: +1.213.738.7665

Yes

Category Survey

Hi Pete,

I have forwarded this to our QA dept for verification.

Category Survey AutoMate 7 version: Windows version:

-------------------------

Leonard Amabile | Director, Cross Platform Support
AutoMate | InterMapper | Skybot | Divisions of HelpSystems
T: +1.213.738.1700 | F: +1.213.738.7665

Hi Pete,

We cannot reproduce the problem internally. Can you post the contents of your output tab? What is the exact error you are receiving?

Category Survey AutoMate 7 version: Windows version:

-------------------------

Leonard Amabile | Director, Cross Platform Support
AutoMate | InterMapper | Skybot | Divisions of HelpSystems
T: +1.213.738.1700 | F: +1.213.738.7665

Variable "FTPFileList" does not exist

Category Survey

Hi Pete,

Do you mind exporting your task and sending the .aml file to support@networkautomation.com? I would like to verify the issue with our DEV team.

Category Survey AutoMate 7 version: Windows version:

-------------------------

Leonard Amabile | Director, Cross Platform Support
AutoMate | InterMapper | Skybot | Divisions of HelpSystems
T: +1.213.738.1700 | F: +1.213.738.7665

Task has been emailed to you.

Category Survey

Hi Pete,

We received your task and it's being reviewed. We may have to schedule another GotoMeeting session in order to verify the issue. I will keep you posted.

Category Survey AutoMate 7 version: Windows version:

-------------------------

Leonard Amabile | Director, Cross Platform Support
AutoMate | InterMapper | Skybot | Divisions of HelpSystems
T: +1.213.738.1700 | F: +1.213.738.7665

Any update on this???

Category Survey

Hi Pete,

Did you receive the email from our support team earlier today?

Category Survey AutoMate 7 version: Windows version:

-------------------------

Leonard Amabile | Director, Cross Platform Support
AutoMate | InterMapper | Skybot | Divisions of HelpSystems
T: +1.213.738.1700 | F: +1.213.738.7665

I was in the same situation like this, what I did was,

I used an If statement before download

If dataset.FTPFileType = 1

Loop dataset

download files

Increment countfile  ---Variable

so after finishing the loop, I used the condition If Countfile = 0

send mail "No Files to Download"

Category Survey

Suresh,

Can you attach your code so we can better examine the issue?

 

Category Survey

-------------------------
Thank you for choosing AutoMate.

Marjo

<a class="ftalternatingbarlinklarge" href="http://www.networkautomation.com" target="_blank">Network Automation, Inc. - No Code, No Limits Business Process Automation</A>

Hello,

I'm trying Automate 7.1.3.0  and I have a problem with Tutorial

Module 4 - FTP Uploads by Files Last Modified Date

link: http://www.networkautomation.com/urc/tutorials/module-4-ftp-uploads-by-files-last-modified-date/82D9F52F-9E82-4024-86992221C22E0578/

in particular "FTP Advanced/Get long file list" function doesn't create any daset (slide 102/138).

Can you help me please?

Category Survey

Claudio,

Are there files present in the folder you are monitoring? A dataset only gets created if files are present. Please post what you can of your task.

Category Survey AutoMate 7 version: Windows version:

-------------------------

Leonard Amabile | Director, Cross Platform Support
AutoMate | InterMapper | Skybot | Divisions of HelpSystems
T: +1.213.738.1700 | F: +1.213.738.7665

Yes, there are files in the remote directory, but I think the problem is in the function "Get long list file". In it I selected the data label, and in the field "Create a dataset with..." I inserted the dataset name "FTPFileList". In the next step I have to use this dataset in a "IF" condition, but I DON'T FIND my dataset name in the DataSet folder. I should find it looklike in the tootorial.

What do you think about?

Category Survey

Hi Claudio,

Which field in your FTPFileList dataset did you want to reference?

For example if the field name is FileName, then you would refer to FTPFileList.FileName to address that specific fiel with the current dataset row.

If there is still an unresolved case, can you post your task steps using the Attach Code button?

Category Survey

-------------------------
- Rick Johnson
Network Automation

Sorry Rick,

I think I haven't explain well my problem. I find nothing of my FTPFileList dataset, even the name. Below my code, with a comment before the step "IF":

<AMVARIABLE NAME="TheLocalFileDate"></AMVARIABLE>
<AMVARIABLE NAME="TheLocalFile"></AMVARIABLE>
<AMVARIABLE NAME="TheFileName"></AMVARIABLE>
<AMFTPLOGIN SERVER="cam65" USERNAME="username" PASSWORD="AM1eP275Sbdumo=aME" PORT="21" />
<AMLOOP TYPE="FOLDER" FOLDER="C:\Documents and Settings\Claudio Rossi\Desktop\prova" RESULTVARIABLE="TheLocalFile">
     <AMSET VARIABLENAME="TheFileName">%ExtractFileName(TheLocalFile)%</AMSET>
     <AMSET VARIABLENAME="TheLocalFileDate">%FileDateTime(TheLocalFile)%</AMSET>
     <AMFTPADVANCED FTPCOMMAND="long_list" FTPLONGLISTDATASET="FTPListFile" PARAMETER="%TheFileName%" />

 

     <!-- here I want to compare the local file date with "FTPFileList.FTPFileDate" but iI don't find my dataset in the folder "Datasets" because the "long_list" function doesn't create the dataset. -->

<AMIF EXPRESSION="%TheLocalFileDate% > ">

 

     </AMLOOP>
</AMIF>
<AMFTPLOGOFF />

Category Survey

Edited: 10/07/2010 at 11:58 PM by ClaudioRossi

Claudio,
I would suggest that in addition to creating a dataset you also specify a variable to populate with the returned data.
If the variable is empty, that means there is nothing in the list, and then you can avoid looping the dataset, which is for sure not created.

Category Survey AutoMate 7 version: Windows version:

-------------------------
Jean Delfosse - Automate Beta Tester
Win7 Pro 64 bits -Win XP Pro SP3 32 bits - AM8, AM7, BPA10, BPA9, BPA8, BPA7, AM6 Enterprise, AM4

Hello Jean,

and thankyou for your answer. I have followed the steps shown in TUTORIAL n.4:

Link to tutorial lesson 4: http://www.networkautomation.com/urc/tutorials/module-4-ftp-uploads-by-files-last-modified-date/82D9F52F-9E82-4024-86992221C22E0578/

I wonder why on my pc with automate 7.1.3.0 doesn't work like in the tutorial.

In any case, could you post the code to do how you are suggesting please?

Thank you in advance!

Category Survey

Claudio,
In one of my ftp sites I have manually created an "emptyfolder" folder
the task below navigates first to the parent folder then to the emptyfolder and issues a longlist with results in a var "list" and a dataset "ds2"
The second message box displays that in the emptyfolder "list" is empty and ds2.totalrows=0
Testing these values will tell you that there are no files in there.

You can experience it on one of your own ftpsites just by changing the credentials and paths

Category Survey AutoMate 7 version: Windows version:

Task Steps: (Right click, Select All, Copy to copy to the clipboard. Steps can then be pasted into the AutoMate Task Builder)
<AMFTPLOGIN SERVER="theftpsite" USERNAME="vsa" PASSWORD="AM1dNE1veIBgfE=aME" COMPATIBILITY="YES" PORT="21" /> <AMVARIABLE NAME="list"></AMVARIABLE> <AMFTPADVANCED FTPCOMMAND="change_folder" PARAMETER="httpdocs/docs/annonces" /> <AMFTPADVANCED FTPCOMMAND="long_list" FTPLONGLISTDATASET="ds1" RESULTVARIABLE="list" /> <AMMESSAGEBOX>%len(list)% bytes %ds1.TotalRows% rows %list%</AMMESSAGEBOX> <AMFTPADVANCED FTPCOMMAND="change_folder" PARAMETER="emptyfolder" /> <AMFTPADVANCED FTPCOMMAND="long_list" FTPLONGLISTDATASET="ds2" RESULTVARIABLE="list" /> <AMMESSAGEBOX>%len(list)% bytes %ds2.TotalRows% rows &gt;%list%&lt;</AMMESSAGEBOX> <AMLOOP TYPE="DATASET" DATASET="ds2"> <AMMESSAGEBOX>ds2 loop</AMMESSAGEBOX> </AMLOOP>

-------------------------
Jean Delfosse - Automate Beta Tester
Win7 Pro 64 bits -Win XP Pro SP3 32 bits - AM8, AM7, BPA10, BPA9, BPA8, BPA7, AM6 Enterprise, AM4

I am having the same issue, I am using Automate 10, the system is issuing an error in the event of a blank data set.
FTP faile (Error: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.)

Category Survey AutoMate 7 version: Windows version: Windows 2008 R2

-------------------------
William Doyle
Director, IT
Southco, Inc.
210 N. Brinton Lake Rd.
Concordville, PA 19331

Edited: 05/02/2016 at 12:07 PM by WilliamDoyle

The message went away....No idea, sometimes when there are no files, it is timing out while looking.

Category Survey AutoMate 7 version: Windows version: Windows 2008 R2

-------------------------
William Doyle
Director, IT
Southco, Inc.
210 N. Brinton Lake Rd.
Concordville, PA 19331

Hello William,

Many servers set the timeout on their side. You may want to enquire to see if there is a timeout, and if so, we may adjust for it accordingly.

Category Survey AutoMate 7 version: Windows version:

-------------------------

Alex Escalante | Support Analyst
AutoMate | Division of HelpSystems
HelpSystems, LLC | T: +1.213.738.1700 | F: +1.213.738.7665

Hi William,

Is there still issues with this?  If so, could you please provide the task involved and the specific error message it's giving?

Category Survey AutoMate 7 version: Windows version:

-------------------------

Devin Cannon | Support Analyst
AutoMate | Division of HelpSystems
HelpSystems, LLC | T: +1.213.738.1700 | F: +1.213.738.7665