Data check

[ThomasB445]

Goodafternoon,

New Enfocus user here and still very new to the whole thing

I work at a company where we have a load of customers who deliver XLS, CSV files most of the times, these can be large companies but often also small companies. We tell our customers they can deliver whatever they want to delvier aslong as they are consistent and do their exports with headers.

Problem is they are often not consistent, basically people doing shipments like twice a year.

Does anyone know a useful method to convert any filetype to csv and read the headers and compare them to something we have programmed in (which will be a previous header they have supplied to us) What i want to do is scan the file they deliver and directly confirm the data has been received in good order or whether something is wrong with it.

These files have columns ranging from 2 to like 100.

Hope someone can guide me in the right direction to build this within Enfocus

Thank you,

Thomas

[jan_suhr]

It can be done within Switch but it will require custom scripting, do you have the Scripting module?

[ThomasB445]

Thanks, We dont have it at this moment, but I'll have a look into that

[tdeschampsBluewest]

Hi Thomas,

Not for the convert part, but once you'll have a CSV, you can achieve this using CSV Pickup.

It has a "filter" property that you can dynamically set to check whether a specific column exists.

Your filter might look something like this:

Code: Select all

name=*
lastName=*
zipCode=*
...

If a required column is missing or not properly formatted, the system will flag it as an error. This should help ensure data integrity.

[ThomasB445]

Thanks we'll look into that too