Welcome to the Agile Timesheet Automation repository! Here, you will find the necessary steps to automate your Agile Timesheet process seamlessly.
Ensure you have the following prerequisites installed on your system by following the installation steps given in the below steps:
- Microsoft Office 2007 or newer.
- Selenium Basic
- EA Sendmail Component Manager
- Chrome Web Browser
- Browser Driver (Chromedriver)
- Open Excel by searching for it in the start menu.
- Navigate to File > Excel Options > Trust Center > Trust Center Settings > ActiveX Settings. Ensure that the options 'Enable all controls without restrictions and without prompting' and 'Safe mode' are enabled as shown in the screenshot below.
- Click 'OK' to save the changes.
- Next, go to File > Excel Options > Trust Center > Trust Center Settings > Macro Settings. Make sure that 'Enable All macros' and 'Trust Access to the VBA project object model' are enabled, as shown in the screenshot.
- Click 'OK' again to save the changes.
- Download the Selenium Basic Download executable from the provided link.
- Install Selenium Basic.
- Download the EA Sendmail Component Manager Download executable from the provided link.
- Install EA Sendmail Component Manager.
-
Launch Chrome browser or install it if not already installed.
-
Navigate to Settings > About Chrome and note the version number.
-
Download the compatible version of Chromedriver Download using the provided link based on your Chrome version.
-
Replace the existing Chromedriver in the installation path of Selenium Basic with the downloaded one.
4.1 Clone this repository [Or] Click Here to download โ Download
Clone this repository to your local machine to access the macro-enabled Excel file or download it from releases
- Make a new folder and open the command prompt.
- Input the below command.
git clone https://github.com/Jaisurya-Ravi/Agile-Time-Using-Excel-Macro.git
- After completion, you will be able to access the macro-enabled Excel file.
- Right-click on the downloaded Excel file and select 'Properties.'
- Ensure that the 'Unblock' option is checked under the general tab. Click 'Apply' and then 'OK' to enable security permissions for the Excel sheet, as shown in the screenshot below.
- Open the downloaded AgileTime Excel file.
- Navigate to File > Excel Options > Quick Access Toolbar. Check that the option 'Show Quick Access Toolbar below the Ribbon' is selected, then click 'OK' to apply the changes. as shown in the screenshot below.
- User Details Sheet - Input your Agile Time username, password, email ID, and manager ID in the corresponding cells.
- Master Details Sheet and 'Update Master Data' Button - Automatically updates eligible task details from your Agile Time records when you click 'Update master data.'
- Timesheet Details Sheet and 'Upload Timesheet' Button - Fill out task details, clicking 'Upload timesheet' updates your timesheet in Agile Time.
- Configuration Sheet and 'Mail My Timesheet' Button - Configure email settings like SMTP address, host, sender email ID, subject, and body. 'Mail my Timesheet' sends an email to your specified address.
- 'User Details' Button - Navigates to the 'User Details' Sheet.
- 'Master Details' Button - Navigates to the 'Master Details' Sheet.
- 'Mail Configuration' Button - Navigates to the 'Configuration' Sheet.
- 'Fill Timesheet Details' Button - Navigates to the 'Timesheet Details' Sheet upon click.
Report a problem(Issue) Click Here when encountering difficulties with configuration or when using the functionality.