Creating DNG attributes in bulk
I have a customer who is trying to efficiently import requirement data into DNG. Right now, he's having to create a long list of attributes for each one of the column headers in his CSV/XLS prior to the ingest. He mentions that creating attributes during the ingest process was a capability in DOORS classic. I'm pretty certain that there is no way to do this in DNG for security reasons I'm sure; however I was curious if there was a way to create attributes in bulk or is your only option the web interface?
Accepted answer
Hi Michael,
We've run into this too. The best solution I've come up with is to use a text grabbing screen capture tool (we use SnagIt from Techsmith) to capture the values from Excel, then paste them in the Attributes that we create to match the worksheet columns. It's not elegant but it saves a lot of typing.
Regards,
Carol
Comments
One other answer
My thought is that Excel has many input processing tools including embedded Basic programming.
Also many screen capture/parsing tools allow programming that could output CSV; Then the CSV could be filtered and inspected in Excel before importing, or just import from CSV.
I like the Excel round trip; export; remove extraneous export record data and modified columns; then inspect/sort and fix, even add an attribute column, and then reimport using ID matching to update old data with new/fixed attributes.
You do have the issue of embedded "comma"s to deal with, but quoting them helps