Jump to content

Import XLSX to Child Table


John Kostenbader
 Share

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

Recommended Posts

It has been covered here but I really can't find a sufficient answer. When I do an automated import of an xlsx file that has no blank lines at the top into a portal that is part of a child relationship I keep getting blank lines. I've confirmed that there are no blank rows in the excel spreadsheet. For the particular import I'm talking about i get one blank line at the top (portal is not sorted in any way). I also get two blank lines at the bottom. I can almost understand the blank lines at the bottom (how does FM know when to stop?) but I cannot wrap my head around why I have one at the beginning

Link to comment
Share on other sites

It's true that there is no blank row at the top of the worksheet - but the first row has data only in the first column. In fact, any row that has data in the first column has no data in the other columns - so if you're importing only the second and the third column, you will get a blank record for every such row (there are 28 of these in the provided example).

In addition, the worksheet has a named range "_xlnm.Print_Area_1" defined as B1:C241. I suspect this causes Filemaker to import the top 241 rows, regardless of whether they contain data or not. This would account for the last two blank records.

Two ways to solve this:

  1. Have your importing script find the empty records and delete them;
  2. Validate one of the target fields as Not empty, Validate always. This will cause rows that do not meet the validation to be skipped during import.

 

Edited by comment
Link to comment
Share on other sites

This topic is 2376 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
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.