Wednesday, May 9, 2018

SQL Server Management Studio: Cannot find one or more components. Please re-install the application

I un-installed VS Studio 2010 dues to storage capacity issues, after I had un-installed I could not longer use SQL Server Management Studio, the database was running fine, but I could not open SSMS. I ran the repair on the SQL Server but that did not fix the issue. I installed and repaired the suggested dependency on VS 2010 Shell (Isolated), but that still had not affect.
I decided to go down the risky road and delete the registry key. There were suggestions of deleting 13, but I only had 11 and 12. So I renamed it first 11_Delete, no change, then 12_Delete and that was the problem. Once I restarted SSMS it created the folder 12_Config again and then I deleted the folder I had renamed.
Computer\HKEY_CURRENT_USER\Software\Microsoft\SQL Server Management Studio\12.0_Config

Wednesday, March 28, 2018

Arcgis REST API Append Data to Feature Layer

I needed to append data to an existing Hosted Feature Layer with multiple layers. I found that I was able to append the data by submitting a JSON request, but the data I was adding never showed up on the map. I found a few suggestions such as doing a refresh via javascript on the layer or turning off synchronization which I did. It turns out is was an issue with the data I was submitting.
I added the data at first using the addFeatures and then I tried the applyEdits...both worked fine. I could see the data in the Data tab online but not in the map.
The request looked like this:
[{
'attributes' : {
'fieldName1' : 'junk data',
'latitude': 89.1000,
'longitude' : -119.333
}
}]
For some reason, I thought that the Lat/Long included in the attributes was how the original data was being mapped, so in reading the instructions, I ignored the Geometry part of the request, which ended up being my problem. I had to submit the request like this:
[{
'geometry' : {'x' : -119.333, 'y' : 89.1000},
'attributes' : {
'fieldName1' : 'junk data',
'latitude': 89.1000,
'longitude' : -119.333
}
}]
Mind your {} and [] and ,,,, and data types and you should be good :)

Tuesday, March 27, 2018

Eclipse XDebug Stuck at 78%

This error seems to happen out of no where. It usually happens when I move to a new PC or something. A lot of times it is the config settings for XDebug buried in the php.ini file. Of the many issues that can cause this error, I did find one simple solution that was causing my problem when I recently moved to a laptop: The difference? C drive vs D drive. This caused all sort of issue because I had to change the drive letter to get the entire PHP/APACHE/Eclipse/MySQL thing going but I also found that inside Eclipse I was pointing the External Browser for debug to D:\Program Files\Mozilla Firefox\firefox.exe.
To check your settings, go to Window - Preferences - General - Web Browser, click the browser type and then click Edit. Verify this path is correct.

Thursday, February 22, 2018

Visual Studio 2015 Errors Opening Report Project

I had a previously working copy of a report project that opened fine in VS2012. A person on the team upgraded the project to VS2015 which began causing me trouble opening the project. It would say some of the projects were incompatible or that the project could not be loaded. It gave me the option to upgrade, which I tired and it failed.
I did several things.
At first I thought I did not have SSDT 2015 installed so I installed that, uninstalled that, ran a repair on VS2015, which resolves the project incompatible error on a couple of the projects but I still could not load the Report Project. I un-installed and re-installed different version of SSDT 2015.
I learned VS2015 comes with the SQL Server Data tools and I needed to update this item called "SQL Tooling" but it was hard to understand because nothing in Tool -> Extensions and Updates read precisely "SQL Tooling", I just ran anything that said it needed to be update and when the update ran it was labeled "...Tooling...". So that was confusing. I think the one I updated was Microsoft ASP.net and Web Tools or maybe Microsoft .NET Core Tools. After trying so many things to resolve the problem, you never know, you just know you got it working finally.
After doing all that, I reloaded the project again and continued to have the error: "... rptproj: error: There is an error in XML document (2, 2)."
I found a recommendation that said: Try deleting the "project.user" or "*.rptproj.rsuser" file located in the project folder. Reopen the solution.
And finally after hours of work, this solved for me although I had tried it early on and it did NOT work, so some combination of installed SSDT, uninstalling, updating and then deleting worked.

Monday, December 11, 2017

Create a Windows file that starts with dot

To create a file that starts with a "." in Windows, you just need to add a trailing ".". Name your file ".htaccess."

Wednesday, August 23, 2017

The Programmer's Basic crop image with border instructions - Paint.net

I needed to crop and image and make it looks a little better than the raw image. So I added a border using this instructions:
https://forums.getpaint.net/topic/31582-how-to-crop-an-image-to-be-rounded-corner/
1. Import your picture into PDN, which will be on its own layer.
2. Make a new Layer and, using the Shapes Tool, draw a line where you want to crop it.
3. With the magic wand, select inside the rounded rectangle, go to your picture layer, use Ctrl and I on your computer (to invert the selection) and then hit delete on your computer.
4. Save pdn and then save and flatten image.

Thursday, July 13, 2017

Visual Studio 2013 Web Install Block Compatibility Mode

If you receive an error when installing Visual Studio 2013 (or possibly any version), you may come across several solutions. One says to right-click and select the Compatibility, the others may say to rename the exe file to the original file name and another may say to change some settings on the ISO files to be 'compatible'.
You may do all these things and it still does not want to install. Ever.
Here are the steps you can try that worked for me on Windows 10. Not sure which one finally triggered it to work because after doing 100 things to get it to install you never know.
1. I had previously installed VS2015 before 2013, this may have triggered the problem. I uninstalled VS2015 and then I found a post that recommended clear my %temp% folders. So that is what I did and I did notice there were some 2015 files in there.
open temp folder -> clicking on start and type: %temp% delete files in temp folder
2. Rename the file to the original file name, right click the executable file, go to to the Details tab, see "Original File Name". Rename it to this.
3. I was running the exe from the D: and E: drive this could have been an issue as well, so I copied the exe to the C: drive and ran the exe as Admin. INSTALL RUNNING :)

...UPDATE: I continued to have trouble on a laptop I had purchased. Same problem. But after trying all the same steps, I could not get the install running. I decided to take a break for a few weeks, when I returned to it and used the previous steps, it got past the error. I did a system cleanup, deleted the temp folder again, renamed the file and ran as Admin and that seemed to work.