View Issue Details

IDProjectCategoryView StatusLast Update
4747Composrcorepublic2021-12-31 01:34
ReporterAdam Edington Assigned ToChris Graham  
PrioritynormalSeveritytrivial 
Status resolvedResolutionfixed 
Product Version10.0.39 
Fixed in Version10.0.40 
Summary4747: CSV export/import doesn't seem to be working 100%
DescriptionAfter 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.
TagsNo tags attached.
Attach Tags
Attached Files
Time estimation (hours)
Sponsorship open

Sponsor

Date Added Member Amount Sponsored

Relationships

duplicate of 4752 ResolvedChris Graham Catalogue entries do not import correctly into tree catalogues 

Activities

Chris Graham

2021-12-27 04:49

administrator   ~7226

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

Adam Edington

2021-12-27 06:02

administrator   ~7227

Yes it did.

Chris Graham

2021-12-27 15:35

administrator   ~7228

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?

admin

2021-12-27 16:05

administrator   ~7229

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.

admin

2021-12-27 16:05

administrator   ~7230

Fixed in git commit 11859209e (https://gitlab.com/composr-foundation/composr/commit/11859209e - link will become active once code pushed to GitLab)

A hotfix (a TAR of files to upload) has been uploaded to this issue. These files are made to the latest intra-version state (i.e. may roll in earlier fixes too if made to the same files) - so only upload files newer than what you have already. If there are files in a hot-fix that you don't have then they probably relate to addons that you don't have installed and should be skipped. Always take backups of files you are replacing or keep a copy of the manual installer for your version, and only apply fixes you need. These hotfixes are not necessarily reliable or well supported. Not sure how to extract TAR files to your Windows computer? Try 7-zip (http://www.7-zip.org/).

Adam Edington

2021-12-27 22:50

administrator   ~7231

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

Chris Graham

2021-12-27 23:14

administrator   ~7232

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?

Adam Edington

2021-12-28 06:34

administrator   ~7233

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.

Chris Graham

2021-12-31 01:34

administrator   ~7237

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

Issue History

Date Modified Username Field Change
2021-12-24 21:26 Adam Edington New Issue
2021-12-27 04:49 Chris Graham Note Added: 0007226
2021-12-27 06:02 Adam Edington Note Added: 0007227
2021-12-27 15:35 Chris Graham Note Added: 0007228
2021-12-27 22:50 Adam Edington Note Added: 0007231
2021-12-27 23:14 Chris Graham Note Added: 0007232
2021-12-28 06:34 Adam Edington Note Added: 0007233
2021-12-31 01:34 Chris Graham Relationship added duplicate of 4752
2021-12-31 01:34 Chris Graham Note Added: 0007237