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

    • 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.
    • Help with XML stylesheet?
      By TLIEB
      I have been given the task of trying to import our postal information which we receive as XML files into Filemaker. I've been searching the forums for the last few days and I've found several examples which I've tried to build off, but I'm still not doing something right. We have no experience working with XML files so I can't quite figure out where I'm going wrong.
      When I try to import my XML file into Filemaker using the stylesheet I created, It looks like all the fields are mapping right, but I don't get data in any of the fields. I get the following pop up message:

       
      This is the stylesheet I have built so far, the sample XML data we were provided is attached. Can anyone point me in the right direction as far as what my problem is and what I need to fix? As an aside, I know I have the CustomerReferenceID field importing twice. Given the sample data we received we're not quite sure which fields we will actually need to import so I'm using one of those entries as a placeholder.
      <?xml version="1.0" encoding="UTF-8"?>
      <xsl:stylesheet version="1.0"
      xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
      <xsl:output method="xml" version="1.0" encoding="utf-8" indent="yes"/>
      <xsl:template match="/">
      <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult">
        <ERRORCODE>0</ERRORCODE>
        <PRODUCT BUILD="" NAME="" VERSION=""/>
        <DATABASE DATEFORMAT="" LAYOUT="" NAME="" RECORDS="" TIMEFORMAT=""/>
       
        <!-- DEFINE FIELDS -->
        <METADATA>
         <FIELD NAME="Mail Date" TYPE="TEXT" EMPTYOK="YES" MAXREPEAT=""/>
         <FIELD NAME="Customer Reference ID" TYPE="TEXT" EMPTYOK="YES" MAXREPEAT=""/>
         <FIELD NAME="Job Description" TYPE="TEXT" EMPTYOK="YES" MAXREPEAT=""/>
         <FIELD NAME="Permit" TYPE="TEXT" EMPTYOK="YES" MAXREPEAT=""/>
         <FIELD NAME="Total Postage" TYPE="NUMBER" EMPTYOK="YES" MAXREPEAT=""/>
         <FIELD NAME="Postage Affixed" TYPE="NUMBER" EMPTYOK="YES" MAXREPEAT=""/>
         <FIELD NAME="Net Postage" TYPE="NUMBER" EMPTYOK="YES" MAXREPEAT=""/>
         <FIELD NAME="Quantity" TYPE="NUMBER" EMPTYOK="YES" MAXREPEAT=""/>
         <FIELD NAME="Affixed Amount" TYPE="NUMBER" EMPTYOK="YES" MAXREPEAT=""/>
         <FIELD NAME="Metered-Stamped" TYPE="NUMBER" EMPTYOK="YES" MAXREPEAT=""/>
        </METADATA>
       
        <!-- IMPORT DATA -->
        <RESULTSET FOUND="">
         <xsl:for-each select="PostageStatement">
          <ROW MODID="" RECORDID="">
           <COL><DATA><xsl:value-of select="ClosingDate"/></DATA></COL>
           <COL><DATA><xsl:value-of select="CustomerReferenceID"/></DATA></COL>
           <COL><DATA><xsl:value-of select="CustomerReferenceID"/></DATA></COL>
           <COL><DATA><xsl:value-of select="PermitNumber"/></DATA></COL>
           <COL><DATA><xsl:value-of select="TotalUSPSAdjustedPostage"/></DATA></COL>
           <COL><DATA><xsl:value-of select="PostageAffixed"/></DATA></COL>
           <COL><DATA><xsl:value-of select="NetPostageDue"/></DATA></COL>
           <COL><DATA><xsl:value-of select="TransactionAmount"/></DATA></COL>
           <COL><DATA><xsl:value-of select="RatePostageAffixed"/></DATA></COL>
           <COL><DATA><xsl:value-of select="PermitType"/></DATA></COL>
          </ROW>
         </xsl:for-each>
        </RESULTSET>
      </FMPXMLRESULT>
      </xsl:template>
      </xsl:stylesheet>
      xml.zip