VisualNeo Win - *.RFT text and Access - Forum - VisualNEO. Cross-platform App Development Tool for Windows

#1 · May 1, 2021, 9:50 pm

Hello everyone
I need to write a text in *.RFT format in an Access memo field, and then retrieve this text 
with the EDITORS TOLBOX 1.75 plugin,(or with another resource),without losing the formatting 
of the RFT. (font type, underline, font color, etc.). 

Can anybody help me ? Thanks

#2 · May 2, 2021, 6:40 am

Good day! You can use zmToRTF plugin to encode ASCII to RTF.

Uploaded files:

You need to login to have access to uploads.

#3 · May 2, 2021, 4:44 pm

Thank you very much for your quick response and for your help. !

#4 · May 2, 2021, 4:52 pm

Would you have an example or a HELP file? What are the [param] and [variable]?
Thanks.

#5 · May 4, 2021, 10:41 pm

@ubirajara-fernandes-valladares

I will be able to show an example of using the plugin only when I return from a trip (after May 17). If it is still relevant for you.

#6 · May 5, 2021, 12:22 am

Vadim,
Again, thank you for your attention. I will wait for the examples when you return from your trip. 
Have a nice trip !

#7 · May 16, 2021, 12:13 pm

@ubirajara-fernandes-valladares

I did the following for the search string:

First, I encoded the string into ASCII with the zmFunctions (Peter Pavlov) plugin:
zmConvertString "StrToAscii" "[findX]" "[ASCII]"

Then I encoded the ASCII into RTF form:
zmASCII2RTF "[ASCII]" "[findXRTF]"

Then searched for the right one in the database that stores the RTF:
dbpQuery "CT" "Persona" "[FieldX] LIKE [#34]%[findXRTF]%[#34]"

I'm attaching the project where I did this. See subprogram "Find".

Uploaded files:

You need to login to have access to uploads.

#8 · May 18, 2021, 3:23 pm

Vadim,

Thank you very much for your attention and example. 
I was able to write the text as RFT in the database, 
but I was unable to retrieve the text to read it on the screen. 
If possible, I would like your help once again. 
Thank you again. I hope you had a good trip.

#9 · May 20, 2021, 12:43 pm

@ubirajara-fernandes-valladares

Many thanks! I was able to help my brother a little in building a house. I hope to continue this good business in the summer, as my vacation))

You can render RTF using EditorsToolbox 1.75 (C. Giebel) plugin.
For example, this is how I do it in my project that I attached above:
teSelText "teRectangle" "[CT.Persona.fDESCRIPTION]"

"teRectangle" is the name of the rectangle in which the EditorsToolbox plugin object is created.

[CT.Persona.fDESCRIPTION] is a variable that stores content from the database.

luishp has reacted to this post.

#10 · September 20, 2021, 11:46 pm

Vadin,good night
Is it possible, with the vlWord plugin, create a *.RTF file? or another plugin to transform *.docx to *.RTF ?
Thanks

#11 · September 21, 2021, 6:29 am

@ubirajara-fernandes-valladares

Good afternoon! Yes, that's right, with vlWord you can create .docx files (including the .dotx template), you can edit .docx and .rtf files, and you can convert .docx, .rtf files to .docx, .rtf, .pdf, html files. MS Word must be installed (the plugin uses it as an automation server).

To convert, use the vlSaveAsWord command (save as).

#12 · September 21, 2021, 7:38 am

Hello,

One thought, the basic article objekt is also capable to show RTF-files.

It may be not that powerfull as EditorsToolbox but for simple RTF it may work. And it is out of the box.

Regards

Hans-Peter

#13 · September 21, 2021, 12:08 pm

@ubirajara-fernandes-valladares

Yes, @hpw is absolutely right. Since an RTF file is a text format, it can be created from scratch using the FileWrite command. In doing so, you can write variable values to such a formatted file.

Here is an example in the demo. Only you may need to set your own encoding (my RTF examples are in Russian).

To understand RTF formatting, you need to refer to the RTF documentation (it's an open format). This takes more time. But if you make an RTF using FileWrite, you can do without plugins. It is also useful to study the RTF file created in VisualNEO Win in a standard notepad to see the RTF code.

Please note that when displaying content in Linked-Article object - the regular object has some disadvantages - it does not always display tables correctly (I had to insert them as images); it is very slow when working with files over 100 pages, especially when the size of text objects changes (when stretching the project window) and the project needs to redistribute text between pages (the project may freeze for 20 minutes to perform this task); there is no automatic word transposition (partitioning, transfer) (by rights, by parts). Perhaps we will manage to improve it in future versions of VisualNEO Win.

Uploaded files:

You need to login to have access to uploads.

#14 · September 22, 2021, 12:09 am

Vadin,good evening.

Your example (createRTF.PUB) worked fine for my need.

I created *.docx using the vlWord plugin, but I couldn't transform .*docx into *.RTF using the following commands:

vlCreateFileWord "[PUBDIR]/[PATIENT]" "" "FALSE" "False"

vlOpenFileWord "[pubdir]/[PATIENT]" "[test]" "False" "False" "False"

vlSaveAsWord "[pubdir]/[PATIENT]" "[TRUE]" ".rtf" "True" "True"

vlCloseFileWord "[PATIENT].docx" "False"

[PATIENT] is a variable, with my patient's name

I did something wrong ?

Thank you Vadin

Thank you Hans-Peter

#15 · September 22, 2021, 7:08 am

@ubirajara-fernandes-valladares

The plugin comes with a demo file. See how the command works in the vlSaveAsWord tab. There is a separate RTF help file for each command. The contents of this file are automatically displayed in the command setup assistant window. You need the RTF files to be located in the folder with the VisualNEO Win installation at the following address: ...VisualNeoWin\PlugIns\vlWord\Loc
Just move the Loc folder (with all the RTF files in it) if you have it in a different location.

Also, note that the path on your local computer is specified with a left slash. Your example uses right slash (like Internet paths).

Also, you do not need to put a slash after [PubDir], this variable will already contain a trailing slash, which is necessary to separate the folder name from your file name.

#16 · September 24, 2021, 3:38 pm

Thank you.