OnRun() BEGIN IF ISSERVICETIER THEN BEGIN IF UPLOADINTOSTREAM('Select File:','C:\Temp','TXT File *.txt| *.txt',ClientFileName,TestStream) THEN MESSAGE('Uploaded File') ELSE EXIT; END ELSE BEGIN TestFile.OPEN('C:\Temp\N43.txt'); TestFile.CREATEINSTREAM(TestStream); END; XMLPORT.IMPORT(57100,TestStream); IF NOT ISSERVICETIER THEN TestFile.CLOSE; END;
Import - Export::OnPreXMLItem() IF IOGLinConcil.FIND('+') THEN IOGContador := IOGLinConcil."Nº línea" + 10000 ELSE IOGContador := 10000; IOGLinConcilAnterior.INIT; Import - Import::OnBeforeInsertRecord() IOGLinConcil.INIT; IOGTipoLinia:=COPYSTR (IOGCadena,1,2); IF IOGTipoLinia='23' THEN IOGConcepte := COPYSTR(IOGCadena,43,38); IF IOGTipoLinia ='22' THEN BEGIN IOGDebeOHa := COPYSTR (IOGCadena, 28, 1); IF (IOGDebeOHa < '1') OR (IOGDebeOHa > '2') THEN currXMLport.SKIP; EVALUATE (IOGImporte, COPYSTR (IOGCadena, 29, 14)); IF IOGImporte = 0 THEN currXMLport.SKIP; IOGImporte := IOGImporte / 100; IF IOGDebeOHa = '1' THEN IOGLinConcil.VALIDATE (Haber, IOGImporte) ELSE IF IOGDebeOHa = '2' THEN IOGLinConcil.VALIDATE (Debe, IOGImporte); IF NOT EVALUATE (IOGAño, COPYSTR (IOGCadena, 11, 2)) THEN currXMLport.SKIP; IF NOT EVALUATE (IOGMes, COPYSTR (IOGCadena, 13, 2)) THEN currXMLport.SKIP; IF NOT EVALUATE (IOGDia, COPYSTR (IOGCadena, 15, 2)) THEN currXMLport.SKIP; IOGLinConcil."Nº línea" := IOGContador; IF (IOGAño >= 80) AND (IOGAño <= 99) THEN IOGLinConcil."Fecha registro" := DMY2DATE (IOGDia, IOGMes, IOGAño + 1900) ELSE IOGLinConcil."Fecha registro" := DMY2DATE (IOGDia, IOGMes, IOGAño + 2000); IOGLinConcil."Nº documento" := COPYSTR (IOGCadena, 43, 10); IOGLinConcil.Descripción := COPYSTR (IOGCadena, 23, 5); IOGLinConcil."Cód. banco" := IOGCodBanco; IOGLinConcil.INSERT; IOGContador := IOGContador + 10000; IOGLinConcilAnterior :=IOGLinConcil; END; IF IOGTipoLinia = '23' THEN BEGIN IF IOGLinConcilAnterior.GET(IOGLinConcilAnterior."Nº línea") THEN BEGIN IOGLinConcilAnterior.Descripción := IOGConcepte; IOGLinConcilAnterior.MODIFY; END; END;
Comments
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.