Wanted a tool like this for years but never stepped over something that really did exactly what i was looking for. Finally made the effort and looked deep throught some of the tools here on mibuso and this one made me happy
It has some years already but sill thx for that
Didn't test all the features yet, but here are 2 basic things that didn't work for me:
- The options "Insert" and "Update" seem always true even if I deselect them. Checked it in Debugger: The Variable "ImporterOptions" comes differently but the codepiece "optInsert := testBit(0,ImporterOptions);"(in function "ImportDataFromFile") doenst seem to work as intended. I made a workaround in function "ChooseColumnsToImport" where i read all the options directly, save them in global variables and set them later again.
- Scenario: I have a big list with entries where i just want to insert the new ones and NOT update existing ones: Didn't work except i used the "Delayed Insert" Option. I changed this little bit of code so it suits me better:
//IF (optInsert AND NOT optDelayedInsert) OR (recordFound AND optUpdate) THEN BEGIN //old
IF (NOT recordFound AND optInsert AND NOT optDelayedInsert) OR (recordFound AND optUpdate) THEN BEGIN //new