Read all files, remove duplicates, Delete
I am working a project involving GPS and RFID. My device will upload CSV files to my server that will contain the following - in this order:
- Reader ID number
- 150 ID numbers
The csv files will be named as 'readerid.csv'. Example (1001.csv, 1002.csv...).
Some of the ID numbers will be duplicates and will need to be either ignored, or removed, before importing into a MySQL database.
After importing, I will need the file to be deleted off the server.
I will most likely need to make this a cron job as there will be no user interface. Currently, I only have one reader (1001) that I am working on, but expect to have 200+ at full-scale.
I can handle the importing into MySQL, I am just not sure how to go about reading each file, and removing/ignoring the duplicate entries, or deleting a file.
I appreciate your help in advance.
Last edited by TW79; 08-20-2014 at 04:48 AM.
Reason: Left out info
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread