PHP Issue: simplexml_load_string parser error : Input is not proper UTF-8, indicate encoding !https://joellipman.com/articles/web-development/php/php-issue-simplexml-load-string-parser-error-input-is-not-proper-utf-8-indicate-encoding.html

02 August 2016 How? A two-step process, my issue was with how the file was downloaded with cURL. The XML node should be baños. The initial command using cURL was: function get_data($url) { $ch = curl_init(); $timeout = 5; curl_setopt($ch, CURLOPT_URL, $url);...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

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 BY 'mybackupuser'; Or via cPanel the following screenshot when adding a user to a database: Method #1: The following command on a cron job: // not recommended: /usr/bin/mysqldump -u dbusername -p'dbpassword' dbname > /path_to/backup.sql // recommended:...

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

Windows 10: Shortcut Apps to Settingshttps://joellipman.com/articles/microsoft/windows-os/windows-10-shortcut-apps-to-settings.html

30 July 2020 To: Microsoft Windows 10 Pro v10.0.18362 What? This is a list of apps that if run via the run command, or used in a desktop shortcut, or that you want to include in automation software such as AutoHotkey, opens any specific Windows OS settings page....

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

Zoho Creator: Create a Widget which uses JavaScripthttps://joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 and ensure that you have permission to install the above, then re-install. Install the Zoho Extension Toolkit (ZET) via command line interface (CLI) In the terminal, type: npm install –g zoho-extension-toolkit If you get errors like “Missing write...

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

PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttps://joellipman.com/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html

12 March 2022 Driver" Either via the device manager or just from pure frustration, you should get a prompt to download the Intel Graphics Command Center app from the Microsoft Store (if you don't get prompted, just go get it and install it). Install it > Agree to...

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

The greatest invention in IThttps://joellipman.com/hardware/the-greatest-invention-in-it.html

13 September 2012 C. Thomas of IBM, noted that "It would be quite useful to permit users to 'take back' at least the immediately preceding command (by issuing some special 'undo' command)." Source: Behavioral Issues in the Use of Interactive Systems. If you've guessed...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

Zoho Deluge: Nested Catch Statementshttps://joellipman.com/articles/crm/zoho/zoho-deluge-nested-catch-statements.html

04 February 2025 anyone says I'm only try catching a doomed conversion from string to integer; I've applied this to an actual invokeURL command rather than just an info output. try { r_GeneratePDF = invokeurl [ url: v_EndpointServer1 type: POST parameters: m_Html...

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

Using a HTML form and PHP to upload a filehttps://joellipman.com/articles/web-development/php/using-a-html-form-and-php-to-upload-a-file.html

17 September 2009 the full path to the folder that you will be uploading the files to and should be 755 (ie. rwxr-xr-x). The change ownership command in shell is 'chown -R apache:apache '. 3. Check that your PHP ini specifies a reasonable maximum file size limit. By...

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

Windows 7 Aero Featureshttps://joellipman.com/articles/microsoft/windows-os/windows-7-aero-features.html

27 April 2010 the Alt key and pressing Tab will give you the more traditional window switcher (2D). Assigning Aero Flip 3D to a shortcut command: Visit http://www.paraesthesia.com/archive/2010/04/16/fun-with-windows-aero-flip-3d.aspx as this was not my idea but quite...

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

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

09 November 2010 in all user tables. db_ddladmin Members of the db_ddladmin fixed database role can run any Data Definition Language (DDL) command in a database. db_denydatareader Members of the db_denydatareader fixed database role cannot read any data in the user...

• 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 how logoff is not the same thing as restart and reminded on both IT and environmental policies. Tech Notes: For PCs: Run a command prompt and type systeminfo: Look for "System Up Time". A staff member in a partner institution: "By the way my printer has...

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

SSRS Parameters in Oracle Stored Procedurehttps://joellipman.com/articles/microsoft/ssrs/ssrs-parameters-in-oracle-stored-procedure.html

02 September 2011 execute our stored procedure. Here we have called the dataset to launch the Stored Procedure as "SP". You can specify command type and stored procedure name here or you can do this in the next screenshot. Note how all our variables are hidden and cannot...

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

Fun with DllCall in AutoHotkeyhttps://joellipman.com/articles/automation/autohotkey/fun-with-dllcall-in-autohotkey.html

27 September 2011 there are more fun things to do out there. If you're the type of AutoHotkey programmer that doesn't like having to use the command prompt to write to an extra text file which your program has to read, then this is for you. DllCall will usually run...

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

Joes DNS Correction (JDC)https://joellipman.com/component/content/article/joes-dns-correction2.html?catid=40

25 November 2011 to either the TFS or my target deploy location. I found a quicker fix than rebooting your computer which is to open a command prompt and to type "ipconfig /flushdns" then "ipconfig /registerdns" and the connections would have been restored. As I love...

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

Fix Oracle Tnsping 3511 without Windows Registryhttps://joellipman.com/articles/database/pl-sql/fix-oracle-tnsping-3511-without-windows-registry.html

04 March 2013 used that we must maintain (current value at "C:\app\\product\11.2.0\client_1\bin") Setting environment variables using the Command prompt (DOS) wouldn't stick (session only). My Fix Right-click on "My Computer" > select "Properties" Click on "Advanced...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

Autohotkey Count Number of Files/Folders in a Directoryhttps://joellipman.com/articles/automation/autohotkey/autohotkey-count-number-of-files-folders-in-a-directory.html

04 June 2013 Folder := fso.GetFolder(Folder) return fso.GetFolder(Folder).Files.Count } Method #5: MS-DOS Command Prompt dir c:\*.* /os /s -- bear with me as i try to create a for loop one to omit all the header info

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

Compare two databases using T-SQLhttps://joellipman.com/articles/database/t-sql/compare-two-databases-using-t-sql.html

24 September 2013 #1 I got this first query from the awesome site that is StackOverflow: SELECT * FROM INFORMATION_SCHEMA.COLUMNS Run this command against both databases and you have their full schemas. Use a comparison tool to compare the outputs. Method #2 Enhancing...

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

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

04 October 2013 Note: Currently SSIS/BIDS only supporting assemblies compiled with .Net 3.5 Take it to the GAC Run a command prompt as Administrator Change working directory to location of GACUtil CD C:\Program Files\Microsoft SDKs\Windows\v7.0A\bin Run the GAC and add...

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

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

21 August 2014 our demo we want all the key fields: Store/save your DOR Setting up the DataEvent-Out-Tray Rule (EOR) Here we enter the SQL command (if using SQL db connector) which will output the data to a MSSQL database. Run EOR from the menu system Enter a EOR code...

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

Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

15 May 2020 to use a subform with the file upload field type so our record can have more than 1 file attached to it. the CRM.attachFile command Okay as a first example, there is a problem here, you asked for Books and this next bit shows how to attach it to a CRM...

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