[eluser]Tominator[/eluser]
[quote author="Blameme" date="1271768516"]I would like to make an 2.0 application where:
I can select a table from a db: (based on login auth which you have access to)
Based on this table I can select the fields and drag them in the right order.
[/quote]
DB class and your own model
[quote author="Blameme" date="1271768516"]
Format the fields output (like dates in some custom format).
[/quote]
Your model too ...
[quote author="Blameme" date="1271768516"]
And generate some csv/xls or other format based on the selected fields.
The selected custom export format can be saved for later use.
[/quote]
Take a look to wiki and find some cvs/xls classes.
[quote author="Blameme" date="1271768516"]
In this table there is a field where each time I export a record the datetime is put in.
[/quote]
Data helper
[quote author="Blameme" date="1271768516"]
So when I export a new file only the unexported records will get exported.
[/quote]
Too many solutions ... you can write to DB for each line, if was exported, or save time of export to some file ...
[quote author="Blameme" date="1271768516"]
Also a list of exported dates is available to re-generate the previous generated export files.
[/quote]
I think saving time will be great, it means: export_12-2-2009_15-2-2009.xls, then you can always go to DB and export data between these times.
[quote author="Blameme" date="1271768516"]
So my question is what plugins/helpers or other scripts should I look into besides the standard CI framework to make this development as smooth as possible and with a nice user ajax user interface.[/quote]
Version 2.0 doesn't support plugins
You may try to make some drivers ...