Automated Extraction & Conversion of PDF Invoices to CSV for MySQL (phpMyAdmin) – Fixed & Non-Negotiable Price
Budget: €30 – €250 EUR
⚠️ IMPORTANT: READ BEFORE BIDDING
? Your bid is final and non-negotiable.
I will not accept price changes after selection.
If you bid low to be selected and then ask for more, I will cancel the project immediately.
Only serious professionals should apply.
? If you are not comfortable with this, do not bid.
? Project Description:
Hello,
I am looking for an experienced developer in PDF data extraction to create an automated script that converts a PDF invoice into a CSV file formatted for MySQL import via phpMyAdmin.
? ? Input Data:
A PDF file containing an invoice structured in a table format.
Each row in the invoice contains: item number, description, quantity, unit, unit price (HT), VAT rate, and total price.
? ? Goal:
Automatically extract data from the PDF.
Convert the extracted data into a CSV file with specific column formatting to match my database structure.
Allow flexibility to select and reformat extracted data (e.g., concatenate description and name).
Fully automate the process to avoid manual work.
? Expected Output Format (CSV Columns):
The script must generate a CSV file with the following structure:
sql
Copier
Modifier
spb_prestation_lot__numero_devis
spb_prestation_lot__nom
spb_prestation_lot__description
spb_prestation_lot__quantite
spb_prestation_lot__unite
spb_prestation_lot__prix_unitaire_ht
spb_prestation_lot__prix_total_ht
spb_prestation_lot__taux_tva
spb_prestation_lot__prix_total_ttc
? Notes:
The invoice number should be extracted from the PDF and added to each row.
The total price (TTC) should be calculated automatically:
ini
Copier
Modifier
prix_total_ttc = prix_total_ht * (1 + taux_tva / 100)
Some fields may need data cleaning (e.g., converting 1 234,56 € into 1234.56).
? Technical Requirements:
✅ The script should be written in Python (pdfplumber, PyMuPDF, pandas, etc.) or PHP.
✅ It should work automatically on multiple PDF files, not just one.
✅ It should be configurable to adjust column formatting if needed.
✅ The output should be a CSV file compatible with phpMyAdmin (; delimiter).
✅ Optional: A simple drag-and-drop interface to upload PDFs and retrieve formatted CSV files.
? Budget & Deadline:
? Budget: Fixed and non-negotiable.
⏳ Deadline: Ideally within 7 days.
? Please include the following in your proposal:
Your experience with PDF extraction and data manipulation.
The programming language and libraries you plan to use.
If you have worked on similar projects, feel free to share examples.
? Looking forward to your proposals! ?
? Your bid is final and non-negotiable.
I will not accept price changes after selection.
If you bid low to be selected and then ask for more, I will cancel the project immediately.
Only serious professionals should apply.
? If you are not comfortable with this, do not bid.
? Project Description:
Hello,
I am looking for an experienced developer in PDF data extraction to create an automated script that converts a PDF invoice into a CSV file formatted for MySQL import via phpMyAdmin.
? ? Input Data:
A PDF file containing an invoice structured in a table format.
Each row in the invoice contains: item number, description, quantity, unit, unit price (HT), VAT rate, and total price.
? ? Goal:
Automatically extract data from the PDF.
Convert the extracted data into a CSV file with specific column formatting to match my database structure.
Allow flexibility to select and reformat extracted data (e.g., concatenate description and name).
Fully automate the process to avoid manual work.
? Expected Output Format (CSV Columns):
The script must generate a CSV file with the following structure:
sql
Copier
Modifier
spb_prestation_lot__numero_devis
spb_prestation_lot__nom
spb_prestation_lot__description
spb_prestation_lot__quantite
spb_prestation_lot__unite
spb_prestation_lot__prix_unitaire_ht
spb_prestation_lot__prix_total_ht
spb_prestation_lot__taux_tva
spb_prestation_lot__prix_total_ttc
? Notes:
The invoice number should be extracted from the PDF and added to each row.
The total price (TTC) should be calculated automatically:
ini
Copier
Modifier
prix_total_ttc = prix_total_ht * (1 + taux_tva / 100)
Some fields may need data cleaning (e.g., converting 1 234,56 € into 1234.56).
? Technical Requirements:
✅ The script should be written in Python (pdfplumber, PyMuPDF, pandas, etc.) or PHP.
✅ It should work automatically on multiple PDF files, not just one.
✅ It should be configurable to adjust column formatting if needed.
✅ The output should be a CSV file compatible with phpMyAdmin (; delimiter).
✅ Optional: A simple drag-and-drop interface to upload PDFs and retrieve formatted CSV files.
? Budget & Deadline:
? Budget: Fixed and non-negotiable.
⏳ Deadline: Ideally within 7 days.
? Please include the following in your proposal:
Your experience with PDF extraction and data manipulation.
The programming language and libraries you plan to use.
If you have worked on similar projects, feel free to share examples.
? Looking forward to your proposals! ?