Joes FREE Website Thumbnailer (JWT)http://mail.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 Tested on: Windows XP SP3, Windows 7 (both 32-bit) Tested with: MS Internet Explorer 7 libraries System Requirements: Used ~55Mb RAM on 1.6Ghz PC Free Disk space to store your pictures Installed MS Internet Explorer (only uses libraries) Program Size:...

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

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttp://mail.joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 Component The above will work as a SSIS Script task. At work however, we needed to separate it out so that it could be used in other SSIS packages. If we included an SSIS Script in each package, any change to the script would need to be repeated across...

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

SSIS: How to loop through multiple flat files as data sourceshttp://mail.joellipman.com/articles/microsoft/ssis/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html

13 June 2014 file as its source and to populate a database table with this data. Note that this only works if all the text files to be used as source data have the same number of columns and where the column widths match. How? I've adapted my real working product...

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

A quick run through of setting up an export process in SITShttp://mail.joellipman.com/articles/web-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

21 August 2014 something like A|Applicant) Click on "Apply" Include any additional entities as sub-entities under the parent one (not used in this demo) and repeat the steps above to select the exchange fields. Check/ensure the "In Use?" is ticked. Store/save your XET...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

ZohoRecruit: Create Linking Table for Candidates and Associated Job Openingshttp://mail.joellipman.com/articles/crm/zoho/zohorecruit-create-linking-table-for-candidates-and-associated-job-openings.html

08 February 2023 Job Opening Ref m_Create.put("Vacancy Ref",r_Data.get("Job_Opening_ID")); // // update the record (note the API name being used here) r_Create = zoho.recruit.addRecord("CustomModule6",m_Create,0,false,"my_connection"); //info r_Create; } } } } For...

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

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

06 March 2023 options: "user", "assistant", "system". Add a file upload field called "Big Data" Add a single line field called "Title" (used as a multi-line cannot be used in the listview). Add a multi-line field called "Content" and change the properties on creation...

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

Zoho Creator: Get Images in Report to be Exported to PDFhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-get-images-in-report-to-be-exported-to-pdf.html

26 January 2024 whenever the ticket form is submitted either on creation or modification. The function to rule-them-all This code was used for testing, then for correcting any historical records, and then when given just one ticket reference; will create or update the...

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

ZohoCRM & Xero: Function to pull most recent quoteshttp://mail.joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-quotes.html

13 October 2025 puts the product name in the description field How? Because my head is a little fried, I'm putting the two functions I used here and I'll document further if I remember. Note that the pre-amble is to generate a Xero access token which I documented in...

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

Database Error: Unable to connect to the database: Could not connect to MySQLhttp://mail.joellipman.com/articles/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

25 September 2009 the error happened less... I then went through the menus and installation screen to get rid of anything that was not visibly used on the website. The website was working fine and I was able resume my click-happy habits. It's a given that in my test,...

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

Installing phpBB3 for Joomla with a RocketTheme templatehttp://mail.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

28 September 2009 Bear this in mind during the installation process. Before we begin: I have to admit this took me a while. I had never used phpBB3 before nor were the instructions for applying the template and integrating it into Joomla that straightforward. It doesn't...

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

Webdeveloper-Speakhttp://mail.joellipman.com/articles/web-development/webdeveloper-speak.html

13 July 2010 the first letter of each word, and is pronounced as a series of individual letters. For example HTML (the computer language used to author webpages), is an initialism of HyperText Markup Language, and is pronounced: “H-T-M-L”. (Um... think I just call...

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

Inserting incremental weeks in MySQLhttp://mail.joellipman.com/articles/database/mysql/inserting-incremental-weeks-in-mysql.html

15 April 2011 the developer wrote a system he felt would last the rest of his PhD degree, it's a shame he started in his last year. He used functions to mktime and simulate the dates. A function goes in with a normal calendar date and returns an academic week number...

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

Developer's Checklist: Taking over a projecthttp://mail.joellipman.com/articles/web-development/developers-checklist-taking-over-a-project.html

01 March 2011 that still needs addressing?) System Requirements (in case you need to transfer/move to another server) Critical functions used in the system? (do this yourself anyway and use theirs as a guide only) Site Authentication Method(s) (will this need to be...

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

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

07 July 2011 on your website and RocketTheme templates would create a style that was hard to customize. Remository Really liked this and used for the best of 2 years. But 1000 downloads in 10 days caused it to crash my Joomla! website. It was very plain and basic,...

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

SSRS Querying on either of 2 Parametershttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

19 July 2011 First(Fields!S_STUDENTREFERENCE.Value, "StudentDetails")) should work: Apparently not because "fields cannot be used in report parameter expressions". I tried this with "Default values" and got the same problems. Note: before you try, "Variable values...

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

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

19 September 2011 to about once a week. In cases where there are no photos, SSRS displays a mini ugly red cross. On the system that used to do this, we could use the HTML attribute "OnError" to load an alternative image. We would like something similar for SSRS. Solution...

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

Returning Oracle Stored Procedure Resultset in SSRShttp://mail.joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

19 January 2012 parameters. 4c. Add a dataset: the "Parameter Names" Under "Parameter Name" type the exact same name for the input variable used in your Oracle stored procedure (in my example: p_STUDENT_ADNAME). Under "Parameter Value" type the exact same name of your...

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

DataJumble - Shuffling characters in a data valuehttp://mail.joellipman.com/articles/database/t-sql/data-shuffling-function.html

01 August 2012 Usr 1964-08-08 Precursor You will need to be able to create the following view to generate random numbers on SQL Server. -- Used to reference RAND with in a function CREATE VIEW dbo.vwRandom AS SELECT RAND() as RandomValue; GO The Function Again you...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

Search a database with SOUNDEXhttp://mail.joellipman.com/articles/database/search-a-database-with-soundex.html

11 October 2012 @myCounter = 0; SET @minStrLen = LEN(@p_SearchString) - 1; SET @maxStrLen = LEN(@p_SearchString) + 1; -- Populate Cursor1 (used to generate final SQL query to run) DECLARE Cursor1 CURSOR FOR SELECT 'SELECT ' + COLUMN_NAME + ' COLLATE...

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

DataScramble - Randomizing data rowshttp://mail.joellipman.com/articles/database/t-sql/datascramble-randomizing-data-rows.html

07 December 2012 on SQL Server. -- Drop the view if it already exists IF OBJECT_ID ('vwRandom', 'V') IS NOT NULL DROP VIEW vwRandom ; GO -- Used to reference RAND within a function CREATE VIEW vwRandom AS SELECT RAND() as RandomValue; GO The Function -- Drop the...

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