TlgAddRecord

Hi,
you will find informations in FAQ http://support.automation.siemens.com/WW/view/de/22809091
or in wincc information system under "options > User archives"

I've expanded (changed) the script in FAQ
http://support.automation.siemens.com/WW/view/de/24363822
by using the following functions:

uaArchiveInsert()
uaArchiveSetFieldValueXXX()
uaArchiveMoveLast()
uaArchiveGetFieldValueLong()

NOTE:
It's necessary to manage the internal archive-ID by yourself, because the "ID" must be unique!!!
- the function "uaArchiveMoveLast()" goes to the last record
- the function "uaArchiveGetFieldValueLong()" read the fieldzero (ID)
- the function "uaArchiveSetFieldValueXXX()" is used to writethe values of allfields of thenew record into an "internal buffer" ==> the valueof field 0 (ID)was incremented
- the function "uaArchiveInsert()" inserts the new record



========================================


#include "apdefap.h"
int CRT3884_UAInsert(void)
{
UAHCONNECT hConnect;
UAHARCHIVE hArchive;
BOOL bOK;
int iRet = 0;
static long ID = 1100;
///////////////////////////////////////////////////////////
// connect component user archive
//////////////////////////////////////////////////////////
bOK = uaConnect(&hConnect);
if ((bOK == FALSE) || (hConnect == NULL)){
printf ("#E101: CRT3884_UAExport() - uaConnect failed! error=%d\r\n", uaGetLastError());
iRet = -101;
return (iRet);
}

///////////////////////////////////////////////////////////
// connect to archive via name
//////////////////////////////////////////////////////////
bOK = uaQueryArchiveByName(hConnect, "MyArchive", &hArchive);
if ((bOK == FALSE) || (hArchive == NULL)){
uaDisconnect(hConnect);
printf ("#E201: CRT3884_UAExport() - uaQueryArchiveByName failed! error=%d\r\n", uaGetLastError());
iRet = -201;
return (iRet);
}

///////////////////////////////////////////////////////////
// set filter
//////////////////////////////////////////////////////////
//bOK = uaArchiveSetFilter(hArchive, "ChargeName like '%charge%' and DateBegin >= '2006-01-01 00:00:00' AND DateBegin < '2007-01-01'");
if (bOK == FALSE){
printf ("#E301: CRT3884_UAExport() - uaArchiveSetFilter failed! error=%d\r\n", uaGetLastError());
iRet = -301;
return (iRet);
}

///////////////////////////////////////////////////////////
// set sort
//////////////////////////////////////////////////////////
//bOK = uaArchiveSetSort(hArchive, "ChargeUser , ChargeName desc");
if (bOK == FALSE){
printf ("#E302: CRT3884_UAExport() - uaArchiveSetSort failed! error=%d\r\n", uaGetLastError());
iRet = -302;
}

///////////////////////////////////////////////////////////
// open archive
//////////////////////////////////////////////////////////
bOK = uaArchiveOpen(hArchive);
if (bOK == FALSE){
uaReleaseArchive(hArchive);
uaDisconnect(hConnect);
printf ("#E401: CRT3884_UAExport() - uaArchiveOpen failed! error=%d\r\n", uaGetLastError());
iRet = -401;
return (iRet);
}

///////////////////////////////////////////////////////////
// export archive
//////////////////////////////////////////////////////////
bOK = uaArchiveExport(hArchive, "p:\\tmp\\MyArchive.csv", 0, 0);
if (bOK == FALSE){
printf ("#E501: CRT3884_UAExport() - uaArchiveExport failed! error=%d\r\n");
iRet = -501;
}

bOK = uaArchiveMoveLast (hArchive);
if (bOK == FALSE){
printf ("#E504: CRT3884_UAExport() - uaArchiveMoveLast \r\n");
iRet = -504;
return (iRet);
}

bOK = uaArchiveGetFieldValueLong (hArchive, 0, &ID);
if (bOK == FALSE){
printf ("#E504: CRT3884_UAExport() - uaArchiveGetFieldValueLong \r\n");
iRet = -504;
return (iRet);
}

ID++;
bOK = uaArchiveSetFieldValueLong(hArchive, 0, ID);
if (bOK == FALSE){
printf ("#E411: CRT3884_UAExport() - uaArchiveSetFieldValueLong \r\n");
iRet = -411;
return (iRet);
}
bOK = uaArchiveSetFieldValueFloat(hArchive, 1, 100.1);
if (bOK == FALSE){
printf ("#E412: CRT3884_UAExport() - uaArchiveSetFieldValueLong \r\n");
iRet = -412;
return (iRet);
}
bOK = uaArchiveSetFieldValueFloat(hArchive, 2, 200.2);
if (bOK == FALSE){
printf ("#E413: CRT3884_UAExport() - uaArchiveSetFieldValueLong \r\n");
iRet = -413;
return (iRet);
}
bOK = uaArchiveInsert(hArchive);
if (bOK == FALSE){
printf ("#E421: CRT3884_UAExport() - uaArchiveInsert\r\n");
iRet = -421;
return (iRet);
}