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.

clk

I don't know about your system background, so this may be a no go, but
just in case:

Pivot tables are database functions and, as you just have experienced,
handling data with the spreadsheet software has its limitations.

I'd try to take Excel out of the game and import the data of your system
directly into a Filemaker table. Whatever you accomplished with the
Excel pivot table can be done with Filemaker.

Further, I'd try to reduce the number of fields and rather have more
relations and records.
--
http://clk.ch