Jump to content

FMP 11 Client-Side Excel .csv Import Problem


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

Recommended Posts

Filemaker Pro 11 is running on two Windows 10 computers connected as Host and Client over a network.

The script to import data from an Excel .csv file utilizes the following script step options:
    1. Un-Checked - Specify data source - File
    2. Check - Specify import order, Import Action
        a. Select - Update existing records in found set
        b. Check - Don't import first record (contains field names)
    3. Check - Perform without dialog

When the Import script is run from the Host computer, and the desired .csv file is manually selected, the Excel first row field names are not imported and the second row with the data is imported as expected. (See Host Import Mapping)

When the same script is run from the Client computer, the Excel first row field names are imported and not the second row data.  To get the proper result, I have to leave the check box for "Perform without dialog" unchecked and then manually, from the "Import Action" group, check the box for "Don't import first record (contains field names)" to get the proper data imported. (See Client Import Mapping, check box is no longer checked)

Is this caused by a defect in FMP 11?  I can't figure out why this is happening.

Host Import Mapping.png

Client Import Mapping.png

Link to comment
Share on other sites

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