How to bulk translate labels on multiple custom tables

[garrett-button]

We have an app in the app store and I need to add translations to every label on 40+ tables, about 550 fields. I tried to create a template to do do this, but I can't seem to define the table the translations should go to.

Is there any way to bulk add translated labels for our tables?

[garrett-button]

@Alex Coope - SN You might know? I saw you've responded to similar questions.

[Alex Coope - SN]

@garrett-button, 
So field labels (both English and translationed) reside on the [sys_documentation] table as detailed in my blog post here.

I'm afraid, currently there is no API method available to auto-add them, but it is something we're looking into. As it's for your app on the store, you'll need to do it within the scope of your app. Sadly your best current bet would be a spreadsheet import directly to the [sys_documentation] table but you'll take to take into account any inherited fields as well as direct fields on the tables.

Many thanks,
kind regards
 

[garrett-button]

@Alex Coope - SN Thank you for the reply. My current issue is that the excel upload is very limited, and won't let me add crucial information like the target table. I'm probably missing something, but right now it doesn't seem possible. 

This is the table template and all that seems to be allowed on upload.

[Alex Coope - SN]

@garrett-button,

For field labels in [sys_documentation] you're missing a few columns in your template, you need at least:
Table | Element | Language | Label | Plural | Help | Hint

So it looks like you're missing "table",

Then you can do a 1<->1 field import per row,

Many thanks,
Kind regards