Blog navigation

Latest posts

Sage X3 silent import (IMPORTSIL) with error catching

You already know how to manually generate a CSV file in order to import it threw a template in Sage X3.
But If you wonder how to catch detailed errors after a silent import here is the solution.
Sometimes you need to catch the incoming errors in order to alert the end-user regarding an issue.
Closed period, wrong date etc ….
Unfortunalty the standard Sage X3 silent import function doesn’t natively show the detailed errors during the import process.
Call IMPORTSIL([M:IMP2]MODIMP,[M:IMP2]NOMIMP) From GIMPOBJ
And the standard function ERR_IMPORT will only show the overall status of the importation and not the detailed errors.

IMPORTSIL function is pushing all the log data into a tracefile in order to avoid any popup on end-user screen.
So you have a log file available in order to search for errors in it.
Sage X3 runtime is using the same principals standards as any shell for loging informations

0001 = Errors output

0000 = Standard output

Let’s make an example :

1) 4GL Silent import call

    Raz [M:IMP2]

    [M:IMP2]MODIMP = YAOENAME # Import Template Name

    [M:IMP2]NOMIMP = YTMPFILE # File Location and Name

    [M:IMP2]TYPEXP = 2 # Server

 

    Call IMPORTSIL([M:IMP2]MODIMP,[M:IMP2]NOMIMP) From GIMPOBJ

    Call ERR_IMPORT([M:IMP2]STAT, YMESSAGE) From GIMPOBJ

    If [M:IMP2]STAT or GOK < 1 : YRESTA += 1   # Import Error

    Else : YRESTA = 0 : Endif                  # Import Successful

    If !GSERVEUR : Call FERME_TRACE From LECFIC : Endif

2) Log reading

 

    Openi filpath("TRA",GTRACE,"tra",0) Using [YTRA]

 

    Local Char XLINE(100)

    Repeat

      Rdseq XLINE Using [YTRA]

      If left$(XLINE,5)="<0001"                  # This is an error

        Append YMESSAGE(YRESTA), right$(XLINE,6) : YRESTA += 1

        Break

      Elsif find(left$(XLINE,11), "Création de") # This is OK

        [L]Y2_TSKNUM = right$(XLINE,13)

        Append YMESSAGE(YRESTA), [L]Y2_TSKNUM : YRESTA += 1

      Endif

    Until fstat <> 0

    Openi Using [YTRA]

Posted in: Sage X3, 4GL