www.webdeveloper.com
Results 1 to 1 of 1

Thread: Read all files, remove duplicates, Delete

  1. #1
    Join Date
    Mar 2014
    Location
    Corpus Christi, TX
    Posts
    88

    Question Read all files, remove duplicates, Delete

    All,

    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:
    1. Reader ID number
    2. Latitude
    3. Longitude
    4. 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

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles