How to change local folder for TFShttps://www.joellipman.com/articles/microsoft/tfs/how-to-change-local-folder-for-tfs.html

08 March 2012 Server (for me this was already done) Go to File > Source Control > Workspaces Edit... the workspace which is causing the problem Change the local folder All the files on TFS should copy over to your local folder; once done close the dialogs click on...

• Type: Article
• Author: Joel Lipman
• Category: Team Foundation Server
• Language: *

Vertically align an asterisk on a linehttps://www.joellipman.com/articles/web-development/css/vertically-align-an-asterisk-on-a-line.html

02 September 2012 this often increases the line-height and causes the overall line height to change for other objects in the same row. The problem afterwards was that the asterisk character would overlap the item beneath it (in this case #2) so when a user clicked on #2...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Background Gradient Disappears on Long Pageshttps://www.joellipman.com/articles/web-development/css/background-disappears-on-long-pages.html

20 November 2012 reveals the overall background (blue) making the text very hard to read. Why? Took me a while to figure out what was the problem, I'd visit some pages and they'd be fine, but when visiting a long page, it would initially display properly but then the...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Three boxes, two roll over, one falls outhttps://www.joellipman.com/articles/web-development/css/three-boxes-two-roll-over-one-falls-out.html

21 January 2013 code that was simply calculating with 33% as the third of the page width. Changing this to 990 pixels in width fixed the problem. I'm guessing this was because 990 divided by 33 leaves a remainder of zero but I'm not 100% sure this fixes the issue...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Set up Desktop SlideShow in Windows 7https://www.joellipman.com/articles/microsoft/windows-os/set-up-desktop-slideshow-in-windows-7.html

22 January 2013 on the desktop", "selecting Personalize", "clicking on Desktop Background", "browsing to the Picture Location". The problem happens when browsing to the picture location and it doesn't seem to remember which folder you selected. At home, this would be a...

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

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

25 February 2013 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 an office environment and we get prompted to login (with the same account as we're...

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

SSIS Convert a string into a datehttps://www.joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

14 March 2013 is flat file (account for line break): ISNULL(Last_Column) ? "" : TRIM(Last_Column) Last Troubleshooting Check: The problems here relate to when our datasource was a flat file connection. We had to change the Format under General to Ragged Right (I had...

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

Things to Check if Joomla Password Reminder email not being senthttps://www.joellipman.com/articles/cms/joomla/things-to-check-if-joomla-password-reminder-email-not-being-sent.html

09 May 2013 then ensure you are using a separate instance of the browser to your Joomla one. Check that your template isn’t the problem: If you have a test site that has the same error, change the site template to a default one and see if that works. Check your...

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

T-SQL Conversion failed when converting the varchar to data type inthttps://www.joellipman.com/articles/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

14 May 2013 FROM DMExtractEmployeeTable e2 LEFT JOIN DMExtractReferenceTable r2 ON e2.CodeType=r2.MapIn -- THIS IS THE LINE CAUSING THE PROBLEM!!! WHERE e2.ID=e1.ID GROUP BY e2.ID,r2.MapIn ) AS MatchingRecordsCount FROM DMExtractEmployeeTable1 e1 LEFT JOIN...

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

Call to a member function mark() on a non-object in Joomla CMShttps://www.joellipman.com/articles/cms/joomla/call-to-a-member-function-mark-on-a-non-object.html

17 November 2013 a standard Joomla update. I suspected that part of an auto-update process had corrupted all the files. In our case, the problem was that the system tried to update Akeeba (a 3rd party component to do backups) simultaneously or prior to updating the core...

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

Registered Users Cannot Login - Super Users Canhttps://www.joellipman.com/articles/cms/joomla/registered-users-cannot-login-super-users-can.html

26 February 2014 "Administrators" could login. However set the same test account to a "Super User" and they would be able to login. Was the problem authentication? Restricted access to a component? A load of blab on ACL managers? How? In our case, the website had...

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

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

07 March 2014 Studio. Not the internal processing and rendering as the report server says it did this in 0.4 seconds. So where's the problem? How? Left to its own devices, a search for "SMITH" as a surname would make the report spin for about 10 minutes without the...

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

Android: Keytool and Google Maps displaying greyhttps://www.joellipman.com/articles/google/androidos/android-keytool-and-google-maps-displaying-grey.html

31 October 2014 the Google APIs console other users could download the file from my website and see the maps. I'm not saying it won't fix a problem for you, just that downloading from the Play store was unrelated to the above. Additional: If you forget your key (like I...

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

Windows Live Mail Error ID: 0x8DE00005https://www.joellipman.com/articles/microsoft/windows-os/windows-live-mail-error-id-0x8de00005.html

14 December 2016 on this, I'm going to do a bunch of screenshots: The error is that I can't receive/send messages on this account. The problem has something to do with DeltaSync no longer being supported. Deactivate the account by deselecting "include this account when...

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

Zoho CRM & Zoho Books: Custom Related Lists Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-books-custom-related-lists-deluge.html

30 July 2021 m_RelatedList.put("data",l_DataRows); return m_RelatedList; Error(s) Encountered Sorry, there was a problem processing your request.: Your returned XML is invalid Sorry, there is a tag discrepancy in the function. The related list cannot be displayed.:...

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

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

17 August 2022 paid, update 2 custom fields with the Payment Method, and the Payment Date. Why? This was requested by a customer and the problem happened in that the workflow would simply not trigger when the invoice was paid. The customer had added 3 custom fields:...

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

Zoho Deluge: Shopify API: Get all active products with GraphQL and Paginationhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-shopify-api-get-all-active-products-with-graphql-and-pagination.html

20 February 2023 ensuring that Product IDs, Variant IDs, Inventory IDs, Current Selling Price, Inventory Level, and Barcode all match. Our problem is that sometimes more than 100 products are modified in a day... We need to be able to do more than 100 or at least resume...

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

Ubuntu as a media serverhttps://www.joellipman.com/articles/linux/ubuntu-as-a-media-server.html

19 September 2009 1. If someone wants to use Ubuntu as a home media pc connected to a tv, there is the problem of overscan; consumer tv's crop off the border around the image. How does Ubuntu intend to officially solve this? Right now LinuxMCE has it's own method for...

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

SSRS Repeat Headers in PDF Reporthttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-repeat-headers-in-pdf-report.html

26 October 2011 Problem I've set some tablix headers but when I request the same report in PDF format, the tablix headers only appear once on the first page. Every subsequent page simply displays the report header (which does not include the tablix header......

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

SSRS Subscriptions cannot be createdhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-subscriptions-cannot-be-created.html

22 November 2013 complicated then this, but it isn't. This is one of those rare situations when the Microsoft error is describing the exact problem. If you include linked images in the report (as in images not in the report itself but referring to other systems holding...

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