Advanced Search

Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming need is required, the following 280 results were found.

  1. 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

    Save failed with the following error. Another menu item has the same alias in Root. Root is the top level parent You will need: Access to the Joomla Administration Panel (to check for and remove expired menu items) A good database administrator who is...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  2. Protecting your Joomla Administrator Sectionhttps://joellipman.com/articles/cms/joomla/protecting-your-joomla-administrator-section.html

    How? The below will a) change the /administrator location and b) limit access to a single IP address. Note that you will need to ensure you have a static IP (most ISPs now assign static IPs to home broadband users as well as larger corporations). But...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  3. Joomla: Remove IDs from URLs for out-of-the-box SEFhttps://joellipman.com/articles/cms/joomla/joomla-remove-ids-from-urls.html

    advantage of a Joomla update and do this without any coding... Pre-amble To allow the Joomla CMS to manage your SEFs you need to setup your htaccess file: Open the root of your Joomla website in your file manager (you can FTP or use web-based clients)...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  4. Migrate Joomla Users to WordPresshttps://joellipman.com/articles/cms/wordpress/migrate-joomla-users-to-wordpress.html

    get your user accounts all migrated. How you deal with the passwords can then be up to you. To use the following script, you need to change the my_wordpress_db to the name of your wordpress database and change my_joomla_db to the name of your joomla...

    • Type: Article
    • Author: Joel Lipman
    • Category: Wordpress
    • Language: en-GB
  5. MacOs: Transcribe Training Video using OpenAI Whisperhttps://joellipman.com/component/content/article/macos-transcribe-training-video-using-openai-whisper.html?catid=60&Itemid=165

    Just noted this down in case I need to do it again. This article documents how to take a 5.5 hour video (MP4) and have it transcribed by a locally installed AI on a MacOS (running Sequoia 15.1.1). Why? Needed for training videos as a follow-on from my...

    • Type: Article
    • Author: Joel Lipman
    • Category: Apple
    • Language: *
  6. Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)https://joellipman.com/component/content/article/upload-file-to-google-drive-with-php-curl-and-api-rest-v3-without-library-install.html?catid=61&Itemid=165

    scopes. The scopes I chose were to do with getting a working example rather than the recommended scope, though you may only need the first (untested): https://www.googleapis.com/auth/drive.file https://www.googleapis.com/auth/userinfo.email...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  7. Calculating Percentagehttps://joellipman.com/articles/else/e-commerce/calculating-percentage.html

    I need to often be reminded of how to calculate a percentage. The context here is that I want a progress bar in one of my programs. To determine what percent a number is of a total number: (Progress So Far / Total Progress Units) * 100 = % or (Net...

    • Type: Article
    • Author: Joel Lipman
    • Category: eCommerce Systems
    • Language: *
  8. Android: Function to let user take photo or choose existinghttps://joellipman.com/articles/else/app-dev/android-os/android-function-to-let-user-take-photo-or-choose-existing.html

    camera beforehand, apparently if(hasSystemFeature(PackageManager.FEATURE_CAMERA)) is a way to go. I haven't tested yet as I need a tablet/phone that doesn't have a camera... Applies to: Android Studio v0.8.9 Microsoft Windows 7 Pro Android: Min SDK...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  9. Android OS: Add GoogleMap as fragmenthttps://joellipman.com/articles/else/app-dev/android-os/android-os-add-googlemap-as-fragment.html

    and any other activity would be a sub-activity; returning to the map activity would restart the app as a menu item, it would need to launch a new intent... I wanted to change my previous example so that the homepage of the app (the starting page) will...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  10. Sort order a dropdown list in MS InfoPath without programminghttps://joellipman.com/component/content/article/sort-order-a-dropdown-list-in-ms-infopath-without-programming.html?catid=73&Itemid=165

    how it works only that it does. I think this could get complicated if you had two dropdowns reading off the same list but needed to list elements in different orders. If you haven't made a dropdown list yet There's other instructions out there on the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Infopath
    • Language: *
  11. SSIS Convert a string into a datehttps://joellipman.com/component/content/article/ssis-convert-a-string-into-a-date.html?catid=74&Itemid=165

    through columns that someone mentioned that maybe all the data in that column is not consistent? This made sense as I need to parse the string to extrapolate the date, month and year. How? I used two "Derived Column" tasks for this after giving up with...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  12. SSIS Skip Blank Rows in Flat File Sourcehttps://joellipman.com/component/content/article/ssis-skip-blank-rows-in-flat-file-source.html?catid=74&Itemid=165

    - my rows to skip is because of the state of my data): Crucial fix here, add 2 to the OutputColumnWidth value. It seems you need to set the data column to accommodate for the special characters the blank rows somehow feed in. In this case, the Ragged...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  13. Alternate row background colour in Reporting Serviceshttps://joellipman.com/component/content/article/alternate-row-background-colour-in-reporting-services.html?catid=75&Itemid=165

    confusing as to why it works but it does. Not sure whether you call this an MDX Query or part of a Transact-SQL mashup. You need to go to "Fill" (of each text box in the row - unless there's a faster way) and instead of color, click on the expression...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  14. SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttps://joellipman.com/component/content/article/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html?catid=75&Itemid=165

    a link that will run a stored procedure which Updates a timestamp in an existing table Inserts a row into an audit table I need the report to run the stored procedure, then based on the errorlevel, return a message. How? We use a database account with...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  15. SSRS Zero Paddinghttps://joellipman.com/component/content/article/ssrs-zero-padding.html?catid=75&Itemid=165

    I didn't want to do this at the database level, mainly because it meant modifying the SQL query. The zero padding would need to be applicable within an MDX query. The Situation We have a database using Oracle 10g, and a SQL Server Reporting Services...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  16. How to Display Report Execution Time in SSRS (milliseconds)https://joellipman.com/component/content/article/how-to-display-report-execution-time-in-ssrs.html?catid=75&Itemid=165

    REPORTSTARTTIME. There are two options here: Create another dataset (would have to be the first dataset to load so you would need delete your current datasets then add them in the order you want them to load) to get the timestamp of when the queries...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  17. SSRS Dropdown parameter cannot be blank!https://joellipman.com/component/content/article/ssrs-dropdown-to-allow-blank-values.html?catid=75&Itemid=165

    server for the ItemID field which is some sort of hexadecimal ID value that Microsoft are so very fond of. You will need to use your own head to match the datatypes for including a dummy row. Also note that because I don't have any options matching the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  18. SSRS Stop Scrolling Behindhttps://joellipman.com/component/content/article/ssrs-stop-scrolling-behind.html?catid=75&Itemid=165

    to False (ensure all items are set to false or it will error): Save and test on the ReportServer. Background: If you need to visualize how I could have ended up in such a situation, here's the design mode of the report (apologies for the red censoring...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  19. Include a carriage return in a column headinghttps://joellipman.com/component/content/article/include-a-carriage-return-in-a-column-heading.html?catid=78&Itemid=165

    format the cells (column headings) in the Excel spreadsheet for it to wrap text and save the file. Hereafter, you will NOT need to do this on each data refresh. Ensure that there is a trailing space after the label and before the carriage return...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server
    • Language: *
  20. How to change local folder for TFShttps://joellipman.com/component/content/article/how-to-change-local-folder-for-tfs.html?catid=79&Itemid=165

    installed it however, they decided to use a common local directory for all workstations so configuration files would not need to be modified. So? Once installed, my BIDS install would continuously check-out files and store these in the home directory. I...

    • Type: Article
    • Author: Joel Lipman
    • Category: Team Foundation Server
    • Language: *
Results 201 - 220 of 280