Hi there,
I need to import a csv set everyday with a list of employees leave and absence date ranges (about 4000 records). I have managed to create a bot to import the csv to the table but every import i make, the table adds all the records to the previous day (so, the second day i have 8000 rows in the table). Then i need to check it there was any change in this set comparing with the actual set (previous day).
My concerns are.
1) Is it right to keep adding records to a table considering the row limit of 384,615 rows that would equal to only 96 days of importing data, not to mention the other existing tables in the app.
2) How to properly track changes (adds, deletions and changes) in the rows of each daily csv import?
my table have this headers:
<td>Name</td>
<td>Register#</td>
<td>Absence Reason</td>
<td>Status</td>
<td>Begin Date</td>
<td>End Date</td>
Thanks in advance.
LinkedIn
Twitter
