salomeTMF_plug.pluginxlsxml.Import
Class FromExcelToXml

java.lang.Object
  extended by salomeTMF_plug.pluginxlsxml.Import.FromExcelToXml

Deprecated. no

public class FromExcelToXml
extends java.lang.Object

Read a Spreadsheet having requirements and test cases, and transform them in XML to be imported by Doc XML in SalomeTMF

Version:
1.0
Author:
Jeremie DEFAYE

Constructor Summary
FromExcelToXml(java.lang.String fichierExcel, boolean selectionImportExigence, boolean selectionImportTest, boolean selectionImportParametre, boolean selectionImportEnvironnement, java.lang.String creationCampagne, boolean selectionExecutionCampagnes, boolean selectionAssociationExigencesSalome, org.objectweb.salome_tmf.plugins.IPlugObject vt)
          Deprecated. Read a Spreadsheet having requirements ans test cases, and transform them in XML to be imported by Doc XML in SalomeTMF
 
Method Summary
 void closeXmlAndXlsFiles()
          Deprecated. Function that close the XLS and the XML file This function tries to delete empties spreadsheet's columns
 java.lang.String copyFileAttachements(java.lang.String listePJ, java.lang.String type, java.lang.String exigenceLu)
          Deprecated. Function that verify if attachements are accessible and copy them into a same directory tree
 java.lang.String createXmlFile(java.lang.String nomFichierXml)
          Deprecated. Function that create the XML file from the name typed in the swing component
 javax.swing.tree.DefaultMutableTreeNode getChosenRoot()
          Deprecated. Get chosenRoot
 boolean getErreurImportFichier()
          Deprecated. Function that return if the transformation in a XML File was OK
 java.lang.String getExigenceNonTrouvePourTest()
          Deprecated. Function that only return the list of requirements that don't exist
 boolean getExigenceSelection()
          Deprecated. Return true si case a cocher Exigence est selectionnee
 java.util.ArrayList getFamilySelectionList()
          Deprecated. Get familySelectionList
 java.lang.String getFichiersNonImportes()
          Deprecated. Function that only return the name of the files that had not been imported
 boolean getIsErreurTraitementImport()
          Deprecated. Function that only return true if there has been an error during import
 java.lang.String getListeCampagneNonTrouve()
          Deprecated. listeCampagneNonTrouve
 java.util.ArrayList getSuiteSelectionList()
          Deprecated. Get suiteSelectionList
 boolean getTestSelection()
          Deprecated. Return true si case a cocher tests est selectionnee
 java.util.ArrayList getTestSelectionList()
          Deprecated. Get testSelectionList
 java.lang.String getXmlDir()
          Deprecated. Function that only return the npath of the xlm created by this function
 java.lang.String getXMLFileName()
          Deprecated. Function that only return the name of the XML File
 boolean isInitSelection()
          Deprecated. Get isInitSelection
 void litLesExecutions(int debutExecutionCampagne, int hauteurExecutionCampagne)
          Deprecated. Lit les executions des campagnes
 void litLesResultatExecutionsTests(int debutResultatExecutionCampagne, int hauteurResultatExecutionCampagne)
          Deprecated. Lit les resultats d'executions des campagnes
 void litPJetURL(org.dom4j.Element ElementAAttachements, jxl.Sheet feuilleExcel, int ligneALire, boolean presenceColonneLienHypertexte, int numeroColonneLienHypertexte, boolean presenceColonnePieceJointe, int numeroColonnePieceJointe, java.lang.String repertoirePieceJointe)
          Deprecated. read url and files for all spreadsheets
 void openXLSFile(java.lang.String FichierExcel)
          Deprecated. Function testing the presence of the XLS file and open it
 void readFamilyTest(int i)
          Deprecated. read a family for a test
 void readRequirementTest(int debutCasDeTest, int hauteurCasDeTest)
          Deprecated. Read all requirements linked to a test
 void readXlsTableCampagnes(boolean selectionImportExigence, boolean selectionImportParametre, boolean selectionExecutionCampagnes)
          Deprecated. Read all the spreadsheet for the campaigns
 void readXlsTableEnvironnement(boolean selectionImportParametre, boolean selectionImportTest)
          Deprecated. Read all the spreadsheet for the environments
 void readXlsTableExecutionCampagnes(java.lang.String valeurNomCampagne)
          Deprecated. Lit la feuille executions des campagnes
 void readXlsTableParametre()
          Deprecated. Read all the spreadsheet for the parameters
 void readXlsTableRequirement()
          Deprecated. Function that read each cells of the requirement spreadsheet
 void readXlsTableTest(boolean selectionImportExigence, boolean selectionAssociationExigencesSalome, boolean selectionImportParametre)
          Deprecated. Read all the spreadsheet for the test
 java.lang.String RemiseEnFormeDescription(java.lang.String valeurDescription)
          Deprecated. Permet d'enlever les espaces en trop d'une chaine de caracteres pour la cellule Description
 java.lang.String removeSpecialCharacters(java.lang.String chaineAModifier)
          Deprecated. Modify a string to pass special characters like quote
 void setChosenRoot(javax.swing.tree.DefaultMutableTreeNode chosenRoot)
          Deprecated. Set chosenRoot
 void setFamilySelectionList(java.util.ArrayList familySelectionList)
          Deprecated. Set familySelectionList
 void setInitSelection(boolean initSelection)
          Deprecated. Set isInitSelection
 void setSuiteSelectionList(java.util.ArrayList suiteSelectionList)
          Deprecated. Set suiteSelectionList
 void setTestSelectionList(java.util.ArrayList testSelectionList)
          Deprecated. Set testSelectionList
 void testColumnsPresenceCampagnes()
          Deprecated. Function that Verify the presence of parameters columns in the paremeter spreadsheet
 void testColumnsPresenceEnvironnement()
          Deprecated. Function that Verify the presence of environments columns in the enviroment spreadsheet
 void testColumnsPresenceExecutionCampagnes()
          Deprecated. Function that Verify the presence of Execution campaigns columns in the Execution campaign spreadsheet
 void testColumnsPresenceParametre()
          Deprecated. Function that Verify the presence of parameters columns in the paremeter spreadsheet
 void testColumnsPresenceRequirement()
          Deprecated. Function that verify the presence of requirement columns in the requirement spreadsheet
 void testColumnsPresenceTests()
          Deprecated. Function that Verify the presence of test columns in the test spreadsheet
 void updateRequirementList(org.objectweb.salome_tmf.plugins.IPlugObject pIPlugObject)
          Deprecated.  
 void writeActionTestAuto()
          Deprecated. Write automatic tests
 void writeActionTestManuel()
          Deprecated. Write one action for a test
 void writeFamilyRequirement(java.lang.String familleEnCours2)
          Deprecated. Function that write a family Requirement in the XML File
 void writeFamilyTest()
          Deprecated. Function that write a family test in the XML File
 void writeRequirement(boolean familleExiste, java.lang.String exigenceLu, int lignePourLirePJetURL)
          Deprecated. Function that write a Requirement in the XML File
 void writeRequirementLinkToTest()
          Deprecated. Write a requirement linked to a test
 void WriteRequirementsFromSalome()
          Deprecated. Function that write requirements read in SalomeTMF
 void writeSuiteTest()
          Deprecated. write suite test
 void writeTest(int lignePourLirePJetURL)
          Deprecated. Function that write a test in the XML File
 void writeTestCase(int debutCasDeTest, int hauteurCasDeTest)
          Deprecated. Write a coplete test case
 void writeXmlHeading()
          Deprecated. Function that write the XML Heading (common to every XML files)
 
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

FromExcelToXml

public FromExcelToXml(java.lang.String fichierExcel,
                      boolean selectionImportExigence,
                      boolean selectionImportTest,
                      boolean selectionImportParametre,
                      boolean selectionImportEnvironnement,
                      java.lang.String creationCampagne,
                      boolean selectionExecutionCampagnes,
                      boolean selectionAssociationExigencesSalome,
                      org.objectweb.salome_tmf.plugins.IPlugObject vt)
               throws java.lang.Exception
Deprecated. 
Read a Spreadsheet having requirements ans test cases, and transform them in XML to be imported by Doc XML in SalomeTMF

Parameters:
selectionImportParametre - parametre case a cocher
selectionImportEnvironnement - parametre case a cocher
selectionExecutionCampagnes - parametre case a cocher
selectionImportExigence - parametre case a cocher
selectionImportTest - parametre case a cocher
creationCampagne - parametre case a cocher
fichierExcel - Name of the spreadsheet file
Throws:
java.lang.Exception - Language Exception
Method Detail

WriteRequirementsFromSalome

public void WriteRequirementsFromSalome()
                                 throws java.lang.Exception
Deprecated. 
Function that write requirements read in SalomeTMF

Throws:
java.lang.Exception - Language Exception

updateRequirementList

public void updateRequirementList(org.objectweb.salome_tmf.plugins.IPlugObject pIPlugObject)
                           throws org.dom4j.DocumentException
Deprecated. 
Throws:
org.dom4j.DocumentException

litLesExecutions

public void litLesExecutions(int debutExecutionCampagne,
                             int hauteurExecutionCampagne)
Deprecated. 
Lit les executions des campagnes

Parameters:
debutExecutionCampagne - Debut ligne
hauteurExecutionCampagne - nombre de lignes a lire

litLesResultatExecutionsTests

public void litLesResultatExecutionsTests(int debutResultatExecutionCampagne,
                                          int hauteurResultatExecutionCampagne)
Deprecated. 
Lit les resultats d'executions des campagnes

Parameters:
debutResultatExecutionCampagne - Debut ligne
hauteurResultatExecutionCampagne - nombre de lignes a lire

readXlsTableExecutionCampagnes

public void readXlsTableExecutionCampagnes(java.lang.String valeurNomCampagne)
Deprecated. 
Lit la feuille executions des campagnes

Parameters:
valeurNomCampagne - Nom de la campagne

testColumnsPresenceExecutionCampagnes

public void testColumnsPresenceExecutionCampagnes()
Deprecated. 
Function that Verify the presence of Execution campaigns columns in the Execution campaign spreadsheet


litPJetURL

public void litPJetURL(org.dom4j.Element ElementAAttachements,
                       jxl.Sheet feuilleExcel,
                       int ligneALire,
                       boolean presenceColonneLienHypertexte,
                       int numeroColonneLienHypertexte,
                       boolean presenceColonnePieceJointe,
                       int numeroColonnePieceJointe,
                       java.lang.String repertoirePieceJointe)
Deprecated. 
read url and files for all spreadsheets

Parameters:
ElementAAttachements - Element XML
feuilleExcel - Feuille Excel
ligneALire - ligne a lire
presenceColonneLienHypertexte - presence Colonne Lien Hypertexte
numeroColonneLienHypertexte - numero Colonne Lien Hypertexte
presenceColonnePieceJointe - presence colonne Piece Jointe
numeroColonnePieceJointe - numero colonne Piece Jointe
repertoirePieceJointe - Repertoire de stockage des Piece Jointe

readXlsTableCampagnes

public void readXlsTableCampagnes(boolean selectionImportExigence,
                                  boolean selectionImportParametre,
                                  boolean selectionExecutionCampagnes)
                           throws java.lang.Exception
Deprecated. 
Read all the spreadsheet for the campaigns

Parameters:
selectionImportExigence - selection Import Exigence
selectionExecutionCampagnes - selection Execution Campagnes
Throws:
java.lang.Exception - Exception

testColumnsPresenceCampagnes

public void testColumnsPresenceCampagnes()
Deprecated. 
Function that Verify the presence of parameters columns in the paremeter spreadsheet


readXlsTableEnvironnement

public void readXlsTableEnvironnement(boolean selectionImportParametre,
                                      boolean selectionImportTest)
                               throws java.lang.Exception
Deprecated. 
Read all the spreadsheet for the environments

Throws:
java.lang.Exception - Null pointer exception

testColumnsPresenceEnvironnement

public void testColumnsPresenceEnvironnement()
Deprecated. 
Function that Verify the presence of environments columns in the enviroment spreadsheet


readXlsTableParametre

public void readXlsTableParametre()
                           throws java.lang.Exception
Deprecated. 
Read all the spreadsheet for the parameters

Throws:
java.lang.Exception - Null pointer exception

testColumnsPresenceParametre

public void testColumnsPresenceParametre()
Deprecated. 
Function that Verify the presence of parameters columns in the paremeter spreadsheet


writeTest

public void writeTest(int lignePourLirePJetURL)
Deprecated. 
Function that write a test in the XML File

Parameters:
lignePourLirePJetURL - lignePourLirePJetURL

writeActionTestAuto

public void writeActionTestAuto()
Deprecated. 
Write automatic tests


writeActionTestManuel

public void writeActionTestManuel()
Deprecated. 
Write one action for a test


writeRequirementLinkToTest

public void writeRequirementLinkToTest()
Deprecated. 
Write a requirement linked to a test


writeFamilyTest

public void writeFamilyTest()
Deprecated. 
Function that write a family test in the XML File


writeSuiteTest

public void writeSuiteTest()
Deprecated. 
write suite test


readFamilyTest

public void readFamilyTest(int i)
Deprecated. 
read a family for a test

Parameters:
i - numbre of line read

readRequirementTest

public void readRequirementTest(int debutCasDeTest,
                                int hauteurCasDeTest)
Deprecated. 
Read all requirements linked to a test

Parameters:
debutCasDeTest - integer
hauteurCasDeTest - integer

readXlsTableTest

public void readXlsTableTest(boolean selectionImportExigence,
                             boolean selectionAssociationExigencesSalome,
                             boolean selectionImportParametre)
                      throws java.lang.Exception
Deprecated. 
Read all the spreadsheet for the test

Parameters:
selectionImportExigence - selectionImportExigence
Throws:
java.lang.Exception - Exception

writeTestCase

public void writeTestCase(int debutCasDeTest,
                          int hauteurCasDeTest)
Deprecated. 
Write a coplete test case

Parameters:
debutCasDeTest - Integer
hauteurCasDeTest - Integer

testColumnsPresenceTests

public void testColumnsPresenceTests()
Deprecated. 
Function that Verify the presence of test columns in the test spreadsheet


writeFamilyRequirement

public void writeFamilyRequirement(java.lang.String familleEnCours2)
Deprecated. 
Function that write a family Requirement in the XML File


writeRequirement

public void writeRequirement(boolean familleExiste,
                             java.lang.String exigenceLu,
                             int lignePourLirePJetURL)
Deprecated. 
Function that write a Requirement in the XML File

Parameters:
lignePourLirePJetURL - lignePourLirePJetURL
familleExiste - boolean
exigenceLu - string
descriptionLu - string

readXlsTableRequirement

public void readXlsTableRequirement()
                             throws java.lang.Exception
Deprecated. 
Function that read each cells of the requirement spreadsheet

Throws:
java.lang.Exception - Language Exception

testColumnsPresenceRequirement

public void testColumnsPresenceRequirement()
Deprecated. 
Function that verify the presence of requirement columns in the requirement spreadsheet


writeXmlHeading

public void writeXmlHeading()
Deprecated. 
Function that write the XML Heading (common to every XML files)


createXmlFile

public java.lang.String createXmlFile(java.lang.String nomFichierXml)
Deprecated. 
Function that create the XML file from the name typed in the swing component

Parameters:
nomFichierXml - Name of the XML file
Returns:
the real name of the created XML File

openXLSFile

public void openXLSFile(java.lang.String FichierExcel)
Deprecated. 
Function testing the presence of the XLS file and open it

Parameters:
FichierExcel - Name of the XLS File

closeXmlAndXlsFiles

public void closeXmlAndXlsFiles()
Deprecated. 
Function that close the XLS and the XML file This function tries to delete empties spreadsheet's columns


getFichiersNonImportes

public java.lang.String getFichiersNonImportes()
Deprecated. 
Function that only return the name of the files that had not been imported

Returns:
Name of files

getXmlDir

public java.lang.String getXmlDir()
Deprecated. 
Function that only return the npath of the xlm created by this function

Returns:
path

getIsErreurTraitementImport

public boolean getIsErreurTraitementImport()
Deprecated. 
Function that only return true if there has been an error during import

Returns:
path

getXMLFileName

public java.lang.String getXMLFileName()
Deprecated. 
Function that only return the name of the XML File

Returns:
Name of the XML File

getExigenceNonTrouvePourTest

public java.lang.String getExigenceNonTrouvePourTest()
Deprecated. 
Function that only return the list of requirements that don't exist

Returns:
list of requirements that don't exist

getListeCampagneNonTrouve

public java.lang.String getListeCampagneNonTrouve()
Deprecated. 
listeCampagneNonTrouve

Returns:
listeCampagneNonTrouve

getErreurImportFichier

public boolean getErreurImportFichier()
Deprecated. 
Function that return if the transformation in a XML File was OK

Returns:
boolean

copyFileAttachements

public java.lang.String copyFileAttachements(java.lang.String listePJ,
                                             java.lang.String type,
                                             java.lang.String exigenceLu)
                                      throws java.lang.Exception
Deprecated. 
Function that verify if attachements are accessible and copy them into a same directory tree

Parameters:
listePJ - File
type - Requirement or test
exigenceLu - Requirement linket to file
Returns:
New file diectory tree
Throws:
java.lang.Exception - Language Exception

removeSpecialCharacters

public java.lang.String removeSpecialCharacters(java.lang.String chaineAModifier)
Deprecated. 
Modify a string to pass special characters like quote

Parameters:
chaineAModifier - A string for argument
Returns:
A string

getChosenRoot

public javax.swing.tree.DefaultMutableTreeNode getChosenRoot()
Deprecated. 
Get chosenRoot

Returns:
Returns the chosenRoot.

setChosenRoot

public void setChosenRoot(javax.swing.tree.DefaultMutableTreeNode chosenRoot)
Deprecated. 
Set chosenRoot

Parameters:
chosenRoot - The chosenRoot to set.

getFamilySelectionList

public java.util.ArrayList getFamilySelectionList()
Deprecated. 
Get familySelectionList

Returns:
Returns the familySelectionList.

setFamilySelectionList

public void setFamilySelectionList(java.util.ArrayList familySelectionList)
Deprecated. 
Set familySelectionList

Parameters:
familySelectionList - The familySelectionList to set.

getSuiteSelectionList

public java.util.ArrayList getSuiteSelectionList()
Deprecated. 
Get suiteSelectionList

Returns:
Returns the suiteSelectionList.

setSuiteSelectionList

public void setSuiteSelectionList(java.util.ArrayList suiteSelectionList)
Deprecated. 
Set suiteSelectionList

Parameters:
suiteSelectionList - The suiteSelectionList to set.

getTestSelectionList

public java.util.ArrayList getTestSelectionList()
Deprecated. 
Get testSelectionList

Returns:
Returns the testSelectionList.

setTestSelectionList

public void setTestSelectionList(java.util.ArrayList testSelectionList)
Deprecated. 
Set testSelectionList

Parameters:
testSelectionList - The testSelectionList to set.

isInitSelection

public boolean isInitSelection()
Deprecated. 
Get isInitSelection

Returns:
Returns the isInitSelection.

getTestSelection

public boolean getTestSelection()
Deprecated. 
Return true si case a cocher tests est selectionnee

Returns:
true

getExigenceSelection

public boolean getExigenceSelection()
Deprecated. 
Return true si case a cocher Exigence est selectionnee

Returns:
isSelectionExportExigence

setInitSelection

public void setInitSelection(boolean initSelection)
Deprecated. 
Set isInitSelection

Parameters:
initSelection - initSelection

RemiseEnFormeDescription

public java.lang.String RemiseEnFormeDescription(java.lang.String valeurDescription)
Deprecated. 
Permet d'enlever les espaces en trop d'une chaine de caracteres pour la cellule Description

Parameters:
valeurDescription - chaine a modifier
Returns:
chaine modifiee