如何允许多个测试人员在发布之前测试App for Excel 2013 [英] How to allow multiple testers to test an App for Excel 2013 before it is published

问题描述

以下是我能想到的选项：

1）让每个测试人员安装Visual Studio并在Visual Studio中运行Office App

2）在网络计算机上创建共享文件夹，并将每个测试人员的可信应用程序目录配置为指向共享文件夹

选项1看起来不吸引人，我可能没有这个许多Visual Studio许可证。我尝试了Option 2但是我遇到了一个问题，它在应用程序中失败了我所有的Ajax调用。问题发布在

另一个问题。

任何建议？

解决方案

我的Excel 2013应用程序具有以下Ajax调用。它在Visual Studio环境中运行良好。该调用被视为跨域调用，IE进程触发预检调用（HTTP OPTIONS），我的服务使用正确的
标头响应预检调用，然后进行GET调用并获得正确的响应。 / p>

var qURL =
"https://server.com:8443/service_uri/" ' ;

    jQuery.support.cors = true;

   

.ajax（{

        ;类型：
" GET" ，

        url：qURL，

        cache：< span style ="color：＃0000ff; font-size：small">
false ，

        dataType：
" json" ，

&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;超时：5000，

        crossDomain：
true ，

&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;标题：{
'授权' ：
'Bearer' + access_token
}，

       成功：
function （data）{

&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; renderCustomerInfo（data）;

        }，

       错误：
function （jqxhr，textStatus，error ）{

             ...

     ;&NBSP;&NBSP;&NBSP;&NBSP; }

    }）;

我正在尝试为我的团队设置一个测试环境，所以我将我的应用程序复制到另一台机器上的共享驱动器。我配置Excel 2013信任中心并将受信任的应用程序目录设置为指向包含应用程序清单文件的共享驱动器文件夹。
该应用程序可在Excel for Office中使用。但是，上述调用总是返回错误，"No transport"。在Fiddler中，我甚至没有看到请求被发送，所以我认为这个调用在JavaScript层被阻止。

此外，我试图独立打开我的App主页IE浏览器并以这种方式运行我的代码。成功完成了相同的Ajax调用。在我看来Office App环境强加了一些安全设置，如果App
从共享驱动器运行，则会失败Ajax调用？

Here are the options I can think of:

1) Get every tester to install Visual Studio and run the Office App within Visual Studio

2) Create a shared folder on a network machine and configure every tester's Trusted App Catalogs to point to shared folder

Option 1 doesn't look appealing and I may not have this many Visual Studio licenses. I tried Option 2 but I ran into a problem which fails all my Ajax calls in the app. The problem is posted in another question.

Any recommendations?

解决方案

My App for Excel 2013 has the following Ajax call. It runs fine in the Visual Studio environment. The call is treated as a cross domain call, the IE process triggers a preflight call (HTTP OPTIONS), my service responds to the preflight call with proper headers, and then the GET call is made and gets proper response.

varqURL = 'https://server.com:8443/service_uri/'';

    jQuery.support.cors = true;

   

.ajax({

        type: "GET",

        url: qURL,

        cache: false,

        dataType: "json",

        timeout: 5000,

        crossDomain: true,

        headers: { 'Authorization': 'Bearer '+ access_token },

        success: function(data) {

            renderCustomerInfo(data);

        },

        error: function(jqxhr, textStatus, error) {

            ...

        }

    });

I am trying to set up a test environment for my team so I copied my app to a shared drive on another machine. I configure my Excel 2013 Trust Center and set Trusted App Catalogs to point to the shared drive folder which contains the App manifest file. The app becomes available under Apps for Office in Excel. However the above call always returns error, "No transport". In the Fiddler, I don't even see the request is sent so I think the call is blocked in the JavaScript layer.

Furthermore, I tried to open my App home page in a standalone IE browser and run my code that way. The same Ajax call is made successfully. It looks to me that the Office App environment imposes some security settings that fails the Ajax call if the App is running from a shared drive?

这篇关于如何允许多个测试人员在发布之前测试App for Excel 2013的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！