The Design of Software (CLOSED)

A public forum for discussing the design of software, from the user interface to the code architecture. Now closed.

The "Design of Software" discussion group has been merged with the main Joel on Software discussion group.

The archives will remain online indefinitely.

parsing Word or RTF file for db insertion

I built a CRUD app (calendar) for a client, however some months they enter over 100 events which as you can imagine becomes pretty laborious doing them one at a time with a web app.
My thought was that they could upload a Word or RTF file containing all the events and parse that file and enter each record in to the database.
I'm sure someone here has run into the same dilemma and I'm interested in how you went about it. I'm trying avoid having client learn some type of custom tagging if possible.

Any suggestions/tips/experiences are greatly appreciated.
thanks
sam Send private email
Saturday, October 29, 2005
 
 
Why Word and not Excel? Seems like you coould create an Excel spreadsheet and then simply save it as a .csv then parse and insert.
TownDrunk
Saturday, October 29, 2005
 
 
damn! talk about not seeing the forest thru the trees!
thanks
sam Send private email
Saturday, October 29, 2005
 
 
:)

http://neopoleon.com/blog/posts/434.aspx
[in case you haven't read it already..]
ZET
Monday, October 31, 2005
 
 
http://wvware.sourceforge.net/

SF project that converts word documents into plaintext. Used by the AbiWord project.
Stephen Caldwell Send private email
Monday, October 31, 2005
 
 
http://www.aspose.com/default.aspx

if you're coding in a .net or java environment, these guys make a pretty good object library for handling word, excel, etc...

i just used the excel one for a client of mine (client paid the $500), and everything's run silky smooth so far...
Kenny
Monday, October 31, 2005
 
 

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics
 
Powered by FogBugz