Database and API

Confluence User - 24 Oct, 2018

Hello, 

Please, I would like to have a list of compatible Databases for Joget?

Secondly, I would like to know if Joget can freely interact with other API's.

Lastly, I  would like to know what skills are needed for UI customization in Joget.

The platform we are trying to build has about five different interfaces and we are at the research phase, trying to find out what tools to use and what developer skill set should be on board.

Thanks in anticipation.

Mo

 

database

6


24 Oct, 2018
confluenceUser
1
confluenceUser

Hello there Mo,

1) Joget officially supports MS SQL, MySQL, MariaDB (fork of MySQL), and Oracle DB. Other RDBMSes may work too, although it is not officially supported. Joget uses Hibernate ORM, hence you may refer here for likely supported databases: https://www.tutorialspoint.com/hibernate/hibernate_quick_guide.htm

2) Joget has great extensibility via plugins, you may refer here for more information: Developer Guide. There are also existing tools available in default Joget builds, such as JSON Tool and SOAP Tool and so on. As long as you are proficient with object-oriented programming, specifically Java, with the addition of web development as a bonus.

3) To customize Joget apps UI, there are a myriad of available configurations in Joget such as Custom HTML or placeholders for custom Javascript, CSS, HTML for userview themes and so forth. Or if you require further customization, you may refer to Userview Theme Plugin to create your own userview themes. In short, as long as you are proficient in CSS, HTML, Javascript, jQuery, Freemarker (optional), and Java.

Hope this helps!

24 Oct, 2018
confluenceUser
confluenceUser

Yes, it does, my team wants to build an application with multiple interfaces. a sample functionality would be:

a platform where a high school sends the list of their top students to the Dean who looks through the record and approves, thus making them(students on the list) eligible for college scholarships.  The college receives a notification from the high school,  note that the college also uses the application but their interface is different. they receive a notification followed by the details from the high school. the college's interface is for moving this details around, For instance, from the registry to accounts department, to the students' department of choice. but in our case instead of student's name transfer, the app is for payment and monitoring.

so the processes involve :

1. Bulk upload of an excel file and the file is supposed to be populated in a table on the app, not as an excel file anymore.

2. Approval, request and decline notifications

3. Dashboard for monitoring transaction history and uploads

so much more... DO YOU THINK THIS IS HIGHLY ACHIEVABLE WITH JOGET?

24 Oct, 2018
confluenceUser
confluenceUser

Yes, certainly!

1) Assuming you have a CSV, XLS, or XLSX file, you can use Import Tool to bulk populate a database table quickly.

2) Joget Workflow is great for your use case and further much more. In fact, there is also a function called Generate Process - Approval Process that is capable of quickly generating an approval process with a single-click, with all its necessary datalist and userview based on the built-in template. Then, there are tools such as Email Tool, Mobile Push Notification Tool, and so forth, to notify your end users.

3) You can create your own monitoring dashboard with แดชบอร์ด (Dashboard), or use existing Joget functions such as MonitorAudit Trail, and Tomcat Logs.

Don't hesitate to ask if you have further doubts. (smile)

24 Oct, 2018
confluenceUser
confluenceUser

Hi, 

Quick question, please how do I export whatever has been built on the Joget platform

secondly, can I modify a form after exporting and then import it back joget?

25 Oct, 2018
confluenceUser
confluenceUser

Hello, 

one last question. I built a login page with custom HTML, how can i upload a logo and a background image to the form.

25 Oct, 2018
confluenceUser
confluenceUser

Hey there,

You can Import and Export Apps from Joget Workflow. This includes your forms, datalists, userviews, and processes of such app. The exported app file format would be like: file.jwa. You can then import the app into another Joget platform and modify as per usual.

For your second question, you can refer to the image below.

In your Joget app, Go to "Properties & Export", you can add your file or image resources there.

After adding your logo and background image, you can click into the file to see the file details. There you can either use the URL or Hash Variable to obtain the file path.

Then, you can use the URL or Hash Variable in your Custom HTML form element.

Best regards.

RELATED QUESTIONS

Your answer


To answer a question you'll need an account.

Print