Knowledge base / Since 1999
Practical solutions and technical notes from CRM platforms, workflow automation, APIs, databases and the systems around them.
Advanced search477 entries / matching AI
Clear filters
Hopefully the title doesn't put you off but after much Googling and Bing-ing, I still couldn't figure out how to do this. Hopefully this article will help you more than my search engine skills do. My Setup Windows XP Workstation ...needs to open... Excel 2007 SP2 ...with ODBC to... MySQL v5+ ...hosting database... Acti...
This article serves to describe several workarounds or proofs of concept.
Amazing, I have just spent all morning on Microsoft websites to determine what number is the TimeDataRetrieval column displaying. Thank you I know it's an INT. There is just a serious lack of documentation as to what this database is and how it populates its data. View: ExecutionLog InstanceNamenvarchar(38)NOT NULLName...
So I'm looking for a SQL query that could do this all in one go and return all the results in one table. With PHP & MySQL it's pretty simple: use individual SQL queries to get the count of yesterday, yesterweek, yestermonth, yesteryear and do the layout in PHP. Now let's say I have one RDL or SSRS Solution. I could do...
The situation is that we are replacing a website-application with a single SQL Server Reporting Services (SSRS 2008 R2) report. We're using Business Intelligence Development Studio (BIDS VS2008) with Team Foundation Server (TFS VS2010) and connecting to an Oracle database (ie. "seamless integration because our setup is...
So I'm revisiting this component for the third time (previously known as "downloadtracker" and "joesdownloadtracker"); for ages I have needed a replacement for the download component managers for Joomla! CMS. I've tried all the following for about a year each and these are my reviews/opinions: Phoca Download Good compa...
Apologies for copying and pasting this but this is information that is worth NOT losing. Tutorial on how to use COM objects in AutoHotkey. Source: Jethrow @ Autohotkey Forums
Apologies for copying this from another source but with lots of OpenSource developers disappearing and reappearing, the content is what I don't want to lose.
This is an article intended for IT Support. It is a list of the system tools available in the Microsoft Windows OS that can be run from the "Start > Run" option. How?
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.