1 Reply Latest reply on Jan 11, 2017 6:17 PM by user27087

    import from ESS table to FM table creating empty records

    sivagurS

      Hi

       

      I have an ESS view in my FM Database say vw_ESS.

      I have a Local FM table with the same table structure as this ESS view, say FM_Table.

       

      I need to update FM_Table with vw_ESS records in a timely fashion, say ONTimer script.

      While importing from vw_ESS to FM_Table, instead of creating a few records it creates empty records.

      The data is huge, over 11000 records, so its hard to follow which records are missing etc

       

      While Importing it doesn't give any errors, so I have no idea whats happening.

       

      Any help is appreciated

       

      Thank You

      Seetha

        • 1. Re: import from ESS table to FM table creating empty records
          user27087

          Any chance we can see a snippet of your SQL code? I assume you are using the Import ODBC data source option.

           

          We import over 100,000 records each morning (and have had no problem with an import of 2.9 million) and all without blank records. I think either your originating data has blanks or more likely your SQL allows for related rows that do not have data in the columns you are requesting.