Importing a csv file into a Filemaker Portal

[Nu2FM]

Hello,

I am new and I am hoping that someone will respond to my question with steps I can follow:

My Excel csv file is setup as follows:

Date,Player,Game1,Score1,Game2,Score2,Game3,Score3

23/2/07,Bob,TPlanet,345,Rcar,232,Fjet,135

23/2/07,Kim,Gwar,239,Fboat,330,Fjet,238

.

.

How can I import each row to a record that has a portal similar to how the Games and Scores are shown below?

Record1

Date 23/2/07 Player Bob Total Points 712

TPlanet 345

Rcar 232

Fjet 135

Record2 (you get the idea...)

I have been playing with portals from examples and they work quite nicely but I need to transfer all my data in FM first.

Any suggestions or even a piece of sample code that actually would import my records for just the small sample above would be helpful.

thanks.

[Nu2FM]

I see my question has a lot of views but no replies? Does this mean it cannot be done or am I not phasing my question properly?

[mr_vodka]

Maybe it would help for you to give some further details.

[comment]

I think you need to perform a series of imports. The first import would be to a Players table*, and it would import the Date and Player columns only.

The second import would be to a Games table, and it would import these columns: Date, Player, Game1, Score1.

The third import would import to the same table (and to the same target fields) Date, Player, Game2, Score2.

The fourth import (again to the same table/fields) Date, Player, Game3, Score3.

Then you can define the relationship as:

Players::Date = Games::Date

AND

Players::Player = Games::Player

and define a calculation field in Players as =

Sum ( Games::Score )

to get the total points for each player/date record.

---

(*) The name Players is not a very good choice for this table, but I couldn't come up with a better one.

[Nu2FM]

Thank you so much for the outline... this also gives me another idea on structuring the future for how to move forward once all the data has been ported.

To some it may seem obvious but to a beginner it's the simple things that help.

thanks again.