Skip to main content
Solved

Data format issues when loading CSV


Bitmetric_Maarten
Contributor
Forum|alt.badge.img

Hi all,

We are trying to load CSV files into the ODX using the CSV data source. However we are getting errors on fields it is trying to interpret as int (housenumber), but some are filled in as 12-18 and therefor failing. We have tried to use the override data type option, but to no avail. What can we do about this?

Kind regards,
Maarten

Best answer by rory.smith

Hi @Bitmetric_Maarten ,

you should use .rsd files to define such fields as string and then apply transformations to resolve those cases. This article gives you the basics: 

 

View original
Did this topic help you find an answer to your question?

2 replies

rory.smith
TimeXtender Xpert
Forum|alt.badge.img+7
  • TimeXtender Xpert
  • 649 replies
  • Answer
  • June 21, 2023

Hi @Bitmetric_Maarten ,

you should use .rsd files to define such fields as string and then apply transformations to resolve those cases. This article gives you the basics: 

 


Bitmetric_Maarten
Contributor
Forum|alt.badge.img

Thanks. This answer worked!


Reply


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