#jArchi This scripts exports selected elements to the CSV in fixed structure and import elements to the model and the current view

fromCsv.ajs

/*
 * Import Elements from CSV
 * 
 * Requires jArchi - https://www.archimatetool.com/blog/2018/07/02/jarchi/
 * Requires PapaParse - https://www.papaparse.com/
 * 
 * This script imports CSV containg followin structure:
 *    * Name
 *    * Documentation
 *    * Type (element type)
 *    * Properties
 * as a result new elements are created in the model and put to the current view stackig from position 10,10.
 * Before running the script you must choose the view.
 * Script does not check whenever elements existed in the model. 
 * 
 * Input file could be created manually or generated by coresponding scrip toCsv.
 * 
 * Version 1: Import elements from CSV list
 * Version 2: Add properties support
 * 
 *     2020 by tkazimie@me.com
 * 
 * This script was creaed based on "Import from CSV" by Steven Mileham
 */

var debug = false;//true;//false;

console.clear();

var theConcept = null;

load(__DIR__ + "lib/papaparse.min.js");
debug? console.log("> Loaded Papa Parse"):true;

var theCurView = $(selection).filter("archimate-diagram-model").first();
if (theCurView != null) { 
  var filePath = window.promptOpenFile({ title: "Open CSV", filterExtensions: ["*.CSV"], fileName: "default.archimate" });
  if (filePath) {
      var FileReader = Java.type("java.io.FileReader");
      var theCSVFile = new FileReader(filePath);

      var theCSV ="";

      var data = theCSVFile.read();
      console.log("> Please Wait...");
      while(data != -1) {
          var theCharacter = String.fromCharCode(data);
          theCSV+=theCharacter;
          data = theCSVFile.read();
      }
      theCSVFile.close();
      console.log("> File Loaded");
      theDataFile = Papa.parse(theCSV);
      console.log("> File Parced");

      theData = theDataFile.data;

      theDataHeaders = theData[0];
      debug? console.log("> header:"+theDataHeaders):true;


      var commonProperties = ["Name", "Documentation","Type"];

      var k=1;
      for (var i=1; i<theData.length; i++) {
          debug? console.log("> data row:"+theData[i]):true;
          var theObject = [];
          for (var j=0; j<theDataHeaders.length; j++) {
              theObject[theDataHeaders[j]]=theData[i][j];
              debug? console.log("> data:"+theData[i][j]):true;
          }
          if (theObject.Name || theObject.Name.length > 1 ) {
            debug? console.log("> Creating Concept["+i+"]:"+theObject.Name):true;
            try {
              var theElem = model.createElement(theObject.Type,theObject.Name);
            }
            catch(err) {
              theElem=null;
            }
            if (theElem) {
              theElem.documentation=theObject.Documentation;

              for (var j=0; j<theDataHeaders.length; j++) {
                switch (theDataHeaders[j]) {
                    case "Name":
                    case "Documentation":
                    case "Type":
                        break;
                    default:
                        if (theObject[theDataHeaders[j]]) {
                          theElem.prop(theDataHeaders[j],theObject[theDataHeaders[j]]);
                        }
                }
            }


              debug? console.log("> Element created:["+i+"]"+theObject.Name):true;
              var theBox=theCurView.add(theElem, 10+k*10, 10+k*10, 150, 75);
              if (!theBox) {
                console.log("> Cannot create box for:"+i+theObject.Name);
              }
              else
              {
                debug? console.log("> Box created: "+theBox):true;
                k++;
              }
            }
            else
            {
              console.log("Skipping line - Cannot create:"+theObject.Name+":"+theObject.Type);
            }
          }
          else {
            console.log("Skipped nameless row.");
          }
      }
  }
  else
  {
    window.alert("File open canceled.");
  }
}
else {
    window.alert("Please Select a the view for elements creation before running the script.");
}
console.log("End fromCsv Script");

toCsv.ajs

/*
 * Export selected elements to CSV
 * 
 * Requires jArchi - https://www.archimatetool.com/blog/2018/07/02/jarchi/
 * Requires PapaParse - https://www.papaparse.com/
 * 
 * This script exports selected elements to the CSV in fixed structure:
 *    * Name
 *    * Documentation
 *    * Type (element type)
 *    * <existing properties (if defined)> 
 * to the selectd file.
 *
 * Before running the script you must select some elements in the tree or the view.
 * 
 * Output file could used by coresponding scrip fromCsv as well the file coule be used as a 
 *  template for manual file creation
 * 
 * 
 * Version 1: Export selected elements to CSV
 * Version 2: Add properties support
 * 
 *     2020 by tkazimie@me.com
 * 
 * This script was creaed based on "Export from CSV" by Steven Mileham
 */


var debug = false;//true;//false;


load(__DIR__ + "lib/papaparse.min.js");
debug? console.log("> Loaded Papa Parse"):true;

console.clear();
console.log("New toCsv Script");


// Set up Header
var conceptHeaders = [
    "Name",
    "Documentation",
    "Type"
];
var theData = new Array();
var propertiesList = [];


$(selection).each(function(theConcept) {
    debug? console.log("Elem name:"+theConcept.name+" type:"+theConcept.type):true;
    if (theConcept.type != "archimate-diagram-model") {
      var theProperties = theConcept.prop();  

      for (var i=0; i<theProperties.length; i++){
          var found = false;
          for (var j=0; j<propertiesList.length; j++) {
              if (propertiesList[j]==theProperties[i]) {
                  found=true;
              }
          }
          if (!found) {
              propertiesList.push(theProperties[i]);
              conceptHeaders.push(theProperties[i]);
          }
      }
      var theObject = new Object;
      theObject["Name"]=theConcept.name;
      theObject["Documentation"]=theConcept.documentation;
      theObject["UID"]=theConcept.id;
      theObject["Type"]=theConcept.type;

      for (var i=0; i<propertiesList.length; i++){
        if (theConcept.prop(propertiesList[i])) {
            theObject[propertiesList[i]]=""+theConcept.prop(propertiesList[i]);
        }
      }
      theData.push(theObject);
    }
});

// Open a dialog to let the user choose where to save the generated file
var defaultFileName = model.name ? model.name  + ".csv" : "Exported Model.csv"; // Default file name
var exportFile = window.promptSaveFile({ title: "Export to CSV", filterExtensions: [ "*.csv" ], fileName: defaultFileName } );
var theCSV = Papa.unparse({fields:conceptHeaders, data:theData});

if(exportFile != null) {
        debug? console.log("> TheCSV"):true;
        debug? console.log(theCSV):true;
    
        $.fs.writeFile(exportFile, theCSV);
        console.log("> Export done");
    }
    else {
      window.alert("File open canceled.");
    }
console.log("End toCsv Script");

Hey @tkazimie, just to let you know, someone pointed out a bug in my original "Import from CSV" script where it was breaking on special characters. I've updated it to now support UTF-8 on import. https://gist.github.com/smileham/1e57a5946235e780dee5a824f664aa3d

Just FYI folks, I've updated the original to now import/export the Specializations and support for creating a View to highlight those Elements which have been imported. https://gist.github.com/smileham/1e57a5946235e780dee5a824f664aa3d and https://gist.github.com/smileham/15c445b17a92bd6f5dc1508e573bcd8a