Start a new topic
Answered

Crushftp task fileparser problem

 I'm trying to read out a csv file containing a name and a url, which I want to loop thru, connect and get files from the server.
Now I'm using the fileparser task. I tried to email me the given values from the csv file, but it always writes in the mail first line with the variable name and afterwards the lines with the correct values.
Now forwarding these values to a find task, it only works with the first value pair, which contains only the variable names and can not connect to. So the task fails and does not loop thru to the next variable pair.
Anyone an idea what I'm missing or doing wrong?

CSV File:
nas;url;
packsize-nas-01;packsize-nas-01.mylenovoemc.com
packsize-nas-12;packsize-nas-12.mylenovoemc.com
packsize-nas-16;packsize-nas-16.mylenovoemc.com

Logfile:
1 11/18/2015 01:56:39 PM:tasks.Task.:CrushTask items size=0
2 11/18/2015 01:56:39 PM:tasks.FindTask.Find:Starting...
3 11/18/2015 01:56:39 PM:tasks.FindTask.Find:Finding items in path:/D:/
4 11/18/2015 01:56:39 PM:tasks.FindTask.Find:(1) Getting list for /D:/
5 11/18/2015 01:56:39 PM:tasks.FindTask.Find:Found 9 in folder /D:/
6 11/18/2015 01:56:39 PM:tasks.FindTask.Find:Got list1 with items:9
7 11/18/2015 01:56:39 PM:tasks.FindTask.Find:Filtering find with check1 items:1
8 11/18/2015 01:56:39 PM:tasks.FindTask.Find:Added:FILE:/D:/packsize_nas_devices.csv
9 11/18/2015 01:56:39 PM:tasks.FindTask.Find:Completing find with newItems items:1
10 11/18/2015 01:56:39 PM:tasks.FileParserTask.FileParser:Starting...
11 11/18/2015 01:56:39 PM:tasks.FileParserTask.FileParser:Result count:4
12 11/18/2015 01:56:39 PM:tasks.EmailTask.Email:Starting...
13 11/18/2015 01:56:39 PM:tasks.EmailTask.Email:to:heiner.wellendorf@pco-online.de cc: bcc:
14 11/18/2015 01:56:39 PM:tasks.EmailTask.Email:from:cdatashare@pco-datacenter.de
15 11/18/2015 01:56:39 PM:tasks.EmailTask.Email:reply_to:
16 11/18/2015 01:56:39 PM:tasks.EmailTask.Email:subject:NAS found
17 11/18/2015 01:56:39 PM:tasks.EmailTask.Email:body:NAS: {nasDevice} Url: {nasUrl}
18 NAS: packsize-nas-01 Url: packsize-nas-01.mylenovoemc.com
19 NAS: packsize-nas-12 Url: packsize-nas-12.mylenovoemc.com
20 NAS: packsize-nas-16 Url: packsize-nas-16.mylenovoemc.com
21
22 11/18/2015 01:56:39 PM:tasks.EmailTask.Email:email results:Success!
23 11/18/2015 01:56:39 PM:tasks.FindTask.Find:Starting...
24 11/18/2015 01:56:40 PM:tasks.FindTask.Find:Finding items in path:/Packsize/
25 11/18/2015 01:56:42 PM:tasks.FindTask.Find:is8GA0d8lI-Job task:Read_Packsize_NAS_Devices:y9DknHSnKXkrlSLVC9xH
26 11/18/2015 01:56:42 PM:tasks.FindTask.Find:java.net.UnknownHostException: {nasUrl}
27 11/18/2015 01:56:42 PM:tasks.FindTask.Find:java.net.AbstractPlainSocketImpl.connect:-1
28 11/18/2015 01:56:42 PM:tasks.FindTask.Find:java.net.PlainSocketImpl.connect:-1
29 11/18/2015 01:56:42 PM:tasks.FindTask.Find:java.net.SocksSocketImpl.connect:-1
30 11/18/2015 01:56:42 PM:tasks.FindTask.Find:java.net.Socket.connect:-1
31 11/18/2015 01:56:42 PM:tasks.FindTask.Find:java.net.Socket.connect:-1
32 11/18/2015 01:56:42 PM:tasks.FindTask.Find:java.net.Socket.<init>:-1
33 11/18/2015 01:56:42 PM:tasks.FindTask.Find:java.net.Socket.<init>:-1
34 11/18/2015 01:56:42 PM:tasks.FindTask.Find:com.crushftp.client.Common.getSocket:1404
35 11/18/2015 01:56:42 PM:tasks.FindTask.Find:com.crushftp.client.SFTPClient.reconnect:128
36 11/18/2015 01:56:42 PM:tasks.FindTask.Find:com.crushftp.client.SFTPClient.login2:99
37 11/18/2015 01:56:42 PM:tasks.FindTask.Find:com.crushftp.client.GenericClient.login:117
38 11/18/2015 01:56:42 PM:tasks.FindTask.Find:tasks.FindTask.run:71
39 11/18/2015 01:56:42 PM:tasks.FindTask.Find:tasks.Task.go:148
40 11/18/2015 01:56:42 PM:tasks.FindTask.Find:CrushTask.Start$2.run:541
41 11/18/2015 01:56:42 PM:tasks.FindTask.Find:java.lang.Thread.run:-1

Why is there the first line with {nasDevice}{nasUrl} which are my variable names for the Fileparser task???

Thanks and kind regards,
hEINER

PNG

Best Answer

This all relates to the ticket you have open and how your going through the tasks in the job.  I believe Arpad is assisting you further on this, so I am closing the forum request.


For other users reading this....


The basic idea is a FIleParser to get text:// reference items.  Then repeatedly looping through calling the Find task filtered with the source items as text:* and the find filter as *.  Then a userVariable task to see if there are more filtered items of text:// and if so, loop and repeat.  If not, move on tot he next steps and start copying everything.

1 Comment

Answer

This all relates to the ticket you have open and how your going through the tasks in the job.  I believe Arpad is assisting you further on this, so I am closing the forum request.


For other users reading this....


The basic idea is a FIleParser to get text:// reference items.  Then repeatedly looping through calling the Find task filtered with the source items as text:* and the find filter as *.  Then a userVariable task to see if there are more filtered items of text:// and if so, loop and repeat.  If not, move on tot he next steps and start copying everything.

Login to post a comment