importing a csv, adding fields, filling in fields from another table...little help.

[showdown]

Hello All,

First off let me provide a bit of background. I have been "duct taping" php for a few years but have never fully wrapped my head around it. I am fairly competent and can manage my way around though I'm no ace. I have been working with PostNuke (Zikula) for years and and also quite familiar with Smarty.

--

So, I have a project that requires the importing of a csv file and populating of a table. The csv file contains two columns (A and 😎 and any number of rows. I need to import this csv file and build a master array for the whole csv file and then in that array I need to build an array for each row in the csv file while also adding several more fields (C, D, E, F) which for the time being will remain empty.

I then need to take this master array and for each sub array I need to fill in the null fields (C, D, E, F) with the contents of another table (T1) matching the records according to field A which will exist in both the sub arrays and the table T1.

Finally, I need to take this master array filled with sub arrays full of data from both the csv and the table T1 and for each sub array create and populate a row in another table (T2)

In my mind I see the steps:
1.) import the csv file and create the master and sub arrays with the contents of the csv file
2.) populate the sub arrays with the contents of T1 according to field A
3.) create rows in T2 for each sub array and save the data

Thing is I really don't know where to start or how exactly to build it and with what functions.

Phew...

That's just the first part of the project... later I'll most likely need some hand holding while I figure out how to create a method for editing/deleting the contents of the rows in T2 in an effective and simple manner... I'd love to use ajax but other than knowing what it is I have almost no experience with it... 🙁

Thanks in advance,
-Julian

[djjjozsi]

it might has a really elastic database table managing program, to recognize your CSV files, making backups to recover the last movements. ( SQL commands to re-set the previous values if its necessary.)

"populate the sub arrays with the contents of T1 according to field A"
lets do it with database tables. and lets think about to handle more than one users.
lets create to-do blocks, to know the next steps...

arrays? you could clean your tables with sql update commands.

hello

[showdown]

Well, I'm a bit lost...

Perhaps I should explain a bit more...

The csv file will have two columns, one containing "name" and the other "number".

It will be uploaded using a form where the user will select 3 variables from a menu; "cat" "race" "year"

I have an existing DB table where every row contains the field "name" and a whole bunch of other data.

I would like to take the contents of the csv file and add to each row the user-selected variables and the data from the DB table where the fields "name" match. And then I'd like to put all that data into a new DB table.

IE:

In the csv:
Joe | 1
Jill |4
Bob |8
Matt |6

In the DB table:
Joe | Man | Tall | Green
Jill |Woman |Tall | Blue
Bob | Man | Fat | Blue
Matt | Man | Tall | Red

So the end result would be:
Joe |1 |Man |Tall |Green |cat |race | year
Jill |4 |Woman| Tall | Blue |cat | race |year
Bob | 8 | Man |Fat | Blue |cat |race |year
Matt | 6 | Man |Tall | Red |cat | race | year

I'm assuming that this will be done with arrays but I don't know where to start...