#4747 - CSV export/import doesn't seem to be working 100%

By Adam Edington
Added 24th Dec 2021, 4:26 PM
2 views

Identifier	#4747
Issue type	Trivial issue (does not break functionality)
Title	CSV export/import doesn't seem to be working 100%
Status	Completed
Handling member	Chris Graham
Version	10.0.39
Addon	core
Description	After exporting some entries, I added them via CSV to a different site as a test. The entries made it into the database, but are not reflected on the front end. Last time I played with this CSV stuff I recall it working without issue, so maybe worth a check.
Steps to reproduce
Related to	#4752 - Catalogue entries do not import correctly into tree catalogues
Funded?	No
Commits	Fixed MANTIS-4747 (Import tasks are not consistently emptying the block cache) (11859209) · Commits · Composr ecosystem / Composr · GitLab

The system will post a comment when this issue is modified (e.g., status changes). To be notified of this, click "Enable comment notifications".

Rating

Unrated

Comments

By Guest posted 26th Dec 2021, 11:49 PM

Did this other site have an equivalent catalogue with existing matching field names?

By Guest posted 27th Dec 2021, 1:02 AM

Yes it did.

By Guest posted 27th Dec 2021, 10:35 AM

Having a quick look at the code, I can see the block cache is not being auto-emptied after import.
Does emptying the block cache manually fix the issue?

By Guest posted 27th Dec 2021, 11:05 AM

Automated response: Import tasks are not consistently emptying the block cache

Any background import task that sets mass-import mode should be emptying any block caches that would be invalidated by the import operation.

A few are, but not all.

Make it a standard feature of the tasks system to empty the block cache if mass-import mode was set, and make it so no task import hooks empty block caches manually any more.

By Guest posted 27th Dec 2021, 5:50 PM

I emptied all the caches and nothing appeared on the frontend. Will try again once I've applied this hotfix.

By Guest posted 27th Dec 2021, 6:14 PM

So they show for edit, but there is no category that shows them on the front-end?
Is this a tree catalogue or not?
Can you dump the contents of your catalogue_entries and catalogue_categories tables and email to me?

By Guest posted 28th Dec 2021, 1:34 AM

Was replying to your early comment asking if I'd cleared the block cache, I had. The entries were in the db but not showing in the catalogue. It was a tree catalogue. Not tried the hotfix yet and the test installs are no longer in action but I will try again as it's a nice way to do batch updates.

By Guest posted 30th Dec 2021, 8:34 PM

I think I found the issue, which is fixed in #4752.

#4747 - CSV export/import doesn't seem to be working 100%

Rating

Comments

Statistics