Bizarre behavior using worklist

[NickHealy_Hamilton]

Hi Nick,

If you are worklisting with CSV or another type of structured text file, this is a limitation with some of the Microsoft Jet drivers VENUS needs to use to interact with various file types. For various reasons, these drivers can be tempermental when reading files that contain alphanumeric strings (mixed types).

For starters, if the filepath of the worklist is being reused from run to run, you will want to be sure to delete the automatically generated ‘schema.ini’ file used by the Jet drivers to inform how to process each column of data (including mixed types).

Check this post for more context:

Issue with file parsing

Hi Don, Because you are using a structured text file, if the name and file path of the CSV you are providing to the method are being reused from run to run, one likely possibility is that a ‘schema.ini’ file may already exist for the CSV file used. If this file already exists, then the driver VENUS uses to process structured text files will apply whatever schema was appropriate for a previous file to the current file, which can cause issues of this nature. Check these posts for more context: h…

Additionally, in this instance, it often helps to open in ‘Append’ mode instead of ‘Read’ mode. This results in more robust processing of mixed strings.

Thanks.

-Nick