Knowledge base / Since 1999
Advanced
search
Practical notes on CRM development, automation, APIs and everyday IT.
Browse all notes328 results
Zoho People and Zoho Analytics: Push all Employee Salary Data to Analytics
... r to performance goals, we need to write code to push the salary data out to a Zoho Analytics table. How? Sounds like you could just do as we did with the P_Goals table but I need this to run every night picking up salary changes as well. I ...
ZohoCRM GetRelatedRecords INVALID_DATA
... d to update the related records. I was getting the error INVALID_DATA with the details being api_name:'data'... But this is shortcode, not an invokeURL. { "code":"INVALID_DATA", "details":{ "api_name":"data" }, "message":"invalid data", "st ...
Zoho Analytics & Zoho People: Monitor DataSource Sync
... ? A quick article on how to setup an automation that checks if a datasource synchronization between Zoho People and Zoho Analytics failed. This can be adapted to any data source for Zoho Analytics. Why? We're assisting a client implement Zo ...
ZohoCreator: Basic Widget with Zoho Data
... ntation was a little sparse on how to connect a JS widget to the data held in Zoho Creator. Having this example for future use might save me some time. The following is the early version of a JS widget used for a customer and before I added ...
Zoho Creator: Find Duplicates by Customer Name for Large Datasets
... xecution limit. Why? My use-case is that I need this done over a dataset of 20k+ contact records and that's only half of the production system's contacts. I needed a quick bit of code to find any duplicates, all within the Zoho Creator app ...
Zoho Analytics: Setup DataSource via FTP Connection
... unch of pictures showing step-by-step of how I setup a recurring data source in Zoho Analytics via FTP. Why? The use-case here is that I have a client who wants to import data via FTP (SFTP - to be precise) and have this available to their ...
Minimal Privileges for MySQL Database Backup Cron Job
... wer on this. I need a cron job setup where the permissions for a database user is required to do a backup (reading and copying data from a LIVE database) to a copy of the database (inaccessible via other users). How? I want to list 2 method ...
MySQL Updating a database table from another table
What? A quick article on how to populate a database column from another table using a string comparison. Why? I have several database tables which replicate country names and I would rather they all use the ccTLD two letter code. This artic ...
SSIS: How to loop through multiple flat files as data sources
... 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. Why? I am c ...
SSIS: Cannot open Data Flow Task: DTS.Pipeline.2 issue
What? 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 Why? We use a combination of MS Visual Studio 2008, 2010 and 2012. VS2008 for our ...
Compare two databases using T-SQL
... pplies to: MS SQL Server Management Studio 2008 Two Transact-SQL databases What? A quick article on how to compare two Microsoft databases using the tools provided with SQL Server and without having to download any third-party products. Why ...
T-SQL Conversion failed when converting the varchar to data type int
... r "Conversion failed when converting the varchar value 'B110' to data type int" then read on. How? So where does the 'B110' string come from, well from one of our tables which looks similar to the following: Table: DMExtractEmployeeTable -- ...