Hi,
Can you check the contents of the table usp_exlist_format in your database?
Run the query as "SELECT *, usp_exlist_format.id from usp_exlist_format" and see if there is an entry with id 1003 to support xlsx format or not?
If not we need to update this table.
Necessary dat file is delivered as part of 17.3RU17 and ideally it should be executed as part of post installation steps.
From the command prompt go to directory $NX_ROOT\data\ and execute the command as below to update the usp_exlist_format table.
pdm_load -f r17_3_17_insert.datOnce pdm_load is successful, verify the issue.
Hope this helps.
Thanks & Regards,
Hema.
Original Message:
Sent: Oct 12, 2022 08:12 AM
From: Richa Pathak
Subject: SDM 17.3 RU17 - list excel export as .xlsx does not work
Hi Peter,
xFlow restart is not required for the changes to come into effect.
We suspect the restart might not have happened properly. But good to know the export is working as expected now.
Original Message:
Sent: Oct 12, 2022 04:25 AM
From: Peter Schmidt
Subject: SDM 17.3 RU17 - list excel export as .xlsx does not work
Hi All,
the reason had been easy to solve.
It's not enough to restart SDM-Service ...
You also have to restart xflow-service ...
Now.xlsx-Files are created.
Regards,
Peter
Original Message:
Sent: Oct 12, 2022 02:56 AM
From: Peter Schmidt
Subject: SDM 17.3 RU17 - list excel export as .xlsx does not work
Hi,
after upgrading to RU17 we tried list-export and it's still .xls
NX.env has: @NX_USE_LEGACY_EXPORT=No
AND yes, we have restartet SDM ;-)
In search_filter.js (which is included to std_list.js) I found:
// NX_USE_LEGACY_EXPORT="Yes" or "" means that we want to export as XLS,
// if it's set to "No" it means we want to export as XLSX
if (ahdtop.cfgUseLegacyExport.toLowerCase() == "no") {
definition = "1003";
list_name += "|INTERFACE|XLSX";
}
So, as described in post install steps, it should work. But it does not.
No errors in stdlog:
Connecting client pdm_exporter-xxx.de-#3748
Connected to server xxx.de (domsrvr)
Export (pdmweb:xxx.de#357546e:1...:-7fff-8456-1) started for Userid(sxxxn) Factory(aty)
Export (pdmweb:xxx.de#357546e:1...0:-7fff-8456-1) completed after (0.71) seconds.
What else has to be done?
Regards,
Peter