Behavior:
When attempting to map a field to your DocuWare Date field in Autoindex, you are unable to see your data source date column available.
Solution:
This is due to the data source date column not being of type "Date". If your Autoindex job is using a Database Connection, go to the source database table and make sure that the column field type is "Date".
If your Autoindex job is using a File Connection, please to do the following:
- Go into your File Connection in the DocuWare Administration Tool.
- Find your Date column. By default, this is set to Type "Text", which is why is it unable to be selected as the data assignment in your Autoindex job.
- You'll need to use the drop down to change the Type from "Text" to "Date" and then adjust the Date and time format accordingly with the ellipsis.
- Click Apply to save your changes.
- Refresh your Autoindex job, and the data source Date field should be available for data assignment.
KBA applicable for both Cloud and On-premise Organizations.