Parsing CSV Data |
||
  Gamma Cpt Goatrider Hey all, Here's a good one for you... Objective: Ease the process of auditing the number of email addresses per server, across multiple servers. Data Access: Data is stored in a single, centralized CSV file; containing, amongst other things: the email address, organization ID number, and mail server name. Real-Life Application: A proprietary spam filter interface allows customers to add users to the spam filter proxy server for their mail server. There is no restriction on how many users the customer can set up, but they have all signed contracts stating they are only allowed to have a certain number of users, and overage charges will apply if they go over their quota. Keeping that in mind, a sales person wants to check how many users each customer has set up for spam filtering, to ensure they're not over their contracted amount, but to do so, they will need to go through each individual customer's page and write it all down. Luckily, the admin console allows for a system-wide dump of user information, including (amongst other things) the email address, organization ID number, and mail server name. This data dump comes in the form of a CSV file, with each row representing a single user. The Question: How does one allow the salesperson, with no technical knowledge, to take that CSV file, upload it to a script, and have that script parse the file for the number of users per server? This should be done using PHP, and if would be GREAT if it could be done using SQL statements to look through the CSV file, though I'm not sure any such mechanism exists. More info can be provided, just let me know what you want. --goat Replies:
|
||
| CyberArmy::Forum v0.6 Generated In 0.01827 seconds |
2008-08-04 21:16:18
2008-08-04 20:04:55
2008-08-05 13:36:37