Category Archives: General

Relocate WordPress website or folder – straightforward text edits will not do it – tools are required

Posted on by

I found a great article and tool to get started, but it took many attempts to finally move or relocate WordPress website or folder from http://elbsolutions.com/chadtest to the almost final position of http://smartcar.websitewelcome.com/~wccogca . Since it was quite frustrating, I thought I would blog about it for other people who can benefit. Steps were:

  1. get temp website running moved over to final home (from http://www.elbsolutions.com/chadtest to http://smartcar.websitewelcome.com/~wccogca its temporary home before DNS change over)
  2. switch website completely to another (DNS change) and
  3. finalize the website at it’s new home in proper place (proper www address).  but the address will be http://www.wccog.ca – but the files in 2. are in the correct spot already.

With these ideas, I hope you can move your site over as well. Read the comments in the article by Rachel below – I think there are some even easier tools, but this one has some plugins and a theme that made this a bit of a pain.

If there is a typo, please comment so others can benefit from the corrections. It takes a second 🙂 Good luck.

So, first Continue reading →

Adding jQuery to Report Services – (Make parameter field bigger is the reason for doing this in this article)

Posted on by

There are really 2 concepts here which is the reason for the long title. First, adding jQuery to Report Services means hacking 2 install files (.aspx files) of Report Services. If you don’t have someone who has access to the server that is hosting the web pages, it might be hard to get this done. Your IT department might say ‘no way’ but this problem is well known for RS 2008 up to the current – so it is really not a risk – if it breaks, simply fix it – most likely it will never need fixing especially if you are using an older version of RS which is by this point mature. Next to address the width – this article helped. Here is how I did it and who helped me (urls in the code and the links above)… Continue reading →

Getting info from MS Access

Posted on by

This is a note to keep myself clear on what technology is preferred and when to use it. I understand why programmers use explitives and the F-bomb- MS makes things SOOOO complicated (uninstall and reinstall the 2010 distributable – no matter how ‘installed’ you think it is 🙂 ). Basically Microsoft Access has flip flopped on whether or not ADO or DAO is the preferred choice – here is a history article for interest sake. I used this article to make my choice and they mention lots of other options and details that are good to know. The project is to get MS Access records into AutoCAD tables. It is important to note that ADO and ADO.net are not the same- except the 3 letters. ACEDAO is the latest ADO and DAO is preferred after MS Access 2007 and is re-written from this version onwards. What references to set? I had troubles because my Excel test envuronmnent gave error 429: could not created an active x component. Here is what references worked Continue reading →

Working with the Bentley Project Database and its effect on Update from spec

Posted on by

Adding new fields to the database

Adding new fields to the database is useful in cases were you more information about a component, but there is no corrosponding field in the database to the one in the specs.

If you know where your database is you can skip the first 3 steps> To create a new field in the database:

  1. Open the “Bentley Project Administrator”. Continue reading →

How Bentley AutoPLANT integrates a new class, methods and speckey WITHOUT editing the core program files

Posted on by

Lets assume that a new spec was created. AutoPLANT has a very clever structure to its files so that the core ones that come with AutoPLANT need not be touched. It also helps when new specs, ebs, classes etc. are added (specs beyond just adding or changing dB rows). This article outlines how to integrate a new component where a new class was created. There is already an article which outlines how to create a ‘new spec’ (a complete one which includes class/ini sections, ebs files and mdb rows) to do this AND there is an article that outlines how that last article was figured out, so that you too can do find out more complicated classes like joints etc. for yourself.

Lets assume that you have all your files / edits ready to go. A pseudo and realistic example is at the bottom. Continue reading →

How to do an-SQL join AND get the latest date without a sub-select

Posted on by

Here is some discussion on a one to many join that needs the many side to return ONE row – the latest one. Also in this article are many links to the related items. It took about an hour to find solutions without a sub-select. Sub-selects are VERY popular – could this be because they are easier to understand and more logical? Many articles still claim that sub-selects are slower especially when there is no correlating field between the sub-select and the outer select statement.

http://stackoverflow.com/questions/2111384/sql-join-selecting-the-last-records-in-a-one-to-many-relationship

VBA for AutoCAD: getting a command line filename or a dialog window filename

Posted on by

The following code prompts for a full path or press E to invoke a dialog window typical to Microsoft to choose a “Save As” style windows path. Eventually an Excel file path that is fully valid and vetted will result.

Here are 2 basic ideas wrapped within eachother

a) Outer: Is there a valid filename (valid string) or did the user cancel (False),
b) Inner: Go get the filename via command line or optional dialog window – this might give garbage- hence, the above line has “valid”
Note we can ONLY do this because you already using the Excel libraries as you are writing an Excel file with this path. There is equiv. commands without this cheat.

You want to make your code contain TestVettedExcelName style code – then you can use the Functions with no issues.

[vb]

Sub TestVettedExcelName()
Dim name As Variant

name = GetVettedExcelName
<!–more–>
If name = False Then
‘ something went wrong
MsgBox (“No file selected or path is not valid”)
Else
MsgBox (“the name is: ” & name & “and is a valid string”)
End If

End Sub
[/vb]

Continue reading →