Clarity

  • 1.  XML Source Missing Fields in Excel

    Posted Jan 17, 2018 10:13 AM
      |   view attached

    Hi All,

     

    We have the need to load bulk data. We have the project write xml with us when we are trying to use that as a source to excel it's not bringing all the custom fields. It is picking only first two custom fields at a time irrespective of the no. of fields used in whatever sequence

     

    We are getting a error while doing it. Could you please let us know what could be the reason of it asap as it is very urgent

     

    Regards\\Avik



  • 2.  Re: XML Source Missing Fields in Excel

    Posted Jan 17, 2018 10:41 AM

    I don't really know what I'm talking about here (in terms of the right terminology I mean), but custom fields don't appear in the XML in the same way that stock fields do - custom fields always appear in the "CustomInformation" as a "ColumnValue" name and value pair rather than the explicit attribute="***" XML for the "real" attributes.

     

    So I'm not sure that you can do what you are trying to do in the way that you are doing it (I assume you are doing something like is described here How to use Microsoft Excel to Map Data into XOG Files, then Update Directly to CA PPM )

     

    You can of course import data from XLS to the system via XML/XOG in many* ways, but they will involve some coding somewhere (to produce valid XML) rather than just "data manipulation" in Excel.

     

    (* discussed elsewhere on these discussions in a few places)



  • 3.  Re: XML Source Missing Fields in Excel

    Posted Jan 17, 2018 11:01 AM

    Tend to agree with Dave_3.0  based on the point in the referenced thread where it is said

    "The xml file must have simple non-hierarchical structure so for eg. users remove groups, rights, partitions, OBS etc."

    For project Custom attributes is similar

    and

    "If you have a simple set of existing data which creates single level xml and you want to add data/records then this is at its best."

     

    Watch the video to see how smooth it can be when it works.