Changing the Bolting Bselector

Hi there

I am looking to change out a load of bolts from flanged connections which have already been placed within design. The Bselector in the flange attribute is unset, I wish to change this to a value to enable a second bolt option to appear. To do this I think I need to generate a report at site level which will allow me to change this attribute. There is several sites with hunderds of pipes where I want to change the bolts out.Can anyone help with a report template that will allow me to output this info and edit to suit before running it back in.

Thanks in advance

Mark

If you need to a report that reports flanges.

Type: FLAN
With: PURP OF SITE EQ 'PIP' (There will be some purpose set for Piping Sites or it could be 'DESC')
Columns:FLAN BSEL PIP ZONE SITE

Leave Hierarchy blank and then run the report!

thanks for the quick response at first glance that seems to have worked, can i edit the report changing the BSEL and running the report in as a macro?

I wish if it was so easy. But then you can't run it in by simple edit. You'll need PML for this.

No, no PML required!

The report file MUST have the extension .txt, if not rename the file

Start Excel and load the file as .txt file, space separated, check the option to treat consecutive spaces as one delimiter.

You should get one column for each column of the original report.

Add between column A and B a column and fill all lines with BSEL

Now in column C add or type the required value for BSEL

Delete the other columns and the header line

Save file as .txt SPACE SEPARATED best with a different name

The file should contain:

=123456/76543 BSEL ABCD

i.e. refno BSEL bsel_value

Run the file in via command line with $m/filename.txt

Note that you also need to set the BSEL to the same value for the neighbouring part of the joint otherwise no bolts will be determined for this joint.

And your (Bolt-) SPEC has to provide lines with the selector set with the BSEL value applied.

It is recommended first to study this for one PIPE before the large file is loaded.  :thinking2:

Good success!

Yes this can be done too.
And also the if you know how to play around using lists then
1. Select flanges using the criterion given above.
2. In the command line type ALP LOG /C:\runfile.txt
3. then in the list box command line type in q ref bsel. Run it
4. ALP LOG END in the main command line
5. Your list with the necessary formatting (as said in the above post by pdmselder)
is ready
6. Replace the BSEL using PFE32 or Excel

and then simply run it in.

Thanks for all the help, I managed a project wide change of BSEL for flanges valves Nozzles etc and gasket option changes after a mornings editing. I am very grateful thankyou

Mark