Search - Joel Lipman .Com

1. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; What? This is a not-so-quick article that queries an eBay order and creates the relevant ZohoInventory item, contact, sales order, package slip, shipment order, invoice, payment records... Why? ...; Created on 27 April 2023
2. Zoho Analytics: Determine profits from invoices and purchase orders: / Zoho /; ... pe", if_null(c."Account Owner", c."Created By") AS "Account Manager ID", u."UserName" AS "Account Manager", if_null(sp."Name", if_null(sp4."Name", if_null(sp3."Name", if_null(sp2."Name", '-')))) AS "Sales Pe ...; Created on 03 November 2022
3. Amazon Kindle: Send PDFs to your Kindle: / Kindle /; ... part. Else, here is what you need to do. Go to the official Amazon home page that applies to your region. Sign in with your Amazon username and password. After you have logged in, look for the menu ...; Created on 29 June 2022
4. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; What? This is an article documenting how to create a Zoho Creator Widget which includes the Bootstrap and jQuery frameworks as well as other JavaScript functionality. Why? Quite simply that at ...; Created on 24 October 2020
5. Autohotkey - Chrome Profiles in Alphabetical Order: / AutoHotkey /; ... %MarginX%, %MarginY% Gui, Add, ListView, w396 h775 gOpenProfile -Hdr +Grid, Profile|Client ProfilePath := "C:\Users\" A_UserName "\AppData\Local\Google\Chrome\User Data\Profile*" Loop, Files, %ProfilePath%, ...; Created on 07 January 2020
6. Minimal Privileges for MySQL Database Backup Cron Job: / cPanel /; ... Method #1: The following command on a cron job: // not recommended: /usr/bin/mysqldump -u dbusername -p'dbpassword' dbname > /path_to/backup.sql // recommended: using credentials stored in external ...; Created on 20 March 2019
7. Windows Live Mail Error ID: 0x8DE00005: / Windows OS /; ... and tick 'Manually configure server settings'. Configure server settings complete as per the image below (changing the log-on username to your own): The downloading of all your folders ...; Created on 14 December 2016
8. Migrating from Joomla 2.5.x to 3.4.x: / Joomla /; ... ( `id`, `name`, `username`, `email`, `password`, `block`, `sendEmail`, `registerDate`, `lastvisitDate`, `activation`, `params`, `lastResetTime`, `resetCount`, `otpKey`, `otep`, `requireReset`) ...; Created on 12 September 2015
9. TravelPort Universal API - Ping Request with PHP-cURL: / API Miscellaneous /; Applies to: TravelPort Universal API PHP 4 or 5 cURL What? An article on how to resolve errors and setup a standard ping request using the TravelPort Universal API. This is to be achieved using ...; Created on 27 April 2015
10. Copy a Wordpress Site for Development: / Wordpress /; ... 'my_database_name'); /** MySQL database username */ define('DB_USER', 'my_database_user'); /** MySQL database password */ define('DB_PASSWORD', 'my_database_password'); /** MySQL hostname */ define('DB_HOST', ...; Created on 08 March 2015
11. Android: Keytool and Google Maps displaying grey: / AndroidOS /; Applies To: Microsoft Windows 7 Pro Android Studio v0.8.6 beta Java Development Kit v1.8.0_20 What? The article below serves as a checklist to ensure I don't release an app that only displays ...; Created on 31 October 2014
12. Quadcopter App with Flight Restrictions (JQA): / Product Documentation /; ... about you: • If shared, your public name (not unique and only the first name) • Your selected aircraft (by public name or \"anonymous\") What joellipman.com stores about you: • Your login/username ...; Created on 24 October 2014
13. Hide a Drive per User in Windows 7: / Windows OS /; ... Load Hive Navigate to that user's profile folder, usually C:\users\username in this case Users > Guest Enter NTUSER.DAT in the File name box. (This file is a system-hidden file, so it won't show up in ...; Created on 28 March 2014
14. Export Joomla Users script: / Joomla /; What? Somebody said I could pay to get an export list of my Joomla users. I said Joomla is a FREE OpenSource system, why? Why? I want to move a client's list of Joomla users to a new system which ...; Created on 28 February 2014
15. Joomla Development: Possible XML Filters: / Joomla /; ... to be an array PATH Forces value to be a file path USERNAME Forces value to only contain characters allowed in the selection of a Joomla username UNSET Completely remove any input RAW Allow ...; Created on 17 October 2013
16. Fix Oracle Tnsping 3511 without Windows Registry: / Oracle PL/SQL /; Applies to: - MS Windows 7 Enterprise What? So I can ping the server the Oracle 11g database sits on. I've installed the Oracle 11g client tools and can connect using sqlplus. But if I tnsping ...; Created on 04 March 2013
17. JDatabase: using the Joomla database with examples: / Joomla /; ... a new query object. $query = $db->getQuery(true); // build the SQL query $query->select($db->quoteName(array('p.user_id', 'u.username', 'u.real_name'))); $query->from($db->quoteName('#__user_profiles ...; Created on 27 January 2013
18. Setup a copy of your Joomla website: / Joomla /; ... usernames/passwords created in the previous steps. $sitename - I would suffix this with "TEST" so as to quickly distinguish this from your main website. $db, $user and $password - these are the database ...; Created on 19 December 2012
19. About 5 seconds worth of fun: / SharePoint /; ... Installer? http:///userdisp.aspx=ID=1 Paying attention to the URL this will show you the domain and username of this accountname in Active Directory. I know the AD domain and username, ...; Created on 21 November 2012
20. Connect to Joomla database in standalone script: / Joomla /; ... of these need to connect to the database but as they sit outside of the MVC structure, we need them to use the existing configuration file in order to retrieve the credentials (ie. username, password, ...; Created on 17 August 2012