Adding a selectable background to a Yootheme templatehttps://joellipman.com/articles/cms/joomla/adding-a-selectable-background-to-a-yootheme-template.html

19 November 2012 Add a \templates\\css\background\ambientturquoise.css file. Note the same filename as in the option value of the previous step. body#page { background: #f4f5f5 url(../../images/background/ambientturquoise/ambientturquoise.jpg) 0 0 no-repeat; } If using...

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

MS Excel - Split Workbook into separate files per sheethttps://joellipman.com/articles/microsoft/excel/ms-excel-split-workbook-into-separate-files-per-sheet.html

11 February 2019 Set xWs = WorkRng.Parent Set xRow = WorkRng.Rows(1) Application.ScreenUpdating = False For i = 1 To WorkRng.Rows.Count Step SplitRow resizeCount = SplitRow If (WorkRng.Rows.Count - xRow.Row + 1)...

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

Zoho Deluge - Get Refresh/Access Token API v2https://joellipman.com/articles/crm/zoho/zoho-deluge-get-refresh-access-token.html

17 July 2019 v_RedirectUri = "https://www.zoho.com/books"; // // enter the code received in the previous step v_Code = "1000.00001111222233334444555566667777888899990000aaaabbbbccccddddeeeef"; v_EndPoint = "https://accounts.zoho.com/oauth/v2/token"; v_GrantType =...

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

Zoho CRM: Permission Denied for Quote Conversion Mappinghttps://joellipman.com/articles/crm/zoho/zoho-crm-permission-denied-for-quote-conversion-mapping.html

02 September 2021 CRM Invoice module. How? Therein lies the reason. For the quote conversion mapping, it needs the CRM Invoice module as well. Step by step fix: Login to ZohoCRM, go to Setup Under "Customization", select "Modules and Fields" Click on "Organize Modules"...

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

Zoho Analytics: Setup DataSource via FTP Connectionhttps://joellipman.com/articles/crm/zoho/zoho-analytics-setup-datasource-via-ftp-connection.html

12 January 2022 So this is going to be an article with a bunch of pictures showing step-by-step of how I setup a recurring data source in Zoho Analytics via FTP. Why? The use-case here is that I have a client who wants to import data via FTP (SFTP - to be precise) and...

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

ZohoCRM: Template: not being able to edit a text boxhttps://joellipman.com/articles/crm/zoho/zohocrm-template-not-being-able-to-edit-a-text-box.html

25 January 2022 odd article with not 100% certainty on what the cause/outcome would be for your case but worked for us. This documents the steps taken to edit/modify the header on a sales order inventory template. Why? A client raised an issue that they had previously...

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

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

31 May 2009 was wrong or whether a warning is necessary to explain it to you. If I do not give a warning, I will skip ahead to the next step in the penalty list. Muting - This is where you are not able to talk on the board. You may still view it. Temporary Ban -...

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

Blank columns issue when exporting to Excel (Data Only) from Crystal Reportshttps://joellipman.com/articles/microsoft/excel/blank-columns-issue-when-exporting-to-excel-data-only-from-crystal-reports.html

15 June 2010 to the guideline. When the corners are highlighted in red, this indicates the field is snapped to the guideline. Repeat step 2 until all the fields in the section are snapped to the vertical guideline(s). Set the object’s size and position by...

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

Accessing a MySQL Database with Business Intelligence Development Studiohttps://joellipman.com/articles/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

05 January 2011 connection using SQL Server Management Studio and would not recommend anyone to go through the same rubbish. I just took a step back and thought this through and this is what I came up with! Additional The above will all work if you're working on a...

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

Joes Bug Tracker (JBT)https://joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=40

07 July 2011 Panel. Go to "Extensions" > "Install/Uninstall". Click on the "Upload" button and select the file you downloaded in step #1. GLOSSARY/TERMS/DEFINITIONS - File = A file which is available for download from your site, each version is its own file. -...

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

Print Directory Contents to a Filehttps://joellipman.com/articles/microsoft/windows-os/print-directory-contents-to-a-file.html

19 July 2012 open window dialogs TEST: Open an instance of Windows Explorer, Right-click on a folder and select the action you named in step 6. For Windows 7: Open the system registry (Start > Run... > Type "REGEDIT" > OK) Navigate to My...

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

Joomla article modal with clear buttonhttps://joellipman.com/articles/cms/joomla/joomla-article-modal-with-clear-button.html

27 August 2012 to 2.5.x). Don't overwrite any existing core files with this one, it's completely unnecessary as this is a 3.24Kb file. Step #1 of 1: Create and include the following PHP file, I've named this file "article.php" (thanks to my amazing imagination). The...

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

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

01 February 2013 begin: Download the JDBC Driver for MySQL (Connector/J) connector from http://www.mysql.com/products/connector/ [Optional Step] Uncompress the download, then copy or move the JAR file (at time of print: mysql-connector-java-5.1.22-bin.jar) to the folder...

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

Administrator Program Shortcut without Prompthttps://joellipman.com/articles/microsoft/windows-os/administrator-program-shortcut-without-prompt.html

25 February 2013 that task: Open the Task Scheduler (Start > Run... > Type taskschd.msc > OK) - You will need administrator rights for this step. Click on Create Task... Under the General tab, for "Name" give it a general name with no symbols/special characters and...

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

AwStats Data Parser (ADP)https://joellipman.com/component/content/article/awstats-data-parser-adp.html?catid=40

03 April 2013 of your Awstats page (so there isn't the menu on the left) Run "Generate_AwStatsParsedData.exe" Select the file you saved in step 1 Click on "Go". What data does it return? Any table/grid in the Awstats report uniquely identified by the labels mentioned...

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

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

15 November 2013 a solopreneur, freelancer but I specialise in automation which lets me do the work of many more. I have associates who can step in when necessary but they will not necessarily match my skillset. My associates only get involved when something goes...

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

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

28 March 2014 The value you enter for NoDrives depends on the drive(s) you want to restrict (Refer to the list above) CRITICAL STEP: Once you've saved this value, navigate back up to HKEY_USERS, select the Foo key you loaded, and then click File > Unload Hive > Yes...

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

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

07 July 2014 ----------- ----------- ----------- ----------- -- 1 14-Jul-2014 15-Jul-2014 16-Jul-2014 17-Jul-2014 18-Jul-2014 Last Step: Format the cells in Excel containing the header under "Alignment" to "Wrap Text". The difference the above does, is that when you...

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

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

06 November 2014 will work FIND("″",B1) // will work You could merge all the statements into one but for simplicity's sake I'm putting each step here: In column C put the formula: =MID(B1, 1, FIND("°", B1)-1) In column D put the formula: =MID(B1,FIND("°",B1)+1,...

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

Warning: Save failed. Another menu item has the same aliashttps://joellipman.com/articles/cms/joomla/warning-save-failed-another-menu-item-has-the-same-alias.html

13 March 2015 existing menu item alias from "about-us" to "about-us2" as well as any similar `path` value. Change the item you created in step #2 (eg. "about_new" to "about-us"), also change the "path" value to match as this will generate your URL. Done

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