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 an article serving as documentation for my first ever app on the Android Operating System. For tablets and phones. The app in a nutshell displays flight restrictions in a given area Description As a quadcopter flier myself, I wanted an app to show me a map of the area I was going to film or fly. I wanted it to...
A quick article on how to populate a database column from another table using a string comparison.
I am writing an app for a tablet running Android and wanted to include a Google Map. The following exercise focuses solely on creating an app which opens Google Maps at your current location. How? I couldn't find any instructions using the tools I had (Android Studio) which is why I've written this article.
"Quick" may not be the right word, so this is a somewhat summarized article on how to get data out of SITS, up to running the monitors and populating an OUTPUT table in the SITS database. Note that this does not include steps thereafter in the Staging or Target destination which will be specific to your business requir...
An article on how to declare an XML element as NULL using the attribute "xsi:nil". I'm going to use a very short example by providing a blank date of birth value: -- What I have: // -- What I want:
XSD Elements Element Explanation all Specifies that the child elements can appear in any order. Each child element can occur 0 or 1 time annotation Specifies the top-level element for schema comments any Enables the author to extend the XML document with elements not specified by the schema anyAttribute Enables the aut...
You might be able to work it out from the online manuals but it took me a while, we wanted to bring back both the code and the lookup value in our XML to our Staging environment.
Trying to export a STU record but I want to use the XET template I created rather than the pre-installed XML export formats. When I try to export using data format XET, the system has never heard of it.
A quick article on an alternative to multiple lookups in SSIS. For any SSIS developer trying to create packages that need to decode a number of values into their full name/description (eg. "M" to "Male", "Prof" to "Professor").
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.