Exporting and importing data records from and into

Siemens-AutomationandDrives-Service&Support-Aut...第1页共2页2005-05-312:47自动化系统SIMATICHMI人机界面HMI软件SCADA系统SIMATICWinCCSIMATICWinCC选件用户归档常问问题ExportingandimportingdatarecordsfromandintouserarchivesQUESTION:HowcanIexportandimportthedatarecordsofaWinCCuserarchive?ANSWER:ExportingdatarecordsToexportthedatarecords(runtimedata)oftheuserarchiveselected,chooseRuntimeDataExportontheuserarchiveEditormenutoopenthefollowingdialogbox:IntheFileSelectionboxenterthepathandfilenameoftheuserarchivetobeexported.The...buttonhelpsyoutofindthefileyouwant.Thedefaultfilepathistheuafolderintheprojectpathoftheactiveuserarchive.TheFileFormatboxletsyouchoosethefileformatfortheuserarchiveyouareexporting.WiththeOptionsbuttonyoucandefinetherequiredseparator.Thedefaultseparatoristhesemicolon;.IntheArchiveSelectionboxyoucanchooseoneoftheuserarchivesofthecurrentprojectastargetarchive.TheFilteroptionsletyoudefineafilterforexportingtheuserarchive.IntheforFieldboxenterthefieldtowhichthefilteristoapply.Inthefrom...toboxesgivethevaluerangetobefiltered.AfterclickingtheSQLExpressioncheckbox,youcanenterafilterexpressioninSQLlanguageintheinputfield.ThenclickExport.Thisisonlyactivatedwhenyouhavecompletedalltheboxes.Siemens-AutomationandDrives-Service&Support-Aut...第2页共2页2005-05-312:47Note:InWinCCV5.1andhigher,thecolumntitlesareexportedaswellandmustnotbechanged(e.g.inExcel).ImportingdatarecordsToimportthedatarecordsintoauserarchive,chooseRuntimeDataImportontheuserarchiveEditormenutoopenthefollowingdialogbox:IntheFileSelectionboxenterthepathandfilenameoftheuserarchivetobeimported.The...buttonhelpsyoutofindthefileyouwant.Thedefaultfilepathistheuafolderintheprojectpathoftheactiveuserarchive.IntheFileFormatboxyoucanselecttheformatoftheuserarchivetobeimported.WiththeOptionsbuttonyoucandefinetherequiredseparator.Thedefaultseparatoristhesemicolon;.IntheArchiveSelectionboxyoucanchooseoneoftheuserarchivesofthecurrentprojectastargetarchive.NowclickImportandtheimportstarts.Note:Theimportcanonlytakeplaceifthestructureofthesourceandtargetarchivesisthesame.Datarecordsalreadypresent(i.e.withthesameID)produceanerrormessageintheua_...,logfileandarenotoverwritten.Theotherdatarecordsareaddedtotheuserarchive.Foranexampleoftheformatofauserarchiveimport/exportfile,pleaserefertoEntryID8970879.InstructionsforexportingthearchivestructureofaWinCCuserarchivearegiveninEntryID8960838.Keywords:Runtimedata,Backup,Databackup条目号:8972156日期:02/15/2002©SiemensAG2005版权所有-法人信息-保密政策-应用条款