Search - Joel Lipman .Com

1. Enterprise Project Management: / Category /; Created on 05 March 2020
2. Customer Relationship Management Systems: / Category /; Created on 05 March 2020
3. Content Management Systems: / Category /; Created on 05 March 2020
4. Zoho Deluge: Determine your Statement Execution Limit: / Zoho /; ... to have to be asked directly to Zoho rather than using the online subscription plan management section. Statement Execution Limit is 5000 The following will run resulting in the error "Number of ...; Created on 31 July 2024
5. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... article link above), we're going to use the GetOrders call for order (sales) management. /* Function: fn_GetEbayOrders() Purpose: Queries eBay for all orders for a specified year ...; Created on 29 March 2023
6. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... ZDK.Page.getForm().setValues(); ZDK.Page.getForm().setValues(); // start subform management // ***************************************** // declare the new row and JSON argument ...; Created on 09 December 2022
7. Zoho CRM: Schedule a Task: Timesheet Reminder: / Zoho /; ... time in our CRM. We're meant to do 40 hours, not just for Management, but for deducting from project and support bundles. How? The following snippet of code is on a CRM schedule set to run every ...; Created on 02 December 2021
8. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... ; // deprecated // use inventory_levels m_Variant.put("inventory_policy","deny"); m_Variant.put("inventory_management","shopify"); m_Variant.put("inventoryItem",); // not working // use inventory_items l_Variants.add(m_Variant); m_Product.put("variants",l_Variants); // ...; Created on 17 October 2021
9. Windows 10: Shortcut Apps to Settings: / Windows OS /; ... Audio and speech ms-settings:holographic-audio Environment ms-settings:privacy-holographic-environment Headset display ms-settings:holographic-headset Uninstall ms-settings:holographic-management ...; Created on 30 July 2020
10. Convert foreign characters to English alphabet: / MySQL /; What? A quick article showing my MySQL statement when I want to remove all the accents from foreign characters and return the English equivalent. Why? A content management system (CMS) that I' ...; Created on 13 June 2016
11. SELECT COUNT(DISTINCT name) FROM table: / Joomla /; What? A quick article to remind me about this issue. Not sure whether it is specific to the Joomla Content Management System, but within the Joomla! CMS, an error 1054 comes up if you use the above ...; Created on 24 September 2015
12. Joes Google Map for Joomla (JGM): / Product Documentation /; What? This article serves as documentation for a module extension I made for the Joomla Content Management System versions 2.5 or later. Why? Could have probably used someone else's. I think there' ...; Created on 13 April 2015
13. Quadcopter App with Flight Restrictions (JQA): / Product Documentation /; ... (for account management) • Your password to my website (password reset only) • Your public name (full Name) • Your membership type • Your app preferences • Any user-specified shared item What ...; Created on 24 October 2014
14. Include a carriage return in a column heading: / SQL Server /; ... you refresh the data, it will retain the carriage return in the column headings. Additional: Only appears obvious in SQL Server Management Studio resultset. Remember to format the cells (column ...; Created on 07 July 2014
15. SSRS: Performance Improvements: SELECT TOP: / SQL Server Reporting Services /; ... world. Where do the extra 9 minutes come from? Not the SQL as this runs in 00:00 seconds in SQL Server Management Studio. Not the internal processing and rendering as the report server says it did this ...; Created on 07 March 2014
16. Generate a Timesheet in MySQL: / MySQL /; ... EPM (Microsoft Enterprise Project Management) more and more. Similar systems have popped out that support some form of time recording and activity logging. The example below however is within a LAMP/MySQL ...; Created on 05 December 2013
17. Client Services: Website Development Agreement: / Static Items /; ... scripts which have sped up development on similar projects, I have bespoke project management systems which manage my work accurately (eg. my Project Analysis Manager - dubbed PAM - can tell me how long ...; Created on 15 November 2013
18. Compare two databases using T-SQL: / Transact-SQL /; Applies to: MS SQL Server Management Studio 2008 Two Transact-SQL databases What? A quick article on how to compare two Microsoft databases using the tools provided with SQL Server and without ...; Created on 24 September 2013
19. Restore MSSQL Error: Database is in use: / Databases /; ... warrant its own article but for those of us who merely use SQL Server Management Studio (SSMS) and Microsoft's SQL Server 2008 R2 for development purposes, the once-in-a-blue-moon restore from backup process ...; Created on 08 March 2013
20. Fix Oracle Tnsping 3511 without Windows Registry: / Oracle PL/SQL /; ... these aren't our databases, we simply help support them. You say less than ideal, I say realistic. Quit complaining about processes and management and instead prove your worth. I'm good at what I do because ...; Created on 04 March 2013