When we copy the data from one environment to another, the displaying of the file mapping is gone. If I look in the IMPORTFILETEMPLATE table, the file mapping still exists in the DETAILCOLUMNMAP field and the import file mapping template can be used without re-mapping anything. But, it is not displayed in the import file mapping data form in the CRM. If the file mapping needs to be changed at all, then the import file mapping must be totally re-mapped.
Why doesn't the file mapping display in the import file mapping data form at all? Trying to come up with a way to be able to move the file mapping, seamlessly, between environments. Currently, the only way that we have found to do this is '…to grab the DETAILCOLUMNMAP column first, then load the template through the front end (along with the import file used to do the file mapping), don't map anything, then in sql update the IMPORTFILETEMPLATE with the column map.' Trying to find an easier way to do this…if there is one.
Thanks,
Matt