Does anyone know of a tool that can be used to validate a flat file using the schema that is created by Cast Iron. I have created a Flat File schema for a EDIFACT file, and when bring a new carrier on board i want them to verify the structure of the file they are producing. However i do not want to give them the WHOLE project. Just the flat file schema, and a tool to compare there output with the input that Cast Iron is expecting.
Does anyone know of a tool that will help validate the flat files being sent.
This topic has been locked.
4 replies Latest Post - 2012-10-10T10:45:40Z by michaelkdown
Pinned topic Validate Flat File Schema OUTSIDE of Studio
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-10-10T10:45:40Z at 2012-10-10T10:45:40Z by michaelkdown
SystemAdmin 110000D4XK1250 PostsACCEPTED ANSWER
Re: Validate Flat File Schema OUTSIDE of Studio2012-10-01T07:20:06Z in response to michaelkdownHi,
If I understand correctly, you have built a project that can receive csv files and transform them into EDIFACT, and you would like to check beforehand if the csv files have the correct structure, is that right?
Why don't you build another project that just parses the csv files, and answer with a custom result parsing message (OK or KO)?
Re: Validate Flat File Schema OUTSIDE of Studio2012-10-01T08:19:29Z in response to SystemAdminI thought about this, and i was going to build it however, when it parses the flat file, and throws an error. It does not give a single error message that can utilised to fix the issue; all it says is an error occurred parsing the file. I was just wondering if there was a tool that can utilise the Schema that Cast Iron produces to validate the files?
NateTheRobot 270004S7U74 PostsACCEPTED ANSWER
Re: Validate Flat File Schema OUTSIDE of Studio2012-10-10T09:32:11Z in response to michaelkdownHave you tried to just create another project with the defined flat file schema? By opening the flat file schema in Studio, the bottom part of the flat file designer can let me verify any example data and output the transform result. Also it indicates at which position of the flat file that it finds severe problem during the flat file transformation.
Re: Validate Flat File Schema OUTSIDE of Studio2012-10-10T10:45:40Z in response to NateTheRobotIt looks like this is going to be the only real method of achieving this. I didn't really want to the BA's to have to install Cast Iron on there local machines just to validate a flat file that is received from another company. I was hoping there was a light weight application that could be used to interoperate the schema and allow to be validate it. This isn't looking likely, so the installation of Cast Iron is the only other possible solution.
Thank you for your response