OroCRM Forums

Covering OroCRM topics, including community updates and company announcements.

This topic contains 6 replies, has 2 voices, and was last updated by Andrey Yatsenko 4 years, 7 months ago.

Starting from March 1, 2020 the forum has been switched to the read-only mode. Please head to StackOverflow for support.

Creator
Topic
August 26, 2019 at 3:16 am #40284

eghlima.faeze
Participant
I want to export and import data into orocrm with excel. What can i do?
Creator
Topic

Viewing 6 replies - 1 through 6 (of 6 total)

Author
Replies
August 27, 2019 at 3:53 am #40289

Andrey Yatsenko
Moderator
The easiest option is to save excel file as CSV and import CSV.
To work directly with excel format you can register new import/export readers and writers, see the documentation for an example
https://oroinc.com/orocrm/doc/current/dev-guide/background-tasks/importexport#extension-of-import-export-contacts
August 27, 2019 at 4:31 am #40291

eghlima.faeze
Participant
Thank you Andrey.
September 3, 2019 at 10:00 pm #40355

eghlima.faeze
Participant
I want to know whether I have to use any Excel library like phpoffice/spreadsheet or not?
September 4, 2019 at 1:31 am #40356

Andrey Yatsenko
Moderator
There is already an integration with box/spout.
Check “Oro\Bundle\ImportExportBundle\Reader\XlsxFileReader” class and the corresponding service definition.
September 4, 2019 at 2:02 am #40358

eghlima.faeze
Participant
Is “Oro\Bundle\ImportExportBundle\Reader\XlsxFileReader” exists in version 1.9 ?
September 4, 2019 at 2:42 am #40364

Andrey Yatsenko
Moderator
No, it’s an old version that is not supported anymore, where a lot of features were not implemented yet.
Author
Replies

Viewing 6 replies - 1 through 6 (of 6 total)

The forum ‘OroCRM’ is closed to new topics and replies.

Back to top