Hi,

Is it a way to update biography field with biography_plaintext ?
I imported a lot of author's biography, upgrading biography_plaintext field with an Excel file, but I can't have access to BLOB biography...

Is the field empty when you open the data entry window, and empty in the explorer?
What version are you using?

V10.13

Some are empty (the new ones), other are written with the old biography

Not sure if it will make any difference, but please try v10.14.


Then you need to clear the "Biography" (BLOB) field.

The problem here is that the program will read the memo text from the BLOB field. Only if this is empty it will read the "plain text" field.

Is it a way to transform the "plain text" field in a BLOB field ?

That is a bit trickier. How did you write data to the "plaintext" field?

I've crossed two tables in Access with SQL query, in order to insert new biographies corrected by a friend under Excel, into the "plaintext" field.
All is right, but the new biographies are in RTF, with tags like <br>, and when I need to export in .txt or .xls, all the fields are desorganized, due to <br> tag.

So, I'd like to transform them... or inject automatically (3000 authors...) the "plain text" in the biography BLOB, to generate a correct export

I'm afraid the only way to get the correct text formatting (whether the source text is in RTF or HTML) is to copy text and paste it into the memo with Edit=>Paste in the memo edit window. Simply copying formatted (plain) text into the BLOB field will not work.

Arghhh...
Ok. I found another way :

- Open a new database
- Import a person Excel File -> Generate BLOB
- Go to Access and rename "person" table of the new database, copy and paste it in the main database
- in SQL mode, UPDATE person, personnew SET person.biography=personnew.biography WHERE person.name=personnew.name

It works fine