Creating a class for the new function using an existing class

1. Open the class editor, then select the desired path.
   
2. Open any of the functions in the same subfolder that you want your function to be in.
3. Copy the name of the “Method Key”, then search for the files in your porject directory using notepad ++ or a similar tool, using the file extension .ini. This will locate the folder in your project directory that the class should be placed in.
   
4. There are 3 files which you need to place information into to create the class. These are class.ini, methods.ini and speckey.ini (speckey.ini is only needed if your function requires you to get data from a database file).
5. Create your new class by right clicking on the parent class and selecting “insert new component”.
6. Enter a name and description. The name is the function that will be called from
   AutoCAD, it should have no spaces and be all upper case letters. The
   description is what will appear in the class editor, this name can include
   spaces and doesn’t need to be uppercase. For example my name is TEST_FUNCTION, and the description is “This is a test function”.
   
7. Clicking  Ok will open your new class with default parameters associated with the parent. We need to change the Methods and the Speckey. To modify the methods click on the button ‘…’ to the right of it.
8. This will open the method’s dialog box, click on the ‘new key’ button on the right side of the dialog box. The name asked for by the new window will follow the same rules as the name in step 6.
9. Copy the same method key as the existing class you are basing your function off of. The functions called will stay the same as the ones in the method key you copied, they can only be changed from the methods.ini file.
   
10. Repeat steps 7-9 for the speckey, the speckey name and the methods name can be the same. Like the methods the speckey can only be edited from its speckey.ini file. When done click the save button in the Class Editor.
11. Open the class.ini file, new classes appear at the bottom of the file. Once you have found your class you can change the description, the method or speckey it uses and the picture that will be seen in the class editor. If no picture is desired
    then this line can be removed.
    
12. Open the methods.ini file, the new methods appear at the bottom of the file. In your method you can change the file location and function name of the sub-method, such as the DRAW_METHOD. Change the desired sub method file location and function so that it looks like %APP_DIR%\file_folder\file_name ; FUNCTION_NAME
    
13. Open the speckey.ini file. The DISPLAY_FIELDS indicate which fields from the
    database file are displayed when the function is run, the fields are shown in
    the order they are written, the data will then be sorted alphabetically starting with the left most column. SPECKEY_SCRIPT should be left alone. The SPEC_TABLE indicates which table from your database file information will be used from. The WHERE_CLAUSE filters the data from the selected table, this section works in the same way as an if statement. Only rows that satisfies the clause will be displayed.
    

Adding a function to AutoCAD Menus, Tool Paletts, Tool Bars and Ribbons

1. In AutoCAD open Tools->Customize->Interface.
2. Under the Command List select any command and choose duplicate under the right click menu.
3. Select the duplicated command (it will have the larger Element ID #), then change the command name to one that describes the function (this will be what appears in
   the menus and tool palettes. It will appear as a description in the ribbons and toolbars).
4. Change the macro so that it is ^C^C(at_Component_insert “AT_CABLET” “CLASS_NAME”),the first “” is dependant on which folder in the class editor you placed your class in. The second “” must be the name of the class that uses your function.
5. Select a button image, this is what will appear in the tool palette and ribbon, if
   there is no premade image in the list that fits your function create one using
   the edit button.

   Note : any changes made to the command name, description or picture will not automatically update. The command must be replaced in all menus, tool palettes and ribbons.

Menus

1. Under the “Customizations in Main File” select at_elect.cuix in the dropdown menu. This will allow changing menu items under “Raceways”.
2. Open menus->raceways, then either create a new sub menu under raceways or open more sub menus to reach a desired location.
3. Select your command from the Command List, then click and drag the command to the desired location.

Tool Palettes

1. Open the desired tool palette, if it doesn’t exist create it using the customize
   palettes (from right clicking on the tool palette), right click the palettes
   box and select new palette. Name the palette to describe the tool set
2. Now open the customize user interface window
3. Select your command from the command list and drag it onto the tool palette

Ribbons

1. Under the “Customizations in Main File” select at_elect.cuix in the dropdown menu.
2. Open Ribbons->Tabs->Raceways, right click on raceways and select new tab. The tab name is what will appear on the ribbon
3. Open Ribbons->Panels, right click on panels and select new panel. Name it the same as the tab you just created

Building the Ribbon Panel

• Ribbons are based on 3 elements, rows, sub-panels and the ‘slideout’
• Rows
  • Functions placed in a row will appear left to right evenly spaced, with their order base on their position in the dialog top to bottom

• Multiple rows on the same level will make columns

• Sub-Panels
  • Sub-panels allow rows to be divided into multiple rows

• SlideOut
  • Anything below the slidout will appear only when you place your mouse over the slideout, must be on new row that is beneath the slide out

• All functions are added to ribbons by clicking and dragging into place

Tool Bars

• works using the same principals of the ribbons, except that you can only use a single row and there is no slideout
• create a new tool bar by opening the customize user inter face, going to at_elect.cuix. Open the Tool bars folder then right click on it and select new tool bar.
• to place commands on your tool bar click and drag them to the desired location. adding “Flyouts” to the toolbar will create a dropdown similar to the ribbon slideOut when selected. Adding a flyout will also create a separate toolbar that is identical to what is in the flyout

Sucking Access files into SQL Server… Setup steps:

• http://www.sqlservercentral.com/Forums/Topic1148079-359-1.aspx#bm1149810

Now I am getting the error: The database owner SID recorded in the master database differs from the database owner SID recorded in database ‘proSteelMtoPartsList’. You should correct this situation by resetting the owner of database ‘proSteelMtoPartsList’ using the ALTER AUTHORIZATION statement.

It COULD be the user- but look around first on your database properties (right mouse click). I followed these links and REALLY messed things up but with some quicky DROP and CREATE TO scripts, I had another one going in no time. DO NOT do the steps in these links unless they WILL help, but they help with understanding and figuring out current settings. I did NOT restore from a backup – so that is why I should NOT have followed the steps. Never set the owner to sa either unless you have access to that account AND you have taken your account off of the dbo member list.

• http://kevine323.blogspot.ca/2011/03/database-owner-sid-recorded-in-master.html
  

This person has some GREAT explanations:

• http://mssqlstuff.blogspot.ca/2012/01/solution-for-error-database-owner-sid.html
• https://www.simple-talk.com/blogs/2010/06/05/database-owner-conundrum/

What it turned out to be is a couple of things – like the trustworthy – should have been run and to NOT use the statement in the stored procedure – however, this DID fix a problem on another database

• execute as user=’DOMAIN\my.username’ – which I used for

Git for dummies. There is no such book, however, here is a quick guide once you know what is going on. Here is another SUPER link and he deserves some sort of peace prize.

Another link is a dummy like resource for newcomers to your team. I have used Git for about a year, but it was only for one or two of us. Now that there is a whole team, we needed a little more knowledge and rather than teach everyone one by one, I thought I would make this post. If you have used SVN, git is a little more intense.

An online book is here. Bare vs. non bare git repository is important to know – check here.