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

25 February 2010 (eye-catchers, stickyness) Agree on splash / slideshow image(s) What will be included in terms of features (calendar, polls, login, etc) Progress Update and Review Website Page Layout Standard article / presentation page Contact form(s) Discuss page...

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

Report Builder 2.0 - Hide Series1https://joellipman.com/articles/microsoft/ssrs/report-builder-20-hide-series1.html

06 May 2010 SELECT _SMDBA_.Incident.[Incident #] ,_SMDBA_.Incident.[Group Name] ,_SMDBA_.Incident.[Close Date & Time] ,_SMDBA_.Incident.[Login ID Closed By] ,_SMDBA_.Incident.[Assigned To Full Name] ,_SMDBA_.Incident.[Incident Type] FROM _SMDBA_.Incident WHERE...

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

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

27 August 2010 Basically you've woken up this morning, visited your website, and all your K2 articles are gone !!!! If you login to your Joomla! administration panel (back-end) and look under k2 items, you should get the following error: Warning: Invalid argument...

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

Joes Word Cloud (JWC)https://joellipman.com/component/content/article/module-joes-word-cloud-jwc.html?catid=40

13 October 2010 Download the appropriate file for your system (see compatibility table below) Login to your Joomla admin panel and install as per usual. How to Use Install the ZIP using your Joomla! Admin Panel > Extension Manager View the module on your front-end to...

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

Create Read-Only Database User in SQL Serverhttps://joellipman.com/articles/database/create-read-only-database-user-in-sql-server.html

09 November 2010 to the AdventureWorks database. Using SQL Server Management Studio 2008: Connect to your database server. Expand Security > Logins. Right-click on the user who will be set as having read-only access (in this example "adventureworksro"). Select...

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

What's the problem? Amusing computer issueshttps://joellipman.com/articles/web-development/whats-the-problem-amusing-computer-reports.html

28 April 2011 on that computer has locked a database record.". "Well my colleague who's using that computer is in a meeting but I can login and do this for you". IT Policy: Do not share passwords. It defeats the whole purpose! A media student: "My computer has...

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

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

07 July 2011 Automatic changelogs based on support tickets/development requests. INSTALLATION Download the ZIP file from my website. Login to your Joomla! Administrator Panel. Go to "Extensions" > "Install/Uninstall". Click on the "Upload" button and select the file...

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

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

03 October 2011 user should have access to both databases in order for this to run smoothly: INSERT INTO my_wordpress_db.wp_users (ID, user_login, user_nicename, user_email, user_url, user_registered, user_activation_key, user_status, display_name ) SELECT a.id 'ID',...

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

Setup a copy of your Joomla websitehttps://joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

19 December 2012 with "TEST" so as to quickly distinguish this from your main website. $db, $user and $password - these are the database and login credentials. $ftp_user and $ftp_pass are the ftp credentials. $log_path and $tmp_path should also be updated. $robots - set...

• 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 Create a new database connection (or click on the plus sign in the connections tab), select the mySQL tab and complete the login details and host location... Done! Additional I wouldn't recommend using Oracle SQL Developer. You have to use mostly SQL to...

• 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 system. At home this may not be a problem but this is intended for those in an office environment and we get prompted to login (with the same account as we're currently logged-in with???) instead of being able to just click on "Yes". How? The gist is...

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

Country Lookup by IP address CSVhttps://joellipman.com/articles/database/mysql/country-lookup-by-ip-address.html

17 March 2013 name to use if necessary. Uncomment the drop statement if running for the second time. Modify the PHP file to use database login credentials, $db_host = "localhost"; // Database host name $db_user = "my_database_user"; // User for database...

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

Joes Password Analyzer (JPA)https://joellipman.com/component/content/article/joes-password-analyzer-jpa.html?catid=40

03 January 2014 the passwords will be easy to memorize or to type quickly. Companies using certain password systems can even send the login credentials to the remote machine for you, but does this just open another can of worms? The trick in my opinion is a memory aid....

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

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

23 October 2015 - [L,F] How-to-use: Browse to the folder you created in step 1 and this will be your new administrator URL. Caveat: If you login to the administrator section on a shared computer, ensure you close the browser (and all tabs) once done or this cookie will...

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

Zoho Deluge - Update Creator from CRMhttps://joellipman.com/articles/crm/zoho/zoho-deluge-update-creator-from-crm.html

18 February 2019 previous Super Admin account as a "Developer". How? I'm going to demo two methods here using the Setup the Connection Link Login to ZohoCRM as the creator super admin/owner (might not be the same as CRM super admin!!!) Go to Setup » Developer Space »...

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

Autohotkey - Chrome Profiles in Alphabetical Orderhttps://joellipman.com/articles/automation/autohotkey/autohotkey-chrome-profiles-in-alphabetical-order.html

07 January 2020 Title := "Joes Chrome Profile Opener" Desc := "This program will list all the Google Chrome profiles available from your login." Version := "1.0" Width := 400 Height := 800 BgColor := "FFFFFF" MarginX := 2 MarginY := 2 Options := "+Caption +Border...

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

Zoho CRM/Creator - Common Errors & Gotchashttps://joellipman.com/articles/crm/zoho/zoho-crm-creator-common-errors-gotchas.html

06 February 2020 to minor errors we run into. Problem: Zoho OAuth Connection: ERROR_invalid_operation_type Sounds rather straightforward, Login to ZohoCRM as Administrator > Setup > Developer Space > Connections > Add Connection > Give it a name and then select Scopes >...

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

Zoho Deluge: Duplicate/Clone a Recordhttps://joellipman.com/articles/crm/zoho/zoho-deluge-duplicate-clone-a-record.html

17 March 2020 Zoho OAuth Connector Just in case you don't know how to setup a Zoho OAuth Connector, here's how you do it in CRM: Login to Zoho CRM as an administrator and go to Setup Under Developer Space click on "Connections" Under Pick your Service click on "Zoho...

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

Zoho Deluge: Convert Xero Date (Unix Timestamp) to Standard Date Stringhttps://joellipman.com/articles/crm/zoho/zoho-deluge-convert-xero-date-unix-timestamp-to-standard-date-string.html

04 May 2020 v_ZohoTime = v_ZohoEpoch.toLong().toTime("yyyy-MM-dd HH:mm:ss", v_IanaTZname); // The best method is per client: // Login to Xero > Accounting > Accounting Settings > Financial Settings > Time Zone // convert to IANA TimeZone and hard-code this whenever...

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

Zoho Deluge: Get Image Uploaded in Creator Formhttps://joellipman.com/articles/crm/zoho/zoho-deluge-get-image-uploaded-in-creator-form.html

14 July 2020 So I'm going to start with 1 method and then update this article with other methods. Method #1: Display and access without login So the quickest is to have a form that has an image upload field. Create an entry with one image. Then... Go to Settings...

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