
Abgeschlossen
Veröffentlicht
Bezahlt bei Lieferung
I need a clean MySQL setup that automatically ingests two separate CSV files every day and keeps them ready for use moments after they arrive. Alongside that, three database users—Admin, Editor, and Viewer—must be created with clearly separated privileges: full control for Admin, write-plus-read for Editor, and read-only for Viewer. Once the data is flowing in, I will rely on a set of reusable SQL scripts to: • pull records that match specific conditions (think filtered reports for my dashboards) • perform controlled data updates or inserts triggered from my application layer Deliverables will be considered complete when: • both CSVs import on schedule without manual intervention • the three user accounts enforce the required privilege boundaries • all retrieval and manipulation queries run error-free on real sample data • straightforward documentation shows how to rerun, modify, or extend the process in the future Feel free to suggest whether cron, LOAD DATA INFILE, or another method best suits the daily import—robustness is the priority.
Projekt-ID: 40090504
14 Vorschläge
Remote Projekt
Aktiv vor 2 Monaten
Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten

Hi, I can help with this task. Ready to start immediately.
€8 EUR in 1 Tag
0,0
0,0
14 Freelancer bieten im Durchschnitt €21 EUR für diesen Auftrag

Hello, I can set up a clean MySQL system that automatically imports both CSV files every day and makes the data ready to use right away. I’ll create the three users (Admin, Editor, Viewer) with strict permissions so access is clearly separated. For imports, I recommend using a scheduled cron job with LOAD DATA INFILE for speed and reliability. I’ll also provide reusable SQL scripts for filtered reports and safe inserts/updates, plus clear documentation so you can rerun or extend everything later. Before I start, I have two questions: Where will the daily CSV files be stored (local server or remote)? Do the CSV file structures ever change?
€50 EUR in 1 Tag
7,7
7,7

As a highly qualified professional, I have worked with over 150+ companies in various domains, including MySQL, PHP and SQL which are essential for this project. This extensive experience has equipped me with the skills to effectively manage your MySQL setup, automate the daily ingestion of CSV files and implement robust role-based access control to ensure the appropriate privileges for different users. In terms of daily imports, I would recommend utilizing cron or LOAD DATA INFILE method, depending on your specific needs. It's our priority to provide robustness in the process. To further streamline your reporting needs, I will create reusable SQL scripts that efficiently pull out records matching specific conditions and execute controlled data updates or inserts as triggered from your application layer. Throughout the project, my goal will be to minimize manual intervention and maximize efficiency. You can expect timely updates and a meticulous documentation demonstrating how to rerun, modify or extend the process in the future. My top 4% ranking here also reflects my work quality ensuring 100% client satisfaction!
€19 EUR in 7 Tagen
6,5
6,5

Hello Dear! I write to introduce myself. I'm Engineer Toriqul Islam. I was born and grew up in Bangladesh. I speak and write in English like native people. I am a B.S.C. Engineer of Computer Science & Engineering. I completed my graduation from Rajshahi University of Engineering & Technology ( RUET). I love to work on Web Design & Development project. Web Design & development: I am a full-stack web developer with more than 10 years of experience. My design Approach is Always Modern and simple, which attracts people towards it. I have built websites for a wide variety of industries. I have worked with a lot of companies and built astonishing websites. All Clients have good reviews about me. Client Satisfaction is my first Priority. Technologies We Use: Custom Websites Development Using ======>Full Stack Development. 1. HTML5 2. CSS3 3. Bootstrap4 4. jQuery 5. JavaScript 6. Angular JS 7. React JS 8. Node JS 9. WordPress 10. PHP 11. Ruby on Rails 12. MYSQL 13. Laravel 14. .Net 15. CodeIgniter 16. React Native 17. SQL / MySQL 18. Mobile app development 19. Python 20. MongoDB What you'll get? • Fully Responsive Website on All Devices • Reusable Components • Quick response • Clean, tested and documented code • Completely met deadlines and requirements • Clear communication You are cordially welcome to discuss your project. Thank You! Best Regards, Toriqul Islam
€20 EUR in 1 Tag
5,6
5,6

Hi there! I’ve reviewed your project and specialize in MySQL setups with automated CSV ingestion. I’ll ensure both files import daily without manual intervention, and I’ll create the three user accounts with the specified privilege levels. Let’s schedule a quick meeting to discuss the specifics! Best Regards, Amjad Iqbal
€30 EUR in 1 Tag
4,8
4,8

I can set up a robust MySQL environment that automatically ingests your two daily CSV files with minimal delay, ensuring the data is ready for immediate use. I’ll implement a reliable import process—using LOAD DATA INFILE or a cron-triggered script depending on which ensures speed and stability—while creating three distinct users: Admin with full privileges, Editor with read/write access, and Viewer with read-only rights. Alongside, I’ll provide reusable SQL scripts for filtered data retrieval, controlled updates, and inserts that integrate smoothly with your application. Deliverables include fully automated daily imports, correctly enforced user privileges, error-free queries on sample data, and clear documentation for rerunning, modifying, or extending the workflow in the future.
€20 EUR in 1 Tag
3,7
3,7

Hi, I can set up a robust, hands-off MySQL pipeline that automatically ingests both CSV files every day and keeps the data ready for use within minutes. No manual steps, no brittle shortcuts. I’ll implement a scheduled import (cron + LOAD DATA INFILE or a safer fallback if needed), create Admin, Editor, and Viewer users with strictly enforced privileges, and deliver reusable SQL scripts for filtered reporting and controlled inserts/updates from your application layer. Everything will be tested against real sample data so queries run cleanly from day one. You’ll also get clear documentation showing how to rerun the imports, adjust schedules, modify queries, or extend the setup later keeping the system easy to maintain. Do the CSV schemas stay consistent each day, or should the import handle occasional column changes? Best Regard, Chand
€10 EUR in 1 Tag
3,5
3,5

Hi , Your Software Architecture, PHP, Database Design, Database Administration, MySQL, SQL, Automation and Data Integration project stood out, it shows you value precision and real results. That’s exactly what I deliver. I don’t use templates. Every project has its own psychology, and success comes from understanding your intention before execution. Why clients choose me: Simplify complexity, deliver clarity. Creative data driven execution. Clear updates, early results. Work that makes you look great. My approach: Understand your vision. Build a focused action plan. Execute with full transparency. Portfolio: https://www.freelancer.com/u/muhammadfaizanh4 Each project shows results backed by strategy. Even a quick 5 minute chat can reveal how we’ll achieve measurable impact together. Let’s make your Software Architecture, PHP, Database Design, Database Administration, MySQL, SQL, Automation and Data Integration project remarkable. Faizan Your Trusted Partner in Smart Execution
€8 EUR in 6 Tagen
2,2
2,2

Hello Seija, I am excited about the opportunity to work on your project requiring a clean MySQL setup that automatically ingests two separate CSV files daily and maintains them for immediate use upon arrival. I will ensure the creation of three distinct database users with specified privileges and develop reusable SQL scripts for data retrieval and manipulation based on your requirements. The deliverables will include seamless daily imports, user privilege enforcement, error-free query execution, and comprehensive documentation for future maintenance. I will recommend the most robust method for daily imports to optimize efficiency. Thank you for considering my proposal. Regards, arslanshahid386
€13 EUR in 3 Tagen
2,0
2,0

Hi ❤️ This sounds like a solid data foundation project, and I can help you set it up so it runs quietly and reliably in the background. I’ll design a clean MySQL workflow where daily CSV arrivals are detected and ingested automatically, with safeguards to prevent partial or duplicate loads. The import process will be optimized for speed so the data is query-ready within minutes. I’ll also create three clearly isolated database roles, ensuring each account can only do exactly what it’s meant to—nothing more, nothing less. On top of that, I’ll deliver reusable SQL scripts that support filtered data extraction for reporting and safe, controlled write operations from your application layer. Everything will be tested against real sample data, and I’ll include concise documentation so you (or another developer) can rerun, adjust, or extend the setup without guesswork. I’d like to go over a few points: Are the CSV files always identical in structure, or do columns change over time? Should imports overwrite existing records, append only, or follow an upsert logic? Do you expect this to run on a single server or eventually scale to multiple environments? Looking forward to aligning this with your workflow.
€30 EUR in 3 Tagen
1,6
1,6

Hey, As a software engineer with more than 5 years of experience, this tasks seems straightforward for me and I can complete it within an hour. Please reach out to discuss further. Sincerely, AZOUHRI Adam
€19 EUR in 1 Tag
0,0
0,0

Hello, I can set up a robust MySQL ingestion pipeline that automatically imports your two daily CSV files and keeps the data ready for use with minimal delay. I’ll configure a reliable scheduled process (cron with LOAD DATA INFILE or a safer alternative, as appropriate) and ensure it runs without manual intervention. I’ll also create the Admin, Editor, and Viewer database users with clearly separated privileges, and provide reusable SQL scripts for filtered reporting and controlled inserts/updates from your application layer. Everything will be tested on real sample data and documented clearly so you can maintain or extend it easily. I’m ready to implement this cleanly and efficiently.
€30 EUR in 3 Tagen
0,0
0,0

Hi, I’ll design an automated daily import for both CSV files using the most reliable approach (cron + LOAD DATA INFILE or a safer alternative if needed). The process will validate files, handle failures cleanly, and ensure data is ready minutes after arrival. I’ll create three MySQL users with strict role separation: Admin (full control), Editor (read/write only where required), and Viewer (read-only). No over-permissioning. I’ll also deliver reusable SQL scripts for filtered data pulls and controlled inserts/updates, tested on real sample data to avoid runtime errors. You’ll get clear documentation explaining how to rerun, adjust schedules, or extend the pipeline later. I’ve handled similar ingestion + permission setups before and I’m confident I can deliver this cleanly and reliably. Best Regards,
€24 EUR in 2 Tagen
0,0
0,0

Bucharest, Romania
Zahlungsmethode verifiziert
Mitglied seit Mai 12, 2017
$30-250 USD
€8-30 EUR
$250-750 USD
$250-750 USD
$750-1500 AUD
$15-25 AUD / Stunde
$5000-10000 USD
₹1000-8000 INR
$250-750 USD
$250-750 USD
$20-30 USD
$250-750 USD
$250-750 USD
$30-250 USD
$30-250 AUD
$30-250 NZD
$8-15 USD / Stunde
$15-25 USD / Stunde
$250-750 USD
€3000-5000 EUR
$750-1500 AUD
$10-30 USD