Text file input error but only with hop-run.bat

[villehoo]

I have an problem reading and handling a large file when running pipeline through the workflow but only when using hop-run.bat

I had older 2.2.0 (openJDK 17) but tried newest available 2.19.0 with OpenJDK 21 but it didn't fix the issue.
I tried also in another windows server.

There is also a problem with error since MY_COLUMN as I have changed it into error description is weird combination of
column names and the one MY_COLUMN doesn't exist in header or in data.

I had similar issue one year ago but I think unchecking 'lazy conversion' or something else fixed it.
From hop-gui.bat I can run the steps fine but can't automate this one workflow currently.

I have tried to look the error row in file but it looks normal in various editors and in Excel.
I tried both CSV input and text file Input steps.

Values for "number" two number fields can be Null, -1 or number (#.##) and I have tried different setting for type and formats in step. Also different settings for almost every setting in content tab.

I got errors for some integer columns too but after changing type to string those rows don't give errors anymore.

The error I can't get rid off:

Unexpected conversion error while converting value [MY_COLUMN String] to a Number

MY_COLUMN String : couldn't convert String to number
Unparseable number: "-1.00"

at org.apache.hop.pipeline.transforms.csvinput.CsvInput.processRow(CsvInput.java:182)
at org.apache.hop.pipeline.transform.RunThread.run(RunThread.java:54)
at java.base/java.lang.Thread.run(Thread.java:1583)

Caused by: org.apache.hop.core.exception.HopValueException:
Unexpected conversion error while converting value [MY_COLUMN String] to a Number

MY_COLUMN String : couldn't convert String to number
Unparseable number: "-1.00"

[hansva]

Make sure to fill in the decimal and grouping symbols that your numbers have. When it is not filled in we use system default and I noticed this might change in different situations

[villehoo]

Thanks, It seems I get forward after checking those settings and also changing every integer in input to string. * Ville

…

________________________________ From: Hans Van Akelyen ***@***.***> Sent: Thursday, August 20, 2026 15:06 To: apache/hop ***@***.***> Cc: Ville Hämäläinen ***@***.***>; Author ***@***.***> Subject: Re: [apache/hop] Text file input error but only with hop-run.bat (Discussion #8030) Make sure to fill in the decimal and grouping symbols that your numbers have. When it is not filled in we use system default and I noticed this might change in different situations — Reply to this email directly, view it on GitHub<#8030?email_source=notifications&email_token=AHMYZQ66DASLDHBHE3C6XHL5K3SUJA5CNFSNUABIM5UWIORPF5TWS5BNNB2WEL2ENFZWG5LTONUW63SDN5WW2ZLOOQXTCOBQHEZDSMZZUZZGKYLTN5XKMYLVORUG64VFMV3GK3TUVRTG633UMVZF6Y3MNFRWW#discussioncomment-18092939>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AHMYZQ65JYCFSL3DVXXMZOL5K3SUJAVCNFSNUABIKJSXA33TNF2G64TZHMZDCMBVG44TAMRRHNCGS43DOVZXG2LPNY5TCMBWGUZTCMBYUF3AE>. Triage notifications, keep track of coding agent tasks and review pull requests on the go with GitHub Mobile for iOS<https://github.com/notifications/mobile/ios/AHMYZQ4T4RQRFNYWTMUXBF35K3SUJA5CNFSNUABIM5UWIORPF5TWS5BNNB2WEL2ENFZWG5LTONUW63SDN5WW2ZLOOQXTCOBQHEZDSMZZUZZGKYLTN5XKMYLVORUG64VFMV3GK3TUVJTG633UMVZF62LPOM> and Android<https://github.com/notifications/mobile/android/AHMYZQ4GRCS5ORPKYK2NI6D5K3SUJA5CNFSNUABIM5UWIORPF5TWS5BNNB2WEL2ENFZWG5LTONUW63SDN5WW2ZLOOQXTCOBQHEZDSMZZUZZGKYLTN5XKMYLVORUG64VFMV3GK3TUVZTG633UMVZF6YLOMRZG62LE>. Download it today! You are receiving this because you authored the thread.Message ID: ***@***.***> The information in this email may be confidential and is intended solely for the use of the individual or entity to whom it is intended. If you are not the intended recipient of this message, please delete the message and notify the sender immediately. For information on how we process personal data and our contact information, please see CSC's website: Privacy<https://csc.fi/en/privacy> Tämän sähköpostin tiedot voivat olla luottamuksellisia ja ne on tarkoitettu yksinomaan sen henkilön tai yhteisön käyttöön, jolle ne on osoitettu. Jos et ole viestissä tarkoitettu vastaanottaja, tuhoa viesti ja ilmoita asiasta välittömästi viestin lähettäjälle. Tietoja henkilötietojen ja yhteystietojen käsittelystä löydät CSC:n verkkosivuilta: Tietosuoja<https://csc.fi/tietosuoja>