Jump to content

Import of data fields


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

Recommended Posts

I'm in the process of creating an application containing 5000+ fields. Basically there are 1000 fields that have 5 variations each. Does anyone know of a way to import fields into Filemaker from an external source? I'm currently using version 5.0.

thnx

Arny

Link to comment
Share on other sites

It sounds to me like you have a text file?

1000 records?

5 fields per record?

If this is correct, make sure that there is a return between each of the 1000 records

Make sure that the fields appear in the same order in each record and that there is a tab between fields.

Field 1 (tab) Field 2 (tab) Field 3 (tab) Field 4 (tab) Field 5 (return)

Field 1 (tab) Field 2 (tab) Field 3 (tab) Field 4 (tab) Field 5 (return)

Field 1 (tab) Field 2 (tab) Field 3 (tab) Field 4 (tab) Field 5 (return)

Field 1 (tab) Field 2 (tab) Field 3 (tab) Field 4 (tab) Field 5

The (tab) & (return) are tabs and returns from the text editor. Make sure that there isn't a return before the first record nor one after the last record.

In the Import menu, changing type file to "Tab-Separated Text File" and do your import.

If I missed read this, either attach a sample of the data for us to see, or go into more detail about it. I prefer the former to the later.

HTH

Lee

Link to comment
Share on other sites

This topic is 7561 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.