Data Management (Import) Excel

StatusIDPriorityType
Closed39668MajorQuestion
ProfileReply
NielClient

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

Replies

UserDescriptionPosted On
MariyaVoytovichAgent

Hello!

You mean importing objects with many to many relationship?

Regards,
Mariya
On behalf of Xafari Client Services Team

NielClient

Yes

MariyaVoytovichAgent

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

NielClient

Thank you!

MariyaVoytovichAgent

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

NielClient

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

NielClient

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

NielClient

Does 20.2.5011.2285 have the fix?

MariyaVoytovichAgent

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:
NielClient

Thank you!

× This ticket is closed.

Write US