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

04 October 2023 and wanted to update the first name of a name field but I was getting the following error: { "code": 2945, "description": "EXTRA_KEY_FOUND_IN_JSON" } How? So the quick answer is to build a nested map in your request instead of using the...

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

Blank columns issue when exporting to Excel (Data Only) from Crystal Reportshttps://www.joellipman.com/articles/microsoft/excel/blank-columns-issue-when-exporting-to-excel-data-only-from-crystal-reports.html

15 June 2010 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 workstation). I would have to upload the report...

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

Zoho CRM: Client Script Confirmation Box and Popup Mailerhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-client-script-prompt-and-popup-mailer.html

06 February 2024 much this can be customized. The task I've set for myself is as follows: Trigger if the contact record has a tickbox called "Extra Confidential" ticked/checked=true Popup a confirmation box to proceed or cancel. Popup the email from CRM mailer with the...

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

Tagliatelle alla Carbonarahttps://www.joellipman.com/articles/_other-misc/tagliatelle-alla-carbonara.html

07 July 2009 Ingredients 1 tbsp extra virgin olive oil 300g/10½oz prosciutto slices, cut into strips 1cm/½in wide 100g/3½oz unsalted butter 150ml/5fl oz white wine 6 free-range egg yolks 50g/2oz parmesan, freshly grated, plus extra for serving 50g/2oz aged...

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

Sun-Dried Tomato Basil Couscous Recipehttps://www.joellipman.com/articles/_other-misc/sun-dried-tomato-basil-couscous-recipe.html

03 September 2009 drained and diced 1/4 cup sliced green onions (scallions), tops included 2 Tablespoons minced fresh basil 2 Tablespoons extra virgin olive oil Salt and freshly ground black pepper to taste Preparation: Heat water to boiling and stir in garlic powder....

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

Crystal Reports: Exporting to Excel omits column headershttps://www.joellipman.com/articles/microsoft/excel/crystal-reports-exporting-to-excel-omits-column-headers.html

03 June 2010 headers" on the Excel Format Options when you export the report. Because our report is exported via a web-based system, this extra dialog doesn't appear when our users export their reports. Not that it solved it as only some different headers appeared...

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

Checklist for the local computer repairshttps://www.joellipman.com/hardware/checklist-for-the-local-computer-repairs.html

28 April 2011 Agreement Template Computer Repair Invoice Template Documents: Service Agreement Electronic Newsletter Business Cards Extra RAM (to charge for) Extra Cables (again to charge for) Service: Software installs at flat price Website development per hourly...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

MS-DOS: Copy folders without overwriting fileshttps://www.joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

23 February 2014 given names/paths. /XC :: eXclude Changed files. /XN :: eXclude Newer files. /XO :: eXclude Older files. /XX :: eXclude eXtra files and directories. /XL :: eXclude Lonely files and directories. /IS :: Include Same files. /IT :: Include Tweaked files....

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

AutoHotkey: Get Media Information and Displayhttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-get-media-information-and-display.html

07 August 2020 could have tried out some cool new DLL files for MS Windows 10 but we needed something lightweight that doesn't require any extra files and that could work on MS Windows 7 (32-bit) for this particular app. For this reason, we are going to use a function...

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

Pancakeshttps://www.joellipman.com/articles/_other-misc/pancakes.html

07 July 2009 in half again to form triangles, or else simply roll them up. Serve sprinkled with a little more sugar and lemon juice and extra sections of lemon.

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

Installing phpBB3 for Joomla with a RocketTheme templatehttps://www.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

28 September 2009 system privileges such as "drop table"). Upload the compressed file to your http://www.mysite.com/ web root folder and extract the zip to it (it should create a http://www.mysite.com/phpBB3 folder). If you don't have shell access, you can decompress the...

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

Anti-Spam override for all submitted datahttps://www.joellipman.com/articles/cms/joomla/anti-spam-override-for-all-submitted-data.html

03 February 2010 certain components of Joomla let you put banned words but I know of even more that don't. If you find all your forms need extra plugins and captchas (such as JezRecaptcha), then the website security isn't amazing. I used to have Captcha on my K2 by...

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

Creating a Profile Plugin for Joomla 1.6https://www.joellipman.com/articles/cms/joomla/creating-a-profile-plugin-for-joomla-16.html

27 April 2011 : All ini files need to be saved as UTF-8 PLG_USER_PROFILE5_XML_DESCRIPTION="User Profile Plug-in by JoelLipman.Com to add extra fields to the user forms." PLG_USER_PROFILE5="User - Profile - JoelLipman.Com" PLG_USER_PROFILE5_SLIDER_LABEL="User Profile...

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

List MediaWiki Articleshttps://www.joellipman.com/articles/cms/mediawiki/list-mediawiki-articles.html

22 September 2011 do I want? Page ID, Title, Content, Category, AccessLevel (note that AccessLevel is extra to your standard MediaWiki setup and one that was customized for my day job). Thought I already had this somewhere on my site, so it took a while again but I've...

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

Fun with DllCall in AutoHotkeyhttps://www.joellipman.com/articles/automation/autohotkey/fun-with-dllcall-in-autohotkey.html

27 September 2011 do out there. If you're the type of AutoHotkey programmer that doesn't like having to use the command prompt to write to an extra text file which your program has to read, then this is for you. DllCall will usually run contained in the program and can...

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

Client Services: Website Development Agreementhttps://www.joellipman.com/static-items/client-services-website-development-agreement.html

15 November 2013 necessarily match my skillset. My associates only get involved when something goes unexpectedly wrong and I do not have the extra time to allocate. They will do the investigative work to get the service up and running again. Having a small...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

SSRS: Performance Improvements: SELECT TOPhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-performance-improvements-select-top.html

07 March 2014 interested in the fact that 0.4 Microsoft seconds seems to translate to about 10 minutes in the real world. Where do the extra 9 minutes come from? Not the SQL as this runs in 00:00 seconds in SQL Server Management Studio. Not the internal processing...

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

Migrating from Joomla 2.5.x to 3.4.xhttps://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

12 September 2015 Weblinks 3rd-party: JComments Here's a less brief outline of the whole process: Pre-Notes: To begin with, ensure that no extra new users are created in the v34 system other than the user who is installing it. Preparation: Backup your Joomla v2.5.x...

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

Foreign Characters create symbols in PHP and MySQLhttps://www.joellipman.com/articles/web-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

25 January 2016 to posting HTML forms: accept-charset="utf-8" Conclusion: The final fix in my case was due to me not specifying some extra parameters on the htmlentities or htmlspecialchars PHP functions. My database stored the foreign characters as they were so the...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Display Feeds to major Social Networkshttps://www.joellipman.com/articles/web-development/display-feeds-to-major-social-networks.html

16 May 2016 Why? There are 3rd-party apps that let you do this, some paid, some not. This was for a staff portal so I wanted this at no extra cost. This is read-only so actual editing of the feed would be done on the respective social network's site. How: This...

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