Export signals to file

Alles zur Software WinPLC-Analyzer

Moderatoren: Matthias, Weiss_MHJ

Antworten
Thijs
SPSTreff-Fortgeschrittener User
Beiträge: 12
Registriert: 24 Aug 2010, 15:54

Export signals to file

Beitrag von Thijs »

1. Time-format
There seems to be something wrong with the time-format in the export file.
[ms] below 100 respectively 10 are exported as '.nn' and '.n' instead of the standard '.nnn'. This results in wrong interpretations by other applications.
Example:
WinPLC-Analyzer alternative
12:59:56.200 (OK, eventually 12:59:56.2)
13:00:14.40 13:00:14.040
Please always use 3 numbers, thus use preceding zero's, for the [ms]!
Is it possible to give this item priority (I have to export a lot of measurements this week).

2. Header
In the header of the file, a main part of the address, the DB-number, is missing for variables in Datablocks.
Example: DW6 should be DB40.DBW6
Or, even better: several header-rows with:
Header-row 1: general connection data (PC-name, PLC-type/ID, PLC-address, interface, routing etc.)
Header-row 2: per column: Address (for DB: <DB-no.>.<DB-address>)
Header-row 3: per column: Type
Header-row 4: per column: Unit
Header-row 5: per column: Symbol
Header-row 6: per column: Comment
Rows (following): data

3. Export file-name
Idea: <signal-window name>.csv (editable)
instead of 'WinPLC-Analyzer_EXPORT.TXT' for every export.
The export-file can be exported to the project-folder instead of the
signal window-folder, to prevent copying this files when copying/duplicating a signal window.

Benutzeravatar
Matthias
SPSTreff-Profi User
Beiträge: 285
Registriert: 19 Jun 2010, 11:16
Wohnort: Bretten
Kontaktdaten:

Beitrag von Matthias »

Hello,

yes these things are useful.

We will implement this in one of the next service pack for WinPLC-Analyzer.

Thijs
SPSTreff-Fortgeschrittener User
Beiträge: 12
Registriert: 24 Aug 2010, 15:54

Beitrag von Thijs »

Can you inform me when a service pack is available for item 1.?
Thanks in advance.

Benutzeravatar
Matthias
SPSTreff-Profi User
Beiträge: 285
Registriert: 19 Jun 2010, 11:16
Wohnort: Bretten
Kontaktdaten:

Beitrag von Matthias »

Yes, of course.

Thijs
SPSTreff-Fortgeschrittener User
Beiträge: 12
Registriert: 24 Aug 2010, 15:54

Beitrag von Thijs »

addition:
Is it possible to choose the date- and time-separator?
It seems to be fixed, thus not following the OS-settings.

For the field-separator it's already possible.
The Help-function:
- describes the field separator is fixed
- the Time-format misses the [ms]

I follow a temporary workaround with Notepad++ (and it's macro-recording function) to modify the export-files manually.

Benutzeravatar
Matthias
SPSTreff-Profi User
Beiträge: 285
Registriert: 19 Jun 2010, 11:16
Wohnort: Bretten
Kontaktdaten:

Beitrag von Matthias »

The format of time and date is fix.

I implement a short turnaround.
If the language setting in WinPLC-Analyzer isn't german the date will be exported as:

2010-08-30

(YY-MM-DD)

Time:

16:48:00.000

(HH:MM:SS.MS)

Thijs
SPSTreff-Fortgeschrittener User
Beiträge: 12
Registriert: 24 Aug 2010, 15:54

Beitrag von Thijs »

With V3.2.1.5 the modification of the time-format functions, thanks!

Thijs
SPSTreff-Fortgeschrittener User
Beiträge: 12
Registriert: 24 Aug 2010, 15:54

Beitrag von Thijs »

Just for information, I have the following question.
This problem of the time-format of the [ms] seems to be a general Windows(?) problem.
I have looked at the results of a previous program I used, made with Borland Delhi (using the Siemens Prodave function-set). It had the same bug when exporting <time>.
Also some programs using [ms] in the default file name tend to use, erroneously, a variable number-format for the [ms].
Can you confirm this?

Benutzeravatar
Matthias
SPSTreff-Profi User
Beiträge: 285
Registriert: 19 Jun 2010, 11:16
Wohnort: Bretten
Kontaktdaten:

Beitrag von Matthias »

Hello,

i format the time-export via "wsprintf".
3-digit value format:

wsprintf(Milliseconds,"%03d", wMilliSecond);

Result: "001" if "wMilliSecond" = 1

Maybe i don't understand your question.

Thijs
SPSTreff-Fortgeschrittener User
Beiträge: 12
Registriert: 24 Aug 2010, 15:54

Beitrag von Thijs »

You're right.
I thought about a problem in maintaining the time as a variable or reading it from the system.
The fault occurs indeed when it is output with statements like your example.
Thanks.

Antworten