Assuming data is required, the following 231 results were found.
-
the 100 most recently modified products at the end of each day and run some Deluge code against it to ensure that the data in Shopify is the same as in Zoho. In this case, Shopify is considered the source of truth and Zoho is the data to be overwritten,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
{ v_RecipientEmail = r_Contact.get("Email"); v_RecipientFullName = r_Contact.get("Full_Name"); // _ m_Parameters = Map(); m_Data = Map(); m_Templates = Map(); m_Actions = Map(); m_FieldData = Map(); m_FieldTextData = Map(); m_FieldBooleanData = Map();...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
type :GET connection:"zcrm" ]; // l_ContactDetails = ifnull(r_ContactDetails.get("data"), List()); for each m_ContactDetails in l_ContactDetails { if(!isNull(m_ContactDetails.get("Tag"))) { for each m_Tag in m_ContactDetails.get("Tag") {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
the BODY tags and not in the HEAD): Loading... Please Wait... console.clear(); ZOHO.embeddedApp.on("PageLoad", function(r_Data) { // for debugging console.log(r_Data); // get id and module on page (if this is a button off a record details view) var...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
changes you may need to make. 1. First: the variables are in arrays Well mostly. Simply because we'll be working with JSON data and this encodes/decodes easily into PHP arrays. I can also output any of the variables and responses for debugging purposes....
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
demonstrating how to use a SOUNDEX in a select and then listing all the variations based on case-sensitivity. Why? We have a database with data in it. For a particular column we have setup default values, let's use the example "Data Not Yet Available"....
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
the API calls to go through a few thousand records and 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":{...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
I'd put a note on this error. Bearing in mind that this is a general data type error and not just because I tried to convert a date in SQL format to a Month name. An error occurred during local report processing. An error has occurred during report...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
If you are trying to join two tables and receiving the error "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...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
- Type: Article
- Category: Static Items
- Language: *
-
Integration API) v_TokenCrmID = 123456000000789012; r_TokenDetails = zoho.crm.getRecordById("Integrations",v_TokenCrmID); v_DataEndpoint = ifnull(r_TokenDetails.get("Data_Endpoint"),""); v_TenantID = ifnull(r_TokenDetails.get("Tenant_ID"),""); // // get...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
Integration API) v_TokenCrmID = 123456000000789012; r_TokenDetails = zoho.crm.getRecordById("Integrations",v_TokenCrmID); v_DataEndpoint = ifnull(r_TokenDetails.get("Data_Endpoint"),""); v_TenantID = ifnull(r_TokenDetails.get("Tenant_ID"),""); // // get...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
Outline Note: As simple as this sounds, this is not a five-minute job. Even with all your SQL scripts with backups of your datasets, each of these will need tweaking. Create your stored procedure in Oracle (and grant execute for your SSRS user) Add a...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
up on my article on correcting disappearing headers, a further issue with our web-report is that even an export to Excel (Data Only) from Crystal Reports 9, created extra columns. This issue could not be replicated on the client machine (ie. from my...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
A quick article on how to skip rows or even specify a range to extract from the Excel file when using as the DataSource. Why? If you are simply using a text file as your data source, then the options in the connection manager will let you skip rows and...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
with how the file was downloaded with cURL. The XML node should be baños. The initial command using cURL was: function get_data($url) { $ch = curl_init(); $timeout = 5; curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
was called a Data-Scrambling Function but it depends on what you mean by "scrambling". This is a function which merely uses the same characters but switches their order randomly, so I've renamed it DataJumble as opposed to my article on Data-Scrambling....
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
A data type reference table. If you're designing a database then you don't need me to tell you what this is. My personal opinion is to always try to use the minimal type and length of the value required. For example, a comment of 500 words should only...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
null)); b.create().show(); } @Override protected void onActivityResult(int requestCode, int resultCode, Intent data) { // if taking if (requestCode == REQUEST_IMAGE_CAPTURE && resultCode == RESULT_OK && null != data && TAKE_OR_PICK == 1) { Bundle extras...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
I have a PHP script which behaves like PhpMyAdmin, in that it automatically lists a database structure and the fields to modify similar to an excel spreadsheet. Now without using PHP, I need standalone SQL scripts that can simply be used to search an...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB