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

    • By jax
      Hi FMers,
      I'm trying to get multiple choice quiz questions into a FileMaker database. The information is in a plain text file. Question and options are simply separated by returns:
      Where in the cell is the genome located?
      Mostly in the cytosol.
      Mostly in the mitochondria.
      [X] Mostly in the nucleus.
      Stored in the membrane.
      Stored in RNA.
      Next question...
      Each question has 5 options, one of which is correct [X]. There's an empty line between questions.
      What's a good approach to get this into a FileMaker database with separate fields for the questions, the options, and the correct solution?
      All the best
    • By H
      Hi i created a certificate and want that when it is clicked to save it it gets created into a pdf and then imported into the cetification container field , however for some reason i am recieving some error  in my script  , the pdf does not save at all. 
      see script below:
      i would appreciate if someone could tell me where i went wrong why my pdf is not saving and if this is the method to save the pdf to a container
    • By shevyshevy
      I have come across this technique severally on this forum, but I can't figure out how this really works. Right now I am faced with a situation that requires similar technique and I can't seem to get it work.
      I have Table A and Table B.
      1. I want to script an import Process that will first export all records in Table A into Table B (kinda A Clone Copy of Table A) Thats just my basic objective
      2. Then from there, I would want to be able to do similar Process but this time, I will only update the records in Table B with that of Table A using a match field.
      3. I will also love to perform the process based on a found count. ie after performing a find of specific records
      I think If I can be guided on achieving NO. 1, then I can similarly script the others..
    • By Walter-MainFrame
      We have a database in Go 14 and users  need to Import records from Filemaker Server 14, to Filemaker Go.
      And it runs very good with all Users that have:
      Ipad Air 2 and Ipad Pro  
      Import time: 8 to 9  Minutes
      But all the users that have:
      Ipad 3rd and Ipad 4rd Generation 
      Import time: + 1Hour
      Both using the same wireless,
      Is there any way I can identify in a script what Ipad Model the user has ?
      Best Regards
    • 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.