Finance | Project Operations, Human Resources, ...

I like to export Vendor master data through DMF data project using X++

(1) Share

Report

Posted on by @rp@n

5,935

Hi All,

I like to Export Vendor master data through DMF data project using X++.

I mean, end user like to click on menu item, then it should generate a data project for Vendor and from there they will download the excel file.

theses entire process needs to do in code.

can anyone please give me a reference please.

Thanks!

Categories:

Dynamics 365 Finance

All responses (5)

Answers (0)

@rp@n 5,935 on at

Like (0)

Report

I like to export Vendor master data through DMF data project using X++

Hi Martin , Mohamed

Can I use the below code for my requirement

It is customer master but I like to use for Vendor

class CustomerMasterExportJob
{
public static void main(Args _args)
{
DataManagementDefinitionGroupExecution definitionGroupExecution;
DataManagementDefinitionGroupEntity definitionGroupEntity;
DMFDefinitionGroup definitionGroup;
DataProjectExecutionId executionId;
DataProjectName projectName = 'CustomerMasterExportProject';
DataEntityName entityName = 'CustCustomerDataStorageEntity'; // Entity name for export
Filename filePath, fileName;
Container fileContents;

try
{
// Step 1: Create a new Data Project
ttsBegin;
definitionGroup = DMFDefinitionGroup::construct();
definitionGroup.DefinitionGroupName = projectName;
definitionGroup.Description = "Customer Master Export Project";
definitionGroup.IsShared = NoYes::No; // Private to the environment
definitionGroup.insert();

// Step 2: Add entity to the project
definitionGroupEntity = DMFDefinitionGroupEntity::construct(definitionGroup.DefinitionGroupName, entityName);
definitionGroupEntity.InsertSeq = 1;
definitionGroupEntity.TargetEntityName = entityName;
definitionGroupEntity.insert();
ttsCommit;

// Step 3: Execute the data export
executionId = DMFExecutionHelper::generateExecutionId();
definitionGroupExecution = DataManagementDefinitionGroupExecution::construct();
definitionGroupExecution.run(projectName, executionId, DataManagementTaskExecutionMode::Sequential, null);

// Wait for completion
while (!definitionGroupExecution.isExecutionCompleted())
{
pause(2000); // Check every 2 seconds
}

// Step 4: Generate the export file
filePath = DataManagementDefinitionGroupExecution::generateExportFile(definitionGroup.DefinitionGroupName, executionId);

if (filePath)
{
// Step 5: Read the file contents
fileContents = SysOperationStorage::getFile(filePath);

// Step 6: Send the file to the user for download
fileName = 'CustomerMasterData.zip'; // Desired file name
File::SendFileToUser(fileContents, fileName, "application/zip");
info("Export file has been downloaded successfully.");
}
else
{
error("Failed to generate the export file.");
}
}
catch (Exception::Error)
{
error("An error occurred during the export process: " + AifUtil::getErrorMessage());
}
}
}

Note - Not yet executed the code.
@rp@n 5,935 on at

Like (0)

Report

I like to export Vendor master data through DMF data project using X++

Thanks Martin for the response

Will update the same, if I faced any issue.
Martin Dráb 230,407 Most Valuable Professional on at

Like (1)

Report

I like to export Vendor master data through DMF data project using X++

X++ code runs on a web server in Azure and it can't connect to users' machines and meddle with their files.

What you could do is to give users the file for download (with File::sendFileToUser()) and if they have their browsers configured to automatically download files to the Download folder, it'll happen.

Or you'll need a completely different architecture, e.g. saving the file to Azure file share (that users may have mapped as a drive), using Recurring Integration Scheduler running in user's local network or something.
@rp@n 5,935 on at

Like (0)

Report

I like to export Vendor master data through DMF data project using X++

Thanks Mohamed,

One thing I forgot to tell. When execution is completed, the data project should download in local machine under download folder.

From there they will take the data project and excel file to proceed further.

How I can do the same through x++ while exporting the customer.

Kindly advise please
Suggested answer

Mohamed Amine Mahmoudi 9,782 Super User 2024 Season 2 on at

Like (0)

Report

I like to export Vendor master data through DMF data project using X++

Hi @@rp@n,

Functionally, you can export the list of suppliers without using x++ code.

https://dynamics365musings.com/export-data-to-excel-in-d365/

If you insist on doing it in the x++ code, you can refer to this link.

https://sunkuaxian.wordpress.com/2019/10/09/export-composite-data-entity-through-x-in-d365-fo/

Best regards,

Mohamed Amine MAHMOUDI