Terminé

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.

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.

Compétences : PHP, XML

en voir plus : 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

Concernant l'employeur :
( 12 commentaires ) Belmont, United States

Nº du projet : #19301980

Décerné à:

GervaiseT

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

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 10 jours
(19 Commentaires)
4.7

5 freelance font une offre moyenne de $115 pour ce travail

KashirinA

⭐⭐⭐⭐ 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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(110 Commentaires)
7.2
kipdev13

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...

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(43 Commentaires)
6.0
HaryCoders

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(10 Commentaires)
4.2
BoyVit85

*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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(8 Commentaires)
3.7