Assuming thought is required, the following 66 results were found.
-
to your code. This will not display a character but is a new line... Used in certain cases v_NewLineChar = hextoText("0A"); Thought I needed to add the following but this makes absolutely no difference: f_CSVFile.setCharSet("UTF-8");...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
products you have in your shop, it will stop when it's reached the end of the list as per eBay and not what you might have thought it was. /* Function: fn_GetEbayActiveProducts() Purpose: Queries eBay for all active listings Date Created: 2023-03-01...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
of a HR system. This is intended to work using Zoho Deluge. How? There are a number of combinations that I won't have thought of but the below code sufficed for my current task, common English and some European names: // // set first and last name...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
SO" = so."Sales order ID" LEFT JOIN "Sales Order Items" soi ON so."Sales order ID" = soi."Sales order ID" Initially we thought we could take the purchase order by simply going through the comments but this only shows Purchase Orders raised from a Sales...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
So I thought I'd 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...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Inventory
- Language: *
-
to remove a key from a map. In this case, the ID key and value pair. It would then tell me the list was null when I thought I was adding the map with the ID removed back into a list. The map itself was null. How? We are using an API action called...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
A frustrated article about an issue that took me a fair few hours to resolve. So I'm putting it here as I thought I covered this previously but couldn't find it on my website. This was previously titled something along the lines of truncating to 2...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
me a while to get the right syntax for writing to the invoice line items as well as setting the value of lookup fields so I thought it was worth an article and may help someone else (or even myself) in the future. At time of print (9th October 2025),...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
Thought I already had an article on this and I know my article Zoho Deluge - Connect to Xero API covered a quick query to pull some invoices but this one documents a pull and mapping into CRM invoices. Why? This took me a whole afternoon so I wanted a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
- along with their Contacts and Items (accounts/contact & products respectively). Why? This took me so much longer than I thought it would. It was meant to be based on the pull from invoices article I wrote earlier but with quotes from Xero, things...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
You can probably find this information of the rocket theme forum but I thought I'd put how I resolved this here. The issue is basically that you want the background to stay in its position in the browser while the rest of the elements scroll about. Go...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
This took me a while to do so I thought I'd document it for future reference. The Issue See the restore default setting link at the bottom of this page in the footer? I wanted to put one of the styled buttons behind it but then found that there's a lot...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
Thought I'd put this error in here and how I fixed it. Basically because firstly I don't want to have to create an account on someone else's forum just to post my answer and secondly because my solution is a "cowboy fix" rather than the other...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
middle of writing a component that will hopefully comprise bug-tracking and download management all in one. Until then, I thought I'd STFW (google) this issue and post a solution considering that even RocketTheme don't want to share this solution unless...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
Thought I'd add the migration script I've been using to test my JComments migration from my Joomla CMS site version 1.5.20 to Joomla CMS site version 2.5.6. DISCLAIMER I do not work for either Joomla or JoomlaTune (Jcomments) This script is provided as...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
unaffected, the site was restored to satisfaction... not bad for an hours work. So I've heard it mentioned before, never thought much of it, but now I know. The lesson here is simply to Update the Joomla Core separately and prior to any 3rd-party...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
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 posted my finished query here: The base query to...
- Type: Article
- Author: Joel Lipman
- Category: MediaWiki
- Language: en-GB
-
Thought I'd put a note on how to remove the toolbar using the URL as I didn't find this clear on the net. Tried it and it didn't work. That's because I was using the Reporting Manager URL rather than the Reporting Server URL. Note: Change "" to the name...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Server (TFS VS2010) and connecting to an Oracle database (ie. "seamless integration because our setup is perfect and well thought through" not - note the DBMS is not hugely relevant for the purposes of this article). The end-user must be able to search...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
can just click on this link and it would take them to http://ora-00201.ora-code.com/. The Padding Found this in a forum so thought I'd better make a note: Right("00000" & Fields!ERROR_CODE.Value.ToString, 5) -- "Right()" to say extract text from the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *