Dear all,

I'm a new member of BaaNboard, I really interesting to the BAANXL created by Mr Vamsi. I have followed the instruction based on the thread #5880. I've created the forms, but I didn't find the program scripts of the form. Are there someone help me? :(

Dear All,

Finally, I've got the program script and I can run the BAANXL as the device choice. But, now I face a new problem. When I try to preview.report, the result is only the num=> characters. Lines of the file were blank. Did I make any mistake?

Thank you very much for your help.

Regards,
Ciptadi.

I have splitted off your posts from the original thread because your question had nothing to do with the content of ~Vamsi's thread.

I guess that I didn't create the file correctly. When the first script execute, it must be create a file (fp1) then this file directory copied when the session started. I guess, if the action success it must give result a file that can be viewed with command preview.report.

Are there someone has any idea?

Regards,
Ciptadi.

Ciptadi,

Did you download and follow the instructions in the word document attached? If so, describe what steps you have followed so far and where you are running into trouble.

Yes, I have downloaded and followed the instructions in BAANXL Guide.

Now, I could run this BAANXL until converted to become Excell file. But it because I modified the First program script:

I've change your prog script zusfwexcel with "cbcomexcel", and this prog script starts the session "cbcomexcell" with prog script "cbcomexcell".



|* zusfwexcel 0 VRC B50C b dev = tccomexcel
|* Title: BaanXL
|* Author: Vamsi Potluru
|* Co-Author: Praveen Ambekar
|* Date: 2001-12-17 [17:17]
|******************************************************************************
|* License:
|* Copyright 2001 by Vamsi Potluru
|*
|* All Rights Reserved
|*
|* Permission to use, copy, modify, and distribute this software and its
|* documentation for any purpose and without fee is hereby granted,
|* provided that the above copyright notice appear in all copies and that
|* both that copyright notice and this permission notice appear in
|* supporting documentation.
|*
|* Vamsi Potluru DISCLAIMS ALL WARRANTIES WITH REGARD TO THIS
|* SOFTWARE, INCLUDING ALL IMPLIED WARRANTIES OF MERCHANTABILITY
|* AND FITNESS, IN NO EVENT SHALL Vamsi Potluru BE LIABLE FOR ANY
|* SPECIAL, INDIRECT OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES
|* WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS,
|* WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE OR OTHER
|* TORTIOUS ACTION, ARISING OUT OF OR IN CONNECTION WITH THE USE
|* OR PERFORMANCE OF THIS SOFTWARE.
|******************************************************************************

longret| general return variable

extern domain tcmcs.str215 input.file| input file - created by Baan
extern domain tcmcs.str215 argument

function main()
{
input.file = creat.tmp.file$(bse.tmp.dir$())
argument = argv$(3)

wait.and.activate("ttstpconv", argv$(1), input.file, "ASCII", argv$(4))
start.session(MODAL,"cbcomexcel","","")
ret = seq.unlink(input.file)
}
|*******************************************************

The problems are:

When I run this program script, it can't create the input.file.

I've tested this by showing the message when the session cbcomexcell started. This session import the input.file and argument. So, at the first this session starts, I show the message that contains the input.file and argument. The message showed only "" (blank).

There are two possibilities in this case:
1. The process create "input.file" was failed
2. The process import variable "input.file" was failed
The process import variable "argument" was failed

Actually, I can solve this problem, by create new button in session, to replace the process create input.file. And it was created succefully.

The next problem is:
- When I run "save.default.values" for the first time. So when, run the BAANXL for the second time, etc, it will perform directly. It because the syntax in the before program, to perform the process.file if the argument isn't "ADMIN".

Now, I confuse, how to import the argument into the session. because the result is always "".

Do you have any method, how to recognize while the session performed from BAANXL, or from BAANXL-ADMIN?


The other problem is:

The result of the report (in excell), for the numeric data is irregular.

for example:
* 86.900,0000 (eighty six thousand an nine hundred)
If I set this data (In the fill details) with string it will become 86.900,000
* 2,0000 (two)
If I set this data (In the fill details) with string it will become 20,000


OTHERWISE,

* 86.900,0000 (eighty six thousand an nine hundred)

If I set this data (In the fill details) with numeric it will become 86.9

* 2,0000 (two)

If I set this data (In the fill details) with numeric it will become 20000


Ho to set the data type "date" ?
I follow your example, set the data type for date to numeric, but when the file converted, I can't format the data(in excell) to become date type the result is #########


For example :

date 03062006 (3rd June 2006) it will become 3062006 in excell
date 14062006 (14th June 2006) it will become 14062006 in excell, but I can't set this data to become date type.


I'm sorry if my question is too long.

Thank you very much for your help, God bless you.


Thank's & Regards.
CIPTADI.

The problems are:

When I run this program script, it can't create the input.file.

I've tested this by showing the message when the session cbcomexcell started. This session import the input.file and argument. So, at the first this session starts, I show the message that contains the input.file and argument. The message showed only "" (blank).


Ciptadi,

As a first step could you please troubleshoot why you cannot create a file as specified in the script. This could have consequences later.

Dear Mr Vamsi,

Actually, I can finish my problems. Now, I can convert BaaN to MS Excell. But I have a problem, when I convert a text which contains comma (in one column), it will separated as some column, whereas it's a part of one column.
How to solve it :confused: ?

Thank you very much for your help.

Best Regards,
Ciptadi.

Note: As can as possible, I don't want to change the column separator with other character, because MS Excell will recognize comma as column separator(standard).

how to fetch month from the date format