Bonjour,
j’essaie d’importer des données via un adapteur par une tâche cron.
new Integration().importADP(getGrant(), "ImportBCSIDeployment",
Tool.toInputStream(Tool.readUrl("urlVersMonFichier")), this.getName(), null);
et mon adapteur :
public class ImportBCSIDeployment extends SimpleXLSXAdapter {
private static final long serialVersionUID = 1L;
@Override
public String processCell(XSSFCell cell) throws InterruptedException {
try {
AppLog.info("processCell " , Grant.getSystemAdmin());
} catch (Exception e) {
AppLog.error(getClass(), "process", null, e, getGrant());
}
return "";
}
@Override
public void startProcessRow(XSSFRow row) throws InterruptedException {
try {
AppLog.info("startProcessRow " , Grant.getSystemAdmin());
} catch (Exception e) {
AppLog.error(getClass(), "process", null, e, getGrant());
}
}
@Override
public void endProcessRow(XSSFRow row) throws InterruptedException {
try {
AppLog.info("endProcessRow " , Grant.getSystemAdmin());
} catch (Exception e) {
AppLog.error(getClass(), "process", null, e, getGrant());
}
}
@Override
public void startProcessSheet(XSSFSheet sheet) throws InterruptedException {
try {
AppLog.info("startProcessSheet " , Grant.getSystemAdmin());
} catch (Exception e) {
AppLog.error(getClass(), "process", null, e, getGrant());
}
}
@Override
public void endProcessSheet(XSSFSheet sheet) throws InterruptedException {
try {
AppLog.info("endProcessSheet " , Grant.getSystemAdmin());
} catch (Exception e) {
AppLog.error(getClass(), "process", null, e, getGrant());
}
}
@Override
public void startProcessWorkbook(XSSFWorkbook workbook) throws InterruptedException {
try {
AppLog.info("workbook " , Grant.getSystemAdmin());
} catch (Exception e) {
AppLog.error(getClass(), "process", null, e, getGrant());
}
}
@Override
public void endProcessWorkbook(XSSFWorkbook workbook) throws InterruptedException {
try {
AppLog.info("endProcessWorkbook ", Grant.getSystemAdmin());
} catch (Exception e) {
AppLog.error(getClass(), "process", null, e, getGrant());
}
}
}
Exemple.xlsx (210.7 KB)
2021-02-18 21:01:01,824 INFO [com.simplicite.util.engine.Interface] SIMPLICITE|http://9bea7c2e2913:8080||ICOREIO001|p104635|com.simplicite.util.engine.Interface|importData||I/O info: Start scanning data, origin: BCSIMetaDataImporter
2021-02-18 21:01:01,705 ERROR [com.simplicite.adapters.BCSIModule_Meta.ImportBCSIDeployment ] SIMPLICITE|http://9bea7c2e2913:8080||ERROR|p104635|com.simplicite.adapters.BCSIModule_Meta.ImportBCSIDeployment |process||Event: Error during Excel workbook processing (at sheet -1, row -1, cell -1)
java.util.zip.ZipException: invalid stored block lengths
at org.apache.commons.compress.archivers.zip.ZipArchiveInputStream.readFromInflater(ZipArchiveInputStream.java:586)
at org.apache.commons.compress.archivers.zip.ZipArchiveInputStream.readDeflated(ZipArchiveInputStream.java:551)
at org.apache.commons.compress.archivers.zip.ZipArchiveInputStream.read(ZipArchiveInputStream.java:458)
at java.base/java.io.FilterInputStream.read(FilterInputStream.java:132)
at org.apache.poi.openxml4j.util.ZipArchiveThresholdInputStream.read(ZipArchiveThresholdInputStream.java:79)
at org.apache.poi.util.IOUtils.toByteArray(IOUtils.java:152)
at org.apache.poi.util.IOUtils.toByteArray(IOUtils.java:121)
at org.apache.poi.openxml4j.util.ZipArchiveFakeEntry.<init>(ZipArchiveFakeEntry.java:47)
at org.apache.poi.openxml4j.util.ZipInputStreamZipEntrySource.<init>(ZipInputStreamZipEntrySource.java:53)
at org.apache.poi.openxml4j.opc.ZipPackage.<init>(ZipPackage.java:106)
at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:301)
at org.apache.poi.ooxml.util.PackageHelper.open(PackageHelper.java:37)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:303)
at com.simplicite.util.integration.SimpleXLSXAdapter.process(SimpleXLSXAdapter.java:42)
Sauriez-vous pourquoi j’ai cette erreur ?
Au passage, pourriez-vous regénérer votre javadoc (celle sur la classe SimpleXLSXAdapter est incomplète).
Merci pour votre support
Amandine T.
[Platform]
Status=OK
Version=4.0.P25
BuiltOn=2021-02-03 12:18 (revision ad67c22c50ac1a7123b8ee2fba1ad4c4734f148a)
Encoding=UTF-8
EndpointIP=21.0.9.3
EndpointURL=http://9bea7c2e2913:8080
TimeZone=Europe/Paris
SystemDate=2021-02-18 21:16:34