Is it a scam? Gumtree.com's warning signshttps://www.joellipman.com/hardware/is-it-a-scam-gumtreecoms-warning-signs.html

12 October 2010 into the country. Don’t pay these fees. You’ll most likely never get the product and will lose any money you paid. Always remember, «CompanyName» is designed for meeting up to deal with people in your neighbourhood face to face. Work from home. Some...

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

Joel's Reference to MidJourney v4 Promptshttps://www.joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

11 February 2023 letter or it will simply reset your custom option): type /prefer option set then a In the "option" box, type an easy to remember word for this set of options, eg. "portrait". Now click outside of the option box at the end (in between where it says +1...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

Zoho Deluge - Store and repopulate a multi lookup list in Creatorhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-store-and-repopulate-a-multi-lookup-list-in-creator.html

28 June 2019 // store already selected entries // if(!isnull(input.myLookup)) { // remember remember the 5th of november l_RememberLookup = List(); if(input.myLookup.size()>0) { for each v_SelectedLookup in input.myLookup { l_RememberLookup.add(v_SelectedLookup); }...

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

Using MetaMod to hide buttons from logged in usershttps://www.joellipman.com/articles/cms/joomla/using-metamod-to-hide-buttons-from-logged-in-users.html

22 September 2009 "Quick Module ID Include" field. Make sure everything you created is saved and published and all should work brilliantly. Remember that unpublished modules will not show up in the list of available modules while editing the metamod. JonP - Webmaster...

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

Uninstalling AEC Central and installing Community Builderhttps://www.joellipman.com/articles/cms/joomla/uninstalling-aec-central-and-installing-community-builder.html

20 January 2010 2. Unzip to a folder 3. Login to your admin panel 4. Go to Extensions > Install/Uninstall 5. Install com_comprofiler.zip (remember to wait till it confirms it says "Installation finished") 6. Go back to Extensions > Install/Uninstall 7. Install...

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

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

03 July 2011 user (as specified in the module parameter) 2) the parameter "STOP Thumbnail Generation" is set to "NO". (Important! remember to switch this to YES when you have updated all your thumbnails as each thumbnail is one entitlement of the first 100,000 for...

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

Unix Date Format Specifiershttps://www.joellipman.com/articles/linux/unix-date-format-specifiers.html

05 July 2011 could just remember to search wikipedia for "Date (Unix)" or search my site for "Unix". This was easier. Source: Wikipedia: Date (Unix) Format specifiers (format string starts with +) Specifier Description Values/Example Day %a weekday, abbreviated Mon...

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

SSRS AlphaNumeric Parameter Validationhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-alphanumeric-validation.html

07 November 2011 -- where :ParameterToCheck is another of the report parameters (Oracle local variable) MDX Check /* For Expression Value. Remember to apply to both ACTION and if you use color change FONT. Note for MySQL solution change 0 to 1. */ =IIF(...

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

Prefix Line Numbers in a Text Filehttps://www.joellipman.com/articles/automation/ms-dos/prefix-line-numbers-to-a-text-file.html

18 July 2012 respective line number in a text file using a Microsoft Windows Operating System... I've just googled this as I couldn't remember how I did this last time and a number of people showing off their MS-DOS batch skills have proposed stupid extensive...

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

Set up Desktop SlideShow in Windows 7https://www.joellipman.com/articles/microsoft/windows-os/set-up-desktop-slideshow-in-windows-7.html

22 January 2013 "browsing to the Picture Location". The problem happens when browsing to the picture location and it doesn't seem to remember which folder you selected. At home, this would be a breeze, but that's because I don't implement group policies at home. Why?...

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

Hide a Drive per User in Windows 7https://www.joellipman.com/articles/microsoft/windows-os/hide-a-drive-per-user-in-windows-7.html

28 March 2014 logged-in user (delete the NoDrives DWORD). The concept of creating the NoDrives registry entry is what you need to remember. In the example below, we are applying the same principle to a specific user account (the Guest account): Open the registry...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Include a carriage return in a column headinghttps://www.joellipman.com/articles/microsoft/sql-server/include-a-carriage-return-in-a-column-heading.html

07 July 2014 the carriage return in the column headings. Additional: Only appears obvious in SQL Server Management Studio resultset. Remember to format the cells (column headings) in the Excel spreadsheet for it to wrap text and save the file. Hereafter, you will...

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

Excel: convert degrees minutes seconds to decimalhttps://www.joellipman.com/articles/microsoft/excel/excel-convert-degrees-minutes-seconds-to-decimal.html

06 November 2014 that I tend to copy the coordinates off a website which has strange apostrophes and double-quotes. You can change this but remember to put two double-quotes if you are searching on it, eg: FIND(""",B1) // will NOT work! FIND("""",B1) // will work...

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

Windows Live Mail Error ID: 0x8DE00005https://www.joellipman.com/articles/microsoft/windows-os/windows-live-mail-error-id-0x8de00005.html

14 December 2016 Server: 'https://mail.services.live.com/DeltaSync_v2.0.0/Sync.aspx' Windows Live Mail Error ID: 0x8DE00005 How? I don't remember the time when the Microsoft website became helpful but as they already have an article on this, I'm going to do a bunch of...

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

AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktopshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-ms-windows-10-open-apps-on-multiple-monitors-and-desktops.html

18 July 2019 grouped into the one desktop. If you have a multiple monitor setup (ie. more than 1 monitor), then MS Windows will almost remember which apps were open on which screen but always on Desktop 1. In addition, there are some developments on AutoHotkey...

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

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 So this is a super quick note that I'll probably remember anyway but just in case, I'm writing this article so I don't spend time researching it later. Why? I'm synchronizing Xero Invoices with Zoho CRM Invoices and noticed that Xero stores its dates in...

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

Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-mapping-a-multi-user-or-multi-lookup-field-using-deluge.html

28 April 2021 one module to another, sometimes you need to manage existing multi-lookups/users in a record. How? So the key point to remember is that all multi-select lookup and multi-user lookup fields are held in temporary CRM modules called a "LinkingModule" (as...

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

Windows OS: Alt Codes / Symbols / Special Charactershttps://www.joellipman.com/articles/microsoft/windows-os/windows-os-alt-codes-symbols-special-characters.html

03 June 2021 spacebar) then press the numbers in the numeric pad (while still holding down the ALT key), then let go of the ALT key. Remember: This will not work with the numbers at the top of your keyboard unless you are on a laptop and can apply a function lock...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Zoho Creator: Two submit buttons on a non-stateless form with 2 different redirectshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-two-submit-buttons-on-a-non-stateless-form.html

27 July 2021 input.Account.toLong(); } else { //... code to create new record r_NewRecord = insert into [ = = = ]; } Done: Additional Remember that an integration field on the interface is returned as a string and needs to be converted to a number to be assigned,...

• 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 /* // Email yourself as a test but remember to remove this before going Live. sendmail [ from :zoho.adminuserid to :"info@joellipman.com" subject :"TEST ebay Webhook Notification" message :m_Payload ] */ return r_CreateRecord; Save the function While...

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