This content has been marked as final. Show 3 replies
The header row shouldn't make any different truely. FDM imports based on if an 'amount' is present in that line/field where you told it to be.
How is it not importing correctly?
I was thinking the same thing. The header ought to be metadata. FDM should be able to import but when a header row is present in the import file the import halts with Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 45 (Amount) and several Data access errors. When I delete the first row in the file, save the file as .csv and hit import it works with no errors. As far as I can tell it even parses the file correctly using an SQL table for parsing special accounts. The import script has been written by a consultant who, as far as I know, could not get it to work properly at the time. I am trying to fully understand the script but my vb and sql skills are somewhat limited.
Make sure that the file you are importing is also saved in unicode code. This combined with the unicode configuration setting should make the file importable. If you post a copy of the file and script, you may get more assistance