Jump to content

Importing Xcel File for 1 Record


This topic is 5999 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I'm trying to import a xcel file which has 5 cell info and would like those info to be imported into 1 record rather than 5 separate differen record on filemaker? Each field does have the repititation from 1 to 15 lines. So what I was hoping for is to have all 5 cell info import within the field since i have 15 available lines.

any suggestion..

Link to comment
Share on other sites

You need to change the format of the excel document so that your data is listed across instead of down.

Filemaker imports each row as a record and each column is a "field".

This is the only way you will get your import to work properly.

Link to comment
Share on other sites

In order to get your data to import into a field with multiple repetitions, you will probably have to create an intermediary FMP table to handle the import and manipulation of the data before it is then imported into the final table. This will make sure that your data is optimized the way you like it and you will not be storing unnecessary fields of data in your final table which only existed to convert the imported data.

For the intermediary import table you should create a calculation field that has repetitions. This calculation field can be set so that each of the repetitions contains the proper data from each of the 5 fields.

Link to comment
Share on other sites

I've found the easiest method for imports like this is to first suck the data into a temporary table, then process it, then move it into the main table.

Link to comment
Share on other sites

If you are using FMP 8 you can create new tables within the same file by going to define fields and clicking on the tables tab.

It is similar to creating additional spreadsheets within the same excel workbook document.

Rather than go into extreme detail, I will provide you with a demo file. To use it, simply import your excel data into it with each of the excel columns matching up to each of the file maker fields labeled f1 thru f5.

Then just run the script in the scripts menu to move the data from these separate fields into the single field that has 5 repetitions.

Finally import the data from this field with the repetitions into your filemaker file.

ImportTest.zip

Link to comment
Share on other sites

Hello Brian,

Thank you for your filemaker test but it still indicate 5 records see my attached xcel file i would like all the info on the excel file except for the first row which is my header to be imported as 1 record instead of 5 separate record. I also attached the importtest.fp file whic show the 5 records when i import.

TaskTime_Data_Export.xls.zip

ImportTest.fp7.zip

Edited by Guest
Link to comment
Share on other sites

  • 3 months later...

I think the answer lies in [color:orange]Brian C first reply. In other words, you need to change the data in Excel. There is a Function in Excel called Transpose, that changes the data from horizontal to vertical, and vice versa.

There has been some Threads in the past about this, here is one to to start with. Link

Pay attention to [color:orange]comment's replies.

HTH

Lee

p.s.

It's either that, or use a text editor like BBEdit (TextWrangler), and remove the returns and replace them with tabs.

[color:blue]Without seeing an actual sample of the text, it is not possible to supply much help.

Edited by Guest
Link to comment
Share on other sites

  • 2 months later...

Hello,

The sample was upload on 03/13/07.

The transpose also did not work.

What I am looking for is to have those 4 rows(jpg sample) exactly how it look like ton the jpg sample to be import into 1 record only instead of creating 4 different records.

Picture_1.jpg

Edited by Guest
Link to comment
Share on other sites

This topic is 5999 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.