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
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)