Find Jobs
Hire Freelancers

OFX (XML) file processing

$30-250 USD

Completed
Posted almost 5 years ago

$30-250 USD

Paid on delivery
I need to have a Quickbooks OFX file processed in order for import into quickbooks. OFX files are XML based. The problem we need solved is that the records often have variable data in the name field which is used to identify the vendor int eh record. This makes it impossible for Quickbooks to properly import the data - without manual intervention. The project is to write a pre-processor which will strip the variable data form the name field. For some records, the variable data may need to be added to another field in the record. The code would scan through the XML file looking for several patterns. It would replace the found pattern with another. For the FedEx transactions, there is some additional processing needed. For other transactions (such as example 2) we just need the name field data replaced by a simple string. Here are the examples: Example 1. Input: <NAME>FEDEX 786285813343 FMEMPHIS TN<MEMO>JOHN B-94000-78628581334INVOICE #14636 20723</STMTTRN> Output: <NAME>FEDEX<MEMO>786285813343 JOHN B-94000-78628581334INVOICE #14636 20723</STMTTRN> Example 2: Input: <NAME>Square Inc DES:190XXXX2 ID:L2104 <MEMO>Square Inc DES:190XXXX2 ID:L21043XXXXXXX INDN:MA Inc CO ID:902 PPD </STMTTRN> Output: <NAME>Square <MEMO>Square Inc DES:190XXXX2 ID:L21043XXXXXXX INDN:MA Inc CO ID:902 PPD </STMTTRN> Ideally the code can read from a file for the list of patterns to process. Right now we have 6 patterns we want to look for. I'd like this implemented as a web page. We currently have a program that was written by a freelancer on this site in 2010. The program worked until last week when FedEx changed the format of their transactions. Unfortunately, all I have is a C++ executable with no source code. The freelancer who wrote it is long gone so we need to re-implement it.
Project ID: 19301980

About the project

4 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hey ! I would be more than happy to code a script to detect and replace the patterns you've specified. Feel free to contact me to get started, Regards
$100 USD in 10 days
4.9 (22 reviews)
4.9
4.9
4 freelancers are bidding on average $107 USD for this job
User Avatar
⭐⭐⭐⭐ i will finish your project very quickly. ⭐⭐⭐⭐⭐⭐ I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. * 4+ years experience in web design and development and site build. Timely delivery 24 hours communication Hope to get your early response Thanks ⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐
$155 USD in 3 days
4.9 (121 reviews)
7.4
7.4
User Avatar
Dear sir. I read your description carefully. I have fully talents and skills of this part. I can give you satisfactory results. I want you to call me. From DragonWarrior...
$50 USD in 3 days
4.9 (49 reviews)
6.2
6.2
User Avatar
I have analysed your requirement carefully and as per my previous experience i can work on this project for you. I have extensive experience in required field. I would be working on daily basis and thus will send you daily status for flawless monitoring of your project Avin H.
$122 USD in 3 days
5.0 (14 reviews)
4.3
4.3

About the client

Flag of UNITED STATES
Belmont, United States
5.0
15
Payment method verified
Member since Jul 21, 2006

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.