Data Management (Import) Excel

StatusIDPriorityType
Closed39668MajorQuestion
Profile Reply
Niel Client

Do you have an example of importing data from Excel with an association table?

Replies

User Description Posted On
MariyaVoytovich Agent

Hello!

You mean importing objects with many to many relationship?

Regards,
Mariya
On behalf of Xafari Client Services Team

Niel Client

Yes

MariyaVoytovich Agent

Hello!

Unfortunately we do not have a ready-made example of such an import.
But we will make an example for you.
We need time.

Regards,
Mariya
On behalf of Xafari Client Services Team

Niel Client

Thank you!

MariyaVoytovich Agent

Hello!

Unfortunately, while preparing the example, we encountered a small error while importing data.
We are already working on fixing this error. This will take some time.

If you really need this part of the Xafari functional,
We can provide you an example that will import data and "work around" this error.

Regards,
Mariya
On behalf of Xafari Client Services Team

Niel Client

On my current project I should have time to wait for the fix.

Niel Client

On my current project I should have time to wait for the fix.

Niel Client

Does 20.2.5011.2285 have the fix?

MariyaVoytovich Agent

Hello!

Yes, we fixed a bug in the Xafari 20.2.5011.2285.

The attached files contain a project ImportDataFromExcel that demonstrates the work of export and import operations.

You can run it and see how it works.

Import and export operations are demonstrated in the controller ImportExportDataViewController(ImportDataFromExcel.Module project).
This controller has two actions: ExportDataToExcel action and ImportDataFromExcel action.
Also in the ImportDataFromExcel.Module project there are data import and export settings files: Demo_ExportSettings.xml and Demo_ImportSettings.xml.
They are located in the ImportExportData folder. In this folder located TestImportExcel file from which data is imported when the ImportDataFromExcel action is executed.

Feel free to contact us if you need further assistance or have additional questions.

Regards,
Mariya
On behalf of Xafari Client Services Team

Attached files:
Niel Client

Thank you!

× This ticket is closed.

Write US