Compass¶

• Compass FlacheListe
• Compass Jobserver
• Compass Replikator
• Compass SQLScripte
• Compass Tipps und Tricks

DEX¶

Ablage Ort fürs DEX Log :

C:\ProgramData\Autodesk\Productstream Data Export Utility\DataExportUtility.log

Filelinkname mit Pad belegen

___Selection ( enumerate __MARK__ ___XdwCmd "update DOCUMENT set FILE_LINKNAME=##(DOCNAME0) where AIMKEY=##(AIMKEY)" );

___read() #DOCNAME0

Seletierte Daten ins DEX

___Selection ( enumerate __MARK__ ___XdwCmd "INSERT INTO PSP2VLT ( AIMKEY ) VALUES ( ##AIMKEY )"  );

CREATE TABLE [dbo].[PSP2VLT](
    [AIMKEY] [numeric](17, 5) NULL,
    [ID] [numeric](18, 0) IDENTITY(1,1) NOT NULL
) ON [PRIMARY]
GO

SELECT * FROM VIEW_ALL_DOCUMENT WHERE AIMKEY IN (  SELECT AIMKEY FROM PSP2VLT )
SELECT * FROM VIEW_ALL_PROJECT WHERE AIMKEY IN (  SELECT AIMKEY FROM PSP2VLT )

DELETE FROM PSP2VLT
WHERE ID NOT IN 
    (SELECT min(ID) 
    FROM PSP2VLTxx Tab1 
    GROUP BY AIMKEY)