Dear all,

We are currently developing a new Data Download tool and are looking for testers. On release, this will be for 'Active' and above subscription levels.

If you are interested please click here.

Your comments and suggestions are welcome.

Karl.

hilary, if Karl emails you the CSV file, save it to disk, fire up 1-2-3 and File/Open it (CSV format). You should be given the options I listed, choose comma-delimited and it should work as expected. Clicking on the file name instead won't give you the options and the default may not be correct.

Karl,

I've opened it in both programs. Not only are the speech marks still visible, but all the data is contained within column A. Incidentally the separator seems to be a tab rather than a column (edit: comma).

The answer to your other question Hilary is that yes it will probably work better under Excel, however changing the browser preference is not the same as changing the file type association in Windows Explorer. I think you might need to reinstall Excel (i.e. install it after 1-2-3 rather than before) or you could always edit the registry if you felt up to it.

From the sounds of it Karl will fix it so that you can download the file and then it should work for you.

hilary, on Karl's screen select Separator Comma (CSV)!

Hilary,

Sorry my mistake ... I sent you the wrong file (Doh!). It was a tab seperated one I was using to test your problem.

The CSV one is on it's way.

K

Oh sorry, indeed, Karl's fault :-)

Kayak, Hilary,

I will fix it so it can be download straight into the browser without the speech marks.

K

I'm not sure that's the best solution to be honest Karl, since if any of the fields were later to have a comma in it (I don't think they do at present) it would go skew. I would instead give the option of saving to a file.

Kayak,

There are systems issues with the saving to file option. The file would need to be generated and then offered up for download. As we use many appliation servers to serve our content the file would be lost between each hit. To solve this we would need to dedicate a server to the download of files. At the momenet this is not feasible, which is why the download is as it is, and is still in BETA test.

Although I would be interested to know why some people do not get the offer to "save to file" or "open in brower" when they click the download. All the machines we have tested offer this as standard.

K.

Karl,

The comma separated file opens fine. Thanks. Strange though that I couldn't get the tab separated file to open (even after playing with the settings!).

Kayak,

I'll forgive you.

:o)

Hilary,

And so the mystery deepens ...

K

hilary, try first opening the CSV file Karl sent you (specifying comma-delimited), come out of that, and then download it again straight into 1-2-3 via Karl's screen. It may be that the default CSV file format it uses is the last one used.

Still can't get it to open, K., but don't worry about it now. Hopefully Karl now understands the problem and I'll be able to get it to work next week once he's done his fix. Thanks for your help.

Karl,

Have you an update yet on the speech marks issue?

Or the earlier download time (7pm) ?

Hilary, BrianTrada,

Thank you for the reminder. The changes are on my to-do list but as the product is only in BetaTest they havn't been actioned as yet due to a other commitments. I will post back as soon as they are live and tested.

Karl.

Hilary,

I have just made the changes regarding the quotation marks.

There is now an option to switch them off. Although I had to leave them for the company name as some of them had commas in them. Also it changes the format of the data. The data is now "raw" but Excel deals with it ok.

Hope that helps.

K

Thanks Karl,

I'll look at it a bit later and let you know how I get on.

Karl,

I've saved a CSV file but the separators are only working from the 4th column (Open Price). The first 3 columns are not separating and end up in column A. The titles from Row 1 are also not separating and all end up in Cell A1. The Volume column still closes with a speech mark.

Back to the drawing board.

:o(

hilary, are you happy with the default spreadsheet when called from IE being Excel rather than 1-2-3? If you reinstall Excel that should happen I think and the CSV file should then open fine.