Export to Excel (Data Only) that includes attachment fields sometimes shows the file name and sometimes shows the internal folder id.

Document ID:  TEC1280392
Last Modified Date:  06/08/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA PPM

Releases

  • CA PPM:Release:15.1

Components

  • CA PPM SAAS STUDIO INTERNAL ONLY:ODSTU
  • CA PPM STUDIOINTERNAL ONLY:PPMSTU
Problem:

Export to Excel (Data Only) that includes attachment fields sometimes shows the file name and sometimes shows the internal folder id. The ootb attachment field in Export to Excel contains the internal folder id. The custom attribute shows the file name correctly.

Steps to Reproduce:

1. Open object Requirements
2. Notice OOTB attribute:
Attribute Name=Attachment
Attribute ID=rqp_attachment
Data Type =Attachment
Attachment Style=Multiple Documents
Database Table= RQP_REQUIREMENTS
Database Column=ATTACHMENT
3. Create Custom Attribute:
Attribute Name=my_attachment
Attribute ID=my_attachment
Data Type =Attachment
Attachment Style=Multiple Documents
Database Table= odf_ca_requirement
Database Column=my_attachment
4. Add both attributes to the Edit Page
5. Create a Requirement instance with id=test. Save it. Populate Attribute 'Attachment' (select for example myfile1.txt) and Attribute 'my_attachment' (select for example myfile2.txt).
6. Add both attributes to the Requirements List.
7. Run query:
select attachment from RQP_REQUIREMENTS where code='test'
attachment =5212601.
8. Export to Excel. Observe columns.

Expected Result: 
The attachment fields in Export to Excel should be the file name

Actual Result: 
The ootb attachment field in Export to Excel contains the internal folder id.
The custom attribute shows the file name correctly.
Column 'Attachment' shows 5212601.000000
Column 'my_attachment' shows myfile2.txt

Cause:

Caused by DE29682

Resolution:

Defect is fixed in 15.3.

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >

Chat with CA

Just give us some brief information and we'll connect you to the right CA ExpertCA sales representative.

Our hours of availability are 8AM - 5PM CST.

All Fields Required

connecting

We're matching your request.

Unfortunately, we can't connect you to an agent. If you are not automatically redirected please click here.

  • {{message.agentProfile.name}} will be helping you today.

    View Profile


  • Transfered to {{message.agentProfile.name}}

    {{message.agentProfile.name}} joined the conversation

    {{message.agentProfile.name}} left the conversation

  • Your chat with {{$storage.chatSession.messages[$index - 1].agentProfile.name}} has ended.
    Thank you for your interest in CA.


    Rate Your Chat Experience.

    {{chat.statusMsg}}

agent is typing