Assuming extract is required, the following 36 results were found.
-
added to the new database. Downloaded and uploaded the latest Joomla (at time of print this is version 5.2.3) as a ZIP Extracted this to the new 2025 production folder I created earlier Pointed a test.joellipman.com domain to the 2025 folder. Visited...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
In not as many words as others, here's my MySQL query to extract details on images stored in the MediaWiki CMS system (v1.14). Why? Prior to a migration and just after another change freeze, I had sent all Wiki articles modified since the last export...
- Type: Article
- Author: Joel Lipman
- Category: MediaWiki
- Language: en-GB
-
A quick article on if you want to extract the link from some text you have copied off the web and into an MS Excel document. How? Open up a new workbook. Get into VBA (Press Alt+F11) Insert a new module (Insert > Module) Copy and Paste the Excel user...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
ASC) as 'RowNumber' FROM ( -- start your original SQL query and save results as table t1 SELECT -- perform formatting to extract the minimum data here (eg. datetime into date, etc) * FROM [pretendDatabase].[pretendSchema].[pretendTable] t0 WHERE...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
This took me a while to find so I've posted an article below detailing how to parse or extract values from a string containing XML code. Why? I'm working with a system which stores XML strings in a database and rather than a separate file, it stores...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
ThisValue ) ColIndex++ } } Snippets Assume that "Haystack" is the string of code you want to parse (all content). Function ExtractText extracts text given a unique string to mark the start of the extract (1a), a second string (1b) to refine the starting...
- Type: Article
- Author: Joel Lipman
- Category: Hypertext Markup Language
- Language: en-GB
-
them to no end but because the end of the month didn't wait for me to finish the project, I quickly created this program to extract all the data values from an AwStats report. Advanced Web Statistics or AwStats, is a reporting system for server logs....
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
m_Webhook = crmAPIRequest.toMap(); // // check if user info is provided if(!isnull(m_Webhook.get("user_info"))) { // // extract user ID v_UserID = m_Webhook.get("user_info").get("id").toLong(); } // // if user ID was extracted sucessfully if(v_UserID !=...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
system privileges such as "drop table"). Upload the compressed file to your http://www.mysite.com/ web root folder and extract the zip to it (it should create a http://www.mysite.com/phpBB3 folder). If you don't have shell access, you can decompress the...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
it works for you. Pre-amble Requires Homebriew, FFMPEG, PIP, and Python: Open the "Terminal" app Type brew install ffmpeg Extract audio: ffmpeg -i your_video.mp4 -vn -ar 16000 -ac 1 -b:a 64k output_audio.mp3 [Optional if using online version of OpenAI...
- Type: Article
- Author: Joel Lipman
- Category: Apple
- Language: *
-
because of a potential loss of data.". Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "Extract dates from string dates" (3614)" failed because error code 0xC0049064 occurred, and the error row disposition on "output column...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
the cursor but no scrolling/swiping. Install 7-Zip (I'm aware there's a built-in compressor for Windows - but we need the "extract to..." option). > Install it Go and download the AppleBcUpdate.exe file from...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
another Template Download the Template package. Open your FTP Connection and go to \components\com_kunena\template\ Extract the folder "Template Name" into this directory ^ If in the package the folder "lib" contains, extract the files in the directory...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
as a rows in a table. This is for Oracle PL/SQL. My List: 1, 2, 3, 4, 5, 6 Yields: 1,2,3,4,5,6 Using this snippet SELECT EXTRACT (VALUE (d), '//row/text()').getstringval () AS AppNo FROM (SELECT XMLTYPE ( '' || REPLACE ( '1, 2, 3, 4, 5, 6' , ',', '') ||...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
Google Chrome Profile folders named "Profile 1", "Profile 2", etc. Scan the preferences file for JSON key "name" and extract value. Hide the first column in the list view (contains "Profile 1", "Profile 2",...) Sort the second column (contains "Joes...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
it will return a string of 5 random uppercase letters. Method #2: Convert time to letters I've previously used substring to extract the milliseconds into 5 numbers and get the remainder from dividing it by 26 (modulus)... This is NOT to be used for...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
character Trying to split a string into a list by the backslash character: v_File = "C:\Documents\My_File.txt"; // want to extract My_File.txt l_FileParts = v_File.toList("\\"); info l_FileParts.get(l_FileParts.size() - 1); // yields...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
and perhaps accompany that value with a timezone, several calculations happen in real-time making it really difficult to extract and use. The key trick I used was to actually use a single-line text to store the customer's requested time. Let's use the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
we cheat by creating a table in ZohoAnalytics rather than simply writing a query and using the 'asynchronous' method to extract the query result. To create an analytics table from a query, we do the following: Login to Zoho Analytics, and choose a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
which uses different login details for their Joomla database. The example below demonstrates how to get these details and extract data from the database. How? Based on a script I found on StackOverflow. Not sure what version they were using so I...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB