Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Data Exchange Excel Driver E7 insteat number

Highlighted
Zorin
Regular Collector

Data Exchange Excel Driver E7 insteat number

hi,

I have Data Exchange Task for excel file.
And when I make XML file then field has E7 on trail (for example real value is 78501267 but in XML file is 7.8501267E7).
How to make real value in XML file?

Regards,
Rodion Zvorygin
6 REPLIES
Mihai Tita
Occasional Visitor

Re: Data Exchange Excel Driver E7 insteat number

Hi,

It's easier to change the corresponding cells format before you create the xml file.
Try with Text!

Format -> Cells... -> Number -> Text


Regards,
Mihai
Zorin
Regular Collector

Re: Data Exchange Excel Driver E7 insteat number

Hi, Mihai,

I did it but nothing! value in XML - steel 12345678E7
Mihai Tita
Occasional Visitor

Re: Data Exchange Excel Driver E7 insteat number

Hi,

Please find attached a .xls file and the corresponding .xml file.
In order to verify your Data Exchange task try to export my .xls file.

Regards,
Mihai
Zorin
Regular Collector

Re: Data Exchange Excel Driver E7 insteat number

Hi, Mihai,

I did it. But it possible only with wizard "Converting text in columns" (I'm using russian version and not sure in exatcly naming this wizard). Your suggestion not working. I don't know why.

with regards,
Rodion Zvorygin
Zorin
Regular Collector

Re: Data Exchange Excel Driver E7 insteat number

Thank you, Mihai.
I did my column in text type. You example help me.

Rodion Zvorygin
Mihai Tita
Occasional Visitor

Re: Data Exchange Excel Driver E7 insteat number

Hi Zorin,

In that situation the number in the cell is formatted as text or preceded by an apostrophe.
You can try to add an apostrophe!

Regards,
Mihai
//Add this to "OnDomLoad" event