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

08 March 2012 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 the TFS icon in Source Control Explorer and check what it says next to "Local Path" (for me this said the name of the...

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

Sync Outlook 2007 Shared Calendar with SharePoint 2007http://mail.joellipman.com/articles/microsoft/sharepoint/sync-outlook-2007-shared-calendar-with-sharepoint-2007.html

09 November 2012 Steps: Open your Outlook 2007 Using MS Internet Explorer (demo below is version 8), bring up your SharePoint Calendar Click on Actions Select Connect to Outlook Allow the website to open a program on your computer (opens Outlook). Confirm the prompt...

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

Joes Revolver Map (JRM)http://mail.joellipman.com/component/content/article/joes-revolver-map-jrm.html?catid=40

07 December 2012 to your Joomla website admin panel Create a new Custom HTML Module In the "Custom HTML", either disable rich-text editor or click on the HTML button Paste the code you got from revolvermaps.com into the "Custom HTML" parameter. Demo

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

AwStats Data Parser (ADP)http://mail.joellipman.com/component/content/article/awstats-data-parser-adp.html?catid=40

03 April 2013 Awstats page (so there isn't the menu on the left) Run "Generate_AwStatsParsedData.exe" Select the file you saved in step 1 Click on "Go". What data does it return? Any table/grid in the Awstats report uniquely identified by the labels mentioned below....

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

SSIS Skip Rows in Excel Source filehttp://mail.joellipman.com/articles/microsoft/ssis/ssis-skip-rows-in-excel-source-file.html

04 April 2013 sheet where the first 10 rows are descriptions to the column, and then I have 38 columns ("A" to "AL"): In the data flow, click on the Excel datasource component so that it's selected. View the Properties panel for this. Under Custom Properties »...

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

Joomla Component: Set default params on installationhttp://mail.joellipman.com/articles/cms/joomla/joomla-component-set-default-params-on-installation.html

24 October 2013 because the parameters haven't been set. I need to go into the Joomla Admin panel, view the Options of the component, and click on "Save"... despite the fact that I don't change anything. How? Add the following line to the XML installation file:...

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

ReCaptcha alternative: Integrate PlayThru in JComments 2.3 for Joomla 2.5http://mail.joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-for-joomla.html

24 March 2014 Download the latest files from https://portal.areyouahuman.com/installation/php (If you want my cached download - v1.1.8: click here) Extract the ZIP file to a folder (should be about 4 php files) Modify the file ayah_config.php to match the publisher...

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

SSIS: How to loop through multiple flat files as data sourceshttp://mail.joellipman.com/articles/microsoft/ssis/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html

13 June 2014 "C:\Temp\SourceFiles\File00001.txt" - although I used a network share without any issues) Add a Connection Manager Right-click in "Connection Managers" Select "New Flat File Connection..." Browse to the first file in the folder to loop through and...

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

SITS: Export field code and namehttp://mail.joellipman.com/articles/web-development/xml/sits-export-field-code-and-name.html

12 August 2014 &G[entity.dictionary: |: Select the exchange fields (or container) to apply this to Select the "Export Format" tab and click on the chevrons ("»") next to the field to apply this to Enter the dictionary code, the entity code and then the inner SRL text...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

A quick run through of setting up an export process in SITShttp://mail.joellipman.com/articles/web-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

21 August 2014 bear this in mind, tick the "Valid for Export" and decide whether blanks are included in the output or not. Select and right-click on the entity and select "Edit... exchange fields" (in this case "Edit CAP exchange fields") Under "Exchange Fields",...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

Basic Android App using Google Maps and Current Locationhttp://mail.joellipman.com/articles/google/androidos/basic-android-app-using-google-maps-and-current-location.html

10 October 2014 activity to Mobile: select Google Maps Activity: Change the Title to what you want (don't change the activity or layout) and click on Finish: Get yourself a developers' Google Android Maps API Key (not necessarily the same as Google API Key) and enter...

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

Quadcopter App with Flight Restrictions (JQA)http://mail.joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 I use this to keep up-to-date with new legislation and developments on "drones". Tap once to see a brief description, click on the button to view the full article in your browser. Hangar New to the app I thought it would be really cool if I could change...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttp://mail.joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

02 February 2019 1000389324798977991) Enter the scope URL in the field One or More API Scopes (eg. https://www.googleapis.com/auth/drive) Click Authorize $api['gdrive']['impersonator'] = ""; 3. Google Endpoints Only change these if you need a different scope or if the...

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

AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktopshttp://mail.joellipman.com/articles/automation/autohotkey/autohotkey-ms-windows-10-open-apps-on-multiple-monitors-and-desktops.html

18 July 2019 target: microsoft.windowscommunicationsapps_8wekyb3d8bbwe!microsoft.windowslive.mail. The easiest way to do this is to right-click and drag to the desktop (or wherever you want to store shortcuts) then run the shortcut: RunWait,...

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

CSS Center an iFrame Horizontally and Verticallyhttp://mail.joellipman.com/articles/web-development/css/css-center-an-iframe-horizontally-and-vertically.html

23 September 2019 -50%); } DEMO: See my JSFiddle demo: https://jsfiddle.net/Jlipman/u5sew3ob/21 and modify the height of the iframe then click on 'Run'. The iframe is always centered even if the top is off screen.

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

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

30 July 2020 this article when there's a perfectly ok post on the Microsoft website? Well I could bookmark that page or save myself a click... How? To test any of the following, type the windows key and select "Run..." ( + R). Then type the value in the 2nd column...

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

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

02 February 2021 The Code to read, parse, create a holding record and generate a link for the customer portal user to click on: // accessing zoho.eu (not zoho.com) so adapt the 2 values v_CreatorBaseUrl = "https://creator.zoho.eu"; v_ZohoApisDC =...

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

Zoho Creator: Copy Subform to other Subformshttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-copy-subform-to-other-subforms.html

17 November 2021 creating an appointment/booking system and I want the user to be able to set entries in a subform called "Mondays" then to click a button which copies it to the remaining working days. How? So I have a form with 6 subforms which list staff/employee...

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

Zoho CRM & Creator: Download attachment and upload to Creator file fieldhttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-creator-download-attachment-and-upload-to-creator-file-field.html

11 March 2022 Why? My use case here is that we are creating a Creator app that will show the attachments on a CRM contact record (and be clickable). The complication here is that the user can use the Creator form to add a new attachment that will eventually be...

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

Zoho Creator: Embed Forms/Reports on a Pagehttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-embed-forms-reports-on-a-page.html

05 May 2022 if you have multiple iframes on a page and you only want part of the page to display different content dynamically or on click of a button: // embeds using DIV: allows for CSS styling // embed a form loading... // embed a report loading... // // embed...

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