Fit Fam - Fitnesse for Appian Generator

Hello,

I'm just trying this tools and any forms that I try to put works. The best I can have is the Final state generator for some but not the dynamic. For many other it hangs due to not supported components. 

I see that this tools is 4 years old. Is it really followed or is it deprecated ? I'm currently in Appian 22.3.

After these first tests, the tools seem not really usable. Someone use it with a recent version of Appian ?

Jean-Alain

You can always download the DDL from the datastore.

Created: 2022-12-20T09:31:59.255Z
By: jb8411
Appian Version: 22.3.535.0
Target Database: Microsoft SQL Server 14.00.3238
Database Driver: Microsoft JDBC Driver 7.0 for SQL Server 7.0.0.0
*/

/* UPDATE DDL */
/* DROP AND CREATE DDL */
/* WARNING: The DDL commented out below will drop and re-create all tables.
alter table [FFM_FitnesseGenerator]
drop constraint ffmfitnssscript_fitnssgnrtr;

drop table [FFM_FitnesseGenerator];

drop table [FFM_FitnesseScript];

drop table [FFM_REF_ComponentTypes];

create table [FFM_FitnesseGenerator] (
[id] int identity not null,
[fieldname] nvarchar(1000) null,
[fieldvalue] nvarchar(4000) null,
[gridcolumnnamenumber] nvarchar(1000) null,
[gridrownumber] nvarchar(255) null,
[output] nvarchar(4000) null,
[displaytypename] nvarchar(255) null,
[orderid] int null,
[scriptid] int null,
primary key ([id])
);

create table [FFM_FitnesseScript] (
[id] int identity not null,
[title] nvarchar(255) null,
[description] nvarchar(500) null,
[modifiedon] datetime null,
[modifiedby] nvarchar(255) null,
[formname] nvarchar(255) null,
primary key ([id])
);

create table [FFM_REF_ComponentTypes] (
[id] int identity not null,
[datatypename] nvarchar(255) null,
[islayouttype] tinyint null,
[fitnessecode] nvarchar(255) null,
[ruleid] int null,
[layoutchildfield] nvarchar(255) null,
[issupported] tinyint null,
primary key ([id])
);

alter table [FFM_FitnesseGenerator]
add constraint ffmfitnssscript_fitnssgnrtr
foreign key ([scriptid])
references [FFM_FitnesseScript];
*/

Just for more context - I cannot publish the data store without the tables already existing (due to the configuration of our Appian instance) - so if someone could extract the DDL script from a working installation that would be extremely helpful.

I've downloaded the utility and see that it comes with XSD code for the application to use the FFM_FitNesseGenerator, FFM_REF_ComponentTypes and FFM_FitNesseScript tables.  Also, there's SQL to insert some rows into the FFM_REF_ComponentTypes table.  However, there's no SQL for table(s) creation in the download - so it's hard to tell what are the primary keys, foreign keys, sequences, etc.  Can someone provide the table creation code so that I can modify it for Oracle and evaluate the viability of this utility?

Hi. I've just installed FitNesse For Appian, and edited the example test to launch the Chromes browser, I ran the test and it  actually invokes a Chrome Browser tab, types "data:," in the url and then fails with the below exception.

Hi bharathwajanr587, this is a utility, not a plug-in. Only plug-ins are available to deploy from the admin console of cloud environments. The cloud approved badge means that it's approved for use with cloud environments. To use this, download it from this AppMarket listing and follow the installation instructions include in the download package.

i am unable to download this plugin in the cloud environment.. Has it been removed for the cloud users, though it says that it is cloud certified

Hey Josh feel free to email appmarket@appian.com and we'll relay the feedback to the author!

Great tool! Where can I submit feedback for things I'd like to see in future releases?