Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    New to the CF scene
    Join Date
    Feb 2009
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Open to Suggestions

    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?

  • #2
    Moderator
    Join Date
    May 2002
    Location
    Hayward, CA
    Posts
    1,461
    Thanks
    1
    Thanked 23 Times in 21 Posts
    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?
    "The first step to confirming there is a bug in someone else's work is confirming there are no bugs in your own."
    June 30, 2001
    author, Verbosio prototype XML Editor
    author, JavaScript Developer's Dictionary
    https://alexvincent.us/blog

  • #3
    New to the CF scene
    Join Date
    Feb 2009
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Alex Vincent View Post
    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.

  • #4
    Master Coder
    Join Date
    Dec 2007
    Posts
    6,682
    Thanks
    436
    Thanked 890 Times in 879 Posts
    Quote Originally Posted by Izzittdashooz View Post
    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/...249073,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


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •