From BaaN IVc, I want to export whole Item Master Data with all Fields to MS-Excel or DBF file. Can anyone help me how to do? I tried the BaaN Sequential Dump of Table but it doesn't export fields names.

Waiting for response.

Regards,
surjeet_rna

Hi,

There are various way to print in excel file.
1. From ttaad4500,Goto Print Option and "set as hex dumps by string" as N and continue
2. Taking sequential dump of table with field separator,download the file to local machine and open in excel.

Enjoy.
Yashwant

Hi,

1. I had already tried sequential dump of table with field separator but using this Field Names are not copied. For Example:

item dsca dscb dscc ....... // table fields
CAL01 Ampoxin-LB 250 --- ---- // table data

I want to expport all data to dbf or excel file.

Regards,
surjeet_rna

you could try the search option on the board.

http://www.baanboard.com/baanboard/search.php?searchid=788329


or you could export the data into a comma separated format and then
add the column names yourself.

it would probably take 10 minutes.

Dave

IF u download and install the ERPJewels tool (http://sourceforge.net/project/platformdownload.php?group_id=207529) , u can do such things in a jiffy with lots of other flexibility & functionality .

Without this tool , as others pointed out and I too know lot many other ways (like sequential export / exchange / ODBC fetching in Excel / other 3rd party tools ) this can be done . Through ODBC fetching the columns names will come in excel (but u have to write meaningful names in ODBC query else table field codes like t_item will come ) .

PS- Noticed u r on bisam. Then ODBC will not help and ERPJewels is best option.

After download the data from "Create sequential dump from table" ..Print fields of item master from table defination in excel file.The fields will come in vertical,Transpose it to horizontal and paste this in your data file..It will be done.

Bye
Yashwant