Merge the content of two similar tables in MySQLhttps://joellipman.com/articles/database/mysql/merge-the-content-of-two-similar-tables-in-mysql.html

11 January 2011 1 Welcome This is Joomla 2 Copyright This site and its design is property of JoelLipman.com HP Articles (table name: jos_hp_items): id name description -------------------------------------------------------------------------- 1 Welcome This is HP 2...

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

XML Schema Referencehttps://joellipman.com/articles/web-development/xml/xml-schema-reference.html

13 August 2014 of decimal places allowed. Must be equal to or greater than zero length Specifies the exact number of characters or list items allowed. Must be equal to or greater than zero maxExclusive Specifies the upper bounds for numeric values (the value must be...

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

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

13 October 2021 m_Params.put("ErrorLanguage","en_GB"); m_Params.put("DetailLevel","ItemReturnCategories"); // // include fixed price items m_ActiveList = Map(); m_ActiveList.put("Include","true"); m_ActiveList.put("ListingType","FixedPriceItem"); m_Pagination = Map();...

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

Zoho CRM & Zoho Inventory: Upload Image to Item Record using Delugehttps://joellipman.com/articles/crm/zoho/zoho-crm-zoho-inventory-upload-image-to-item-record.html

21 June 2022 to Zoho m_Params = Map(); m_Params.put("image",r_DownloadedPhoto); // // generate endpoint v_Url = "https://books.zoho.eu/v3/items/" + v_InventoryId + "/images?organization_id=" + v_BooksOrgId; // // updload the photo r_UploadPhoto = invokeurl [ url...

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

GDPR Privacy Policyhttps://joellipman.com/static-items/gdpr-privacy-policy.html

14 February 2019 takes no responsibility and assumes no liability for any content posted by you or any third party. Risk of Loss All items purchased from JoelLipman.com are made pursuant to a shipment contract. This means that the risk of loss and title for such items...

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

MySQL parameters in Excel 2007 PivotTableshttps://joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 Services? Yes by far. Fast, quick to setup and a big fat refresh button for the executives. SQL query returns individual items while Excel allows drag and drop grouping/drilldown pivot tables. Have managed to get this working with SQL Server, Oracle and...

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

SSIS: How to loop through multiple flat files as data sourceshttps://joellipman.com/articles/microsoft/ssis/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html

13 June 2014 ssis toolbox - if you do not see it when you are under the "Control Flow" design tab, then select Tools > Choose Toolbox Items > SSIS Control Flow Items > Tick the "For Each Loop Container") Add the Data-Flow to the container (or drag into the container...

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

Zoho CRM/Creator - Common Errors & Gotchashttps://joellipman.com/articles/crm/zoho/zoho-crm-creator-common-errors-gotchas.html

06 February 2020 the payload is empty which is not true in my case. This is my invokeUrl: v_DataEndpoint = "https://inventory.zoho.com/api/v1/items?organization_id=123456789"; r_Response = invokeurl [ url :v_DataEndpoint type :POST parameters:m_CreateRecord...

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

Zoho Creator: Button on Report for Merging Multiple Selected Recordshttps://joellipman.com/articles/crm/zoho/zoho-creator-button-on-report-for-merging-multiple-selected-records.html

06 December 2020 the selected (ticked) records. The example below documents a report of Quotes where we want to merge all the product line items of each quote into one single quote. Why? I've written this article because I keep forgetting on how to do this. I have a...

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

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

31 March 2022 application mode) Then go to Setup > Connections > Add Connection Select Zoho OAuth and specify the scope(s) ZohoInventory.items.READ (add some more if you're unsure...) Give it a connection name and note down the connection link name. I'm calling mine...

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

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

27 April 2023 on ebay item specific - Add stock in order to authorize payment creation Date Modified: 2023-02-02 (Joel Lipman) - Marked Items as inclusive of VAT so VAT reports in Books will be accurate (eg. £499.95 is correctly £416.62) Date Modified: 2023-02-23...

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

Zoho Inventory: Enable Tracking using the APIhttps://joellipman.com/articles/crm/zoho/zoho-inventory-enable-tracking-using-the-api.html

04 May 2023 update or create request m_CreateBooksItem = Map(); m_CreateBooksItem.put("name",v_ItemTitle); m_CreateBooksItem.put("sku",v_ItemSKU); m_CreateBooksItem.put("rate",v_ItemPrice.toDecimal()); // // key here to enable inventory tracking...

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

Zoho Books: Get Invoice Payment Terms via APIhttps://joellipman.com/articles/crm/zoho/zoho-books-get-invoice-payment-terms-via-api.html

06 July 2023 displays "Net 56" instead. m_InvoiceDetails.put("payment_terms_label","Due end of next month"); // // loop through line items and populate for each m_SOLineItem in l_SalesOrderLineItems { m_InvoiceLineItem = Map(); m_InvoiceLineItem.put("item_id",...

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

Zoho Inventory Template Issue: First Page is Blankhttps://joellipman.com/articles/crm/zoho/zoho-inventory-template-issue-first-page-is-blank.html

15 November 2018 write an article to help me resolve the particular issue where the organization details and the header of the product line items table would display on the first page, the product line items would then print on the second page, with the terms and...

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

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

25 September 2009 that in my test, there was only 1 user (me). There are reports though that some people set up websites with NO 3rd-party items whatsoever... For those of you with this issue, I'd double-check your website host allows Joomla and if they don't, look for...

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

Is it a scam? Gumtree.com's warning signshttps://joellipman.com/hardware/is-it-a-scam-gumtreecoms-warning-signs.html

12 October 2010 Cheque overpayment. A buyer, prospective tenant or even an employer will send you a cheque worth more than the value of the items/rent/job. They’ll then ask for the surplus money to be returned to them or a third party, for example ‘to pay for...

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

Passwords: Did-you-knowhttps://joellipman.com/hardware/passwords-did-you-know.html

15 November 2010 following is a list of items I use to include on password checker pages: A program called LC4 (formerly L0phtCrack) used by governments and the military boasts being able to crack 90% of user passwords in under 48 hours on a Pentium II/300....

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

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

29 March 2011 like: =IIF(Sum(Fields!Counter.Value, "Equipment")>0, True, False) If you're bugged by the warning "Overlapping report items are not supported in all renderers" then I'd suggest you use method #1. Issues I ran into: I replaced the empty dataset with the...

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

Win32 Constantshttps://joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 = 2 ;#End Region ;#Region ListView Messages Const LVM_FIRST = $1000 Const LVM_GETSUBITEMRECT = (LVM_FIRST + 56) Const LVM_GETITEMSTATE = (LVM_FIRST + 44) Const LVM_GETITEMTEXTW = (LVM_FIRST + 115) ;#End Region ;#Region Header Control Messages Const...

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

Excel PivotTable Filter List Orderinghttps://joellipman.com/articles/microsoft/excel/excel-pivottable-filter-list-ordering.html

05 September 2011 (or name of field) from the dropdown. (NOTE the "More Options" button) Click on OK to sort the values Note: Office 2010: If items did not sort, then remove the column from the PivotTable altogether, hit the Data Refresh button Add the column back to the...

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