Zoho Creator: Error Code 2945: EXTRA KEY FOUND IN JSONhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-error-code-2945-extra_key_found_in_json.html

04 October 2023 m_QuoteRecord.put("Email",v_SellerEmail); // // other params m_Blank = Map(); // // send the request r_Create = zoho.creator.createRecord(zoho.adminuser, zoho.appname, "Quote", m_QuoteRecord, m_Blank, "my_creator_connection"); // // FAILS: with r_Create...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

05 December 2023 the on-boarding process. A client of ours has a rather rich HTML email signature with a profile photo included. When sending an email from CRM, they want CRM to include this rich signature (different per user) at the bottom of the email message. How? So...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttp://mail.joellipman.com/articles/crm/zoho/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html

05 December 2023 v_Endpoint = m_Attachment.get("href") + "?orgId=" + v_DeskOrgID; info v_Endpoint; // // build data row to send m_Data = Map(); m_Data.put("Ticket ID", p_TicketID); m_Data.put("Attachment ID", m_Attachment.get("id")); m_Data.put("Image URL", v_Endpoint);...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

14 May 2024 spend this long on such a request again. The brief is: "Follow up when a lead is created and not converted within 1 day send an email and notification to sales person everyday for 3 days then escalate to a specified user". Why? Sorry Zoho! I tried using...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoAnalytics & ZohoBooks: Custom Related List from Analyticshttp://mail.joellipman.com/articles/crm/zoho/zohoanalytics-zohobooks-custom-related-list-from-analytics.html

09 July 2024 a related list on the Sales Order but does not associate any records... not sure why this is. So we have a workaround, by sending all the data including the custom fields per line items to ZohoAnalytics; and in ZohoAnalytics importing a table based on a...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Workdrive: Getting Team Folder IDhttp://mail.joellipman.com/articles/crm/zoho/zoho-workdrive-getting-team-folder-id.html

11 September 2024 { v_PermaLink = m_ThisData.get("attributes").get("Permalink"); } } } } } // ==================================== // send an email with the permalink v_Subject = "Data for Export w/c: " + zoho.currentdate.toStartOfWeek().toString("yyyy-MM-dd"); v_Message...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM: Updating a CRM record Custom Line Items using API v7http://mail.joellipman.com/articles/crm/zoho/zoho-crm-updating-a-crm-record-using-api-v7.html

18 December 2024 // if there is reason to update it then let's update CRM API v7 style if(l_NewLineItems.size() > 0) { // // build request to send to CRM v7 // m_RecordData should have value from last iteration m_UpdateQuote.put("Subject",m_RecordData.get("Subject"));...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Nested Catch Statementshttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-nested-catch-statements.html

04 February 2025 which exists for a client of mine. The use-case for my Cx is that they need documents converted from HTML to PDF — as in we send it a bit of code in HTML and we want a PDF file returned. I have severaly instances of an API which accepts HTML and returns...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Database Error: Unable to connect to the database: Could not connect to MySQLhttp://mail.joellipman.com/articles/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

25 September 2009 does and the number of times I refresh the page and upload files. Why they think that developers should not be able to send a 1000 queries a minute or why a developer has to refresh the page, make a change, upload, etc. well it's beyond a joke and no...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

Mediawiki Extension for Camtasia Studio SWF videoshttp://mail.joellipman.com/articles/cms/mediawiki/mediawiki-extension-for-camtasia-studio-swf-videos.html

08 October 2009 "renderFlvPlayer" ); } function renderFlvPlayer( $input, $argv ) { $result = $flvPlayerFile->render(); return $result; // send the final code to the wiki } Amend your skin files Amend your skins to include the reference to this script in between the...

• Type: Article
• Author: Joel Lipman
• Category: MediaWiki
• Language: en-GB

Project Plan for Freelance Websitehttp://mail.joellipman.com/articles/web-development/project-plan-for-freelance-website.html

25 February 2010 Thunderbird, Eudora) For Joellipman.com to do: Submit connection instructions (SMTP, POP3 - incoming, outgoing servers) Send Webmail URL Allocate space for mailbox(es) Assign passwords and instructions on changing each password Website Initiation For...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

SSRS Hide results table if emptyhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-hide-results-table-if-empty.html

29 March 2011 Type the following expression (where "Equipment" is the name of the dataset) =IIF(Sum(Fields!Counter.Value, "Equipment") send to back), the expression for visibility on the textbox should be something like: =IIF(Sum(Fields!Counter.Value, "Equipment")>0,...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Could not instantiate mail functionhttp://mail.joellipman.com/articles/cms/joomla/could-not-instantiate-mail-function.html

09 May 2011 isn't resolved by just changing the Mailer (Joomla > Global Configuration > Mailer settings). Alternate between PHPmail and sendmail just to check this isn't the problem. If the problem is still there then check the below: Tried both PHPmail and...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

Stop Excel Row Height Self-Adjust on Refreshhttp://mail.joellipman.com/articles/microsoft/excel/stop-excel-row-height-self-adjust-on-refresh.html

30 September 2011 since simplified this so that only the person who knows how to hit the refresh button is the one to save as a PDF file and sends it to all customers. Training these people in adjusting row height would be like a magician revealing the secrets to his...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB

T-SQL Record Separatorhttp://mail.joellipman.com/articles/database/t-sql/t-sql-record-separator.html

11 October 2011 Some of our end customers are not even computer literate so the SQL query had to do the bulk of the work. The SQL query we send to the database has to insert separator rows so ideally we would like: Day ---------------- Monday Monday Monday Tuesday...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB

Joes DNS Correction (JDC)http://mail.joellipman.com/component/content/article/joes-dns-correction2.html?catid=40

25 November 2011 -- http://autohotkey.com/ * Joes Brains v0.1 alpha -- http://joellipman.com/ Future Considerations: Any suggestions? Send them to...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

No rows returned in Oracle causes SP to failhttp://mail.joellipman.com/articles/database/pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

24 January 2012 procedure: The solution in the end was to null the first query and make sure it didn't return the errors "no data found" and send this to the second query: -- the same query but which doesn't fail the procedure :) SELECT NVL( ( SELECT...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

Prefix Line Numbers in a Text Filehttp://mail.joellipman.com/articles/automation/ms-dos/prefix-line-numbers-to-a-text-file.html

18 July 2012 line 3 ***** C:\TEMP.TXT 1: ECHO is on. ***** Additional You could change c:\results_file.txt to %TEMP%\results_file.txt to send the file to your temporary directory instead of using the root c drive. If you do not have c:\windows folder than find where...

• Type: Article
• Author: Joel Lipman
• Category: MS-DOS
• Language: *

DataJumble - Shuffling characters in a data valuehttp://mail.joellipman.com/articles/database/t-sql/data-shuffling-function.html

01 August 2012 so I've renamed it DataJumble as opposed to my article on Data-Scrambling. Why? We want to scramble sensitive data that we send to suppliers for support or analysis. With inspiration from: "Obfuscating your SQL Server Data" by John Magnabosco but...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

Slideshow div layer through a windowhttp://mail.joellipman.com/articles/web-development/mootools/slideshow-div-layer-through-a-window.html

11 September 2012 AJAX (which will have to be Asynchronous JavaScript and xHTML. I'm not using XML, or is that AJAHtml? AJAH?), anyway, we can send each new info to the next slide and use only two slides in total (that's the aim at least). Other objects (mostly text over...

• Type: Article
• Author: Joel Lipman
• Category: MooTools Framework
• Language: *