Hi all,

once installed, followed all the directions the Tech Notes TN-0043-A0 “Using FileZilla FTP Server with a DT80 Series Logger“,
but I can not upload files to FileZilla FTP Server.

I have checked all connection settings and seem to be okay according to the instructions.

There is no antivirus or firewall software on the computer installed.
I have checked the Windows Firewall it is disabled and checked username, password that are entered correctly.

I have a static IP address assigned on my PC and dataTaker. There are no IP address filters and autoban is not enabled.

This is the error that I keep getting when I try to send the command in Command Window:
DO{COPYD id=1 start=new merge=n FORMAT=csv dest="ftp://qbh:qbh@169.254.55.162/"}

"Failed to create listen socket on port 21
Failed to create a listen socket on any of the specified ports. Server is not online!"

Most FTP servers use port 21, but DtUsb web interface dEX also when the FileZilla FTP Server and dEX at the same time is working.
I checked from command prompt cmd: netstat -a -b -n >D:\test.txt if the port 21 is listening or it's in use by some other program.

Proto Lokale Adresse Remoteadresse Status PID

TCP 127.1.1.1:21 0.0.0.0:0 ABH™REN 280
[DtUsb.exe]

TCP 0.0.0.0:21 0.0.0.0:0 ABH™REN 3940
[FileZilla Server.exe]

So I look it up, port 21 does not working at the same time.

I have tried to use both possibilities.
In the first place I added one Manual channel (called FTP_1) and entered into text area:
DO{COPYD id=1 start=new merge=n FORMAT=csv dest="ftp://qbh:qbh@169.254.55.162/"}

secondly one FTP logged data (Menu-> Add-> Action-> FTP logged data) entered into text box
IP adress, username and password. The text box for Folder and File left empty.

Am I doing this correctly or not? What should I do?

Then I started my schedule and closed the Web Interface dEX afterwards started FileZilla FTP Server, so that port 21 used only once.
But it didn't help, data files are not transferred.
There seems to be no way to get FileZilla FTP Server to connect to dataTaker.

On the other hand, a client PC per crossover cable connected with PC FileZilla FTP Server it works! Data files are transferred.

Have I missed out on anything? Maybe command-line switches, parameters or file commandos on dataTaker?

Please I need some help?

Thanks in advance.

Best regards
edie

Hi edie,

How do you connect your dataTaker to your network?
Have you set up dataTaker IP address, subnet and gateway?

Best regards,
Rudy Gunawan

Hello Rudy,

Thanks a lot for your reply.

I have assigned by my PC static IP adresss, subnet and gateway (gateway field is blank) the same on dataTaker the ip adress changed last number.
I have used/use crossover cable.

I have tried various settings but nothing works.
The problem is, the port 21 is already being used by FileZilla FTP Server and dataTaker. The FileZilla FTP Server doesn't work.
I just tested with port 22 on FileZilla FTP Server. I changed also by dataTaker instead 21 of this 22. It works now!

Best regards,
edie

Hello again,

I have two different issues. The first is, when I insert, manually configure a FTP logged data (Menu-> Add-> Action-> FTP logged data) and
the text box for folder and file left blank all uploaded files I getting with timestemp.
My question is, can I determine the file name? It's possible? How can I replace file names in this case?

I need a permanent file name without timestamp, for each schedule?

e.g.

schedule a = tem_1.csv
schedule b = tem_2.csv
schedule c = tem_3.csv
schedule d = tem_4.csv
schedule e = tem_5.csv

secondly, what is the difference between one Manual channel with copyD command and FTP logged data (Menu-> Add-> Action-> FTP logged data)?
Can I change the port 21 by copyD command? I can not upload files with copyD command. The problem is, the port 21 is already being used by FileZilla FTP Server and dataTaker.

please help me understand and troubleshoot this issue.

Thanks in advance.

Best regards
edie

Hi edie,

If field for folder and file name are blank, you will get automatic file name generated by dataTaker.
If you want to set permanent file name, please type in the name in the file box.

Different names for each schedule (as in your example) will require several FTPLogData channel, all you need to do are set the name and select the related schedule.

You may use manual channel or FTPLogData, there is no different between those two command.
And if you want to specify different port of FTP transmission using manual channel, you may add the number after FTP address.
Example:
Do{Copyd dest=ftp://username:password@xx.com:22 start=new}

Best regards,
Rudy Gunawan

Hello Rudy,

Thanks a lot for your support.
I am sorry to bother you again with this matter, but this is important for me.

When I using manual channel with copyD command:
DO{COPYD merge=n FORMAT=csv dest="ftp://datataker:datataker@169.254.55.163.com22/tem_1.csv"}
I keep getting the file name for example tem_1_A.csv, tem_1_B.csv or tem_1_E.csv according the schedules.
I would like file name for example tem_1.csv, tem_2.csv or tem_5.csv...only. without extensions _A, _B etc.

When I use FTPLogData and open tab Optional the controls being selected all the time. Why? And not every individual.
schedule_1 (A) selected all controlls
schedule_2 (B) selected B, C, D and E
schedule_3 (C) selected C, D and E
schedule_4 (D) selected D and E
schedule_5 (E) selected E
I must correct them.

Thanks in advance.

Best regards
edie

Hello again,

I have selected average controls on my RTD temperature sensors.
Why do I get two columns displayed? See attachment.

Thanks in advance.

Best regards,
edie

Hi edie,

Do not worry, I will answer any questions.

The first question is about file name.
In order to create the necessary file name per your request you will need to create many COPYD and put specific schedule for download and you miss this.

Example:
DO{COPYD merge=n sch=A dest="ftp://datataker:datataker@169.254.55.163.com22/tem_1.csv" format=CSV}
DO{COPYD merge=n sch=B dest="ftp://datataker:datataker@169.254.55.163.com22/tem_2.csv" format=CSV}
etc

If you saw the option of FTPLogData is not for every schedule, it could be the old version of dEX.
Could you inform me what is your dataTaker firmware version?

The second question is about two display column for average value.
This is because you check the "Log and display the value" in general section.
If you want to get only average value, remove this check.

I hope this will help you.

Best regards,
Rudy Gunawan

Hello Rudy,

thank you for all your assistance.

The dataTaker Firmware version is: 9.08.3932

The next question i have asked myself is: How to create an alarm for each schedule?
Take all the alarms in a file and upload with FTPLogData.
So, I would like to create an alarm, when values of maximum temperatures increase over e.g. of 50 degrees celsius.

Can i do this? Why?
Do you have an example for me?

Thanks in advance.

Best regards,
edie

Hi edie,

Data has a default memory allocation of 1 MB, while Alarms has 100 kB.
You may need to increase memory allocation for this purpose, then use conditional statement IF to trigger an alarm.
Please check page 77-79 of DT8x manual.

I write this example in command console mode and not in dEX.
Manual channel will be required to write a conditional statement for dEX programming.

RA30S
REFT("Internal Temperature~degC",=1CV)
IF(1CV>50)"Hot temperature"
RB10M
DO{COPYD merge=n sch=A Al=Y dest="ftp://datataker:datataker@169.254.55.163.com22/tem_1.csv" format=CSV}

In dEX you may choose the record (data, alarm, data+ alarm) to transfer out.

Best regards,
Rudy

Hello Rudy,

many, many thanks for all your help.
I have tried hard but I can't to write a conditional statement for dEX programming. I don't get it.
So, I have got a dataTaker and 4 CEM20 with PT385 (Platinum). They measure temperatures from -15°C up to 50°C.

schedule_1 (A) have 11 PT385 sensors
schedule_2 (B) have 20 PT385 sensors
schedule_3 (C) have 20 PT385 sensors
schedule_4 (D) have 20 PT385 sensors
schedule_5 (E) have 20 PT385 sensors

When values of maximum temperatures increase over e.g. of 50 °C of one of the sensors, then will be stored alarm messages from this sensor.
I want to know which sensor is defect and if required replace it.
I would like to store in a separate file without dates.

Could you please explain that in detail I would like to understand the syntax:
RA30S
What is this - 30S
What is the abbreviation from - REFT
And this: "Internal Temperature~degC" It should be replaced I have got PT385 (Platinum) sensor.
what is the meaning: 1CV
why B in RB10M, it's schedule_1 (A)

Could you please give me a hand I'm afraid I can't handle it.

Thanks in advance.

Best regards,
edie

Hello Rudy,

many, many thanks for all your help.

I have tried hard but I can't to write a conditional statement for dEX programming. I don't get it.

So, I have got a dataTaker and 4 CEM20 with PT385 (Platinum). They measure temperatures from -15°C up to 50°C.

schedule_1 (A) have 11 PT385 sensors
schedule_2 (B) have 20 PT385 sensors
schedule_3 (C) have 20 PT385 sensors
schedule_4 (D) have 20 PT385 sensors
schedule_5 (E) have 20 PT385 sensors

When values of maximum temperatures increase over e.g. of 50 °C of one of the sensors,then will be stored alarm messages from this sensor.
I want to know which sensor is defect and if required replace it.
I would like to store in a separate file without dates.

Could you please explain that in detail I would like to understand the syntax:

RA30S
What is this - 30S
What is the abbreviation from - REFT
And this: "Internal Temperature~degC" It should be replaced I have got PT385 (Platinum) sensor.
what is the meaning: 1CV
why B in RB10M, it's schedule_1 (A)

Could you please give me a hand I'm afraid I can't handle it.

Thanks in advance.

Best regards,
edie

Hi edie,

In my previous answer I use command console to guide you. This command console is a bit different than dEX.

Before I explain about dEX, I will give you a bit overview of my previous example.

RA30S
REFT("Internal Temperature~degC",=1CV)
IF(1CV>50)"Hot temperature"
RB10M
DO{COPYD merge=n sch=A Al=Y dest="ftp://datataker:datataker@169.254.55.163.com22/tem_1.csv" format=CSV}

• RA30S means you set schedule A for 30 seconds reading interval, this is similar to Schedule_1 (A) setting in dEX
• REFT is used to measure internal temperature of dataTaker, you may find this channel in Add – Measurement – Internal.
• In this REFT channel, I set channel name as Internal temperature and measurement unit as degC.
• I also saved REFT value to 1CV (channel variable no 1). Channel variable is a holding memory that may be used for manipulation of measurement result, dataTaker has 1CV – 1000CV.
• RB10M means you have schedule B to run every 10 minutes.

I understand that you are more familiar to dEX, so my apology for that answer.

I will give you step by step processes to program dataTaker through dEX.

1. If I used one RTD Pt100 as one example.
   

2. Set alarm limit of 50 °C for that RTD channel.
   

3. Set the output that you want, text file is usually used. In this setting you may also use additional command (only triggered if alarm happened).
   

4. You may need to send the data out every day.
   

5. Through FTP, only alarm
   

You can repeat those step for the other RTD.

I hope these instructions can help you.
If you have further questions, please do not hesitate to contact me. 

Best regards,
Rudy Gunawan

Hello Rudy,

thank you very much for all your help and support!

The step-by-step directions with screenshots was very helpful.

Let me briefly describe what we do.

I'm working at the Agricultural Research and Service Center ( freely translated) in south-west germany.

I conducted agricultural field experiments also including e.g. temperature measurement. For example, unfortunately this is in German:

http://www.am.rlp.de/Internet/global/inetcntr.nsf/dlr_web_full.xsp?src=F575L0ZX33&p1=XXUB6KJ051&p3=8XF90L07L8&p4=XJPZBV4849

At the moment we have summer, therefore we haven't got currently data.

We have bought new 2 dataTaker and 8 CEM20. I'm working on it and this is all very new to me.

So, I have another question:

By default, the dataTaker logged data separated by columns into a single file e.g. Timestamp 13.08.2013 03:54

Date and time separated by one blank.

Is it possible to separate with semicolon? For example: Timestamp 13.08.2013;03:54.

I checked page 25-27 of DT80 Range user's manual and found nothing.

Thanks in advance.

Best regards,

Mit freundlichen Grüßen
Ewald Pauz

Hi Ewald,

You may use semicolon as data separation by setting the parameter P22 and use ASCII list (please refer to parameter configuration on page 248 and 249 of DT8x manual).

Location in dEX:

By changing P22 value to 59, you will get semicolon (;) as your data delimiter.

Other setting such as date and time format can be set through parameter setting as well.

Please feel free to email me for any assistance.
I will do my best to help you.

Best regards,
Rudy Gunawan

Hello Rudy,

thank you very much for all your help.

I'm not sure but it seems that changing the default value from 36 to 59 defined separator characters (;) as the delimiter by data, but not by timestamp.

I would like to have instead of 15.08.2013 14:45. this 15.08.2013;14:45 (between date and time a semicolon as the delimiter).

And another thing: Can I omit the column B (TZ)?

So, I didn't manipulate data and will be put online.

It is possible? It would be very helpful for me.

I have the following data in a Text Editor.

I have the following data in an excel spreadsheet:

Have I missed out on anything? Any advice on how to handle this?

Thanks in advance.

Best regards,

Mit freundlichen Grüßen
Ewald Pauz

Hi Ewald,

You may use free data format to manually set date and time and remove TZ.
To activate free data format from dEX:

Turn off the following switches from dEX Advance option : C, H, N, T, U.
Then add 2 manual channels (date and time) before your measurement channel.
And you will get the required format.

Best regards,
Rudy Gunawan

Hello Rudy,

I really appreciate your patience and your support.

Sorry for my late reply.

I have followed the suggested steps but I still can't remove Timestamp and TZ.
Have I missed out on anything?

Thanks in advance.

Best regards,
Ewald Pauz

Hi Ewald,

How do you download the data?

This free format needs to have special syntax to retrieve that format.
If you want to save the data inside logger memory, you may issue the following as manual channel in dEX:
DO{COPYD dest=b:\data_?(timestamp).csv format=free start=new}

And to retrieve the data from the logger you can open up your windows explorer (not internet explorer),
Type in ftp://DATATAKER:DATATAKER@127.1.1.2/ in the address windows, note that 127.1.1.2 may be different in your case, please check your DTUsb setting.

There you will find your csv files.

If you retrieve the data through Monitor the logger, you cannot put additional option of format=free, therefore you will get a normal CSV.

Hope this can help you.

Best regards,
Rudy Gunawan

Hello Rudy,

Thank you very much for all your help!

What exactly do you mean with: How do you download the data?

I use manuel channel in dEX with the following syntax:
schedule a
DO{COPYD merge=n sch=A dest="ftp://qbh:qbh@169.254.55.163.com22/var_temp1.csv" format=CSV}
schedule b
DO{COPYD merge=n sch=B dest="ftp://qbh:qbh@169.254.55.163.com22/var_temp2.csv" format=CSV}
schedule c
DO{COPYD merge=n sch=C dest="ftp://qbh:qbh@169.254.55.163.com22/var_temp3.csv" format=CSV}
schedule d
DO{COPYD merge=n sch=D dest="ftp://qbh:qbh@169.254.55.163.com22/var_temp4.csv" format=CSV}
schedule e
DO{COPYD merge=n sch=E dest="ftp://qbh:qbh@169.254.55.163.com22/var_temp5.csv" format=CSV}

I need to clarify a couple of points the dest=b is inside logger memory.
I must to save the data inside logger memory of format=free?
With: DO{COPYD dest=b:\data_?(timestamp).csv format=free start=new}?

Could you please give me a hand I'm afraid I can't handle it?
I need a table without Timestamp and TZ columns.

Thanks in advance.

Best regards,
Ewald Pauz