AnsweredAssumed Answered

import from ESS table to FM table creating empty records

Question asked by sivagurS on Jan 11, 2017
Latest reply on Jan 11, 2017 by user27087

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

Outcomes