Tamamlanmış

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.

Beceriler: PHP, XML

Daha fazlasını gör: 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

İşveren Hakkında:
( 12 değerlendirme ) Belmont, United States

Proje NO: #19301980

Seçilen:

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_period_sub_7% gün içinde 100%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(19 Değerlendirme)
4.7

Bu iş için 5 freelancer ortalamada $115 teklif veriyor

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 Daha Fazla

$155 USD in 3 gün içinde
(110 Değerlendirme)
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...

$50 USD in 3 gün içinde
(43 Değerlendirme)
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 Daha Fazla

$122 USD in 3 gün içinde
(10 Değerlendirme)
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 Daha Fazla

$150 USD in 3 gün içinde
(8 Değerlendirme)
3.7