Project Title: FormFiller

The Challenge

In the rapid world of telecommunication speed can be a determining factor for successful growth. Lots of data and information require custom automation solutions that can ease the procedure of synchronizing data.

The personnel of the company work with a large number of data, information resources and systems. Sometimes there arises a need to transfer accumulated data to third-party databases or convert it into orders to third-party service providers. Transferring thousands of data objects requires painful manual efforts and will undoubtedly put customer’s personnel off its key responsibilities, which may result in financial loss for the company. So the need to develop a solution that will allow the staff to use automated form filling was obvious.

The Solution

It was agreed to make the system as a small application that will perform automatic batch upload of project order entries into a web form on a third-party service provider website. Program was intended for "from time to time" usage, thus no sophisticated user interface or detailed documentation was needed. No further development of the application was planned.

Application was designed to run under Windows 2000/XP, input file format must have been compatible with Microsoft Excel 2000 and newer. First data row in excel sheet should contain the web form's name attributes of "input" or "select" tags for the corresponding data column. Application is able to handle files with about 10000 rows (about 10 000 form submits).

The application can automatically logon to third-party website and maintain the session (for instance, storing Jsession in a cookie or URL). Also it is able to determine whether the submission of a single entry was successful or caused error in the system. The user can change the frequency of form filling and submitting. Successful submit is determined by comparing contents of the resulting information page and the initial data. If they match then submission is considered successful, and the form can be filled and submitted again.

Tools and Technologies

Java 1.5, Apache POI library, The Jakarta Commons HttpClient library, The Jakarta Commons Logging library.

Related links

http://www.qulix.com/Case_Study_-_FormFiller.html

Post Your Story, Tell All About Your Success!

If you want the story of your company to appear on the portal please fill out this form and send it to [email protected]. We would also like you to leave contact information (name, e-mail, phone) of a person who is responsible for filling the form to clarify any questions, which could appear.

Available Success Stories From Companies:

Disclaimer

All information contained in this Section is owned by RUSSOFT.org and its Participants and is protected by Russian and international copyright laws. Any reproduction or republication of all or part of this Section has to remain intact and include a notice on the copyright of RUSSOFT.org or the Participants, as applicable.

While the information of this Section has been presented with all due care, RUSSOFT.org does not warrant the accuracy, completeness, usefulness and truth of Section’s information, links and logos derived from third parties. RUSSOFT.org is not liable for any loss or damage occurring from the use of this Section’s materials.