PHPackages                             atico/translator-symfony-demo-onedrive-to-xliff - 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. atico/translator-symfony-demo-onedrive-to-xliff

ActiveProject

atico/translator-symfony-demo-onedrive-to-xliff
===============================================

Spreadsheet Translator. Symfony Demo Application. Takes a Microsoft OneDrive spreadsheet file and creates translation files in XLIFF format

v8.4.1(6mo ago)019MITPHPPHP >=8.4CI passing

Since May 15Pushed 6mo ago1 watchersCompare

[ Source](https://github.com/samuelvi/translator-symfony-demo-onedrive-to-xliff)[ Packagist](https://packagist.org/packages/atico/translator-symfony-demo-onedrive-to-xliff)[ RSS](/packages/atico-translator-symfony-demo-onedrive-to-xliff/feed)WikiDiscussions master Synced yesterday

READMEChangelog (2)Dependencies (21)Versions (10)Used By (0)

Spreadsheet Translator Symfony Demo Application
===============================================

[](#spreadsheet-translator-symfony-demo-application)

Symfony demo application that takes a Microsoft OneDrive spreadsheet and generates translation files in XLIFF format.

Requirements
------------

[](#requirements)

- PHP >= 8.4
- Symfony 7.0
- Docker & Docker Compose (recommended)

Installation
------------

[](#installation)

```
composer create-project atico/translator-symfony-demo-onedrive-to-xliff
```

Demo spreadsheet: [https://onedrive.live.com/embed?resid=F52C4DBF73226B55%%212071&authkey=%%21ANaIXSe9EB\_Vywo&em=2&em=2&cid=F52C4DBF73226B55%%212071](https://onedrive.live.com/embed?resid=F52C4DBF73226B55%%212071&authkey=%%21ANaIXSe9EB_Vywo&em=2&em=2&cid=F52C4DBF73226B55%%212071)

Notice that this file cannot be opened via web browser but with the atico:demo:translator command.

Running with Docker
-------------------

[](#running-with-docker)

### Quick Start

[](#quick-start)

```
make build          # Build Docker images
make up             # Start services
make composer-install
make demo           # Run demo translator command
```

### Available Make Commands

[](#available-make-commands)

**Docker Commands:**

```
make build              # Build or rebuild the Docker images
make up                 # Start the services in the background
make down               # Stop and remove the services
make restart            # Restart the services
make shell              # Access the PHP container shell
```

**Composer Commands:**

```
make composer-install   # Run composer install inside the container
make composer-update    # Run composer update inside the container
```

**Testing Commands:**

```
make test               # Run PHPUnit tests
make test-coverage      # Run tests with coverage report
```

**Code Quality Commands:**

```
make rector             # Run Rector to fix code (applies changes)
make rector-dry-run     # Run Rector in dry-run mode (shows changes)
```

**Application Commands:**

```
make demo               # Run demo translator command
make console [command]  # Run any Symfony console command
```

**Utility Commands:**

```
make clean              # Clean cache and temporary files
```

Running Locally (Without Docker)
--------------------------------

[](#running-locally-without-docker)

```
composer install
bin/console atico:demo:translator --sheet-name=common

# Run tests
vendor/bin/phpunit

# Run Rector
vendor/bin/rector process --dry-run
vendor/bin/rector process
```

Testing
-------

[](#testing)

This project includes comprehensive unit tests for all components.

```
# Run all tests
make test

# Generate coverage report (saved to var/coverage/)
make test-coverage

# Run specific test
docker-compose -f docker/docker-compose.yaml exec php-atic-odp-xe vendor/bin/phpunit tests/Command/TranslatorCommandTest.php
```

Code Quality
------------

[](#code-quality)

The project uses Rector for automated code refactoring and quality improvements.

```
# Check what changes Rector would make
make rector-dry-run

# Apply Rector changes
make rector
```

Output
------

[](#output)

Translation files are generated in `translations/`:

```
translations/
  ├── demo_common.es_ES.xliff
  ├── demo_common.en_GB.xliff
  └── demo_common.it_IT.xliff

```

OneDrive File Sharing
---------------------

[](#onedrive-file-sharing)

1. Open spreadsheet in OneDrive
2. Share → Embed → Generate code
3. Extract AUTHKEY from iframe code
4. Copy RESID and CID from URL
5. Build URL: `https://onedrive.live.com/embed?resid=RESID&authkey=AUTHKEY&em=2&cid=CID`

Note: Escape `%` characters in URL values by doubling them (`%%`)

Related Projects
----------------

[](#related-projects)

- [Symfony Bundle](https://github.com/samuelvi/spreadsheet-translator-symfony-bundle)
- [Local File to PHP Demo](https://github.com/samuelvi/translator-symfony-demo-local-file-to-php)
- [Google Drive to YML Demo](https://github.com/samuelvi/translator-symfony-demo-google-drive-provider-yml-exporter)

CI/CD
-----

[](#cicd)

The project includes GitHub Actions workflow for automated testing on every push and pull request.

Dependencies
------------

[](#dependencies)

### Core Libraries

[](#core-libraries)

- `samuelvi/spreadsheet-translator-core`: ^8.4
- `samuelvi/spreadsheet-translator-symfony-bundle`: ^8.4
- `samuelvi/spreadsheet-translator-provider-onedrive`: ^8.4
- `samuelvi/spreadsheet-translator-reader-xlsx`: ^8.4
- `samuelvi/spreadsheet-translator-exporter-xliff`: ^8.4

### Symfony Components

[](#symfony-components)

- Symfony 7.0 (Console, Framework Bundle, Translation, etc.)

### Development Tools

[](#development-tools)

- PHPUnit 11.5 for testing
- Rector 2.1 for code quality and refactoring

License
-------

[](#license)

Licensed under the MIT License. See LICENSE file for details.

###  Health Score

46

—

FairBetter than 93% of packages

Maintenance69

Regular maintenance activity

Popularity6

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity86

Battle-tested with a long release history

 Bus Factor1

Top contributor holds 100% 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 ~342 days

Recently: every ~684 days

Total

9

Last Release

182d ago

Major Versions

1.0.6 → v8.4.02025-11-02

PHP version history (2 changes)1.0.0PHP >=5.5.9

v8.4.0PHP >=8.4

### Community

Maintainers

![](https://avatars.githubusercontent.com/u/10146931?v=4)[Samuel Vicent](/maintainers/samuelvi)[@samuelvi](https://github.com/samuelvi)

---

Top Contributors

[![samuelvi](https://avatars.githubusercontent.com/u/10146931?v=4)](https://github.com/samuelvi "samuelvi (14 commits)")

###  Code Quality

TestsPHPUnit

Static AnalysisRector

### Embed Badge

![Health badge](/badges/atico-translator-symfony-demo-onedrive-to-xliff/health.svg)

```
[![Health](https://phpackages.com/badges/atico-translator-symfony-demo-onedrive-to-xliff/health.svg)](https://phpackages.com/packages/atico-translator-symfony-demo-onedrive-to-xliff)
```

###  Alternatives

[shopware/platform

The Shopware e-commerce core

3.3k1.5M3](/packages/shopware-platform)[sylius/sylius

E-Commerce platform for PHP, based on Symfony framework.

8.4k5.6M651](/packages/sylius-sylius)[prestashop/prestashop

PrestaShop is an Open Source e-commerce platform, committed to providing the best shopping cart experience for both merchants and customers.

9.0k15.4k](/packages/prestashop-prestashop)[shopware/core

Shopware platform is the core for all Shopware ecommerce products.

595.2M386](/packages/shopware-core)[ec-cube/ec-cube

EC-CUBE EC open platform.

78527.0k1](/packages/ec-cube-ec-cube)[sulu/sulu

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

1.3k1.3M152](/packages/sulu-sulu)

PHPackages © 2026

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