Jump to content

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

Recommended Posts

Posted

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

Posted

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

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