Sign in to follow this  
Followers 0

importing from excel; match field required for new record

2 posts in this topic

I'm setting up an excel file for import to "update matching records in found set" records and selected the option to "add remaining data as new records." My match field is the sys_id. What I"m finding is filemaker won't add the remaining data as new records unless there's a value in the sys_id match field. Normally, that field is set to auto-enter a serial number in sequence. I would prefer not to create a sys_id value in the excel in case someone has created the same one from within filemaker.

Any reason Filemaker is requiring data in the match field to create a new record with the remaining data?

Thanks for any help and advice.


Share this post

Link to post
Share on other sites

If I understand this correctly, you should create a calculation field = sys_id and use it as the match field. Then your new records can have any arbitrary value in their sys_id cell. Make sure to apply auto-enters during the import.

I am assuming here that the existing records do have a sys_id value and that it is the correct one - otherwise your question makes no sense.

Share this post

Link to post
Share on other sites

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
Sign in to follow this  
Followers 0

  • Similar Content

    • PSOS Import Records is failing
      By thomas.brinch
      I have a problem with server side import of records. I have a simple script which just does an import of a textile (with tab delimiters):
      Set Variable [$FileList; Value: "filewin://server/folder/1795739.txt"]
      Go to Layout ["files" (files)]
      Import Records [No dialog; "$FileList"; Add; UTF-8]
      When I run it client side, everything is fine. When I run it server side with Perform Script on Server I'm getting an error:
      The previous script step, "Perform Script on Server", could not be completed because of an error....
      If I run Get ( LastError), I get error code 100 (File is missing)
      I have tried many different file locations for the textile. Network path, Local path (on the FM server) and Relative path (from where the database is placed on FM server).
      I have tried placing the file in the FM server Databases and Documents folder AND the User Documents folder:
      filewin:/C:/Program Files/FileMaker/FileMaker Server/Data/Documents/1795739.txt
      filewin:/C:/Program Files/FileMaker/FileMaker Server/Data/Databases/1795739.txt
      Every time I get error 100. What am I doing wrong??
      FileMaker server is v14 on Windows Server 2008 and the client is running on Windows 7.

    • Exporting large summary file to Excel taking long time
      By Neil_Million
      I've got multiple Filemake databases with 4m+ records each. I've created a layout which calculates a summary using a sort, Groups and Counts. This takes 10-15 seconds, which is OK.
      However, when I try to export this summary report to Excel it appears that Filemaker has to recalculate all the Groups & Counts, but for some reason this takes several hours. The last report took over 4 hours.
      I can't figure out how I can simply export or copy the summary report that Filemaker creates for the Layout?
      Please can someone provide assistance because I have another 20 similar reports to do and this will take me days instead of hours
    • Import pdf and word documents from folders
      By shevyshevy
      I have been able to use the Import script step to import pictures from a folder. However, doing the same for bunch of pdf and word document files have not been a success. Is there any special trick to achieve this?
    • Move Records to a new Table
      By shevyshevy
      I have two tables Temporary and Real, the procedure is that contacts are created on the temporary table, probably by the contacts themselves. then once they have been confirmed as Clients (ie after their details have been verified by our staff), I would want to move them from the Temporary table to the Real table.  Please how can I achieve this?
    • Import records from table to table not behaving as expected.
      By gerg nnud
      I am trying to copy selected line item records from one table to another as part of an intended 'recurring transactions' structure. For some reason if I perform a find on line items for that transaction and attempt to import into the recurring line items table it wants to import all records (12000) and not the found set (1-20) as I would expect. 
      I have just conducted some tests with other databases to confirm I have an issue with this database only. The test databases would only import the found set from table to table as expected. Is my db corrupt or is there some setting somewhere thats changes this behaviour? Any help would be appreciated. FM13.