Project only for ASIM - Excel CSV Creator & Daily Report-Generator

Hi! Thank you for sharing the details. I completely understand these tasks and am ready to start as soon as possible. I have worked on different technologies and frameworks: HTML, CSS, JavaScript, CodeIgniter Bootstrap, jQuery, Cake PHP, PHP, WordPress, WooCommerce, Laravel, Yii2, MySQL, SQL, Shopify, and various other technologies. The Benefits will get from: Communication according to your timezone On-time delivery 24 hours support Give you technical support as well after completion Jira and Trello for project management Deploy your project on the server Looking forward to your response and doing business with you. Best Regards. Asim Bashir

With my strong background in Excel, Microsoft SQL Server, and MySQL paired with my 7 years of experience as a Full Stack Developer, I am confident in my ability to fulfill your project needs. Not only have I worked with huge companies like Metlife GOSC, DXC Technologies, and Elite Services, but I assure you of 100% employer satisfaction. My values of speed, precision, and commitment to understanding your needs align perfectly with your project requirements. Regarding the first part of your project, my expertise in database management specifically in SQL will allow me to import and export the data from your 32 backups seamlessly. Alongside this, I am skilled in maintaining data integrity across various formats including CSV for Excel and can ensure that the converted CSV file preserves all specialized characters like German Umlaute. My keen eye for detail will guarantee that you'll receive one accurate big CSV file combining data from all backups. For the second half of the project- generating a daily report; my skills in PHP and HTML will be invaluable. Designing an easily navigable menu item that allows dynamic date input is well within my capabilities. Moreover, using PHP to filter the data precisely by date and formatting it into HTML for easy reading or exporting into other handy formats like PDF or Excel would be done with utmost accuracy to provide you with a clean and professional report. Choose me Sandeep for timely delivery of quality work at user-oriented pricing!

Dear Client, as a skilled MySQL and PHP developer with more than 7 years of experience, your tedious task of creating an Excel CSV from multiple database backups seems like an ideal project for me. I'm well-versed in handling database queries and have knowledge about maintaining codepages to ensure compatibility. In addition, I'm fluent in German, hence making me capable to maintain umlaute (e.g., ä, ö, ü) while exporting to CSV files. Regarding the second feature, generating a date-based report from the provided database feels like a smooth ride for my expertise. I'll build a user-friendly menu item "Report" which upon clicking will prompt for the desired date. Whether the requirement involves adding new customers or contracts or even modifying existing ones - all would be smoothly accomplished within the table of an HTML page. This report can easily be converted into PDF or transferred to Excel as necessary without data loss or structural distortions. To conclude, I guarantee not just an efficient extraction and fusion of data from your various .sql backups into a single CSV file, but also a seamless generation of meaningful reports on daily basis. My commitment to meeting deadlines and budgets aligns perfectly with the meticulous nature of this project. Don't wait longer, choose me today to get started on your project ASAP!

Hi, I have more then 15 year’ experienced in Development with full stack . As i am expert, I can build it according to your requirements. Because I have a lot of the experiences about these fields, I can build your project as soon as possible perfectly. I offer excellent software quality work and provide the best support on your project. If you give me this job, I will do my best to finish your job until your timeline. If you want to see my past works, I can show you my past works right now. Ready to discuss with you about the task now.

Hi, I am a programmer skilled in Visual Basic, MS SQL Server, MS EXCEL and VBA. Hope discussing more details. Best Regards, Michael

Hi, I have gone through the Job details and am interested in taking it up. I need you to share more details with me, and I will deliver the required tasks fast and accurately. We will negotiate my fees depending on how many hours it will take to fulfill the work. I’m Ahmed Hassanein. I’ve been working with MS Office since the 90’s as a user, developer, and trainer. I've been using formulas, VBA, and macros in Excel since 2004. I completed Excel VBA and Google Sheets Apps Script jobs for happy customers (check my job reviews). I have over 25 years of experience supporting systems and users in the information technology field such as office applications, domain servers, application servers, network security, information systems audit, etc. I would be happy if we connect to talk more about your Job and discuss how I can help you accomplish it. Thank you and kind regards, Ahmed Hassanein

Hi Matthias H., How are you doing? As a professional developer with expertise in SQL, PHP, MySQL, Microsoft SQL Server and Excel, I eagerly anticipate the opportunity to complete this project for you. Please drop me a message to discuss the project detail. Thank you for considering my services.

Hi there I read your project details Extract 32 database backups, export "contracts" table to CSV, merge into one file. Implement "Report" menu item, generate HTML report with customer and contract data based on selected date Please leave me a message to discuss about it Thanks

Hi , please send a sample data to create a demo for you

Hello, I understand your requirements and I'm confident I can assist you with both tasks efficiently. Here's how I propose to tackle them: For the first task of merging data from multiple SQL backups into one CSV file, I'll import each backup onto my SQL server, export the "contracts" table to CSV for Excel, and repeat this process for all other backups. I'll ensure that the resulting CSV file maintains the German umlauts as specified. For the second task of creating a report with customer and contract details based on a selected date, I'll develop a menu item labeled "Report" that prompts the user to input a date. I'll create a calendar picker to facilitate date selection. Then, I'll generate a comprehensive HTML table containing the requested customer and contract details for the specified date. I have the necessary skills and experience to handle both tasks proficiently and deliver high-quality results. Looking forward to working together on this project. Best regards, Sumit Joshi

We can do it in a few hours by starting working on it right now. Message us for a quick chat and lets start it. For more information, you can pay heed to our profiles here: https://www.freelancer.com/u/ProfessorxCorp https://www.freelancer.com/u/ProfessorxWriter Looking forward to this, Thanks and Regards, Muhammad

Hello, I can assist you with both tasks efficiently and accurately. For the first task, I will import each backup file, export the "contracts" table to CSV, and merge them into one CSV file while maintaining the German umlaute encoding. For the second task, I will create a menu item for the "Report" functionality, prompt the user for a date, and generate a report containing the specified customer and contract information in a HTML table format. I have extensive experience with SQL, CSV manipulation, and HTML/CSS, ensuring a high-quality deliverable. Come on chat so we can discuss the details. Regards, Faheem.

Are you looking for a good candidate for your project? I will give you the work quickly and well. Give me this project.

I'm writing to express my interest in your project requiring the consolidation of 32 SQL database backups into a CSV file and the creation of a dynamic reporting feature. With extensive experience in SQL database management, data extraction, and web development, I am well-equipped to handle the complexities of this project. My expertise includes managing SQL databases, ensuring data integrity during extraction, and maintaining character accuracy, such as German umlauts, in Excel files. Additionally, I'm skilled in developing user-friendly reporting tools that allow for easy data interaction and report generation based on specific criteria like date selection. I propose to efficiently import your backups, extract the necessary "contracts" table, and compile the data into a single, coherent CSV file. Following this, I will develop a reporting feature that presents requested customer and contract information in a format suitable for both printing and Excel export. I am excited about the possibility of contributing to your project and am prepared to start at your earliest convenience. Thank you for considering my application. I look forward to discussing how I can meet your project needs.

It would be a pleasure to implement your Excel CSV Creator within a day. - I have over 20 years of professional experience in SQL and transferring data between SQL and CSV. I have a script that can do this for you and can deliver it within a day: - In an HTML website - read from SQL files - Download as an Excel-compatible CSV file. Happy to discuss details further and answer any questions. Looking forward to working with you. Sincerely.

With a solid background in MySQL and SQL, I am more than equipped to handle your project on exporting data from your SQL backups into a CSV format. My expertise will guarantee that your data is preserved intact, including delicate German umlaute characters. I understand the importance of maintaining code page compatibility for a seamless experience with Excel. Moreover, I can also create an intuitive menu item for you named "Report" which will enable you to easily access and generate a report based on a desired date range, encompassing customer and contract details. Being skilled in HTML, I'll format the report as a table in an HTML page which can be either printed as PDF or copied to Excel for further analysis. As a business analyst, I am experienced in dealing with complex requirements and transforming them into actionable tasks. My resilience ensures that shifting deadlines and evolving demands do not impede the successful execution of projects like yours. Lastly, my adaptability will come into play here as well; ensuring that not just my outputs align perfectly with your expectations, but even my work ethos neatly integrates with your team dynamic.

Hi, Could you clarify if you already have the backups (.sql-files) imported on your SQL server? Once I have this information, I can proceed with exporting the “contracts” table to a CSV file for Excel. Additionally, for the menu-item “Report,” do you already have a calendar feature in place? If not, would you like me to implement that as well? I have extensive experience in handling SQL databases and generating reports in various formats. I am confident that I can complete this task efficiently. Let me know if you would like to discuss the project further via Zoom. Looking forward to working with you.