Finance | Project Operations, Human Resources, ...

Can you create an import from a zip file?

(0) Share

Report

Posted on by AstridMalanka

449

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

All responses (6)

Answers (0)

Suggested answer

huijij 19,811 on at

Like (0)

Report

RE: Can you create an import from a zip file?

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
Martin Dráb 230,445 Most Valuable Professional on at

Like (0)

Report

RE: Can you create an import from a zip file?

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.).
AstridMalanka 449 on at

Like (0)

Report

RE: Can you create an import from a zip file?

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'.
Suggested answer

André Arnaud de Cal... 291,391 Super User 2024 Season 2 on at

Like (0)

Report

RE: Can you create an import from a zip file?

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.
huijij 19,811 on at

Like (0)

Report

RE: Can you create an import from a zip file?

Hi,

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

import a data package

regards
Suggested answer

saurabh bharti 15,039 Super User 2024 Season 2 on at

Like (0)

Report

RE: Can you create an import from a zip file?

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.