Sign in to follow this  
Followers 0
mbarrett65

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.

-Mo

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 Peter Barfield
      Not sure if this is the relevant area however, I couldn't seem to find a scripting section
      What I would like to do and I have had no success so far is the following scenario.
      I have database which stores references to files in container field located on a folder on a shared computer.
      What I want to do is have a script which when run populates the database with the names of those files located in the folders on the computer and create a new record for those not already present and if they are already present ignore the import.
      I have tried a test script which gets the documents path and loops through each record however I get file unknown when debugging and that is as far as it goes.
      The script in no one handles the above scenario of omitting and inserting only new docs it was just a test to see if it was possible to import via this method. From what I can see the script is asking for a particular filename and if it can't be found it throws the error. That though is no good as essentially the filename is in a sense unknown at the time of import and that is what the purpose of the script would be i.e. too find those files and create a new record with reference only in a container.
      Documentation on this is either non existent or sparse and confusing to say the least (or at least that's how I find it)
      Any enlightenment would be appreciated.
       
    • By BugsyOhar
      Over the past ten years our organization have been using a PO database solution to store all purchasing information. Each year
      the layout would change to illustrate which year it represents. We would like to merge each of these databases into one for better
      searching capabilities. Is there an easy way to accomplish this task while still maintaining data integrity? Thank you!
    • By Bartek
      Hi There,
      First of all many thanks to creators for amaizng plugin.
      What is the syntax for inserting images to excel?
      ScribeDocWriteValue ( “addImage()”; image ; page ; x location ; y location ; height ; width ) 
      Do not work for xlsx with error about invalid cell name (first parameter is function adn for excel it seams it is not recognized) for pdf works fine as in demo expample
      I tried standard syntax for excel where first parameter is table cell and second is image in container but it do not insert the image.
      Any suggestions?
      Thanks in advance.
      Bart
    • By slbr549
      I am using Excel 365 on desktop and FileMaker Pro Advanced 15 with FileMaker Server. 
      I am able to connect to FileMaker from Excel using ODBC to read all records in a table or matching it to a hard coded name. Sample:
      Select work FROM "Student Time Import" WHERE badgename="Patrick Dollar"
      What I'd like to do is add a where clause where it selects hours worked based on the date in the Excel spreadsheet. The cell's date is B12 and so on.  I know my syntax is wrong, but after several attempts, I haven't been able to solve it. Here is my syntax:
      Select work FROM "Student Time Import" WHERE badgename="Patrick Dollar" and date = TimeSHeet(Select * FROM[SHRA Temp Timesheet.Range("B12).Value])
      Thanks.
       
    • By TaiChi56
      I am using FileMaker Pro 12. I wrote a script to look at a field and if the value is less or equal to .70 it will run the report. I have it set to Auto open an EXCEL spreadsheet. When the script runs I see that it finds the records but then my EXCEL spreadsheet is empty. Here is the script:
      Perform Find [Restore] Save Records as Excel["TotalAttendance.xls";Automatically open;Records being browsed] Go to Layout[original layout] Show All Records In the Perform Find [Restore] I have the following coded:
      Find Records PersonnelRecords::PercentDaysAttended:[<_ .70] That is suppose to be less than and equal to. Did not know how to show it with the keyboard.