Creating dropdown menu's without backend interaction in Agentry

[Former Member]

Hi,

is there a way (for quick demo purposes) to show a dropdown list that is based on a locally created data table without backend interaction?

This doesn't need to be a data table per se, just a sort of hardcoded list of selection values with a separator (for instance ;yes;no;maybe;).

This way we can give our stakeholders on short term a mockup screen with selection values that don't need the whole backend integration.

Tags edited by: Michael Appleby

[bill_froelich]

All Agentry applications must have at least one backend defined to at a minimum handle the user authentication,  For quick demos I typically use a SQL connection where I automatically accept all user / password combinations as valid.  I can then setup sample data to populate data tables etc as needed for my application,

The other option would be to use a File Backend connection and setup the data table based on a file from the Agentry server.  You can refer to the following link for more details.

https://sycloresourcecenter.sap.com/development/kb/howto-create-data-table-file-backend

If you are still having issue let us know.

--Bill

[Former Member]

I can't get it to work (the file backend solution).

When syncing I get a server error on checking data tables.

These are my configs like described on sycloresourcecenter:

ini:

[Agentry]

messageLogFile=messages.log

eventLogFile=events.log

logMaxSize=0

logRollTime=1:45

logRollsAtTime=true

[Server]

administratorEmail=jonathan.gijsemans@tmvw.be

administratorName=Jonathan Gijsemans

administratorPhone=???-???-????

agentFile=agents.ini

allowRelogin=True

autoRegister=true

inactiveTimeout=600

notifyUserOnLogout=false

notifyUsersOnShutdown=false

userKey=PPSNHFMHKHKGOJOP

devKey=AUJJCFFHHCEEKXLJ

expKey=PPSCHKMJFEIAATQH

loginRetryLimit=3

publicKeyLength=512

serverAgentThreadCount=0

userUpdatePeriod=1000

vineFile=vines.ini

[Server Administration]

authenticationCertificateStore=AgentryServer.pfx

authenticationCertificateStorePassword=Rzdrj~SwixoAqzmbVxgi

authenticationCertificateStorePasswordEncoded=true

;trustedCertificateStore=

;authenticateClient=false

; If you wish to bind the Server Administration ports to specific TCP ports,

; use the settings below.  Each one takes either "port number" or

; "interface address:port number".  Only the interface name in commandPipePort

; is significant, and controls which interface both ports will be bound to.

; The statusPipePort must either contain the same host name, or only a port

; number, or the server will fail to start.  Both values default to 0, which

; causes both ports to be allocated dynamically and bound to all interfaces.

;commandPipePort=0

;statusPipePort=0

[Front Ends]

1=angelvine.dll

[ANGEL Front End]

trustedCertificateStore=

authenticationCertificateStore=AgentryServer.pfx

authenticationCertificateStorePassword=Rzdrj~SwixoAqzmbVxgi

authenticationCertificateStorePasswordEncoded=true

authenticateClient=false

timeout=300

keepAliveTime=60

;Leave the Cipher Strength settings commented out for the system to select them automatically.

;minimumCipherStrength=40

;maximumCipherStrength=512

[ANGEL Front End Ports]

1=7003

;2=127.0.0.1:7013

[TCP Front End]

listenOn=7001

timeout=300

[Configuration]

applicationGlobalsFile=Globals.ini

applicationStringsFile=ApplicationText.ini

clientStringNamesFile=ClientStringNames.ini

clientStringsFile=ClientText.nl.ini

developmentServer=True

enableFailedTransactionLogging=True

enableOverrideFile=Enables.ini

enableTransactionFailureHandling=False

failedTransactionFilenameFormat=%{userid} %{transaction_name} %{date} %{time}-%{count}.xml

failedTransactionsQueue=FailedTransactionsQueue

imagesPath=Application\Development\Images

localizationPath=

localizations=

overrideInfoTableDirectory=OverrideInfoTable

overrideTypesFile=OverrideTypes.ini

postedTransactionDirectory=posted

postedTransactionFile=%{device}.pli

scriptsPath=Application\Development\Scripts

spinDocIniFile=

threadCount=0

transmitConfigurationFile=TransmitConfigurations.ini

updateIdleWait=60

updatePeriod=60

[Agents]

1=ag3.dll

[Web Server Front End]

listenOn=80

permitGetCGI=true

xslDirectory=xsl

resourceDirectory=resource

authenticationCertificateStore=AgentryServer.pfx

authenticationCertificateStorePassword=Rzdrj~SwixoAqzmbVxgi

authenticationCertificateStorePasswordEncoded=true

[Web Server MIME Types]

ico=image\x-icon

wmls=text/vnd.wap.wmlscript

png=image/png

gif=image/gif

css=text/css

[Server Side Clients]

1=ServerSideClient.dll

[SpinDoc]

os=windows

facePath=sql\custom;sql

;Use this section to enter TimeZoneAlias values

[TimeZoneAlias]

[File-2]

name=dos

enableAuthentication=false

enablePreviousUserAuthentication=false

allowPreviousUserLogin=false

userDomain=

tempPath=

[File-3]

name=File Back End

allowPreviousUserLogin=false

enableAuthentication=false

enablePreviousUserAuthentication=false

tempPath=E:\Syclo\TM1\attachmentsdummy

userDomain=

[Java-1]

classPath=./ini4j.jar;./sapjco.jar;./Java/Agentry-v5.jar;./Java;./Java/S4SAPWM.jar;

constantsFile=

deleteSource=True

enableAuthentication=True

allowPreviousUserLogin=true

enablePreviousUserAuthentication=True

initialHeapSize=256

maxHeapSize=512

name=Java Back End

outputDirectory=.

performCompile=False

printBusinessLogicStackTrace=False

printStackTrace=False

reduceOSSignalUse=True

scriptsPath=

serverClass=com/syclo/sap/workmanager/Server

sourceDirectory=.

timeZoneName=Central Europe Standard Time

nonStandardJavaOptions=-Xdebug -Xrunjdwp:transport=dt_socket,address=7090,server=y,suspend=n

[SQL-4]

name=SQL Back End

allowUserToChangePassword=true

dbConnectionPasswordEncoded=false

dbConnectionName=Interflex

dbConnectionUserID=syclo

dbConnectionPassword=syclo

dbConnectionType=ODBC

disconnectFromDB=false

disconnectTime=1:00

enableAuthentication=true

enablePreviousUserAuthentication=true

queryInitFile=SqlBE.ini

queryConstantFiles=SqlServer_sd.ini

reconnectTime=2:00

sharedConnections=0

timeZoneName=Central Europe Standard Time

prefetchRows=1000

useUserDBAuthConnection=true

[System Connections]

1=ag3javabe.dll

2=ag3filebe.dll

3=ag3filebe.dll

4=ag3sqlbe.dll

5=ag3filebe.dll

[File-5]

name=File Back End

allowPreviousUserLogin=true

enableAuthentication=true

enablePreviousUserAuthentication=true

tempPath=

userDomain=

[LastUpdates]

System Connections=17:40:50 2/5/2014

Java-1=15:2:51 10/28/2013

Front Ends=11:21:10 2/21/2011

ANGEL Front End=13:6:19 2/21/2011

ANGEL Front End Ports=13:6:19 2/21/2011

Agentry=13:6:19 2/21/2011

Configuration=13:6:19 2/21/2011

Midstation Front End=13:6:19 2/21/2011

Server=13:6:19 2/21/2011

SpinDoc=13:6:19 2/21/2011

TCP Front End=13:6:19 2/21/2011

File-2=11:47:18 4/5/2011

File-3=15:50:58 4/12/2011

SQL-4=15:36:49 4/20/2011

File-5=17:40:50 2/5/2014

[jason_latko]

Dieter,

First thing I saw was that your data table is named MockupUrgency in the editor, but your file contains: [Mockup_Urgency], with an underscore.  I'm pretty sure those must match.

Jason Latko - Senior Product Developer at SAP

[bill_froelich]

Dieter,

I just setup an example of this using Agentry 6.0.38 to confirm it was working as expected.

The one thing I noticed in your example is that the table name in the editor doesn't match the section heading in the data file.  Based on your screen shots, I believe Agentry is expecting the section heading name to be [mockupurgency].

If you haven't already turn on logging at the lowest level for the File Backend and perform a transmit.  The logs will indicate the file and section that Agentry is looking for to load the Data table.  Also, the same name (I believe it may be case sensitive) should match in the LastUpdates.

Hopefully this will get you going.

--Bill

[bill_froelich]

Dieter,

I also noticed you have multiple File System Connection backends in your application.  Typically you would only have one File backend in an application since they will all be accessing the same File system on the Agentry Server.

Just something to consider.

--Bill

[Former Member]

I've corrected the name issue, but I now get a password error message and after a few attempts the user is said to be locked.

Although in the SAP backend the user is not locked.

Normally the incorrect password notification is different, so it should be caused by this data table mockup.

I do have multiple File system connections because I'm making mockup screens for an existing application.

The other connection is to a SAP backend, which means much more setup to demo a simple screen.

Pasword error message before the update:

Password error after the update:

[jason_latko]

Dieter,

In your Agentry.ini, you have authentication enabled for multiple backends, including one of your file backends.  Turn off all user authentication for any backend you are not checking user credentials for by setting the values to false:

enableAuthentication=false

enablePreviousUserAuthentication=false

Jason Latko - Senior Product Developer at SAP

[Former Member]

I see the [SQL-4] section is set to true for the values Jason set, please update to false.  Also [File-5]

Stephen Streeter

[Former Member]

I got through the sync, but the table isn't picked up (as seen on the transmission screen).

The values in the dropdown don't show up.

Did I place the txt in the wrong directory?

(republished, restarted service and reset client, so this is not the issue)

[Former Member]

The name of your table in the editor is "MockupUrgency" while your file name and the section header is called "Mockup_Urgency", please update the them so they match.

Stephen Streeter

[Former Member]

yes that I corrected already, but still not picked up..

[Former Member]

Can you show us what the User Log file shows for when it tries to load the table?

Stephen

[bill_froelich]

Even better what the contents of the File Backend log are.

--Bill

[Former Member]

On the agentry server I only see "events" and "messages" logs, can't see any relevant logging that relates to the user and the tables..

I do see that there was a folder created "attachmentsdummy" where i can find the "Mockup_Urgency.txt" file

[Former Member]

To enable log files please see this SAP KBA: http://service.sap.com/sap/support/notes/1959484

Stephen Streeter