"... you mean these fans?" Posted October 19, 2017 Share Posted October 19, 2017 Hi, For some reason, I can import all 16,153 record except for the 1st record Looking back into the import step, the check box to "not import first record" is grayed and the check box is not checked. Any ideas ?? Any help I would be grateful. Link to comment Share on other sites More sharing options...
"... you mean these fans?" Posted October 23, 2017 Author Share Posted October 23, 2017 Any suggestions Link to comment Share on other sites More sharing options...
bcooney Posted October 23, 2017 Share Posted October 23, 2017 Not sure why it's grey, but you don't need to export to import from table to table. However, I question why you're duplicating data. Link to comment Share on other sites More sharing options...
"... you mean these fans?" Posted October 23, 2017 Author Share Posted October 23, 2017 (edited) Hi Bcooney and thank you, It is a request from a client who wants to import then filter a large number of records down to a few. The test file only has approx 1/10th the records to use for development. The client has several filters or "Found Sets" he is asking for. The client states that as the records are filtered through each filter, the records that do not meet that filters criteria I'm to delete them. The client wants to "Retain" each filter for historical look ups. I thought to pushed each filter to a new table. So I built a second table for testing and I noticed that the 1st record never imported ?? Strange ?? Every attempt I tried has not worked. I know that the 1st record is usually "Field Names" when importing a file and I have that "Option" in FileMaker whether or not to "Not Import" the 1st record ... however, since I am exporting / importing to a know table with know fields apparently FileMaker is aware of this and keeps the check box "Unchecked" and greyed out ( Do Not Import 1st record ) ... makes sense, the 1st record in my case contains "DATA" not "Field" names, so the 1st record should export then import. My guess it is not exporting ... and if you could test for that, I am not sure how to correct it ? Anyway, I am just trying to understand why the 1st record does not import ... I have no idea why Edited October 23, 2017 by Mr. Ignoramus Link to comment Share on other sites More sharing options...
bcooney Posted October 23, 2017 Share Posted October 23, 2017 Couldn't you mark the records and then omit them? Anyway, you do not need to export to copy records to another table. https://community.filemaker.com/thread/66865 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 2391 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