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 because the data source date column is not of type Date. If your Autoindex job is using a Database Connection, navigate to the source database table and ensure the column field type is Date.
If your Autoindex job is using a File Connection, please do the following:
- Go into your File Connection using the DocuWare Administration Tool.
- Find your Date column. By default, it is set to type Text, which is why it cannot be selected as the data assignment in your Autoindex job.
- You'll need to use the dropdown 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 is applicable for both Cloud and On-premise Organizations.