Current date/time to/from user archive with C-script

In the meantime I solved the issue 2 (adding WinCC tags to a field). It seems there is a general option for the archive concerning Communication.

That still leaves only option 1 to be solved.

Here's how to do it.
Please note that I'm not very familiar with "C" and quite frankly, I don't really understand all of it (pragma code ?, SYSTEMTIME *lpst ?), so maybe there are better ways to do it.


STORE CURRENT DATE/TIME IN A USER ARCHIVE (field 1, fieldtype Date/Time)
-----------------------------------------------------------------------------------------------------------------------

#include "apdefap.h"

int gscAction( void )
{

#pragma code ("kernel32.dll");
VOID GetLocalTime (SYSTEMTIME *lpst);
#pragma code ();

UAHCONNECT hConnect = 0;
UAHARCHIVE hArchive = 0;
SYSTEMTIME DateTime;

// OPEN ARCHIVE GENERAL PRODUCTION DATA
// connect to component user archives
if ( uaConnect( &hConnect ) == FALSE )
{
printf( "uaConnect error:%d, ", "uaGetLastError()" );
goto finish1;
}
if ( hConnect == NULL )
{
printf("Handle UAHCONNECT equals 0, " );
goto finish1;
}
// connect to archive via archivename
if (uaQueryArchiveByName( hConnect, "GeneralProdData", &hArchive ) == FALSE )
{
printf( "uaQueryArchive Error:%d, ", "uaGetLastError()" );
goto finish1;
}
// open archive
if ( uaArchiveOpen( hArchive ) == FALSE )
{
printf( "GeneralProdData Open Error, " );
goto finish1;
}

// move to first record (SHIFT DATA)
if (uaArchiveMoveFirst(hArchive) == FALSE )
{
printf("GeneralProdData Move First Error, " );
goto finish1;
}
GetLocalTime(&DateTime); // get current date / time
uaArchiveSetFieldValueDate (hArchive, 1, &DateTime );
// update archive
uaArchiveUpdate(hProdArchive );
// close archive
finish1:;
uaArchiveClose ( hArchive );
uaReleaseArchive ( hArchive ); // release connection
hArchive = 0;
uaDisconnect ( hConnect ); // disconnect user archive
hConnect = 0;

return 0;

}

GET STOREDDATE/TIMEFROM A USER ARCHIVE AND MOVE INTO A TAG (type STRING)
-----------------------------------------------------------------------------------------------------------------------------------------
Create the following (project) function


void DateTimeToTag(SYSTEMTIME DateTime, char* TagName)
{
// Converts Date/Time (SYSTEMTIME format) to Date/Time in string format
char sTemp[24];
char sDateTime[24];

// add day
sprintf (sTemp, "%d", DateTime.wDay );
if (strlen ( sTemp) == 1 )
{
strcpy ( sDateTime, "0" ); // 0
}
else
{
strcpy ( sDateTime, "" ); //
}
strcat (sDateTime, sTemp ); // dd
// add month
sprintf (sTemp, "%d", DateTime.wMonth );
if (strlen ( sTemp ) == 1 )
{
strcat (sDateTime, "/0" ); // dd/0
}
else
{
strcat (sDateTime, "/" ); // dd/
}
strcat (sDateTime, sTemp ); // dd/mm
// add year
strcat (sDateTime, "/" ); // dd/mm/
sprintf (sTemp, "%d", DateTime.wYear );
strcat (sDateTime, sTemp ); // dd/mm/yyyy

// add hour
sprintf (sTemp, "%d", DateTime.wHour );
if (strlen ( sTemp ) == 1 )
{
strcat (sDateTime, " 0" ); // dd/mm/yyyy_0
}
else
{
strcat (sDateTime, " " ); // dd/mm/yyyy_
}
strcat (sDateTime, sTemp ); // dd/mm/yyyy_hh
// add minutes
sprintf (sTemp, "%d", DateTime.wMinute );
if (strlen ( sTemp ) == 1 )
{
strcat (sDateTime, ":0" ); // dd/mm/yyyy_hh:0
}
else
{
strcat (sDateTime, ":" ); // dd/mm/yyyy_hh:
}
strcat (sDateTime, sTemp ); // mm/dd/yyyy_hh:mm

// add seconds
sprintf (sTemp, "%d", DateTime.wSecond );
if (strlen ( sTemp ) == 1 )
{
strcat (sDateTime, ":0" ); // dd/mm/yyyy_hh:mm:0
}
else
{
strcat (sDateTime, ":" ); // dd/mm/yyyy_hh:mm:
}
strcat (sDateTime, sTemp ); // dd/mm/yyyy_hh:mm:ss
SetTagChar(TagName, sDateTime);

}






Call this function with
...
...
uaArchiveGetFieldValueDate(hArchive, 1,&DateTime);
DateTimeToTag ( DateTime, "StartDateTime");
...
...

where the first field in the user archive is of the type "Date/Time" and "StartDateTime" is an internal tag of type "Text tag 8 bit character set" which can be used in a report for example.