Finance | Project Operations, Human Resources, ...

Can you create an import from a zip file?

(0) Share

Report

Posted on by AstridMalanka

Hi,

I was asked to create an import data package, which is supposed to be a zip file that contains many excels inside to load.

I am not sure how to do that, and I can't find anything online.

When I add a file, I need to add an entity destination, but if it is a zip file that contains many entities destination, I have no clue how to do it, and how to arrange the loading order.

Can someone please clarify?

Thanks

Astrid

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Suggested answer

saurabh bharti 15,059 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

Why can't you add multiple entities and upload all the files against each data entity.

After that on import package you can setup sequence for import.

Was this reply helpful? Yes No
huijij 19,813 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Please go through the MS document for Importing a data package and setup sequence:

import a data package

regards

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 306,703 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi Astrid,

You can create a new Import project. When adding a file/entity, you can just upload the file. It will be recognized as a package and all the entities will be added automatically in the project.

Was this reply helpful? Yes No
AstridMalanka 8 on at

Like (0)

Report
Copy link

Link copied!

I am still very confused.

I added three excels for the testing and I try to add it as a package. but I got the following error when trying to add the zip file

Could not find file 'C:\Users\ContainerAdministrator\AppData\Local\Temp\xxxxxxx\PackageHeader.xml'.

Was this reply helpful? Yes No
Martin Dráb 240,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

The package indeed must contain more than just data files. It needs complete information about the data project, such as the order of import and file mapping. You can easily create such a package by creating an export project (with the entities you want), exporting it and downloading the package. Then you can unzip it, modify files, zip it again and import.

It's also possible to generate a package by yourself, because all you need to do is adding two XML files, which isn't technically difficult. But you must somewhere take the information about the order of files and field mapping. I've done it before - we were creating packages based on database views with field names exactly matching entity fields (which made mapping trivial) and based on configuration files (defining the order of files, the company to import to etc.).

Was this reply helpful? Yes No
Suggested answer

huijij 19,813 on at

Like (0)

Report
Copy link

Link copied!

The error happens when the Zip package does not have the correct format.

community.dynamics.com/.../how-to-resolve-issues-related-to-attachment-import-process-in-dynamics-365-finance-and-operations

regards

Was this reply helpful? Yes No