Knowledge.ToString()

  • How to Use JSDoc @event Tag Correctly?

    I am using JSDoc 3.4.2 for my JavaScript API documentation need. By looking at the @event tag example, when I tried to use it, the event name was replaced with “event:” + event name which was a sign that it was looking at the @event tag correctly but found two issues. When I use @fire…

    |

  • How to Document Self-Executing Anonymous Javascript Function Using JSDoc?

    I have a class defined in self-executing anonymous Javascript function for which I want to generate the documentation using JSDoc 3.4.2 but I had hard time finding the solution. Solutions searched on the internet did not yield the fruitful result and I had to try various combination of tags in order to get it working.…

    |

  • 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…

    |