HPSM 9.33 - Failed Data Export (493 Views)
Reply
Advisor
HJ-Quick
Posts: 31
Registered: ‎11-10-2013
Message 1 of 5 (493 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,810
Registered: ‎06-17-2010
Message 2 of 5 (461 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: 31
Registered: ‎11-10-2013
Message 3 of 5 (448 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,810
Registered: ‎06-17-2010
Message 4 of 5 (416 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: 292
Registered: ‎11-01-2011
Message 5 of 5 (400 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