CSV import always in Waiting status.

Open
#75 1 comment 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty
4/5
Estimated time
3-5 days
Newbie friendliness
25/100
Issue type
Bug
Clarity
Mostly clear
Activity status
Stale
Tech stack
mysql, php
Domain
backend

Research direction

Start with the /admin/csv-import flow and the reported CSV Import 2.0.6 setup (Omeka 3.0.1, PHP 7.3.21, MySQL 5.7.31); the report says the import remains “Waiting” after column mapping, with no errors in the logs. Determine why the import stays queued and verify that the same CSV completes successfully.

Written by the indexing model from the issue text.

Description

Hi, impossible to import a CSV file.
My file is very simple for debug purposes because I tried a lot of times, even from a new database just after install:

"TITRE";"SUPPORT"
"Araignée du soir";"Text"
"Les ailes te portent";"Text"

Content type is Text , mapping looks like correct on second screen:

TITRE maps to Araignée du soir
SUPPORT maps to Text ( I tried also to Type.)

status of import is "En attente" indefinitly (FR lang) which means Queuying or Waiting or Pending .....

used in localhost: http://omeka/admin/ (Super user admin).

logs: access.log:
::1 - - [27/Nov/2021:13:29:01 +0100] "GET /admin/ HTTP/1.1" 200 2363
::1 - - [27/Nov/2021:13:29:03 +0100] "GET /admin/csv-import HTTP/1.1" 200 3466
::1 - - [27/Nov/2021:13:29:04 +0100] "GET /admin/csv-import/index/browse HTTP/1.1" 200 2560
::1 - - [27/Nov/2021:13:30:45 +0100] "GET /admin/csv-import/index/browse HTTP/1.1" 200 2560
::1 - - [27/Nov/2021:13:30:48 +0100] "GET /admin/csv-import HTTP/1.1" 200 3466
::1 - - [27/Nov/2021:13:30:50 +0100] "GET /admin/csv-import/index/browse HTTP/1.1" 200 2560
::1 - - [27/Nov/2021:13:32:05 +0100] "GET /admin/system-info HTTP/1.1" 200 2726
::1 - - [27/Nov/2021:13:33:05 +0100] "-" 408 -
::1 - - [27/Nov/2021:13:45:36 +0100] "GET /admin/system-info HTTP/1.1" 200 2726
::1 - - [27/Nov/2021:13:46:36 +0100] "-" 408 -
::1 - - [27/Nov/2021:13:50:35 +0100] "GET /admin/csv-import HTTP/1.1" 200 3466
::1 - - [27/Nov/2021:13:50:36 +0100] "GET /admin/csv-import/index/browse HTTP/1.1" 200 2560
::1 - - [27/Nov/2021:13:50:37 +0100] "GET /admin/csv-import HTTP/1.1" 200 3466
::1 - - [27/Nov/2021:13:50:49 +0100] "POST /admin/csv-import HTTP/1.1" 302 20
::1 - - [27/Nov/2021:13:50:50 +0100] "GET /admin/csv-import/index/map-columns HTTP/1.1" 200 2882
::1 - - [27/Nov/2021:13:51:49 +0100] "-" 408 -
::1 - - [27/Nov/2021:13:55:35 +0100] "GET /admin/csv-import HTTP/1.1" 200 3466
::1 - - [27/Nov/2021:13:56:30 +0100] "POST /admin/csv-import HTTP/1.1" 302 20
::1 - - [27/Nov/2021:13:56:30 +0100] "GET /admin/csv-import/index/map-columns HTTP/1.1" 200 2882
::1 - - [27/Nov/2021:13:57:30 +0100] "-" 408 -
::1 - - [27/Nov/2021:14:00:12 +0100] "GET /admin/users/edit/1 HTTP/1.1" 200 2549
::1 - - [27/Nov/2021:14:00:37 +0100] "GET /admin/ HTTP/1.1" 200 2363
::1 - - [27/Nov/2021:14:01:37 +0100] "-" 408 -

------------>>>>>>>>>>>>> informations system: (WINAMP 3.2.5 on Windows 10)

Browser Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.55 Safari/537.36 Edg/96.0.1054.34
Role super

Omeka | 3.0.1
PHP | 7.3.21 (apache2handler)
OS | Windows NT 10.0 AMD64
MySQL Server | 5.7.31
MySQL Client | mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $
Apache | Apache/2.4.46 (Win64) PHP/7.3.21

Regular | apache2handler, bcmath, bz2, calendar, com_dotnet, Core, ctype, curl, date, dom, exif, fileinfo, filter, gd, gettext, gmp, hash, iconv, imap, intl, json, ldap, libxml, mbstring, mysqli, mysqlnd, openssl, pcre, PDO, pdo_mysql, pdo_sqlite, Phar, readline, Reflection, session, SimpleXML, soap, sockets, SPL, sqlite3, standard, tokenizer, wddx, xdebug, xml, xmlreader, xmlrpc, xmlwriter, xsl, Zend OPcache, zip, zlib
Zend | Xdebug, Zend OPcache

CsvImport | 2.0.6

berlin | 2.7.2
default | 2.6.5 (current)
seasons | 2.6.2


Any incompatibilities between versions ?
no errors logged in apache_error.log and in Omeka errors.log

thank you for help.
jacques

Dominant language
PHP
Stars
20
Forks
32
PR merge metrics
No merged PRs in 30d

Getting set up

This project ships no dev container, Dockerfile or contributing guide, so setting up is up to you: start from its README, and see our first-contribution guide for the general steps.

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from omeka/plugin-CsvImport

All issues in omeka/plugin-CsvImport

Similar issues

More PHP issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.