Excel Automation for GLPI

@Microlent

Your requirement is a good fit for automation: the goal should be to remove the manual export completely and make the technician report a reliable scheduled process. I’m Dr. Rajesh Rolen, with 20+ years of software development experience and 400+ completed projects on Freelancer.com with a 4.9/5 average rating. I can build this in Python, using the appropriate GLPI API or MariaDB queries depending on the available data and GLPI configuration, and generate a clean .xlsx report using a reliable Excel library. The solution can include technician-wise ticket counts, average and median resolution times, date-range filtering, validation against GLPI data, and unattended execution through cron or Windows Task Scheduler. The generated file can be saved to a shared location or distributed by email. I’ll structure the reporting layer so additional reports such as weekly/monthly summaries, ticket-status breakdowns, and performance metrics can be added without rewriting the core system. You’ll receive the complete commented source code, simple deployment instructions, and a verified test run showing the report data matches GLPI. Please open the chat and share the GLPI API details or database structure/access information. I can then review the current setup and discuss the implementation approach. Let’s connect in chat.

@tangramua

Hello,   We carefully studied the description of your project and we can confirm that we understand your needs and are also interested in your project. Our team has the necessary resources to start your project as soon as possible and complete it in a very short time.   We are 25 years in this business and our technical specialists have strong experience in PHP, Python, Visual Basic, Data Processing, Excel, Software Architecture, Automation, Database Management and other technologies relevant to your project.   Please, review our profile https://www.freelancer.com/u/tangramua where you can find detailed information about our company, our portfolio, and the client's recent reviews.   Please contact us via Freelancer Chat to discuss your project in details.    Best regards, Sales department Tangram Canada Inc.     

@kamransiyal9

HI! I am an expert web programmer. I have a lot of work experience in Laravel, Codeigniter, PHP, Wordpress, JavaScript, HTML, Vuejs, Reactjs, React Native, and MySQL. I can start right away. I want to discuss this project in detail. Please contact me to discuss more regarding this project. For more details Chat with me

@AZTURK1

Automating technician performance reports directly from GLPI's MariaDB schema avoids the lag and manual overhead of web interface exports. ✅ Python automation script using PyMySQL and openpyxl to pull from glpi_tickets and glpi_tickets_users, computing ticket volumes along with mean and median resolution times per technician. ✅ Headless execution scheduled via Linux cron or Windows Task Scheduler, delivering styled .xlsx files directly to an SMB/NFS share or via automated SMTP email. ✅ Read-only database credentials and non-blocking SQL queries tested first to guarantee zero lockups or performance impact on your live GLPI production database. ✅ 10+ years production experience | 400+ completed projects | 320+ five-star reviews ✅ Microsoft® Certified: MCSA | MCSE | MCT & cPanel Certified (CWSA-2) Do you calculate resolution times purely as calendar elapsed time (solvedate minus date_creation), or do we need to factor in GLPI business hour calendars and SLA pauses? I can deliver this in 2 day(s) for 100000 USD and can jump on it right now.

@worksoft

Hi, We are a team with expertise in development, deployment & maintenance of data-driven process automation software. We can develop a scalable process to automate data from your GLPI instance. We plan to build a dynamic engine for this so that you can add any new reports to export and set different schedules for exporting with additional features. We prefer using GLPI APIs for this purpose however the final approach will be designed once we discuss details of your report requirements & purpose of this export. Let's connect & discuss so that we can share a detailed proposal. Regards, Sujata

@KarthikTechCon

Hi, I'm Karthik, a seasoned developer with over 15 years of experience in automation and data processing. I can help you automate your GLPI data export to Excel, streamlining your reporting process effectively. Proposed Solution: 1. Automation Script: I will create a Python script that pulls data directly from your GLPI database via API or SQL, generating a clean .xlsx file with technician details and ticket metrics. 2. Scheduling: The script will be easily scheduled using cron or Windows Task Scheduler, ensuring it runs unattended. 3. Delivery: The output file will be saved in a designated shared folder or sent via email, based on your preference. Additional Insights: I can also recommend enhancements like weekly summaries and performance dashboards to add value to your reports. Deliverables: - Well-commented source code. - Clear deployment instructions for sysadmins. - A successful test run demonstrating accurate data. I estimate a completion time of 1 week, using Python and pandas for data handling. I look forward to your feedback and am ready to discuss further. Best, Karthik

@hayteekeys

HI, KINDLY READ THROUGH MY PROPOSAL I will build a fully automated, unattended script that pulls technician ticket counts plus average and median resolution times from your GLPI instance and generates a clean Excel file on a schedule, ready to drop into a shared folder or email. MY APPROACH ✅ Direct extraction from GLPI database or API for accurate counts and times ✅ Clean .xlsx output compatible with Excel and LibreOffice ✅ Scheduled via cron or Windows Task Scheduler with zero manual steps ✅ Well-commented source code and 30-minute sysadmin deployment guide ✅ Easy extension path for weekly/monthly summaries or status breakdowns DELIVERABLES - Source code (Python preferred) fully commented - Clear deployment instructions - Successful test run with correct technician metrics QUESTIONS 1. Preferred output method (shared folder path or email)? 2. Desired schedule (daily, weekly, monthly)? 3. Any specific GLPI ticket statuses or date filters to include? Ready to start as soon as SSH/database access details and preferred schedule are confirmed.

@Sv3nie

Hi, A scheduled Python script that reads your GLPI MariaDB and writes the technician xlsx is a small automation job I do often alongside my full-stack work. Lets get in contact first.

@Solutionzhere

SolutionzHere has automated 10+ GLPI reporting pipelines (Python + pandas + openpyxl) with scheduled Excel exports. We'll build a cron/Task Scheduler script pulling technician stats (ticket counts, avg/median resolution time) and email/drop the .xlsx. Budget: $1.2K fixed. Timeline: 5 days. Quick question: Do you prefer Python (pandas) or PHP (PHPSpreadsheet) for the script?

@Aaleen110

This job is about extracting specific ticket data from GLPI and putting it into a scheduled Excel report, so I'll build this as a Python script. Python has excellent libraries for database connections and Excel file generation, which is what this needs. I’d use `pyodbc` to connect directly to your GLPI database. The script will query for technicians, ticket counts, and resolution times, and then use `openpyxl` to write that data into a new `.xlsx` file. This approach is easier to maintain long-term than a GLPI plugin, also it avoids touching the core GLPI application. I’d set this up to run via Windows Task Scheduler. For the reporting frequency, weekly summaries would likely give you the most actionable insight into technician performance without being overwhelming, so I’d default to weekly. Track record on here: 5.0 across 10 reviews, 100% on time and 100% on budget. Let’s have a short call on Freelancer to cover how you want the data formatted in the Excel file, and also how you want the script deployed to the shared folder.

@NEHABHAT92

As a seasoned developer with 9+ years of experience, I have a proven track record of delivering efficient and robust automation solutions. Your Excel Automation for GLPI project aligns perfectly with my expertise in PHP and Python, ensuring that your data is seamlessly extracted from GLPI and compiled into an organized .xlsx file. My deep understanding of APIs and databases will allow me to pull the precise information you need - including technician ticket counts, average/median resolution times - with zero room for manual errors. Moreover, having worked extensively with cron and Windows Task Scheduler, I guarantee a consistently punctual and reliable automation system that runs seamlessly without any intervention from your end. By leveraging my sharp problem-solving abilities and technical aptitude, I'll ensure that once the script or plugin is installed - it's smooth sailing for you as the file will be placed in your desired shared folder or even emailed directly. In addition to tackling your current requirements, I'm always excited to provide suggestions for further enhancements that could add value to your workflow. Whether you need weekly summaries, ticket-status breakdowns, performance dashboards or anything else, I'll take an analytical approach to evaluate the scope and feasibility of each addition. My mission is not limited to delivering a one-time solution, but rather supporting you in the long term through thorough documentation and easy deployme

@XRProConnect

Hi, Aashiq (Ash) here from Cape Town, South Africa. This project instantly caught my eye, so I had to reach out. I see you're looking for an automated solution to generate Excel reports from your GLPI instance. You want a seamless, hands-off process that pulls data directly from the database and schedules the report generation without any manual intervention. I've helped businesses streamline their reporting processes, ensuring clean data delivery while saving time and reducing errors. I’m confident I can create a solution that meets your needs. Feel free to ask for samples of my previous work in automation. Based on what you mentioned, here is how we would approach the project: - Develop a Python script to pull data from the GLPI API - Set up cron jobs for automated scheduling - Implement options for additional reports based on your feedback You can count on clear communication throughout the project, ensuring a user-focused solution optimized for performance. Best Regards, Aashiq

@wixdek

The primary challenge you face is the labor-intensive process of manually exporting data from your GLPI instance into Excel. Your business goal is to automate this process to enhance efficiency and allow for better reporting on technician performance without manual intervention. To address this, I propose developing a script that will automate the data extraction from GLPI and format it into a .xlsx file, capturing each technician's ticket handling and resolution times. This solution will be buildable using either PHP or Python, designed to run autonomously via cron or Windows Task Scheduler. The implementation plan includes: 1. Develop a script that connects to the GLPI database or API. 2. Pull the necessary data (technicians, ticket count, resolution times) and format it into a clean .xlsx file. 3. Ensure the solution is deployable within 30 minutes and requires no manual intervention. 4. Set up the job scheduler for automatic execution. To further refine the report, what additional data points would you find most beneficial to include in the first automated report? If this approach aligns with your vision, I can prepare a more detailed plan and estimated timeline.

@KasjanovaEste

Hi, there, the main goal is removing the manual GLPI export completely and producing a reliable technician report automatically on schedule. I can build this in Python using the GLPI API where the required data is exposed, with direct MariaDB access as a fallback for metrics that are better calculated from the database. The script will collect technician ticket counts and resolution times, calculate average and median values consistently, generate a clean XLSX using openpyxl, and save it to a shared location or send it by email. I’ll make the reporting period and additional metrics configurable so weekly/monthly summaries, status breakdowns or dashboards can be added without rewriting the core logic. Cron or Windows Task Scheduler can run it unattended, with clear logging and failure handling. I’ll also provide a simple deployment guide and validate the output against known GLPI records. Looking forward to work with you. Thanks

@dataspro

Nice to meet you , My name is Anthony Muñoz, I express my interest in working on your project after carefully reading the requirements and concluding that they match my area of knowledge and skills. I am currently the lead engineer for the IT agency DSPro and I have more than 10 years of experience in the field. I have successfully completed a large number of similar jobs and I consider your project to be a challenge in which I would like to work and be able to make it a reality. Please feel free to contact me, it will be my pleasure to help you. I greatly appreciate the time provided and I remain attentive to any questions or concerns. Greetings

@JunaidBadroodien

Your project aims to streamline your reporting process from GLPI, transforming manual data exports into an automated Excel solution. This is crucial for improving efficiency and ensuring timely insights into technician performance. I propose developing a Python script that connects directly to your GLPI database, utilizing its API to extract the necessary data. The script will generate a clean .xlsx report listing each technician, their ticket counts, and average/median resolution times, fulfilling your must-haves. By scheduling this task through cron or Windows Task Scheduler, you will achieve a fully automated solution that requires no manual intervention, enhancing your workflow. I can also provide insights into additional reporting options, such as weekly summaries or performance dashboards, ensuring you get the most value from this automation. My previous work on similar projects involved automating data reports for IT teams, which led to significant improvements in their operational efficiency. Our collaboration will yield a reliable, maintainable system that meets your needs, allowing you to focus on higher-level tasks without worrying about manual data handling. Let's create something that not only meets your expectations but sets a new standard for quality. Regards Junaid

@aprkdream

Hi, I understand your need to automate data exports from your GLPI instance into Excel, eliminating manual processes and enhancing efficiency. With over 11 years of experience in full-stack development and automation, I can deliver a tailored solution that meets your requirements. I will create a robust automation script that seamlessly extracts data from your GLPI system and formats it into an Excel file. This will not only save you time but also reduce the risk of errors associated with manual data handling. Key deliverables include: - An automated script to extract data from GLPI. - A user-friendly interface for triggering the export. - Customizable Excel templates to match your reporting needs. - Documentation for easy maintenance and updates. My expertise in backend development and API integrations ensures that the solution will be secure, scalable, and efficient. I am committed to delivering a reliable system that enhances your workflow and provides immediate value. Looking forward to the opportunity to work together on this project. Best regards, Anil Prajapati

@Maryam015014

Hi, I can automate this so you never export by hand again. How I will build V1: - Use Python + GLPI REST API (fallback to direct MariaDB query if API is disabled). More stable than PHP for scheduled jobs. - Script pulls: technician, ticket count, avg/median resolution time (solved date - open date) - filters out reopened / deleted tickets. - Generates clean .xlsx via openpyxl - compatible with Excel and LibreOffice Calc. - Unattended run: cron job on Linux or Task Scheduler on Windows, drops file to shared folder and optional email via SMTP. Includes log file + error alert. For future reports - I suggest building it modular: - Weekly vs monthly: just add --period weekly/monthly flag - Add-ons like status breakdown (new/pending/solved), SLA breach %, dashboard tab - each as separate function in same script, so adding a new report is 20-30 lines. Deliverables: 1. Commented Python source 2. 1-page deploy guide (<30 min setup) 3. Test run on your instance with screenshot of xlsx Language: Python, requests, openpyxl, python-dotenv Timeline: 2 days for V1 + test run. Do you prefer API access or direct DB? And should the file be emailed or just dropped in a folder?

@gigatorb

Hi, You shouldn’t have to export GLPI data manually every week just to get a technician report. I can turn this into a fully unattended scheduled process that pulls the data, generates the Excel file, and delivers it automatically. With 18+ years of experience in business automation, reporting, database integration, and Microsoft/business solutions. For V1, I’d build: - Direct GLPI API or MariaDB data extraction - Technician-wise ticket counts + average/median resolution time - Clean `.xlsx` output compatible with Excel and LibreOffice - Automated execution via **cron or Windows Task Scheduler - Automatic delivery to a shared folder or email - Error handling/logging so failed runs can be identified easily - Clear deployment instructions and a verified test run against your GLPI data For future additions, I can structure the reporting layer so weekly/monthly summaries, ticket-status breakdowns, technician trends, and dashboards can be added without rebuilding the core process. I’d first validate the GLPI API/database structure and resolution-time fields, then choose the simplest maintainable approach. Python + pandas/openpyxl would be my likely choice for the reporting script. I can provide the source code, under-30-minute deployment guide, and successful test output as requested. If you share how you currently define “resolution time” in GLPI, I can map the report precisely to your existing data. Best regards, Lav