Hi,
I’ve got the same problem like few days ago.
Here the content of the import log file:
10:20:02 IMPORT_DATA Importing Started.
10:20:02 IMPORT_DATA Preparing files to import
10:20:02 IMPORT_DATA Copying of menusItems.csv, size: 0.004 MiB.
10:20:02 IMPORT_DATA Creating temporary tables
10:20:02 IMPORT_DATA Creating user's tables
10:20:02 IMPORT_DATA Preparing menusItems table: initializing columns.
10:20:02 IMPORT_DATA Import of tables failed: Property value for "additives" exceeded the maximum allowed size (500 symbols)
10:20:02 IMPORT_DATA Importing failed. Exception:com.backendless.exceptions.persistence.InvalidEntitySizeException: Property value for "additives" 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)
I’ve attached my cvs file that I’ve tried to import.
Thanks for your help!
Mario
menusItems.csv (3.9 KB)
Hello @Mario_Canevarollo
I just imported your csv file into my new app without any issues.
Could you please try one more time with a new app or provide us additional steps to reproduce the problem.
my log:
10:58:22 IMPORT_DATA Importing Started.
10:58:22 IMPORT_DATA Preparing files to import
10:58:22 IMPORT_DATA Copying of menusItems.csv, size: 0.004 MiB.
10:58:22 IMPORT_DATA Creating temporary tables
10:58:22 IMPORT_DATA Creating user's tables
10:58:22 IMPORT_DATA Preparing menusItems table: create schema.
10:58:23 IMPORT_DATA Preparing menusItems table: initializing columns.
10:58:28 IMPORT_DATA Preparing menusItems table: updating column related IDs.
10:58:28 IMPORT_DATA Preparing menusItems table: initializing relations.
10:58:28 IMPORT_DATA Checking denied and duplicate columns.
10:58:28 IMPORT_DATA Resolving related table.
10:58:28 IMPORT_DATA Getting meta-info about insetable tables.
10:58:28 IMPORT_DATA Start import table: menusItems
10:58:28 IMPORT_DATA Table 'menusItems' was imported at 0 seconds. Saved 42 records.
10:58:28 IMPORT_DATA Finish import table: menusItems
10:58:28 IMPORT_DATA Started restoring relations.
10:58:28 IMPORT_DATA Clearing user data table cache.
10:58:28 IMPORT_DATA Deleting temporary tables.
10:58:29 IMPORT_DATA Finishing pointers export.
10:58:29 IMPORT_DATA Restoring expiration tasks for DeviceRegistrations.
10:58:29 IMPORT_DATA Import finished.
Regards, Vlad
It is so frustrating! Every time that I want to import new data into a table I get the same problem.
I can’t every time delete the table, recreate it and import finally the data. Also because I will lost my relations.
Is there an other way to import data to a table?
I don’t see any relations in the menusItems.csv file.
Could you please provide all the steps to reproduce the problem?
Here the video about the steps that I’ve followed.
ok, provide please your appId
My AppId:
AA0CC718-4B21-C574-FF0A-624EEA04DA00
Now I see where the problem is.
In your csv I can see that shortDescription is TEXT data type:
shortDescription({""constraints"":[],""type"":""TEXT""})
but in your data schema is “STRING” dataType specified.
I’m going to create an internal ticket to fix error message in the log output, however as a workaround I can propose you to change the column in the csv file to the following one:
shortDescription({""constraints"":[],""type"":""STRING"",""dataSize"":250,""dataSizeAuto"":false})
Regards, Vlad
Regards, Vlad
Ok, Now it works. Thanks a lot Vlad!
stay healthy
Please let me know how to handle this type of information of a FaceRecognition data:
“[-0.17113525 0.03394878 0.05539499 -0.15419377 -0.09586173 -0.07617393\n 0.00353586 0.01201518 0.17828736 -0.09959501 0.16390234 -0.0117666\n -0.24600323 -0.01351003 0.04984597 0.21909235 -0.24951109 -0.10450409\n -0.15963088 -0.0458378 0.02889594 0.0772904 0.00874032 0.09176794\n -0.11941934 -0.35257047 -0.06420058 -0.06144265 -0.03583916 -0.01231775\n 0.00125447 0.09167829 -0.14507243 -0.04326186 0.064956 0.10459989\n -0.05120549 -0.06550813 0.21243767 0.07035262 -0.18633159 -0.03386188\n 0.06540138 0.29181936 0.150677 0.02179301 0.04113857 -0.03765064\n 0.12621459 -0.30273193 0.00915759 0.11780986 0.10232864 0.0514505\n 0.14102221 -0.14881657 0.0710285 0.22472259 -0.28889066 0.09456245\n -0.02632923 -0.20513886 -0.03750928 -0.11303782 0.23300767 0.12030827\n -0.15401217 -0.12939382 0.146717 -0.08279873 -0.08043581 0.0377623\n -0.12918229 -0.20162892 -0.36182359 -0.01918942 0.32901943 0.14064442\n -0.18911332 0.04187616 -0.00463464 -0.08810019 0.04964426 0.16134855\n -0.08471709 -0.00060301 -0.07262702 0.06250948 0.15668124 -0.02796761\n -0.00607337 0.22457886 0.01911652 -0.00327939 -0.0263204 -0.01106801\n -0.1072505 -0.04145628 -0.12997609 -0.0063486 0.03647438 -0.10317151\n -0.00651391 0.05453994 -0.17815176 0.08822814 -0.0067255 -0.08231965\n -0.09872936 -0.02221727 -0.1133105 -0.02829476 0.12799725 -0.25078681\n 0.18975149 0.26431915 -0.00332375 0.16520399 0.01975095 0.0053516\n -0.01882976 0.00632899 -0.13884465 -0.04734213 0.12155446 0.0123738\n 0.10821094 0.04842498]”
128 Words and 1503 Characters in 19 lines.
I’m using String but is more than 500.
Thanks, Mario
I found TEXT and is working!