Google translate API phrase into every language using classic ASP
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
Good morning everyone,
I have something [maybe not so] unique which I want to do which is translate a simple phrase like "Hello" into every language available under Google Translate API. I want to basically capture the results and store it into a SQL Server database.
In the past, I have written bulk geocoding processes using ASP and that worked well, and I am thinking that I can do the same with the translate API using a querystring. However, there are really no great examples of it.
I am about to drop the languages and their codes into a table so that I can just loop through things, and then use a JSON parser since I am not using the latest version of SQL Server. I have done crazy ASP SOAP implementation in the past which required authentication twice, but am thinking that this can be done differently.
I am just figuring that someone else out here might have had to slay this dragon before and any and all tips would be greatly appreciated.
Thanks
sql-server asp-classic google-translate asked Nov 16 '18 at 13:45
user2105186user2105186
143
add a comment |
Good morning everyone,
I have something [maybe not so] unique which I want to do which is translate a simple phrase like "Hello" into every language available under Google Translate API. I want to basically capture the results and store it into a SQL Server database.
In the past, I have written bulk geocoding processes using ASP and that worked well, and I am thinking that I can do the same with the translate API using a querystring. However, there are really no great examples of it.
I am about to drop the languages and their codes into a table so that I can just loop through things, and then use a JSON parser since I am not using the latest version of SQL Server. I have done crazy ASP SOAP implementation in the past which required authentication twice, but am thinking that this can be done differently.
I am just figuring that someone else out here might have had to slay this dragon before and any and all tips would be greatly appreciated.
Thanks
sql-server asp-classic google-translate asked Nov 16 '18 at 13:45
user2105186user2105186
143
add a comment |
Good morning everyone,
I have something [maybe not so] unique which I want to do which is translate a simple phrase like "Hello" into every language available under Google Translate API. I want to basically capture the results and store it into a SQL Server database.
In the past, I have written bulk geocoding processes using ASP and that worked well, and I am thinking that I can do the same with the translate API using a querystring. However, there are really no great examples of it.
I am about to drop the languages and their codes into a table so that I can just loop through things, and then use a JSON parser since I am not using the latest version of SQL Server. I have done crazy ASP SOAP implementation in the past which required authentication twice, but am thinking that this can be done differently.
I am just figuring that someone else out here might have had to slay this dragon before and any and all tips would be greatly appreciated.
Thanks
sql-server asp-classic google-translate asked Nov 16 '18 at 13:45
user2105186user2105186
143
Good morning everyone,
I have something [maybe not so] unique which I want to do which is translate a simple phrase like "Hello" into every language available under Google Translate API. I want to basically capture the results and store it into a SQL Server database.
In the past, I have written bulk geocoding processes using ASP and that worked well, and I am thinking that I can do the same with the translate API using a querystring. However, there are really no great examples of it.
I am about to drop the languages and their codes into a table so that I can just loop through things, and then use a JSON parser since I am not using the latest version of SQL Server. I have done crazy ASP SOAP implementation in the past which required authentication twice, but am thinking that this can be done differently.
I am just figuring that someone else out here might have had to slay this dragon before and any and all tips would be greatly appreciated.
Thanks
sql-server asp-classic google-translate sql-server asp-classic google-translate asked Nov 16 '18 at 13:45
user2105186user2105186
143
asked Nov 16 '18 at 13:45
user2105186user2105186
143
asked Nov 16 '18 at 13:45
user2105186user2105186
143
asked Nov 16 '18 at 13:45
user2105186user2105186
143
asked Nov 16 '18 at 13:45
user2105186user2105186
143
143
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
The Translation API only allows for one target language per request. Unfortunately, for your use case you would have to loop through the desired languages and send a separate request for each.
answered Nov 18 '18 at 18:32
Ali TAli T
1667
Thanks very much. I got busy for the past few days (steam pipe pinhole leak) and was thinking that I would try one, and then just loop it. I might have to mess with my PHP and CURL programming but prefer SQL Server.
– user2105186
Nov 18 '18 at 22:28
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53339099%2fgoogle-translate-api-phrase-into-every-language-using-classic-asp%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
The Translation API only allows for one target language per request. Unfortunately, for your use case you would have to loop through the desired languages and send a separate request for each.
answered Nov 18 '18 at 18:32
Ali TAli T
1667
Thanks very much. I got busy for the past few days (steam pipe pinhole leak) and was thinking that I would try one, and then just loop it. I might have to mess with my PHP and CURL programming but prefer SQL Server.
– user2105186
Nov 18 '18 at 22:28
add a comment |
The Translation API only allows for one target language per request. Unfortunately, for your use case you would have to loop through the desired languages and send a separate request for each.
answered Nov 18 '18 at 18:32
Ali TAli T
1667
Thanks very much. I got busy for the past few days (steam pipe pinhole leak) and was thinking that I would try one, and then just loop it. I might have to mess with my PHP and CURL programming but prefer SQL Server.
– user2105186
Nov 18 '18 at 22:28
add a comment |
The Translation API only allows for one target language per request. Unfortunately, for your use case you would have to loop through the desired languages and send a separate request for each.
answered Nov 18 '18 at 18:32
Ali TAli T
1667
The Translation API only allows for one target language per request. Unfortunately, for your use case you would have to loop through the desired languages and send a separate request for each.
answered Nov 18 '18 at 18:32
Ali TAli T
1667
answered Nov 18 '18 at 18:32
Ali TAli T
1667
answered Nov 18 '18 at 18:32
Ali TAli T
1667
answered Nov 18 '18 at 18:32
Ali TAli T
1667
1667
Thanks very much. I got busy for the past few days (steam pipe pinhole leak) and was thinking that I would try one, and then just loop it. I might have to mess with my PHP and CURL programming but prefer SQL Server.
– user2105186
Nov 18 '18 at 22:28
add a comment |
Thanks very much. I got busy for the past few days (steam pipe pinhole leak) and was thinking that I would try one, and then just loop it. I might have to mess with my PHP and CURL programming but prefer SQL Server.
– user2105186
Nov 18 '18 at 22:28
Thanks very much. I got busy for the past few days (steam pipe pinhole leak) and was thinking that I would try one, and then just loop it. I might have to mess with my PHP and CURL programming but prefer SQL Server.
– user2105186
Nov 18 '18 at 22:28
Thanks very much. I got busy for the past few days (steam pipe pinhole leak) and was thinking that I would try one, and then just loop it. I might have to mess with my PHP and CURL programming but prefer SQL Server.
– user2105186
Nov 18 '18 at 22:28
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53339099%2fgoogle-translate-api-phrase-into-every-language-using-classic-asp%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
