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