![]() The starting point for Linking is the Customizable Data Export report.A secure connection (SSL/https) is required to use this feature.Data Linking does not include support for Mac versions of Excel.It does not support integration of expense information. The Customizable Data Export allows access to time entry data.Please contact ClickTime Support if you have questions about upgrading in order to utilize XML Linking. Data Linking requires a Team/Corporate subscription (or above) - Basic/Starter plans will not be able to generate an XML link. ![]() The following requirements and restrictions apply to accounts that want to use the Linking feature: Excel) skills on the part of the account administrator/manager in charge of setting it up. This power tool involves advanced application (e.g. This is a multi-step process during the set up stage and becomes a simple one-step update action once all the settings are configured properly. This functionality allows you to request a saved Customizable Data Export report via a single secure web request without logging into ClickTime using the standard web application login interface. Linking allows your company to update your spreadsheet or database with fresh data from your ClickTime account on demand. ![]() in Excel, Sheets or similar applications, and some of the existing ClickTime reports do not fully match or replace your custom reporting, then Data Linking is the solution for you. If your company already uses an internal reporting system based on reports, charts, pivot tables, etc. Basic/Starter plans will not have the option to generate an XML link from the Customizable Data Export. Please note - XML linking requires a Team (or above) plan. Using the Customizable Data Export for Linking This information is also summarized in this pdf file. Please see the Excel Linking guide and Google Sheets Linking guide for more information. We also provide separate guides for linking specifically with Microsoft Excel and Google Sheets. This guide will provide basic details for connecting ClickTime data with external systems via Data Linking. This method allows applications such as Microsoft Excel and Google Sheets to request and retrieve data from the ClickTime system without using the standard web application login and graphical user interface.ĭata Linking starts with the Customizable Data Export Report - general information on using that report is available in the Customizable Data Export Overview Guide here. ClickTime can easily integrate your ClickTime data with your pre-existing external reports. ![]()
0 Comments
Leave a Reply. |