Đã hoàn thành

OFX (XML) file processing

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.


<NAME>FEDEX 786285813343 FMEMPHIS TN<MEMO>JOHN B-94000-78628581334INVOICE #14636 20723</STMTTRN>


<NAME>FEDEX<MEMO>786285813343 JOHN B-94000-78628581334INVOICE #14636 20723</STMTTRN>

Example 2:


<NAME>Square Inc DES:190XXXX2 ID:L2104







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.

Kĩ năng: PHP, XML

Xem nhiều hơn: ofx format example, python ofx, ofx file, ofx validator, ofx parser, java ofx parser, simple write xml file, simple xml file, read simple xml file, php parse simple xml file, read xml file vbnet simple, simple online xml file editor, simple code reading xml file using vbnet 2005, updating xml file using simple cms, simple example reading xml file vbnet, reading simple xml file, simple parse xml file, excel 2007 export xml file simple, simple online xml file, simple xml file read xml cnet

Về Bên Thuê:
( 12 nhận xét ) Belmont, United States

ID dự án: #19301980

Được trao cho:


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 trong 10 ngày
(19 Đánh Giá)

5 freelancer đang chào giá trung bình $115 cho công việc này


⭐⭐⭐⭐ 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 developm Thêm

$155 USD trong 3 ngày
(110 Nhận xét)

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 trong 3 ngày
(43 Nhận xét)

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 y Thêm

$122 USD trong 3 ngày
(10 Nhận xét)

*Dear sir.* I have read your proposal carefully and really understood what you want. Having more than 10 years of experience in web development, my main objective is to make sure that the clients' requirements are me Thêm

$150 USD trong 3 ngày
(8 Nhận xét)