diego b

Hi Guys,

I have the following problem : I am going to define a clinical research
involving echocardiography. For each patient i have to measure
something like 150 parameters, and every parameter include three
values. I can store all the measurments using the proprietary software
related with the machine and then I can export the data in an excel
worksheet. This worksheet includes many parameters but I am interested
in three columns : Parameter name, VaLue Number and Value(the numbers).
Using the macros and Pivot Tables, I was able to organize the data in
the excel file so that now I have something like this :


Parameter 1 Parameter 2 Parameter 3
Value Value Value

That's fine, because in this way I can import all the values inside a
filemaker table prepared by myself.
Unfortunately, since in the new layout, the number of columns is more
than 255 (the maximum allowed by Excel) I had to split the first
worksheet into two different worksheets. Therefore, now I have : Def.
Data 1 (first worksheet) and Def Data 2 (Second Worksheet).
I was able to import successfully the two worksheets inside my
filemaker table but I have a great problem :
At first I defined the relations between the cells in excel and the
filemaker fields (in the import window something like

Parameter 1(excel) --> Parameter 1(Filemaker)

and so on for all the parameters (believe me, it was very tough)

Then, after I have imported the first worksheet (Def. Data 1) I did the
same for worksheet 2, and everything worked quite well.
The problem is that when I have tried to do the same work with the
second patient importing data from excel to filemaker using the first
worksheet I have noticed that the relations defined by myself was
disappeared . It took almost two hours to define those so it is
impossible to repeat the work for every patient.
Does it exist a way to "save" the relations I define when I import from
a specific cell in excel to a specific field in Filemaker ?
I spent few days on this problem and I would not like to abandon the
ship now.

Thank you for every help or idea.