New: Servoy Html Editor (SHE) plugin

Direct ICT announces the first BETA of the Servoy Html Editor (SHE) plugin

Methods

The plugin exposes eleven main functions to a servoy developer environment-

  1. openFile(String filename)
    This function opens a file in the server given by the filename parameter. The fileName parameter can contain full path or relative path. The relative paths are searched in servoy/server/webapps/root directory.

  2. openStringSaveInFile(String htmlString,String filename)
    This function opens the given htmlString in the editor. The save operation in the editor will save the html into a file in server given by the file name parameter. The fileName parameter can contain full path or relative path. The relative paths are searched in servoy/server/webapps/root directory.

  3. openTableColumn(String serverName,String tableName,String columnName, String whereConditio)
    This function opens the data in a servoy db field . The field is given by serverName, tableName , colummName and whereCondition parameters. The whereCondition is used to select the row. The syntax of where condition is same as SQL where clause excluding the where word. If the whereCondition returns multiple rows the first row is selected. The save operation in the editor will save the data into the same field.
    example: openTableColumn(“user_data”,“editor”,“html”,“id=1”);

  4. openStringSaveinTableColumn(String htmlString,String serverName,String tableName, String columnName,String whereCondition)
    This function opens the given htmlString in the editor. The save operation in the editor will save the html into a servoy db field.The field is given by serverName, tableName , colummName and whereCondition parameters. The whereCondition is used to select the row. The syntax of where condition is same as SQL where clause excluding the where word.
    If the whereCondition returns multiple rows the first row is selected.
    The save operation in the editor will save the data into the same field.
    Example:
    openTableColumn(“

    sample html string

    ”,“user_data” ,“editor” ,“html” ,“id= 1” );

  5. setMediaFolder(String folderName)

  6. setCSSFile(String fileName)

  7. setWidth(int width)

  8. setHeight(int Height)

  9. setSkin(String skinName)

  10. setUseServoyLookAndFeel(boolean flag)

  11. createFolderInRoot(String folderName)

Preferences
The plugin has the following design preferences. The preferences will appear in the servoy developer edit/preferences/she tab. (These functions are also scriptable! See point 5 t/m 11)

  1. Media Folder Name: name of the media folder. This folder should be located in servoy/server/webapps/root
  2. CSS File: name of the CSS file. This file should be located in servoy/server/webapps/root
  3. Width: Width of the editor. Integer Field.
  4. Height: Height of the editor. Integer Field.
  5. Skin: Name of the skin.
  6. List of functions: This list can be used to enable/disable the functions available in the editor.

I18N
The language is selected based on the servoy local settings. The I18N keys for the plugin are included in the SHEsample.servoy example servoy application. Default language is English.

  • This is Beta software. Do not use in production.
  • The Copyright of this product is protected

The demo plugin can be downloaded here: http://www.directict.nl/servoy/ServoyEditorDemo.zip
and works for one hour!

drop the plugin in the plugins-dir and import the SHEsample solution WITH sample-data.

Have FUN! :D And send me all your comment!

I got this interesting error :(

http://www.practica.com.au/servoy/she/error.jpg

Yes, look good at the error. it tries to open sample.html which is not there!

make your own sample.html and put it in that folder!

Sorry Harjo :)

I just assumed that the sample application would take care of the Sample.html . I just didn’t think to go and create it manually.

thanks :)
julian

Pricing is available now:

Server license (ip-based): 200,-
Developer 25 license: 750,-
Developer 50 license: 1000,-
Developer 100 license 1500,-
Developer Unlimited 3000,-

Prices are in Euro’s

If you have questions or what so ever, please ask.

is anyone using this html editor plugin?

what i saw of it looked pretty good and i was looking forward to seeing what it could do. Im about to try the full version and just waiting for Harjo to do an update which i think is any day now

many thanks

Yes, I’ll post an update, today!

Direct ICT announces the first release of the Servoy Html Editor (SHE) plugin

I18N
The language is selected based on the servoy local settings. The I18N keys for the plugin are included in the SHEsample.servoy example servoy application. Default language is English. So import this WITH sample-data

  • The Copyright of this product is protected

The demo plugin can be downloaded here: http://www.directict.nl/servoy/ServoyEditorDemo.zip
and works for one hour!

drop the files: (remove or overwrite older files!)

editor.jar
skin.jar
license.lic

in the plugins-dir and import the SHEsample solution WITH sample-data.
If you have questions or suggestions? Don’t hesitate to contact me.

Have fun.

Is anyone else using the HTML Editor?

We’ve playing with the almost finished version and it looks great… Massive time saver for us.

One thing we are struggling with though is refreshing the data in servoy after editing and saving some html data in the editor pluggin.

Im told this works fine in sybase but we are using MS SQL and the refresh function does not seem to do anything. has anyone had any luck with this?

Highly recommend the Editor plugin… i believe they are just finishing off some licensing code. Great job Harjo

thanks

Eugene

Hi Harjo,

I need a trial version of the SHE plugin. Where I can get. The downloaded link included in this page is not working.

Thanks

The link is working again!

Thanks Harjo!

Hi Harjo,

I am using mySQL for my application. I have refresh issue showing the edited HTML instantly in the servoy field. I edit the HTML when a transaction is on. Does this cause any issue?

Can any one of your method return the edited HTML? This could solve the refresh issue. ie I could set the returned HTML string into the servoy field directly.

Hi!

try this for refreshing the column after editing with SHE:

databaseManager.refreshRecordFromDatabase(foundset,foundset.getSelectedIndex())

P.S. I will post soon the latest version of SHE, with better support for images and contextial menu’s and better support for tables without, borders!

I tried databaseManager.refreshRecordFromDatabase(foundset,foundset.getSelectedIndex()) already.

But it did not work. It may be because I am in the transaction mode and not commited to the database yet. Any other idea? How about my idea of returning edited HTML string?

Thanks

You have to push the save-button first in the plugin!

Can you please try it without a transaction?

returning the edited HTML-string is not possible, because of the structure we use!

Could you please give me a link for the latest version because the one I have seems missing lot of things like inserting table, image etc..

Also can I copy & past from word document with or without any formatting?

Thanks

Could you please give me a link for the latest version because the one I have seems missing lot of things like inserting table, image etc..

hugh??

We allready had that features in the beta-version.
Search for the table-icon, and the image-icon. (the image-feature even allows you to upload images to the server!

Also can I copy & past from word document with or without any formatting?

I don’t know, never tried that.

Hi Harjo, are there any updates for the html plugin. We’ve been using the editor on and off for almost a year now and think it is a great addition to servoy.

im still using the original version which has a couple of bugs one of which is causing us problems when we use it. the editor seems to wrap the html content and also indent it with a couple of spaces. This is causing us a problem when we reder the html in our application which we are doing in Flash. The word wraps and indentations show in the text on the page completely altering its layout. I tried to cut past a text example in the post but all the formatting got removed so ive attached a couple screen shots instead which hopefully give you the idea. It shows the text appering normally in Normal view but then wrapped and indented in the html view. is there anyway to stop this or has it been fixed in a update version?

The second bug is not so serious, when editing existing text in the Normal View of the Editor plugin, when ever you hit enter to add a carriage return the cursor also skips once space forward in the text , which means that if you hit enter again, the first character on the new line gets left behind. and this happens each time you hit enter within exisiting text. Its obviously possible to get around this my hitting the back arrow to reposition the cursos to its correct place after each carriage return. doing that is not that much hassle but it would be nicer not to have to do. :)

Hope this helps. Would really appreciate the fix to the first problem as it is stopping us from using the editor at the moment. Everything else with the editor has been great, thanks for creating the plugin.
Eugene

Yes, there is a new version.
I dont know if it will fix the issues you mentioned.
I will look into this.