- Help's Find command button tool
- Command preview
- Lasso selection
I've used the Notepad++ application to edit before, usually HTML. But, now, I'm using it to edit Archibus views.
When chatting with my friend, James Castruccio, he mentioned I should be able to tweak a setting in Notepad++ that would automatically apply the XML formatting to the AXVW files when I opened them, rather than manually selecting it from the Language menu every time.
I poked around a little and couldn't see an obvious setting, so, I did what any self-respecting cad geek would do, and posted a question on the AUGI Forums.
Richard Lawrence provided the solution I used.
Under the Settings menu, click the Style Configurator
One of our lease specialists asked me to add a comments field to our Taxes and Insurance form (aka task) in Archibus, which would allow space for notes on some of the more obscure situations they run across. In addition to wanting to display all of the text at once, the notes field will serve as a visual break between the current and historic data being displayed.
From the Archibus Help File:
colspan – When the field is presented in a form containing multiple columns of label – value pairs, this attribute allows a field to cover more than one column.
Valid Values: a ‘small’ number between one (the default) and the number of columns used as the panel attribute.
Since this panel is formatted to have two columns, I set the colspan control to 2.
Editing the .axvw file, I modify the entry for the applicable field.
" <field name="cmts_cam" table="operating_expense" colspan="2" /> "
Also note that each field is paired up with another (either another data field or a placeholder), so I had to remember to remove the second line in this pair, so that the pairs below it in the form were not shifted.
The first change basically did the job, but, I wanted a bit more control over the appearance of the textbox, so I decided to use the style control and input the size in pixels. It did take a couple of tries to get it to line up just how I wanted, but, once you’ve got those numbers handy, you’re gravy for the next time you edit that form, or another using the same panel with the same attributes.
(I am sure there are apps out there that will allow you to measure screen pixels to find the number faster, if I run across one, I will post about it.)
" <field name="cmts_cam" table="operating_expense" colspan="2" style="height:40px; width:743px;"/> "
Remember, you still need to keep the colspan set to 2, otherwise, the style width will push the whole first column wider.
And with that final tweak, the view receives the users’ seal of approval, which means my first of many .axvw edits is completed!
My next big task at work is adding our hundreds of branch locations to the Work Order & Preventative Maintenance (CMMS) system in Archibus.
Our consultant has a portal where we log in to the system, so, the first step is supplying them with a list of usernames and email addresses to import. The data I have available does not list this information together, so I needed a quick and easy way to produce it.
Concatenating a name to create an email address
While I could just copy the name column and do a find and replace to append the domain, I like concatenating, because it’s so quick and easy.
Just type an equal sign, the first cell name, an ampersand and then the second cell name.
Since I want to drag and copy this down the entire column, I still want to point the latter half of the equation to the top cell. I type a dollar sign in front of the cell number, so it will not increment to match the row number (if I were copying this formula to different columns, I would put a $ in front of both the column and the row, like “$F$1”).
If I were joining other data, such as the city and state fields, I would want to add additional formatting like a comma and a space. All I have to do is place some more &’s and surround the addition with a pair of quote marks.
The above is a shorter way of using the =CONCATENATE function.
MS Excel has an Autofill feature, so, start typing the word, and when it shows up at the prompt, hit Tab to insert the whole command into your cell.
Then proceed as you normally would when typing an expression in, using parentheses to surround the data and commas to separate the components you wish to include.