Révision 2796

tmp/org.txm.groovy.core/src/groovy/org/txm/scripts/importer/transcriber/FixINAXML.groovy (revision 2796)
1 1 
import org.txm.utils.ConsoleProgressBar
2 2 

  		





  3
  
  
    
def directory = new File("C:\\Users\\mdecorde\\xml\\trs")


  		





  
  3
  
    
def directory = new File(System.getProperty("user.home"), "TEMP/ANTRACT/AF")


  		





  4
  4
  
    
println "Fixing $directory"


  		





  5
  5
  
    
def files = directory.listFiles()


  		





  6
  6
  
    
ConsoleProgressBar cpb = new ConsoleProgressBar(files.size())


  		












  

    
      tmp/org.txm.libs.msoffice/src/org/txm/libs/msoffice/ReadExcel.java	(revision 2796)
    
  






  458
  458
  
    
		HashMap<String, String> columnsToRenameRules = new HashMap<String, String>();


  		





  459
  459
  
    
		HashMap<String, String[]> searchAndReplaceRules = new HashMap<String, String[]>();


  		





  460
  460
  
    
		// //emissions


  		





  461
  
  
    
		// table2File = new File("/home/mdecorde/TEMP/ANTRACT/AF/emissions.xlsx");


  		





  462
  
  
    
		// columnsSelection = Arrays.asList(


  		





  463
  
  
    
		// "Identifiant de la notice", "Titre propre", "Notes du titre", "Date de diffusion", "Durée", "Nom fichier segmenté (info)", "antract_video",


  		





  464
  
  
    
		// "antract_debut","antract_fin","antract_duree","antract_tc_type","antract_tc_date");


  		





  465
  
  
    
		// lineRules.put("Type de notice", "Notice sommaire");


  		





  466
  
  
    
		// columnsToCopy.put("Notes du titre", "subtitle");


  		





  467
  
  
    
		// columnsToCopy.put("Titre propre", "title");


  		





  468
  
  
    
		// columnsToCopy.put("Date de diffusion", "textorder");


  		





  469
  
  
    
		// columnsToRenameRules.put("Identifiant de la notice", "id");


  		





  470
  
  
    
		// searchAndReplaceRules.put("textorder", new String[] {"../../....", "$3$2$1"});


  		





  
  461
  
    
//		 table2File = new File("/home/mdecorde/TEMP/ANTRACT/AF/emissions.xlsx");


  		





  
  462
  
    
//		 columnsSelection = Arrays.asList(


  		





  
  463
  
    
//		 "Identifiant de la notice", "Titre propre", "Notes du titre", "Date de diffusion", "Durée", "Nom fichier segmenté (info)", "antract_video",


  		





  
  464
  
    
//		 "antract_debut","antract_fin","antract_duree","antract_tc_type","antract_tc_date");


  		





  
  465
  
    
//		 lineRules.put("Type de notice", "Notice sommaire");


  		





  
  466
  
    
//		 columnsToRenameRules.put("Identifiant de la notice", "id");


  		





  
  467
  
    
//		 


  		





  
  468
  
    
//		 columnsToCopy.put("Notes du titre", "subtitle"); // not working yet


  		





  
  469
  
    
//		 columnsToCopy.put("Titre propre", "title"); // not working yet


  		





  
  470
  
    
//		 columnsToCopy.put("Date de diffusion", "textorder"); // not working yet


  		





  
  471
  
    
//		 searchAndReplaceRules.put("textorder", new String[] {"../../....", "$3$2$1"}); // not working yet


  		





  471
  472
  
    
		


  		





  472
  473
  
    
		// sujets


  		





  473
  474
  
    
		table2File = new File("/home/mdecorde/TEMP/ANTRACT/AF/sujets.xlsx");


  		





  ......




  486
  487
  
    
		}


  		





  487
  488
  
    
		


  		





  488
  489
  
    
		System.out.println("copying column: " + columnsToCopy.size());


  		





  489
  
  
    
		// excel2.copyColumns(columnsToCopy);


  		





  
  490
  
    
		//excel2.copyColumns(columnsToCopy);


  		





  490
  491
  
    
		


  		





  491
  492
  
    
		System.out.println("search&replace column: " + searchAndReplaceRules.size());


  		





  492
  
  
    
		// excel2.searchAndReplaceInLines(searchAndReplaceRules);


  		





  
  493
  
    
		//excel2.searchAndReplaceInLines(searchAndReplaceRules);


  		





  493
  494
  
    
		


  		





  494
  495
  
    
		System.out.println("renaming column: " + columnsToRenameRules.size());


  		





  495
  496
  
    
		excel2.renameColumns(columnsToRenameRules);


  		












Formats disponibles :
  Unified diff