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

04 April 2013 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 specify column datatypes. You don't get that...

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

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

23 April 2013 Split Task: Check keycolumn is not null and data column is not blank. Derived Column Task: Format keycolumn as per your requirements and use substring on trimmed DataColumn to retrieve each data column. Additional The TRIM in SSIS does not appear to get...

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

Client Services: Website Development Agreementhttps://www.joellipman.com/static-items/client-services-website-development-agreement.html

15 November 2013 This includes keeping the servers up-to-date and running with the latest technologies. You are welcome to find and use your own website hosts with their own support plans and I can help you configure these for the source files (as per my base rate)....

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

ReCaptcha alternative: Integrate PlayThru in JComments 2.3 for Joomla 2.5https://www.joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-for-joomla.html

24 March 2014 'PLAYTHRU'); STEP #4: Set to PlayThru in admin setting We've made the change, now login and set it to PlayThru Login to your Joomla Administration panel Components > JComments > Settings > Layout > CAPTCHA > PLAYTHRU Save the change. STEP #5: Display...

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

ReCaptcha alternative: Integrate PlayThru in JComments 3.0 for Joomla 3.2https://www.joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-3-0-for-joomla-3-2.html

27 April 2014 KCAPTCHA PLAYTHRU STEP #4: Set to PlayThru in admin setting We've made the change, now login and set it to PlayThru Login to your Joomla Administration panel Components > JComments > Settings > Layout > CAPTCHA > PLAYTHRU Save the change. STEP #5:...

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

Thank You!https://www.joellipman.com/static-items/thank-you.html

31 May 2009 Your feedback has been successfully submitted and is much appreciated. This filters through to an account which is checked regularly and you should get a quick response.

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

Batch Process to rename multiple files using Windows DOShttps://www.joellipman.com/articles/automation/ms-dos/batch-process-to-rename-multiple-files-using-windows-dos.html

09 August 2014 This will display all the files to be renamed Return to the notepad (rename.bat) and take out the remark "REM" prefix so your code becomes: @ECHO OFF SETLOCAL ENABLEDELAYEDEXPANSION FOR /f "tokens=*" %%a IN ('dir /b *" (Copy).jpg"') DO ( SET...

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

SITS: Export field code and namehttps://www.joellipman.com/articles/web-development/xml/sits-export-field-code-and-name.html

12 August 2014 both code and name will be blank. -- possibly use "-1|*LookupFailed*" for the error to come through the XSLT but watch your datatypes Notes: We did not find a way to return the code when the lookup failed, only an alternative message "*LookupFailed*".

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

Submit form as a server and not the client with cURLhttps://www.joellipman.com/articles/automation/api-misc/submit-form-as-a-server-and-not-the-client-with-curl.html

20 February 2015 permitted server with a single IP address. How? It's likely that you already know how to submit a HTML form to a server via your Mobile application so the following will only document the process of sending data under the server IP address. We're going...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

Copy a Wordpress Site for Developmenthttps://www.joellipman.com/articles/cms/wordpress/copy-a-wordpress-site-for-development.html

08 March 2015 and just for myself to quickly modify a Wordpress configuration file. // ** MySQL settings - You can get this info from your web host ** // /** The name of the database for WordPress */ define('DB_NAME', 'my_database_name'); /** MySQL database username...

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

Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttps://www.joellipman.com/articles/web-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

28 March 2015 data into an XML array and use the built-in PHP function: "json_encode". How? So here's what I tried and ended up with: If your XML is UTF-8 This is the basic code and will work to fetch some XML and return it in JSON formatting as long as the XML is...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Joes Quicklist Weblinks (JQW) Downloadshttps://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=92

07 September 2015 thumbnails on the fly or uses local images if they exist. (Note: This retrieves thumbnail from a service and stores this on your server) - Warning: Images will reset if you specify a different image type (default is PNG) (eg. PNG to JPG -> means module...

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

PHP Issue: simplexml_load_string parser error : Input is not proper UTF-8, indicate encoding !https://www.joellipman.com/articles/web-development/php/php-issue-simplexml-load-string-parser-error-input-is-not-proper-utf-8-indicate-encoding.html

02 August 2016 ); $file_xml = simplexml_load_string( utf8_encode( $file_content ) ); // works! DONE! Stop reading any further and tell your boss it was always in hand. Other things I tried but to no avail The solution above was as easy as that. Here are a number of...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

Pure JS - Display Time Elapsed & Remaininghttps://www.joellipman.com/articles/web-development/js/pure-js-display-time-elapsed-remaining.html

30 October 2018 seconds remaining and seconds elapsed in PHP first then passing these as two variables to the below code but you could get your values from anywhere: On page load, the seconds remaining and elapsed are specified JS then takes over and runs the time var...

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

Zoho CRM: APIv2 using PHP & cURLhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-apiv2-using-php-curl.html

30 January 2019 to apply it to any client. How? Firstly, you will need to browse to https://accounts.zoho.eu/developerconsole and register your new app (or the one you will have completed once copying the below scripts). Let's start with the first PHP file which I will...

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

Minimal Privileges for MySQL Database Backup Cron Jobhttps://www.joellipman.com/articles/linux/cpanel/minimal-privileges-for-mysql-database-backup-cron-job.html

20 March 2019 credentials stored in external file: mysqldump --defaults-file=/path-to-file/.my.cnf my_db > /path_to/backup.sql // and in your cnf file: [mysqldump] user=my_user password=my_password The one to rule them all: // everything: using external file,...

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

CSS Add Text to Breadcrumb Link with a Transitionhttps://www.joellipman.com/articles/web-development/css/css-add-text-to-breadcrumb-link-with-a-transition.html

18 May 2019 { content:'\00bb'; margin-right:5px; } The last snippet is completely optional if you want to prefix the character » to your breadcrumbs. Unfortunately, this only deals with the opacity transition as the width transition is not a smooth one. If anyone...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Zoho Deluge - Counting in a Map dataTypehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-counting-in-a-map.html

02 September 2019 levels, the count will be with a series if then else statements. See the results/yield section to determine which best fits your scenario: Counting total products: // // count total products for availability m_ProductCount = Map(); for each...

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

Zoho Deluge: Push Multi-Select Picklist containing Commas from CRM to Creatorhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-push-multi-select-picklist-containing-commas-from-crm-to-creator.html

20 April 2020 in Creator (Options 2 is split from 3) Solution: In the Creator picklist/dropdown options, change any comma to , then in your CRM code to create the record in Creator: l_MyMultiPicklist = List(); for each r_PicklistOption in...

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

Zoho Deluge: Convert Xero Date (Unix Timestamp) to Standard Date Stringhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-convert-xero-date-unix-timestamp-to-standard-date-string.html

04 May 2020 "$1:$3", false); Error: Argument type mismatch -Found 'TEXT' but Expected 'Long' // Solution: Convert your string into a date. Source(s) toTime() function | Help - Zoho Deluge unixEpoch() function | Help - Zoho Deluge

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