I needn’t say more. Here is the link. In specific – this part of the conversation allowed me to keep changes that were NOT part of the other guy’s work AND force his stuff on top of mine. I was fiddling (to keep him working), he was working on the real stuff. HOWEVER, I had a problem pushing – so this link helped with that part. Put them together and here is the final set of commands in my context on my branch … Continue reading →

I don’t want to upload one record at a time, I want to do them all – so that is like a transaction. It either works or it doesn’t. Here is a genius who has lego’ed a few interesting things together. He uses a webviewer and ajax to communicate files through the temp directory. These might be the droids I was looking for. My question is, can I preemptively put a file in the temp directory and trigger Ajax to upload it somewhere? Here? I will post any updates here… see you soon.

Windows of course … cd to the directory and type

[bash]

git config core.longpaths true

[/bash]

Now you can add AngularJS apps with their >12000 file node dependancies

OK – first, it is because all these great tools are assuming the root url is /. They all give part of the picture, but they don’t know the whole story. Neither do did I. But do I google root uri, base url, AHHHH! Anyways, lets document this so I don’t and you don’t have to go nuts and google for hours like I did.

First – I am using ServiceStackVS 4.x, and it is an angular (not MVC – that might be a mistake) app.  I want

• myweb.com/myApplication/myServices for the services and
• myweb.com/myApplication for the application.

So for ServiceStack (I installed the extension ServiceStackVS into Visual Studio 2013) …

• – change the web.config line from a “*” to “myApplication/myServices*” in the lines that look like:

Continue reading →

Ok, so I am going crazy. A prototype project works, then it doesn’t work, and apparently I clicked a button in the project properties called “Create Virtual Directory”. Don’t click that (you edit a file to mess with IIS Express to undo it). Now that things are working – I still want to fiddle til it is just right, but since I don’t know what is changing underneath. Well lets get Git involved so we can store our files and see what file changes affect what. But … what to upload!? If we include a gitignore in the first place, we can reduce the uploaded files a lot. But what to include? This article led me to a few options. There is an online generator but I chose the VS2013 recommendations from Microsoft’s site. I also added node_modules/ as if you need the node modules, it should be as easy as going to that directory and typing npm install

So I am using service stack with node quite successfully – but now I have to make some services. Why not use ServiceStack since its reputation and ease of use (in node anyways) is super easy. Lets get going recording the steps I took – cause I likely won’t remember it otherwise.

• make a new project (I chose blank)
• add service stack to your project  OR … get the template (so skip this step) and it will be added automatically
• install the ServiceStackVS templates and make your 1st project
  • I ensured that NuGet was up to date
  • I installed the 2013 Shell (Isolated) update as well which is a prerequisite
• I made my first app with it as per the demos at the bottom.
• I added to the main app – Swagger UI – which allows easy testing and documentation for the services. All I had to do was search for “Configure(” and add the code the recommend, add a using…. statement (as per the intellisense when it did not compile – yes I am very lazy/efficient)
• Bingo – up and running. Lets get to work (and it does)

Continue reading →

The first plug in I am to design in VSTO (not VBA is what that means) is to have the user mark up a document with bookmarks – a set of bookmarks that leads you along. The bookmarks are to be named in a very specific format. The tool will force the user to use the “select first” type bookmark. You can toggle the viewing of bookmarks as well.

How to Create Add-Ins Using VSTO in MS-Word – this gets one started.It is VS2010 and I am using VS 2013 – but it gives a really good view of adding a ribbon item, using forms and making it all work. Ok – I tried it – this is like trying to kill a mosquito with a elephant gun – but that is what corporate wants. Every time you click “run” it starts a new version of Word. This means that you have to load the document of interest every time. In VBA – you “run” from the context you are already in <- RIGHT THERE IS THE CRUX of my axe griding as well as VBA on the fly debugging on ANYONE”S MACHINE. Alas…

Continue reading →

First, get a design. Now I had a design in my last article, but I have not vetted it with any standards. I think I have little or no room to physically walk around on the roof, which you need – so I might need to augment my design to 2 less panels etc. You have to have all your equipment known and their certifications checked for your area – so you need to have your money on the table so to speak if you are going to do this. I am not quite there yet, but if I was… keep reading.

But, here are some links if you live in Calgary, AB, Canada. My WSP (wire service provider) is ENMAX and here is their Residential Renewable Generator Checklist. In that checklist are other sources for the organizations that govern all this for safety and orderly conduct (in my case the Alberta Utilities Commission micro-generator application guideline.

Active X and VBA (from Excel from example) are SOOOOO cheap to design and debug, but on a more corporate level, VBA is shunned by IT as “impossible to manage” … and, it can be but I am using git to manage everything and it works fine. Agreed though, all the cool people are using .NET so I will too. Here is a custom list of my own resources I used to re-aquaint myself. I did this once before and noticed that it would cost the customer much more to do .NET and they advised me that VBA would be just fine. Alas … I get paid to do what I am told. I will be using c# (the only thing cooler would be node … but that is there too:-)) Continue reading →

Here are some links for ripping Word Docs apart and storing bits here and there in a sql database to be later retrieved and re-glued.

• c# – How to store formatted snippets of Microsoft Word documents in sql server – Stack Overflow
• How to Store, Read & Delete a Word Document in Database Using .NET code snippet and examples
• Frespire .net tools that might make this easier
• One thing I think that is key is inline metadata (data attached to an Heading 2 or Heading 3 etc.)
  • This helps mark up docs TO BE RIPPED APART. Once ripped apart, the data will be stored, later to be cobbled together
  • One way to get these inline meta-data keys injected is to use citekeys. Here is a practical how-to in word.

Some similar systems

• Phrase Express
• Pandoc – an open source project to convert one format to another (usually a quite normal->geek level)
• c# code for finding start and end placeholders in word