Search - Joel Lipman .Com

1. Import Excel CSV file as JavaScript array: / Excel /; What I have: A CSV file exported from Excel along with double-quotes label1,label2 item1a,item2a item1c,"item2c,c" item1b,item2b What I want: To read the file (stored on the server) and ...; Created on 05 October 2015
2. Export/Import Database using MySQL Workbench: / MySQL /; What? This article isn't unique as there are other tutorials out there. This is meant to detail a process to export a database using MySQL Workbench and then to import it into another database. Why? ...; Created on 05 February 2013
3. Importing Joomla articles to WordPress posts: / Wordpress /; ... comment_count FROM my_joomla_db.jos_content ORDER BY id Importing the joomla categories to Wordpress: (still to do: sections as parent categories?) SET @CountCategoriesAlreadyEntered:=(SELECT ...; Created on 16 August 2011
4. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; ... the value of each radio item will be populated using deluge and what's important to note here is that each picklist/dropdown option includes some HTML, specifically a SPAN tag surrounding the date number ...; Created on 09 March 2022
5. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; What? This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify. Why? Previously, we would receive an eBay notification and create an ...; Created on 21 January 2022
6. Zoho Analytics: Setup DataSource via FTP Connection: / Zoho /; ... client who wants to import data via FTP (SFTP - to be precise) and have this available to their Zoho apps. My aim(s) are: Setup recurring FTP connection. Make data readily available to ZohoCRM. ...; Created on 12 January 2022
7. Zoho Creator: Change Radio into Tabs: / Zoho /; What? This is an article to serve as a guide in terms of styling a radio group into a group of Tabs. This is only a guide or reference which was applied for one client but would need adapting to match ...; Created on 22 October 2021
8. Zoho CRM: Upload a Product Photo using Deluge: / Zoho /; ... set the param name to file (this is important) r_CreatorPhoto.setParamName("file"); // // upload the photo to CRM (and prevent workflows from running) v_Endpoint2 = "https://www.zohoapis.com/crm/v2/Products/" ...; Created on 27 September 2021
9. Zoho Creator: Two submit buttons on a non-stateless form with 2 different redirects: / Zoho /; ... Standard as for any usual form without a redirect. Drag a decision box field on to the form; we are calling ours "Save & Close" with the field link name as "Save_and_Close" (the field link name is important ...; Created on 27 July 2021
10. Zoho Creator: Receive JSON via a Shopify Webhook: / Zoho /; ... it Shopify - Webhook - Order Update Specify the Category, I'm going to say Standalone Specify the Function parameters/Arguments EXACTLY as this: crmAPIRequest of data type string. IMPORTANT! It won ...; Created on 15 July 2021
11. Zoho CRM: Update a custom field in line items / product details using REST API v2.1: / Zoho /; ... The important fields I wanted were some custom fields within the line items subform. Here I'm adding the parameters to ensure we get CRM records that are also pending approval or being converted. m_Params ...; Created on 17 May 2021
12. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... . p_LeaveTill this is the value of "To" on the "Leave" form. Giving you something as per the following screenshot: Click on "Save" to accept this Note: It is important to add these parameters rath ...; Created on 10 December 2020
13. Zoho Creator: Button on Report for Merging Multiple Selected Records: / Zoho /; ... your action item Name the workflow Execute the action for Collection of record (this step is very important!) And you should have something like the following: Click through on "Add New Action": ...; Created on 06 December 2020
14. Zoho Creator: Set Up Custom Domain for Customer Portal: / Zoho /; ... to instruct the client. I use CNAME as I find it easier and it is a step we need for Zoho on their side. Important: You should now have at least 2 CNAME records against this domain/subdomain. I ...; Created on 17 November 2020
15. Zoho Creator: info/alert/modal/popup notification for any user: / Zoho /; What? So I thought I'd write a quick article to remind me and to develop a simple notification system that will popup for any user on the submit of a form, or on the click of a button or on the click ...; Created on 06 November 2020
16. COVID-19: Working from Home: / Articles /; Ergonomic adjective "relating to or designed for efficiency and comfort in the working environment." So it's pretty important not to be slouching over the coffee table for hours or days on end. I ...; Created on 05 July 2020
17. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... download the file into cache r_FileDownload = invokeurl [ url :v_FileDownloadUrl type :GET ]; // // Important: use setParamName on the response r_FileDownload.setParamName("attachment"); // // ...; Created on 15 May 2020
18. MS Excel - Open CSV with Long Numbers: / Excel /; ... each column: 1. Specify that the data is delimited 2. Specify the data is delimited by commas 3. Specify which columns should be imported as text (the long numbers and phone numbers) ...; Created on 23 July 2019
19. AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktops: / AutoHotkey /; ... will open your applications in explorer (much like MacOS). You can then create shortcuts from these and more importantly see the command to open them. Note that the MS Windows 10 Mail shortcut will be ...; Created on 18 July 2019
20. MS Excel - Split Workbook into separate files per sheet: / Excel /; ... size of about 11Mb. In order for an import process to work, the import would only accept XLS files no greater than 1Mb. So our script has to split a single spreadsheet into multiple worksheets of 3000 ...; Created on 11 February 2019