Hi Dave,

Would it be possible to post some sample files the demonstrate the problem you are encountering? They don't have to contain your original data, just some made-up files that we can use to reproduce your issue. You can either post them on this forum, or alternatively send them to support@visokio.com.

Thanks

Chris

Hi,

Where you not able to recreate this??

See attached files. One is a omnscoipe file, with a sequance of vaules, that outputs to excel. The other is the excel output.

See the excel file is showing numbers as text, to convert the, to numbers to perform calculations, I need to do a text to cloumns. And this I cant do each time, as I need to to work as a automated dump output.

Dave

Hi Dave,

Thanks for sending us the files.

Omniscope comes with two Excel writers:

- Excel direct. This writes the data directly to Excel. You must have Excel installed to use this writer.

- Omniscope. This uses Omniscope to write the data. It doesn't require Excel to be installed.

In Omniscope 2.8 we have added the ability to select which writer you want to use (although you will only be able to use "Excel direct" if Excel is installed. In 2.7 and older Omniscope automatically selects which writer to use.

I've tested your data with both the "Excel direct" and "Omniscope" writers. The "Excel direct" writer does convert the data to a numeric column, and the "Omniscope" writer does not. The "Omniscope" writer currently only exports data as text, which is why your experiencing this problem. We may review this in the future, but there are a number of issues (formatting etc) that we need to deal with. I suspect that your Omniscope is automatically using the "Omniscope" writer.

Can you let us know if you have Excel installed? If you do, please ensure that "Settings>Advanced>Misc>Use alternative Excel reader" is UNCHECKED. Then add a new publisher block and try again.

Let us know how you get on.

ah mine just says use alternative excel reader (POI) and is unchecked.

Dave

Hi Dave,

Firstly please ensure you have the "Use alternative Excel reader" option UNCHECKED.

The option should say "Excel reader" in your version of Omniscope. Steve was referring to the same option in 2.8, where we have changed the text slightly.

Can you add a completely new Excel publisher block. Does that block still have the same problem?

Ok getting somewhere. It does not like to create on a unc.

If you create on a local drive it's fine. Create over a unc and it fails.

What do you mean by UNC? Do you mean when you try and create it on a network drive it fails? If so what error message do you get? When you create it locally is your original issue with the formatting now fixed?

I get no error message at all.

But yes locally its fine. Over network it fails. It used to work fine. This only started when we moved to run this on a sever (it used to run from a pc)

Any ideas?

Dave

What happens when it fails?
Does the block say it published successfully?
Do you have permissions to write to the folder?
Can you try publishing different data (eg. IOK/CSV), does this work?

It does say it was successful.

And yes other types work fine.

I've tested this out and I am able to write to a network location in Omniscope 2.7, so i'm not entirely sure why your experiencing this problem. I would suggest trying to export to other network locations and see if you still have the same problem.

Same issue on all network locations.

Dave,

As suggested before, I think it would be worthwhile setting up a screen-sharing session. We cannot reproduce your issue, so I think we need to be able to see your screen in order to diagnose your issue. Please contact me by email to arrange this.

Hi,

I have got this going. Thanks for all your help. I did not have the modify permissions.

This stopped it working.

Dave