Dear support,
We would like to read the file from the file server by using the file adapter. Here is the steps of my development.
1. Install the DPAgent tool to the side of the file server and registered the agent for file server.
2. Create the data file (MyData.txt) and config file (MyData.txt.cfg)in the side of file server as the following
eg. C:\DemoFileServer\SDI\data
C:\DemoFileServer\SDI\conf
3. The file adapter is created on my local pc and access to read file server.
Result: The connection test is successful. But the data file table (MyData.txt) cannot be seen in the adapter folder.
Instead of it, the config file table (MyData.txt.cfg) is provided by the adapter.
Although the root directory path and file format definition path are correct, what wrong with it?
Here is the content of file format.
FORMAT=CSV TEXT_QUOTES=" TEXT_QUOTES_ESCAPE_CHAR=" ESCAPE_CHAR=\ QUOTED_TEXT_CONTAIN_ROW_DELIMITER=false SKIP_HEADER_LINES=1 FORCE_FILENAME_PATTERN=MyData.txt FORCE_DIRECTORY_PATTERN=C:\DemoFileServer\SDI\data CODEPAGE= LOCALE=ja_JP COLUMN_DELIMITER=, ROW_DELIMITER=\r\n ERROR_ON_COLUMNCOUNT=false COLUMN=ORDER_ID;VARCHAR(10) COLUMN=CUS_ID;VARCHAR(10) COLUMN=SUP_ID;VARCHAR(10) COLUMN=PRD_ID;VARCHAR(40)
Best regards,
Nyein.