Service Desk Practitioners Forum
cancel

issue with importing decimal number to duration field

Highlighted
Jan Gunnar Helg
Honored Contributor.

issue with importing decimal number to duration field

Hi

We have a oracle table that stores a duration column for our services. This column is imported to HPOVSD 4.5 using the data exchange.

However, HPOVSD rounds the number when generating the XML file and the results are therefor incorrect.

Example a value of 1.5 in the source table gets imported as 2 in the XML.

How do I correct this, any workarounds?
2 REPLIES
Jan Gunnar Helg
Honored Contributor.

Re: issue with importing decimal number to duration field

I am one step closer.

I converted the column to char in the source table and the data is now transferred as 1,5. But HPOVSD wants the data as 1.5. How do I change the decimal delimiter?
Jan Gunnar Helg
Honored Contributor.

Re: issue with importing decimal number to duration field

Well after some ingenuity on my own (after staring at my motivational MacGyver poster for an hour) I found a solution, or well an elaborate workaround at least :)

1. Use SQL plus to genereate a csv file from the source view
2. Run a find/replace app that swaps all , with . in csv file
3. Run sd_event using the modified csv file as source

Voilà, totally automated, even sends me an email if anything out of the ordinary happens ;)

As a extra pleasant surprise; sd_event also support blanking of fields which the HPOVSD data exchange solution does not.