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

08 March 2013 the Restrict Access option, select Single. If other users are connected to the database, an Open Connections message will appear. To change the property and close all other connections, click Yes. Restoring in SSMS, Right-click on the database Select...

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

SSIS Skip Blank Rows in Flat File Sourcehttp://mail.joellipman.com/articles/microsoft/ssis/ssis-skip-blank-rows-in-flat-file-source.html

23 April 2013 than 1: Almost! A problem not covered by many sites was happening to me when I had blank rows in a flat file, where it appeared to add the special carriage return or line feed characters to the next viable row, see my original data file here (sample...

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

List of Font Awesomehttp://mail.joellipman.com/articles/web-development/list-of-font-awesome.html

04 September 2015 The List This is a copy of the cheat sheet version 4.4. If some icons don't appear on this page, it is because I have only copied over some of the entire directory (the icons I want to use). Note, change the width of your browser if the below list is...

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

Display Feeds to major Social Networkshttp://mail.joellipman.com/articles/web-development/display-feeds-to-major-social-networks.html

16 May 2016 video/picture to embed Click the 3 dots (ellipsis) at the bottom right of the description. Click Embed From the box that appears, Copy & Paste the code into your blog or website HTML. YouTube Go to YouTube and browse to your channel Hover the mouse over...

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

Zoho Templates - Font size is inexplicably tinyhttp://mail.joellipman.com/articles/crm/zoho/zoho-templates-font-size-is-inexplicably-tiny.html

22 February 2019 by an issue which I'd been working on for most of the day where I would remove all the styling and the text would still appear small. Sure I resized the text to about 46pt and everything was over 3000px in width but this is not good for a final...

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

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

15 May 2020 There is a lag/delay in the synchronization of Zoho Books to Zoho CRM and vice-versa. Annoyingly the attachment does not appear to be included in any sync... This method would be enough if the action was instantaneous and the attachments were also...

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

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

30 July 2020 ms-settings:network-wificalling Personalization Background ms-settings:personalization-background Choose which folders appear on Start ms-settings:personalization-start-places Colors ms-settings:personalization-colors ms-settings:colors Glance...

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

Zoho Deluge: Setup an API Connection for InvokeURLhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-setup-an-api-connection-for-invokeurl.html

12 August 2020 and Connect" You will get a popup confirming what this app will access and you should click on "Accept": A quick popup will appear to say connected. Done! Now you can use this in your custom function with the invokeURL without the need for a header...

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

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

06 December 2020 Records". Amazing! You're all done! Go test it by going to the report, hover the mouse over each row and a tickbox will appear, tick a few and click on your newly made button (as per the first screenshot on this article).

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

Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Delugehttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-mapping-a-multi-user-or-multi-lookup-field-using-deluge.html

28 April 2021 changes. I now query all the records held so far in this linking module which I'm guessing is called Quotes_X_Users (would appear in the popup once you start typing zoho.crm.getRecords. I'll get an array back of 2 records and I'll be looking for the 2...

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

Zoho CRM & Zoho Bookings Issue: Full Name appears in Last Name (first name first name last name)http://mail.joellipman.com/articles/crm/zoho/zoho-crm-zoho-bookings-full-name-appears-in-last-name.html

01 September 2021 A quick article to explain why the full name might appear in the last name field in Zoho CRM. Why? We had a customer report the issue that sometimes the full name of a contact was appearing in the last name field and creating a contact called "Firstname...

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

Zoho CRM: Standard Setup for Tax Rateshttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-standard-tax-rate-setup.html

02 September 2021 you click on the edit icon in the line item "Tax" you will see both options available to be ticked, the same popup will appear if you click on the edit icon in the header "Tax" (applies to subtotal). Note: If you do not do the second section as per this...

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

Zoho Creator/Deluge: UnPredictable exception, Invalid statement foundhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-deluge-unpredictable-exception,-invalid-statement-found.html

17 November 2021 Execution Failed UnPredictable exception, Invalid statement found Line:(20) I cannot guarantee that this error doesn't appear for other reasons but I will add to this article if I encounter any. This is simply how I fixed this error on this occasion....

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

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

12 March 2022 your PC Weirdly, the BIOS will load up on my one monitor connected to my motherboard, but my windows login screen will appear on my central monitor (after further reboots my daisy chained 2 monitors now load the bios logo with the primary monitor...

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

Zoho Books/Inventory: Trigger a workflow when an invoice has been paidhttp://mail.joellipman.com/articles/crm/zoho/zoho-books-inventory-trigger-a-workflow-when-an-invoice-has-been-paid.html

17 August 2022 needed to know what card they had paid with (if paid by card). The customer wanted payment method and payment date to appear on the invoice. How? This sounds rather straightforward, write a function that given an invoice, checks the customer payments...

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

ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttp://mail.joellipman.com/articles/crm/zoho/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html

05 December 2023 that the client needed to export the report and send it to suppliers; in ZohoAnalytics, the photos will not display (they appear as a URL) if the viewer is not a Zoho user belonging to the organization. Even in PDF format, the image is displayed as a...

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

Zoho Creator: Get Images in Report to be Exported to PDFhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-get-images-in-report-to-be-exported-to-pdf.html

26 January 2024 or chat. Customer can upload or send to agent to upload to a Zoho Desk support ticket as an attachment. The ticket will appear in a Quality Control report in Zoho Creator Staff can access the report via Zoho Creator and export it to PDF. They can then...

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

ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

14 May 2024 v_RemindTime = v_TimeOffset.addBusinessDay(1).toString("yyyy-MM-dd'T'HH:mm:ss", v_ThisTimeZone); // // want the reminder to appear daily until 3 days after creation date (inclusive of 4th?) v_EndTime =...

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

PHP Script: Make your own Thumbnail Generator via APIhttp://mail.joellipman.com/articles/crm/zoho/php-script-make-your-own-thumbnail-generator-via-api.html

29 May 2025 and makes it downloadable via URL. Why? Performance. I have a client with about 10k images of products that they want to appear in a dropdown menu of a JavaScript widget. When the user first loads up the webpage containing the widget, 10k images are...

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

ZohoBooks: Broken UK Banking Feedhttp://mail.joellipman.com/articles/crm/zoho/zohobooks-broken-uk-banking-feed.html

16 October 2025 Zoho migrated UK accounts to Open Banking connections handled by Plaid. The “via Plaid” or “via Yodlee” tags no longer appear in the UK interface; instead, you’ll see the bank listed as “& Country (United Kingdom).” Deleting accounts: Deleting a bank...

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