
Cancelado
Publicado
Pago na entrega
PROJECT BRIEF: Automated Invoice Processing ([login to view URL] + UBL 2.1 XML) 1. Project Overview We need a [login to view URL] (formerly Integromat) expert to automate our purchase invoice workflow. The system must monitor a Zoho Mail folder, process incoming .zip files containing electronic invoices (Colombian DIAN UBL 2.1 Standard), extract data from the XML, store it in a MariaDB/MySQL database, and archive the PDF in Dropbox. 2. Technical Stack Automation Platform: [login to view URL] (Mandatory). Email: Zoho Mail (IMAP). XML Standard: UBL 2.1 (AttachedDocument format). Database: MariaDB/MySQL (Hosted on Azure). Storage: Dropbox Business. 3. Scope of Work (Step-by-Step) Trigger: Watch a Zoho Mail folder for new emails with .zip attachments. Extraction: Unzip files to retrieve the .xml and the .pdf. Advanced XML Parsing: Extract data from the encapsulated cbc:Description node (standard for DIAN Colombia). Capture: Invoice #, Issue Date, Supplier NIT (Tax ID), Subtotal, Taxes, and Total Amount. Logic for Purchase Order (OC): Search for the OC number in cac:OrderReference. If empty, use Regex to find a 4-5 digit pattern in the cbc:Note field. Database Integration: Match Supplier NIT with our internal ps_supplier table. Insert a header row in ps_lasus_factura_proveedor. Iterate and insert line items in ps_lasus_factura_proveedor_detalle. IMPORTANT: Use raw SQL names. NO Aliases (AS) are allowed to ensure Looker Studio compatibility. File Management: Rename the PDF as [SupplierName]-[InvoiceNumber].pdf and upload to Dropbox folder /Facturas_Compra/YYYY-MM/. 4. Work Requirements & Security Account Ownership: All work must be done directly on the Client's [login to view URL] account. You will be invited as a member. Data Integrity: No changes to existing table structures or column names. Security: Access will be provided via restricted MySQL users and Scoped Dropbox Apps. Deliverables: A fully functional [login to view URL] scenario, documented with notes, and a 30-min handover session. YOu can finde attached the files we receive.
ID do Projeto: 40180238
78 propostas
Projeto remoto
Ativo há 1 mês
Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
78 freelancers estão ofertando em média $173 USD for esse trabalho

Hello, I came across your project and found it truly interesting. With over eight years of hands-on experience in this field, I have successfully delivered high-quality solutions to clients worldwide. My dedication to excellence is reflected in the 180+ positive reviews from satisfied clients. I’d love to bring this expertise to your project and ensure outstanding results. However, I do have a few important points I’d like to clarify to align perfectly with your vision. Let’s connect via chat, where I can also share relevant examples of my past work. I'm looking forward to hearing back from you! Best Regards, Divu.
$250 USD em 5 dias
7,7
7,7

Hey there, I'm excited about automating your purchase invoice workflow using Make.com. I'll monitor your Zoho Mail for .zip files with UBL 2.1 XML invoices, extract data, store it in MariaDB, and archive PDFs in Dropbox. Let's streamline your process efficiently. What do you think?
$155 USD em 1 dia
5,7
5,7

Hey Mate , Good morning! I’ve carefully checked your requirements and really interested in this job. I’m full stack node.js developer working at large-scale apps as a lead developer with U.S. and European teams. I’m offering best quality and highest performance at lowest price. I can complete your project on time and your will experience great satisfaction with me. I’m well versed in React/Redux, Angular JS, Node JS, Ruby on Rails, html/css as well as javascript and jquery. I have rich experienced in XML, Software Architecture, Data Extraction, Dropbox API, Process Automation, Automation, Data Management, MySQL and Make.com. For more information about me, please refer to my portfolios. I am checking your attachment, I'll update you shortly... I’m ready to discuss your project and start immediately. Looking forward to hearing you back and discussing all details.. Your Sincerely
$155 USD em 6 dias
4,1
4,1

Hi, I am Haresh, having 14+ years of experience in Software Testing Industry. - Having unique blend of knowledge in Quality Product Delivery, Processes Management, Functional testing, Integration and regression testing, load and Perfromance Testing which help me to take the Quality of the software to the next level. - Hands on experience on testing Desktop, Web Based, Mobile application and ERP based application. - Hands on experience on automation testing tools on selenium webdriver, jmeter, katalon studio, Appium, cypress, selenium with TestNG freamwork etc.. - Thorough understanding of Product Delivery Life Cycle, Software Testing Life Cycle and Software Development Life Cycle. - Experience in Well conversant with writing Test plan,Test Cases,Bug report, Release Note and Product Health Report. - Worked in various domains like Finance, Retail, Web Portals, Healthcare, ecommnerce, CMS, Eduction Portal, Life Insurance, ERP system etc. - I do have require mobile devices to test mobile view or applications like android and iOS applications. - I have hands on experience with Git, postman, MSSQL Server. Kindly review my profile and let me know you view over the same. Thanks, Haresh
$240 USD em 7 dias
3,6
3,6

Hola tengo experiencia con ETL, scrappers, python, bigdata. muchas herramientas que se encajan con lo que estas. buscando. estoy en manizales siguieres podemos. hablar. y como podemos trabajar en tu proyecto Saludos Julian
$300 USD em 7 dias
3,3
3,3

⭐️⭐️⭐️⭐️⭐️ Hello, I am excited about the opportunity to assist you with automating your purchase invoice workflow using Make.com. With extensive experience in automation platforms and a strong understanding of UBL 2.1 XML, I am confident in delivering a seamless solution that meets your requirements. My approach will involve closely monitoring your Zoho Mail for new invoices, efficiently extracting data from the XML, and ensuring proper integration with your MariaDB/MySQL database. I will adhere to your specifications regarding raw SQL names and maintain the integrity of your existing structures. Client satisfaction is my top priority, and I will ensure thorough documentation and a successful handover session. With my skills in automation, email integration, and database management, I am well-equipped for this project. Let’s discuss how I can bring this project to life! Best, Abdulhamid
$100 USD em 1 dia
3,1
3,1

Welcome to professional Python development services! Hi there, I'm Alema, a Python expert programmer who strives for clear code in atmospheric, numerical weather prediction, physics, and all other seminal fields. I'm ready to provide you with high-quality services. I have completed 350+ projects with a 100% Positive Rating. If you are looking for Quality work, look no further. Also, we are a team of professional workers, and we are always available 24/7 to help employers without limitations, and delivery is guaranteed on time. Your faithfully. Eng. Alema Akter
$150 USD em 3 dias
2,5
2,5

Hey , I just finished reading the job description and I see you are looking for someone experienced in Data Extraction, MySQL, Data Management, Process Automation, Automation, XML, Software Architecture, Dropbox API and Make.com. This is something I can do. Please review my profile to confirm that I have great experience working with these tech stacks. While I have few questions: 1. These are all the requirements? If not, Please share more detailed requirements. 2. Do you currently have anything done for the job or it has to be done from scratch? 3. What is the timeline to get this done? Why Choose Me? Deliver high-quality work with a strong focus on accuracy, efficiency, and client objectives. Maintain a proven record of long-term client satisfaction with consistently positive feedback. Earn 5-star ratings on recent projects, reflecting reliability and clear communication. Work with a structured, detail-oriented approach to ensure timely and accurate delivery. Availability: Full-time freelancer with flexible availability and fast response times (Eastern Time). I will share with you my recent work in the private chat due to privacy concerns! Please start the chat to discuss it further. Regards, Hassan.
$30 USD em 6 dias
0,0
0,0

Hello DavidLasus, With 8 years of experience in Software Architecture, I have expertise in creating efficient automation solutions tailored to specific requirements. I have thoroughly reviewed your project description and understand the need for automating the purchase invoice workflow using Make.com. I will set up the system to monitor the Zoho Mail folder, extract data from UBL 2.1 XML invoices, store the information in a MariaDB/MySQL database, and archive the PDFs in Dropbox. Effective communication will be maintained throughout the project, ensuring a smooth workflow. I am excited about the opportunity to work on this project and look forward to hearing from you. Regards
$140 USD em 7 dias
0,0
0,0

Medellín, Colombia
Método de pagamento verificado
Membro desde jan. 30, 2020
$8-15 USD / hora
$30-250 USD
$250-750 USD
$250-750 USD
$8-15 USD / hora
₹600-1500 INR
$10-30 USD
$10-30 CAD
$30-250 USD
mín. $50 USD / hora
$10-30 USD
£20-250 GBP
₹600-1500 INR
$250-750 USD
£20-250 GBP
$40-75 USD
$250-750 SGD
€18-36 EUR / hora
₹600-1500 INR
€250-750 EUR
₹37500-75000 INR
₹12500-37500 INR
₹12500-37500 INR
$250-750 AUD
$30-250 AUD