Knowledge base / Since 1999
Practical solutions and technical notes from CRM platforms, workflow automation, APIs, databases and the systems around them.
Advanced search639 entries
So I can ping the server the Oracle 11g database sits on. I've installed the Oracle 11g client tools and can connect using sqlplus. But if I tnsping any oracle database, I get something along the lines of: Message 3511 not found; No message file for product=NETWORK, facility=TNSMessage 3512 not found; No message file f...
I want to create a desktop shortcut that I can double-click and it will run the above programs in administrator mode without confirmation by the Windows operating system. At home this may not be a problem but this is intended for those in an office environment and we get prompted to login (with the same account as we'r...
We have an excel spreadsheet which reports against a mySQL database and reads time spent on projects by IT Service colleagues. The main report is a pivot table with staff members along the top, tasks down the first column, and time spent in the form of person days in the cross-join.
So many people asking this when the solution is a bit of aesthetic styling. ol -- yields 995. 996. 997. 998. 999. 000.
For those of you who use Preg_Replace. Preg_replace is a function that uses regular expressions to search and replace a string.
This article isn't unique as there are other tutorials out there. This is meant to detail a process to export a database using MySQL Workbench and then to import it into another database.
This is an article on how to replace a string with another in all your joomla articles without modifying other data such as modified date and author.
So this is a quick article on how to install the mySQL add-on for Oracle SQL Developer v3.0.04.
Some memory aids for me so that I don't have to keep looking them up:
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 CRM's Notes now gets Reactions and a new look Zoho CRM: Sync Deal and related record owners from Zoho Desk Zoho CRM: Link supplier emails to the Purchase Order Emails related list Zoho CRM's WhatsApp integration now supports multiple accounts, multiple numbers, and custom modules Zoho Books: Improper Statement Error might be due to missing ';'Protected notes
Log in for protected notes and any private client projects assigned to your account.