Erm...

[Replies] [Reply] [View by Thread] [Help]
[Back To Programming]

Delta Gen int16h

Why 'should' it be in PHP? If this is some kind of personal homework or problem you have for work - you should say it is rather than making it look like a challenge (if not, ignore that ;)

On 2008-08-04 19:57:43, Goatrider wrote
>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:

Parsing CSV Data - Gamma Cpt Goatrider 2008-08-04 19:57:43
- RE: Parsing CSV Data - Lambda ViceCinC Enstyne 2008-08-04 21:16:18
  - not that that does what you want, but i had my fun -nt- - Lambda ViceCinC Enstyne 2008-08-04 21:22:17
- Does it need to be a script? - Delta Cpt dopel 2008-08-04 20:35:09
- >Erm... - Delta Gen int16h 2008-08-04 20:04:55 <
  - Heh - Gamma Cpt Goatrider 2008-08-05 11:55:11
    - RE: Heh - Delta Cpt dopel 2008-08-05 15:45:41
    - Its quite easy really - Gamma LtKer MDalby 2008-08-05 13:36:37
      - Missing the point though - Gamma Cpt Goatrider 2008-08-05 13:40:01
        Oh...Urgh! -nt- - Gamma LtKer MDalby 2008-08-05 14:09:30

Guest:
Subject:
Message:	On 2008-08-04 20:04:55, int16h wrote > >Why 'should' it be in PHP? If this is some kind of personal homework or problem you have for work - you should say it is rather than making it look like a challenge (if not, ignore that ;) > > >On 2008-08-04 19:57:43, Goatrider wrote >>Hey all, >> >>Here's a good one for you... >> >>[b]Objective:[/b] >>Ease the process of auditing the number of email addresses per server, across multiple servers. >> >>[b]Data Access:[/b] >>Data is stored in a single, centralized CSV file; containing, amongst other things: the email address, organization ID number, and mail server name. >> >>[b]Real-Life Application:[/b] >>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. >> >>[b]The Question:[/b] >>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 >>
Signature:
Optional Image Link:
http://

CyberArmy::Forum v0.6
Generated In 0.02538 seconds