2023-11 Twinmotion Material Substitute Table Editor :

1. Intro :

   To automatically create a match table from the Twinmotion material csv file exported from User Library,
   provides basic edit function like insert, delete items and export edited match data to Excel file,
   as well as to compare data between the newly export material library and the previously edited match table.
   ..



2. Link :

   Web App Version:
   https://zefreestijl.github.io/TM_SubstTable_Editor/
   ..
   Desktop App Version (by Electron):
   https://github.com/zefreestijl/TM_SubstTable_Editor/releases/tag/app
   ..
   Explaination of Each Attributes in Match Table
   https://twinmotionhelp.epicgames.com/s/article/Twinmotion-2023-1-Substitution-Table-Overview?language=en_US
   ..
   --



3. 0. UI Outlook :

   

4. 1. Loading Material Library CSV File from Twinmotion :

   

   
   

   

   
   

   



5. 2. Loading Previously Exported Match Table Excel File :

   
   
   
   



6. 3. Data Comparison Note :

   "1. New Added" - no matched material found in match table → will create new item automatically.
   "2. ID Replaced" - current material ID has been changed → will update to new ID automatically.
   "3. Has Deleted" - material has been removed from library → new match table will ignore the item.
   
   
   
   
   
   
   
   



7. 4. Save the Exported Xsl File to CSV :

   Before Importing datasmith model with the matched data table, we have to Convert the xsl to CSV-UTF8 first.
   (Still trying to figure out how to export the csv in UTF8 enconding inside the Table Editor App..)
   
   
   
   
   



8. 5. Result Before & After Material Matches when Importing a New Datasmith Model