Zoho Deluge: Today, Tomorrow, Day After but Skip Sundayhttp://www.joellipman.com/articles/crm/zoho/zoho-deluge-today,-tomorrow,-day-after-but-skip-sunday.html

02 November 2021 A very quick article with a snippet of code to get today's date, tomorrow's, and the day after's but it has to skip Sundays. Why? Wanting to create a schedule for availability over the next few days which needs to dynamically change. I am aware of the...

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

SSIS Skip Rows in Excel Source filehttp://www.joellipman.com/articles/microsoft/ssis/ssis-skip-rows-in-excel-source-file.html

04 April 2013 A quick article on how to skip rows or even specify a range to extract from the Excel file when using as the DataSource. Why? If you are simply using a text file as your data source, then the options in the connection manager will let you skip rows and...

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

SSIS Skip Blank Rows in Flat File Sourcehttp://www.joellipman.com/articles/microsoft/ssis/ssis-skip-blank-rows-in-flat-file-source.html

23 April 2013 This is a quick article to remind me on how to skip blank rows when using a Flat file as a data source. I would receive another Microsoft error as clear as mud: Error: The conditional operation failed. Error: SSIS Error Code...

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

Migrate Joomla! 1.5.x to 2.5.x+http://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 most privileges on BOTH databases. -- -- To change the database names used in the below script to the ones you use!!! -- SKIP MIGRATION: -- -- Each section was written so that it could be migrated separate to the rest. -- -- It is recommended to skip...

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

Forum Ruleshttp://www.joellipman.com/static-items/forum-rules.html

31 May 2009 what you were doing was wrong or whether a warning is necessary to explain it to you. If I do not give a warning, I will skip ahead to the next step in the penalty list. Muting - This is where you are not able to talk on the board. You may still view...

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

Proposed Budget i3 PC under £200http://www.joellipman.com/hardware/proposed-budget-i3-pc-under-200.html

26 January 2013 and the verdict is that our workstations need upgrading (it always is). So on a budget (ie. as cheap as possible), we'll skip Windows 8 and wait for Windows 9, but in the meantime we need something that flows as smooth as any other Microsoft product...

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

Split a row into multiple rows based on a column valuehttp://www.joellipman.com/articles/database/t-sql/split-a-row-into-multiple-rows-based-on-a-column-value.html

23 August 2013 hardcode a 1.00 if its confusing. In theory, if you know the shift patterns of an employee, you could enhance the above to skip day-off dates (eg. Saturday/Sunday - the above does not take this into account - my day-job company is a 24/7 business).

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

Zoho Creator: Retrieve record with case-insensitive queryhttp://www.joellipman.com/articles/crm/zoho/zoho-creator-retrieve-record-with-case-insensitive.html

21 November 2019 TEST03 I'm trying to insert a record for a new product if it doesn't exist in the table but if it does exist then to simply skip adding the product. v_Name = "Myproduct1"; // note the lowercase P l_ProductDetails = Product[Product_Name == v_Name];...

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

AutoHotkey: App GUI Listview to Rename Fileshttp://www.joellipman.com/articles/automation/autohotkey/autohotkey-app-gui-listview-to-rename-files.html

08 July 2020 LV_Delete() v_RowCount := 0 GuiControlGet, SelectedDir v_FilesPath := SelectedDir "\*" Loop, Files, %v_FilesPath% { ; skip if file ext is not media if A_LoopFileExt not contains wav,mp3,avi,flv,mkv,mov,mp4,mpeg,mpg,wmv continue ; get name of file...

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

Zoho CRM: Get Unique Values of a Text Fieldhttp://www.joellipman.com/articles/crm/zoho/zoho-crm-get-unique-values-of-a-field.html

08 October 2021 set up a connector as there is plenty of documentation on the Zoho Official Documentation and even on this website so we'll skip to the COQL query. This is what I have: // // build up COQL query v_CoqlQuery = "select distinct Currency from Quotes where...

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

Amazon Kindle: Send PDFs to your Kindlehttp://www.joellipman.com/amazon/kindle/amazon-kindle-send-pdfs-to-your-kindle.html

29 June 2022 your Kindle email address. That’s assuming you are not aware of yours. However, if you know your Kindle email ID, you can skip this part. Else, here is what you need to do. Go to the official Amazon home page that applies to your region. Sign in with...

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

Zoho Books: Generate Bank Text File for Downloadhttp://www.joellipman.com/articles/crm/zoho/zoho-books-generate-bank-text-file-for-download.html

02 October 2023 the file We need to delete this file from the attachments as well as from the system as it contains bank details. You can skip this step if you're not bothered about storing this file on the system. Note that if you use the endpoint to delete the...

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

ZohoCreator: Using .toFile and Uploading to a Creator fieldhttp://www.joellipman.com/articles/crm/zoho/zohocreator-using-tofile-and-uploading-to-a-creator-field.html

25 March 2024 www.zohoapis.com/creator/v2.1/data"+zoho.appuri+"report/"+v_ReportLinkName+"/"+v_RecordID+"/"+v_FileUploadFieldName+"/upload?skip_workflow=['all']"; info v_Endpoint; // // upload the file m_Params = Map(); m_Params.put("file", f_TestFile); // // this...

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

Zoho Analytics: Create a Monitoring System with Imageshttp://www.joellipman.com/articles/crm/zoho/zoho-analytics-create-a-monitoring-system-with-images.html

25 July 2024 uploading into the system stored on your device. A URL (as in an image hosted on another website) can be used so you might skip the first section here where I demonstrate how to upload photos to be hosted by the Zoho Analytics app. Uploading the images...

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

Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttp://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

06 August 2024 record for templates in ZohoSign // NB: if your document is NOT in ZohoSign but is a mail merge template in CRM, then skip this if statement if(v_ZohoSign_DocumentType == "CreditApplication") { v_RequestID =...

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