Assuming each is required, the following 200 results were found.
-
accept XLS files no greater than 1Mb. So our script has to split a single spreadsheet into multiple worksheets of 3000 rows each, and then output each sheet to a separate file that is formatted as XLS (Not *.xlsx). How? In summary, we are going to move...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
a quick article if you get the above error and what to look for. Why? I was writing a function with perhaps too many for each loops within a for loop. How? The following is 1 fix for the error: Execution Failed UnPredictable exception, Invalid statement...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
public class ScriptMain : UserComponent { // Method that will be started for each record in your dataflow public override void Input0_ProcessInputRow(Input0Buffer Row) { // C# alternative for VB.Net StrConv uses cultureinfo and threading // See:...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
you have a few hundred records, or a few hundred thousand records, we sometimes want to write a function that will check each record and mark it so that the process doesn't repeat on records that have already been checked. Some solutions have worked in...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
(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 specific order...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Part 2 is dedicated to content migration, the commands are split to do about 5000 articles on each iteration so as to avoid session timeouts and memory issues. Edit the script, renaming the database and table names used (DO NOT CONFUSE THE FOLLOWING...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
Licence GNU/GPLhttps://joellipman.com/static-items/licence-gnugpl.html
kinds of works, such as semiconductor masks. “The Program” refers to any copyrightable work licensed under this License. Each licensee is addressed as “you”. “Licensees” and “recipients” may be individuals or organizations. To “modify” a work means to...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
matched ID of the Sales Order in CRM r_CreatorForm = myForm[ID == myRecordID]; if(!isnull(r_CreatorForm.Attachments)) { for each row in r_CreatorForm.Attachments { r_AttachFile = zoho.crm.attachFile("CustomModule5004",v_CrmSoID, row.myUpload); } } //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
in November at 2:00 v_LastMonthDate = toTime(zoho.currentdate.toString("yyyy") + "-11-01 02:00:00"); // // loop through each day in a week to get the start and end dates for each v_DayIndex in {0,1,2,3,4,5,6} { v_CheckDateStart =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
// // reset and set radio group options clear input.Color_Picker; for each l_ColorRow in l_ColorPalette { for each v_ThisColor in l_ColorRow { input.Color_Picker:ui.add(v_ThisColor); } } Step 2: Replace the text with colored boxes //... // // reset and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
1000 hits, so thereafter I have to pay every time someone sees that picture through my site; when I could just go to each website and press the print screen key and save this as an image for FREE. I don't get it. So I wrote a program that does exactly...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
[ url :"https://books.zoho.eu/api/v3/settings/taxes?organization_id=" + v_BooksOrgID type :GET connection:"zbooks" ]; for each r_Tax in r_Taxes.get("taxes") { m_Taxes.put(r_Tax.get("tax_percentage").toString(),r_Tax.get("tax_id")); } // //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
url :"https://www.zohoapis.com/books/v3/settings/taxes?organization_id=" + v_BooksOrgID type :GET connection:"zbooks" ]; for each m_Tax in r_Taxes.get("taxes") { m_Taxes.put(m_Tax.get("tax_percentage").toString(),m_Tax.get("tax_id")); } info m_Taxes; //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
*/ // // initialize v_CountTotal = 0; v_CountUpdated = 0; l_Pages = {1}; v_PerPage = 1; // for each v_Page in l_Pages { l_Deals = zoho.crm.getRecords("Deals", v_Page, v_PerPage, {"cvid":123456000012345678}); for each m_Deal in l_Deals {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
have needed a replacement for the download component managers for Joomla! CMS. I've tried all the following for about a year each and these are my reviews/opinions: Phoca Download Good compatibility and actively developed. Unfortunately hacked on more...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
I've made a function that does this. How? Not sure how else to do this but I simply wrote a function in Zoho Creator for each instance that I knew a HTML entity would be submitted. So it doesn't decode every HTML in existence, only the ones I know will...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
function in CRM and to sort the results response. Why? This is unclear and not always working as coded below since each system (CRM, Creator, Books) seems to interpret this sorting feature differently. This article is an effort to find clear and working...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
name: Starting_Date || type Date) Selected Date (link name: Selected_Date || type Date) The CSS So first of all 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...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
+ "/associate" type :GET connection:"my_connection" ]; //info r_Associated; if(!isnull(r_Associated.get("data"))) { for each r_Data in r_Associated.get("data") { if(!isnull(r_Data.get("id"))) { v_SearchEndpoint =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
The following will run resulting in the error "Number of statement execution limit exceed Line:(10)" but it will info out each number to increment: // l_Loop = " ".leftpad(5000).replaceAll(" ", ",").toList(); // for each index v_Iteration in l_Loop {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *