Replace time stamps in ASCII Export file

[Bonsai]

Dear all,

we all know that it's not a good way to transfer the WinCC OA database into a version control system. So my solution was to transfer only the ASCII files.
But now I have the problem that I have many changes between the ASCII files on the server and the client, because there are different timestamps at the original values.

My solution to this problem could be an algorithm that checks the file after export and replaces all time stamps with "01.01.1970". But that's annoying and not the best way.
There is no way that the AsciiManager exports with a "fix" timestamp, is there? Is there an other good solution?

Thank You!

[leoknipp]

When doing an ASCII export for the original values there is no possibility to "remove" the time stamps or to replace them with a fixed values.
Probably you can start a command which reads only the "columns" for the attributes and write it to a new file, .e.g using the "cut" command. The ASCII file is a tab separated file.

Best Regards
Leopold Knipp
Senior Support Specialist

[Bonsai]

I found a solution. I do the export within a control manager and after the export I reopen the exported file and replace the timestamps there. That works good.

But now, I have another problem. I create for every DPT an own DPL File (to make possible merges easier). That file contains DPT and all according DPs. After ~10 called ascii exports via the system() function I get the following message:

Code: Select all

WCCOAascii0:WCCOAascii   (0), 2018.06.26 15:20:21.726, SYS,  SEVERE,     69, Database error, RAIMA Database Error *** Code:-921 (SYSTEM/OS error: -921
WCCOAascii0:DBUSERID is already being used
WCCOAascii0:C errno = 0: No error
WCCOAascii0:FILE: D:\\workspaces\\3.13\\workspace\\ExternLibs\\rdm45\\runtime\\Dblfcns.c(493))

WCCOAascii0:WCCOAascii   (0), 2018.06.26 15:20:21.800, SYS,  SEVERE,     69, Database error, TypeAndIdDb, open
WCCOAascii0:cannot open TypeAndIdDb
WCCOAascii0:doAsciiOut returned error code: -2

What's the reason of this message and what can I do against this?

[Bonsai]

Justus Meyer wrote:

[...]

Code: Select all

WCCOAascii0:WCCOAascii   (0), 2018.06.26 15:20:21.726, SYS,  SEVERE,     69, Database error, RAIMA Database Error *** Code:-921 (SYSTEM/OS error: -921
WCCOAascii0:DBUSERID is already being used
WCCOAascii0:C errno = 0: No error
WCCOAascii0:FILE: D:\\workspaces\\3.13\\workspace\\ExternLibs\\rdm45\\runtime\\Dblfcns.c(493))

WCCOAascii0:WCCOAascii   (0), 2018.06.26 15:20:21.800, SYS,  SEVERE,     69, Database error, TypeAndIdDb, open
WCCOAascii0:cannot open TypeAndIdDb
WCCOAascii0:doAsciiOut returned error code: -2

What's the reason of this message and what can I do against this?

Does anyone know what to do with this log message?