This content has been marked as final. Show 4 replies
make sure your source file header following FDM standatrd format.
make sure import format conditions are applying to your source file. your source file data have some out range values to your import format condition.
All my import formats is the same as my source file.
When i move my source to txt file, it works perfectly.
But when i'm using excel, i encounter that error...
I try using name in excel with prefix ups and it returned another error like this...
"Detail: GL Account is a required field!"
This is the log...
Processing Excel File Start... [2010-03-04-10:48:20]
Processing [UpCheck Function] Start... [2010-03-04-10:48:20]
[UpCheck Function] Does not exist!
Begin SQL Insert Load Process (1): [2010-03-04-10:48:20]
Processing Complete... [2010-03-04-10:48:20]
Edited by: user649207 on Mar 3, 2010 7:48 PM
FDM imports excel files by using a named range that begins with "UPS" (which stands for Upstream)
The first cell in the named range is the table into which data will be imported. The next rows is the fields of the table and row 3-n are the data records.
I would strongly discourage you from importing data directly from excel unless you are using the journal functionality of FDM. FDM's workflow process optimizes the data import process using a temp table. If you were to write data directly to the table, you would be bypassing this key application functionality.
Thanks for your explanation.
So, for best practice, it's better not to load from Excel directly unless i'm using its Journal and Trial Balance function right?