Project only for ASIM - Excel CSV Creator & Daily Report-Generator
₹12500-37500 INR
Maksettu toimituksen yhteydessä
1. We have 32 backups from the same database as .sql-files.
From one table of this database we need all instances in one csv-file (with the same codepage as stated in the sql-file ).
So basicly you must:
- import 1st backup on your sql-server
- export the table "contracts" to "csv for Excel"
- repeat for all 31 other backups
- put everything together in one big csv-file that is readable in Excel (pls maintain german umlaute)
2. There should be a menu-item (i.e. "Report"); clicking this asks for the date "Welches Datum?"; the current date is proposed but can be changed by choosing a date in a calendar.
The report should consist of:
1. All customers that have been added at the given date.
2. All contracts that have been added at the given date
3. All contracts that have been modified at the given date
1. Fields for customer:
- Number, company, name, first-name, street, house-no, post-code, city
2+3. Fields for contract:
- contractNo, property-name, customer-no, customer-name, status, expert-name, no_of_bill, total_amount
related contract-actions:
- action-Type (WBA/HZ), wall-lenght
related payments
- paymentNo, paymentDate, payment-amount, method
All this report as a table in a html-page (so it can be printed as PDF or copied to Excel)
Projektin tunnus: #37876871
Tietoa projektista
12 freelanceria on tarjonnut keskimäärin ₹25708 tähän työhön
With over seven years of experience as a Full Stack Developer, I've worked with notable companies such as Metlife GOSC, DXC technologies, and Elite Services. I'm not only proficient in Excel, Microsoft SQL Server, MySQ Lisää
Hello Sir, I hope you are doing well, SrashtaSoft, leveraging our extensive 9+ years of experience in database management and software development, is excited to offer a comprehensive solution for your ASIM project. W Lisää
Hi there, Greetings❤️ I have read your project details that you need to design Project only for ASIM - Excel CSV Creator & Daily Report-Generator. Can we talk regarding this project and Thanks for the details and clear Lisää
I am experienced in SQL databases, data manipulation, and web development. I can import and export data, merge CSV files, and create dynamic HTML reports with interactive elements like date selection. My expertise ensu Lisää
Hey, my name is erik,, i have 5+ years experient as a web app development especially with big data. I can make you 1 web app for solve your problem. MySQL and PHP are right on spot for solving your project. With over 5 Lisää
With a solid foundation in Excel and SQL, I offer a seamless fusion of data analysis and manipulation expertise. Proficient in crafting complex queries, optimizing databases, and generating insightful reports, I am poi Lisää