Hi! I’m in trouble with a data import.
This is the cvs file:
“ArtNo({”“constraints”":[],"“type”":"“STRING”","“dataSize”":36,"“dataSizeAuto”":true,"“defaultValue”":"“00000000"”})",“description({”“constraints”":[],"“type”":"“TEXT”"})",“expireDate({”“constraints”":["“NN”"],"“type”":"“DATETIME”","“defaultValue”":"“2019-08-09 22:00:00"”})",“img({”“constraints”":["“NN”"],"“type”":"“FILE_REF”","“dataSize”":500,"“defaultValue”":"“https://backendlessappcontent.com/MY-PERSONAL-DATA/files/view/deals/no-image-deal.jpg”"})",“maxQuantity({”“constraints”":["“NN”"],"“type”":"“INT”","“defaultValue”":"“0"”})",“newPrice({”“constraints”":["“NN”"],"“type”":"“DOUBLE”","“defaultValue”":"“0"”})",“note({”“constraints”":[],"“type”":"“STRING”","“dataSize”":44,"“dataSizeAuto”":true,"“defaultValue”":"“Text”"})",“priceCurrency({”“constraints”":["“NN”"],"“type”":"“STRING”","“dataSize”":36,"“dataSizeAuto”":true,"“defaultValue”":"“€”"})",“startDate({”“constraints”":["“NN”"],"“type”":"“DATETIME”","“defaultValue”":"“2019-08-06 22:00:00"”})",“title({”“constraints”":["“NN”"],"“type”":"“STRING”","“dataSize”":78,"“dataSizeAuto”":true,"“defaultValue”":"“Titel des Deal”"})",“volumePrice({”“constraints”":[],"“type”":"“DOUBLE”","“defaultValue”":"“0"”})",“volumeType({”“constraints”":[],"“type”":"“STRING”","“dataSize”":36,"“dataSizeAuto”":true,"“defaultValue”":""""})"
AP20200651,Die Beschreibung folgt in kurzem…,Thu Mar 26 18:04:36 UTC 2020,https://backendlessappcontent.com/MY-PERSONAL-DATA/files/view/deals/fabio-esposito/AP20200651.jpg,100000,5.87,Paluani/Mughett,EUR,Thu Mar 26 18:04:36 UTC 2020,COLOMBA CLASSICA CON CANDITI,11.74,Kg
AP20200602,Die Beschreibung folgt in kurzem…,Thu Mar 26 18:04:36 UTC 2021,https://backendlessappcontent.com/MY-PERSONAL-DATA/files/view/deals/fabio-esposito/AP20200602.jpg,100000,1.94,Rio Mare,EUR,Thu Mar 26 18:04:36 UTC 2021,TONNO IN OLIO RIO MARE 80gr,12.125,Kg
AP20200599,Die Beschreibung folgt in kurzem…,Thu Mar 26 18:04:36 UTC 2022,https://backendlessappcontent.com/MY-PERSONAL-DATA/files/view/deals/fabio-esposito/AP20200599.jpg,100000,0.78,SAI,EUR,Thu Mar 26 18:04:36 UTC 2022,SALE FINO (FEINGEMAHLEN),0.78,Kg
AP20200598,Die Beschreibung folgt in kurzem…,Thu Mar 26 18:04:36 UTC 2023,https://backendlessappcontent.com/MY-PERSONAL-DATA/files/view/deals/fabio-esposito/AP20200598.jpg,100000,0.78,SAI,EUR,Thu Mar 26 18:04:36 UTC 2023,SALE GROSSO (GROB GEMAHLEN),0.78,Kg
This the error from the log file:
13:51:30 IMPORT_DATA Importing Started.
13:51:30 IMPORT_DATA Preparing files to import
13:51:30 IMPORT_DATA Copying of Deals.csv, size: 0.003 MiB.
13:51:30 IMPORT_DATA Creating temporary tables
13:51:30 IMPORT_DATA Creating user’s tables
13:51:30 IMPORT_DATA Preparing Deals table: initializing columns.
13:51:31 IMPORT_DATA Import of tables failed: Property value for “description” exceeded the maximum allowed size (500 symbols)
13:51:31 IMPORT_DATA Importing failed. Exception:com.backendless.exceptions.persistence.InvalidEntitySizeException: Property value for “description” exceeded the maximum allowed size (500 symbols)
com.backendless.management.impex.manager.imports.data.CommonDatabaseUtils.ensureDataSize(CommonDatabaseUtils.java:48)
com.backendless.management.impex.manager.imports.data.ImportDataManager.initColumn(ImportDataManager.java:761)
com.backendless.management.impex.manager.imports.data.ImportDataManager.initColumns(ImportDataManager.java:746)
com.backendless.management.impex.manager.imports.data.ImportDataManager.initTables(ImportDataManager.java:692)
com.backendless.tasks.impex.ImportDataTask.doExecute(ImportDataTask.java:173)
com.backendless.tasks.impex.ImportDataTask.executeImpl(ImportDataTask.java:124)
com.backendless.tasks.impex.AbstractImportTask.execute(AbstractImportTask.java:83)
com.backendless.taskman.Task.run(Task.java:136)
com.backendless.taskman.TimeoutFixedThreadPoolExecutor.executeTaskWithTracker(TimeoutFixedThreadPoolExecutor.java:91)
com.backendless.taskman.TimeoutFixedThreadPoolExecutor.lambda$invoke$0(TimeoutFixedThreadPoolExecutor.java:39)
java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
java.base/java.lang.Thread.run(Thread.java:834)