Project Plan for Freelance Websitehttps://www.joellipman.com/articles/web-development/project-plan-for-freelance-website.html

25 February 2010 content to be finalised (this is content that will exist on project closure) Instructions for modifying content (textual mostly but also image uploads) Create custom documentation for front-end use Create custom documentation for back-end (admin panel)...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

The ReportServer Databasehttps://www.joellipman.com/articles/database/the-reportserver-database.html

08 August 2011 be 1 or 0. This was zero "0" when I would run a report as a user. Format nvarchar(26) NULL This is the rendering format. Mostly RPL if viewed in MS Internet Explorer. Parameters ntext NULL Parameters and the values they were submitted with. TimeStart...

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

Slideshow div layer through a windowhttps://www.joellipman.com/articles/web-development/mootools/slideshow-div-layer-through-a-window.html

11 September 2012 we can send each new info to the next slide and use only two slides in total (that's the aim at least). Other objects (mostly text over image) will need to be free flowing and slide in emulating a dynamic showcase slideshow. Using MooTools it's also...

• Type: Article
• Author: Joel Lipman
• Category: MooTools Framework
• Language: *

Access MySQL databases using Oracle SQL Developerhttps://www.joellipman.com/articles/database/mysql/access-mysql-databases-using-oracle-sql-developer.html

01 February 2013 the login details and host location... Done! Additional I wouldn't recommend using Oracle SQL Developer. You have to use mostly SQL to create tables and stuff. Recommend to your bosses that you need the MySQL Workbench as this is FREE and with all the...

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

Joes Syntax Styler (JSS)https://www.joellipman.com/component/content/article/joes-syntax-styler-jss.html?catid=40

06 April 2013 are highlighted what color. Uses separate CSS file for overall look. This is still in development! Currently this plugin is mostly hard-coded and most of the parameters have no effect. It was initially built for someone as a quick syntax highlighter...

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

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 no one seemed bothered but now the request came through asking if this could be restored to a normal case, a mixture of mostly lowercase and some UPPERCASE. Why? I'm writing this article because other solutions on the net were either incomplete, did not...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• 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 to setup on each website :c) - Date Uploaded: Mon, 1st Aug 2011 It's Personal- Rounded corners, hover border, styling mostly - For use by my own personal site - Hardcoded features of version 1.4.3 (ie. not parameters) - Date Uploaded: Mon, 25th Jul 2011...

• 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 into memory with simplexml_load_string(). I get the above error when it is attempting to load an XML feed which is mostly in Spanish and breaks at the following XML node: 2 -> yields issue: PHP Warning: simplexml_load_string(): 2 in...

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

Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://www.joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

02 February 2019 the code to go through the logic and highlight any changes you may need to make. 1. First: the variables are in arrays Well mostly. Simply because we'll be working with JSON data and this encodes/decodes easily into PHP arrays. I can also output any of...

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

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

08 July 2020 is provided (defaults to A_ScriptDir) to specify what folder to scan for files. The 3rd button simply reloads the app (used mostly for testing/development). Lastly, a listview that has 2 columns: the 1st lists the files in that directory, the 2nd...

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

Zoho Creator: Create a Widget which uses JavaScripthttps://www.joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 that at time of print (2020-10-24), Zoho Creator does not allow you to use JavaScript anywhere in its app. HTML and CSS are mostly allowed but JavaScript automatically gets removed from any of your code. How? As someone who's been using Zoho services...

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

Zoho Creator: eBay: Get Item Transactionhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-ebay-get-item-transaction.html

22 January 2022 This is the function to get the line item order/transaction from eBay if you give it the eBay Item ID as a parameter. Why? Mostly for debugging but here's the code that will quickly get the XML of a GetItemTransactions request to eBay. How? You'll need...

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

Zoho Webhooks & Shopify API: Keep Disappearinghttps://www.joellipman.com/articles/crm/zoho/zoho-webhooks-shopify-api-automatically-restore.html

22 April 2024 set this up in the CRM. I'm using ZohoCRM here despite storing the record in ZohoCreator as the app and data processing is mostly done in ZohoCreator. I could have setup webhooks to go directly to Zoho Creator but I don't find Zoho Creator reliable when...

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

First and Last Entry on a Page using Modulus Remainderhttps://www.joellipman.com/articles/web-development/php/first-and-last-entry-on-a-page-using-modulus-remainder.html

26 September 2011 quite a long title but I'm not sure what I'll be searching next time. It has taken me a lot longer than I thought it would mostly out of frustration and the inability to know exactly what I'm looking for... always difficult. After a cup of tea the...

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