5/26/2011 12:41 PM | |
Joined: 10/3/2010 Last visit: 9/20/2024 Posts: 1562 Rating: (191) |
InfoBrowser doesn't show what I thoughed it would do, it doesn't show the content of the DB, only a list of the available DB's etc. |
B r g d s , |
|
5/27/2011 2:23 PM | |
Joined: 10/3/2010 Last visit: 9/20/2024 Posts: 1562 Rating: (191) |
I have some DB's containing 1or 2 variables of UDT but most are standard data types. So if you want, I'm always interested to check out your template and see if I can use it somehow. It would be very nice! Thanks in advance. |
B r g d s , |
|
5/27/2011 7:00 PM | |
Posts: 2348 Rating: (264)
|
Ok, don't judge too strict - its internal variant, having drawbacks)) Created Excel 2007 Rus, saved as 2003 - i hope nobody will have problems with that. How to use - open DB, set View to Data View, select all rows, Ctrl+C. Open Xls file, choose D3 cell, Ctrl+V. Now - if datatype is unknown then you'll get #N/A in columns -should set address manually first instance of #N/A (or fix file and send back to me)))). This version doesn't care too much about word boundries, so if there be 3 BOOLs and 1 INT address of INT would be 0.3 - but it would be highlighted red. Also you should check last address in Xls and DB - if they match - everything OK (they don't if you use 1 BYTE + 1 WORD and that won't be highlighted). Main reason i decided not making word--boundary--counting version: I always use "empty" space produced by word boundary rule; filling it with "Reserved" variables. In this case if you need to add variable - you just rename reserved and that's it. On the other hand if you add variable by filling "empty" space, S7-Manager supposes you have changed the structure of DB and insists on re-downloading to PLC. PS. You're welcome with corrections and suggestions :^) AttachmentDB_aвdresses_template.zip (1590 Downloads) |
5/30/2011 10:28 AM | |
Joined: 10/3/2010 Last visit: 9/20/2024 Posts: 1562 Rating: (191) |
On some DB's it stops for example on STRING [14] but I know this template has its limitation Works nice as long data types are in the lookup list. Thanks FYI: I experimented also with Windows Generic / Text Only-printer and some adjusting some settings, works pretty good and no complex data type issues there. View a DB in Data View & choose Print, choose Generic / Text Only printer (can be installed by default on Windows see attached screenshot) and you have to play around with some properties. I have quite good results on A3 paper size, other settings could cause some field using the word-wrap. When finished, click OK and enter a filename, for example DB1234.prn This file can be imported into Excel (might need some adjustments depending on your needs) |
Last edited by: SteBo at: 5/30/2011 10:54 AMLast edited by: SteBo at: 5/30/2011 10:41 AMB r g d s , |
|
5/30/2011 6:02 PM | |
Posts: 2348 Rating: (264)
|
Well, i don't use STRINGs, so missed that:^) Nevertheless i fixed this and added monitoring of word-boundaries in case 1 BYTE + 1 WORD. Also checked another Complex types - as you copy from Data View ARRAYs, UDTs and STRUCTs are splitted into elementary types, so no problems from now on (at least i think so) PS. The thing i like on this template (excluding it's just mine) is simplicity - one copy/paste to get result AttachmentDB_addresses_template_v2.zip (1467 Downloads) |
This contribution was helpful to2 thankful Users |
4/24/2016 12:37 PM | |
Joined: 5/4/2012 Last visit: 6/18/2024 Posts: 11 Rating: (1) |
I have tried this way, but i wonder about how to insert the comment to datablock? "motor1 : bool := FALSE : comment;" => compile error "motor1 : bool := FALSE ;" => compile ok, without comment any solution please! |
This contribution was helpful to1 thankful Users |
4/25/2016 11:15 AM | |
Joined: 3/24/2009 Last visit: 7/9/2024 Posts: 535 Rating: (112) |
Dear Andrzej, add your comments to the declarion-part of the block:
Best regards, |
This contribution was helpful to1 thankful Users |
3/1/2017 10:15 AM | |
Posts: 1 Rating: (0) |
Thanks Aret! Works just perfectly. Saves me a lot of time! Regards, Hans |