Hello,
I have an issue when trying to use the import option when in list view. I go through the process to export the records I want and have it create a template that I will edit. One of the fields is a choice list and of type integer with a length of 40. In the Excel export the cells contain the Labels of the fields and not the numerical value and you cannot change that as it creates a drop down in the cells so you choose the correct available options. But what seems to happen is during the import if one of the field's labels is greater than 40 it will truncate anything > 40 as it goes into the import table. Then when it moves it to the actual table it will store it as the truncated value rather than matching it to the correct choice and storing as a numerical value. It makes sense that it does this, but I would have thought the import feature would be aware of these situations and handle it. I was able to edit the import table once it was created, go back and re-load but it seems this should work correctly without any modifications. Anyone else run into this?
