NT8 + OfficeInside 4.26

[bramkip]

Hi,

Creating a Excel document is working only when the NT8 app is running manualy. When running as a Service (SelfService) the Excel document is not created.
(this was also the case with NT7 app)

Bruce, look at this please.

Best regards,

Bram

[kevin plummer]

Hi Bram, have you checked the permissions when running as a service?

[Bruce]

Hi Bram,

In NT7, Excel is used to create excel documents. So the Excel program is being called from your service. My guess is that it's not set up right to do that.

In NT8 (or more specifically xFiles 2.5) you can also create Excel (xml) files using xFiles. That might be a better approach in the long run, although it might depend on the type of file you are trying to create. (Also that part of xFiles is not documented yet.)

In the short term I think as Kevin suggests, it's some sort of permissions issue though that is preventing the service from either running, or communicating with, the Excel file. (Obviously the files being created _must_ be on the C drive, there's no network shared-drive access for the service user.)

cheers
Bruce

[bramkip]

Hi Kevin, Bruce,

Which permissions do you mean? The Excel document is created when running the program manualy and not when running as a service.
Bye the way, when running the program as a Service, all works fine except creating a Excel document.

On the Global template I tested with both  'Local System' and Partical User account (with Administrator rights)

Thanks.
Bram

[Bruce]

permission to run Excel, permission to create the file (in the directory you are trying to save it to) and so on.

cheers
Bruce

[bramkip]

Hi Bruce,

As I wrote 'the Excel document is created perfectly when running the program manualy'. So write permissions seems not be the issue. Only when the program is started as a Service, the document is not created.

I added the Selfservice template to your demo app ExcelRequiresOI (54) and ran it on my Windows 7 PC. Same problem.

Regards,
Bram

[Bruce]

I tried that here, but it seems to work ok.
added SelfService to the app
ran it with the /ISS command line (to install it as a service, and start it.)
went to my browser
went to http://127.0.0.1:88/
click on Generate XLS
Click on Lnk
Excel opens.

so I'm guessing it has something to do with your setup. Maybe try disabling firewalls, UAC etc to see if you can narrow it down.

cheers
Bruce

[bramkip]

Hi Bruce,

Very strange! I do exactly like you do, but no succes. Also with firewall and UAC disabled.
Do you also use 'Local system account' ? And you grant this account more rights as default?

Regards,
Bram

[Bruce]

I just used the default Service settings, and the /ISS install. I didn't alter any of the proeprties after that.

Are you getting any error clues that you might be able to use? ie are you trapping for errors after all the function calls in the code?

cheers
Bruce

[bramkip]

Hi Bruce,

I don't see any errors. The Excel file is not generated in the 'reports' map.  I think the right permissions are not the problem, because an PDF is generated perfectly in the same 'reports' map.

Best regards,

Bram

[Bruce]

I guess you need to figure out what is not working on the system, because it's working here ok.

cheers
Bruce

[kevin plummer]

Hi Bram,

try these things in service mode and use task manager to see if things are happening.

1) just opening excel
2) open an existing excel document
3) save the excel doc to different locations

It may be your service account does not have permission to open excel or save the file where you want.

[bramkip]

Hi Kevin, Bruce,

Thanks for the tips. I try this.

Best regards.

Bram