#8 Action on foreign key violation

[Bulat Yapparov]

Need to make it possible to change action for the link violation errors (Links form).
Delete / Copy / Move action should be available.

[Bulat Yapparov]

To remove erroneous records from the valid file you need to add on-error actions to you schema.
See User Guide->Add Actions->Introduction here http://www.flat-file.net/help/

Unfortunately there is no support for lookup violation actions in UI. You can still add them through direct modification of schema XML file.
You will need to change the content within Link tag to make it look like this (also see the modified schema attached):

<Link PrimaryKey="Check" ForeignKey="Url" Lookup="Filtre" DataFile="Part001" CaseSensitive="False">
<Enforce>
<Action>
<Delete />
</Action>
</Enforce>
</Link>

Please feel free to ask if you need more help