Проекты импорта и экспорта в формат Primavera

Собственное обменное формат Primavera (XER) от Primavera Systems, Inc. в первую очередь связан с управлением проектами Primavera. Aspose.Tasks для Java предоставляет возможность экспортировать данные проекта Microsoft в форматы Primavera Xer и XML. Эта статья показывает, как экспортировать данные проекта в обе эти форматы.

Импорт данных из файла Primavera

Импорт данных из формата Primavera XML

Aspose.Tasks может импортировать * primavera * xml аналогично форматам Microsoft Project XML и MPP. Класс проекта предоставляет возможность загружать такой тип файла с использованием того же конструктора, что и для других файлов проекта.

// 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(ImportExportDataToPrimavera.class);
Project project = new Project(dataDir + "Primavera1.xml");
// read the project structure
ProjectFileInfo info = Project.getProjectFileInfo("primavera1.xml");
System.out.println(info.getProjectFileFormat());

Importing Data from Primavera MPX File Format

// 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(ImportExportDataToPrimavera.class);
Project project = new Project(dataDir +"Primavera1.mpx");
// read the project structure
ProjectFileInfo info = Project.getProjectFileInfo("primavera1.mpx");
System.out.println(info.getProjectFileFormat());

Reading Project UIDs from Primavera XML file

A Primavera XML file may contain multiple projects, each having its own UID. Aspose.Tasks for Java API provides the capability to read all such UIDs from the project and then load a project using a specific id from the list of UIDs.

// For complete examples and data files, please go to https://github.com/aspose-tasks/Aspose.Tasks-for-Java
PrimaveraXmlReader reader = new PrimaveraXmlReader("primaveraXml.xml");
List<Integer> listOpProjectUids = reader.getProjectUids();

Reading Primavera XML file with Multiple Projects

// For complete examples and data files, please go to https://github.com/aspose-tasks/Aspose.Tasks-for-Java
PrimaveraXmlReadingOptions options = new PrimaveraXmlReadingOptions();
options.setProjectUid(4557);
// returns project with special Uid
Project project = new Project("PrimaveraXmlFile.xml",options); 

Importing Project Data from Primavera Database File

String url = "jdbc:sqlserver://";
String serverName = "192.168.56.3\\MSSQLSERVER";
String portNumber = "1433";
String databaseName = "PrimaveraEDB";
String userName = "privuser";
String password = "***";
PrimaveraDbSettings settings = new PrimaveraDbSettings(url+serverName + ":" + portNumber + ";databaseName=" + databaseName + ";user=" + userName + ";password=" + password, 4502);
// set driver name
settings.setDriverClassName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
// note that you have to set the classpath to include the sqljdbc.jar file or the sqljdbc4.jar file, otherwise  "Class not found" exception will be thrown
// here we add classpath dynamically just for testing needs:
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);
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()});
}

Support for SQLite Database

const string connectionString = "Data Source=d:\\DB\\PPMDBSQLite.db";
const int projectId = 4502;
PrimaveraDbSettings primaveraDbSettings = new PrimaveraDbSettings(connectionString, projectId);
primaveraDbSettings.setProviderInvariantName("System.Data.SQLite");
Project project = new Project(primaveraDbSettings);

Exporting Project Data in Primavera Formats

The SaveFileFormat enumerator is used to specify the project export type as Primavera XML or XER.

Exporting Project Data to Primavera XML Format

// 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(ImportExportDataToPrimavera.class);
Project project = new Project(dataDir + "Project.mpp");
project.save(dataDir + "saved.xml", SaveFileFormat.PrimaveraP6XML);

Exporting Project Data to Primavera XER Format

// 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(ImportExportDataToPrimavera.class);
Project project = new Project(dataDir + "Project.mpp");
project.save(dataDir + "saved.xer", SaveFileFormat.PrimaveraXER);

Exporting Project Data to Primavera MPX Format

// 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(ImportExportDataToPrimavera.class);
Project project = new Project(dataDir + "Project.mpp");
project.save(dataDir + "saved.mpx", SaveFileFormat.MPX);

Primavera XML Save Options

If Primavera XML file doesn’t has any WBS inside (only Activities), Aspose.Tasks can’t read properly this type of file, because the API needs a root task to create a tree of tasks. In this case, the API creates a RootTask, even if it doesn’t exist in the file, to be able to read these particular files. If the user wants to save after reading, it’ll be saving with created RootTask, which did not exist before reading. This option helps to decide how to save into the file - with created RootTask or not. By default, it set to true.

// For complete examples and data files, please go to https://github.com/aspose-tasks/Aspose.Tasks-for-Java
Project project = new Project("test.xml");
PrimaveraXmlSaveOptions options = new PrimaveraXmlSaveOptions();
options.setSaveRootTask(false);
project.save("test1.xml",options);