HPSM 9.33 - Failed Data Export (663 Views)
Reply
Frequent Advisor
HJ-Quick
Posts: 56
Registered: ‎11-10-2013
Message 1 of 5 (663 Views)

HPSM 9.33 - Failed Data Export

Hi,

 

Need help. I was trying to export data into excel / csv. But encounter problem as attached.

 

Thanks

Honored Contributor
Piku
Posts: 4,136
Registered: ‎06-17-2010
Message 2 of 5 (631 Views)

Re: HPSM 9.33 - Failed Data Export

Hi,

Seems you have record which has special character for SM is not able to handle it.
SO try to identify that record by exporting the data in multiple parts for few records at a time.

Also try to change the deliminator for the export to text.

Hth,
____________________________________
Assign Kudo, if found post useful and mark it accepted if solves the issue.
Frequent Advisor
HJ-Quick
Posts: 56
Registered: ‎11-10-2013
Message 3 of 5 (618 Views)

Re: HPSM 9.33 - Failed Data Export

Hi Piku,

 

Thanks for your reply. May i know how to change the delimiter?

 

Thanks

Honored Contributor
Piku
Posts: 4,136
Registered: ‎06-17-2010
Message 4 of 5 (586 Views)

Re: HPSM 9.33 - Failed Data Export

When you export to text ou have option for same. But not in excel it is auto tab delimitated.

hth
____________________________________
Assign Kudo, if found post useful and mark it accepted if solves the issue.
Honored Contributor
DimitarPeychev
Posts: 297
Registered: ‎11-01-2011
Message 5 of 5 (570 Views)

Re: HPSM 9.33 - Failed Data Export

[ Edited ]

Hi,

 

Ability to change the Export to Text File default delimiter.
Workaround
From the Export dialog box shown when clicked Export to Text, manually change the delimiter from the default selected option "Tab" to "Semicolon Separated CSV".

 

Please check it here:

 

http://support.openview.hp.com/selfsolve/document/LID/QCCR1E109219

HP Support
If you find that this or any post resolved your issue, please be sure
to mark it as an accepted solution.
Please also give kudo if you find it interesting :)
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.