Knowledge base / Since 1999
Practical solutions and technical notes from CRM platforms, workflow automation, APIs, databases and the systems around them.
Advanced search342 entries / matching Data
Clear filters
This is a quick article on how to get around the problem of backing up your MySQL database when attempting to "Data Export" using MySQL Workbench. This is not regarding the connection issue as I can connect to my database using MySQL Workbench (I have enabled the old authentication protocol). The error ONLY appears whe...
Someone suggested an app that counts the days I have left serving my notice. I thought I'd go one better and have it calculate to the nearest second. I call this latest app "byeBU" and this is version 0.4 Beta (unofficial app).
A quick article on how to use the where clause in a joomla database query.
A really quick note on how to insert a carriage return or new line into the column name/alias (the header). It might seem trivial but these little aesthetic changes done at the database level can save some time.
This is an article to demonstrate a quick step-by-step on having an SSIS package loop through a directory/folder of files in order to populate a database table. We could add each file as a separate connection manager but this is inefficient and not versatile enough to accommodate files that get added later.
I started getting this error: The task with the name "Data Flow Task" and the creation name "DTS.Pipeline.2" is not registered for use on this computer
So this is an article exploring how to convert UPPERCASE text into mixed case. The feed is originally for a personnel feed so it won't be converting long paragraphs of English text. Instead it will be applied to names and addresses as well as job titles and departments.
So I have a column in an SSRS report which displays a date. Being rather pernickety, I would like a question mark to display if there is no date to populate the field.
I recently revamped our standard report with a new template comprising of a single Tablix which contained the images of the corners and sides of the report. It looked beautiful if simply displayed on a single page (the top half of the page) as long as the end-user doesn't scroll. If the page was scrolled, what should d...
Working principle
This site exists as a practical knowledge base built from real-world experience across systems, platforms, and technologies since 1999. Much of the content documents solutions, edge cases, and working patterns that were learned through investigation where documentation was incomplete or absent, and is shared to reduce the same friction for others.
Recently Added
Zoho Books: Change a Purchase Order's Delivery Address over API Zoho CRM: Presenting ABM for Zoho CRM: Expand and retain your customers with precision Zoho CRM: Announcing the new SKILL.md for Zoho CRM and the updated OAS repository! Zoho CRM: Allow Only Administrators To Change Task Owners Zoho Billing: Workflow does not exist!Protected notes
Log in for protected notes and any private client projects assigned to your account.