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

Spreadsheet Translator. Symfony Demo Application. Takes a Microsoft One Drive spreadhseet file and creates a translation file per locale in Xliff format

Spreadsheet Translator Symfony Demo Application - Use Case

Introduction

Lightweight Symfony Demo Application for the Spreadsheet Translator functionallity. The demo brings a command that takes a Microsoft One Drive spreadhseet file and creates a translation file per locale in Xliff format., _(*1)

Installation

composer create-project atico/translator-symfony-demo-onedrive-to-xliff, _(*2)

This will install the demo application into your computer, _(*3)

The source demo spreadsheet file is located at https://onedrive.live.com/embed?resid=AF6B7F4DC4426D56!114&authkey=%21AOntrGclPCi6zdA&em=2&cid=af6b7f4dc4426d56, _(*4)

Instructions for sharing the One Drive file in readonly mode

Open your spreadsheet file in One Drive., _(*5)

Go to Open => Share, _(*6)

Click on the embed link, _(*7)

Click on the generate button, _(*8)

A screen with a Code for Insert|Javascript will appear, _(*9)

The given textarea will contain an iframe element, copy the value for AUTHKEY, _(*10)

From the address bar copy the values for RESID and CID, _(*11)

Manually build the following url replacing the corresponding values:, _(*12)

https://onedrive.live.com/embed?resid=RESID&authkey=AUTHKEY&em=2&cid=CID, _(*13)

Running the demo

type in you terminal: bin/console atico:demo:translator --sheet-name=common, _(*14)

This command will generate the translation files that will be stored into app/translations folder., _(*15)

The generated files will be:, _(*16)

  app
  |
  └───Resources
     │
     └──translations
         │  demo_common.es_ES.xliff   
         │  demo_common.en_GB.xliff
         │  demo_common.it_IT.xliff

demo_common.it_IT.yml will contain:, _(*17)

  <?php
  return array (
    'homepage_title' => 'Traduttore di fogli di calcolo',
    'homepage_subtitle' => 'Traduttore per pagine Web con fogli di calcolo',
  );

Related

Symfony Bundle: - Symfony Bundle, _(*18)

Symfony Demos:, _(*19)

• Symfony Demo. Takes a local file and creates translation files per locale in php format
• Symfony Demo. Takes a google drive spreadsheet and creates translation files per locale in yml format
• Symfony Demo. Takes a microsoft one drive spreadsheet and creates translation files per locale in xliff format

Notes

composer.json will include the following Spreadsheet Translator dependencies:, _(*20)

  "atico/spreadsheet-translator-core": "^1.0",
  "atico/spreadsheet-translator-symfony-bundle": "^1.0",
  "atico/spreadsheet-translator-provider-onedrive": "^1.0",
  "atico/spreadsheet-translator-reader-xlsx": "^1.0",
  "atico/spreadsheet-translator-exporter-xliff": "^1.0",

Requirements

• PHP >=5.5.9
• Symfony ~2.3|~3.0

Contributing

We welcome contributions to this project, including pull requests and issues (and discussions on existing issues)., _(*21)

If you'd like to contribute code but aren't sure what, the issues list is a good place to start. If you're a first-time code contributor, you may find Github's guide to forking projects helpful., _(*22)

All contributors (whether contributing code, involved in issue discussions, or involved in any other way) must abide by our code of conduct., _(*23)

License

Spreadsheet Translator Symfony Bundle is licensed under the MIT License. See the LICENSE file for full details., _(*24)