Skip to main content
Solved

Excel Data Migration Invalid Number

  • December 28, 2021
  • 2 replies
  • 240 views

Forum|alt.badge.img+2
  • Do Gooder (Customer)
  • 1 reply

Hi, 

I get an error when I try to update the parts catalog weight if the number is equal to or less than 0.00001.

For Instance:

 

But the same value can be specified in IFS without any problem:

 

The migration job is very simple:

 

Has anyone already had a similar problem?

Thanks for your feedback.

 

Kind Regards,

Daniele

Best answer by iz1gwn

Hi Dumeesha,

 

It worked! Thanks for helping me!

 

Kind Regards,

Daniele

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

2 replies

Dumeesha Wanigarathna
Superhero (Partner)
Forum|alt.badge.img+16

Hi @iz1gwn ,

This normally happens  in occasions where scientific notation goes to E+1.

 

Please check the below workaround

-Open excel and Connect to the Migration job 
-RMB on Qty/Assembly column -> Format cells -> Number -> Text -> OK
-Update the Qty/Assembly with a number having more than 4 decimals -> Validate/Execute 
Please check above works for  you


Forum|alt.badge.img+2
  • Author
  • Do Gooder (Customer)
  • 1 reply
  • Answer
  • January 3, 2022

Hi Dumeesha,

 

It worked! Thanks for helping me!

 

Kind Regards,

Daniele


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings