A problem when a report is open in Excel application.

Nornally, the data is all in the first column with the "|". Then we manually format it with Text to Column in Excel.

Now, there are some users just encounter the issue that the data is not all in the first column and it's all mess up. It was working fine before. I don't know what happen. PLEASE HELP!!!!
:confused:
The Excel Device is setup as follow:
4GL Program: ttstpconv
ArgumentASCII: EXCEL.EXE %s
path: ${BSE}/tmp/file1.xls

Hello,
The device definition seems ok. I should check on the client side configuration. Or, perhaps if the problem are not present in all reports, check the particular report that you users report.

Hope this helps.

I think there is a problem with the latest update for MS Excel 2003. This not happen to all users. I found that it happens to the users who have installed the MS08-014 Security update for Excel 2003.

I find that there is a known issue with this MS08-014 update, but it does not actually related to Text To Column function. How can I fix this? Any idea??

THANK YOU :confused:

Try to change the filename into:

${BSE}/tmp/file1.csv

We had the same problem and with this change it seems to be working! Please give me a short feedback!

It's still not working. I tried both of the following:

${BSE}/tmp/fileout.csv
${BSE}/tmp/fileout

But the output is still messed up. Please help....:confused:

The path setting (csv) has no influence on the file opened in Excel.
Excel opens always a tmpxxxxx.txt.
So the problem remains. We have the same problem.

Has anyone a solution?

Hi,

this is related to the country settings in Windows. Please refer to my post here (http://www.baanboard.com/baanboard/showthread.php?t=47901&highlight=EXCEL)

I agree that the separator setting is applicable on a csv file.
But Baan doesn't generate a csv file.
If using UNIX/AIX always a .txt file is generated, so the problem remains the same!

I'm having the same problems. I anyone solved it, please let me know!!

Greetz

Hello,
In order to review the problem, Can you post here, some screen shots of the information?

This is the behaviour when we import to excel.
See the attachement.

Hello,
I belive it is a client side configuration problem. Can you post a sample file?
I will try to import to excel. My first impression is that the client have been defined pipe like separator from somewhere else, bsides excel.

Here's the file.
We also have a custom made device that uses a 4GL program :otccomwordexc
In the "argument" it uses a excel template specified on a windows server.
I have rewritten the Macro and filtered out the delimiters.
Now everything is put into 1 cell and our users can use the wizard "text to columns" themselves.

I don't have an anwser for the device that uses the 4GL program "ttstpconv"

Hi,

are you sure that the user chooses delimited as option when opening the file in Excel. The only way i can reproduce your problem in by clicking Finish when the Text Import Wizard starts (Screen 1 of 3) and the default setting for Original Datatype is set to Fixed Width.

Hello,
I succesfully imported the data of your file to an excel sheet.
Also in your message says, that you are using a macro to do the distribution fo the data acrosss the excel columns, right?

So, my dear friend, this is not a Baan related problem. Your macro is not working as expected. Therefore, if your macro have not been modified, then, almos sure you have installed something Microsoft patch that modifies your macro! At this point my only sugestion is to try your macro on a fresh Microsoft office instalation.

Hope this helps.
Good luck.

I found out what causes this problem:

Excel Update : http://www.microsoft.com/netherlands/technet/security/bulletin/ms08-014.mspx

I don't have a solution for this bug yet.

I found out what causes this problem:

Excel Update : http://www.microsoft.com/netherlands/technet/security/bulletin/ms08-014.mspx

I don't have a solution for this bug yet.

bkkland already mentioned this!!! :rolleyes:

Thanks,

We have solved the problem by editing the macro.
Now everything is placed into 1 cell.
Then the user can use the "text to columns" wizard.

Everything works fine now.

Greetings Errol

Can You share the macro?

Using Excel %s in session ttaad3100m000 with path: baan.csv solves the problem. You have to set your windows list separator of course.
Now the Baan output is directly placed into the columns properly!

Only disadvantage is that this solution uses a fixed filename (baan.csv in this example) i.o. an unique name in the old way of working. So You can open only 1 excel output at a time.
Does anyone have a solution to solve this (by creating unique filenames at runtime)?

Hello,

There is a solution in codes & utilities to produce an excel friendly file.
It needs an awk but was also translated by others on windows.
The csv file cuts with 0 starting numeric columns but works fine.

regards

Thanks,

We have solved the problem by editing the macro.
Now everything is placed into 1 cell.
Then the user can use the "text to columns" wizard.

Everything works fine now.

Greetings Errol

Yes - can you share this solution and macro? None of the other solutions will work at our site. We can't change the list separator.

Hi
We have also a number of users (including myself last week) where exactly the same thing started to happen. It was OK one day and then the following day when choosing device 'Excel' the Baan reports automatically split into columns (incorrectly) instead of placing the data in Column A. It is infuriorating.

Reading the previous posts it is implied that the problem is related to a Microsoft update - is this correct? Some of you have also talked about macros - have you had to edit a automatic Excel macro for importing text files. To me it seems stupid to have to create your own macros.

So what I really want to know is ..
1 - do we know what has definitely caused this problem?\ & can we avoid it for future users?
2 - Is so what is the quickest solution (apart from sending the report to Wordpad, cutting and pasting into Excel and then continuing as normal with the Text to Columns feature?

thanks in advance :D

We use the solution that changed the sperator at the Window, but it cause other problems for some users that use Excel function.

We submitted a case to Baan Support to see if they have any solution. There a patch but not sure it working or not after installing the patch.

This hotfix solved our problem:

Hotfix 952208 http://support.microsoft.com/kb/952208/