hello,
having some import issues on a new test setup. no objects were importing using the mapping/data we used with CA 1.7. for testing i created a new database using the sample installation profile from https://manual.collectiveaccess.org/providence/user/import/c_import_tutorial.html and tried an import using the sample mapping and data from that link as well. the same issue seems to be occurring.
after running sudo -u nginx /usr/share/nginx/html/providence/support/bin/caUtils import-data --format=XLSX --mapping=sample_mapping --source=/usr/share/nginx/html/providence/import/data.xlsx --log=/t
mp -d DEBUG no objects are imported:
CollectiveAccess 2.0 (197/GIT) Utilities
(c) 2013-2023 Whirl-i-Gig
Importing from /usr/share/nginx/html/providence/import/data.xlsx 0.0% 0/4 ETC: -. Elapsed: - [| ]
Imported data from source /usr/share/nginx/html/providence/import/data.xlsx
the log shows:
2024-10-17 14:33:48 - INFO --> Started import of /usr/share/nginx/html/providence/import/data.xlsx using mapping sample_mapping
2024-10-17 14:33:48 - DEBUG --> Finished reading input source at 0.0570 seconds
2024-10-17 14:33:48 - DEBUG --> Found 4 rows in input source
2024-10-17 14:33:48 - DEBUG --> Finished analyzing mapping at 0.0686 seconds
2024-10-17 14:33:48 - DEBUG --> Skipped initial row 0 of 1
2024-10-17 14:33:48 - DEBUG --> Started reading row 2 at 0.0000 seconds
2024-10-17 14:33:48 - DEBUG --> Started reading row 3 at 0.0000 seconds
2024-10-17 14:33:48 - DEBUG --> Started reading row 4 at 0.0000 seconds
2024-10-17 14:33:48 - INFO --> Import of /usr/share/nginx/html/providence/import/data.xlsx completed using mapping sample_mapping: 0 imported/0 skipped/0 errors
if it's relevant, i was able to manually create an object in the providence web interface. any help is appreciated, thanks again.
server config:
- collectiveaccess dev/php8
- nginx 1.20.1-16
- mariadb 10.5.22-1
- php 8.3.12-1
