Empty file - dataport

Srivas · 2009-01-29

I am importing csv file from a dataport and then copy the file to a different folder.
It imports correctly but the file is empty.
I don't know why the file is empty after import. ](*,)

kapamarou · 2009-01-29

Do you do it manually or through code?

Srivas · 2009-01-29

through code

Savatage · 2009-01-29

OnAfterImportRecord()

OrderCount := OrderCount + 1;

text constants:
Text0001-> %1 Orders Imported / Would You Like To Delete The File?
FilePath->c:\DataportFile\Completed Import\

OnPostDataport()

CurrFile.CLOSE;  //don't forget to close!
IF CONFIRM(Text0001,TRUE,OrderCount) THEN BEGIN
SavedFileName := FORMAT(WORKDATE,0,'<Year4>'+'-'+'<Month Text,3>'+'-'+'<Day,2>')+'.txt';
FILE.COPY(CurrDataport.FILENAME,FilePath+SavedFileName);
ERASE(CurrDataport.FILENAME);
END;

In this example of moving a file after import to another directory - my new filename becomes the day month year.

Srivas · 2009-01-29

I call the dataport from a code unit like this

GLEAdjImport.IMPORT := TRUE;
GLEAdjImport.FILENAME := ImpFile.Path + '\' + ImpFile.Name;
GLEAdjImport.RUN;

And then in code unit itself I move the file to new location

IF COPY("Imp Ready to Process Location" + '\' + ImpFile.Name,"Imp Processed Location" + '\' + ImpFile.Name) THEN
ERASE("Imp Ready to Process Location" + '\' + ImpFile.Name);

Savatage · 2009-01-29

have you tried your move from the dataport as i did?
have you tried closing the file before moving it?

DaveT · 2009-01-29

Savatage wrote:

have you tried closing the file before moving it?

My money is on this

Srivas · 2009-01-29

I have taken IMPfile as a record variable of file which donot have close method.

Savatage · 2009-01-29

why not just add the code to onpostdataport trigger?

are you obligated to move the file using the codeunit?

Empty file - dataport

Comments

Categories