By donatello on

Hi,
i'd like to know if there's a way to import content into drupal 6, knowing that i have 2 languages to manage.
I've installed all translation and localisation modules.

I have about 3000 items to put in my new custom content type, all in french and english. Do i have to translate each item manually through interface or can i manage all that with excel/csv and import after?

Many thanks for your answers.

⋅ Categories: Drupal 6.x

Comments

rsushil’s picture

rsushil commented

There is no such provision available in drupal to import the content from excel/csv to a language specific content type.
Here is a possible solution for you (but its not very easy):

*First Create a translated version of your content type (example : node) using drupal i18n
*Configure Entire website to use those translated content type (ex: configure your views,menus)
*Write a php script that will read content from your csv file and insert into database. You have to figure out which table and column hold the content for your content type. And then language column + ID will help you to find the way to insert the content to the exact row. While doing this you may have to take extra care for teaser part of the node.

You can look into the icanlocalize module to see how they insert the content to language specific content type.

Hope this will help.

donatello’s picture

donatello commented

hi,
thanks a lot for this advice, i'll have a close look at it.
I've seen there's a module called "migrate", that hepls to manage migrations.
Do you think this could be a helpful tool in my particular situation?

rsushil’s picture

rsushil commented

Some part of migration module could be useful, but it would be more difficult to go with the general utility module like Migration instead of translation specific module. But at the end you have to customize these module to fit into your requirement so as along as you are comfortable you can start with any one.