Import multilingual content to Babel website

aaantz · July 21, 2021, 3:17pm

Hi there,

i would like to import content (resource fields + TVs) via a CSV file. Basically what importX does, but I need to import my main language + one additional language and I would like to use Babel for my multilang setup.

Is there a way to import all the data at once from one single CSV?
Or would it be better to split it into my languages?
How does the resource-linking get handled?

We are talking about a clean install, if that matters.
Thanks in advance for your help!

halftrainedharry · July 21, 2021, 4:59pm

With Babel, pages for different languages are just normal resources in a different context. Therefore you should be able to use ImportX with a column context_key to set the right context.

The linking of the resources is trickier. The linking information is stored in a TV with the name babelLanguageLinks and a structure like this:

web:2;en:18

You need the actual values of the resource-ids to create the linking, so you can’t create it beforehand in your CSV.

Maybe you can adjust the code of ImportX: Read the ID from $response and create the linking for every other row.

github.com

Mark-H/importX/blob/d1f25c28b294556341cafc7f710ffc58fa2b8e56/core/components/importx/processors/startimport.php#L49

    
      
              $modx->importx->log('complete','');
              return $this->modx->error->failure();    
          }
          
          
$this->modx->importx->log('info',$modx->lexicon('importx.log.importvaluesclean',array('count' => count($lines))));
          $resourceCount = 0;
          
          
$processor = 'resource/'.$modx->getOption('importx.processor',null,'create');
          foreach ($lines as $line) {
              /* @var modProcessorResponse $response */
              $response = $modx->runProcessor($processor,$line);
              if ($response->isError()) {
                  if ($response->hasFieldErrors()) {
                      $fieldErrors = $response->getAllErrors();
                      $errorMessage = implode("\n",$fieldErrors);
                  } else {
                      $errorMessage = $modx->lexicon('importx.err.savefailed')."\n".print_r($response->getMessage(),true);
                  }
                  $this->modx->importx->log('warn',$resourceCount.' of '.count($lines).' resources were imported successfully');
                  $this->modx->importx->log('error',$errorMessage);
                  return $this->modx->importx->log('complete','');

Or maybe you can run a snippet after the import to create the linking, if you have a way to determine (from the resources in MODx) which two belong together. For example by creating a (temporary) TV for the import with a value that is equal for both versions.

aaantz · July 29, 2021, 7:25am

Thank you very much for your detailed response. Setting up a temporary TV is a great idea, I will try that approach.