Administrator Program Shortcut without Prompthttps://joellipman.com/articles/microsoft/windows-os/administrator-program-shortcut-without-prompt.html

25 February 2013 to do. What? I want to create a desktop shortcut that I can double-click and it will run the above programs in administrator mode without confirmation by the Windows operating system. At home this may not be a problem but this is intended for those in...

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

Restore MSSQL Error: Database is in usehttps://joellipman.com/articles/database/restore-mssql-error-database-is-in-use.html

08 March 2013 the once-in-a-blue-moon restore from backup process is quickly forgotten. How? You need to set the database to single-user mode. In SSMS, connect to an instance of the SQL Server Database Engine, and then expand that instance. Right-click the database...

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

SSRS: Performance Improvements: SELECT TOPhttps://joellipman.com/articles/microsoft/ssrs/ssrs-performance-improvements-select-top.html

07 March 2014 (link not working!?) and eventually would display circa 3000 matching results. If I attempted to check this in "preview" mode using Business Intelligence Development Studio (BIDS / VS2008), the IDE would crash and close without warnings or...

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

Android OS: Add GoogleMap as fragmenthttps://joellipman.com/articles/google/androidos/android-os-add-googlemap-as-fragment.html

25 November 2014 example so that the homepage of the app (the starting page) will simply display a button to the map (in case of offline mode or incompatibility with the device). How? In this example, I'm going to add the map as a fragment. This is the most rudimentary...

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

Zoho Creator: Button on Report for Merging Multiple Selected Recordshttps://joellipman.com/articles/crm/zoho/zoho-creator-button-on-report-for-merging-multiple-selected-records.html

06 December 2020 Save your function and click on "Done" to ensure it's all saved in the system. Create the workflow Now go to a the "Design" mode of the report that contains the forms you want to be able to merge (multiple selection) and click on the "Actions" tab then...

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

Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments)https://joellipman.com/articles/crm/zoho/zoho-creator-download-file-from-zohocrm-field-type-file-upload-not-attachments.html

02 February 2021 &module=CustomModule1&parentId=123456789012345678&creatorId=987654321098765432&id=234567890123456789&name=dummy1.pdf&downLoadMode=default", "delete_Url":...

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

ZohoCRM: Template: not being able to edit a text boxhttps://joellipman.com/articles/crm/zoho/zohocrm-template-not-being-able-to-edit-a-text-box.html

25 January 2022 Login to ZohoCRM > Setup > Templates > Inventory Click on the name of the problematic template to enter a Preview Edit mode (not the pencil icon) Click on the clone icon (just below the pencil icon) Give it a new name, possibly the same name but with a...

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

Zoho Inventory & eBay Picture Services: UploadSiteHostedPictureshttps://joellipman.com/articles/crm/zoho/zoho-inventory-ebay-picture-services-uploadsitehostedpictures.html

31 March 2022 a connection from Zoho Creator to Zoho Inventory 3 lines icon in the top-left of your Creator (in edit this application mode) Then go to Setup > Connections > Add Connection Select Zoho OAuth and specify the scope(s) ZohoInventory.items.READ (add some...

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

GoDaddy Apache cPanel: Install SSL Certificatehttps://joellipman.com/articles/linux/cpanel/godaddy-apache-cpanel-install-ssl-certificate.html

07 April 2022 and followed the steps above but it kept showing the certificate for last year. Chatted to GoDaddy who said use incognito mode and clear cached files - same result Downloaded the ZIP file from GoDaddy for the 7th time and extracted the 3 files Opened...

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

Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbohttps://joellipman.com/articles/crm/zoho/zoho-cliq-integrate-openai-and-chatgpt-3-5-turbo.html

13 February 2023 " + v_Token); m_Header.put("Content-Type","application/json"); // // build params of request m_Params = Map(); m_Params.put("model", "gpt-3.5-turbo"); m_Message = Map(); m_Message.put("role", "user"); m_Message.put("content", v_Question);...

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

ZohoBooks: Stripe Terminal Integrationhttps://joellipman.com/articles/crm/zoho/zohobooks-stripe-terminal-integration.html

16 March 2023 { m_CreatePayment = Map(); m_CreatePayment.put("customer_id",m_Invoice.get("customer_id")); m_CreatePayment.put("payment_mode","In Person - Card"); m_CreatePayment.put("amount",v_AmountReceived / 100);...

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

FTP on Mac: Failed to retrieve directory listinghttps://joellipman.com/articles/web-development/ftp/ftp-on-mac-failed-to-retrieve-directory-listing.html

06 October 2018 to make changes Firewall Options Untick "Block all incoming connections" Leave the boxes ticked EXCEPT for "Enable Stealth Mode" Settings Security and Privacy Firewall Firewall Options Note: the filezilla just appeared when it was running. I didn't add...

• Type: Article
• Author: Joel Lipman
• Category: File Transfer Protocol
• Language: *