Records Tutorial how to insert values into the table?

Please check the below links

docs.appian.com/.../Write_to_Data_Store_Entity_Smart_Service.html

docs.appian.com/.../recipe_use_the_write_to_data_store_entity_smart_service_function_on_an_interface.html

ok, so in Appian i can't generate table with prepared fields to just easy fill in?
like when i create custom data type and include for example:

id (Integer)
firstName (Text)
lastName (Text)
department (Text)
title (Text)
phoneNumber (Text)
startDate (Date)

correct?

Hi piotrb0002 ,
yes it is possible to create table in appian.

after create the custom data type(cdt), you have to publish that cdt into datasource of your server, then the table is created ..

once the table is created , then u can insert the data.

Regards,
Bhanu.

Where i can insert these data?
after created data type and publish application also created data store with data entities from cdt, "Entity mappings verified" and i click save and publish, data store has been published so it's looks fine but still can't see place where i can insert values into the table.
Next steps like record type works well the only problem is how to insert these values.

hi piotrb0002 ,

you have to insert this data into many ways.

1. Manually insert the data into respective table
2. You can paste this data into excel and use excel to cdt plugin then insert into table using a!writetodatastoreentity funtion or use write to data store plugin from process model.

Hope this helpful.

Hi piotrb0002 ,

After you publish the data-store successfully with the appropriate data store entities in it , the respective tables will be created the database .

Then you can insert records into table in following possible ways.

1) Manually , by directly navigating to database i,e envts-url/.../index.php. Once you go here click on Appian database on the left hand side , inside it click on the tables and then select the table you want to insert record into . Then select the insert option and start adding the records to the table manually .

2) Using a process model - This is a long procedure
- Create an interface which will capture all the fields that you want to enter into the database
- Create a process model which will call this interface in User input task .
- Use Write to datastore entity smart service to push the data captured from the user into the desired tables

3) Like mentioned below by bhanuprakashm You can paste this data into excel and use excel to cdt plugin then insert into table using a!writetodatastoreentity funtion or use write to data store plugin from process model.


Hopefully this will help .

Thanks,
Rohit Ouhal

Hi piotrb0002 ,

After you publish the data-store successfully with the appropriate data store entities in it , the respective tables will be created the database .

Then you can insert records into table in following possible ways.

1) Manually , by directly navigating to database i,e envts-url/.../index.php. Once you go here click on Appian database on the left hand side , inside it click on the tables and then select the table you want to insert record into . Then select the insert option and start adding the records to the table manually .

2) Using a process model - This is a long procedure
- Create an interface which will capture all the fields that you want to enter into the database
- Create a process model which will call this interface in User input task .
- Use Write to datastore entity smart service to push the data captured from the user into the desired tables

3) Like mentioned below by bhanuprakashm You can paste this data into excel and use excel to cdt plugin then insert into table using a!writetodatastoreentity funtion or use write to data store plugin from process model.


Hopefully this will help .

Thanks,
Rohit Ouhal

Finally got it!
I used 1st method :)