i want to translate csv file

[Tran Quang Phuc]

I have a csv file about 500 rows or more . I want to call api a time to translate .  what api do i need to call? I am using asp.net.

Thank you so much!

[Yingjie He]

Hi,

Currently we don't support batch translation, the way you can do is translating rows one by one, or combining some rows.

[michael zhang]

Hi, my suggestion is that you can translate your .csv file in any major CAT tools which can load Google Translate API. For example, SDL Trados or MemoQ.

The beauty of this solution is that you don't have to be charged by billable API use if there are 100% matches in your file,which is not uncommon in my domain.

Also, you may write or copy a script to call GT API in csv file.

Hope this helps.

[Tran Quang Phuc]

Hi ,

I am currently translating rows one by one but it takes a lot of time to translate, around 376 rows is taking about 10 mins to translate is there a way to make this faster.

this is api to call ( https://automl.googleapis.com/v1beta1/projects .... {"payload":{"textSnippet": {"content": "my content 1 - my content 2"}}}.

i had to combining 2 rows. even i tried |, -, . and ; but it will not translate correctly if I do that.

Thank you so much,

[michael zhang]

Hi Tran Quang Phuc,

It seems that you have little idea about how Computer-Aided Tools such as SDL Trados works, which is absolutely a faster way to translate spreadsheets.

Please share something to translate of your csv file provided 1) you don’t mind;2) it violates no NDA or regulation or compliance rules available in your jurisdiction.

I can share my hands-on with you and may I know what is your language pair( what is the source language and what is the target language)?

Best,

Michael

[Tran Quang Phuc]

Hello Michael zhang ,

the surce language is english and destination language is chinese (not simplified) but based on custom model.

you can see translate.csv (i were translating rows one by one )

combiningrows.txt ( i combined some rows and called api but it was not google).

Thank you so much for your support

[michael zhang]

Hi Tran Quang Phuc,

1) The target language in the file you posted (the csv and the txt) seems Simplified Chinese to me so I don't understand why you said destination language is Chinese (not simplified) .

2) In your case,  maybe you should buy a major CATO tools such as SDL Trados 2014 or 2017 version, there is some menu in this software that allows you to load various kinds of machine 

translation API such as Google Translate or alike.

See the screenshot below.

3) So far you cannot load API of the custom model trained by Google AutoML Translation.

4) You may consider outsourcing the job to me if you trust me and the rate is reasonable.