Creación, lectura y guardado de proyectos con Aspose.Tasks para Java

Aspose.Tasks for Java le permite trabajar con archivos de Microsoft Project (MPP/XML) sin tener instalado Microsoft Project o usar la automatización de Microsoft Office. Una API poderosa y flexible, Aspose.Tasks le ahorra tiempo y esfuerzo al brindarle las herramientas que necesita para escribir un código eficiente para manipular los archivos del proyecto.

Aspose.Tasks puede abrir archivos existentes, pero también puede crear nuevos archivos. Este artículo explica cómo crear un archivo de proyecto nuevo y vacío desde una transmisión o usar la clase Proyecto.

Creación de un archivo de proyecto vacío

La clase Proyecto es la clase principal en Aspose.Tasks utilizadas para establecer y obtener propiedades asociadas con un proyecto, así como el comportamiento. El método de guardado ofrecido por esta clase permite hacer que el proyecto a varios formatos de salida, como XML, MPP, PDF, HTML, etc., con una sola llamada API. Este método acepta una secuencia de archivo o nombre de archivo, y uno de los valores proporcionados por el tipo de enumeración de SaveFileFormat.

En la actualidad, Aspose.Tasks for Java proporciona la instalación para crear solo archivos de proyecto XML. Las siguientes líneas de código crean un archivo de proyecto simple en formato XML.

El archivo del proyecto XML se puede abrir en el proyecto Microsoft:

1. En el menú Archivo, seleccione Abrir.
2. Seleccione la opción Formato XML (*.xml) de los tipos de archivos y navegue al archivo XML de salida.
3. En el menú del proyecto, seleccione Información del proyecto.

La información del proyecto para el archivo XML de salida

Crear un proyecto vacío usando la transmisión de archivos

El ejemplo de código dado a continuación muestra cómo crear un proyecto vacío usando la transmisión de archivos con Aspose.Tasks.

// For complete examples and data files, please go to https://github.com/aspose-tasks/Aspose.Tasks-for-Java
   // The path to the documents directory.
   String dataDir = Utils.getDataDir(CreateEmptyProjectFile.class);

   //Create a project instance
   Project newProject = new Project();

   newProject.save(dataDir + "Project1.xml", SaveFileFormat.XML);

   //Display result of conversion.
   System.out.println("Project file generated Successfully");

Reading a Project File

Aspose.Tasks for Java lets you open existing files and manipulate them as well as creating new files. This topic shows how a Project file can be read using the Project class’s constructor.

The Project class constructor accepts a valid FileInputStream object or path to MPP or XML document and returns a Project object which can be used to manipulate project data.

// For complete examples and data files, please go to https://github.com/aspose-tasks/Aspose.Tasks-for-Java
   try
   {
       FileInputStream prjStream = new FileInputStream(dataDir + "Project1.mpp");
       Project existingProject = new Project(prjStream);
       prjStream.close();
       
       System.out.println("Calendar : " + existingProject.get(Prj.NAME));
   }
   catch(Exception ex)
   {
       System.out.println(ex.getMessage());
   }

Reading Project Files as a Template

Project project = new Project("d:\\Project1.mpp");

Reading Project Data from Microsoft Project Database

Aspose.Tasks for Java API now allows to read Project data from the Microsoft Project database. The SqlConnectionStringBuilder and MspDbSettings classes can be used to accomplish this purpose providing connection string settings for connection to the database.

// The path to the documents directory.
      String dataDir = Utils.getDataDir(ReadingProjectDatafromMicrosoftProjectDatabase.class);
      
String url = "jdbc:sqlserver://";
String serverName = "192.168.56.2\\MSSQLSERVER";
String portNumber = "1433";
String databaseName = "ProjectServer_Published";
String userName = "sa";
String password = "***";
MspDbSettings settings = new MspDbSettings(url+serverName+":"+portNumber+";databaseName="+databaseName+
         ";user=" + userName + ";password=" + password, UUID.fromString("E6426C44-D6CB-4B9C-AF16-48910ACE0F54"));
 
addJDBCDriver(new File("c:\\Program Files (x86)\\Microsoft JDBC Driver 4.0 for SQL Server\\sqljdbc_4.0\\enu\\sqljdbc4.jar"));
 
Project project = new Project(settings);
project.save(dataDir + "Project1.xml", SaveFileFormat.XML);

private static void addJDBCDriver(File file) throws Exception
{
    Method method = URLClassLoader.class.getDeclaredMethod("addURL", new Class[]{URL.class});
    method.setAccessible(true);
    method.invoke(ClassLoader.getSystemClassLoader(), new Object[]{file.toURI().toURL()});
}

Reading Project Data from Microsoft Access Database (MPD)

public static void main(String[] args) throws IOException {
    // For complete examples and data files, please go to https://github.com/aspose-tasks/Aspose.Tasks-for-Java
    // The path to the documents directory.
    String dataDir = Utils.getDataDir(ReadingProjectDatafromMicrosoftProjectDatabase.class);
    
    MpdSettings settings = new MpdSettings(getConnectionString(), 1);
    Project project = new Project(settings);
    project.save(dataDir + "Project1.xml", SaveFileFormat.XML);
}
    
private static String getConnectionString()
{
    return "jdbc:odbc:DRIVER=Microsoft Access Driver (*.mdb, *.accdb);DBQ=" + "mpdFile.mpd";
}

Ignoring invalid characters during loading Project

Some files may have invalid characters in the custom fields. Microsoft Project does not allow invalid character so the files have been created or manipulated with automation or some other tools. If these be loaded using the API, they may lead to an exception. In order to ignore such invalid characters, the overloaded constructor of the Project class can be used with the delegate method ParseErrorCallBack.

public static void main(String[] args) throws IOException {
    // For complete examples and data files, please go to https://github.com/aspose-tasks/Aspose.Tasks-for-Java
    
    // The path to the documents directory.
    String dataDir = Utils.getDataDir(ReadingProjectDatafromMicrosoftProjectDatabase.class);
            
    InputStream stream = null;
    try
    {
        stream = new ByteArrayInputStream(getModifiedXml().getBytes("utf-8"));
    }
    catch (UnsupportedEncodingException e)
    {
        e.printStackTrace();
    }
 
    Project project = new Project(stream, new ParseErrorCallback()
    {
        public Object invoke(Object sender, ParseErrorArgs args)
        {
            return customDurationHandler(sender, args);
        }
    });
    project.save(dataDir + "Project1.xml", SaveFileFormat.XML);
}

private static String getModifiedXml()
{
    StringBuilder xml = new StringBuilder();
 
    BufferedReader reader;
    String line;
    try
    {
        reader = new BufferedReader(new InputStreamReader(new FileInputStream("NewProductDev.xml"), "UTF8"));
        while ((line = reader.readLine()) != null)
        {
            xml.append(line).append("\n");
        }
    }
    catch (Exception e)
    {
        e.printStackTrace();
    }
 
    return xml.toString().replaceAll("PT(\\d+)H(\\d+)M(\\d+)S", "**$1Hrs$2Mins$3Secs**");
}
 
private static Object customDurationHandler(Object sender, ParseErrorArgs args)
{
    System.err.print(String.format("Object field : %s; Invalid value : %s; ", args.getFieldName(), args.getInvalidValue()));
    String duration = args.getInvalidValue().replaceAll("[*]{2}(\\d+)Hrs(\\d+)Mins(\\d+)Secs[*]{2}", "PT$1H$2M$3S");
    double newValue = Duration.parseTimeSpan(duration)*0.001/60/60;
    System.err.println(String.format("New value : %s", duration));
    Project project = new Project();
    return project.getDuration(newValue, TimeUnitType.Hour);
}

Read Password Protected Projects (2003 Format)

This topic shows how to read password protected projects in 2003 format using Aspose.Tasks for Java.

The Project class exposes the Project() constructor which is capable of reading password protected files in 2003 format. Saving a password-protected file is not supported yet.

To read a password-protected project file:

1. Load a Microsoft Project file.
2. In the constructor, provide a password as the second argument to the constructor.

The following lines of code show how to achieve this using Java.

// For complete examples and data files, please go to https://github.com/aspose-tasks/Aspose.Tasks-for-Java
   // The path to the documents directory.
   String dataDir = Utils.getDataDir(ReadPasswordProtectedFiles.class);

   Project prj = new Project(dataDir + "PassProtected2003.mpp", "pass");

   //Display result of conversion.
   System.out.println("Process completed Successfully");

The following code example demonstrates how to check if the project file is password protected.

ProjectFileInfo info = Project.getProjectFileInfo(dataDir + "project.mpp");
System.out.println("Is file password protected?:" + info.isPasswordProtected());

Reading Project Online

The ProjectServerManager class provides the methods to retrieve projects from the specified Project Online account. The ProjectServerCredentials class shall be used to provide credentials that are used to connect to Project Online. Previously, Microsoft.SharePoint.Client.Runtime assembly was used to retrieve AuthToken but now Aspose.Tasks for Java provides an option to specify SiteUrl, username, and password to create a connection to Project Online.

The following lines of code show how to read the project online.

String sharepointDomainAddress = "https://contoso.sharepoint.com";
String userName = "[e-mail]";
String password = "MyPassword";

ProjectServerCredentials credentials = new ProjectServerCredentials(sharepointDomainAddress, userName, password);
ProjectServerManager reader = new ProjectServerManager(credentials);

for (ProjectInfo p : (Iterable<ProjectInfo>)reader.getProjectList())
{
    System.out.println("Project Name:" + p.getName());
    System.out.println("Project Created Date:" + p.getCreatedDate());
    System.out.println("Project Last Saved Date:" + p.getLastSavedDate());
}

for (ProjectInfo p : (Iterable<ProjectInfo>)reader.getProjectList())
{
    Project project = reader.getProject(p.getId());
    System.out.println("Project " + p.getName() + " loaded.");
    System.out.println("Resources count:" + project.getResources().size());
}