Robert McAnany 2024
Contributors: @[Francesco Arfilli] (github @farfilli), @daysanduski, @mmtrebuchet, @[o_o ....码], @ChrisNC (github @ChrisClems), @ZaPpInG (github @lrmoreno007)
Beta Testers: @JayJay04, @Cimarian_RMP, @n0minus38, @xenia.turon, @MonkTheOCD_Engie, @HIL, @[Robin BIoemberg], @[Jan Bos], @Rboyd347
Helpful feedback and bug reports: @Satyen, @n0minus38, @wku, @aredderson, @bshand, @TeeVar, @SeanCresswell, @Jean-Louis, @Jan_Bos, @MonkTheOCD_Engie, @[mike miller], @[Francesco Arfilli], @[Martin Bernhard], @[Derek G], @Chris42, @JasonT, @Bob Henry, @JayJay101, @nate.arinta5649, @DaveG, @tempod, @64Pacific, @ben.steele6044, @KennyG, @Alex_H, @Nosybottle, @Seva, @HIL, @[o_o ....码], @roger.ribamatic, @jnewell, @[Robin BIoemberg], @Pedro0996, @Imre Szucs, @Bert303, @gir.isi, @BrianVR74
Notice: Portions adapted from code by Jason Newell, Tushar Suradkar, Greg Chasteen, and others. Most of the rest copied verbatim from Jason's repo or Tushar's blog.
Solid Edge Housekeeper helps you find annoying little errors in your project. It can identify failed features in 3D models, detached dimensions in drawings, missing parts in assemblies, and more. It can also update certain individual file settings to match those in a template you specify.
If this is your first time here, you may want to check out the Quick Start Guide. It's not nearly as detailed as this README, but it will get you up and running much more quickly.
Feedback from users
This is the Michael Jordan of macros! I've tried lots of them. This is on a whole other level. Thank you!
This is going to save me SO MUCH TIME! Thank you for sharing!
Thank you for all your time and effort (...) Also thanks a lot for making it open source. I constantly reference your code for my own macros, which motivates me to make my projects open source as well.
Awesome. It looks like you are still overachieving with this app, and I thank you for it. If they ever figure out how to automate me running Housekeeper, I will be out of a job!
Rad, this saves a mountain of time for me. Thanks!
Responding to the prompt *"Heard any good jokes about Solid Edge Housekeeper?", Google's Bard said:
Why did the Solid Edge Housekeeper get a promotion?
She was the only one who could clean up the mess that Solid Edge users make.
Start with the context-sensitive help icon 
. Every command, and most dialogs, have one.
If it doesn't show what you're looking for, click 
to open the Table of Contents as shown below.
Ask questions, report bugs, or suggest improvements on the Solid Edge Forum
If you want to make Housekeeper better, join us as a beta tester! Beta testing is nothing more than conducting your own workflow on your own files and telling me if you run into problems. It isn't meant to be a lot of work. The big idea is to make the program better for you and me and everyone else!
To sign up, message me, RobertMcAnany, on the forum. (The Messages button is hidden under your profile picture, at the very top right of the page). Unsubscribe the same way. To combat bots and spam, I will probably ignore requests from User16612341234.... (Change you nickname in My Profile, also under your profile picture).
If you know .NET, or want to learn, there's more to do! To get started on GitHub collaboration, head over to ToyProject. There are instructions and links to get you up to speed.
There is no installation per se. The preferred method is to download or clone the project and compile it yourself.
The other option is to use the Latest Release. It will be the top entry on the page.
Click the file SolidEdgeHousekeeper-vYYYY.N.zip (sometimes hidden under the Assets dropdown). It should prompt you to save it. Choose a convenient location on your machine. Extract the zip file (probably by right-clicking and selecting Extract All). Double-click the .exe file to run.
The first time you run it, you may encounter the following dialog. You can click More Info followed by Run Anyway to launch the program. 
If you are upgrading from a previous release, you should be able to copy the settings files from the old version to the new. The files are stored in Housekeeper's Preferences folder. There is one exception. Starting with v2024.2, property filters are stored in a *.json format. The old *.txt format is no longer used.
Select which files to process on the Home Tab. Select what to do on the Task Tab. There are many options for selecting files. See FILE SELECTION AND FILTERING below for details.
If any errors are found, a log file will be written to your temp folder. It will identify each error and the file in which it occurred. When processing is complete, the log file is opened in Notepad for review. If you want to open an old log file, look for file names starting with 'Housekeeper' in the %temp% folder.
To start execution, click the Process button. The status bar tracks progress. You can also stop execution if desired. See STARTING, STOPPING, AND MONITORING EXECUTION for details.
You can select files by folder, subfolder, top-level assembly, top-level folder, or list. There can be any number of each, in any combination.
Another option is to drag and drop files from Windows File Explorer. You can use drag and drop and the toolbar in combination.
An alternative method is to select files with errors from a previous run.
Choose this option to select files within a single folder, or a folder and its subfolders. Referring to the diagram, click 
to select a single folder, click 
for a folder and sub folders.
Choose this option to select files linked to an assembly. Click 
to choose the assembly, click 
to choose the search path for where used files.
You would be asking for trouble specifying more than one top-level assembly. However, you can have any number of folders. Note the program always includes subfolders for where used files.
A top level assembly search can optionally report files with no links to the assembly. Set this and other options on the Configuration Tab -- Top Level Assembly Page.
When selecting a top-level assembly, you can automatically include the folder in which it resides. This auto include option in on by default.
If auto include is turned off, you do not have to specify any folders. In that case, Housekeeper simply finds files directly linked to the specified assembly and subassemblies. Note this means that no draft files will be found. For that reason, a warning is displayed. Disable the warning on the Configuration Tab -- Top Level Assembly Page.
If you do specify one or more folders, there are two options for performing where used, Top Down or Bottom Up (see next). Guidelines are given below, however it's not a bad idea to try both methods to see which works best for you.
Bottom Up
Bottom up is meant for general purpose (hopefully indexed) directories (e.g., \\BIG_SERVER\all_parts\), where the number of files in the folder(s) far exceed the number of files in the assembly. The program gets links by recursion, then finds draft files with where used. If your draft files have the same name as the model they depict, click that option and the program will find drawings directly, bypassing the often time-consuming where used operation.
A bottom up search requires a valid Fast Search Scope filename, (e.g., C:\Program Files\...\Preferences\FastSearchScope.txt), which tells the program if the specified folder is on an indexed drive.
Top Down
Top down is meant for self-contained project directories (e.g., C:\Projects\Project123\), where most of the files in the folder(s) are related to the assembly. The program launches Design Manager to open every file within and below the top-level assembly folder(s). As it does, it creates a graph of the links. The graph is subsequently traversed to find related files. I don't know how it works; my son did that part.
Include parents of part copies option
This option may be confusing. Referring to the diagram, note that C.par is a parent of B.par. B.par is in top.asm, while C.par is not. Enabling the option means that C.par would be included in the search results.
Referring to the diagram, click 
to import a list, click 
to export one.
If you are importing a list from another source, be aware that the file names must contain the full path. E.g., D:\Projects\Project123\Partxyz.par, not just Partxyz.par.
Select files with errors from the previous run
Click 
to select only files that encountered an error. All other files will be removed from the list. To reproduce the TODO list functionality from previous versions, you can export the resultant list if desired.
Remove all
Click 
to remove all folders and files from the list.
Shortcut menu
If you select one or more files on the list, you can click the right mouse button for more options.
- Open: Opens the files in Solid Edge.
- Open folder: Opens the files in Windows File Explorer.
- Find linked files: Populates the list with files linked to a top-level assembly. Similar to Update but no other File Sources are processed.
- Process selected: Runs selected Tasks on the selected files. This does the same thing as clicking the Process button.
- Remove from list: Moves the files to the Excluded files section of the list.
The update button 
populates the file list from the File Sources and Filters. If any Sources are added or removed, or a change is made to a Filter (see Filtering below), an update is required. In those cases the button will turn orange to let you know.
You can limit the search to return only selected types of Solid Edge files. To do so, check/uncheck the appropriate File Type 
You can sort the file list in a variety of ways.
The options are Unsorted, Alphabetical, Dependency, or Random sample. Set it on the Configuration Tab -- Sorting Page.
The Unsorted option is primarily intended to preserve the order of imported lists.
The Dependency option is useful in conjunction with the Update part copy command. It is intended to help eliminate the tedious model out-of-date (dark gray corners) on drawings.
Dependency ordering is not fool proof. It has trouble with mutual dependencies, such as Interpart copies. I've had some luck simply running Update part copy twice in a row.
The Random sample option randomly selects and shuffles a fraction of the total files found. The Sample fraction is a decimal number between 0.0 and 1.0. This option is primarily intended for software testing, but can be used for any purpose.
If you use the document Status functionality, you know that some settings place the file in read-only mode. These cannot normally be processed by Housekeeper.
You can get around this by checking Process files as Available regardless of document Status. Set the option on the Configuration Tab -- Status Page.
After processing, you can choose to change the Status back to the old value, or pick a new one. In the example, I decided to change everything to Available. You can select the new Status by clicking the appropriate button in the table. For instance, if you wanted to convert all Baselined files to Released, you would click the last button on the second row.
If you want simply to change the Status on a batch of files, specify your Before/After choices here, then run the Open/Save command.
If you don't need to worry about document Status for your current task, it's not a bad idea to disable the Process files as Available option. That's because, when enabled, it launches Design Manager. That doesn't hurt anything, but it can be a bit confusing to see that program pop up while Solid Edge is actively processing files.
Filters are a way to refine the list of files to process. You can filter on file properties, or filenames (with a wildcard search). They can be used alone or in combination.
The property filter allows you to select files by their property values. Prior to using this tool, you first need to populate properties from your templates. Please refer to instructions in the Configuration Tab -- Top Level Assembly Page section of this Readme.
To configure a property filter, click the tool icon 
to the right of the Property filter checkbox.
The Property Filter checks Draft files, but they often don't have properties of their own. For those files, Housekeeper can also search any models in the drawing for the specified properties. Set the option on the Configuration Tab -- General Page. One situation where you might want to disable this option is when searching for file Status. See Document Status Options below.
This is a powerful tool with a lot of options. These are detailed below.
Composing a Filter
Compose a filter by defining one or more Conditions, and adding them one-by-one to the list. A Condition consists of a Property, a Comparison, and a Value. For example, Material contains stainless, where Material is the Property, contains is the Comparison, and stainless is the Value.
Any number of Conditions are allowed for a filter. The filters can be named, saved, modified, and deleted. The tools to do so are in the Toolbar -- Saved Setting Group.
Most people use a limited number of properties. You can set which ones are available in the drop-down list. That is done on the Configuration Tab -- Templates Page.
The Available Properties are populated by clicking the Update button. You then use the Customize dialog to add, remove, and rearrange as needed. If you need a property not in the template, right-click the Selected Properties list and add it manually.
Property Set
In addition to entering the Property name, you must also specify the Property set, either System or Custom.
System properties are in every Solid Edge file. They include Material, Project, etc. Some are in English only, others are localized.
Custom properties are ones that you create, probably in a template. Solid Edge also creates some Custom properties for you. These include Exposed Variables and output from the Inspect > Physical Properties command. The custom property names can be in any language. (In theory, at least -- not tested at this time. Not sure about the Solid Edge entries either.)
Template properties will know their PropertySet. Unless you added it manually, that is, in which case you specify it yourself.
Comparison
Select the Comparison from its dropdown box. The choices are contains, is_exactly, is_not, wildcard_match, regex_match, >, or <. The options is_exactly, is_not, >, and < are hopefully self-explanatory.
Contains means the Value can appear anywhere in the property. For example, if you specify Aluminum and a part file has Aluminum 6061-T6, you will get a match. Note, at this time, all Values (except see below for dates and numbers) are converted to lower case text before comparison. So ALUMINUM, Aluminum, and aluminum would all match.
Wildcard_match searches for a match with a wildcard pattern. For example [bfj]ake would match bake, fake, and jake. A more familiar example might be Aluminum*, which would match Aluminum 6061-T6, Aluminum 2023, etc. Unlike contains, in this example, Cast Aluminum Jigplate would not match because it doesn't start with Aluminum. (*Aluminum* would match, by the way.)
Internally the VB Like Operator is used to make the wildcard comparison. Visit the link for details and examples.
Regex_match uses Regular Expressions. They are flexible and powerful, but explaining them is beyond the scope of this document. For more information see REGEX in .NET, or better yet find a programmer who uses them daily. That's what I do.
Default Filter Formula
Each Condition is assigned a variable name, (A, B, ...). The default filter formula is to match all conditions (e.g., A AND B AND C).
In the image above, sticking with the default formula means you would get all parts in project 7481 made out of Stainless and engineered by Fred, i.e., A AND B AND C.
Editing the Formula
You can optionally change the formula. Click the Edit Formula button in the toolbar and type the desired expression. For example, if you wanted all parts from Project 7481, either made out of Stainless, or engineered by Fred, you would enter the formula shown,
i.e., A AND (B OR C).
One More Thing About the Formula
Prior to Housekeeper V2024.2, the formula, a boolean expression, was parsed and evaluated using the .NET built-in VBScript engine. Oversimplifying a bit, that is no longer supported on 64-bit operating systems.
The program now uses PowerShell to do the evaluation. The communication code is built into .NET, but PowerShell itself has to be installed separately. On recent versions of Windows (maybe back to Win7, not sure) it comes bundled with the OS, so it shouldn't be an issue.
If there is an issue, like PowerShell isn't installed, you won't get an error message. Instead, you'll get no files matching your property search. If you know that's wrong, please mention it on the Solid Edge Forum. There may be other more .NET-native ways of evaluating the formula.
Dates and Numbers
Dates and numbers are converted to their native format when possible. This is done to obtain commonsense results for < and >. Note the conversion is attempted even if the property type is TEXT, rather than NUMBER, DATE, or YES/NO.
Dates take the form YYYYMMDD when converted. This is the format that must be used in the Value field. So if you wanted all files dated before January 1, 2022, your condition would be Custom.Date < 20220101. The conversion is supposed to be locale-aware, however this has not been tested. Please ask on the Solid Edge Forum if it is not working correctly for you.
Numbers are converted to floating point decimals. In Solid Edge many numbers, in particular those from the variable table, include units. These must be stripped off by the program to make comparisons. Currently only distance and mass units are checked (in, mm, lbm, kg). It`s easy to add more, so please ask on the Forum if you need others.
Document Status
You can select files based on Status, but not like this:
System.Status contains Available
There is a number associated with each Status value. You have to use that instead of the name.
Here is a way to get all Available files: System.Status is_exactly 0
For everything but Available you could use: System.Status > 0
Here's the list:
0 Available1 InWork2 InReview3 Released4 Baselined5 Obsolete
As mentioned above, this is a situation where the option Include Draft file model documents in search can yield confusing results. For example, an InWork Draft file containing a Released part would appear in a search for Released documents.
Saved Settings
The filters are saved in property_filter_saved_settings.json in the Preferences directory under the root directory of Housekeeper.exe. If desired, you can create a master copy of the file and share it with others.
The wildcard filter operates on file names. Simply enter the wildcard pattern in the provided combobox. Wildcard patterns are automatically saved for future use. Delete a pattern that is no longer needed by selecting it and clicking 
.
As suggested above, see VB Like Operator for details and examples.
Press the Process button to start executing the chosen tasks. If one or more files on the list were selected, only those are processed. Otherwise, all files are processed.
A checkbox 
to the left of the file name indicates it has yet to be processed. Afterwards, if no errors were detected, a checkmark 
is shown. Otherwise, an error indicator is displayed.
You can monitor progress on the status bar. It shows the number of files processed, the current file, and an estimate of time remaining.
You can interrupt the program before it finishes. As shown above, while processing, the Cancel button changes to a Stop button. Just click that to halt execution. It may take several seconds to register the request. It doesn't hurt to click it a couple of times.
To save some time, you can process files in the background, without graphics. This capability is somewhat experimental; let me know if you run into problems. To save some space on Solid Edge's Most Recently Used list, you can disable adding files that are processed by Housekeeper. Both options are set on the Configuration Tab -- General Page.
The Task Tab is where you choose what operations to perform.
To enable a task, click its left-most checkbox. If it has options, they will appear when the task is selected. You can hide the options by clicking 
(Collapse). If you don't want the options to automatically appear, enable Only show options manually at the bottom of the Options pane.
When a task is selected, the applicable file types are automatically enabled. This is indicated by the four other checkboxes on the task's header row. You can de-select any you don't want to process.
To open the task's help page, click 
on the right side of its header row. There you can learn what the task does and details about any options it has.
The row at the top of the task list has buttons that operate on all tasks. Click the left-most checkbox to disable all. Click (Collapse All) to hide options for all selected tasks.
The remaining four buttons toggle file type selection. In order, they are (Assembly), (Part), (Sheetmetal), and (Draft).
On the far right brings up general help for the task tab.
You can customize the list. To do so, click Edit Task List at the bottom of the form. The following dialog will appear.
The left pane shows all available tasks. The right pane shows the ones currently in use. To reposition a task in the list, select it and click Move up or Move down. To remove one, select it and click Remove.
To add a task, select one from AVAILABLE TASKS and click Add. You can have multiple copies of the same task. This is handy for many situations. For example, if you have a printer for small drawings and a plotter for large ones, you can place two Print tasks on the list and configure them accordingly.
Each task must have a unique name. Rename one by double-clicking it in the list. You can rename all of them, for example in your own language, if desired.
The tasks are color-coded. Change the color by selecting the task, right-clicking, then selecting Change color. I'm not kidding that the task needs to be selected before right-clicking. Otherwise for some reason the task at the top of the list is modified. Anyway, you can change hue, saturation and brightness. A preview of your choices is provided on the dialog.
To save the changes, click OK, Cancel otherwise. To start over with the task list, delete the file task_list.json in Housekeeper's Preferences directory. Note, in doing so you will also lose any customizations you did, such as setting your template locations, etc.
Speaking of task_list.json, like any other file in the Preferences directory, you can share your customized version with others. Just copy it into their Preferences directory.
Global options for the program are set on this tab.
See the Top Level Assembly section.
See the Document Status section.
See the Sorting section.
Templates and related tools.
Description of tab controls:
Assembly,Part,Sheetmetal,Draft,Material TableButtons to let you specify template locations.UpdateThis is where you pre-populate properties for use in dialogs that need them.CustomizeThere are a lot of properties in a Solid Edge file. This is where you decide which ones to see and in what order. For details, see the Property Filter section (scroll down a bit to find it).
Everything else.
Description of tab controls:
Use current Solid Edge session (if any)Normally Housekeeper will not start if Solid Edge is open. This is to protect you in case opening a file causes an exception in Solid Edge. This can happen with a corrupted file and other situations. If it does, the program closes and reopens Solid Edge, causing any unsaved changes to be lost. Enabling this option bypasses that check.Warn me if file save is requiredThis is a way for me to wag my finger one last time, reminding you to back up files before using the program. It's enabled by default. I always turn it off.Do not show processed files in Most Recently Used ListThis keeps from clogging up Solid Edge's file list with those processed in batch mode.File list font sizeThis allows you to change the font size of the file list.Remember selected tasks between sessionsWhen you close out of Housekeeper, it records the state of all settings, such as template locations, etc. Normally that's what you want, but not necessarily for task selection. This lets you decide how to handle that.Property Filter -- Include Draft file model in searchFor details, see the Property Filter sectionProperty Filter -- Include the Draft file itself in searchFor details, see the Property Filter sectionCheck for newer version at startupUses GitHub's API to get the most recent version and compares it to the running version. Not everyone wants programs to access outside resources like that, so is disabled by default.
Opens a document and saves in the current version.
Loads all assembly occurrences' geometry into memory and does an update. Used mainly to eliminate the gray corners on assembly drawings.
Can run out of memory for very large assemblies.
Checks to see if the part's material name and properties match any material in a file you specify on the Options panel.
If the names match, but their properties (e.g., density, face style, etc.) do not, the material is updated. If no match is found, or no material is assigned, it is reported in the log file.
You can optionally remove any face style overrides. Set the option on the Options panel.
In conjuction with Assembly Activate and update all, used mainly to eliminate the gray corners on assembly drawings.
You can optionally update the parent files recursively by enabling Update parent documents on the Options panel.
Updates mass, volume, etc. Models with no assigned density are reported in the log file.
You can optionally control the display of the physical properties symbols. They can either be shown, hidden, or left unchanged. To leave their display unchanged, disable both the Show and Hide options.
Occasionally, the physical properties are updated correctly, but the results are not carried over to the Variable Table. The error is detected and reported in the log file. One fix that often works is to open the file in SE, change the material, then change it back. To see if it worked, run Inspect > Physical Properties, then check for Mass in the Variable Table.
Copies the model size to the variable table.
This is primarily intended for standard cross-section material (barstock, channel, etc.), but can be used for any purpose. Exposes the variables so they can be used in a callout, parts list, or the like.
The size is determined using the built-in Solid Edge RangeBox. The range box is oriented along the XYZ axes. Misleading values will result for parts with an off axis orientation, such as a 3D tube.
The size can be reported as XYZ, or MinMidMax, or both. MinMidMax is independent of the part's orientation in the file. Set your preference on the Options panel. Set the desired variable names there, too.
Note that the values are non-associative copies. Any change to the model will require rerunning this command to update the variable table.
The command reports sheet metal size in the formed state. For a flat pattern, instead of creating new variables using this command, you can use the variables already created by the flat pattern command -- Flat_Pattern_Model_CutSizeX, Flat_Pattern_Model_CutSizeY, and Material Thickness. If you have an entry in the Material Table Gage Properties Tab Sheet Metal Gage combobox, you can use that instead of (or along with) Material Thickness.
Updates DesignForCost and saves the document.
An annoyance of this command is that it opens the DesignForCost Edgebar pane, but is not able to close it. The user must manually close the pane in an interactive Sheetmetal session. The state of the pane is system-wide, not per-document, so closing it is a one-time action.
Checks drawing views one by one, and updates them if needed.
Updates flat patterns. If the update was not successful, or no flat patterns were found, it is reported in the log file.
Before updating the flat pattern, this command first regenerates the flat model. That is the parent geometry of the flat pattern. If you have an automated model-to-laser pipeline, you may have noticed that sometimes an exported flat model contains no geometry. This is a fix for that situation.
Breaks external links to a file. This is irreversible, so you know, think about it.
The command options are explained below.
Break part copy design links and Break part copy construction links remove links created with the Part Copy command. The geometry remains intact.
Break Excel links removes Excel references from Variable and Dimension formulas. In both cases, the value remains as it was before the link was removed.
Break all interpart links is the sledgehammer option. It removes the links cited above. It also removes included links in profiles and pasted links in the variable table. It might do more. The complete API documentation (below) is, uh, short on details.
Break draft model links converts drawing views to 2D, removing external references in the process. In testing it quickly became apparent that this operation also converts Property text to blank lines in Callouts.
Luckily, Solid Edge can take care of that. That's in the program, but only for Callouts. If you have TextBoxes, Blocks, or other objects that use Property text, let me know. I can try to address those in a future release.
Searches for text in a specified property and replaces it if found.
The property, search text, and replacement text are entered on the Input Editor. To activate the editor click the Edit button in the options panel.
This is a powerful tool with a lot of options. These are detailed below.
Using the Input Editor
Before using this command, you must pre-populate property choices from your templates. To do so, on the Configuration Tab -- Templates Page, select your templates and click the Update button. There are a lot of properties. After the update is complete, the Customize dialog appears. Choose which to make available there. If you need a property that is not in your templates, right-click the Favorites pane and click Add property manually. To access properties not in your Favorites, enable the Show All Props option on the toolbar.
A Property set, either System or Custom, is required. The program will normally set the correct choice automatically. One exception is if you have a custom property with the same name as a system property. In that case, you have to select the appropriate one yourself. For more information about Property sets, see the Property Filter section in this README file.
There are five search modes, PT, WC, RX, EX, and X.
PTstands for 'Plain Text'. It is simple to use, but finds literal matches only.WCstands for 'Wild Card'. You use*,?[charlist], and[!charlist]according to the VBLikesyntax.RXstands for 'Regex'. It is a more comprehensive (and notoriously cryptic) method of matching text. Check the .NET Regex Guide for more information.EXstands for 'Expression'. It is discussed below.Xisn't really a search mode. It means delete the chosen property.
The properties are processed in the order in the table. To change the order, select a row and, on the toolbar Row Tools group, click the Up or Down arrow. The Delete button removes the selected row.
You can save a setup for future use. In the toolbar Saved Settings group, enter the name and click Save. To retrieve a setting, click the down arrow and select it. To remove a setting, select it and click Delete.
Case Sensitivity
The search is not case sensitive, the replacement is. For example, say the search is aluminum, the replacement is ALUMINUM, and the property value in a file is Aluminum 6061-T6. Then the new value would be ALUMINUM 6061-T6.
Property Substitution
In addition to plain text and pattern matching, you can also do property substitution. The example in the Input Editor above is telling the program to use the file name for the Document Number. To select a property, right-click the Find or Replace field and select Insert property. You can also type it in if preferred. The formula has the same syntax as the Callout command, except preceeded with System. or Custom. as shown in the example.
Options
If the specified property does not exist in the file, you can optionally add it by enabling Add any property not already in file. Note, this only works for Custom properties. Adding System properties is not allowed.
To delete a property, set the Find Search to X. As above, this only works for Custom properties.
If you are changing System.Material specifically, you can also update the properties associated with the material itself. Select the option For material, update density, face styles, etc..
Expressions
An expression is similar to a formula in Excel. Expressions enable more complex manipulations of the Replace string. To create one, click the Expression Editor button on the input editor form.
You can perform string processing, create logical expressions, do arithmetic, and, well, almost anything. The available functions are listed below. Like Excel, the expression must return a value. Nested functions are the norm for complex manipulations. Unlike Excel, multi-line text is allowed, which can make the code more readable.
You can check your expression using the Test button. If there are undefined variables, for example %{Custom.Engineer}, it prompts you for a value. You can Save or Save As your expression with the buttons provided. Retreive them with the Saved Expressions drop-down. That drop-down comes with a few examples. You can study those to get the hang of it. To learn more, click the Help button. That opens a web site with lots of useful information, and links to more.
Available functions
concat(), contains(), convert(), count(), countBy(), dateAdd(), dateTime(), dateTimeAsEpoch(), dateTimeAsEpochMs(), dictionary(),distinct(), endsWith(), extend(), first(), firstOrDefault(), format(), getProperties(), getProperty(), humanize(), if(), in(), indexOf(), isGuid(), isInfinite(), isNaN(), isNull(), isNullOrEmpty(), isNullOrWhiteSpace(), isSet(), itemAtIndex(), jObject(), join(), jPath(), last(), lastIndexOf(), lastOrDefault(), length(), list(), listOf(), max(), maxValue(), min(), minValue(), nullCoalesce(), orderBy(), padLeft(), parse(), parseInt(), regexGroup(), regexIsMatch(), replace(), retrieve, reverse(), sanitize(), select(), selectDistinct(), setProperties(), skip(), Sort(), Split(), startsWith(), store(), substring(), sum(), switch(), take(), throw(), timeSpan(), toDateTime(), toLower(), toString(), toUpper(), try(), tryParse(), typeOf(), where()
Edit Outside Solid Edge (Experimental)
Direct edit using Windows Structured Storage for fast execution. Like blazingly fast -- 100x to 400x faster than Solid Edge. If you want to try this out, select the option Edit properties outside Solid Edge.
There are certain items Solid Edge presents as properties, but do not actually reside in a Structured Storage Property Stream. As such, they are not accessible using this technique. There are quite a few of these, mostly related to materials, for example density, fill style, etc. The only two that Housekeeper (but not Structured Storage) currently supports are System.Material and System.Sheet Metal Gage.
Also, Structured Storage does not know about file links. That means it cannot access models from their drawings. Property callouts that require such access, for example %{System.Material|R1}, generate an error with this option.
Adds, changes, and/or exposes variables.
The information is entered on the Input Editor. Access the form using the Edit button.
The Variable name is required. There are restrictions on the name. It cannot start with a number. It can only contain letters and numbers and the underscore _ character.
If a variable on the list is not in the file, it can optionally be added. Set the behavior on the Options panel.
The number/formula is not required if only exposing an existing variable, otherwise it is. If a formula references a variable not in the file, the program will report an error.
If exposing a variable, the Expose name defaults to the variable name. You can optionally change it. The Expose name does not have restrictions like the variable name.
The variables are processed in the order in the table. To change the order, select a row and, on the toolbar Row Tools group, click the Up or Down arrow. The Delete button removes the selected row.
You can save a setup for future use. In the toolbar Saved Settings group, enter the name and click Save. To retrieve a setting, click the down arrow and select it. To remove a setting, select it and click Delete.
Brings up files one at a time for manual processing.
A dialog box lets you tell Housekeeper when you are done. You can save the file or not, or choose to abort. Aborting stops processing and returns you to the Housekeeper main form.
You choose the dialog's starting position. X and Y are the number of pixels from the left and top of the screen, respectively. If you move the dialog, it remembers the location for subsequent files. It doesn't remember between runs, unfortunately. That turns out to be surprisingly complicated. As a workaround, a change in position is reported on the form. Once processing is complete, you can enter the reported values in the command options. Those numbers are remembered between runs.
You can optionally set a countdown timer and/or start a command.
Countdown Timer
The countdown timer lets you run hands-free. This can be handy for doing a quick inspection of a batch of files, for example. If something catches your eye, you can pause the timer. There is an option, Save file after timeout, that tells Housekeeper how to proceed if the timer runs to completion.
Start Command
The Start command option launches a command when the file opens. This can help keep you on track when you have a small chore to complete on a bunch of files. For example:
- Enable the
Update file on saveoption on thePhysical Propertiesdialog. - Cycle through assembly
display configurationsto make sure they are all set correctly.
The dropdown list contains commands that we thought might be useful. The first entry on the list, Manual entry is a special case. It instructs the program to execute the Command ID entered in the textboxes below the dropdown. If you don't want a command to start for a given file type, enter 0 in the textbox.
You can customize the list. Instructions to do so are in the file interactive_edit_commands.txt in the Housekeeper Preferences directory. It also shows how to find commands and their corresponding ID numbers. Hundreds of commands are available. It's worth checking out. Note, the file is created the first time you run Housekeeper. It won't be there prior to that.
Rules for Interactive Editing
Some rules for this command apply. It is important to leave Solid Edge in the state you found it when the file was opened. For example, if you open another file, such as a drawing, you need to close it. If you add or modify a feature, you need to click Finish. If you used the Start command option, you need to close any dialog opened in the process.
Also, do not Close or Save As the file being processed. Housekeeper maintains a reference to the file. Those two commands cause the reference to be lost, resulting in an error.
One last thing. Macros interact with Solid Edge through something called the Windows Component Object Model. That framework appears to have some sort of built-in inactivity detection. If you let this command sit idle for a period of time, COM reports an error. It doesn't really hurt anything, but Housekeeper stops and restarts SE any time a COM error occurs. I get around it by selecting only a small number of files to work on at a time.
Finds cylindrical cutouts in an imported model and converts them into hole features. For the command to work correctly, the model must be in a freshly-imported state, with no subsequent modifications performed in Solid Edge.
As the first step of the conversion process, the Optimize command is run on the imported geometry. While not strictly necessary, it is considered good practice for any imported file.
The conversion is only possible in Synchronous mode. Ordered files are switched to Sync before the conversion, then switched back. Note, the imported body and the new hole features remain in Sync after the transition.
Updates the styles you select from a template you specify.
Using the checkboxes provided, you can update all styles, or select which ones to update individually.
Styles present in the template, but not in the file, are added. Styles present in the file, but not in the template, can optionally be removed, if possible. Set the option Remove styles not in template as needed. It is not possible to remove a style if Solid Edge thinks it is in use (even if it isn't).
Styles are updated/added as described, but no mapping takes place. For example, if the template has a dimension style ANSI(in), and the file instead uses ANSI(inch), the dimensions will not be updated. A workaround is to create the target style in the template and modify it in that file as needed.
The active view style of the file is changed to match the one active in the template. Note, it must be a named style. Overrides are ignored. To create a named style from an override, open the template in Solid Edge, activate the View Overrides dialog, and click Save As.
Updates styles and/or background sheets from a template you specify.
These styles are processed: DimensionStyles, DrawingViewStyles, LinearStyles, TableStyles, TextCharStyles, TextStyles. These are not: FillStyles, HatchPatternStyles, SmartFrame2dStyles. The latter group encountered errors with the current implementation. The errors were not thoroughly investigated, however. If you need one or more of those styles updated, please ask on the Forum.
Face style overrides change a part's appearance in the assembly. This command causes the part to appear the same in the part file and the assembly.
Hides all non-model elements such as reference planes, PMI dimensions, etc.
Maximizes the window, sets the view orientation for model files, and does a fit.
Select the desired orientation on the Options panel. The setting is required, but is ignored for draft files.
Runs an interference check. All parts are checked against all others.
This can take a long time on large assemblies, so there is a limit to the number of parts to check. Set it on the Options panel.
Checks linked files.
Missing links are files not found on disk. Misplaced links are files not contained in the search directories specified on the Home Tab. Only links directly contained in the file are checked. Links to links are not.
Checks if the file has any failed, underconstrained, or suppressed relationships.
Checks for the existence of a flat pattern. If one is found, checks if it is up to date.
Checks if the material in the file exists in the material table.
The material table is chosen on the Options panel. This command only checks the name. To check/update its properties (density, face style, etc.), run the Update material from material table command.
Assumes drawing has the same name as the model, and is in the same directory
Checks if the file name contains the part number.
Enter the property name that holds part number on the Options panel. A Property set, either System or Custom, is required. For more information, see the Property Filter section in this README file.
The command only checks that the part number appears somewhere in the file name. If the part number is, say, 7481-12104 and the file name is 7481-12104 Motor Mount.par, you will get a match.
If the file has any Part Copies, checks if they are up to date.
Checks is there are any parts list in the drawing and if they are all up to date.
Checks draft files for various problems.
The options are:
Drawing views out of date: Checks if any drawing views are not up to date.Detached dimensions or annotations: Checks that dimensions, balloons, callouts, etc. are attached to geometry in the drawing.Drawing view on background sheet: Checks background sheets for the presence of drawing views.
Runs an *.exe or *.vbs or *.ps1 file.
Select the program with the Browse button on the Options panel.
If you are writing your own program, be aware several interoperability rules apply. See HousekeeperExternalPrograms for details and examples.
Exports the file to either a non-Solid Edge format, or the same format in a different directory.
Select the file type using the combobox. Select the directory using the Browse button, or check the Original Directory checkbox.
You can optionally create subdirectories using a formula similar to the Property Text Callout. Enable the Use subdirectory formula option to do so. To add a property, right-click the text box and select Insert property. You can also just type it in if that's easier. You can create nested subdirectories if desired. Simply add \ in the formula. Here are two examples.
Project %{System.Project Name}%{System.Material}\%{System.Sheet Metal Gage}
As illustrated in the examples, a Property set, either System or Custom, is required. For more information, refer to the Property Filter section in this Readme file.
It is possible that a property contains a character that cannot be used in a file name. If that happens, a replacement is read from filename_charmap.txt in the Preferences directory in the Housekeeper root folder. You can/should edit it to change the replacement characters to your preference. The file is created the first time you run Housekeeper. For details, see the header comments in that file.
Sheetmetal files have two additional options -- DXF Flat (*.dxf) and PDF Drawing (*.pdf). The DXF Flat option saves the flat pattern of the sheet metal file.
The PDF Drawing option saves the drawing of the sheet metal file. The drawing must have the same name as the model, and be in the same directory. A more flexible option may be to use Save Drawing As command, using a Property Filter if needed.
For image file formats there are additional options. You can hide constructions and/or fit the view. For Fit, choose an orientation, either Isometric, Dimetric, or Trimetric. You can also crop images to the aspect ratio of the model, rather than the window. The option is called Crop image to model size. On tall skinny parts cropping works a little too well. You might need to expand the margins a bit in Photoshop for those. Finally, you can change the view style by selecting that option and entering its name in the textbox provided.
Exports the file to either a non-Solid Edge format, or the same format in a different directory.
Select the file type using the combobox. Select the directory using the Browse button, or enable the Original Directory option.
You can optionally create subdirectories using a formula similar to the Property Text Callout. See the Save model as help topic for details.
Unlike with model files, draft subdirectory formulas can include an Index Reference designator (eg, |R1). This is the way to refer to a model contained in the draft file, similar to Property Text in a Callout. For example, %{System.Material|R1}. To refer to properties of the draft file itself, do not specify a designator, for example, %{Custom.Last Revision Date}.
You can optionally include a watermark image on the drawing output file. For the watermark, set X/W and Y/H to position the image, and Scale to change its size. The X/W and Y/H values are fractions of the sheet's width and height, respectively. So, (0,0) means lower left, (0.5,0.5) means centered, etc. Note some file formats may not support bitmap output.
When creating PDF files, there are two options, PDF and PDF per Sheet. The first saves all sheets to one file. The second saves each sheet to a separate file, using the format <Filename>-<Sheetname>.pdf. You can optionally suppress the Sheetname suffix on files with only one sheet. The option is called Suppress sheet suffix on 1-page drawings. To save sheets to separate dxf or dwg files, set the Save As Options in Solid Edge for those file types before running this command.
Creates a drawing of a flat pattern using the template you specify. If the file does not contain a flat pattern, the command reports an error. It does not check if the flat pattern is up to date. For that, run the Check flat pattern and/or Update flat pattern commands before running this one.
The command attempts to place the flat pattern centered on the sheet. It rotates it if needed to match the available space. It scales it to entirely fill the sheet in one direction. That's not the scale you ultimately want, but is the starting point for the Scale factor. With that you control the final size. If you want it to take up 90% of the available space, enter 0.9. For half size, enter 0.5, etc. X and Y offset will offset the drawing by the specified values from center, +Y will offset up, -Y will offset down. +X will offset right, -X will offset left.
You can save the drawing as a *.dft or *.pdf or both. If a file with the same name already exists, the Overwrite existing checkbox tells the program how to proceed. You can save the drawing to the original directory, or choose another one. Each file type can be saved to a different directory.
Prints drawings.
The dropdown should list all installed printers.
If you use more than one printer, use the Edit task list function on the Task Tab to add one or more Print tasks. Set up each by selecting the printer/plotter, sheet sizes, and other options as desired.
You assign sheet sizes to a printer with the Select Sheets button. Print jobs are routed on a per-sheet basis. So if a drawing has some sheets that need a printer and others that need a plotter, it will do what you expect.
This command may not work with PDF printers. Try the Save As PDF command instead.
The program is not perfect
- Cause: The programmer is not perfect.
- Possible workaround: Back up any files before using it. The program can process a large number of files in a short amount of time. It can do damage at the same rate. It has been tested on thousands of our files, but none of yours. So, you know, back up any files before using it.
Does not support managed files
- Cause: Unknown.
- Possible workaround: Process the files in an unmanaged workspace.
- Update 10/10/2021 Some users have reported success with BiDM managed files.
- Update 1/25/2022 One user has reported success with Teamcenter 'cached' files.
Some tasks cannot run on older Solid Edge versions
- Cause: Probably an API call not available in previous versions.
- Possible workaround: Use the latest version, or avoid use of the task causing problems.
May not support multiple installed Solid Edge versions
- Cause: Unknown.
- Possible workaround: Use the version that was 'silently' installed.
Pathfinder sometimes blank during Interactive Edit
- Cause: Unknown.
- Possible workaround: Refresh the screen by minimizing and maximizing the Solid Edge window.
This project uses these awesome open source packages.
- Solid Edge Community SolidEdgeCommunity
- JSON Converter Newtonsoft.Json
- Excel reader ExcelDataReader
- Expression engine PanoramicData.NCalcExtensions
- Expression editor FastColoredTextBox
- Structured storage editor OpenMCDF
- Time zone converter TimeZoneConverter
Processing starts in Form_Main.vb. A short description of the code's organization can be found there.