.NET Strategies

How Come i can't change the size of my application windows in Windows 10 with Parallels 12

2016-09-22T12:12:00.000-07:00

I updated to Parallels 12. I ended up changing a lot of the visual displays trying to make things better. Then somewhere along the way, I couldn't change the size of the applications in Windows 10. I thought it had something to do with Parallels, but it doesn't.

To fix this issue, simply do the following:

Go to the notifications window. The little icon near the date and time on the bottom right on the start bar.
Open it up
Check to see if you are in tablet mode.... I was.
Unhighlight it and you're done.

Fatal error: Call to undefined method aaAmazonWS::set_the_plugin() line 88 (ANSWER/SOLVED)

2016-09-22T07:47:00.001-07:00

Fatal error: Call to undefined method aaAmazonWS::set_the_plugin() line 88

I was installing WooZone's WooCommerce Amazon Affiliates plugin. And I received the message above.

Essentially, I had already installed WooCommerce Light. Then, I tried to install the purchased version above. When I installed it, the message appeared.

Solution:

go to WooCommerce Light
Get your Amazon WS settings if you don't have them easily available
Deactivate the Light version
Activate the new version

This will allow you to continue..

No more

Fatal error: Call to undefined method aaAmazonWS::set_the_plugin() line 88

Connect Office365 with my desktop or windows explorer and the sign in button doesn't work

2016-09-14T09:38:00.001-07:00

Connect Office365 with my desktop or windows explorer and the sign in button doesn't work. WTF? Really, I tried this several times.

Answer: CLICK ON THE ENTER KEY, and you will get through. I used the mouse and it didn't work.

Here's an article if it helps.
https://blog.zubairalexander.com/onedrive-for-business-and-office-365-sign-in-bug/

The source was not found, but some or all event logs could not be searched. Inaccessible logs

2016-09-02T11:27:00.002-07:00

Had the following error message:

The source was not found, but some or all event logs could not be searched. Inaccessible logs

I ended up adding this value to the registry. See the solution here:

http://stackoverflow.com/questions/20389248/the-source-was-not-found-but-some-or-all-event-logs-could-not-be-searched-inac

Section or group name 'xyz.Properties.Settings' is already defined. This can not be defined multiple times.

2016-09-02T09:57:00.002-07:00

Section or group name 'xyz.Properties.Settings' is already defined. This can not be defined multiple times. (C:\whatever.dll.config line [Line Number])

I ended up opening the config file and found a line was duplicated in Configuration | ConfigSections | SectionGroup

Removed it and all was good.

Using c# if debug

2016-08-30T16:28:00.001-07:00

If you want to hide some of your code for production you can use the #if the statements. This allows you to do testing and not affect your production code. See the example below for more information.

#if Debug

//Code goes in this spot

#endif

Using system.collections.specialized.stringcollection in application settings

2016-08-30T12:45:00.003-07:00

So, I'm in the application settings and want to put in a setting saved as type system.collections.specialized.strincollection. I started putting in a value and the message c# cannot be converted to an instance of type system.collections.specialized.stringcollection pops up. What? So, started looking online as to how to enter the value.

Long story short, if you look to the end of the line, there is an "ellipses" button. Click on the button and it will allow you to enter the values and it will format everything for you.

Verifying Data For Text Files from vendors

2016-08-30T08:15:00.004-07:00

So, I'm gathering feeds from a vendor. It's turning into be a pain in the ass. Here is what I gathered to make it easier the next time. I tried on numerous occasions to send documents with Data specifications. What I found out was they were not reading the specifications. And were just relying on me to review the data that was coming to us. So then I started to debug based on what data was sent. This initial process of course was more time-consuming on my part. But once I figured out what they were doing it's went faster. The good thing is that all the data specifications created can use internally on my end.

Find out all of the fields available.
Determine the initial set of fields needed.
Have them start sending the feeds.
Evaluate the file sense. Considering this set of feeds has headers I copied the header and example data.
I took that header and example data and showed them a before and after of what the data should look like.
Continue steps four and five until this is complete.

Excel The Formula is showing instead of the value

2016-08-26T11:33:00.002-07:00

Format the cell to "General" then hit F2. The issue is that somewhere it was changed to text.

TF84013: you cannot modify a field that is read-only or a work item that restricts updates to valid users based on current conditions

2016-08-26T10:07:00.004-07:00

Ran into this. Spreadsheet was still connected to TFS. I ended up just copying the contents of the spreadsheet into brand-new Excel spreadsheet.

How do I combine text in excel sheet to create a sql statement or combine first and last name?

2016-08-26T08:49:00.000-07:00

There are two ways to do this... you can use the shortcut or the more formal way:

shortcut: =("beginning" & "before column value" & B2 & "after column value and end")
formal: =Concatenate("beginning" & "before column value" & B2 & "after column value and end")

Choose the cell where you want to combine the values.
Type in:

=(
or
=Concatenate(

Type in the starting text surrounded by quotes "me" or choose a cell that contains the first text you want to combine like first name.
Type &” “& (a space enclosed in quotation marks).
Type in the next set of text surrounded by quotes "me" or click the next cell with the text that you want to combine like last name.

One other thing I ended up using was the Substitute command as well. It allowed me to replace semicolons with commas for comma delimited exports.

How to remove the date and author of a post in the Affinity Theme

2016-08-25T16:34:00.004-07:00

Ok, this one took me a while...

Log in as Admin to the WordPress site
Navigate to Appearance | Editor
Click on template-tags.php in the right hand navigation with all of the pages.
Search for the following line:

echo '' . $posted_on . ' ' . $byline . ''; // WPCS: XSS OK

If you don't want the date and the author to show, change this line to the following:

//echo '' . $posted_on . ' ' . $byline . ''; // WPCS: XSS OK

If you don't want to only show the date, change this line to the following:

echo '' . $posted_on . ''; // WPCS: XSS OK

If you don't want only show the author, change this line to the following:

echo ' ' . $byline . ''; // WPCS: XSS OK

C# moving a file from one directory to another

2016-08-25T12:05:00.003-07:00

C# moving a file from one directory to another

var fileName = @"xyz.txt";

var fromPath = @"c:\test\";

var toPath = @"c:\test\complete\";

public static void MoveFileToDirectory(string moveFile)

{

string fileOrigin = fromPath + moveFile;

string fileDestination = toPath + moveFile;

File.Move(fileOrigin, fileDestination);

}

MoveFileToDirectory(fileName);

C# convert string YYYYMMDD string to datetime

2016-08-25T10:59:00.000-07:00

Use DateTime.TryParseExact.

var newDate = DateTime.ParseExact("20160823", "yyyyMMdd", CultureInfo.InvariantCulture);

Add if not already referenced

using System.Globalization;

Visual Studio 2010 Save a text file as a bat or cmd file without errors

2016-08-25T09:05:00.000-07:00

Repost from...http://stackoverflow.com/questions/854360/visual-studio-inserts-invalid-characters-in-batch-files

In VS2008, select your file in the solution explorer and choose File...Save myfile.bat As...
On the down arrow on the Save button, choose Save with Encoding.
When saving in the Advanced Save Options dialog, Choose US-ASCII in the Encoding drop-down list. Set the line endings as required, or leave it as Current Setting.

Microsoft Windows 10 Pro How to put my programs, applications on top of each other.

2016-08-25T09:04:00.002-07:00

Comparing data from a spreadsheet and SQL Server management studio. I wanted to compare the data and it was difficult switching between two screens on a laptop. So, I looked into a solution that could stack both windows on top of each other. The end result was I minimized all of my applications. Then I opened up these two applications. Then I right clicked on the Windows task bar, and chose "Show Windows Stacked". That was it.

The model backing the 'DataContext' context has changed since the database was created. Consider using Code First Migrations to update the database

2016-08-25T07:35:00.003-07:00

I ran into this error message:

The Designer Code for this migration file includes a snapshot of your current Code First model. This snapshot is used to calculate the changes to your model when you scaffold the next migration. If you make additional changes to your model that you want to include in this migration, then you can re-scaffold it by running 'Add-Migration Electra1' again.

After a lot of researching and troubleshooting updating tables and updating values, I realized what the issue was. What I had done was update the Entity framework prior to running a new migration from another developer. I never actually updated the database though. So when I ran the migration from another developer, I received the above error message. To fix this, I ended up migrating my changes, and updated my database. So the real issue was I had to run my migration, and update the database.

The following link was the most beneficial after all of the research.
https://msdn.microsoft.com/en-us/data/jj591621.aspx

Import csv file with varbinary(max) using SQL Server Management Studio

2016-08-24T13:06:00.002-07:00

So, I was never able to figure out how to import the varbinary(max) with the SQL Server Management Studio. I ended up using SSMS to create an import query, then updated the query. A pain, but it worked.

I found out the issue was, I was using SQL Server management studio and created a select query. Once I had the results I copied the table into a CSV file. The issue was the information copied over into text. When I tried to import this information, it translated the information as varbinary which resulted in a different result. I ended up dropping this technique. I later tried to import this data from a duplicate database which resolve my problem.

Found this... wasn't sure if it would help someone else.
I did see later on that switching the file type to windows-1251 will work.

bulk insert loads my data, but my code crashes when trying to read or compare a text value

2013-09-10T10:28:00.002-07:00

The issue was we would do a regular export from SQL Server of a table with an ID field and a varchar field. The export went fine. Then we did an import using bulk insert... the rowterminator was \n. Everything loaded fine. The issue arose when we ran code that compared values in the text field. The result caused a crash because it couldn't return an exact match.

The end result was we changed the rowterminator to another character. For some reason, we were getting phantom characters in the text field. We couldn't see them in the database or in the code. But, if we went into the database and retyped the value, it worked.

Best

error occurred while validating. HRESULT = '8000000A'

2013-09-09T08:21:00.001-07:00

I resolved this issue by doing the following:

1. Checked out the project in Teamsite so it could write the new files
2. Restarted my computer. I had seen that somewhere before
3. Right click on Detected Dependencies and refreshed them.
4. Rebuilt the project.

Until I restarted I couldn't refresh the dependencies, there was always an error.

Incorrect Shp File Format using DevExpress

2013-08-21T10:20:00.001-07:00

So, I thought I had everything working. Then I received the message "Incorrect Shp file Format" presented as an error when trying to run in debug mode for Visual Studio 2010. The error occurred in the Designer.cs file.

Part of the issue is that I'm trying to take an existing shp file and split it up into multiple shp files. Note, the original shp file with all of the points does work. But, when I try to pull specific locations out, I receive the error. I'm using Quantum GIS to do this.

Ground zero. Just to test, I decided to select all of the same data points in the original file. Click on save selection as and create a new set of shp files. When I reference this group of files in the project, I receive a "Property value is not valid." and ""Disagree dbf file" error messages. So, logically, I thought I should update the dbf file to match.

Had to shift topics, but have not been able to resolve this issue.

Need help choosing a datacenter?

2013-05-08T19:41:00.006-07:00

Data centers needs have become one of the largest growing needs in the country. Think about it, there is more and more data every day. Each time you post an image or message online, thousands of others are doing the same thing. What if you were looking to purchase a datacenter or need data center help? Where would you go? There are realtors all over the world that would say they could help you. But, can they really help?

At DatacenterHelp.com there are knowledgeable professionals ready to help. There isn't any cost to you. They are paid by the data centers themselves to gain business. If you're looking to choose a data center, look no further.

The type name 'DateTime' does not exist in the type 'MyProject.Models.System' - Visual Studio 2010

2013-04-23T15:04:00.000-07:00

Ended up replacing instances of System.DateTime with DateTime and System.Guid with Guid

Visual Studio 2010 Save a text file as a bat or cmd file without errors

2013-04-17T11:27:00.001-07:00

Repost from...http://stackoverflow.com/questions/854360/visual-studio-inserts-invalid-characters-in-batch-files

Error Message:

C:\>∩╗┐
'∩╗┐' is not recognized as an internal or external command,
operable program or batch file.
Creating tables on server (LOCAL) and database PLEDGES
Done creating tables.

Quick Solution

In VS2008 and VS2010, select your file in the solution explorer and choose File...Save myfile.bat As...
On the down arrow on the Save button, choose Save with Encoding.
When saving in the Advanced Save Options dialog, Choose US-ASCII in the Encoding drop-down list. Set the line endings as required, or leave it as Current Setting.

Windows Services for constant Database Updates

2013-04-17T10:08:00.000-07:00

Research on Windows Services.
What is a Windows Service: http://msdn.microsoft.com/en-us/library/d56de412(v=vs.80).aspx

Create a service using: http://msdn.microsoft.com/en-us/library/zt39148a.aspx

The installer service file properties will define the name and description of the service. Whatever you put in here as the name will appear in Windows Services.

Command line arguments to get everything running:

******
How to install this service
******
installutil.exe xyz.exe

******
How to uninstall this service
******
installutil.exe /u xyz.exe

******
How to Start the Service
******
net start "xyz"

******
How to Stop the Service
******
net stop "xyz"

******
To verify service is running
******
1. Go to Command line: cmd.exe
2. Type in: services.msc
3. Look for "xyz"

******
How to see what's happened with the service
******
1. Go to Event Viewer and view messages: eventvwr
2. Windows Logs | System