I used Import option in Database menu, Tables section. I received message the work will take some time, I will be notified by email. I received those email with a log file about my file data transfer. All perfect, but in the table there aren’t any record !?!?!
What is the problem?
Hi. Could you share the example of the csv data you try to import.
(you can send it on firstname.lastname@example.org).
Also, provide the appId where you tried to run the import.
I’ve checked your import log (if i found you app correctly).
All the records has error messages:
Ignores rows with values [1, 1, 184.108.40.206, 20/07/2023 21:12:38, 2, Servicio terrrible, no se como pueden dormir en las noches, 3, El servicio es regular, El servicio fue regular., NONE, , NONE, , 2023-08-30 23:58:21, 476D0DFB-497D-4291-96EB-C47D723801A6, 09/04/2023 03:07:25 UTC, null]. Invalid date format for value '20/07/2023 21:12:38'
Opps… Yes. Date format… ufffff… I don’t know how to apologize for having wasted your time. I looked at that log cursorily without reading every line. It seemed to me that everything was fine when it was the other way around.
Now I converted date to YYYY-MM-DD format and I received a log with notification the process finished succesfully. But … I can’t see the records … This is the log:
Backendless finished import your data successfully for application: TerapiaOc.
The Import log located in File Service’s “import” directory.
See Import log bellow:
1 18:11:57 IMPORT_DATA Importing Started.
2 18:11:57 IMPORT_DATA Preparing files to import
3 18:11:57 IMPORT_DATA Creating temporary tables
4 18:11:57 IMPORT_DATA Creating user’s tables
5 18:11:57 IMPORT_DATA Checking for existing views with the same names as in imported tables
6 18:11:57 IMPORT_DATA Checking denied, duplicate and dataSize for columns.
7 18:11:57 IMPORT_DATA Preparing Cliente01_Res_Base_Res_YYYY_MM_DD table: create schema.
8 18:11:57 IMPORT_DATA Preparing Cliente01_Res_Base_Res_YYYY_MM_DD table: initializing columns.
9 18:12:05 IMPORT_DATA Preparing Cliente01_Res_Base_Res_YYYY_MM_DD table: updating column related IDs.
10 18:12:05 IMPORT_DATA Preparing Cliente01_Res_Base_Res_YYYY_MM_DD table: initializing relations.
11 18:12:05 IMPORT_DATA Resolving related table.
12 18:12:05 IMPORT_DATA Getting meta-info about insetable tables.
13 18:12:06 IMPORT_DATA Start import table: Cliente01_Res_Base_Res_YYYY_MM_DD
14 18:12:06 IMPORT_DATA Started import data from csv Cliente01_Res_Base_Res_YYYY_MM_DD.csv
15 18:12:06 IMPORT_DATA Will perform Inserting or Updating (on duplicate by objectId).
16 18:12:06 IMPORT_DATA Reading next portion (0) of data from csv Cliente01_Res_Base_Res_YYYY_MM_DD.csv.
17 18:12:06 IMPORT_DATA Created new import subtask (1) for Cliente01_Res_Base_Res_YYYY_MM_DD.csv with 106 elements.
18 18:12:06 IMPORT_DATA Reading next portion (1) of data from csv Cliente01_Res_Base_Res_YYYY_MM_DD.csv.
19 18:12:06 IMPORT_DATA Started import subtask (1) for Cliente01_Res_Base_Res_YYYY_MM_DD table.
20 18:12:07 IMPORT_DATA Table ‘Cliente01_Res_Base_Res_YYYY_MM_DD’ was imported at 0 seconds. Saved 106 records.
21 18:12:07 IMPORT_DATA Finish import table: Cliente01_Res_Base_Res_YYYY_MM_DD
22 18:12:07 IMPORT_DATA Started restoring relations.
23 18:12:07 IMPORT_DATA Counting relations.
24 18:12:07 IMPORT_DATA Checking for existing tables with the same names as in imported views
25 18:12:07 IMPORT_DATA Clearing user data table cache.
26 18:12:07 IMPORT_DATA Deleting temporary tables.
27 18:12:07 IMPORT_DATA Finishing pointers export.
28 18:12:07 IMPORT_DATA Restoring expiration tasks for DeviceRegistrations.
29 18:12:07 IMPORT_DATA Import finished.
What is the name of the CSV file?
And what is your application ID?
My app is TerapiaOC , the CSV file is Cliente01_Res_Base_Res_YYYY_MM_DD.csv. I have a springboard plan.
App Id in personal message
I connected to your app and I see the table that has the data from the CSV. The name of the table is the same as the name of the CSV file. It has 106 records in it, exactly the number reported in the log:
Thanks very mucho for your quick answers. I couldn’t see this table before … And… I waited the records will appear in my table a_encuestas from which I executed the CSV import. Again, thanks I will rename the tables now.
You are welcome. When you import data from a CSV file, the table will have the same name as the name of the file.