Display Feeds to major Social Networkshttps://www.joellipman.com/articles/web-development/display-feeds-to-major-social-networks.html

16 May 2016 A quick article on how I displayed feeds from the company's social network pages in one page. Why? There are 3rd-party apps that let you do this, some paid, some not. This was for a staff portal so I wanted this at no extra cost. This is read-only so...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• 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 $timeout); $data = curl_exec($ch); curl_close($ch); return $data; } $file_content = get_data( "http://joellipman.com/xml_feeds/my_XML_url.xml" ); $file_xml = simplexml_load_string( $file_content ); // doesn't work and returns a load of parser errors The...

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

Zoho Deluge - Some Useful Regular Expressionshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-some-useful-regular-expressions.html

31 May 2019 v_MyString.replaceAll("\r","",false); // carriage returns v_FormattedString = v_MyString.replaceAll("\n","",false); // line feeds v_FormattedString = v_MyString.replaceAll("\f","",false); // form feeds // a regex that should work but doesn't...

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

PHP & MySQL Search Enginehttps://www.joellipman.com/articles/web-development/php/php-a-mysql-search-engine.html

09 March 2011 (and everything in between) $str = str_replace(array("\r\n", "\r", "\n", "\t"), ' ', $str); // remove carriage returns, line feeds, tabs and double-spaces # for mediawiki $str = str_replace('=', ' ', $str); // replace any equal signs with a single-space...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• 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 creating discrepancies that would error the flow. Solution Found!!! Taking the idea that the Carriage Return (CR) or Line Feeds (LF) are being inserted, simply extract the entire row as a column and trim it. I separate out the first column as my...

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

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

13 August 2014 Specifies the maximum number of digits allowed. Must be greater than zero whiteSpace Specifies how white space (line feeds, tabs, spaces, and carriage returns) is handled Source(s): w3schools.com

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

Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 - [1.7.3] Pilot: profile preferences/settings - [1.7.3] Hangar: backwards compatibility - [1.7.2] News: Fix for duplicate feeds - [1.7.1] Hangar: backwards compatibility for this app - [1.7.0] Map: toggle city centres - [1.7.0] Map: toggle map type -...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Zoho Deluge and Wordpress/WooCommerce API: Get All Productshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-and-wordpress-woocommerce-api-get-all-products.html

15 April 2024 Granted that in some cases, the design should go in the other direction, as in enter the products in Zoho Inventory and this feeds the website. More than often, however, this request comes in when the customer has already been setting their Zoho...

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

Trim in T-SQL and SSIShttps://www.joellipman.com/articles/microsoft/ssis/trim-in-t-sql-and-ssis.html

14 May 2013 Some methods of removing trailing spaces, tabs, carriage returns and line feeds (new lines). How? First in Transact-SQL: SELECT RTRIM( REPLACE( REPLACE( REPLACE( @myString, CHAR(9), ''), CHAR(10), ''), CHAR(13), '') ) -- CHAR(9) = Tab -- CHAR(10) = Line...

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

SITS: XET format for Export not availablehttps://www.joellipman.com/articles/web-development/xml/sits-xet-format-for-export-not-available.html

08 August 2014 and create a new one based on the following: Now you can go and retrieve a student/staff (depending on what data your XET feeds off) Bring up STU File > Export... You should have something similar to the following:

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