Windows 7 Aero Featureshttps://www.joellipman.com/articles/microsoft/windows-os/windows-7-aero-features.html

27 April 2010 I'd put something here as a lot of my clients and friends are all surprised by the Aero features and weren't aware that these existed in Windows Vista (and originally from Linux variants). Sometimes you may only have partial Aero effects. This can be...

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

Joe's Unduplicater (JUD)https://www.joellipman.com/component/content/article/joes-unduplicater.html?catid=40

12 July 2010 files it will keep and which ones it will send to the Recycle Bin. TESTED ON: - Windows XP, Windows 7 SCREENSHOTS: LICENSE: These scripts are offered freely and in good faith. Please do not pass this off as your own work or try to sell it without due...

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

SQL Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

14 January 2011 which will display any room bookings for that month. This is "Reinventing" because we used to use MS Outlook to store these kind of things until the company implemented a software to deal with room bookings and said we shouldn't use Outlook for this......

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

Inserting incremental weeks in MySQLhttps://www.joellipman.com/articles/database/mysql/inserting-incremental-weeks-in-mysql.html

15 April 2011 those of you unfamiliar with this system, the reason week numbers are different to normal people's week numbers is because these are academic week numbers. So I can't use the built-in functions. The current structure looks similar to this: ID SetID...

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

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

03 July 2011 and Rounded Corners not Working? The "Rounded Corners" effect on the thumbnails and popups are CSS3 driven. These will only really display properly in browsers that support CSS3 (Chrome, Firefox 3.5+, Safari 4+, MS Internet Explorer 9+). Other users...

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

Fix Oracle Tnsping 3511 without Windows Registryhttps://www.joellipman.com/articles/database/pl-sql/fix-oracle-tnsping-3511-without-windows-registry.html

04 March 2013 product=NETWORK, facility=TNS Why? We NEED several instances of Oracle installed as we have different products/services and these run off various instances of Oracle 9i, 10g, and 11g. This article was written for those that need to support these kind of...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

Protecting your Joomla Administrator Sectionhttps://www.joellipman.com/articles/cms/joomla/protecting-your-joomla-administrator-section.html

23 October 2015 that the crackers/hackers will get through ultimately whether it be by brute-force, DoS, Injection, etc. I'm not saying these are silver bullets, but they will slow down some people. How? The below will a) change the /administrator location and b) limit...

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

Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

15 May 2020 row.myUpload); } } // r_AttachFile should yield SUCCESS and if you check your CRM record it will have these under "attachments" Setup a Zoho Oauth Connection So that we can use invokeUrl and attempt the REST via API (see what I did there?), we need a...

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

Zoho Creator: Receive eBay Order Notifications via Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

20 September 2021 need an access token: please visit my article and read the first part on how to get a valid Access Token for the rest of these steps. Once we have an access token, we will check what notifications already exist (if any), and then we will create a...

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

Zoho Creator/Deluge: UnPredictable exception, Invalid statement foundhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-deluge-unpredictable-exception,-invalid-statement-found.html

17 November 2021 in each record: // select a bunch of creator records (ok all of them) l_AllRecords = myForm[ ID != 0 ]; // // loop through these for each r_Record in l_AllRecords { // set an if condition if(r_Record.Type == "Subform1") { // loop through the first...

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

Zoho: Email Deliverability / SPF / DKIM / DMARC / Toolkithttps://www.joellipman.com/articles/crm/zoho/zoho-email-deliverability-spf-dkim-dmarc-toolkit.html

04 May 2023 they need to sign in to their domain registrar's website and need to be assisted, perhaps via a remote session, on setting these up. If they have someone or a company which manages their domain, then they can give the following instructions to these...

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

ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttps://www.joellipman.com/articles/crm/zoho/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

05 December 2023 Source URLs returned from the above function to generate a HTML signature, then use placeholders for the code to replace these with the user's personal details (eg. name, job title, etc). /*...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• 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 and permissions can be "Read". Click on the "Generate API Key" button Note the consumer_key and consumer_secret somewhere (these aren't displayed to you in future - so this is your one chance, or else you need to generate another key) Zoho Deluge Here's...

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

Zoho CRM: Updating a CRM record Custom Line Items using API v7https://www.joellipman.com/articles/crm/zoho/zoho-crm-updating-a-crm-record-using-api-v7.html

18 December 2024 fields in their transactional modules line items (quotes, sales orders, invoices, purchase orders). The only way to update these are by using the API and deluge function invokeURL rather than the usual shortcode of zoho.crm.updateRecord() or...

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

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

31 May 2009 To edit a post, click the "Edit" button right below it. Cheating the censor system is against the rules. If you break one of these rules, the following penalties will apply (first time, second time, third time...) with the exception of breaking the rule...

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

Database Error: Unable to connect to the database: Could not connect to MySQLhttps://www.joellipman.com/articles/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

25 September 2009 15 modules and about 15 plugins (excluding the core modules/plugins) and managed to recreate this error. I disabled half of these but still got the error. Cleared the expired cache but still got the error. I then uninstalled half of these (including...

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

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

25 February 2010 the user to the database Create test database with same user Email Setup For you to do: How many email accounts? What will these be primarily used for (restricted on space allocation - usually ~100Mb)? List all email addresses please (limited as these...

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

Some milestones for a website projecthttps://www.joellipman.com/articles/web-development/some-milestones-for-a-website-project.html

14 April 2010 level of usability, the saleability of the product and technical risk involved in fully developing the website. ALPHA/BETA – these are the next major milestones that represent near completed websites, these are subject to extensive testing,...

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

Joe's CSV Chart Generator (JCG)https://www.joellipman.com/component/content/article/joellipmans-csv-chart-generator.html?catid=40

26 May 2010 TESTED ON: - Windows XP, Windows Server 2003, Windows 7 SCREENSHOTS: LICENSE: These scripts are offered freely and in good faith. Please do not pass this off as your own work or try to sell it without due credit. Check back with us at joellipman.com...

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

Room Availability Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/microsoft/ssrs/room-availability-calendar-in-business-intelligence-development-studio.html

23 March 2011 = @siteId AND upper(sd.[Descrip]) not like 'ADDITIONAL TIMETABLE%' --Cycle through all possible rooms and include these in the calendar UNION SELECT rms.RoomId AS Room, CONVERT(VARCHAR(8), @StartTime, 108) AS EventStart, CONVERT(VARCHAR(8), @StartTime,...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *