How to use Mapping Form to import item journal

selece28

Hi all
I have a problem when importing data from excel file to item journal line
I can do mapping for some fields but having problem with the [Line No.] fields because when importing the auto number in Line No. fields didn't work
So everytime i import using mapping form, it only imported 1 records

Could someone tell me how to solve this problem?
Thanks

ssingla

Make a field "Line Number" in the excel sheet and specify it in the dataport. Give different line number on each row in the excel sheet and import.
It will solve the problem.

Savatage

Or you can generate the line no on import...

Variable
LineNo (Integer)

OnPreDataPort()
LineNo := 10000;

OnAfterImportRecord()
LineNo := LineNo + 10000;
"Line No." := LineNo;

Waldo

Just to clear something up.

Savatage wrote:

Or you can generate the line no on import...

Variable
LineNo (Integer)

OnPreDataPort()
LineNo := 10000;

OnAfterImportRecord()
LineNo := LineNo + 10000;
"Line No." := LineNo;

This is indeed a correct solution when using dataports, but selece28 is using the mapping form (form 8601). This can import stuff directly from the excel sheet. ssingla's solutions should work.

selece28

Thanks,
But what did i get after the import process? The number from excel or the original Line No. autonumber? I want my imported records to have the original Line No. autonumber

Regards,
Steven

ssingla

What is original Line Number.Auto Number. :-k

It is increment of 10000 (Indian Version) , so define the line number accordingly in the excel sheet.

Mbad

Never seen those forms before and im pretty sure they wont last till vers. 5.0 Honestly with the bad translation and the bad numbering etc. it looks like its a mistake its even in the database.
Is it somewhere on the menusuite?

David_Singleton

Mbad wrote:

Never seen those forms before and im pretty sure they wont last till vers. 5.0 Honestly with the bad translation and the bad numbering etc. it looks like its a mistake its even in the database.
Is it somewhere on the menusuite?

The new tool in 5.0 is for export only (for now at least ) so this will still be the way for importing I guess.

Mbad

Your build must be higher than mine then cause i cant find it.
Still I wouldnt use this. It looks like unfinished business. I mean a fieldcaption that is called ValidateInsertModify?

ssingla

I am not a techie but I guess it validates the fields which are inserted.

I always puts the validation on the field for which master data/related data exists in the database. i do not know whether it is right or wrong but it saves wrong insertion of data.

I am finding this mapping pretty useful .

selece28

Yes, i find this form very useful to import data from excel sheet
The problem is when importing auto number fields


And yes, i would like the auto number to be the increment of 10000. Then it means i have to create a column in my excel file with the value of increment number by 10000, is that true ssingla?

ssingla

Yes

selece28

Ok then, my problems solved.
Just curious, Is there any other way without creating Line No. column in my excel sheet?

Thank You ssingla

ssingla

Mark [solved] on the issue if the issue is resolved.