Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About vbrich

  • Rank
  1. vbrich

    Tools for Schemas

    Thanks for the input. I agree that Excel adds a layer of "What the ..." to the whole concept. I guess I will search ways of doing this myself from scratch. The whole problem is that 30 people without much technical knowledge need to add/remove fields from this master schema we are creating and I need to think of a good way to manage it. It is probably much more of a process question than a technical question. I was just hoping that somebody may have heard of some sort of application that would help facilitate this schema design project. Unfortunately there are many xml files that go into makin
  2. vbrich

    Tools for Schemas

    I don't think I was very clear in my problem.I am only working with Schemas at this point. Let's take one schema for an example. Income.xsd> Currently there is a Income.xls file that contains it's own representation of the schema file. > 30 different people make changes to this xls file and send it back to me> I cut and paste and merge these files back into a single xls file> I then run macros that create the Income.xsd file from the single xls file> I don't deal with the individual xml files that these schemas validate at any time. Problems:> People make typos in Excel and i
  3. vbrich

    Simple Query or not

    I have a sql question that somebody probably knows off the top of their head. I have a table with data like this...TABLE> ID> FIELD1> FIELD2> FIELD3> TYPEI need to find how many rows contain data where the set (FIELD1, FIELD2, FIELD3) is the same, but the (TYPE) is different. In other words, all the fields have different values, but if the set of the 3 (FIELD1 = 1, FIELD2 = 2, and FIELD3 = 3) is the same, then I need to find instances where TYPE is not the same. I hope I am explaining this clearly. Basically, if there is more than 1 row where FIELD1=X, FIELD2=Y, and FIELD3=Z, I
  4. I hope this qualifies as a schema question.I am taking over a project that involves multiple parties (30) all trying to define a generic master set of schemas. To abstract the technical stuff, each party submits their changes using excel spreadsheets (I know) to indicate changes they are requesting. These spreadsheets (containing over 10000 rows) are then run through macros to generate the schemas. Everything works fine if the parties do not make any typos and follow the color guidelines for their change requests (e.g red to delete, green to change, yellow to add new...). Of course, that is wh
  • Create New...