Zoho Creator: Receive eBay Order Notifications via Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-receive-ebay-order-notifications-via-webhook.html

20 September 2021 m_Params.put("WarningLevel","High"); m_Params.put("ErrorLanguage","en_GB"); // // convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params = x_Params.toString().replaceFirst("","");...

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

T-SQL: Parse an XML valuehttps://www.joellipman.com/articles/else/database/t-sql/t-sql-parse-an-xml-value.html

27 March 2014 need to surround with brackets and append a [1] as per the above example. Retrieving nodes -- to get all below nodes from root node - STAFF SELECT Event_XML.query('/STAFF') FROM [dbo].[XML_EVENTS] -- to get all element nodes named 'EMPLOYEE_NUMBER'...

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

Win32 Constantshttps://www.joellipman.com/component/content/article/win32-constants.html?catid=48&Itemid=165

05 July 2011 Const LVN_SETDISPINFOA = (LVN_FIRST-51) ;#end region ;#region Drive Type Const DRIVE_UNKNOWN = 0 Const DRIVE_NO_ROOT_DIR = 1 Const DRIVE_REMOVABLE = 2 Const DRIVE_FIXED = 3 Const DRIVE_REMOTE = 4 Const DRIVE_CDROM = 5 Const DRIVE_RAMDISK = 6 ;#End...

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

Registered Users Cannot Login - Super Users Canhttps://www.joellipman.com/articles/cms/joomla/registered-users-cannot-login-super-users-can.html

26 February 2014 and a quick scan in the assets table revealed 3 assets had the parent_id = 0. Only one asset can have that and that is "root". Login to your Joomla database using your MySQL database manager (eg. phpMyAdmin, MySQL Workbench) Open the #__assets table...

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

Prefix Line Numbers in a Text Filehttps://www.joellipman.com/component/content/article/prefix-line-numbers-to-a-text-file.html?catid=51&Itemid=165

18 July 2012 on a text file: Open the system registry (Start > Run... > Type "REGEDIT" > OK) Navigate to My Computer\HKEY_CLASSES_ROOT\txtfile\shell Right-click on "shell" and create a new key with the action name (eg. "Prefix_with_line_numbers") Right-click on this...

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

Zoho Creator: Create a Widget which uses JavaScripthttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 to make changes to your Certificate Trust Settings: You should get the following page open in your browser which is the root folder of your app: In the browser url, type https://127.0.0.1:5000/app/widget.html, your browser page should now display...

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

Warning: Save failed. Another menu item has the same aliashttps://www.joellipman.com/articles/cms/joomla/warning-save-failed-another-menu-item-has-the-same-alias.html

13 March 2015 resolving a menu item alias conflict: Warning Save failed with the following error. Another menu item has the same alias in Root. Root is the top level parent You will need: Access to the Joomla Administration Panel (to check for and remove expired menu...

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

Protecting your Joomla Administrator Sectionhttps://www.joellipman.com/articles/cms/joomla/protecting-your-joomla-administrator-section.html

23 October 2015 But just in case you don't have one, let me do this in two stages. Move the /administrator URL Create a folder in the root of your joomla website with a name that is difficult to guess but easy to memorise. Create a file called index.php in the folder...

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

Upgrading Joomla CMS version 3.x to Joomla CMS 5.xhttps://www.joellipman.com/articles/cms/joomla/upgrading-joomla-cms-version-3-x-to-joomla-cms-5-x.html

04 February 2025 > Manage Extensions > com_akeebabackup > Uninstall: Joomla\CMS\Filesystem\Folder::delete: Path is not a folder. Path: [ROOT]/administrator/components/com_akeebabackup Joomla\CMS\Filesystem\Folder::delete: Path is not a folder. Path:...

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

Migrate MediaWiki to another serverhttps://www.joellipman.com/articles/cms/mediawiki/migrate-mediawiki-to-another-server.html

23 September 2009 Old Server mysqldump -u root -p wikidb > wikidb.sql tar -cvf wiki.tar wiki ;this is the wiki folder on document root New Server: create database wikidb; this is inside mysql, Note that both mysql versions should be same. grant create, select, insert,...

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

Alternative method of displaying Unicode in Autohotkey GUIhttps://www.joellipman.com/component/content/article/alternative-method-of-displaying-unicode-in-autohotkey-gui.html?catid=48&Itemid=165

29 September 2011 equal to 248 F8 U+00B0 ° degree sign 249 F9 U+2219 ∙ bullet operator 250 FA U+00B7 · middle dot 251 FB U+221A √ square root 252 FC U+207F ⁿ superscript latin small letter n 253 FD U+00B2 ² superscript two 254 FE U+25A0 ■ black square 255 FF U+00A0...

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

Joes Quicklist Weblinks (JQW)https://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=53&Itemid=165

03 July 2011 weblinks" module Set the permissions to view this new module as "Super Users" or "Special". Set the category of weblinks to "Root" or "Uncategorized". Switch "STOP Thumbnail Service" to NO on the restricted module. Keep refreshing the module until all...

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

Zoho Creator / eBay: Get all Active Productshttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-ebay-get-all-active-products.html

13 October 2021 l_OutputFields.add("TotalNumberOfEntries"); m_Params.put("OutputSelector",l_OutputFields); // // convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params =...

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

Zoho Creator: eBay: Get Item Transactionhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-ebay-get-item-transaction.html

22 January 2022 //m_ActiveList.put("Sort","ItemID"); m_Params.put("ItemID",p_ItemID); // // convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params = x_Params.toString().replaceFirst("",""); // //...

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

Zoho Inventory & eBay Picture Services: UploadSiteHostedPictureshttps://www.joellipman.com/articles/else/e-commerce/ebay/zoho-inventory-ebay-picture-services-uploadsitehostedpictures.html

31 March 2022 m_Params.put("PictureName","OhBeautifulMe"); m_Params.put("PictureSet","Supersize"); // // convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params =...

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

ZohoCRM: Import Attachmentshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-import-attachments.html

16 January 2023 must be a zip of the folder "Attachments" (with capitalized "A") and have no subfolders with all files in the root. File not found. Please check the attachment ID.: The Attachment ID column must contain the unique field names. File name column can...

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

ZohoDeluge: Get All eBay Orders Given a From and Till Datehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zohodeluge-get-all-ebay-orders-given-a-from-and-till-date.html

28 February 2023 m_Params.put("CreateTimeTo",v_timeTill); m_Params.put("OrderRole","Seller"); // // convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params = x_Params.toString().replaceFirst("","");...

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

ZohoCRM: Get All eBay Active Listingshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-get-all-ebay-active-listings.html

01 March 2023 m_ActiveList.put("Pagination",m_Pagination); // m_Params.put("ActiveList",m_ActiveList); // // convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params =...

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

Zoho Deluge: Get All Orders from eBayhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-all-orders-from-ebay.html

29 March 2023 m_Pagination.put("EntriesPerPage",v_PerPage); m_Params.put("Pagination",m_Pagination); // // convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params =...

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

ZohoCRM Webhook: Create ZohoInventory Records from an eBay orderhttps://www.joellipman.com/articles/crm/zoho/zoho-inventory/zohocrm-webhook-create-zohoinventory-records-from-an-ebay-order.html

27 April 2023 l_OrderIDs.add(m_OrderID); m_Params.put("OrderIDArray",l_OrderIDs); // // convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params = x_Params.toString().replaceFirst("",""); // //...

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