Zoho Inventory: Mark a package slip as delivered and shippedhttp://mail.joellipman.com/articles/crm/zoho/zoho-inventory-mark-a-package-slip-as-delivered-and-shipped.html

14 July 2022 + l_UrlParams.toString("&"); r_CreateShipment = invokeurl [ url :v_Url type :POST parameters:m_Params.toString() connection:"jl_inventory" ]; info "Created Shipment: "; info r_CreateShipment; if(r_CreateShipment.get("shipment_order") != null) {...

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

Zoho Deluge: Shopify API: Get all active products with GraphQL and Paginationhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-shopify-api-get-all-active-products-with-graphql-and-pagination.html

20 February 2023 v_Endpoint = "https://" + v_ShopID + "/admin/api/" + v_ShopifyApiVersion.toString() + "/graphql.json"; // // set header parameters m_Header = Map(); m_Header.put("Content-Type","application/json"); m_Header.put("X-Shopify-Access-Token",v_AccessToken);...

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

Zoho Books: Error 7008: There are no contact persons associated with this Invoicehttp://mail.joellipman.com/articles/crm/zoho/zohobooks-error-7008-there-are-no-contact-persons-associated-with-this-invoice.html

07 March 2024 formed - Encountered when trying to use the send an invoice API - Was sending to_mail_ids in the URL instead of the body parameters ******************************************************************************* */ v_BooksOrgID = "12345678901";...

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

ZohoCreator: Basic Widget with Zoho Datahttp://mail.joellipman.com/articles/crm/zoho/zohocreator-basic-widget-with-zoho-data.html

14 March 2024 Initialize var v_ShopifyID = ""; var v_ShopifyEmail = ""; var v_GreetingName = ""; // Try and catch try{ // Get Creator Parameters Passed in URL - Cannot use window.location URL var queryParams = ZOHO.CREATOR.UTIL.getQueryParams(); // Check parameters...

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

Zoho Deluge and Wordpress/WooCommerce API: Get All Productshttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-and-wordpress-woocommerce-api-get-all-products.html

15 April 2024 v_ConsumerSecret = "cs_555566667777888899990000aaaabbbbccccdddd"; // // connection parameters l_ConnectionParams = List(); l_ConnectionParams.add("consumer_key=" + v_ConsumerKey); l_ConnectionParams.add("consumer_secret=" + v_ConsumerSecret); // // get...

• 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 value is by single-quotes. m_Params.put("criteria","\"SO ID\"='" + v_SalesOrderID + "'"); m_Config = Map(); // sometimes parameters need to be a string... but this is working m_Config.put("CONFIG",m_Params); v_Endpoint =...

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

Zoho CRM: Remove Duplicate Product Recordshttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-remove-duplicate-product-records.html

07 March 2025 + " offset " + v_Offset}; r_CoqlUniqueProducts = invokeurl [ url :"https://www.zohoapis.eu/crm/v7/coql" type :POST parameters:m_Params.toString() connection:"zcrm" ]; l_UniqueProducts = ifnull(r_CoqlUniqueProducts.get("data"),List()); for each m_Product...

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

Zoho CRM: JS Widget: Generic Script to pass the Record ID to a CRM functionhttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-js-widget-generic-script-to-pass-the-record-id-to-a-crm-function.html

18 August 2025 the function name to be called (don't include the namespace) var v_FuncName = "fn_Accounts_GetCreditSafe"; // Prepare the parameters for the function call var m_Params = { "arguments": JSON.stringify({ "p_AccountID": v_EntityID }) };...

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

Frontpage Item Orderinghttp://mail.joellipman.com/articles/cms/joomla/frontpage-item-ordering.html

16 September 2010 is that it is within the menu manager > main menu > menu item section of your Joomla! Admin Panel. Certain Advanced Parameters in your Menu Item called "Home" must be set correctly for the article ordering you set in your Front Page Manager to take...

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

SSRS Subscriptions cannot be createdhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-subscriptions-cannot-be-created.html

22 November 2013 shared data source which stores the credentials, ie. A sql authenticated user with read-only privileges. The report has 4 parameters, two of them use the default values (from and to date range) and two use specified values (setup in the subscription...

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

Change default order of weblinkshttp://mail.joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

15 November 2009 how to do this via the admin back-end panel in the advanced configuration... I can't see this panel, there is no advanced parameters under a weblinks category. The issue is that suppose a menuitem links to a category of weblinks, the default sort order...

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

Joes Word Cloud (JWC)http://mail.joellipman.com/component/content/article/module-joes-word-cloud-jwc.html?catid=40

13 October 2010 Panel > Extension Manager View the module on your front-end to see if it does what you want it to do. Modify the module parameters as necessary. Setup First of all, you need to make it visible. These 3 steps will have your module ready: The further...

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

The ReportServer Databasehttp://mail.joellipman.com/articles/database/the-reportserver-database.html

08 August 2011 a report as a user. Format nvarchar(26) NULL This is the rendering format. Mostly RPL if viewed in MS Internet Explorer. Parameters ntext NULL Parameters and the values they were submitted with. TimeStart datetime NOT NULL Time report started to run....

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

Basic Oracle Function Structurehttp://mail.joellipman.com/articles/database/pl-sql/basic-oracle-function-structure.html

15 January 2012 all with the aim to improve performance on some SSRS queries which accept either an ID number or an AD name as user parameters. Syntax: CREATE [OR REPLACE] FUNCTION function_name [ (parameter [,parameter]) ] RETURN return_datatype IS | AS...

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

Joomla article modal with clear buttonhttp://mail.joellipman.com/articles/cms/joomla/joomla-article-modal-with-clear-button.html

27 August 2012 below script. Why? The article modal is a much easier way for the end-users to select a Joomla! article in the component parameters/options. The "clear" button is essential as some article_modal fields may not be required and are difficult to clear once...

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

Search a database for a string (MySQL, T-SQL)http://mail.joellipman.com/articles/database/search-a-database-for-a-string-mysql-t-sql.html

08 October 2012 GO CREATE PROCEDURE usp_SearchDB @Tablenames VARCHAR(500) ,@SearchStr NVARCHAR(60) ,@GenerateSQLOnly Bit = 0 AS /* Parameters and usage @Tablenames -- Provide a single table name or multiple table name with comma seperated. If left blank , it will check...

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

Export/Import Database using MySQL Workbenchhttp://mail.joellipman.com/articles/database/mysql/export-import-database-using-mysql-workbench.html

05 February 2013 happens under the Server Administration section: Let's create a Server Instance, I'm going to specify the Take Parameters from Existing Database Connection option (note that I have obscured my personal settings in the following screenshot): In this...

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

Autohotkey Count Number of Files/Folders in a Directoryhttp://mail.joellipman.com/articles/automation/autohotkey/autohotkey-count-number-of-files-folders-in-a-directory.html

04 June 2013 - FileCount TotalFileCount += FileCount TotalFolderCount += FolderCount } Method #3: Standard Function with Loop -- input parameters: -- -- Folder=folder/file pattern. -- -- Subfolders=1 or 0 (recurse into subfolders or not) SC_Load(Folder, Subfolders){...

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

A quick run through of setting up an export process in SITShttp://mail.joellipman.com/articles/web-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

21 August 2014 SITS application audit giving details on each process. Stu-Talk Monitor Process (SMP): Counts the DOTs with date range as parameters. Stu-Talk Monitor Summary (STMS): Specify a SMG, date range and it will give you an overview of the DOT, EOT, TOT, TIN,...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

Joes Youtube Plugin (JYP) Downloadshttp://mail.joellipman.com/component/content/article/joes-youtube-plugin-jyp-downloads.html?catid=92

07 September 2015 Class Suffix - Added Joomla Admin Panel option: Border Color - Added Joomla Admin Panel option: Border Style - Fixed parameters to display as saved (Was saving but not showing). - Date Uploaded: Thu, 17th Feb 2011 1.0.2- Added Joomla Admin Panel option:...

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