| java.lang.Object
 salomeTMF_plug.pluginxlsxml.Import.FromExcelToXml
| FromExcelToXml | | public class FromExcelToXml (Code) | | Read a Spreadsheet having requirements and test cases, and transform them in
XML to be imported by Doc XML in SaloméTMF
author:
Jérémie DEFAYE
version:
1.0 |
| Constructor Summary | |
| public | FromExcelToXml(String fichierExcel, boolean selectionImportExigence, boolean selectionImportTest, boolean selectionImportParametre, boolean selectionImportEnvironnement, String creationCampagne, boolean selectionExecutionCampagnes)
|
| Method Summary | |
| public void | closeXmlAndXlsFiles()
| | public String | copyFileAttachements(String listePJ, String type, String exigenceLu)
| | public String | createXmlFile(String nomFichierXml)
| | void | creeCampagne(String nomCampagne, ArrayList vectorElementsofCampaign, boolean selectionImportEnvironnement)
| | void | creeCampagnes(String creationCampagne, boolean selectionImportEnvironnement)
| | public boolean | getErreurImportFichier()
| | public String | getExigenceNonTrouvePourTest()
| | public String | getFichiersNonImportes()
| | public boolean | getIsErreurTraitementImport()
| | public String | getListeCampagneNonTrouve()
| | public String | getXMLFileName()
| | public String | getXmlDir()
| | public void | litLesExecutions(int debutExecutionCampagne, int hauteurExecutionCampagne)
| | public void | litLesResultatExecutionsTests(int debutResultatExecutionCampagne, int hauteurResultatExecutionCampagne)
| | public void | litPJetURL(Element ElementAAttachements, Sheet feuilleExcel, int ligneALire, boolean presenceColonneLienHypertexte, int numeroColonneLienHypertexte, boolean presenceColonnePieceJointe, int numeroColonnePieceJointe, String repertoirePieceJointe)
| | public void | openXLSFile(String FichierExcel)
| | public void | readFamilyTest(int i)
| | public void | readRequirementTest(int debutCasDeTest, int hauteurCasDeTest)
| | public void | readXlsTableCampagnes(boolean selectionImportExigence, boolean selectionExecutionCampagnes)
| | public void | readXlsTableEnvironnement(boolean selectionImportParametre)
| | public void | readXlsTableExecutionCampagnes(String valeurNomCampagne)
| | public void | readXlsTableParametre()
| | public void | readXlsTableRequirement()
| | public void | readXlsTableTest(boolean selectionImportExigence)
| | public String | removeSpecialCharacters(String chaineAModifier)
| | String | restorePath(String path)
| | public void | testColumnsPresenceCampagnes()
| | public void | testColumnsPresenceEnvironnement()
| | public void | testColumnsPresenceExecutionCampagnes()
| | public void | testColumnsPresenceParametre()
| | public void | testColumnsPresenceRequirement()
| | public void | testColumnsPresenceTests()
| | public void | writeActionTestAuto()
| | public void | writeActionTestManuel()
| | public void | writeFamilyRequirement()
| | public void | writeFamilyTest()
| | public void | writeRequirement(boolean familleExiste, int lignePourLirePJetURL)
| | public void | writeRequirementLinkToTest()
| | public void | writeSuiteTest()
| | public void | writeTest(int lignePourLirePJetURL)
| | public void | writeTestCase(int debutCasDeTest, int hauteurCasDeTest)
| | public void | writeXmlHeading()
|
| FromExcelToXml | | public FromExcelToXml(String fichierExcel, boolean selectionImportExigence, boolean selectionImportTest, boolean selectionImportParametre, boolean selectionImportEnvironnement, String creationCampagne, boolean selectionExecutionCampagnes) throws Exception(Code) | | Read a Spreadsheet having requirements ans test cases, and transform them
in XML to be imported by Doc XML in SaloméTMF
Parameters:
selectionImportParametre - parametre case à cocher
Parameters:
selectionImportEnvironnement - parametre case à cocher
Parameters:
selectionExecutionCampagnes - parametre case à cocher
Parameters:
selectionImportExigence - parametre case à cocher
Parameters:
selectionImportTest - parametre case à cocher
Parameters:
creationCampagne - parametre case à cocher
Parameters:
fichierExcel - Name of the spreadsheet file
throws:
java.lang.Exception - Language Exception |
| closeXmlAndXlsFiles | | public void closeXmlAndXlsFiles()(Code) | | Function that close the XLS and the XML file This function tries to
delete empties spreadsheet's columns
|
| copyFileAttachements | | public String copyFileAttachements(String listePJ, String type, String exigenceLu) throws Exception(Code) | | Function that verify if attachements are accessible and copy them into a
same directory tree
Parameters:
listePJ - File
Parameters:
type - Requirement or test
Parameters:
exigenceLu - Requirement linket to file
throws:
java.lang.Exception - Language Exception New file diectory tree |
| createXmlFile | | public String createXmlFile(String nomFichierXml)(Code) | | Function that create the XML file from the name typed in the swing
component
Parameters:
nomFichierXml - Name of the XML file the real name of the created XML File |
| creeCampagne | | void creeCampagne(String nomCampagne, ArrayList vectorElementsofCampaign, boolean selectionImportEnvironnement)(Code) | | Fonction that generate acampaign
Parameters:
nomCampagne - name of campaign to create
Parameters:
vectorElementsofCampaign - vector containing all elements to create a campaign |
| creeCampagnes | | void creeCampagnes(String creationCampagne, boolean selectionImportEnvironnement)(Code) | | Fonction that generate campaigns
Parameters:
creationCampagne - type of camapaign to create |
| getErreurImportFichier | | public boolean getErreurImportFichier()(Code) | | Function that return if the transformation in a XML File was OK
boolean |
| getExigenceNonTrouvePourTest | | public String getExigenceNonTrouvePourTest()(Code) | | Function that only return the list of requirements that don't exist
list of requirements that don't exist |
| getFichiersNonImportes | | public String getFichiersNonImportes()(Code) | | Function that only return the name of the files that had not been
imported
Name of files |
| getIsErreurTraitementImport | | public boolean getIsErreurTraitementImport()(Code) | | Function that only return true if there has been an error during import
path |
| getListeCampagneNonTrouve | | public String getListeCampagneNonTrouve()(Code) | | listeCampagneNonTrouve
listeCampagneNonTrouve |
| getXMLFileName | | public String getXMLFileName()(Code) | | Function that only return the name of the XML File
Name of the XML File |
| getXmlDir | | public String getXmlDir()(Code) | | Function that only return the npath of the xlm created by this function
path |
| litLesExecutions | | public void litLesExecutions(int debutExecutionCampagne, int hauteurExecutionCampagne)(Code) | | Lit les executions des campagnes
Parameters:
debutExecutionCampagne - Début ligne
Parameters:
hauteurExecutionCampagne - nombre de lignes à lire |
| litLesResultatExecutionsTests | | public void litLesResultatExecutionsTests(int debutResultatExecutionCampagne, int hauteurResultatExecutionCampagne)(Code) | | Lit les résultats d'executions des campagnes
Parameters:
debutResultatExecutionCampagne - Début ligne
Parameters:
hauteurResultatExecutionCampagne - nombre de lignes à lire |
| litPJetURL | | public void litPJetURL(Element ElementAAttachements, Sheet feuilleExcel, int ligneALire, boolean presenceColonneLienHypertexte, int numeroColonneLienHypertexte, boolean presenceColonnePieceJointe, int numeroColonnePieceJointe, String repertoirePieceJointe)(Code) | | read url and files for all spreadsheets
Parameters:
ElementAAttachements - Element XML
Parameters:
feuilleExcel - Feuille Excel
Parameters:
ligneALire - ligne à lire
Parameters:
presenceColonneLienHypertexte - presence Colonne Lien Hypertexte
Parameters:
numeroColonneLienHypertexte - numéro Colonne Lien Hypertexte
Parameters:
presenceColonnePieceJointe - presence colonne Piece Jointe
Parameters:
numeroColonnePieceJointe - numéro colonne Piece Jointe
Parameters:
repertoirePieceJointe - Répertoire de stockage des Piece Jointe |
| openXLSFile | | public void openXLSFile(String FichierExcel)(Code) | | Function testing the presence of the XLS file and open it
Parameters:
FichierExcel - Name of the XLS File |
| readFamilyTest | | public void readFamilyTest(int i)(Code) | | read a family for a test
Parameters:
i - numbre of line read |
| readRequirementTest | | public void readRequirementTest(int debutCasDeTest, int hauteurCasDeTest)(Code) | | Read all requirements linked to a test
Parameters:
debutCasDeTest - integer
Parameters:
hauteurCasDeTest - integer |
| readXlsTableCampagnes | | public void readXlsTableCampagnes(boolean selectionImportExigence, boolean selectionExecutionCampagnes) throws Exception(Code) | | Read all the spreadsheet for the campaigns
Parameters:
selectionImportExigence - selection Import Exigence
Parameters:
selectionExecutionCampagnes - selection Execution Campagnes
throws:
java.lang.Exception - Exception |
| readXlsTableEnvironnement | | public void readXlsTableEnvironnement(boolean selectionImportParametre) throws Exception(Code) | | Read all the spreadsheet for the environments
throws:
java.lang.Exception - Null pointer exception |
| readXlsTableExecutionCampagnes | | public void readXlsTableExecutionCampagnes(String valeurNomCampagne)(Code) | | Lit la feuille executions des campagnes
Parameters:
valeurNomCampagne - Nom de la campagne |
| readXlsTableParametre | | public void readXlsTableParametre() throws Exception(Code) | | Read all the spreadsheet for the parameters
throws:
java.lang.Exception - Null pointer exception |
| readXlsTableRequirement | | public void readXlsTableRequirement() throws Exception(Code) | | Function that read each cells of the requirement spreadsheet
throws:
java.lang.Exception - Language Exception |
| readXlsTableTest | | public void readXlsTableTest(boolean selectionImportExigence) throws Exception(Code) | | Read all the spreadsheet for the test
Parameters:
selectionImportExigence - selectionImportExigence
throws:
java.lang.Exception - Exception |
| removeSpecialCharacters | | public String removeSpecialCharacters(String chaineAModifier)(Code) | | Modify a string to pass spécial characters like quote
Parameters:
chaineAModifier - A string for argument A string |
| testColumnsPresenceCampagnes | | public void testColumnsPresenceCampagnes()(Code) | | Function that Verify the presence of parameters columns in the paremeter spreadsheet
|
| testColumnsPresenceEnvironnement | | public void testColumnsPresenceEnvironnement()(Code) | | Function that Verify the presence of environments columns in the enviroment spreadsheet
|
| testColumnsPresenceExecutionCampagnes | | public void testColumnsPresenceExecutionCampagnes()(Code) | | Function that Verify the presence of Execution campaigns columns in the Execution campaign spreadsheet
|
| testColumnsPresenceParametre | | public void testColumnsPresenceParametre()(Code) | | Function that Verify the presence of parameters columns in the paremeter spreadsheet
|
| testColumnsPresenceRequirement | | public void testColumnsPresenceRequirement()(Code) | | Function that verify the presence of requirement columns in the
requirement spreadsheet
|
| testColumnsPresenceTests | | public void testColumnsPresenceTests()(Code) | | Function that Verify the presence of test columns in the test spreadsheet
|
| writeActionTestAuto | | public void writeActionTestAuto()(Code) | | Write automatic tests
|
| writeActionTestManuel | | public void writeActionTestManuel()(Code) | | Write one action for a test
|
| writeFamilyRequirement | | public void writeFamilyRequirement()(Code) | | Function that write a family Requirement in the XML File
|
| writeFamilyTest | | public void writeFamilyTest()(Code) | | Function that write a family test in the XML File
|
| writeRequirement | | public void writeRequirement(boolean familleExiste, int lignePourLirePJetURL)(Code) | | Function that write a Requirement in the XML File
Parameters:
lignePourLirePJetURL - lignePourLirePJetURL
Parameters:
familleExiste - boolean |
| writeRequirementLinkToTest | | public void writeRequirementLinkToTest()(Code) | | Write a requirement linked to a test
|
| writeSuiteTest | | public void writeSuiteTest()(Code) | | write suite test
|
| writeTest | | public void writeTest(int lignePourLirePJetURL)(Code) | | Function that write a test in the XML File
Parameters:
lignePourLirePJetURL - lignePourLirePJetURL |
| writeTestCase | | public void writeTestCase(int debutCasDeTest, int hauteurCasDeTest)(Code) | | Write a coplete test case
Parameters:
debutCasDeTest - Integer
Parameters:
hauteurCasDeTest - Integer |
| writeXmlHeading | | public void writeXmlHeading()(Code) | | Function that write the XML Heading (common to every XML files)
|
|
|