PHPackages                             draw/sonata-import-bundle - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Utility &amp; Helpers](/categories/utility)
4. /
5. draw/sonata-import-bundle

ActiveLibrary[Utility &amp; Helpers](/categories/utility)

draw/sonata-import-bundle
=========================

Generic customisable import system for sonata

0.39.5(1mo ago)014.7k↑136.5%MITPHPPHP &gt;=8.5

Since Apr 17Pushed 1mo ago1 watchersCompare

[ Source](https://github.com/mpoiriert/sonata-import-bundle)[ Packagist](https://packagist.org/packages/draw/sonata-import-bundle)[ RSS](/packages/draw-sonata-import-bundle/feed)WikiDiscussions master Synced today

READMEChangelogDependencies (30)Versions (65)Used By (0)

DrawSonataImportBundle
======================

[](#drawsonataimportbundle)

This bundle add a basic import from csv system of entities in Sonata.

> It's currently only support update of existing entities.

Base on a configuration you can set which entity can be imported.

When uploading a csv file the system will detect the list of attribute base on a header column. It will then try to detect the identifier and the mutator to update the entities.

Configuration
-------------

[](#configuration)

Here is an example of the configuration:

```
draw_sonata_import:
  skip_value: '_SKIP_' # Optional, defaults to "_SKIP_". See "Preserving existing values" below.
  classes:
    App\Entity\User:
      alias: 'User' #The alias will be used instead of the full class name in the dropdown and database
    App\Entity\Product:
      alias: 'Product'
```

This tell the system that it support import for **App\\Entity\\User** and **App\\Entity\\Product**.

Preserving existing values on partial imports
---------------------------------------------

[](#preserving-existing-values-on-partial-imports)

When updating existing entities, an empty cell or any other value is normally written to the entity. This is a problem for partial imports — for example, updating only one locale of a translatable field while leaving the other locales untouched.

To opt out of writing a given cell, use the **skip value** (default `_SKIP_`):

```
id,translation#en.title,translation#fr.title,translation#pl.title
42,Ocean kingdom,Royaume océanique,_SKIP_
```

For row `id=42`, the English and French titles are updated and the Polish title is left exactly as it is in the database. The check happens in `Importer::assignValue()` *before* any type coercion, so the marker also works on date columns, boolean columns, etc.

You can change the marker per project via the `skip_value` configuration key. The marker only makes sense on update — on insert (`insertWhenNotFound: true`) a skipped column simply leaves the field at its default value.

An empty cell is **not** a skip — it still clears the field. Use the marker explicitly when you want to keep the stored value.

Sonata admin
------------

[](#sonata-admin)

A new menu **Import** will be available on the lef menu to create a new import. A dropdown to specify which entity you are importing is available base on the configuration. There is also an action **Import** on the list view of the entities that will link directly to this page with the entity selected in the dropdown.

You must select a csv file from which the system will detect the header and will try to fill the column information. You can then adjust it manually and select to **Process** the file.

Column Information Extraction
-----------------------------

[](#column-information-extraction)

The system try to extract column information base on a **Draw\\Bundle\\SonataImportBundle\\Column\\ColumnBuilder\\ColumnBuilderInterface**. There is two extractor provider with the system, one that will set if a column is the identifier base on it's name (id only), another one that will check if there is a **setter** base on the header to assign the mutator.

Import
------

[](#import)

When importing data a event **Draw\\Bundle\\SonataImportBundle\\Event\\AttributeImportEvent** is dispatch for every entity/column. Listening to this event let you do custom import logic of the data. If you did process the event you need to stop is propagation. If the event was not stop, the import logic will fall back on the column mutator that was set.

The setter just do a simple set of the raw value in the column (that is always a string) so if it's a reference to another object you must implement a listener to do have a custom logic.

###  Health Score

50

—

FairBetter than 95% of packages

Maintenance88

Actively maintained with recent releases

Popularity26

Limited adoption so far

Community10

Small or concentrated contributor base

Maturity63

Established project with proven stability

 Bus Factor1

Top contributor holds 96.8% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Every ~12 days

Total

64

Last Release

59d ago

PHP version history (3 changes)0.10.17PHP &gt;=8.1

0.10.47PHP &gt;=8.2

0.39.0PHP &gt;=8.5

### Community

Maintainers

![](https://www.gravatar.com/avatar/8bb9496b48abc2bfd37ebafa9cc4b3b1307a369ad27f6514943408d9b5ff18a5?d=identicon)[mpoiriert](/maintainers/mpoiriert)

---

Top Contributors

[![mpoiriert](https://avatars.githubusercontent.com/u/4175616?v=4)](https://github.com/mpoiriert "mpoiriert (90 commits)")[![kiloumap](https://avatars.githubusercontent.com/u/17480546?v=4)](https://github.com/kiloumap "kiloumap (2 commits)")[![DumitracheAdrian](https://avatars.githubusercontent.com/u/12441524?v=4)](https://github.com/DumitracheAdrian "DumitracheAdrian (1 commits)")

---

Tags

symfonybundledraw

###  Code Quality

TestsPHPUnit

### Embed Badge

![Health badge](/badges/draw-sonata-import-bundle/health.svg)

```
[![Health](https://phpackages.com/badges/draw-sonata-import-bundle/health.svg)](https://phpackages.com/packages/draw-sonata-import-bundle)
```

###  Alternatives

[easycorp/easyadmin-bundle

Admin generator for Symfony applications

4.3k17.9M388](/packages/easycorp-easyadmin-bundle)[rcsofttech/audit-trail-bundle

Enterprise-grade, high-performance Symfony audit trail bundle. Automatically track Doctrine entity changes with split-phase architecture, multiple transports (HTTP, Queue, Doctrine), and sensitive data masking.

1189.8k](/packages/rcsofttech-audit-trail-bundle)[sulu/sulu

Core framework that implements the functionality of the Sulu content management system

1.3k1.4M204](/packages/sulu-sulu)[open-dxp/opendxp

Content &amp; Product Management Framework (CMS/PIM)

9421.6k61](/packages/open-dxp-opendxp)[chameleon-system/chameleon-base

The Chameleon System core.

1028.6k5](/packages/chameleon-system-chameleon-base)[mapbender/mapbender

Mapbender library

10418.3k8](/packages/mapbender-mapbender)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)
