
Geschlossen
Veröffentlicht
Bezahlt bei Lieferung
Ich betreibe eine Vinyldatenbank und erhalte regelmäßig Neuheitenlisten per E-Mail. Damit ich die Informationen nicht mehr manuell übernehmen muss, suche ich eine Lösung, die die Nachrichten automatisch einliest, die relevanten Felder erkennt und direkt in meine Datenbank schreibt. Was verarbeitet werden soll • Künstlername & Albumtitel • Veröffentlichungsdatum & Label • Musikgenre & komplette Trackliste mit MMP3 und Covern * Preisermittlung Wie es ablaufen soll 1. Automatische Filterung der Eingangspostfächer (z. B. nach Absender oder Betreff). 2. Keyword-basierte Extraktion der oben genannten Felder. 3. Option zur manuellen Überprüfung, bevor die Datensätze endgültig gespeichert werden. Ziel-Format Die extrahierten Daten werden strukturiert in meiner Datenbank (MySQL) abgelegt. Technische Eckpunkte – Abruf neuer Mails via IMAP/POP oder Weiterleitung. – Verarbeitung von Textkörper und Anhängen (HTML, PDF, einfache Excel-Listen). – Interface (Web-GUI oder CLI) zum Prüfen, Korrigieren und Freigeben der importierten Titel. – Nachvollziehbare Logs, Fehler-Handling und klar kommentierter Code. – Auf meinem Linux-Server installierbar; Python oder PHP sind bevorzugt, ich bin aber offen für andere Vorschläge. Akzeptanzkriterien – ≥ 95 % korrekte Felder bei typischen Lieferanten-Layouts. – Zeitgesteuerter oder eventbasierter Abruf ohne manuelles Anstoßen. – Dokumentation zur Einrichtung sowie kurzes Benutzerhandbuch. Teile mir bitte mit, welche Sprache / Libraries (z. B. Python + imaplib, spaCy, BeautifulSoup) du einsetzen willst und wie du das Prüftool realisieren würdest. Beispiele früherer Arbeiten im Bereich E-Mail-Parsing oder Datenimport sind willkommen. I run a vinyl records database and regularly receive new release lists by email. To avoid manually entering this information, I’m looking for a solution that can automatically read incoming emails, identify the relevant fields, and write the data directly into my database. Data to Be Processed Artist name & album title Release date & label Music genre & complete tracklist with MP3s and cover images Price determination Workflow Automatic filtering of incoming mailboxes (e.g. by sender or subject line). Keyword-based extraction of the fields listed above. Optional manual review step before records are permanently saved. Target Format The extracted data should be stored in a structured format in my database (MySQL). Technical Requirements Retrieval of new emails via IMAP/POP or forwarding. Processing of email bodies and attachments (HTML, PDF, simple Excel lists). Interface (web GUI or CLI) to review, correct, and approve imported records. Transparent logging, error handling, and clearly commented code. Installable on my Linux server; Python or PHP preferred, but open to other suggestions. Acceptance Criteria ≥ 95% correct field extraction for typical supplier layouts. Scheduled or event-based execution without manual triggering. Setup documentation and a short user guide. Please let me know which language and libraries you would use (e.g. Python + imaplib, spaCy, BeautifulSoup), how you would implement the review tool, and share examples of previous work related to email parsing or data import if available.
Projekt-ID: 40203945
59 Vorschläge
Remote Projekt
Aktiv vor 1 Monat
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
59 Freelancer bieten im Durchschnitt €7.186 EUR für diesen Auftrag

As an experienced developer at ZAWN Tech, specializing in software systems and web development, I can provide you with the perfect solution for automating your email parsing needs and integrating them seamlessly with your vinyl database. I propose using Python because of the extensive libraries and ease of use it offers for tasks like web scraping and data processing. With regards to email parsing, I suggest leveraging the imaplib module to retrieve emails via IMAP protocol and BeautifulSoup for the extraction of relevant data from HTML, PDF, and Excel attachments. To ensure accurate parsing, we can adopt a keyword-based approach combined with enhanced machine learning techniques such as spaCy if needed. The extracted information can then be saved directly into your MySQL database, retaining all the structure in compliance with your acceptance criteria while incorporating transparent logging for efficient error handling. Moreover, our team will develop a user-friendly, web GUI-based tool that will allow you to manually review and approve each imported title before the final save action. We also offer a strong post-delivery support system which includes thorough documentation and a short user guide designed to make the setup process smooth for you. You can count on us to deliver not just a functional product but one that meets your specific needs with great precision. Let's turn your manual processes into an automated delight together!
€10.000 EUR in 30 Tagen
9,3
9,3

⭐⭐⭐⭐⭐ Dear Valuable Client, CnELIndia, led by Raman Ladhani, can deliver a fully automated solution for your vinyl database updates. We propose using Python with imaplib for email retrieval, BeautifulSoup and PyPDF2 for parsing HTML and PDF attachments, and pandas/openpyxl for Excel files. spaCy will enable accurate keyword-based extraction of artist, album, release date, label, genre, tracklist, MP3 links, covers, and pricing. Extracted records will be staged in a Web-GUI for optional manual verification before insertion into your MySQL database. Scheduled or event-triggered jobs ensure automated processing. Our implementation will include detailed logging, error handling, and fully commented code, all installable on your Linux server. Previous projects include parsing supplier emails for e-commerce and automating structured database imports, achieving >95% field accuracy. A concise setup guide and user manual will accompany delivery. We ensure reliable, maintainable, and high-accuracy automation tailored to your workflow.
€7.500 EUR in 7 Tagen
9,1
9,1

I have extensive experience in PHP, Data Processing, Software Architecture, MySQL, and HTML, making me a perfect fit for the "Email und CSV Parsing für Vinyldatenbank" project. I am confident in my ability to create a solution that will automatically extract and store the required information from incoming emails into your MySQL database. I am open to using Python or PHP, and I will utilize libraries like imaplib, spaCy, and BeautifulSoup for efficient email parsing. For the verification tool, I will create a user-friendly web GUI interface for easy checking and correction of imported data. My past work showcases my expertise in email parsing and data import tasks. I am eager to discuss the project scope further and adjust the budget accordingly. Please go through my profile, which reflects my 15 years of experience and commitment to client satisfaction. Let's kick off this project together!
€7.000 EUR in 21 Tagen
8,8
8,8

Hello, As a proficient and versatile developer, I am well-equipped to address your specific email parsing needs. With my extensive knowledge of back-end development, particularly in PHP and MySQL, I can design and implement a powerful solution using IMAP/POP to fetch your new mails, parse their content using libraries like imaplib and BeautifulSoup. With my expertise in HTML, I can handle the processing of different attachment types including HTML, PDFs and Excel files. To further enhance usability, I propose a web-based GUI that will allow you to conveniently review, correct and approve the imported titles before saving them to your MySQL database. I also place great importance on error handling and maintainable code so that debugging becomes a breeze. To validate the effectiveness of my implementation, I suggest comparing the efficiency of my system against your current dataset for 95% accuracy in typical supplier layouts. You can further bolster your confidence in me by reviewing my track record of email parsing or data import projects and how they have benefitted my clients. Hire me today and let me bring efficiency to your vinyl database management! thank you Regards Gaurav D.
€5.500 EUR in 30 Tagen
8,6
8,6

⭐⭐⭐⭐⭐ Automate Email Processing for Your Vinyl Records Database ❇️ Hi My Friend, I hope you are doing well. I just reviewed your project requirements and see you are looking for an automated email processing solution. You have no need to look any further as Zohaib is here to help you! My team has successfully completed 50+ similar projects for email data extraction. I will create a system that reads your emails, extracts the relevant information, and inputs it directly into your MySQL database with a focus on accuracy and efficiency. ➡️ Why Me? I can easily do your email processing project as I have 5 years of experience in automation and data extraction. My expertise includes Python programming, email parsing, and database management. Besides, I have a strong grip on technologies like IMAP, BeautifulSoup, and error handling, ensuring a robust solution for your needs. ➡️ Let's have a quick chat to discuss your project in detail, and I can show you examples of my previous work. Looking forward to discussing with you in chat. ➡️ Skills & Experience: ✅ Python Programming ✅ Email Parsing ✅ Data Extraction ✅ MySQL Database ✅ IMAP/POP Integration ✅ HTML/PDF Processing ✅ Web GUI Development ✅ Error Handling ✅ Logging Mechanisms ✅ Automation Scripting ✅ Data Validation ✅ User Documentation Waiting for your response! Best Regards, Zohaib
€6.000 EUR in 2 Tagen
7,9
7,9

Hallo, ICH VERFÜGE ÜBER PRAKTISCHE ERFAHRUNG MIT SOLCHEN PROJEKTEN Ich verfüge über mehr als 9 Jahre Erfahrung in der Python-/PHP-Automatisierung und verstehe Ihre Anforderungen genau. Ziel ist der Aufbau eines skalierbaren, automatisierten Systems zur E-Mail- und CSV-Verarbeitung, das Vinyl-Release-Daten zuverlässig extrahiert und sauber in Ihre MySQL-Datenbank schreibt. -->> Abrufen und Filtern von E-Mails über IMAP/POP3 nach Absender/Betreff -->> Parsen von HTML-, PDF- und Excel-Anhängen mit strukturierter Feldextraktion -->> Benutzeroberfläche (Web/CLI) zur manuellen Überprüfung vor dem endgültigen Import -->> Zeitgesteuerte oder ereignisbasierte Automatisierung mit Protokollierung und Fehlerbehandlung Mein Ansatz basiert auf sauberer Architektur, sicherer Integration, effizienter Parsing-Logik und agiler Entwicklung. Ich habe einige Fragen zum Projekt, die ich Ihnen gerne im Chat stellen möchte, um die weiteren Schritte zu besprechen. Ich würde Ihr Projekt mit Wireframes beginnen und das UI/UX-Design abschließen, bevor ich mit der eigentlichen Entwicklungsphase starte. Lassen Sie uns gemeinsam eine Plattform entwickeln, die Ihr Unternehmen nicht nur voranbringt, sondern sich auch deutlich vom Wettbewerb abhebt. Vielen Dank und beste Grüße Julian
€5.000 EUR in 7 Tagen
8,0
8,0

Hello Als erfahrenes und hochqualifiziertes Softwareentwicklungsunternehmen verfügen wir über genau die Kompetenzen und das Know-how, die Sie für Ihre komplexen Herausforderungen im Bereich Vinyl-Datenbanken benötigen. Für Ihr Projekt schlagen wir den Einsatz von Python (mit Bibliotheken wie imaplib, spaCy und BeautifulSoup) als primäre Programmiersprache vor, um Ihre E-Mail-Analyse zu gewährleisten. Dank unserer umfassenden Kenntnisse in diesem Bereich können wir ein automatisiertes System entwickeln, das E-Mails via IMAP/POP/Weiterleitung schnell abruft und Informationen durch Filterung relevanter Felder anhand von Schlüsselwörtern extrahiert. Um die Authentizität und Genauigkeit der importierten Daten zu gewährleisten, bieten wir eine robuste und benutzerfreundliche Oberfläche (entweder CLI oder Web-GUI) zur bequemen manuellen Überprüfung und Freigabe, bevor die Daten in Ihrer MySQL-Datenbank gespeichert werden. Darüber hinaus legen wir großen Wert auf die sorgfältige Protokollierung, die Implementierung effektiver Fehlerbehandlungsmechanismen und die Integration verständlicher Codekommentare während des gesamten Prozesses. Zusammenfassend lässt sich sagen, dass Sie mit uns Zugang zu einigen der besten Experten der Branche erhalten, die nicht nur über nachgewiesene Kompetenzen verfügen, sondern auch stets höchste Qualitätsstandards erfüllen. Regards DJ
€9.000 EUR in 40 Tagen
7,9
7,9

Hi, this is Elias from Miami. I read your vinyl database workflow and it’s a perfect automation use case: pull supplier emails automatically, parse body + attachments (HTML/PDF/Excel), extract consistent fields, then push clean records into MySQL with an approval step so bad parses never pollute your catalog. Stack I’d use (Python on Linux): * Email ingest: imaplib (or IMAPClient) + cron/systemd timer * Parsing: BeautifulSoup for HTML, pandas/openpyxl for Excel, and pdfplumber for text-based PDFs (OCR only if needed) * Extraction: supplier “templates” first (highest accuracy), then a fallback rules/regex layer; spaCy (de/en) only where free text needs NER * Media: download/attach MP3 + cover, store to disk/S3-compatible storage, save paths + hashes in MySQL * Price: rules engine per supplier (net/gross, currency, shipping, markup) with configurable formulas Q1: Do the suppliers send fairly consistent layouts (same 5–10 vendors), or is it a long tail of many formats? Q2: How do you want MP3s/covers stored—inside MySQL (not ideal), or filesystem paths with a structured folder layout + backups? Q3: For “price determination,” do you already have markup rules (by label/genre/vendor), and do you need currency conversion? I can ship this as a Dockerized service with a config file for vendor rules + mail filters, plus docs and a short user guide so you can maintain it easily.
€7.500 EUR in 7 Tagen
7,6
7,6

AUTOMATED VINYL RELEASE IMPORT SYSTEM – READY TO STREAMLINE YOUR DATABASE I have extensive experience automating data ingestion from emails into MySQL and can build a reliable system to automatically parse your new release lists, extract all relevant fields, and insert them into your database. Proposed Approach: Language & Libraries: Python with imaplib/imapclient for email retrieval, BeautifulSoup for HTML parsing, PyPDF2 or pdfplumber for PDFs, pandas for Excel/CSV processing, spaCy for natural language extraction. Workflow: Scheduled IMAP retrieval of incoming emails. Automatic filtering by sender and subject. Extraction of artist, album, release date, label, genre, tracklist, MP3 links, cover images, and price. Optional web-based review interface (Flask/Bootstrap) to approve, correct, or enrich records before final insertion. Structured import into MySQL with logs for every operation. Additional Features: Event-based triggers, retry/error handling, clear logging, attachment handling, and offline testing. I can also provide previous examples of email parsing and automated data import pipelines for reference. Next Steps: I can prepare a small proof-of-concept parsing one supplier’s email within a few days to confirm accuracy before full deployment.
€5.000 EUR in 30 Tagen
7,4
7,4

Hi, Iosif here - 15+ years in Secure Full-Stack & DevOps. This is my speciality: automatisierte E-Mail-Parsing-Workflows mit sicherer MySQL-Integration, genau passend für Ihre Vinyldatenbank. Approach Discovery → Audit der Beispiel-Mails & DB → Build/Integrate (IMAP/POP, Parser, Review-UI) → Validate (Accuracy ≥95%) → Handover & Doku. Technik & Prüftool Python mit imaplib, spaCy, BeautifulSoup; für PDF/Excel bewährte Parser; Web-GUI oder CLI zum Korrigieren und Freigeben; saubere Logs, Fehlerbehandlung, least-privilege Server-Install, Backups. Deliverables - Mail-Collector (IMAP/POP) + Filterregeln - Extraktor: Künstler, Album, Release, Label, Genre, Tracks, MP3-Links, Cover, Preis - Review-Interface (Web/CLI) + MySQL-Importer - Install-Anleitung & kurzes Benutzerhandbuch - Testset & Nachvollziehbare Logs Akzeptanzkriterien - ≥95% korrekte Felder bei üblichen Lieferanten-Layouts - Zeitgesteuerter/eventbasierter Abruf - Dokumentation + lauffähiger Installer Timeline Ca. 6-8 Wochen. Bereit nach Klärung der offenen Punkte. Preis Nächste Schritte Bitte sende 5-10 Beispiel-Mails, DB-Schema, gewünschte Review-UI (Web/CLI) und Zugangsoptionen; gern kurz chatten, um Scope zu klären.
€6.800 EUR in 45 Tagen
6,3
6,3

I’ve carefully read your requirement for an automated system that extracts structured music release data from supplier emails and imports it into your MySQL database. This is a great automation project, and I have solid experience building email-parsing and data-processing pipelines with validation interfaces. I can develop a reliable solution that reads emails via IMAP, processes attachments (HTML, PDF, Excel), extracts fields like artist, album, tracklist, genre, label, and pricing, and stores everything in a structured format with logs and error handling. A few quick questions: Do your suppliers use consistent layouts, or should the system adapt to multiple formats? Should cover images and MP3 previews be stored locally or linked externally? Do you prefer a browser-based review panel or a lightweight admin dashboard? Looking forward to hearing back from you and discussing this in the chat. Portfolio: https://www.freelancer.in/u/Rupal878 Rupal Saini
€7.500 EUR in 7 Tagen
5,1
5,1

Greetings! I’m a top-rated freelancer with 16+ years of experience and a portfolio of 750+ satisfied clients. I specialize in delivering high-quality, professional services tailored to your unique needs. Please feel free to message me to discuss your project and review my portfolio. I’d love to help bring your ideas to life! Looking forward to collaborating with you! Best regards, Revival
€5.000 EUR in 30 Tagen
5,4
5,4

Hello There, Hope you are doing well :) Just following any chance to discuss the project Thank you
€7.500 EUR in 7 Tagen
5,8
5,8

Hello, I’m excited about the opportunity to automate your vinyl new-release intake end-to-end, so incoming supplier emails are parsed reliably and written into MySQL with a clean approval step instead of manual entry. I would implement this in Python for stability and parsing accuracy, using IMAP for retrieval, BeautifulSoup for HTML bodies, pdfplumber for PDFs, and openpyxl for Excel attachments, with a supplier-aware extraction layer (keywords + templates) to reach the ≥95% accuracy target across repeat layouts. For the review tool, I’d build a lightweight web GUI that shows each “pending import” record with detected fields, confidence flags, and attachment previews (tracklist, cover, MP3 links), allowing quick edits and one-click approve/reject while logging every run and every change for traceability. You can expect clean, well-commented code, robust error handling, scheduled execution on Linux (cron/systemd), and clear setup + user documentation so you can operate and extend the system confidently. Best regards, Juan
€5.000 EUR in 7 Tagen
5,0
5,0

As an experienced developer with a track record of creating high-performing digital solutions, I am confident I am the perfect candidate to tackle your email and CSV parsing project for your vinyl records database. Throughout my 13-year career, I have successfully worked on various projects that require meticulous data extraction, manipulation, and storage, providing me with the necessary tools to excel in this role. In terms of languages and libraries, I would propose using Python with imaplib, spaCy, and BeautifulSoup. Python's versatility and wide range of libraries make it an ideal choice for handling complex data processing tasks. My solution would entail an interface for you to review, correct and approve imported records securely. Additionally, I’ll ensure transparent logging, robust error-handling mechanisms, as well as clean, comprehensively documented codes that are Linux-ready and deployable on your MySQL server. Though my earlier work hasn't focused specifically on email parsing or CSV importation, my software architecture skills coupled with my HTML and PHP expertise make me adaptable enough to quickly grasp new concepts and deliver high-quality results that align with your requirements. More importantly, my commitment to producing accurate outputs - guaranteed by ≥ 95% correct field extraction - alongside providing detailed documentation will ensure ease of set up and operation for you.
€10.000 EUR in 30 Tagen
5,1
5,1

Hi there! I’d love to help you build a polished, reliable system that automatisch Neuheiten-Mails ausliest, relevante Felder erkennt und strukturiert in Ihre MySQL-Datenbank überträgt. Mit starker Erfahrung in Backend-Automatisierung und Datenextraktion stelle ich sicher, dass die Lösung stabil, nachvollziehbar und langfristig wartbar ist. Couple of questions: Sind die Lieferanten-Layouts weitgehend gleich aufgebaut oder stark unterschiedlich? Sollen Cover & MP3-Infos nur verlinkt oder als Dateien gespeichert werden? Existiert bereits eine Datenbankstruktur, oder soll diese mit optimiert werden? Bevorzugen Sie ein Web-Interface oder reicht ein internes Admin-Panel? Wie häufig treffen solche E-Mails typischerweise ein (täglich, stündlich)? I'm confident in delivering a clean, consistent, and automatisierte Lösung, die Ihre manuelle Arbeit drastisch reduziert und gleichzeitig Transparenz sowie Kontrollmöglichkeiten bietet. Dokumentation zur Installation sowie ein kurzes Benutzerhandbuch sind selbstverständlich enthalten. Feel free to review my past work here: https://www.freelancer.com/u/rahul8696 Looking forward to working with you! Rahul
€7.500 EUR in 7 Tagen
4,5
4,5

As a seasoned freelancer with over two decades of experience in web development, I am confident in my ability to successfully complete your project. I have a strong command of HTML, MySQL and Software Architecture which perfectly aligns with your requirement to parse and extract relevant fields from email messages and store them in your MySQL database. For this specific task, I plan to use Python with libraries such as imaplib, spaCy, and BeautifulSoup. These libraries allow for efficient handling of emails via IMAP/POP protocol, parsing HTML, extracting data using keywords and manipulating contect as needed. Python's rich ecosystem also grants more flexibility when it comes to detecting invoices or other documents you may receive in formats like PDF or Excel. To ensure quality control and minimize errors, I propose a two-step validation process: automated filtering through sender/betreff-based filtering followed by keyword-based information extraction. The entire process will be conducted on a Linux server for easy installation, effortless integration and an interface (either Web-GUI or CLI) for you to manually validate the parsed data.
€7.500 EUR in 7 Tagen
3,4
3,4

⭐⭐⭐⭐⭐ ✅Hi there, hope you are doing well! I have developed automated email parsing and data import systems for databases, enabling seamless extraction of relevant fields from complex email formats into structured SQL databases. The most critical factor for success is creating a robust parser that accurately recognizes and extracts data fields across varied supplier email layouts with minimal errors. Approach: ⭕ Use Python with imaplib for mailbox retrieval. ⭕ Employ BeautifulSoup and pdfminer for parsing HTML and PDF attachments. ⭕ Implement spaCy for keyword and field extraction. ⭕ Build a web GUI to review, correct, and approve data before database insertion. ⭕ Log processing steps with error handling for transparency. ⭕ Schedule event-driven checks via cron jobs on your Linux server. ❓ Could you specify the typical formats and suppliers of the emails? ❓ Are there existing database schema or APIs we need to consider? ❓ Do you prefer a web-based GUI or CLI for manual review? I am confident I can deliver a reliable, easy-to-use solution tailored to your Vinyldatenbank needs that streamlines your enrichment process efficiently. Let’s discuss next steps to kick off the project. Best regards, Nam
€8.000 EUR in 40 Tagen
2,4
2,4

Hi there, Nice to meet you. I have read your project description carefully and got what you want exactly. I am a full stack engineer with 5 years of experience and can offering best quality and highest performance during your timeline. I am ready to discuss your project and can start immediately. I'd like to talking about your proposals via chat. I will wait for your reply. Thanks! Roman,
€5.000 EUR in 70 Tagen
2,5
2,5

I understand your need for automating the extraction of vinyl records data from emails to your database efficiently. With my expertise in PHP, MySQL, data processing, and software architecture, I can deliver the solution you require. I propose using PHP with libraries like BeautifulSoup and designing a user-friendly scanning tool. My previous work includes similar data parsing projects, displaying my capability in this area. Working within your budget of €5,000.00 – €10,000.00 EUR, I ensure a reliable solution meeting over 95% accuracy expectations with a seamless automated process. I look forward to potentially collaborating on this project. Regards, Jason McLachlan
€6.996 EUR in 3 Tagen
1,9
1,9

Germany
Mitglied seit Mai 24, 2017
€18-36 EUR / Stunde
₹12500-37500 INR
$2-8 USD / Stunde
$30-250 USD
$30-250 USD
₹600-1500 INR
€250-750 EUR
$15-25 USD / Stunde
₹12500-37500 INR
₹12500-37500 INR
$30-250 USD
$250-750 USD
₹1500-12500 INR
€30-250 EUR
$250-750 USD
$250-750 USD
₹12500-37500 INR
₹12500-37500 INR
₹600-1500 INR
$250-750 USD
$750-1500 USD