SP3D Custom Command (Test Request)

[tim]

Attachment is my custom command for conventional search/report/attribute management with Excel.

Extract and copy SP3DOBJSearch.ocx to local HDD, then register by regsvr32.

Run custom command "SP3DOBJSearch.Search_Object" with active view.
Tested with 2009.1, 2011SP1 and 2011R1 both MSSQL and Oracle.(Sorry, older version is not supported.:cool:)

How to use will be followed.

2013.05.08 Updated
Ver. 0.6.46

For SP3D/SM3D Ver. 2009.1 Link (http://bit.ly/18sI5Gu)
For SP3D/SM3D Ver. 2011SP1 Link (http://bit.ly/18sI5pN)
For SP3D/SM3D Ver. 2011R1 HF10 or later Link (http://bit.ly/ZOobCB)

Sample SQL Files (http://db.tt/IwANLhg)

Newly Added(from Ver 0.3.01)
2010.12.21 updated (Access 2003 format)
UserShapeDef.mdb (http://db.tt/EQvAMFP)

SP3DIsoLink/SP3DDWGLink (no change)
Link (http://db.tt/LVtbLX4)

Link to SQL search library
Link (http://dl.dropbox.com/u/268816/SP3DObjectSearch_SQL.xml)

Link to SQL attribute library
Link (http://dl.dropboxusercontent.com/u/268816/SP3DObjectSearch_AttributeSQL.xml)
------------------------------------------------------------------------------------
For SP3D Ver. 2009.SP1 (Version 0.6.28 no more update this version)
Link (http://dl.dropbox.com/u/268816/SP3DOBJSearch0628%282009%29.zip)

[AlessandroButteri]

Thank you, i will try it....

[tim]

Basic how to use of search function is;
1)Select class name in the combobox and click Search button. All class object will be listed in the grid view.
2)Click item in the grid view will change select set of SP3D.
3) Double click item in the grid view will fit graphic view to the item.
4)Right click item in the grid view will open property(run as high priority command and closing property form returns to the grid view).

Option
a)Input part of item tag in the textbox next to the Search button results in conditinal search of Name.
b)Check "Search by attribute value" and select interface/attribute and set value results in conditional search by any one property.
c)Click right half of status bar will switch search condition from/to whole plant / current workspace.
d)If you want to search different type of object not listed in basic combobox, switch from basic to detail. Then input part of class name in the text box next to filter button. Then click filter. You can find any target class in the combobox.
e) Or switch to "From BO Tree" tab and select class from Tree view.

[tim]

Ver 0.02 is released.
Several bug fix and improvement.

Now you can customize basic class selection combo box.
Select a target class by switching "detail" then right-click detail option label and execute "Add to basic" menu.
Or switch to "From BO Tree" tab and select BO class from tree and right-click class name then execute "Add to basic" menu.

To reset customized class information, right-click basic option label and execute "Initialize Basic Class".
Default basic class is Equipment, Pipe Line, Pipe Run, Instrument and Speciality.

[tim]

How to use No.2: Excel List export and customize index.

After searching, the search result can be exported as Excel list. (Excel 2003 or higher is required.)

Simply click "Export" button. New Excel work book with SP3D **** List sheet will be created.(**** is class name)
By default, A column(hidden column) is oid which is unique key in the database. This column is very important to create report/ import attribute etc.
B column is item name.
From C column, only index of basic attributes of its class will be added. If you click "Export" button with "Add common att" option off, index will not be added.
Index consists from 3 rows. 1st row is interface name, 2nd row is attribute name and 3rd row is user attribute name.
These information also required for following step(create report/ import attribute etc.)
You can customize index by select interface in the combo box and click "Add IF" button or select attribute in the combo box and "Add Att" button.
You can delete index columns which is not required for reporting purpose.

Meaning of color of index rows is.
Pink:read only attribute.
Green: Code list type attribute
Light green: Other type of attribute.

For attribute column with code list type. Input validation is automatically set.

[tim]

How to use No.3: Advanced Index definition using relation analyzer

Most of case, reporting direct attribute is not enough. You may need more attributes of relational object.
For example, piping component has relation to catalog object, feature, parent pipe run etc.
Such relation can be analyzed with my tool.
Simply select any cell in the Excel list exported by my tool then click "Get" button or copy and paste oid to text box.
All relation will become available in the first combo box.
Select any relation which you need attribute. Then select interface and click "Add IF" button or select attribute and click "Add Att" button.

Attribute index will be added to Excel sheet with relation information as note in the 1st row.

Now you are ready to go to Export/Import step.

[tim]

Ver 003 is posted.
Several bug fix and improvements.

Press Ins key in the search result grid will add object to workspace.
Press Del key in the search result grid will delete object.

etc.

[Loban]

Hi, Tim!!Very useful custom command!!Great work!!
Can I export to excel only selected in the search result grid objects?
Can I import information about isometric drawings property
ThankYou

[tim]

Loban, thanks for your feedback.

New version 0.04 posted.

For selected export, simply Ctrl+C on the grid and paste it to blank Excel sheet.
To import isometric drawing property, additional DLL(DWGCustom.dll) is required. copy to same location and register it with regsvr32.
isometric drawing property is not direct property of isometric sheet.
Use "Analyze Relation" and add property from there.(See attached picture)

[tim]

New version 0.04 posted.

<New feature>
Main form is now height-resizable.(Double click Search tab will restore original height)
Excel link function is improved.(right-click on Excel sheet will open property. Double-click will cut link. Main form will be hidden while Excel link established.)
Menu register function.(Right-click Search tab and execute add to menu.) The custom command will be called from Edit-Find menu or simply Ctrl+F short cut key.
Right-click grid will open drawing / report when object type is drawing/report(Iso, Ortho etc.)
Double-click grid will fit corresponding piping object when object is Iso.
Ctrl+A on the grid will switch to Analyze Relation and run.

[Loban]

[QUOTE=tim;18216]Loban, thanks for your feedback.

New version 0.04 posted.

To import isometric drawing property, additional DLL(DWGCustom.dll) is required. copy to same location and register it with regsvr32.

Hi, Tim! It's all ok, but there are no DWGCustom.dll in attaching archive. Upload this file please.

[tim]

Separate file (DWGCustom.zip) available in my original post.

[Loban]

Thanks, have found

[tim]

See

http://www.davetyner.com/forum/showthread.php?7582-Supplemental-application-%28ExcelMoniker-synchronize%29

For the purpose of Moniker export button.

[tim]

New version 0.05 posted.

<New Feature>
Isometric drawing-3D model synchronize function.
1)Place SP3DIsolink.dll in the same location as SP3DOBJSearch.ocx.(No register required.)
2)Display Iso on the grid.
3)Open Iso by right click on the grid.(If drawing file does not exists, nothing will happen.)
4)Click SmartSketch button on left bottom of the form.(sync start)
Left-click any piping component on th Iso, corresponding object will be fit in the SP3D active view.
Right-click will open property.
5)Double click on the Iso sheet will quit sync.

[tim]

New version 0.06 posted.

<New feature>
Drawing & Report Search tab added.
Iso sync was changed.
Simply click will select object only.
Shift+Crick will fit object.

And several minor bug fix as always.

[chintan]

hi i m also using this utility nice work

thaks for this

[sam.n.v.]

Hi Tim. It's very useful utility! Great work! Don't stop!!!

[Loban]

Thanks Tim, very useful command, I tested each version, everything works without problems! Maybe in the future will be possible to implement import / export properties only selected objects in the workspace? but it is just a wish ... thank you!

[tim]

Ver 0.07

<New Feature>
Search within SelectSet option.
Show/Hide by Ctrl+S/Ctrl+H on the grid.

Thanks for feedback Loban.

[tim]

Ver 0.08

<New Feature>
Category combo box added to filter interface.
Workspace last update time displayed in Status bar.(Click to update WS)
Object type icon added at top left of search result grid.

[Loban]

B)
No comment:)

[samv74]

Dear Tim,
Thanks for sharing this utility search/report/attribute management with Excel.

I have getting following error message at status bar "Error starting the commandSearch_Object: Could not load file or assembly 'file://D:\SP3D\UTILS\SP3DOBJSEARCH.OCX.DLL' or one of its dependencies. The system cannot find the file specified.

1. I have registered the ocx file with regsvr32.
2. add custom command.
D:\sp3d\utils\SP3DOBJSearch.ocx,SP3DOBJSearch.Sear ch_Object
Command name : Search_Object

If you can please tell me why i am getting this error. I will try to test and use this custom command.
SP3D 2009

Thanks & Best Regards,
Sam

[chintan]

Try with

Command name: SP3DOBJSearch.Search_Object

[samv74]

Not working similar error but now "Error starting the commandSP3DOBJSearch.Search_Object: Could not load file............."
I wonder why its saying file file://D:\SP3D\UTILS\SP3DOBJSEARCH.OCX.DLL

[tim]

In case of VB6 custom command, you don't have to specify file path.

Set simply "SP3DOBJSearch.Search_Object" instead of "D:\sp3d\utils\SP3DOBJSearch.ocx,SP3DOBJSearch.Sear ch_Object".

[samv74]

Thanks Tim,
Its working now....
I will use it and come back if any queries.

[chintan]

instead of this (D:\sp3d\utils\SP3DOBJSearch.ocx,SP3DOBJSearch.Sea r ch_Object)

type ( SP3DOBJSearch.Search_Object )

[tim]

Ver 0.09 posted.

Relation analyzer logic changed. Speed improved. (fast enough not to display complete message.)

Drawing Object list display option added. When you check this option and open drawing with right click. objects list in the drawing will be displayed.
Single click will select in 3D. Double click to fit in 3D. Single right click will highlight in 2D. Shift+right^click will fit in 2D.

SP3DDwgLink.dll added. New SmartSketch macro, which can run from Drawing Object list. Click object in the 2D drawing will select corresponding object in the list and 3D.Shift+click will fit 3D.

Fit button added in relation analyzer.

Add "Isogen Error" export button. This button is valid for Isometric sheet Excel list only.

Sevaral bug fix as always.

[tim]

Because of security reason, I had to delete demonstration video from YouTube.
Instead of that user manual pdf was added on the original post.
If something is wrong with my English, please point me out.

[00Frotto]

Nice work Tim!
Its a mighty and very helpfully tool!
Thanks a lot!

[tim]

Ver 0.10 Uploaded

See original post.

<New Feature>
Option "Ignore capital/small letter to compare" added.
"oid from Name" function added.
Select blank column(ex. insert new "A" column) and click "Report oid" button will find and report corresponding oid from Item Name.
Change name column if necessary. Default is "B" column.
This function is useful to import/compare Excel data created by other tools. (TEKLA,SPPID etc.)
As far as Item Tag (e.g. Item name) is unique, system can find corresponding object's oid in SP3D database.
Save file with HL button added.
This button is valid for drawing/report list only.
Select non-blank one column(ex. Name B-column) and click this button will save corresponding drawing/report under folder of Excel report sheet and add hypelink.
So you have to save Excel list before click this button.

<Other change>
Special export/import was moved to dedicated tab.

<Bug fix>
Export/Import/Compare dos not work if inrterface name not start with "IJ***".
Special import (Set Path, Set NR) does not reflect "Single Commit" option.

[Khairin]

Hello tim,

Thanks for sharing! It is very interesting.

Thanks so much..;)

[tim]

0.11 Posted

<New Function>
Add "Number of sheet" button for Isome Drawing sheet list. (As konan13's request )

<Simple how to use>
Generate Iso Excel list from Search tab-D&R Tree Tab.(Select drawing snap-in and drawing status if required. Then click Search. Click Export after search.)
Select blank one column and click "Number of sheet" button in Other Processing tab.

Program will save each Iso sheet in temp folder and count sheet one by one. So this special export takes time (1-2 sec per drawing). You have to be patient if number of Iso is large.

[konan13]

thanks! thanks! thanks!)

[tim]

Sorry for frequent update.

Ver 0.012 posted.

<New Feature>
1)Add "Import/Replace file" button in other Processing tab.
Most of member here may be feeling that auto-drawing generation of SP3D is not good enough and spending much time to modify drawings by editor manually.
Don't you think it's ridiculous to occupy one license while editing drawings in Drawings and Reports task? :mad:
By combining "Save file with HL" and "Import/Replace file", you can edit drawings off-line and write back drawing files to database.

(Note 1) Sometimes drawings are saved as cache in temp\Drawings folder and Replace/Import looks failed.
In such case, delete Drawings folder and open drawing again.
(Note 2)Import/Replace file will not work for reports.

2)Add "Read Only Attribute" option for "Save file"
if you don't want edit drawings, check this option and Run "Save file".

Several bug fix.

[KevinD]

Hi Tim..seems u adding very useful functionalities day-by-day with each new version.. Thanks a lot..

[tim]

Ver 0.1.00 posted

<New Feature>
Note Search
I don't explain. Just try.

Option to get object oids from selectset for Relation Analyzer
Similar to call repository browser.

Option to export multi-relation object value.
Check this option then export will set all relation objects value in one Excel cell with line feed.

[tim]

Ver 0.2.00 Updated

<New Feature>
P&ID Search (available when you retrieve P&ID through SmartPlant Foundation)
Note export function and search speed improvement.
Save check box condition in registry.

And many bug fix for Oracle environment.

[tim]

Ver 0.2.01 Posted

<New Feature>
Export code list value option instead of short string value.

Several bug fix for Oracle environment.

[tim]

Additional instruction is here.

[ammon]

Where to download files (“SP3DOBJSearch.ocx”, “SP3DDwgLink.dll”, “SP3DIsoLink.dll”)?

[tim]

Link in my post #1.

[tim]

Those who succeeded to create integrated environment, go to my SmartPlant Review forum post.

http://www.davetyner.com/forum/showthread.php?7411-vue-file-viewer

[tim]

Document updated.

Separate file prepared for Ver 2009SP1 and 2009.1 because of dll referencing incompatibility.(Main custom command only)

[tim]

Ver 02.02 Update

<New Feature>
Export path has option Full path, Upper parent, Area and Unit
Mouse scroll for main search grid.

[tim]

Ver. 02.03 Update

Add Object Class export Button.
Add Tree Report Button (System, Drawing/Report, WBS, Space option). See attached picture as typical sample.

[songchangyang]

Where to download files ?:):D:D

[3DCAD-IT]

As noted above, the link is in Post #1

[tim]

Ver. 02.04 Update

Search by volume option.
Select pre-defined volume (drawing volume, zone and area) or set X/Y/Z, min/max manually.
Check "in Vol" option.
By dafault, search object which part of range is in volume.
If check "inside", search object which whole range is in volume.
Volume icon will select and fit volume in the active view.

Manual Rev.2 Updated.

[Benny]

The link of download in the post #1 is invalid....

[dave]

Benny, both are working for me. You have to be logged i for the attached one. Were you logged in when you tried?

[Benny]

Thank you Dave. I have logged in.But it still did not work.Could you sent them to me? Thank you!

[tim]

Benny, I don't like to send e-Mail everytime I post latest version.
If your company (or Chinese goverment??) block the link, you shold solve by yourself.

Here is alternative link for main custom command (ver. 2009.1);

http://www.multiupload.com/4V6MNHEXL5

[tim]

Ver 0.300 update;

System search option
Specify area/unit for search.
With this option search takes longer time. Be patient.
Also this option does not work with Oracle environment.
I reported the bug to Intergraph.

prefix/suffix/partial matching option for name search
Click triangle next to search button.

Shape export/import function

Shape placer
Download and watch demonstration video from here (http://db.tt/39YMD9F).

(Note) New Equipment tab will appear only when you call the custom command from equipment task.

Importing general note attribute(IJGeneralNote) will create new note if note does not exist.

Bug fix for work share environment.

[Benny]

Tim, Thank you for uploading this Command here. And I would like to share some SmartPlant ToolTips later. But I don't think there is no any relation with Chinese goverment.

[chintan]

Hi tim
This is an excellent tool u added.
I used shap placer ,Its really good and working fine except it is not responding for my Customised Symbole.

IS this shape placer working with new customised shape symbole.

[tim]

Chintan

Shape placer is getting better and better.
User defined shape will be implemented in the next release.
Much more option will be added.

rotation increment for continuous placement
Other reference point
Location orientation option
Rotation orientation option

[tim]

Ver 0.301 update;

Enhancement of shape placer.

Place "UserShapeDef.mdb" to the same location where SP3DOBJSearch.ocx exists.
Add information of user-defined shape in the file if required. (Maxmum number of dimensional parameter is 5)
if somebody requests to increase the maxmum number, I'll consider to change the limit.

Other changes are already outlined in my previsou post #58.

New Sceenshot of Shape placer (http://img63.imageshack.us/i/shapeplacernew.jpg/)

[chintan]

i am getting error on clicking Shape Placer

Error Description:
Runtime error'-2147467259(80004005)
Selected collating sequence not supported by the operating system.


having XP SP3,msaccess03

[chintan]

Hi tim
Its working now mdb file u send is in 2000 format i convert this to 2003
now it working fine it showing my customised symbole too.

Good work.
In Access 2003 ::::::Tools->Database Utilities->Convert Database->To Access 2002 - 2003 Format

[tim]

Thanks chintan

mdb file is replaced to 2003 format.
I didn't notice such language-dependency error of access 2000 format.

[tim]

Ver 0.3.02 Update

Nozzle Export/Import function.
New small command save script (see next post)

Set NR can set User Defined.
Importing IJNamedItem/Name will set naming rule to user defined.
Fit will be applied to all views.

Other minor improvement and bug fix.

[tim]

How to use the new command (Save script)

Execute command SP3DOBJSearch.RegistFileMenu once.
Switch task.
New menu Save script will be added in file menu with short cut key Ctrl+Shift+S.
Run this command.

Run SP3DOBJSearch.RegistFileMenu again will delete the menu item.

This command will save XXX.vbs file with current session file name.(You have to save session before run this command)
Generated .vbs file will set site information and open session file. Just double click it.
So you don't have to switch site before opening session file any more!!.

here is a .vbs code generated by the command for your reference.



Option Explicit

Dim objWshShell
Dim REG_SP3DSITE,strKey1,strKey2,strKey3
Dim strVal1,strVal2,strVal3

Set objWshShell = WScript.CreateObject("WScript.Shell")

REG_SP3DSITE = _
"HKEY_CURRENT_USER\Software\Intergraph\Applications \Environments\CommonApp\ProjectDB\"
strKey1="PhysicalName"
strKey2="Schema"
strKey3="SiteDatabaseProviderType"

strVal1="SERVER=ZZZZ;DATABASE=XXXX_SDB"
strVal2="SERVER=ZZZZ;DATABASE=XXXX_SDB_SCHEMA"
strVal3="ORACLE"

objWshShell.RegWrite REG_SP3DSITE & strKey1,strVal1,"REG_SZ"
objWshShell.RegWrite REG_SP3DSITE & strKey2,strVal2,"REG_SZ"
objWshShell.RegWrite REG_SP3DSITE & strKey3,strVal3,"REG_SZ"

objWshShell.run "YYYY.ses"

[KevinD]

thanks for this productive function Tim..

[samv74]

Dear Tim,

where is link for downloading Ver 0.300 update.

Thanks
Sam

[tim]

Ver 0.400

New command SPR Tag View Sync.
Command name:SP3DOBJSearch.View_SPR_Tag
Run command and select mdb file of SmartPlant Review with tag data (One time for each plant)
Select tag id in combobox or manually input id.
SP3D's active view will be syncronized with selected tag's view.
If you want display snap shot picture, create .mdbsnp file by SPR Tag Snap available in SmartPlant Review forum.

Bug report/feed back is welcome.

Demonstration video is here (http://db.tt/eEBmTjk)

Other improvement
Save script will run save as if session file is not saved.
Excel list one time jump.
Export Object Class will report subclass name(ex. Horizontal Centrifugal Pump etc.) instead of root class name(ex. Equipment).
Relation analyzer displays root class and sub class name.
Several bug fix.

[tim]

Ver 0.401

"Search by System" can set any system folder from system hierarchy tree now.(Finally I found out how to display system hierarchy using ocx component)

"Export immediately" option for "Add IF", "Add Att" button which will start export data after adding attribute index.

Permission check
After search, click Shift+A on search result grid.Cell color will be set based on your access right.
Meaning of cell color is;
Dark yellow:Read only by permission setting
Magenta:Read only because of approval status
White:Full Access
Gray:Other status
Same color will be set for excel name column when you generate Excel list from search result.
Also,"Iimport" will be skipped if you don't have update right for target object and set pink color to the Excel row.

Relation Analyzer can set attribute index beyond one relation.
After select relation in the combo box, click "Path" button. information will be shifted to destination object(s) and you can follow relation chain by any steps.
For example, you can additionally export pipeline name to Instrument Excel list by following two relation chain as below.
Instrument----------------->Pipe Run--------------------->Pipe Line
(Run to Part) --------------> (System Hierarchy)

Every form will appear with fade-in effect.

[Loban]

Hi Tim.I try to search all supports using BO Tree.I see this error - Cannot execute statement:SET NOCOUNT ON

[tim]

Loban

I can repeat the error. This error never happens with Oracle environment but MSSQL happens.

There must be inconsistency between schema definition and actual view in the model database. Corresponding view defined in the schema does not exist in the model.
I'll investigate to avoid this kind of error.

[tim]

Ver 0.402

Error fixed when BO node contains non-exist view.(Thanks for bug report Loban!)
Add tree export button for SmartPlant Review Explorer2.
Add button to start SmartPlant Review Tag Viewer.
(See "Other processing" tab)

[tim]

User manual rev.3 updated.

[Loban]

Thanks Tim! Everything works fine!

[tim]

Data exchange figure between SP3D and SPR.
Clicking application name will jump to the related thread.

[KevinD]

Thanks Tim for all your utilities..

[tim]

Ver. 0.403 update

Bug fix for export tree function.(Thanks for testing hikam)
Display drawing status icon (considering performance, this function is optional. Shift+ Click Search button. Simply clicking search does not display icon and response is much faster.)
Ctrl+Search will search within workspace.
Change mouse cursor to sand clock while searching.

[sconvens]

Tim, SP3DOBJSearch.ocx has made my day...correction my year. Thanks
again Tim, awesome utility. Makes delivering Sp3D projects a whole lot
easier. Give this man a medal !!!!!!!!!!!!!!!!!!!!! Steven
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> > Ing. Steven Convens
> > Senior PDMS/ SMARTPLANT/ PDS Application Specialist& Coordinator
>
> > Belgian Mobile: ++32 477/31.35.09
> > Belgian Fax: ++32 3/610.95.81
> > Skype: sconvens
>
> > eMail: sconvens@hotmail.com
> > Homepage: http://sconvens.tripod.com
>
> > Netmeeting Videoconferencing: ils.advalvas.be
>
> > Office Address: Hoeve van Gemp 5 - 2430 Laakdal(Belgium)
> > US Conferencing Call: ++1(712) 432-4018 Passcode: 889345#
>
> > We either find a way or we make one - Hannibal
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=-=-=-=-=-=-=

[tim]

Ver 0.500 update

Interference entity viewer.(I decided to add this function because built-in interference list function is simply f**k.):mad:
Advantage to interference list.
Search by condition. (class of Part A/B, aspect,status, name, within specified volume)
Easy operation.
Click to select. Shift+click to fit to view. Select row will select entity, Part A/B. Shift+ select row will fit Part A/B.
Excel report function(future function.Not implemented yet.)
Right-click menu to delete entity, change status, add/edit note.

Run main search command and click interference icon to display new form.

[hikam]

wow, great.. we just sent request to INGR regarding this interference list.. and you already did something.
i"ll try it next week.. can not d/l from office -.-;

[hikam]

Tim,
Thanks for this tools.

btw, is there any change to select structure item?
and is there any possibility to add the note or change the status of selected items in one click?

ups.. i'm sorry too many ask.. ^^;

again, thanks alot for these usefull tools

[tim]

hikam

New feature request is always welcomed.
You can add your favorite class to combo box in the main search form. Class combo box in the interference entity viewer is synchronized with main form's one.
You can add member part prismatic class . Read sec 3.1 of user manual.

Multiple selection to applying change status, add note is possible. I'll implement in the next release with Excel report function.
However because of limitation of MSFlexgrid, only continuous rows can be selected.

[tim]

Ver 0.501 update

Interference entity viewer Excel list export function.
(Exported Excel list is compatible with main search export format.You can edit status,note and write back to database using import function.)
Change state, edit note can be applied to multi-rows as hikam requests.
Grid component of entity viewer is replaced to MSHFlexGrid because MSFlexgrid has limitation of total cell number.
Seems much faster.(With my environment, 10 seconds to display 50000 rows)
Add sort for entity search result grid. Click fixed row.
Add last update date in the grid.

[hikam]

Tim,

this is great.. as i expected.
thank you so much.

[hikam]

Tim,

any possibility to show the path in the IFC list, at least when we export to excel file?

i've tried to combine your "Interference Entity Viewer" with "Object Search -> Other Processing -> Special Export -> Path" and return no data.

Is it because the interference itself doesn't have that kind of path in database?

consider this as "a question" not "a request" :)

[tim]

hikam

You are correct. Interference entity itself does not belong to any system parent.
However we can export path for partA/B object.
You need to change oid column in Import/Export/Relation tab from default value, 1 to 6 (partA) or 11(partB ).
These oid column is hidden but available in the exported Excel.

SPR interference checker will work even if you add new columns in any place as far as each column exists and index is not modified.

[hikam]

great.. thanks Tim, it works well

[Loban]

Hi Tim, i have some problems with new function
when I push a button interference entity viewer a see error like this Run-time error'383' 'Text' property is read-only.((

[tim]

What a terrible day today.
Two same bug report (error 383) from different user and different application.

I checked the code and possibility of the bug seems from codelist of IFC status short code is different from default value.

Could you check view CL_InterferenceRequiredAction in the report database and ShortStringValue "Edit" exists or not.
My app try to set Edit as default search condition and if it does not exists in the codelist it may cause error 383.

[tim]

Ver 0.502 Update

Add permission group search option for IFC viewer
Add Plant/Workspace search scope for IFC viewer
Apply Red/Blue/Yellow hiliter same as Intergraph's Graphic Clash Reports for Smart3D for grid operation of IFC viewer.

Bug fix which Loban reported.

All grid component is now MSHFlexGrid. (No limitation of total cell number.)

[hikam]

Tim, thanks a lot for updating the tools.

in v0.51, when nothing is selected, the list shows all the interferences. unfortunately i can not do this again on v0.52. ("Invalid use of Null")
is there any other way to show all interferences?

other additional functions are helpfull, thank you.

[tim]

The logic to check if PartA/B is in workspace has bug. I'll fix and post fixed version soon.

Some interference entity does not have relation to PartA or PartB.(oid is null)
Do you have any idea what is the cause of such a entity??

[tim]

hikam

Bug maybe fixed. Please re-download and try it.
(Same download URL,Same version)

[hikam]

Tim,

i'm sorry, i don't have any idea also.
but, now i can see all interferences again. thanks alot.

[tim]

Ver. 0.503 Update

Export space tree/volume information for SmartPlant Review Explorer2. (Ver. 0.06 or higher)
Apply highliter for object select/fit.

Several bug fix.

[tim]

Ver. 0.504 update

Export WBS tree/WBS item for SmartPlant Review Explorer2.
Bug fix for view sync with SPR tag.(thanks for bug report, hikam)

[tim]

Ver. 0.505 update

Update check function through Internet
Display class information (key-in 'V' on the class combo box)
Display/edit comment for SPR tag
Add download link of SPR Explorer/SPR Tag Snap.
VB compile option changed to make ocx file smaller

several minor bug fix as always.

dave, thanks for setting this thread sticky.

[tim]

Ver. 0.506 update

Select search option volume from space tree instead of combo box.
Add aspect for shape export/import Excel.
New command, capture active view. Simple screen capture.
command progid : SP3DOBJSearch.Capture_View
argument : /S
How to use:
1) Run custom command as above command name and argument.
2) Set capture option then click regist to menu.
3) Switch task to reflect additional command in the menu.(View - Capture Active View / Shift+P )
4) Capture Active View by Shift+P

[tim]

Ver. 0.507 Update

Add "Project" button to other processing tab that will export project name the object is claimed to.
Add "Set WBS" button to other processing tab that will assign (import) WBS item to the object in the Excel list with claiming to parent WBS project.
(WBS data in the Excel can be full path (ex.SP3DTRAIN\As-Built\Mechanical) or single name (ex. Mechanical) as far as WBS Item name is unique.)
Add "Clean WBS Assignment" button with Release claim option to other processing tab.

[tim]

Ver. 0.508 Update

Batch PDF convert function
Search drawings(Iso, Composed or Ortho) on D&R tab then click Acrobat Icon.
Set destination folder and then click start.
If SmartPlant PDF converter is not installed, installer will be launched.

Set Delete Information
All import/export/compare function (including special export/import) will add note to oid cell for deleted record about who/when.

[tim]

Ver. 0.600 Update
Search by user defined SQL file. (a few sample .sql files added. Place these .sql files in the folder where "SP3DOBJSearch.ocx" exists)

Ver. 0.509 Update
Deleted object search & report function (click trash box icon)

[tim]

Ver. 0.602 Update
Option to run Object Search as assistant.
How to use
1.Short Cut Key (Shift+F)
Run Object Search and "Delete from Menu" and "Add to Edit Menu" again.
Two Find will be added in Edit menu.
2. From Tools-Custom Commands
Command Name:SP3DOBJSearch.RunAsAssistant

What is the difference between command and assistant?
Command will be stopped or suspended by another command depending its priority. On the other hand, assistant never stop by another command.
You can continue to display search result while modifying object if it's assistant.
Assistant cannot do commit to database. You can not do import/special import with assistant.(Related buttons become disabled.)

Ver. 0.601 Update
Option to get SQL through Internet (dropbox.com access required)

[hikam]

tim, thanks for this continuous update. just tried until 6.00 and it has more good functions.
great work.
will try next version.

[tim]

I forgot to add one more improvement.

SPR tag viewer will draw line and circle to express tag balloon.

[lincolntian]

Dear Tim

I can't access the custom file download link,Could you pls send them to my email:lincoln.tianshuai@gmail.com

Thank you very much.

[tim]

I have added several SQLs for QC purpose to the common library(XML) which can be accessed through Internet.(New function from Ver. 0.601)
If you can not access "dropbox.com" from your office and you are interested in such SQLs, access following URL at home or somewhere else where dropbox.com is accessible to get SQLs.
http://dl.dropbox.com/u/268816/SP3DObjectSearch_SQL.xml

Following is the latest list.

Disconnected Piping Parts--which may cause Isometric drawing generation error. See recent topic (http://www.davetyner.com/forum/showthread.php?8981-Find-Disconnected-Pipe-Parts-%28Isometric-Troubleshooting%29) in this forum
Pipeline without Run
Pipe Run without Part
PipeRun without Naming Rule
Piping Parts without WBS---for WBS Iso
Eq Foundation without Eq
Equipment without Geometry
Duct Run without Part
Conduit Run without Part
Cable Run without Part
Pipe Nozzle without connection
Insulated Pipe Run with 0 thickness
System without child

For XXX Run without Part, Intergraph already provided function "Select Empty Runs" as a part of SP3D Automation Toolkit.
Any suggestion for additional SQL is always welcomed if it is useful for everyone.

[tim]

Ver 0.603 Update

SmartPlant 3D / Review View synchronize function added to SPR Tag Viewer(See PDF manual for detail)
PDF manual button added (dropbox.com access required)

Several bug fix.

Latest PDF manual (Rev4) is added at top of this thread.

[tim]

Ver. 0.604 Update

Class/Relation combo box width will be adjusted by maximum length
Export option "Export display user name by LDAP query"
This option is valid for "Created by" and "Last Modified by" to convert domain account to display name registered in domain server.
"Check who is on-line" function.
This function will display other SP3D users connected to database and send console message to selected users.
To send/receive console message, Messenger service must be running in both sender and receiver.

Ver. 0.605 Update

Right click menu was added to main search result grid.
Select object action is changed from single click to Shift+Click for better operability.

[tim]

Ver. 0.606/0.607 Update

Search by Part Number added
Search by Commodity Code added
Operation to search result grid(select/fit/delete/add to workspace etc.) can be cancelled on the way.

Key-in first letter to combo box will dynamically change combo item.
Label next to the combo box is option of search type. C:commodity code, P:Part Number. Click to change.

[hikam]

just tried until 0.65 and wow, this tool's growth is very fast and still coming :)
simple, easy to use and really usefull. great job tim.

[hikam]

tim,
is it compatible with 64 bit pc?
i can not export when "workspace" (right bottom selection) is selected. maybe wrong on my pc?

[tim]

hikam

Sorry for late response.
I don't have 64 bit test environment.
But even with 64 bit OS, I think it will work under 32 bit compatibility.

http://msdn.microsoft.com/ja-jp/vbrun/ms788708.aspx

What kind of error did you faced?
It only happens when you try to export with workspace option??
Please inform OS, Excel version.

[tim]

Ver. 0.608 Update

Add function to preview image for part. (In Part tab)
Add button at the bottom to expand objects in select set to search result grids.
(Similar to SelectSet browser which Intergraph provides as part of SP3D Automation toolkit.)
Click to display name. Shift+Click to display name and class name.
View Related Drawings
Right click menu in main search result grid. Which will display drawing list in which a selected object exists.
Double click drawing will open it with 2D editor.

[tim]

Ver. 0.609 Update

Piping (and conduit) component search
This function is inspired by the recent thread (http://www.davetyner.com/forum/showthread.php?9240-Locate-pipe-component-featrue-by-attributes) posted by h3nrik.
(See attached for how to display additional search form.Esc to hide.)
Speed improvement of highlight/fit of multiple objects

[hikam]

tim, very sorry for late reply also.
when select "workspace" for searching, there are data shown on result grid. but when i click export, small window message "No record in the grid" appears.
but, when select "plant" for searching, no problem at all.
OS is XP, excel 2007.

btw, as usual, new version is great.

[tim]

hikam

Thanks for detail error report. It is very primitive bug. I'll fix it in the next version.

[tim]

Ver. 0.610 Update

Batch DWG/DGN conversion. See attached picture.

Several bug fix includes hikam's one at #114.

[tim]

Ver. 0.611 Update

Add zoom scale % combo box.
Add "3D DGN" option for D&R search.
Equipment classification search.(See #113 to display additional search form)

Several bug fix and improvement.

[snd2000]

Tim,

These are great. Everyone, just be aware that if you are looking for truly empty runs, you need to look for runs without features since it is valid situation especially where you change to a reducer to have a run with no parts but if you delete it, reducer will get deleted.

snd2000


I have added several SQLs for QC purpose to the common library(XML) which can be accessed through Internet.(New function from Ver. 0.601)
If you can not access "dropbox.com" from your office and you are interested in such SQLs, access following URL at home or somewhere else where dropbox.com is accessible to get SQLs.
http://dl.dropbox.com/u/268816/SP3DObjectSearch_SQL.xml

Following is the latest list.

Disconnected Piping Parts--which may cause Isometric drawing generation error. See recent topic (http://www.davetyner.com/forum/showthread.php?8981-Find-Disconnected-Pipe-Parts-%28Isometric-Troubleshooting%29) in this forum
Pipeline without Run
Pipe Run without Part
PipeRun without Naming Rule
Piping Parts without WBS---for WBS Iso
Eq Foundation without Eq
Equipment without Geometry
Duct Run without Part
Conduit Run without Part
Cable Run without Part
Pipe Nozzle without connection
Insulated Pipe Run with 0 thickness
System without child

For XXX Run without Part, Intergraph already provided function "Select Empty Runs" as a part of SP3D Automation Toolkit.
Any suggestion for additional SQL is always welcomed if it is useful for everyone.

[tim]

No Feature, No Feature (Sex Pistols)

snd2000, thanks for your suggestion. Common SQL library is replaced to no feature based ones.

[tim]

Recent updates

Ver. 0.6.12
Add "Member" tab for additional class/category search.
Ver. 0.6.13
Add button (in class tab) to register select set object to basic class.(Select any one object which has name property and click the button.)
Ver. 0.6.14
Add right click menu for Iso search result,"Set Isometric Sheet Number for parts". This command will set Iso name to piping parts.
Ver. 0.6.15
Change bottom buttons to toolbar to reduce number of component.
Add option for fit command to apply all graphic views or active view only.(Additional button in tool bar)
Add export SP_ID from oid following relation of SPPID-SP3D correlation. (Shift+Click P&ID button)
Add export oid from SP_ID following relation of SPPID-SP3D correlation. (Ctrl+Click P&ID button)

[tim]

Ver. 0.6.16
Add location search option (Additional combo box appears only when global workshare environment)
Add export location function (Shift+Click Object Class button)

[tim]

Ver. 0.6.17 Update

Function to create SQL filter equivalent to search condition.
Click new button next to name search condition text box then set filter name. SQL filter will be created under My Filter.

[dave]

tim, you're awesome dude! Thanks so much for this great tool!

[tim]

Ver 0.6.18 Update

Function to search duplicated name within a selected class. Click additional search button in class tab.

[tim]

Newly compiled with SP3D Version 2011SP1.

http://i56.tinypic.com/fk5h6g.jpg

[hikam]

tim, you already got 2011sp1?
wow, quite fast ^^;

[tim]

Yesterday I got it, today ready to test.
It's strange that SP3D 2011 does not have report template for SmartPlant Review Direct even after applying hot fix 1.

[hikam]

i got and installed it..
but i dont have any ms sql 2008 server here.. (-.-);

[tim]

180 day trial version is enough to test new SP3D.
http://msdn.microsoft.com/en-us/evalcenter/ff459612

Against Intergraph's requirement, Win2003 Server can run SQL2008R2 and seems to work with SP3D 2011SP1.

[snd2000]

For testing S3D, you can also use SQL Server Express Edition. Tihs is free edition with size limit per database of 2 or 4GB

[hikam]

thanks tim and snd2000 for the info
will try for it

[RainRiku]

Thanks Tim..it's very useful to me..

very great indeed..real pro bro!!..:D

[tim]

Ver 0.619 update

Relation analyzer can follow relation beyond model database (from part to catalog)
Export can work for catalog information (commodity code etc.) by following relation beyond model database.

These improvement is inspired from recent thread (http://www.davetyner.com/forum/showthread.php?10057-How-to-code-private-relationship) by jamesmuga.

Bug fix to fail to start when user is logging in to local computer. (Thanks for bug report snd2000)

[tim]

Ver 0.620 update

Special export location (x,y,z) and rotation (bearing, pitch, roll) added.
Select three columns in Excel sheet then click the new button. (Shift+Click for rotation)

[tim]

Ver 0.621 update
Add special import set x,y,z and set bearing, pitch, roll. This function will work for equipment and shape only.

Ver 0.622 update
Shape export/import works for design solid and its child shape.(two columns added to Excel format.)

Ver 0.623 update
Shape export/import works for imported shape (.dgn/.sat).

[h3nrik]

Hi. I've been using Object Search a lot just for searching, makes SP3D so much better! But now I have started to fiddle with Export/Import to Excel.
I have made a couple of dummy PipeLines and loaded a Workspace with only these pipes.

I search for PipeLines within Workspace, then right click on a pipe line to set access right colour. I get grey (other status)

Export to Excel with 'Add common att' checked. Export works.

I select the row for SequenceNumber and Export values to Excel. Great. Now I changed them, mark all the changed cells and press Import.
Now every cell (for all attributes, not just sequence number) turns magenta - read only by approval status?
I tried setting approval status also and importing but no luck..

I check back in SP3D and properties on pipelines and sequence number hasn't changed.

I have tried a lot of different aproches and somehow - after trying back and forth I have managed to change to change the sequence number through import. But I have yet to understand how I did it.

Am I doing somthing fundamentally wrong or what's happening? (I have all the user rights to change/delete the pipelines=

[tim]

h3nrik

Thanks for test and detailed report.

There must be access right status which I did not assume.
Import will check access right condition and skip processing if access right is not what I expect and whole row will be magenta.

I'll send PM with link of different OCX file for investigation. Please inform result. I'll fix the bug ASAP.

[tim]

Ver 0.6.24

Access right issue solved.

New access right color rule for both search result grid and exported Excel sheet is;
Full access - No color
Write access - Light yellow
Read only - Dark yellow
Approved, Rejected, In Review status - Magenta
other unexpected status - Grey

[tim]

Ver 0.6.25

Add multi-line tool tips for main search grid.
Function to delete customized basic class from combo box.(Press delete key on the class combo box)
Import test mode. (Shift + click import button). This function will skip commit to database. So you can check import result without updating data.

[tim]

Ver 0.6.26

Add button to bottom toolbar to run several developer tools(Schema browser, View generator and Error Log Enable)
Function to add class to combo box from interface. (Click Ctrl+X on interface combo box)
Function to add class to combo box from business object tree node. Show BO tree and click "Add class" button.
Add button "Compare Design Basis"to Other processing tab. This button can export 3D model property and design basis property. Select blank two columns on exported Excel sheet and click "Compare button".

I'm not sure how many member here are working with integrated environment and using P&ID-3D correlation function.

[tim]

Ver 0.6.27

Function to open "Compare Design Basis" for selected item in Excel sheet. (Additional Excel button on Compare with Design Basis form)
Option to display only root class in class combo box. (Shift + Click "Detail" option to switch to Root.)
Set background color for combo boxes.
Class Combo --- Light Yellow:Root Class, No Color:Sub Class
Interface Combo --- Pink:Hard-coded interface
Attribute Combo --- Pink:Read only, Light Blue:Not displayed on property page, Yellow Green:Code list type attribute
Function to call repository browser for object in the search result grid (Additional right-click menu)
Function to check version consistency between SP3D itself and object search.

Several bug fix and optimization.

[tim]

Version 0.6.28
Add part A/B's system hierarchy to interference Excel report
Add search option of system hierarchy for interference part A/B.
Update check will not be displayed if user select "NO" for one day.

Version 0.6.29
Add special impprt pipe spec for pipe run.
Add special import nominal diameter for pipe run.
(Shift+Click "Special Import" frame will display these two additional buttons.)

Notice:
I decided to stop updating Object Search for SP3D version 2009SP1 because our company no longer apply this old version.
Version 0.6.28 is the last version for SP3D 2009SP1.

[sconvens]

Wondering if you could navigate via the "Analyse Relationship" from Piperun to display the Piperun's Path Coordinates?
Anybody out there found the "Analyse Relation" Relationships (rel:) to navigate to this Coordinate level?

[sconvens]

Wondering if you could navigate via the "Analyse Relationship" from Piperun to display the Piperun's Path Coordinates?
Anybody out there found the "Analyse Relation" Relationships (rel:) to navigate to this Coordinate level?

Need likely to navigate to CPRtePipeComponentOcc/IJOccurrence. But how?

[tim]

sconvens

This question is related to another thread about BOP label.
As chintan suggested in other thread, you can get coordination information from feature not pipe part. See view JRtePathFeature for x,y,z.
My relation analyzer only display interfaces which has reportable attributes. That's why IJOccurrence is not displayed.

As I mentioned, getting BOP by simple query for pipe run is difficult. Search longest horizontal pipe by program seems only way. Otherwise how you can find correct feature for BOP in a pipe run?

[tim]

Version 0.6.30 update

Function to generate code snippet for COM query.
Right click "stroke" button for single stroke.<STROKES>-</STROKES>
Right click number of strokes for accumulated strokes.<STROKES>-</STROKES>
Shift + Q on property combo box in relation analyzer for full code. <RETURNED_PROPERTY>-</RETURNED_PROPERTY>.

Code is displayed in message box as attachment and copy to clipboard.

1698

[coodar]

Ver. 0.606/0.607 Update

Search by Part Number added
Search by Commodity Code added
Operation to search result grid(select/fit/delete/add to workspace etc.) can be cancelled on the way.

Key-in first letter to combo box will dynamically change combo item.
Label next to the combo box is option of search type. C:commodity code, P:Part Number. Click to change.
Why can't i find the select operation to search result in new version? It's useful.

[tim]

Sorry. I forgot to describe how to select.
Ctrl+Shift+Click to select.

[tim]

Version 0.6.31

New Function:Copy Template Tool
This function will compare report/label template in current catalog database with another catalog database and list up missing templates in current catalog.
Then create bulkload Excel file for missing templates and copy files.

Caution for user of SP3D 2011 and MSSQL.
This new function uses SQL-DMO to list up all catalog database in the combo box.
And SQL-DMO is no longer a part of component installed with MSSQL client by default from MSSQL 2008.
So you need to install "Microsoft SQL Server 2005 Backward Compatibility Components" (http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=16177)

[sherwaynes]

THAnks guyz

[peg2]

When I start Version 0.6.31 I get error:
1713
Run-time error '339':
Component MSINET.OCX: a file is missing.

[tim]

Install VB6 Runtime

http://www.microsoft.com/download/en/details.aspx?id=24417

[coodar]

My system version is Win7.
SP3d version:2009.1(08.01.36.0059)
vb6 runtime can't be installed correctly.
When I recall the version 0.6.31, The runtime error changed from '339' to '429':
Run-time error '429':
ActiveX component can't create object.

Is that Compatibility issue?
how to resovle it?
thanks.

[tim]

Ummm

MSINET.OCX has compatibility problem with Windows 7 especially in case of 64bit.
Try to follow instruction below.
http://angrybyte.com/windows-hacks/msinet-ocx-for-64-bit-windows-7-vista/

I put MSINET.OCX here (http://dl.dropbox.com/u/268816/MSINET.OCX).

[coodar]

it works.thanks so much.

[RainRiku]

1740

I can't register the dll in windows 7..any ideas?..

Thank you

[tim]

It's UAC issue.
Run regsvr32 with elevated account or turn off UAC.

[RainRiku]

run as administrator...tsk sorry

Thank you..

[RainRiku]

Thanks very useful especially the Relation Analyzer...

B)

[tim]

Ver 0.6.32 update

Function to create report of property mismatch between SP3D-PID. This idea is from RainRiku.
-Click "Compare Design Basis" button in Other Processing Tab. Then select class and click "Inconsistency Report" button to generate report.
Function to search catalog part. (Ctrl+Click basic/detail option in class tab to switch)
"MSINET.OCX" is no longer used to avoid error with Window 7.

Several bug fix.

Add new SQL (Piping Feature with Non-Default Commodity Option) to common library

[RainRiku]

Whoa that was fast..

I've just finished my report i'll try yours..

[tim]

Ver 0.6.33 Update

Function to add new attribute column to main search grid. (Shift+ Click Add Att button)
Special Import, Set Approval Status to all Children in Special Import 2 Tab.

[coodar]

When i use "search by system" function, I wanna select more than one system, is that possible?

[tim]

Ver. 0.6.34 Update

"search by system" can select multi-system.

Thanks for your feedback, coodar.

[tim]

Ver. 0.6.35 Update

Add Split character text box for "1 to n" relation export (Blank = vbLf)
Shift+Click "Add Att" in relation analyzer will add new column in search result grid.

Bug fix: export not work for relation beyond piping spec.
Bug fix: import not work correctly for IJDObject/ApprovalReason (Status of Ver 2011)
Other minor bug fix.

[ajay]

Hi Tim,

The tool was working in my machine perfectly earlier.
I formatted my machine a week ago and updated Win xp SP3 and installed MS office 2010.
Now it says Active X error 429. Solution Please?

[tim]

Did you register DLL by regsvr32?
Which version of SP3D are you using?
Did you select correct one?

[ajay]

Yes i have registered.
SP3D ver 2009.1 HF19
When i run the custom command a pop up appears asking for new version download. I just cancel it then run time error occurs, again when i try it says error 429

[tim]

So your dll is old version, It contains bug.
Why don't you download latest one?

[ajay]

Thanks tim. The new version works.

[ts721521]

Hi Tim
I had download the latest DLL(SP3DOBJSearch2011),and registered with regsvr32 successfully.But a pop up error (
---------------------------
SP3D Object Search
---------------------------
Run-time error '429':

ActiveX component can't create object
---------------------------
OK
---------------------------
My SP3D version is SP3DSP1 09.00.71.0065

Oracle 11R 2 database with path15.

OS:Win7 64 Bit.

Pls help on this issue.

[tim]

Check following components exist in your client. (System32 folder except indicated)

MSCAL.ocx (Microsoft Calender Control)--may exists in MS Office installation folder.
comdlg32.ocx (Microsoft Common Dialog Control 6.0)
mshflxgd.ocx (Microsoft Hierarchical FlexGrid Control 6.0)
TABCTL32.ocx (Microsoft Tabbed Dialog Control 6.0(SP6))
MSCOMCTL.OCX (Microsoft Windows Common Control 6.0 (SP6))
MSCOMCT2.OCX (Microsoft Windows Common Control-2 6.0 (SP6))

[tim]

There's a possibility of wrong file distribution by my mistake.
Would you please re-download and re-try?(Same URL version 6.35)
I have checked this one works with version 09.00.71.0065.

[ts721521]

Hi Tim Thanks a lot.It works.

[sam.n.v.]

Hi Tim, we updated sp3d 2011 to version 2011 r1. In 2011 r1 your custom command is not working, can you create an update for sp3d 2011 r1. Without your custom command can not work already...

[tim]

sam.n.v.

SP3D Object Search for version 2011R1 is now available.
See top post to download.

[sam.n.v.]

Hi Tim, thanks a lot!!!

[tim]

Ver. 0.6.36 Update

Function to modify/delete custom (means user-defined) class/interface/attribute information.

Shift+E on class combobox to change user class name.
Shift+D on class combobox to delete user class definition.
Shift+D on interface combobox to delete user-defined interface definition.
Shift+E on attribute combobox to edit attribute settings or delete attribute definition.

These new function to work for user-defined class/interface/attribute only.

[hikam]

thanks alot tim for this great tools.

i tried your report function (export) by analyze relation and it is good.

is there any way that i can make that report as a template in drawing and report?
or any way to see the query script that made after setting something by analyze relation?

thank you

[tim]

>any way to see the query script that made after setting something by analyze relation?

Function to generate code for com query is available in relation analyzer.
Information shown in message box will be copied to clipboard. Just paste it in .rfq file.

http://www.davetyner.com/forum/showthread.php?7505-SP3D-Custom-Command-(Test-Request)/page15#146

[hikam]

thanks tim,

sorry i didn't read previous pages.

[tim]

Version 0.6.37 update

Function to manage equipment nozzle.

How to use
Select one equipment in workspace then start the command
Or Start command first and search target equipment and select (Ctrl+Shift+Click on the search result grid)
Click Equipment tab then move to Nozzle tab.

You can see nozzle list in grid control. (Edit/Delete from right click menu)
You can add new nozzle. (Select reference datum shape from combo box then click "Place Nozzle" button)

[tim]

Version 0.6.38 Update

Improvement of nozzle manage function

Add connected pipe run's PipeSpec Name in nozzle list
Add Copy to clipborad button in nozzle list for conventional reporting.
Double click equipment name will fit view
Highlight reference object when select in combo box

Add fragmentation check for pipe line list

How to use
1) Search Pipe Line with any condition and display pipe line list in the grid.
2) Right-click picture button next to the "inc. EF" check box.(See attached)
3) After checking, search grid background color turns to red for empty pipe line, light green for fragmented pipe line
4) Double click fragmented pipe line to fit to the view, then right-click and select "Highlight fragmentation" to check visually in the view.
All pipe run under the pipe line selected and one fragment becomes highlighted.

[KevinD]

Hi Tim, I tested both new features..work well..Can you please elaborate on "Pipe Line fragmentation" in Sp3D? I am not aware of this term. Thanks,

[tim]

This feature is suggested by recent thread started by hikam. See the related thread.

http://www.davetyner.com/forum/showthread.php?11706-separated-piperun

[KevinD]

Thanks Tim. Now I understood. Your function identifies disconnected PipeLine (under which PipeRuns are grouped in WS explorer.) If a Piperun has disconnected sections, can they be detected in a similar fashion?

Also, I was trying the ShapePlacer refering to demo video you posted. It does not work when I use the Assistant Mode of Object Search utility? It is greyed out. (Import Shape Info, Import Nozzle Info and Shape Placer). just want to know is it my machine or some other issue??

Also when I use it in Regular Mode, (Ctrl + F)after placing a shape or using it, while closing the utility get this error,

Run-time error '91':
Obkect variable or With block variable not set

[tim]

Answer to first question
Disconnected and fragmented is different issue.
Fragmented pipe run does not necessarily has disconnected open end.

If you want search simply disconnected pipe run, search by SQL is enough.
Common SQL library has corresponding one.

Answer to second question
Assistant mode can not do any transaction (modify/create) to the database, so Shape Placer is disabled.

[KevinD]

thankx again for clarification..

[tim]

About your error report, I could not repeat your error.
Please describe more detail step. How to cause this error.

[KevinD]

Its not coming all the time..I will report more details the next time when I face it..

[KevinD]

Hi Tim, I was trying to use your below feature on the Training Plant model.
################################################## #################
Function to create report of property mismatch between SP3D-PID. This idea is from RainRiku.
-Click "Compare Design Basis" button in Other Processing Tab. Then select class and click "Inconsistency Report" button to generate report.
################################################## ##########################

Is it possible to have a Topology comparison as well which can be further reported similar to Properties?

[tim]

Thanks for your suggestion.

Yes it's technically possible.
But I don't think it's good idea to report in detail as property mismatch.
I don't feel it's useful to see topology mismatch item list in Excel format.
To solve topology mismatch, we have to visually compare between P&ID and 3D anyway.

I'll add option to set cell color on item name when it has topology mismatch in the next release.

[hikam]

thanks a lot tim for including fragmented pipeline in your tools. it's nice to have it.

btw, any way to extract only green/red pipeline to excel for reporting?

[tim]

hikam

I'll implement it in the next release.

[KevinD]

Just for info.. I was doing the Sp3D piping training. I found one use of the the Fragmented Pipeline feature in cases where we have used the Insert Split Command and placed a Feature Break, it detects the Pipeline and hilights the Fragmentation location. (This is not usually visible after placement.)

[hikam]

hikam

I'll implement it in the next release.

thanks a lot tim

[KevinD]

Hi Tim,

When I Special Export from Other Processing tab, is it possible to get the Column Name exported at the same time when we click on the buttons, like Project or WBS? I exported a Pipeline and then from Other Processing I exported Project and WBS . I am getting the values but not the column names in the Excel file.

[tim]

It's possible but I reject to implement it.
Put any name as you like manually.

[KevinD]

Ok. Thanks Tim.

[KevinD]

I was trying "Set Access Rights Color" in search grid result. for "In Review" items, status is appearing Magenta insead of Light Green??(ref.
has anyone faced similar color for In-review items?

[KevinD]

1975

snapshot attached in this post.

[tim]

Thanks for your report.

I modified my old post.

http://www.davetyner.com/forum/showthread.php?7505-SP3D-Custom-Command-(Test-Request)/page14#138

[KevinD]

1976
When using Search By Attribute option, for number based search the Operator type Note Equal To is not available whereas its available for CodeListed Attribute.
It will be useful also to find piperuns not matching a given Min Design Temp for example.
However, if this is not justified, its ok.

[tim]

Reject.
I can not imagine the case to use "not equal" search condition for pipe run temperature.
That's why I intentionally omit not equal.

[KevinD]

1979
Hi Tim,
one small query.
Using Shape Placer to add to Designed equipment, we are getting the object iterations along X, Y, Z or combinations of these axes(Axial Iteration). Is Radial placement of shapes is possible using SHape Placer, where one places a designed eqp shapes at a location that needs to be copied Radially to create multiple instances/iterations?
(Refer attached image)

Thanks.

[tim]

Not possible.
Offset by cylindrical coordination is required to achieve it.

[tim]

This is what you want.

[KevinD]

Great..Thanks Tim. I used Radial grids and planes to achieve something like that ( 1981 )..but I found it really time consuming as I had to copy the main eqp at each intersection of radial grid/plane and and then rotate to match the orientation. This also created many copies of the Original eqp in WS hierarchy.

I will try with your utility to see if I can build the required eqp using multiple shapes and then create instances of of those combined shapes radially.

[KevinD]

Hi Tim, I cant see the Catersian/Cylindrical Option under Location. Is it new version of Sp3D Object Search?

[tim]

Yes.
That's why I answered "Not possible" (with current version) at #206.

[KevinD]

Ok..We will wait for the new version. Thanks,..

[tim]

Ver. 0.6.39 Update

Copy Pipeline fragment check result to clipboard. (simply paste to Excel) (requested by hikam)

For those who can not access dropbox.com from S3D workstation
1) Option to skip latest version check from next time (Click to Yes to message box)
2) Ability to read local SP3DObjectSearch_SQL.xml file instead of common SQL library in dropbox.com
Save attached file and rename .txt to .xml in the same folder where .ocx exists.

Shape export/import can handle design equipment component and it's child

Improve Shape Placer
1) Ability to set position by cylindrical coordinate
2) Aspect selection
3) Add combo box to select parent (equipment, component or design solid)
4) Maximum number of dimension parameter is increased from 5 to 8.

"Set Status to all Children" can be applied WBS item and all assigned objects

Improve Inconsistency Report
1) Add Topology option (will set color for topology mismatch items)
2) Report will display codelist short text instead of codelist number.

Several bug fix as usual.

[KevinD]

Good day Tim,

Thanks for the updated version. Could you pls share some tips on How to Use the Cylindrical placement using Shape Placer. Also, it will be good to have Tool-tips when we hover over the fileds like r, s. Snapshot: 1985

For keying in the dimensions for shapes, it it possible to match the active session Unit settings in Shape Placer? ( I am getting Ft in Shape Placer, but my active setting in Tool-Options is Ft-in )

Thanks for the Local XML Based queries using local machine. One very minor finding... 1986

[tim]

Cylindrical Coordinates
http://mathworld.wolfram.com/CylindricalCoordinates.html

parameter is radial, azimuthal, vertical from the top. And vertical orientation option. (default z-axis)

Orientation is angle of x-y plane, y-z plane, z-x plane.

[hikam]

many many thanks for this update

btw, link for 2011R1 seems not working well (or is it only me?)

[tim]

Sorry it's copy and paste error. Link fixed.

[KevinD]

is it possible to modify the System Path for Shapes residing under a Designed Equipment or Designed Equipment COmponent, to bring them under a hierarchy like...

for ex.
FROM
SP3DTrain\A2\U08\Equipment\DesignedEquipment\Shape s

TO

SP3DTrain\A2\U08\Equipment\DesignedEquipment\Desig ned Solid\Shapes

I tried using the Import Export function to first export Shapes and then System Path. Modify the path to bring Shapes under Designed Solids and Import. but it did not work.

any suggestion please..

[tim]

It did not work.
"Set path" works to change system parent only. Solid - Shape is different relationship.

I'll implement it in the next version.Thanks.

[tim]

Ver. 0.6.40 Update

Dimension/location text box is refined (auto convert to default unit) on shape placer form.
Add button to create design solid on shape placer form.
Command line argument "/S" to run shape placer directly (skip main form/equipment form)

Add "PBS" option to "Report Tree" export.

Replace volume search option from self coding tree control to hierarchy combo box.

Special import "Set Path" works to relocate shapes.

[KevinD]

Thanks a lot Tim for new update. have a nice evening..
Update:

Tested the Special Import to relocate shapes..Works great..many thanks.

[KevinD]

Hi Tim,

Can you pls explain more on how to use Shape Placer directly?
where we have to use the "/S" switch?

Update:

I got it.. added the "/S" argument in Custom Command form..Thanks...

[KevinD]

While using the Shape Placer directly, when we run the custom command it asks to select the equipment. When I try to select the Eqp or the deisgned eqp.it wont select. ( I have my Select Set filter to All). But when I have selected the Designed Eqp from Workspace explorer, and then run the Shape Placer Custom command, it works..

also, I noticed in Cylindrical placement, while keying the angle value for "s", for increment when I key-in value for Increment as 30, it picks up as "03.00 deg"

[KevinD]

Hi Tim,
Some findings using V6.40 and V6.39 shape placer.. The values for Dimension parameters do not match when placement is done and also for Cylindrical placement is different from v6.39 using same values for r, S and increment.

19881989

[tim]

Thanks for bug report.

Bug fixed, download again. (same version same URL)

>When I try to select the Eqp or the deisgned eqp.it wont select
It's not matter of my custom command.

[KevinD]

Thanks.Shape placer works fine now.

Hi Tim,

one small request.. To enable easier scrolling in Search Grid or when viewing Clash report in Search Object, can you consider mouse wheel based scrolling in such forms?
as of now, for going to next set we have to click on the up/down arrows.. mouse scrolling the results will be faster..

Also, possible to add Define Workspace as a separate tab within Object search Tool.?

[KevinD]

Searching for Designed Equipment does not return any result. They get populated when we search the regular(Catalog) Equipment.

Not sure whether its a bug in tool or issue with model?

Attachment:
19911992.

[tim]

It's a matter of view definition.(EQUIPDesignEquipmentView)
Each class has dedicated view in the database.
Sometimes class view definition is wrong and has no record.

You can check how many records in class view just select class combo box.

[KevinD]

Thanks for that information. Yes, when I select Designed Equipment in class combo box, it shows 0 records in the view(EQUIPDesignEquipmentView)
good to know this.

[KevinD]

Came across Validate Pipeline/PipeRun command in training. (it checks the line or run for inconsistent or illegal pipe run toplogy, port overlaps, gives user report on erros/warnings..)

Ctrl + SHift +D is the keyboard shortcut. will it be a good idea to have similar feature to make this check run on selected pipelines/runs in the result grid? and the line/run wise errors& warnings can be exported to excel.?

Just an idea.

[tim]

I don't understand what is useful to call validation command from my custom command.
Select piperuns/pipelines on search result grid (Ctrl+Shift+Click) then call the validation command manually.

> possible to add Define Workspace as a separate tab within Object search Tool.?
Also I don't understand this request.

[KevinD]

I tried "Select piperuns/pipelines on search result grid (Ctrl+Shift+Click) then call the validation command manually'." Sorry.. It works... Also, it Ctrl+Shift+D works in Piping task only. Adding this check to pipeline/run result grid, on Right Click?

kindly ignore second request..

[tim]

I'm not interesting in adding new right click menu just to call existing default commands.
Especially ones only works for specific object type.

Select objects then call it in normal way.

[KevinD]

for Equipments, is it possible to get the Equipment Classification, Part Number attributes assigned to equipments under Definition tab?? 1993

[tim]

What do you mean "Get"?

Is this question related to my tool?
Do you want to export to Excel?
If so, use relation analyzer.

[KevinD]

yes. i meant Export..
I got it now using Relation Analyzer. really nice feature..

One question.- The Exported values are CodeList Numbers in the Excel file. Any way to export the Details of the Codelist number or resolve Numbers to get the Codelist details in excel ? it will be helful to know the Codelist details in excel file so one can make changes easily by knowing which value to apply and then Import back.
pls refer snapshot

1994

just a query..

[tim]

Check/Uncheck "Export code list value". If you want to see number or short code string.
Operator should not need to care about code number.

[KevinD]

got it..Thanks..

[KevinD]

1995

Can you please provide the working units similar to Shape placer(Unit displayed same as Session file) when we want to Object Search using In Volume option?

In search result grid, pressing Ctrl+A with object selected, does not send to Relation Analyzer. It selects all the objects in result grid.(Ref: Object Search Manual-Rev.04 , pg-11, bullet point f)) (this is just an observation. we can Right -Click and send to Relation Analyzer)

Also after a designed equipment has been placed, is it possible to Update Object Class? does Sp3D alow it? just want to know.

[tim]

Manual is old

A - Send to relation analyzer
Shift +A - Set access right color
Ctrl +A - Select All

[KevinD]

Hi Tim
Considering this link, http://www.davetyner.com/forum/showthread.php?11875-PCF-file-for-Sheet
Save File with HL option can be expanded to Save PCFs out of SP3D for the resuly grid items.

Just an idea.

[tim]

I don't understand what is the relation between ramankumar's question and save with hyperlink function of my tool at all.

[KevinD]

i just meant saving of multiple PCFs at one time (which can be useful for importing into other applications like Caesar-II or SP Isometrics), when we use the Save with HL to save the SHA files locally..

just to share a video on a smartplant symbol placer ..

http://www.youtube.com/watch?feature=player_detailpage&v=_TURSzQUA9Y

[tim]

>saving of multiple PCFs at one time
It's default function of SmartPlant 3D.
It's meaningless to implement it to my tool.

[tim]

Ver. 0.6.41 update

Function to create/rebuild UserShapeDef.mdb from catalog database.
Rotate equipment option after import shape.
Add naming option for import shape.

Shapeplacer
Add function to pick child shape for reference point.
Add function to delete child from combo box.

Add auto unit conversion to volume range text box.

Other several bug fixes.

[KevinD]

Thanks..New features work well.

When importing shapes, is it possible to have a feature like Preview and then Ok to confirm Import.(Like in Shape Placer).

Shape Dimensions get exported in Meters while active units are Ft-in. Sp3D handles this unit conversion internally, I guess.

[tim]

I could not reproduce such error.
Please inform exact version of S3D.

[KevinD]

09.01.30

using win7 32 bit..

[tim]

>09.01.30
It's not exact version number.
What I want to know is hotfix applied.

[KevinD]

09.01.0.00057

[tim]

My develop environment is 09.01.30.0062.
So please try to apply hotfix.