HPSM 9.33 - Failed Data Export (427 Views)
Reply
Advisor
HJ-Quick
Posts: 26
Registered: ‎11-10-2013
Message 1 of 5 (427 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

Please use plain text.
Honored Contributor
Piku
Posts: 3,670
Registered: ‎06-17-2010
Message 2 of 5 (395 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,
Please use plain text.
Advisor
HJ-Quick
Posts: 26
Registered: ‎11-10-2013
Message 3 of 5 (382 Views)

Re: HPSM 9.33 - Failed Data Export

Hi Piku,

 

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

 

Thanks

Please use plain text.
Honored Contributor
Piku
Posts: 3,670
Registered: ‎06-17-2010
Message 4 of 5 (350 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
Please use plain text.
Honored Contributor
DimitarPeychev
Posts: 286
Registered: ‎11-01-2011
Message 5 of 5 (334 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 :)
Please use plain text.
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