...

View Full Version : Open to Suggestions



Izzittdashooz
02-17-2009, 11:16 PM
I am learning XML, be gentle.

Here's what I am trying to accomplish:

My church has a weekly publication that we put out. It has a plethora of announcements. My goal here is to create a schema that I can us in InfoPath 2003 that will submit to an XML document. From this XML document, I can then keep track of who submitted what, when, when I added it, and when I removed it. I also intend to create queries for those connected with the document to be able to see what is going to be included each week.

I have two kinds of announcements: a prayer list and event/miscellaneous announcements.

Prayer List - There are three actions associated with these submissions: add, change, or remove. The actual submission is usually a name. I also need to keep track of when I add/change the submission, remove the submission, and who submitted the information.

Event/Miscellaneous - These are sometimes time sensitive announcements, for instance, an event in 30 days, next week or this week. There are also some that are removed at the discretion of my supervisory staff (usually the miscellaneous).

When dealing with the time sensitive announcements. I have several dates that I have to keep track of:


The start date
The date three weeks out
The date two weeks out
The date next week
The date for this week
The expiration date


Some of these, obviously, could be blank.

With ALL of the announcements, I have to keep track of the date it was received, who submitted it, when it was added to the document, when it was removed from the document.

While I have a use for XML for many things, in looking at all these things, am I on the right track using XML?

I am using the community version of XMLStudio. I am also overwhelmed with how to set up the schema best to work with InfoPath 2003.

Any suggestions?

Alex Vincent
02-18-2009, 04:30 PM
I've never worked with InfoPath, so I don't know anything about it... but it sounds like you need a database, not XML.

How are people submitting the data to you? How are you formatting the output?

Izzittdashooz
02-18-2009, 10:39 PM
I've never worked with InfoPath, so I don't know anything about it... but it sounds like you need a database, not XML.

How are people submitting the data to you? How are you formatting the output?

I thought that might be right. I guess I wanted to implement XML because I'm learning it.

People give me announcements in e-mail, verbally, over the phone. That is why I wanted to create the form.

InfoPath allows you to create a from based on an XML schema; however, your statement of needing a database makes more sense to me.

Thanks for your help.

oesxyl
02-19-2009, 02:38 AM
I thought that might be right. I guess I wanted to implement XML because I'm learning it.

People give me announcements in e-mail, verbally, over the phone. That is why I wanted to create the form.

InfoPath allows you to create a from based on an XML schema; however, your statement of needing a database makes more sense to me.

Thanks for your help.
when you have:
- unstructured or semistructured data -> xml is better
- structured data -> databases are better

http://searchstorage.techtarget.com/generic/0,295582,sid5_gci1249073,00.html

in both cases you must know what you are doing, a "smart tool" always mess things if you can't control it.

best regards



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum