Import Dataport

fmhigue

I created a Dataport to import Frozen Prices. I only have Item No, and List Price on the Text file.

The rest of the information I am getting it on the Request Form. (Beginning Data, Ending Date, Requested by, etc). The problem is only Item No. and List are getting import to the Frozen-Special Table.

Here is my code:

Frozen-Specal Price - OnPreDataItem()
LineNo := 0;
Counter := 0;
FrozenSpecial.INIT;


Frozen-Special Price - OnAfterImportRecord()
FrozenSpecial."Price Type":=PriceType;
FrozenSpecial."Customer Type":= CustomerType;
IF FrozenSpecial."Customer Type" = "Customer Type"::Customer THEN
FrozenSpecial."Price Group Code":= CustomerNo
ELSE
FrozenSpecial."Price Group Code":= ChainNo;

FrozenSpecial."Item No.":= "Item No.";
FrozenSpecial."List Price":= "List Price";
FrozenSpecial."Beginning Date":= BeginningDate;
FrozenSpecial."Ending Date":= EndingDate;
FrozenSpecial."Currency Code":= CurrCode;
FrozenSpecial."Discount %" := 0;
FrozenSpecial."Requested By":= RequestedBy;
FrozenSpecial."Supress Profit Warning":= '';
FrozenSpecial."Special Price/Percentage" := "Special Price/Percentage"::Price;
Counter += 1;

Any ideas?
Thank you in advance

Dave_Cintron

Without more data I'm guessing, but it looks like you have FrozenSpecial declared as a variable separate from the dataport Data Item, then you have only the 2 variables importing to the Data Item, then you are filling out FrozenSpecial but there is no INSERT.

fmhigue

Dave thank you a lot.

What a mistake I just fixed it and it work perfectly.