Dear all This is the 1st time I contact you I'ma big fan of this group years ago I always read and read It is a very useful group indeed Now I need a help I want to a do a tool that adjust blocks in the CSD viewer in IACC ,we did a similar tool for infusion that take a loop as sample get x,y postion of each block then apply the same x,y for same blocks of the same type in all other similar loops the result for example 99 loops follow in shape and blocks arrangement 1 loop We did so in ifusion using the data stored in tables in the SQL server Now we want to do the same in IACC where all data is stored in encrypted inside the IACC itself Your email about how to dump the blocks data (parameters and values) from IACC direct using script is very useful ,now I'm asking if there is script similar to this one to dump the blocks names and their relative x,y positions in the loop editor Thank you Ramy hamdy -----Original Message----- From: foxboro-bounce@xxxxxxxxxxxxx [mailto:foxboro-bounce@xxxxxxxxxxxxx] On Behalf Of William C Ricker Sent: Saturday, July 02, 2011 11:18 PM To: foxboro@xxxxxxxxxxxxx Subject: Re: [foxboro] Fwd: IACC Database in excel format I have a little script ... This produces 2 files for each CP. {LTRBUG}.txt is direct from the ICCAPI, and {LTRBUG}.src is a 4 column file. Col 1 Compound name Col 2 Block name Col 3 Parameter Col 4 Value The source file imports quite nicely to a spreadsheet. I normally put this into a directory called '/opt/customer/cio'. The files are dropped into the same directory the script runs from. If you use it on windows, and you use the ".sh" extension, you can run it directly by a double-click in the explorer. On the windows box, it must run on the AW which hosts the CPs you want to document. Line 7 refers to '/etc/nt_cplns'. On a Windows box, this file lists the CPs hosted by the AW it's running on. On a Solaris box, this should be file '/etc/cplns'. Regards, William C Ricker FeedForward, Inc. - getsrc.sh ---------------------------------------------------------------------------- -------- #! /bin/sh exec >$0.log 2>&1 if [ ! "$1" ] ; then LIST=`cat /etc/nt_cplns` else LIST="$*" fi od=`pwd` for CP in $LIST ; do cd /opt/fox/ciocfg/api iccdrvr.tsk <<.end >$od/$CP.txt OPEN $CP all $0 GET *:* ALL CLOSE EXIT .end awk ' BEGIN { blk="" ; cmp = "" } $1=="NAME" { cln=index($3,":") if (cln==0) { cmp = $3 ; blk = cmp } else { cmp=substr($3,1,cln-1) ; blk=substr($3,cln+1) } next } $1=="END" { next } { printf "%-12.12s %-12.12s %-6.6s %s\n",cmp,blk,$1,substr($0,12) } ' $od/$CP.txt >$od/$CP.src set -x cd $od done ---------------------------------------------------------------------------- -------- -----Original Message----- From: foxboro-bounce@xxxxxxxxxxxxx [mailto:foxboro-bounce@xxxxxxxxxxxxx] On Behalf Of manan raval Sent: Saturday, July 02, 2011 2:33 AM To: foxboro Subject: [foxboro] Fwd: IACC Database in excel format Hello Freelist, Is there any way, that we can fetch all configured blocks parameters in EXCEL or any other tabular formate? Regards, M B Raval _______________________________________________________________________ This mailing list is neither sponsored nor endorsed by Invensys Process Systems (formerly The Foxboro Company). Use the info you obtain here at your own risks. Read http://www.thecassandraproject.org/disclaimer.html foxboro mailing list: //www.freelists.org/list/foxboro to subscribe: mailto:foxboro-request@xxxxxxxxxxxxx?subject=join to unsubscribe: mailto:foxboro-request@xxxxxxxxxxxxx?subject=leave *** Confidentiality Notice: This e-mail, including any associated or attached files, is intended solely for the individual or entity to which it is addressed. This e-mail is confidential and may well also be legally privileged. If you have received it in error, you are on notice of its status. Please notify the sender immediately by reply e-mail and then delete this message from your system. Please do not copy it or use it for any purposes, or disclose its contents to any other person. This email comes from a division of the Invensys Group, owned by Invensys plc, which is a company registered in England and Wales with its registered office at 3rd Floor, 40 Grosvenor Place, London, SW1X 7AW (Registered number 166023). For a list of European legal entities within the Invensys Group, please go to http://www.invensys.com/en/legal/default.aspx. You may contact Invensys plc on +44 (0)20 3155 1200 or e-mail reception@xxxxxxxxxxxxx This e-mail and any attachments thereto may be subject to the terms of any agreements between Invensys (and/or its subsidiaries and affiliates) and the recipient (and/or its subsidiaries and affiliates). _______________________________________________________________________ This mailing list is neither sponsored nor endorsed by Invensys Process Systems (formerly The Foxboro Company). Use the info you obtain here at your own risks. Read http://www.thecassandraproject.org/disclaimer.html foxboro mailing list: //www.freelists.org/list/foxboro to subscribe: mailto:foxboro-request@xxxxxxxxxxxxx?subject=join to unsubscribe: mailto:foxboro-request@xxxxxxxxxxxxx?subject=leave