Page 1 of 1
SOLIDWORKS PDM Export File (.cex) Parser?
Posted: Wed Jul 26, 2023 4:37 pm
by cdantonio
Is it possible to create a .cex file parser? I have supply chain people who use mac (without SolidWorks or PDM) who like seeing plain text exports of card variable lists from the admin tool. I used to just copy and paste the list contents every time someone asked to see data, but I was wondering if there was a way to convert .cex to a flattened .txt so I can just send a file. I know that lots of SolidWorks file formats are proprietary, so I'm not sure if I should even attempt this.
Re: SOLIDWORKS PDM Export File (.cex) Parser?
Posted: Wed Jul 26, 2023 5:11 pm
by jcapriotti
Opened in a text editor but the file format is not readable. You could write a SQL query though.
Code: Select all
SELECT CL.Name as [Card List Name]
,CLV.Value as [Card List Value]
FROM CardLists CL
JOIN CardListValues CLV on CLV.CardListId=CL.Id
WHERE CL.Name like 'Document Types' -- Put your card list name here, or comment out to get all
ORDER BY [Card List Name], [Card List Value]
You can also dump that into a CRP report file in PDM and let them run it as needed.
Re: SOLIDWORKS PDM Export File (.cex) Parser?
Posted: Thu Jul 27, 2023 2:47 pm
by cdantonio
Ah ok didn't think of that. Thank you that worked for me!