Data Import Wizard XLS file import columns not working with sdimp file.
If I try to import with the current sdimp file that have resaved multiple times I still get columns that won't map properly. I noticed this was an issue in SQL Dev V17 and thought it would be fixed by Version 20.4.1.407.
Any hopes for us to be able to manually fix the sdimp file outside of SQL Dev or another process we could use to make the data align with the table columns?
I have ended up manually updating the Target Table Columns and it works fine.
If I save state and then restore state I get the same errors.
I also get a false positive for Target Table Columns if I use the V17 fix… Note that Date is not mapped to date but no exclamation. Match by position does not work.
By the way,
The sdimp file is accurate. Why would the import process not read it accurately?
<COLUMN>
<TABLE_COL_NAME><![CDATA[WORK_DATE]]></TABLE_COL_NAME>
<SOURCE_COL_NAME><![CDATA[DATE]]></SOURCE_COL_NAME>
<SOURCE_COL_ID><![CDATA[4]]></SOURCE_COL_ID>
<TYPE><![CDATA[DATE]]></TYPE>
<PRECISION><![CDATA[0]]></PRECISION>
<SCALE><![CDATA[0]]></SCALE>
<DEFAULT><![CDATA[]]></DEFAULT>
<FORMAT><![CDATA[MM/DD/YYYY]]></FORMAT>
<COMMENT><![CDATA[]]></COMMENT>
<NULLABLE><![CDATA[false]]></NULLABLE>
<EDITABLE><![CDATA[true]]></EDITABLE>
</COLUMN>
<COLUMN_REFERENCE>
<TABLE_COL_NAME><![CDATA[WORK_DATE]]></TABLE_COL_NAME>
<SOURCE_COL_NAME><![CDATA[DATE]]></SOURCE_COL_NAME>
<SOURCE_COL_ID><![CDATA[4]]></SOURCE_COL_ID>
</COLUMN_REFERENCE>