JSDoc Tokenizer Plugin to Replace the Token With Values From Config
If you are a JavaScript developer, you would have used the JSDoc to document your JavaScript code. I was trying to use the JSDoc for generating the documentation for my PramukhIME Javascript library. I have the core library and based on the plugin, I wanted to generate the documentation to show how the plugin works…
JSDoc – Customize Output Documentation Files
I am using JSDoc 3.4.2 for my JavaScript library documentation. I wanted to make the change to the output files so here are the tricks I used to make following changes. In order to make the change, I have copied all the files from the default template available at “C:\Users\USERNAME\AppData\Roaming\npm\node_modules\jsdoc\templates\default” (JSDoc over Node.js location) to…
Resolved: Method ‘Sheets’ of Object ‘_Global’ Failed
We have a complex macro enabled spreadsheet. Today we got a ticket from the business user that Excel is throwing error: “Run-time 1004 error: Method ‘Sheets’ of object ‘_Global’ failed.”. I could not find an answer even after searching online for hours. None of the online discussion was giving the root cause of the error.…
Execute Package Task Fails Even Though the Package Executed Successfully
We have parent and child SSIS packages. Both the packages were using environment variable configuration and sql configuration to get the further configuration property. Sql authentication and package protection level is set to “EncryptSensitiveWithUserKey” for parent and child packages. Both the packages run as expected in development environment. When we moved packages to QA, even…
|
Excel Column Letter to Number Quick Reference
Here is a quick reference for Excel column letter to number mapping. Many times I needed to find the column number associated with a column letter in order to use it in Excel Macro. For a lazy developer like me, It is very time consuming 😉 to use my Math skill to get the answer…
The Value Violated the Integrity Constraints for the Column
SSIS Package Error You are using SSIS package to load data into SQL table and suddenly you get the error “The value violated the integrity constraints for the column”. It does not give enough information of why the error occurred. Root Cause for Error SQL Server has following integrity constraints Primary Key Foreign Key Not…
|
Restore Missing Button and Drop Down Controls in Excel
Have you ever faced a situation where suddenly all the buttons, drop downs and various controls are missing from your Excel spreadsheet? Well, it’s not gone but it is hidden. Here is the setting to make the controls visible. Go to File > Options > Advanced > Display options for this workbook > For objects,…
How to Use Plain Old JavaScript File into Node.js as a Module
If you want to use your plain old JavaScript file into Node.js, you need to create a module which is nothing but a fancy wrapper around your JavaScript file and then you can use all the functions of your JavaScript object into Node.js. Environment Windows 7 (64 bit) Node.js 4.4.2 (64 bit) Path already contains…
Improve Attunity Driver Performance When Extracting Millions of Rows From Oracle
If you are extracting data from Oracle, Attunity driver helps you extract it faster. But if you are extracting millions of rows from Oracle and you think it is slower than anticipated, here are few tips. These advanced tips will help you drastically improve the performance. Advanced Tips to Improve Performance Right click on Oracle…
|
How to Permanently Remove the Changeset From Mercurial?
Steps Backup repository/repositories you want to modify. Enable “mq” extension. If you don’t know how to enable it, follow these steps. Open TortoiseHG Workbench Go to File > Settings > USERNAME’s Global Settings > Extensions > select “mq” > press OK button Restart TortoiseHG by closing and opening it again. Select changeset you want to…
Knowledge.ToString()