SiePortal

The integrated platform for your product selection, buying and support workflow - bringing together Industry Mall and Online Support.

Products & Services
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Support Support
{{(apiData.Support | filter:{'rank':1}:true)[0].title}} Support
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
MySiePortal MySiePortal
{{(apiData.MySiePortal | filter:{'rank':1}:true)[0].title}} MySiePortal
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Cart ({{apiData.CartCount}})

Navigation

Write into User Archive from extern external

9/20/2011 5:58 PM	Rate (0)
Deckard78 Posts: 102 Rating: (1)	I should copy, periodically, some records from an externalDB table to one UA#Table of my WinCC Project; how can I copy records from external table to UA#Table? I don't know how to manage the ID column that is created in automatic from UserArchive Editor; this column can not be set NULL and must be unique...
Deckard78 Posts: 102 Rating: (1)
Suggestion To thank Quote Answer

9/21/2011 8:57 AM	Rate (0)
Michel Bronze Member Joined: 9/8/2005 Last visit: 9/11/2024 Posts: 177 Rating: (15)	Hello, if you are working with redunatd servers, it is strongle recommanded to use the described User Archive functions. Otherwise the redundance mechamisen isn't work. Generall yis the better solution to using the C user Archive function. I know it is much more complicate and not so fast, but the best solution. Possible that the WinCC tool "script Connector" is helpful for your task. It allows to using C-Funktions in VBS scripts. http://support.automation.siemens.com/WW/view/de/17544346 Michel

Suggestion To thank Quote Answer

9/21/2011 11:54 AM	Rate (0)
Deckard78 Posts: 102 Rating: (1)	You say that in case I use an external application, for example SQL Server or VB, to write into a User Archive Table of one server, this data will not be automatically synchronized with the redundant partner?
Deckard78 Posts: 102 Rating: (1)
Suggestion To thank Quote Answer

Share this page:

Share this page on...