Data table creation with file back end

[former_member197782]

Hi Experts,

   I have created a Data Table with File system back end and I created DTData.txt in Tables folder of ServerDev(Which was created by me only).

1. I added a File back end system connection.

2. Added Data table with file system back end.

3. Modified the agentry.ini file

[System Connections]

1=ag3sqlbe.dll

2=ag3filebe.dll

[File-3]

name=File Back End

allowPreviousUserLogin=true

enableAuthentication=false

enablePreviousUserAuthentication=false

tempPath=

userDomain=

     Restarted the server.

4. Created Tables folder in ServerDev and inside this folder created DTData.txt file

5. Modified the DTData.txt as follows.

This is all the process I have done. But where can I see this file system data table. I couldn't find the effected changes in my app in ATE.

I created screen set field with this data table as screen field edit type but the values I posted in DTData.txt are not populating to that filed.

Anyone please suggest where to test this.

Thanks in advance,

Swaroopa.

[Former Member · Accepted solution]

You system connections show the the File Connection is number 2, but the File section shows "3"

[System Connections]

1=ag3sqlbe.dll

2=ag3filebe.dll

[File-3]

[former_member197782 · Accepted solution]

Hi Stephen,

I have changed my Agentry.ini as below.

[System Connections]

1=ag3sqlbe.dll

2=ag3filebe.dll

[File-2]

name=File Back End

allowPreviousUserLogin=true

enableAuthentication=false

enablePreviousUserAuthentication=false

tempPath=

userDomain=

And my DTData.txt is as follows.

[filedatatable]

1=low

2=high

3=medium

[LastUpdates]

filedatatable=8:00:00 01/01/2007

But there is no change in output. Could you help me where I need to change.

Thanks,

Swaroopa.

[bill_froelich · Accepted solution]

Swaroopa,

I would recommend making sure you File Backend logs are setup to Low (most detail) and separate file.  Then perform your initial transmit and check (and post or email me) the logs and we can look to see where the problem might be.

--Bill

[former_member197782 · Accepted solution]

Hi Bill,

     Thanks for the reply. Please check below.

My DTData.txt:

My Agentry.ini file:

My File back end log file:

--In editor I added a new system connection with "File Back end", created new data table with this system connection and created DTData.txt as file name.

--Created "Tables" folder in ServerDev root directory and placed DTData.txt file in this folder and entered the above 1st screen shot text.

--In my ATE i couldn't see this filedatatable.

Thanks,

Swaroopa.

[bill_froelich · Accepted solution]

Looking at your screenshot for your file DTData.txt the filename is actually DTData.txt.txt.  You have the .txt extension on there twice.  I suspect that you have file extensions hidden in Windows Explorer which is why you didn't see it.  Try fixing the file name and see if that helps.

--Bill

[former_member208808]

Also take a look at this blog