ETL and Data Integration tools - Modern ETL software for everyone

Hello Support

We recently bought an Enterprise version and it works very good.

But I have a problem with the price import. We often gets product files with the price in the format 9999.99 and 9999 as you can see in the included example. The database is using (,) as decimal point.

What happens is this:

If I map the [F8] column from the file to the database field PURCPRICE I get following error

Record:1 Line:1 Can't convert Value '7950.00' to type DECIMAL for field PURCPRICE

f I make a calculation (as in the included file) the PURCPRICE column will be empty in the database after running import.

I have tried to convert, round, replace, trim and so on, as they are and in combination. Nothing seems helps.

Have a nice day,
Stefan

I have to make sure that decimals separator matches your regional settings

I assume that it is comma

So you need to replace dot with comma than it should work

Peter

Works as expected

Thank you or the help peter

Stefan