XML Processing Program
Project ID:
630976Project Type:
FixedBudget:
$30-$250 USD
Project Description:
We are looking for someone to write a string-processing program for XML files.The current process requires a lot of manual intervention on files that are loaded daily. We want to build a program that will automate most of the current manual activity.
The program will work as follows:
1) The program will read in an XML file specified by the user.
2) The program will look for XML records in the file with certain string patterns and replace them with a new pattern.
For example: <TRAN><NAME>XYZZZ#3981110 1-600-122-1<MEMO>39892INVOICE #4247</TRAN>
would become: <NAME>XYZZZ<MEMO>3981110 INVOICE #4247<MEMO></TRAN>
3) The program will repeat this process for the number of defined string patterns.
4) The program will generate a revised version of the XML file.
The program must:
1) Be run self contained on the desktop. The information in the XML file is sensitive and should not be transmitted over the web.
2) Run without a bunch of DLL files etc. Preferably from a browser.
3) Have a GUI that allows the user to:
a. Specify the location of the XML input file
b. Specify the location of the XML output file.
c. Allow modification of the string patterns.
d. Start the processing.
4) Have some sort of licensing platform built in.
5) Be able to run on Microsoft operating systems from XP up.
Skills required:
.NET, Java, Joomla, PHP, XML
Public Clarification Board
7 messages
-
jbcarbon
Screen Mockup
Here is a quick drawing of a screen mockup. Not sure how to include the fact that the transaction ID needs to be moved from the NAME field to the MEMO field and how to indicate how to fomat the MEMO field.over 1 year ago
-
jbcarbon
About Us
I am a former IT consultant with 10 years experience in IT consulting , management, programming etc. I no longer work in IT and instead have a company that sells consumer goods.
However, with my previous IT experience, I know how to write specifications and get what we need. I've worked with a number of getafreelancer.com providers and have had good results. We are not looking for the cheapest and fastest bid but are looking for a provider who will deliver the product on time. I tend to pay a bonus when we get a good result. I will not grind you on cost and understand that if we make a specification change, its costs time and money.
I look forward to working with one of you guys.
Johnover 1 year ago
-
jbcarbon
Web Vs Desctop
The program needs to run only on the desktop. The XML file weill have credit card account numbers (and other confidential information) in it. So the data can not be transmitted over the web. But whether the program runs in a browser or as a standalone C#, .Net, VB, etc program is up to the developer.over 1 year ago
-
jbcarbon
Licensing
We are looking to sell the tool once its developed. So licensing needs to be included so that customer's have to buy the program. We are not a software company (although we have a deep software background) so we need something very light. We are not looking for a bulletproof licensing solution. We doubt anyone who would want this tool will be searching the net for a free, hacked version.over 1 year ago
-
jbcarbon
Here is the XML file after the processing. Not how the transaction IDs have been moved from the NAME field to the Memo field. We also changed the memo field a bit.
The manipulation of the memeo field is probably out of scope other than to move the transaction to it. But I'm showing the IDEAL manupulation.over 1 year ago
-
jbcarbon
This is a simplified version of the XML file before processing.
The change needs to be made in the <NAME> and <MEMO> fields.
Notice that we show 3 names: CCMM Credit Company, CCMM, and CCM. These are all names that correspond to services provided by the same company. The problem is that there are transaction IDs in the NAME field for CCMM and CCM. This prevents the program that loads the XML file from doing an automatic mapping. This forces the user to manually map it. What should be a 5 minute load takes an hour. So what we need is a program that 'pre-processes' the XML to move the transaction ID from the NAME field to the MEMO field.
1) We've included 3 NAMES to manipulate. Please use that as the basis for your bid. An ideal solution would allow the program to easily be expanded to include more mapping. But that is not required.
2) The format of the NAME and MEMO field for CCM and CCMM are different. Note the before and after. The solution MUST make it easy to modify the program if the format changes. We can't have to replace all the desktop executables if the format of the incoming XML changes.over 1 year ago
