[Resolved] Import Problem

[cbrknight]

K have another brain twister... let me see if I can explain the problem....

I am importing customers into a database via a csv file. Some of the customers are trial customers and some are full customers...

The trial customers come from different departments in the company.. these depts are stored in the csv file as room#'s...

I need to be able to only import the customers in certain rooms...
the rub is that the number of rooms always change and I could be using from one to 100 different room numbers..

I figure if I put the room numbers into an array and then loop through the array running the import once for every different room number. Will this work? is there an easier way?

also how do I get the user imput of all the different rooms needed to import from the csv file? Since the numbers change I cant use any static form elements... and I dont know how many rooms it will be... I am thinking of a text field and then explode the text field results with a blank space or comma to separate the room numbers... Can I do this?

[nemonoman]

Here's how I understand the problem:

You have an import file that contains a set of records. The set includes some records that you want to keep and some you don't want to keep.

You know in advance the identiites of the records you don't want to keep.

Example you have records for rooms 1-100 but don't want to keep rooms 19, 23, 88.

If I were doing this I would import the WHOLE file. This is very fast. Then I would delete the records I don't want. This also is very fast. ("DELETE FROM myTable WHERE roomnumber IN (19,23,88)").

Beats having to do
csv>array>fix the array> csv>file>import fixed csv