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

wincc 6.0 - how to read compressed database?

9/7/2009 8:36 AM	Rate (0)
sdfrew Posts: 4 Rating: (0)	Hi, I have a wincc 6.0 project which store several process values in .mdf database. I retrieved those data and exported to excel using connectivity pack. What I have now is thousands of rows of hex data(http://obrazki.elektroda.net/53_1252047895.png). Somewhere among, obviously, have to be values of those data, but where? If anybody could give me a hint how can I figure it out I would be more than grateful. szymon
sdfrew Posts: 4 Rating: (0)
Suggestion To thank Quote Answer

9/7/2009 9:32 AM	Rate (0)
uel123 Gold Member Joined: 1/29/2006 Last visit: 8/16/2025 Posts: 451 Rating: (65)	Hey, sdfrew! Tell us more about your project....... - is this for process value archive data or for alarm archive data? - Syntax of your SQL statement in query? If you follow example in Manual for connectivity pack, there should be no problems.... Retrieved data is quite OK, in my experience.... Any how, tell us more. have fun! uel123

Suggestion To thank Quote Answer

9/7/2009 2:38 PM	Rate (0)
sdfrew Posts: 4 Rating: (0)	Hi, First of all, many thanks for your interest :) My project is for process value archive data. To retrieve data I used Data Transformation Service (expample from connectivity pack manual). Firstly data went to TXT file, than to anexcel worksheet. My SQL query was as simplest as possible: "select * from TagCompressed". http://obrazki.elektroda.net/53_1252047895.png Link above is PrintScreen from excel after importing from TXT file. Values I want toobtain are different electric measurements. I have checked tons of siemens doc's without finding meaning of what I have... Waiting for any advice... szymon
sdfrew Posts: 4 Rating: (0)
Suggestion To thank Quote Answer

9/7/2009 6:39 PM	Rate (0)
uel123 Gold Member Joined: 1/29/2006 Last visit: 8/16/2025 Posts: 451 Rating: (65)	sdfrew ....I used Data Transformation Service (expample from connectivity pack manual).... .....was as simplest as possible: "select * from TagCompressed". Hey, sdfrew! I must say, that I did not find expression "Data Transformation Service" in connectivity pack manual. Any how: inthis manual, SQLquery with Command text "select" is allways mentioned in queries for Alarm archives or for Ua archives; for queries in process value archives,command text seems allways to be TAG:R, (and so on, see chptr. 8.5.3 of Manual....). According to my experince, thiscommand text(TAG:R,....) works OK. Have fun! uel123

Suggestion To thank Quote Answer

9/7/2009 9:47 PM	Rate (0)
sdfrew Posts: 4 Rating: (0)	Hi, This method is described in chapter 6.4.7 "Configuring Access With DTS". You are probably right about SQL query, because it's also written there :) I thought that there's no difference what kind of query I would choose. I'll check it tomorrow and I hope you are right. Many thanks, szymon
sdfrew Posts: 4 Rating: (0)
Suggestion To thank Quote Answer

9/10/2009 11:19 AM	Rate (0)
sdfrew Posts: 4 Rating: (0)	Hallo, Hopefully you were right about my query. Changing to "Tag:R, ... "worked perfect. Thank you! szymon
sdfrew Posts: 4 Rating: (0)
Suggestion To thank Quote Answer

9/10/2009 2:24 PM	Rate (0)
uel123 Gold Member Joined: 1/29/2006 Last visit: 8/16/2025 Posts: 451 Rating: (65)	..... glad to be of any help..... have fun! uel123

Suggestion To thank Quote Answer

Share this page:

Share this page on...