Date and Time in import CSV

Hello Jean

You have a row (number 0) in your CSV file with the name of your columns. This is the one causing the error.

Instead of starting your loop at 0, start it at 1 in order to skip the first row.

c := sl.Count;
          for i := 1 to c - 1 do
          begin....

As for the rest, huuuuuuu.... I'm still looking :-)

Have fun

Cheers

Mathias

Hello Mathmathou

Thanks for your answer and fixed project.

I always have a hard time to extricate myself with dates and times (and I long program).
I thought breaking down the date by day, month, year, hour and minute, but I still had a doubt.

So, I put the script in my snippets.

Also, "cerise sur le gâteau", the ProgressBar nice. Such, in snippets.
It gives tone to the application.

Mathmathou, thank you again for your help.

JB

Hello Jean

I see two approaches to achieve what you are after, one with a tiny database modifcation, the other not

//---------- WITH DATABASE MOD:

- add a Boolean field called is_last_import to the table (or what you want), with a default value of 1
- after opening the CSV file but before looping through the lines, update the table to set Boolean field to 0
- update TableGrid to filter on is_last_import = 1

THIS WAY :

- on opening the applictaion, the is_last_import = 1 records are shown in the tablegrid
- they are all reset to 0 and the new batch of import is saved with is_last_import = 1 (default value)
- the tablegrid is refreshed and only shows the last imports

//---------- WITHOUT DATABASE MOD

-your tablegrid must be blank with no settings, it will be filled by query AFTER the import
- after opening the CSV file but before looping through the lines, find MAX(id) from you table and store it in a variable
- after saving to database your new records, find the new MAX(id) in the same table
- fill you tablegrid with the standard script query and a filter condition on journal.id > first_max ID AND journal.id <= second_max_id

Only downside of this method is that, on launch of your software, nothing differentiate the records in your table, so I see no way to show just the last record saved, the tablegrid only fills after a CSV import

Hope this helps and maybe you'lle get better answers from the others

Cheers

Mathias

Hello Mathmathou

Excellent idea to set a kind of flag for different files imported.

Thanks for this, I'm testing it

Thanks again
JB