Import .CSV or .XLS into B1 and generate Sales Orders

[Former Member]

Hello all. I was wondering if there are any examples/samples to IMPORT an .CSV / .XLS file into SAP B1.

There are about 2500 + lines in this excel file and I am looking to import the data into a Sales Order Form, but I don't know where to begin.

This Excel file cannot change it's format, so that is why I cannot use the DTW (Data Transfer Workbench).

Any help would be much appreciated. Thanks in advance!

[Nussi · Accepted solution]

Hi,

the easiest way is to use a .csv instead of .xls.

because the .csv you can open like a normal textfile in your addon.

go through the .csv line by line

you have to split the each line in it's "fields" - the separator is usually ;

add the data to a document object.

the logik itself shouldn't be that difficult

it's just some "writing work"

lg David

[Former Member]

Any sample code I can analyze please?

[Former Member]

Hi Quoc Ho

Look these threads:

- [Import Data to UDO|; (look code of Vitor Vieira to import Purchase Order);

- [How to read data from excel file|;.

Regards

Sierdna S.

[Former Member]

Hi

You can use excel file to import data to SAP B1 tables, but you need to make all checks of fields values what you need to add.

Some threads may be usefull. Look [here |; for list.

For reading data from excel files... [here|;.

Regards

Sierdna S.

[former_member209699]

Hi,

First try to copy all the data from csv to any one temporary table. And after that you can refer that table for replecating onto B1 tables.

It should work.

regards:

SANDY

Edited by: | Sandeep Saini | Roorkee | India on Oct 8, 2008 2:04 PM