DSP 6.5 - Construct - Excel Integration
I need a field to be displayed as read-only in the Excel template. I have set the column properties as:
View Type = Excel
Control Status = Disabled
However, the field does not display. Does anyone know how to set it as read-only? On the other hand, I have tried to unprotect the sheet, but it is password protected. Does anyone know the password? Thanks in advance!
VGazquez: Hi Sergio/Didac, Unfortunately, as far as I know, this action is not possible (I hope the Development team adds it in the next release).
According to the documentation, only fields with Control Status = Enable are downloaded.
The only workaround I found is to set this in your Hor view as Disable and Key, and Enable in your Excel. In this way, you download the field, and even if you change it, you get an error when the Excel file is uploaded (in case you do not allow Add data) or it will create a new entry (in case you allow Add data). It is not ideal, but it works.
Another way is to create an intermediate table as a copy of the main one and use it with the Excel integration. Once you upload it, you will need to move the corresponding data (only columns that you want) to the main table.
Another way, which allows you to change data (I do not recommend it), is to enable the field, change the background color, and tell the client that particular color are only read data, but there is nothing that stop you to change it. An additional step could be create a SP that overwrites with the original value.
The password for unprotecting Excel files produced by Excel Integration can be requested in a ticket at support.syniti.com.
Regards
Please sign in to leave a comment.
Comments
1 comment