[vygi]

peterlaursen wrote on Nov 29 2005, 04:16 PM:

but which one is you ?  😀

I'm on the left 😉

[X] <- nail here to get new monitor

[vygi]

peterlaursen wrote on Nov 29 2005, 04:00 PM:

yeah … I like the dolphins too  😛

hey – that was my 50th post and I became “Advanced Member”! 😀

[vygi]

peterlaursen: are you permanently online on this page?!.. 😎

[vygi]

peterlaursen wrote on Nov 29 2005, 03:14 PM:

Well .. this is a matter of priority basically.

Yes, I agree,

but if office user like my teammates are SQLyog target customers then decent export to Excel should become not the very lowest priority.

[vygi]

peterlaursen wrote on Nov 29 2005, 12:55 PM:

But to me the database issues (overwriting of defaults) are far more important to me than any M$ issue.

Yes, I agree, it is not a first priority to me as well, but my three workmates have tried SQLyog (after using urSQL) and two of them got these type conversion problems within first 30 minutes; they were disappointed, aren't excited by SQLyog anymore and prefer to stay with urSQL, although it is not MySQL5-compatible and therefore probably will cause problems in the near future. So are the facts…

I am quite sure that urSQL uses Windows COM interface to write “directly” to Excel. It allows to avoid any type interpretation errors and is faster as makes everything in one step, without clipboard or (temporary) files.

Hope it helps: http://www.codeproject.com/com/#Automation

BTW even PHP on Windows has this COM interface, so I very hope it is not too complicated to implement.

Best,

Vygi

[vygi]

Ritesh wrote on Nov 29 2005, 09:16 AM:

Did this method work? If it does, then its an interesting entry in our FAQ system.

It works… somehow….

But it is only a workaround. Quite good one if you only need to store date but worse if some calculations must be done.

Example:

let's format cells as text and paste some data from MySQL, let's say just date in column A and two floats in columns B and C.

Now let's try to calculate sum of B and C and put it into D.

That means, I have to write a formula “=B1+C1” into cell D1.

It works only if column D was not indicated as text column.

So I must either know in advance how many columns will be inserted (and only these must be formatted as text) or revert theom to general or number format after copy&paste. This is a 1st issue.

No big deal so far, I can easily change it to “general”.

But now the worse thing: as soon as I edit this formula, the cell becomes text again, and the formula don't work anymore. So I have to select also both columns B and C and format them as numbers in order to use them in some arithmetical formulas. This is the 2nd issue.

It's not possible to define number column as number in advance (before copy&paste) because Excel then puts “38600.00” instead of “5.09”! So number fields *must* be indicated as text before paste and *must* be switched to number format after.

So you see it is not that easy and this workaround isn't good enough.

Ritesh wrote on Nov 29 2005, 09:16 AM:

Anyway, I will take a look in urSQL and see how they are able to get things straight without any problem.

[post=”8015″]<{POST_SNAPBACK}>[/post]

Thanks, Ritesh!

I don't care much about it but I see that data transfer to Excel is a common practice, and this cell format problem must be quite important issue for many office users.

BTW especially European users are affected as we use periods to format date (today is 29.11.2005 or just 29.11). Americans may have less problems with it (11/29/05).

Thanks in advance,

Vygi

[vygi]

Yes I know that this is a known Excel problem.

Among other things, I'm also web developer and know that download to Excel can be a pain if you try to send just a tab separated values. It works… somehow… but these issues with text/number/date fields suck! Fortunately, there are several packages which allow to create real Excel files and specify data type for every singe cell.

ODBC is an option if you really know what you need and always do the same.

Otherwise you have to use some DB GUIs like SQLyog to put query results into files, and Excel is a common office application. Unfortunately, this described issue makes export to Excel problematic to quite impossible.

I'm not sure but urSQL seems to use direct interface (COM) for Excel exports and it works much better. I never had any problems with urSQL.

This issue is not a big problem to me but quite a show-stopper for some of my colleagues at work. Otherwise – who knows – maybe we would purchase a couple of licenses. But now they continue with urSQL….

[vygi]

Ritesh wrote on Nov 25 2005, 07:49 AM:

I had messaged you with info on 5.01 BETA. Did the BETA fix the problem?

[post=”7991″]<{POST_SNAPBACK}>[/post]

Sorry for delay….

Yes, this new versions works correctly, no problems detected so far!

Vygi

[vygi]

Ritesh wrote on Nov 23 2005, 08:57 AM:

This is very strange. We test SQLyog on Win98 and Win2K and it works perfectly.

[post=”7968″]<{POST_SNAPBACK}>[/post]

Yes it works on 2000 but I was not able to upgrade SQLyog 4.07 (I think) to 4.20 on Windows NT: setup was permanently crashing. I did not try 5.0 on NT yet.

[vygi]

billmaltby wrote on Nov 22 2005, 04:56 PM:

Hi Guys, I have spent more time on this (with the latest version, 5.0) and have the following senario. Try this to reproduce the problem.

It doesn't work. I mean, SQLyog works well and I can't reproduce the issue in that way.

And generally: SQLyog runs without any problems today. I currently have 6 connections to 4 different databases, 2-3 query tabs in each window, and everything works just fine, no such problems like already twice before.

[vygi]

peterlaursen wrote on Nov 20 2005, 05:57 AM:

As I see it it IS correctly escaped!  this ' (apostrophe) must be escaped – this  ´ (accent) must not.  SQLyog and MySQL on Windows sees that it is a ´ and does not escape.  Rightly so!

[…]

Vygi .. help us … or move somewhere else!  😀

[post=”7949″]<{POST_SNAPBACK}>[/post]

No panic! Please read my 3rd posting: SQLyog works correct!

*MS WINDOWS* has replaced alls “standalone” accents ´ by apostrophe ' when I have edited SQL file, that was the only reason! I've realized it just after my first posting here, sorry guys…

[vygi]

peterlaursen wrote on Nov 20 2005, 01:24 AM:

Caught in the act!  See attached!!

[post=”7944″]<{POST_SNAPBACK}>[/post]

Yes, that is very similar to what I've got.

When you minimize this window and restore it again, some parts will show parts of other windows.

I am not sure but maybe I also have minimized SQLyog having several connections. I will try to reproduce it tomorrow.

BTW resizing or moving window did not help in my case.

[vygi]

Recently I've got some similar problems related to the SQLyog (ver 5.0 final) window refresh/repainting.

We have many servers in our office intranet and I mostly have two connections to different hosts using same SQLyog instance, sometimes three. Last week I've opened 4 or even 5, and SQLyog has suddenly stopped window refreshing: just window border was visible and some icons. F5 was executing current query but only result grid was repainted; remaining screen remained unrefreshed: some parts of other windows were visible. Minimize/restore window did not help. I've tried to close single connections (Ctrl-F4) but with no success. After program restart all was fine again.

Few days later I've got exactly same problem again, and again after opening 4th or 5th connection.

I'm using Windows XP Professional with SP2.

Regards,

Vygi

[vygi]

peterlaursen wrote on Nov 19 2005, 12:33 PM:

Actually I have requested too that 'Bulk Size' could be user settable.

[post=”7935″]<{POST_SNAPBACK}>[/post]

Yes, it should be configurable.

BTW, max query size depends not only on MySQL server settings.

In my case, remote server was able to process up to 1 MB at once but has reported time out error because of low upload speed.

[vygi]

Sorry guys, I must investigate more before posting….

I have finally find out that Windows has replaced all ’ by ' after I've edited this file.

The bulk insert statement was too large and I split it into two parts.

And all ’ characters were automatically replaced by ' for some reason.

Sometimes I just hate windows….

Sorry for confusion once more!

[Author]

Posts