fbugeja Posted August 13, 2014 Share Posted August 13, 2014 Hi All I am still considering myself a newbie and my query may have been dealt with before. I have a database which has a portal displaying records from a related table. I have exported all the records in this table as an Excel spreadsheet but, as a test on importing records into a clone of my database, I find that the Import Field Mapping dialog box where you match source fields from the Excel spreadsheet with the target fields in the Filemaker database, related tables are greyed out. Does this mean that I cannot import to records from the Excel spreadsheet to the records in the related table in the portal? Frank Link to comment Share on other sites More sharing options...
comment Posted August 13, 2014 Share Posted August 13, 2014 You can only import to one table at a time. Link to comment Share on other sites More sharing options...
fbugeja Posted August 14, 2014 Author Share Posted August 14, 2014 Hi Repeated the trial again, but tried first importing records to the relatd table first. Did not work - related tables still greyed out. So it seems that while you cannot export records from a related table, you cannot import to them. Frank Link to comment Share on other sites More sharing options...
comment Posted August 14, 2014 Share Posted August 14, 2014 You can import into any table - but only one table at a time. If you are doing the import manually, then that table is the table of the current layout (or a new table, if you so choose). If you are scripting the import, then you can select any table as the target table for the import. Link to comment Share on other sites More sharing options...
Sheju Sathyanesan Posted February 5, 2016 Share Posted February 5, 2016 Do you have any example script for this.. please help thank you Link to comment Share on other sites More sharing options...
comment Posted February 5, 2016 Share Posted February 5, 2016 @Sheju Sathyanesan Please don't be a pest.http://fmforums.com/topic/99033-import/ Link to comment Share on other sites More sharing options...
Lee Smith Posted February 5, 2016 Share Posted February 5, 2016 In other words, please don't multiple post your question. Whether you create a new topic or reply to someone else’s it is still multiple posting. Link to comment Share on other sites More sharing options...
Sheju Sathyanesan Posted February 5, 2016 Share Posted February 5, 2016 Sure... will make sure... Thank you Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3001 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