{"id":199,"date":"2023-12-29T19:11:41","date_gmt":"2023-12-29T10:11:41","guid":{"rendered":"https:\/\/www.fideltech.com\/case-studies\/?p=199"},"modified":"2025-04-14T17:45:02","modified_gmt":"2025-04-14T08:45:02","slug":"automation-bot-for-report-generating-from-redmine","status":"publish","type":"post","link":"https:\/\/www.fideltech.com\/case-studies\/automation-bot-for-report-generating-from-redmine\/","title":{"rendered":"Automation BOT for Report Generating from REDMINE"},"content":{"rendered":"\n[et_pb_section fb_built=&#8221;1&#8243; fullwidth=&#8221;on&#8221; _builder_version=&#8221;4.18.0&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_fullwidth_image src=&#8221;https:\/\/www.fideltech.com\/case-studies\/wp-content\/uploads\/2023\/12\/FidelSoftech-Blogs-Banner.jpg&#8221; alt=&#8221;Case Studies&#8221; _builder_version=&#8221;4.23.1&#8243; _module_preset=&#8221;default&#8221; custom_margin=&#8221;||||false|false&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_fullwidth_image][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; fullwidth=&#8221;on&#8221; _builder_version=&#8221;4.18.0&#8243; _module_preset=&#8221;default&#8221; custom_margin=&#8221;2px||0px||false|false&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_fullwidth_post_title meta=&#8221;off&#8221; featured_image=&#8221;off&#8221; _builder_version=&#8221;4.18.0&#8243; _module_preset=&#8221;default&#8221; title_text_align=&#8221;left&#8221; custom_margin=&#8221;0px||||false|false&#8221; custom_padding=&#8221;30px||||false|false&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_fullwidth_post_title][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.18.0&#8243; _module_preset=&#8221;default&#8221; custom_padding=&#8221;25px||||false|false&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row module_class=&#8221;inner-page&#8221; _builder_version=&#8221;4.18.0&#8243; _module_preset=&#8221;default&#8221; custom_padding=&#8221;0px||||false|false&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.18.0&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.23.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]The automation is used to make our work easier. The world is moving forward to using different technologies. Fidel is providing the solution with leading RPA tool Automation Anywhere.\n\nThis case study informs about use of Automation Anywhere tool \u2013 BOT FOR REDMINE Projects Report Generating.\n\n<h3>Bot Overview<\/h3>\n<p>This bot performs following:<\/p>\n<ol>\n<li>Generate report for multiple projects.<\/li>\n<li>Team member work reports of projects.<\/li>\n<li>Time tracking of multiple projects.<\/li>\n<\/ol>\n<iframe loading=\"lazy\" width=\"560\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/iQCPj4mLoTs?si=_J7iHRq5s7xljFf2\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen><\/iframe>\n<h3>Pre \u2013requisites<\/h3>\n<ol>\n<li>Automation Anywhere Enterprise v10.7 or above.<\/li>\n<li>Project Management system using Redmine<\/li>\n<\/ol>\n<h3>Features<\/h3>\n<p>Bot login to Redmine Tool, inserts user details to appropriate fields and generate project reports.<\/p>\n<h3>Benefits<\/h3>\n<ol>\n<li>Fast and efficient process.<\/li>\n<li>Accurate report generation.<\/li>\n<\/ol>\n<h3>How bot works?<\/h3>\n<p>This bot login to Redmine Tool, get all details from text file and generate report based on dates, selected mode i.e. week, month, year, also it track each member work report Bot can rename downloaded files with start and end date for each cycle. This bot able to work for 24*7 as per requirements.<\/p>\n<p><strong>Input Data<\/strong>: Bot take all details from text file which is require to generate reports such as Start and End Date, Users Names etc.<\/p>\n<p><strong>Output:<\/strong> After entering all details i.e. Dates and team members name bot will generate report in CSV file and store file in User-Defined folder.<\/p>\n<p><strong>Bot Execution Process<\/strong>:<\/p>\n<ol>\n<li>Bot prompt user choice for Redmine version i.e. Yes\/No.<\/li>\n<li>Bot Prompt message to Enter User Credential. I.e. Username and Password.<\/li>\n<li>Bot check for is Redmine window open or not.<\/li>\n<li>Bot launch website using IE browser.<\/li>\n<li>Enter the user credentials and click on login button.<\/li>\n<li>Go to reports page and insert all required details such as dates and user names\/team members name.<\/li>\n<li>Click on CSV option at Right bottom corner.<\/li>\n<li>Rename downloaded file by using Start and End date.<\/li>\n<\/ol>\n<h4>Error Handling<\/h4>\n<p>This bot can handle error by storing following details:<\/p>\n<p><strong>Logs<\/strong><\/p>\n<ul>\n<li>Error Logs Month-Day-Year.txt: In case of any error, this file logs error message along with time stamp<\/li>\n<\/ul>\n<p><strong>Snapshots<\/strong><\/p>\n<ul>\n<li>Error Snap Month-Day-Year.png: In case of any error, this file captures screenshot of error.<\/li>\n<\/ul>\n<p>As above, the Automation Anywhere offers much more to reduce human efforts in simple way, by automating repetitive tasks. It can be used in BPO, Financial Services, Healthcare, Insurance, Life Science, Manufacturing, Public Sector and Telecom.<\/p>\n<p>With Automation Anywhere based solutions from Fidel Technologies, the work process is automated to optimum use of resources and make use of talents in a better way.<\/p>\n<p>If you have manual processes that can be automated, contact Fidel at <a href=\"mailto:infofidel@fideltech.com\">infofidel@fideltech.com<\/a><\/p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;Section&#8221; module_class=&#8221;footer-cnt&#8221; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#103e66&#8243; custom_margin=&#8221;||-27px||false|false&#8221; custom_padding=&#8221;||30px||false|false&#8221; hover_enabled=&#8221;0&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221; sticky_enabled=&#8221;0&#8243;][et_pb_row column_structure=&#8221;1_2,1_2&#8243; _builder_version=&#8221;4.17.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_2&#8243; _builder_version=&#8221;4.17.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.19.5&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<h2 style=\"color: #ffffff;\">Is this Case Study interests you?<\/h2>\n<p style=\"color: #ffffff;\">If you found this case study similar to your requirement OR interested to get our services, please connect with us using form. We will be happy to respond.<\/p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; sticky_enabled=&#8221;0&#8243;]<p><span><\/span><\/p>\n<h3 style=\"color: #ffffff;\"><i id=\"et-info-phone\"><\/i>Call us<\/h3>\n<p><a href=\"tel:03-6261-3309\" onclick=\"gtag('event', 'generate_lead', {'event_category': 'engagement','event_label': 'Footer Phone Japan','value': '03-6261-3309'});\">03-6261-3309<\/a><\/p>\n<p><span><\/span><\/p>\n<h3 style=\"color: #ffffff;\"><i id=\"et-info-email\"><\/i> Email us<\/h3>\n<p><a href=\"mailto:infofidel@fideltech.com\" onclick=\"gtag(('event', 'generate_lead', {'event_category': 'engagement','event_label': 'Footer Email Japan','value': 'infofidel@fideltech.com'});\">infofidel@fideltech.com<\/a><\/p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;1_2&#8243; _builder_version=&#8221;4.17.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.23.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<div class=\"cf7sg-container\"><div id=\"cf7sg-form-footer-contact-form\" class=\"cf7-smart-grid has-grid key_footer-contact-form\">\n<div class=\"wpcf7 no-js\" id=\"wpcf7-f22-o1\" lang=\"en-US\" dir=\"ltr\" data-wpcf7-id=\"22\">\n<div class=\"screen-reader-response\"><p role=\"status\" aria-live=\"polite\" aria-atomic=\"true\"><\/p> <ul><\/ul><\/div>\n<form action=\"\/case-studies\/wp-json\/wp\/v2\/posts\/199#wpcf7-f22-o1\" method=\"post\" class=\"wpcf7-form init\" aria-label=\"Contact form\" novalidate=\"novalidate\" data-status=\"init\">\n<fieldset class=\"hidden-fields-container\"><input type=\"hidden\" name=\"_wpcf7\" value=\"22\" \/><input type=\"hidden\" name=\"_wpcf7_version\" value=\"6.1.7\" \/><input type=\"hidden\" name=\"_wpcf7_locale\" value=\"en_US\" \/><input type=\"hidden\" name=\"_wpcf7_unit_tag\" value=\"wpcf7-f22-o1\" \/><input type=\"hidden\" name=\"_wpcf7_container_post\" value=\"0\" \/><input type=\"hidden\" name=\"_wpcf7_posted_data_hash\" value=\"\" \/><input type=\"hidden\" name=\"_wpcf7_key\" value=\"footer-contact-form\" \/><input type=\"hidden\" name=\"_cf7sg_toggles\" value=\"\" \/><input type=\"hidden\" name=\"_cf7sg_version\" value=\"4.18.0\" \/><input type=\"hidden\" name=\"_wpnonce\" value=\"6ce1afdbc1\" \/>\n<\/fieldset>\n<div class=\"container\">\n  <div class=\"row\">\n    <div class=\"columns full\">\n      <div class=\"container cnt-mt\">\n        <div class=\"row\" style=\"padding-bottom: 20px\">\n          <div class=\"columns one-half\">\n            <div class=\"field text required\"><span class=\"wpcf7-form-control-wrap\" data-name=\"your-name\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-text wpcf7-validates-as-required\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Your Name*\" value=\"\" type=\"text\" name=\"your-name\" \/><\/span>\n              <p class=\"info-tip\"><\/p>\n            <\/div>\n          <\/div>\n          <div class=\"columns one-half\">\n            <div class=\"field email required\"><span class=\"wpcf7-form-control-wrap\" data-name=\"email-669\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-email wpcf7-validates-as-required wpcf7-text wpcf7-validates-as-email\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Corporate Email*\" value=\"\" type=\"email\" name=\"email-669\" \/><\/span>\n              <p class=\"info-tip\"><\/p>\n            <\/div>\n          <\/div>\n        <\/div>\n      <\/div>\n      <div class=\"container\">\n        <div class=\"row\" style=\"padding-bottom: 20px\">\n          <div class=\"columns one-half\">\n            <div class=\"field text required\"><span class=\"wpcf7-form-control-wrap\" data-name=\"company-name\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-text wpcf7-validates-as-required\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Company Name*\" value=\"\" type=\"text\" name=\"company-name\" \/><\/span>\n              <p class=\"info-tip\"><\/p>\n            <\/div>\n          <\/div>\n          <div class=\"columns one-half\">\n            <div class=\"field tel required\"><span class=\"wpcf7-form-control-wrap\" data-name=\"tel-536\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-tel wpcf7-validates-as-required wpcf7-text wpcf7-validates-as-tel\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Phone*\" value=\"\" type=\"tel\" name=\"tel-536\" \/><\/span>\n              <p class=\"info-tip\"><\/p>\n            <\/div>\n          <\/div>\n        <\/div>\n      <\/div>\n    <\/div>\n  <\/div>\n<\/div>\n<div class=\"container\">\n  <div class=\"row\" style=\"padding-bottom: 20px\">\n    <div class=\"columns full\">\n      <div class=\"field textarea required\"><span class=\"wpcf7-form-control-wrap\" data-name=\"Message\"><textarea cols=\"40\" rows=\"2\" maxlength=\"2000\" class=\"wpcf7-form-control wpcf7-textarea wpcf7-validates-as-required\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Message*\" name=\"Message\"><\/textarea><\/span>\n        <p class=\"info-tip\"><\/p>\n      <\/div>\n    <\/div>\n  <\/div>\n<\/div>\n<div class=\"container\">\n  <div class=\"row\" style=\"padding-bottom: 20px\">\n    <div class=\"columns full\">\n      <div class=\"field\"><label><\/label><div id=\"cf7sr-6ac3fd6db2f4e\" class=\"cf7sr-g-recaptcha\" data-theme=\"light\" data-type=\"image\" data-size=\"normal\" data-sitekey=\"6LcW5JAUAAAAAHRCNkfrX7zI14Oxgh2dP0KQg8Av\"><\/div><span class=\"wpcf7-form-control-wrap cf7sr-recaptcha\" data-name=\"cf7sr-recaptcha\"><input type=\"hidden\" name=\"cf7sr-recaptcha\" value=\"\" class=\"wpcf7-form-control\"><\/span>\n        <p class=\"info-tip\"><\/p>\n      <\/div>\n    <\/div>\n  <\/div>\n<\/div>\n<div class=\"container\">\n  <div class=\"row\" style=\"padding-bottom: 20px\">\n    <div class=\"columns full\">\n      <div class=\"field\"><label><\/label><span id=\"wpcf7-6ac3fd6db322a-wrapper\" class=\"wpcf7-form-control-wrap cf7apps-honeypot-wrap email-wrap\" data-cf7apps-honeypot=\"email\" style=\"position:absolute;width:1px;height:1px;padding:0;margin:-1px;overflow:hidden;clip:rect(0,0,0,0);white-space:nowrap;border:0;\"><input type=\"hidden\" name=\"email-random-hash\" value=\"20261006\"><input type=\"hidden\" name=\"email-time-token\" value=\"MTc5MTIyOTI5Mw==.65f1d23014e2ca82bb5602c0320dba467fd6390ee529ada4aa0eef34e178eed0\"><label\r\n\t\t    for=\"wpcf7-6ac3fd6db322a-field\"\r\n\t\t    class=\"hp-message\"\r\n        >Please leave this field empty.<\/label><input\r\n\t    id=\"wpcf7-6ac3fd6db322a-field\"\r\n\t    \r\n\t    class=\"wpcf7-form-control wpcf7-text\"\r\n\t    type=\"text\"\r\n\t    name=\"87svgd39br7k\"\r\n\t    value=\"\"\r\n\t    autocomplete=\"new-password\"\r\n\t    tabindex=\"1000\"\r\n\t    data-cf7apps-tabindex=\"1000\"\r\n    \/><\/span>\n        <p class=\"info-tip\"><\/p>\n      <\/div>\n    <\/div>\n  <\/div>\n<\/div>\n<div class=\"container\">\n  <div class=\"row\">\n    <div class=\"columns one-fourth\">\n      <div class=\"field\"><label><\/label><input class=\"wpcf7-form-control wpcf7-submit has-spinner\" type=\"submit\" value=\"Send\" \/>\n        <p class=\"info-tip\"><\/p>\n      <\/div>\n    <\/div>\n  <\/div>\n<\/div><div class=\"wpcf7-response-output\" aria-hidden=\"true\"><\/div>\n<\/form>\n<\/div>\n<\/div><\/div>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]\n","protected":false},"excerpt":{"rendered":"<p>The automation is used to make our work easier. The world is moving forward to using different technologies. Fidel is providing the solution with leading RPA tool Automation Anywhere. This case study informs about use of Automation Anywhere tool \u2013 BOT FOR REDMINE Projects Report Generating. Bot Overview This bot performs following: Generate report for [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":38,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"2880","footnotes":""},"categories":[14],"tags":[],"class_list":["post-199","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-software-development"],"_links":{"self":[{"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/posts\/199","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/comments?post=199"}],"version-history":[{"count":9,"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/posts\/199\/revisions"}],"predecessor-version":[{"id":313,"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/posts\/199\/revisions\/313"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/media\/38"}],"wp:attachment":[{"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/media?parent=199"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/categories?post=199"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/tags?post=199"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}