[Koha-bugs] [Bug 27968] MARC framework CSV and ODS import incomplete or corrupted

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27968

--- Comment #8 from Victor Grousset/tuxayo <victor at tuxayo.net> ---
(In reply to Jonathan Druart from comment #7)
> (In reply to Victor Grousset/tuxayo from comment #6)
> > 1. Export default MARC framework in CSV
> > 2. Open the .csv with LibreOffice and save it
> > 3. Create a new framework
> > 4. import the CSV
> > 5. See MARC structure of the new framework
> > 6. Tags are missing the trailing zeros (10 instead of 010)
> 
> I don't recreate that.
> Certainly a setting in the libreoffice config.

Next is attached the CSV saved by LibreOffice, 010 => 10 happens there.
When opening the CSV, one of the options is "Format quoted fields as text.",
it's off by default. Hence 010 => 10.
Should the Koha import handle the spreadsheet software removing the leading
zeros? Since one of the common spreadsheet software does this by default, a
fair share of usage of this feature will be with this data.

> > 7. View subfields of tag 10/010
> > 8. Compare with default framework
> > 9. Subfields are missing
> >      note, why does on the default framework, these two URLs don't yield the
> > same result?
> >      /koha/admin/marc_subfields_structure.pl?tagfield=010&frameworkcode=
> >      /koha/admin/marc_subfields_structure.pl?tagfield=10&frameworkcode=3
> >      It would also make sense that 10 doesn't yield anything.
> > 10. Same with 031/31
> >       default framework still has different output for 31 and 031
> 
> 10 picked the 100's subfields, that's definitely a bug, should be reported
> separately.

Ok, see bug 27989.

About the subfields missing it's related to the above issue. Because when
reexporting they are in the CSV even if I can't find a way to see them in the
interface.

> > ODS issue when saved by LibreOffice is still there
> > 
> > 1. Export default MARC framework in .ods
> > 2. Open the .ods with LibreOffice
> > 3. Save it
> > 4. Create a new framework
> > 5. import the .ods
> > 6. See MARC structure of the new framework
> > 7. View subfield of tag 010
> > 8. Compare with default framework
> > 9. See Also: 4, and Link:4 have appeared (the code of my new framework code
> > is 4)
> 
> Does it work if you don't open/save it?

Yes, if the ODS export is directly imported, no issues

-- 
You are receiving this mail because:
You are watching all bug changes.