Hope the title gives you a clue.
For a number of years we have had the ability to store the url address of external images in our databases which when displayed in a form etc shows the actual image.
Great functionality for things like personnel, security,membership system.
However if you ever export your database for whatever reason , perhaps to do a global update oon fields which is nigh impossible from within knack, these images files get stored using HTML img tag a bit like this :
<img src-“https://myserver.cov/images/staff/smith-fred.jpg”/src>
all good makes sense BUT
if for example you wish to change the image data say to reflect a later version of an image like:
imgs/staff/smith-fred-2024
you then encounter 2 problems
- KNACK won’t reimport in the format it exported the URL with the img tag data around it
and/or - it won’t even if you leave the img tag info off.
yet put it directly in to the databae the string used in 2. works totally fine,
This has been an ongoing issue for us as our database uses ID photos on some 2,000 records.
We recently had an unexplained corruption of the field definition which would not allow us to click the field settings without knack thinking we were creating a new field.
I resolved that by going in through conditional settings and tabbing back to the main screen which subsequently remedied the issue.
But fearing a data corruption I copied all the image values to a new field and whilst 2. above worked for a good many it still would not import others for no apparent reason.
Has anyone else encountered this problem ? I have checked the main ID used to access the record (record ID if you will which is unique) and made sure both sides had exactly the same data,
But as I said, it won;t match some up and store the image data in the field.
This has been a long standing problem and think its time it was resolved.
cheers
