SSRS Subscriptions cannot be createdhttps://joellipman.com/articles/microsoft/ssrs/ssrs-subscriptions-cannot-be-created.html

22 November 2013 describes solutions to the error: Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked report, the link is no longer valid. How? I'd like to say that the solution is far more complicated then...

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

SSRS Report Builder 2.0 - Error during processinghttps://joellipman.com/articles/microsoft/ssrs/ssrs-report-builder-20-error-during-processing.html

06 May 2010 'DataSet1'. The variable name '@GroupName' has already been declared. Variable names must be unique within a query batch or stored procedure. The Quick Fix Return to the Design interface of Report Builder 2.0 for the problematic report: Right-click on...

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

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

12 July 2010 retrieve accidentally deleted programs from my backup drives. I downloaded a load of media files (all legitimately :) and stored them in my music folder. I then run my MP3 software to convert all the files into MP3 format and store these in another...

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

Running Internet Explorer 6, 7, 8 as standaloneshttps://joellipman.com/articles/microsoft/windows-os/running-internet-explorer-6-7-8-as-standalones.html

18 May 2010 but click on "Settings" first Select "Hard Disk 1" and run the Virtual Disk Wizard Change it so that the file is not stored in "My Documents" (find somewhere on the C drive or other with space and real disks) It should go about creating a usable virtual...

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

K2 Items disappearhttps://joellipman.com/articles/cms/joomla/k2-items-disappear.html

27 August 2010 is "jos_") then you'll need to change this repair table command to match the database table where your K2 articles are stored (eg. "zu1fq_k2_items").

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

Migrate Joomla! 1.5.x to 2.5.x+https://joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 on the new database (only SELECT on the old database will do). Special care has been made to avoid the use of functions, stored procedures, temporary tables, etc. This allows broader compatibility and customers who do not have DBAs to run this...

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

MySQL parameters in Excel 2007 PivotTableshttps://joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 ...ouch......and it was so easy up to here... Tables of interest StaffActivities...the one users recorded time gets stored in... Resources...the one with the codes and resource names... Users...the one with users names... Teams...another lookup...

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

SSRS External Images don't displayhttps://joellipman.com/articles/microsoft/ssrs/ssrs-external-images-dont-display.html

19 September 2011 Situation We want some photos taken from another website of ours to display in our report. These are not stored locally on the Reporting Server because other services use these photos on our Intranet and we only want one location to upload the photos....

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

Migrate Joomla Users to WordPresshttps://joellipman.com/articles/cms/wordpress/migrate-joomla-users-to-wordpress.html

03 October 2011 a ORDER BY a.id; A bit more to do: PHP file So I needed to do a loop and rather than complicate things with stored procedures and cursors, it's likely if you're using either Joomla or Wordpress that you have a PHP enabled server available. Here's code...

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

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

19 July 2012 the action. Additional Notes: This outputs the contents to a text file called "directory_printout.txt". This file will be stored in the folder that you asked to list. Instead of C:\windows\system32\cmd.exe, I could have used %Comspec% or even...

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

Delete related records from multiple tableshttps://joellipman.com/articles/database/mysql/delete-related-records-from-multiple-tables.html

11 January 2013 System (RDBMS) where deleting some erroneous rows in one table will cause errors because the existence of those rows is stored in another table, how do we delete from all the related tables as well? How? You need to refer to the tables just after the...

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

Problem creating SSRS report subscriptionshttps://joellipman.com/articles/microsoft/ssrs/problem-creating-ssrs-report-subscriptions.html

11 November 2013 the following: Message from webpage Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked report, the link is no longer valid. Why? The problem happens because of the data source used in the...

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

Import Excel CSV file as JavaScript arrayhttps://joellipman.com/articles/microsoft/excel/import-excel-csv-file-as-javascript-array.html

05 October 2015 Excel along with double-quotes label1,label2 item1a,item2a item1c,"item2c,c" item1b,item2b What I want: To read the file (stored on the server) and convert to a JavaScript array of objects var my_object_array = [ { my_col1_val: 'item1a', my_col2_val:...

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

Foreign Characters create symbols in PHP and MySQLhttps://joellipman.com/articles/web-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

25 January 2016 case was due to me not specifying some extra parameters on the htmlentities or htmlspecialchars PHP functions. My database stored the foreign characters as they were so the fault was somewhere between PHP reading from MySQL to displaying the characters...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Google Authentication - OAuth 2.0 using PHP/cURLhttps://joellipman.com/articles/google/google-authentication-oauth-2-0-using-php-curl.html

31 October 2018 is required, redirect user to Consent page and rewrite token file (in JSON). If token is not required, use access_token stored in file. It is assumed that you have already registered the app with the Google developers console along with the redirect URI...

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

Minimal Privileges for MySQL Database Backup Cron Jobhttps://joellipman.com/articles/linux/cpanel/minimal-privileges-for-mysql-database-backup-cron-job.html

20 March 2019 recommended: /usr/bin/mysqldump -u dbusername -p'dbpassword' dbname > /path_to/backup.sql // recommended: using credentials stored in external file: mysqldump --defaults-file=/path-to-file/.my.cnf my_db > /path_to/backup.sql // and in your cnf file:...

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

Zoho Creator: Public URL of an Image field / Upload to Shopify APIhttps://joellipman.com/articles/crm/zoho/zoho-creator-public-url-of-an-image-field-upload-to-shopify-api.html

17 October 2021 instead of zoho.appuri, we are hardcoding the appowner and appname as this is used across Creator apps, ie. images are stored in a separate app]: l_CompatiblePhotoExtensions = {"png","jpg","jpeg","gif","bmp","heic"}; c_Document = My_Form[ID ==...

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

Zoho Desk: Re-enable Desktop Notifications after clicking on "Not Now"https://joellipman.com/articles/crm/zoho/zoho-desk-re-enable-desktop-notifications-after-clicking-on-not-now.html

20 July 2022 on “Site Settings” If the ZohoDesk activity appears then click into this, if not then: Click on “View permissions and data stored across sites” Click on “zoho.eu” this will dropdown all Zoho apps Click on “desk.zoho.eu” Click on “Clear Data” You will be...

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

ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://joellipman.com/articles/crm/zoho/zohocrm-integrate-chatgpt-to-zohozia.html

06 March 2023 data and models that are used by their services. When you train a model with OpenAI's services, your data is encrypted and stored in a secure environment, and access to the data is restricted to authorized personnel only. OpenAI also has strict policies...

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

PHP Script: Make your own Thumbnail Generator via APIhttps://joellipman.com/articles/crm/zoho/php-script-make-your-own-thumbnail-generator-via-api.html

29 May 2025 as some images are over 1Mb. So I needed a tool that every time a new product is added, a thumbnail gets generated and stored in the same application. Trawling through the first few pages of Google, all the online tools that did the same had a pricing...

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