Arny Posted October 31, 2003 Posted October 31, 2003 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
Lee Smith Posted October 31, 2003 Posted October 31, 2003 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
Arny Posted October 31, 2003 Author Posted October 31, 2003 Thanks . . . sounds like a solution that just may do what I need. Arny
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now