Question:
How can I avoid using file connections in Autoindex and use an auxiliary file cabinet instead?
How can I avoid using file connections in Autoindex and use an auxiliary file cabinet instead?
Answer:
This example is valid for on-premises as well as for cloud
A sample semicolon-separated file is used for this example:
barcode;name;price;date
10001;Apple;1.10;01/15/2020
10002;Orange;2.20;01/16/2020
10003;Melon;3.30;01/17/2020
10004;Avocado;4.40;01/18/2020
![](https://dwsupport.blob.core.windows.net/kba/9ae24334-7423-4df5-b45c-8ae542cf4802.png)
3. Create a scheduled Autoindex to transfer the file data into the newly created File Cabinet:
Note: It is also possible to adapt this initial Autoindex to update the File Cabinet with new data, but this is not in the scope of this how to.
4. Save and Run
![](https://dwsupport.blob.core.windows.net/kba/3ff798e9-b60d-4318-9d81-8d635f5579c8.png)
Verify the execution and check the number of updated records.
Note: Identical rows from the text file will be imported only once.
5. Open the Web Client and verify the imported data
![](https://dwsupport.blob.core.windows.net/kba/828c0139-39d8-4f65-8ada-faad28c4d8d0.png)
6. If all is good, you can delete the scheduled Autoindex if not needed anymore.
![](https://dwsupport.blob.core.windows.net/kba/f2d44a05-9efa-474a-a1b1-d80f5766892b.png)
Select the File Cabinet database.
Chose “file cabinet database” and press “Configure data source“
![](https://dwsupport.blob.core.windows.net/kba/f9aef0da-1ac8-4a2a-8fb9-3d0f0c42ea70.png)
Select the File Cabinet
![](https://dwsupport.blob.core.windows.net/kba/40904fcd-799a-43e3-9c9c-cf94b70c5168.png)
Continue setting up the Auto Index to your needs.
barcode;name;price;date
10001;Apple;1.10;01/15/2020
10002;Orange;2.20;01/16/2020
10003;Melon;3.30;01/17/2020
10004;Avocado;4.40;01/18/2020
1. Create a file connection and use a CSV or text file with separators, use the column identification to make sure the file is usable and correct:
![](https://dwsupport.blob.core.windows.net/kba/9ae24334-7423-4df5-b45c-8ae542cf4802.png)
3. Create a scheduled Autoindex to transfer the file data into the newly created File Cabinet:
![](https://dwsupport.blob.core.windows.net/kba/8d1351b1-094e-43b4-b257-089680201a31.png)
- Choose the newly created File Cabinet.
- Select option Scheduled
- Select Schedule - Never (Since we only need to run it once)
![](https://dwsupport.blob.core.windows.net/kba/97709693-6cfc-4c1d-8756-8ad04ec69426.png)
- Choose the file connection
- Add all desired fields as match codes
- Base the Auto Index on the data source
- Chose the option to Add new data records to the File Cabinet
Note: It is also possible to adapt this initial Autoindex to update the File Cabinet with new data, but this is not in the scope of this how to.
4. Save and Run
![](https://dwsupport.blob.core.windows.net/kba/3ff798e9-b60d-4318-9d81-8d635f5579c8.png)
Verify the execution and check the number of updated records.
Note: Identical rows from the text file will be imported only once.
5. Open the Web Client and verify the imported data
![](https://dwsupport.blob.core.windows.net/kba/828c0139-39d8-4f65-8ada-faad28c4d8d0.png)
6. If all is good, you can delete the scheduled Autoindex if not needed anymore.
Connect any Auto Index to the newly populated File Cabinet.
Plan A - Connect to the File Cabinet Database (preferred solution)
Chose “external database” and select “Configure data source“![](https://dwsupport.blob.core.windows.net/kba/f2d44a05-9efa-474a-a1b1-d80f5766892b.png)
Select the File Cabinet database.
![](https://dwsupport.blob.core.windows.net/kba/0ddee9f0-cdb5-40f6-8328-3681be94b1c3.png)
- Choose the content server connection
- Choose Table
- Find and select the File Cabinet containing the data
- Verify the correct data.
- Click OK
Plan B - Connect to the File Cabinet (optional solution)
Note: Choose this only if connecting to the file cabinet is not possible.Chose “file cabinet database” and press “Configure data source“
![](https://dwsupport.blob.core.windows.net/kba/f9aef0da-1ac8-4a2a-8fb9-3d0f0c42ea70.png)
Select the File Cabinet
![](https://dwsupport.blob.core.windows.net/kba/40904fcd-799a-43e3-9c9c-cf94b70c5168.png)
Continue setting up the Auto Index to your needs.