3/4/2007 6:09 PM | |
Joined: 1/7/2006 Last visit: 11/17/2023 Posts: 2705 Rating: (318)
|
Hi, I have looked on the page but there is only information about the functions, not about the programming. Are there possibilitys to work with the engineering packages, or is it like S7 Lite, only to use for small PLCs and without any networking, drives and all special cards. If it is only for the DBs then I could earn easally the money by doing it with the tool that Siemens have by there own. How do you import an Excel list with STEP 7 variables into a data block? |
I hope that the answer will help, if you have still questions, don't hesitate to ask me. |
|
4/28/2007 3:30 PM | |
Joined: 1/7/2006 Last visit: 11/17/2023 Posts: 2705 Rating: (318)
|
Please look for the next link: STEP 7 InfoBrowser V1.0 - Exporting STEP 7 project data to MS-Excel and accessing information in Online Support This will help you to the right way I think. |
I hope that the answer will help, if you have still questions, don't hesitate to ask me. |
|
This contribution was helpful to1 thankful Users |
2/20/2008 10:57 AM | |
Posts: 2 Rating: (0) |
Oh ! thanks. |
5/2/2011 1:02 PM | |
Posts: 30 Rating: (0) |
-------------------------------------------------------------------- Hi the page www.s7xp.com not found. Please give me the right address |
Last edited by: eemi at: 5/2/2011 1:03 PM |
|
5/26/2011 9:31 AM | |
Joined: 10/3/2010 Last visit: 9/20/2024 Posts: 1562 Rating: (191) |
I'm interested too, I tried the STEP 7 InfoBrowser tool but it fails to load the full project, displaying an error, see attached screenshot. Copy/paste is also not good cause it doesn't include the address column Opened an older project with STEP 7 InfoBrowser and it works, so probably the newer project uses resources that STEP 7 InfoBrowser doesn't know. |
Last edited by: SteBo at: 5/26/2011 9:39 AMB r g d s , |
|
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 (1595 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 (1471 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 |
2/23/2018 2:14 PM | |
Joined: 6/19/2017 Last visit: 9/6/2024 Posts: 8175 Rating: (172) |
New question published by rramosg is split to a separate thread with the subject Export DB to Excel continuously so the data automatically updates with the same frequency as it does in the DB. . Best regards |
Follow us on