Debugging VS2013/VS2015 Websites Using 64-bit IIS Express

If you are working on ASP.NET MVC web sites in Visual Studio 2013 (VS2013) or 2015 (VS2015), and want to debug 64bit application, you need to do following changes in Visual Studio.

f you don’t do this, you will likely get a message similar to:

“Could not load file or assembly or one of its dependencies. An attempt was made to load a program with an incorrect format.”

For Visual Studio 2013 and Visual Studio 2015:

Tools
  -> Options
   -> Projects and Solutions
    -> Web Projects
     -> Check "Use the 64 bit version of IIS Express for web sites and projects"`

How to display negative time in excel cell

While working with excel application I found that if we find difference between 2 times is negative then excel doesn’t display time, it shows “##########” instead of values. For positive difference we don’t have any issue.

There are 2 ways to handle this, using 1904 date system and other using custom formula.

To change the date system you need open Advance options of excel and enable the 1904 date system box.

Use the formula:

=IF(D2-A2<0, "-" & TEXT(ABS(D2-A2),"hh:mm"), D2-A2)

 

 

How to fix the outlook issue when its prompting the password again and again

We are using Microsoft Outlook on our desktops or laptops to view emails offline. Some times on start the outlook it prompt us to provide valid password. After providing valid password it prompt again. This will be some irritating.

To fix this type of issue we do have 2 ways:

  • Remove the saved credentials of outlook from windows credentials manager, using these steps:
    • Click Start, click Control Panel, and then click Credential Manager.
    • Note If View by is set to Category, click User Accounts first, and then click Credential Manager.
    • Locate the set of credentials that has Outlook in the name.
    • Click the name to expand the set of credentials, and then click Remove from Vault.
    • Repeat step 3 for any additional sets of credentials that have the word Outlook in the name.
  • In outlook, go to “Email Accounts -> More Settings” –> “Outgoing Server” –> Check First checkbox and first radio button.

Only Office Error: Server connection lost. The document cannot be edited right now

After hosting of Only Office some time users can get the error “Server connection lost. The document cannot be edited right now“.  To resolve this error we can remove 2 values from the web.config key of the Document Server setup.

By default values:
<add key=”editor.settings.coauthoring.url” value=”/coauthoring” />
<add key=”editor.settings.spellchecker.url” value=”/spellchecker” />

Remove values like that:
<add key=”editor.settings.coauthoring.url” value=”” />
<add key=”editor.settings.spellchecker.url” value=”” />

and reset the IIS.

How to recover an archived email from your gmail account

Most of the people in the world are using GMAIL for their email, its a free and support unlimited storage (15 GB).

Some times while viewing the email on desktop / handheld devices, archived option is clicked accidentally. If you want to recover that email from archived folder, just use these steps:

  • Open your gmail account
  • Go to left panel and click on “All Mails”
  • Search your email and open it
  • After opening, click on “Move to Inbox” button.
  • Now you can see your archived email to inbox folder

Archive folder is good for keeping the emails, if you want to delete the emails which is not used, without deleting permanently them move to archived folder.

How to enable HTTP Compression of Static and Dynamic Contents IIS

Enabling compression of static and dynamic contents of your website will be more help to load your website faster on browsers.

To enabling both you must have to install “Dynamic Compression” and “Static Compression” on the server features and roles.

Open server manager
Roles > Web Server (IIS)
Role Services (scroll down) > Add Role Services
Add desired role (Web Server > Performance > Dynamic Content Compression & Static Content Compression)
Next, Install, Wait for couple of seconds…Done!

To Enable it:
Open your web.config and add the following configuration in webServer tag.

<system.webServer>
<urlCompression doStaticCompression="true" doDynamicCompression="true" dynamicCompressionBeforeCache="true"/>
<httpCompression noCompressionForHttp10="false" noCompressionForProxies="false" dynamicCompressionDisableCpuUsage="93" dynamicCompressionEnableCpuUsage="93" staticCompressionDisableCpuUsage="99" staticCompressionEnableCpuUsage="99">
<scheme name="gzip" dll="%Windir%\System32\Inetsrv\gzip.dll" staticCompressionLevel="9" dynamicCompressionLevel="4" doDynamicCompression="true" doStaticCompression="true"/>
</httpCompression>
</system.webServer>

 

remove duplicate values from a excel cell

Microsoft Excel is used by everyone in the world for all data related things, some time we have duplicate cell contents in rows or in columns.

To remove these duplicate values from the sheet we already have a feature “Remove Duplicates” in latest version of the excel application. But if we have some duplicate values in a single cell then this feature will not work, we need some another alternative, either we delete manually or can create a Macro / Addins / Custom Function.

Manual process will not help because it required lot of concentration,  To resolved that I have created a Addins which we can integrate in excel application and access this custom function like other we generally used.

Steps to create addins:
– Go to View – > Macro
– Define Name “RemoveDuplicatesFromCell” and click on create Button
– Add the following code at Module1 file
– Save the file as RemoveDuplicatesFromCell.xla

Function RemoveDuplicatesFromCell(txt As String, Optional delim As String = " ") As String
Dim x
With CreateObject("Scripting.Dictionary")
.CompareMode = vbTextCompare
For Each x In Split(txt, delim)
If Trim(x) <> "" And Not .exists(Trim(x)) Then .Add Trim(x), Nothing
Next
If .Count > 0 Then RemoveDuplicatesFromCell= Join(.keys, delim)
End With
End Function

 

Only Office – Multifunctional service for business with low cost

Only Office is a great tool which can use by any small scale organization for Project management, online editors, documents management, emails and few more things. Like all the features are available in other products too like Google, Microsoft Office Online, Microsoft SharePoint. All these products stores data to their own cloud servers, they are some expensive for the start-ups or small companies, also their model based on subscription. We need to pay them monthly or yearly subscription.

Only office also host on their cloud machines but we can setup this on our machines too.  A subscription model of this application also cost effective. Any small scale company can afford it. If they want to setup their own machine then it can also be possible.

If we have a small team and would like to share docs between them without worrying about versions, sharing permissions, we can do it easily with this tool. It also support web editors where anyone can open and edit documents without installing the required software’s on local machines. This will help to reduce resources as well.

Only office also easily integrated with existing applications using iframe without worrying and wasting lot of time. It has application programming interface (API) too, so programmers can easily integrate it. Programmers can easily create real time users, upload files, sharing permission to the file without going to portal.

Only office installation is also easy, it provides single click installation for beginners, setup will take case all the things, we need to provide public IP and credentials to start that.

Only office comes with two applications, first Community Server and second one is document server. Community server will take care of all the things like project management, users, sharing, emails, authentication and authorizations. Document server serve the documents online with the support of Iframe.

If anyone wants to use the application for editors only then he can setup document server ONLY. Both application needs to install on separate machines. They are internally responsible for data transfer.

See more about only office please click here

General Medical Terms

  • Patient
  • Hospital / Facility
  • Hospitalist / Provider
  • PCP – Primary Care Physician
  • Referring Physician
  • Consulting Physician
  • Ordering Physician
  • Admitting Physician
  • Attending Physician
  • Dictating Physician
  • Discharging Physician
  • Insurance – Primary, Secondary
  • SSN – Social Security Number
  • ICD –  International Classification of Diseases
  • CPT – Current Procedural Terminology
  • DRG – Diagnosis Related Groups
  • Billing
  • Admission
  • Discharge
  • LOS – Length of Stay
  • Discharge Notes
  • DOS – Date of Service
  • Modifiers
  • ER – Emergency Room
  • ICU – Intensive Care Unit
  • MRI – Magnetic Resonance Imaging
  • Medicare
  • Medicaid
  • POS – Place of Service
  • MRN – Medical Record Number