[Libreoffice-bugs] [Bug 98168] Cannot use XLSX (with validation errors) as address list in Mail Merge Wizard - error in Comment 6 (workaround: add as external data source)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=98168

Miklos Vajna  changed:

   What|Removed |Added

 Status|NEW |ASSIGNED
   Assignee|libreoffice-b...@lists.free |vmik...@collabora.co.uk
   |desktop.org |

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 98168] Cannot use XLSX (with validation errors) as address list in Mail Merge Wizard - error in Comment 6 (workaround: add as external data source)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=98168

--- Comment #12 from Gabor Kelemen  ---
So I bibisected it back to commit[1].

Looks like only accidentally adding the format to the filters list was needed. 
However, before we can close this it would be nice to have some unit test, as
it is rather important to keep this feature in a working condition.

CC vmiklos as he did the deed :).

[1]
https://cgit.freedesktop.org/libreoffice/core/commit/?id=83b43ef2223b66484e0e90e7b614886e06f955b5

$ git bisect log 
# bad: [aee1ff762e080f444514ce89aab3e442c278a445] source
sha:54e1441949b83a76eecd02f2839693697773f711
# good: [b9d78ce81dc3481fccb0cb75d76fcb6ac939cbd5] source
sha:9feb7f7039a3b59974cbf266922177e961a52dd1
git bisect start 'origin/master' 'oldest'
# bad: [2dc325e2914c0f19c12642479a823a747dd6424f] source
sha:2b78b9feab9521e614b9edae17709cb6e2001292
git bisect bad 2dc325e2914c0f19c12642479a823a747dd6424f
# good: [ac95c990285f21355016a6a07903f7b0b193aa31] source
sha:592ab6435b22f7d1a0d9d940ccc32059fed05b87
git bisect good ac95c990285f21355016a6a07903f7b0b193aa31
# bad: [e481e94e818e8cbfaff95d105634b116aaa6b034] source
sha:123ea883b0643894c928bd8edd4203bdc60cc054
git bisect bad e481e94e818e8cbfaff95d105634b116aaa6b034
# good: [e5205a8af67a55dc554f7be39e2ed325dc0f2337] source
sha:7892b4191b525162dd2cad63524922856b70fff5
git bisect good e5205a8af67a55dc554f7be39e2ed325dc0f2337
# bad: [7b51331a2581834e511a2c887493b6883d58d776] source
sha:1802cfca17e7f12a0666dd884108e5b5a666b36f
git bisect bad 7b51331a2581834e511a2c887493b6883d58d776
# good: [7570f65619a123f4f9ff5873e17665942ea92999] source
sha:d4bda10ceef4502ce4717368c6a39ecd709cff7f
git bisect good 7570f65619a123f4f9ff5873e17665942ea92999
# good: [92e0752931c9fab99a91b4613e6d70c7445b8ceb] source
sha:2ce827f21cd11832cec5395c6c1c5fb2eef4b2d0
git bisect good 92e0752931c9fab99a91b4613e6d70c7445b8ceb
# bad: [f89af92fff1a9c1879a5ab5fae0066214971d7b4] source
sha:5734c6fee6a959b86b5e7f9c391ae3bee6009a08
git bisect bad f89af92fff1a9c1879a5ab5fae0066214971d7b4
# bad: [79a54ddc1d3648b27e03a7478bf60e9afa60605d] source
sha:e57aad8e43bc2617e88caac515b3fe5a09349813
git bisect bad 79a54ddc1d3648b27e03a7478bf60e9afa60605d
# bad: [936b6d0472c6affb34c2a3dd30e814c25879d6ba] source
sha:83b43ef2223b66484e0e90e7b614886e06f955b5
git bisect bad 936b6d0472c6affb34c2a3dd30e814c25879d6ba
# good: [df79da4f42f7795e98f5d4f4d0de74c430c9a0eb] source
sha:71c3113e9dbf61693fd947262370cc61cdf31ac7
git bisect good df79da4f42f7795e98f5d4f4d0de74c430c9a0eb
# good: [b56fa05d5bbd65716f28f62a64de2f50b5d0] source
sha:c49ed68c7e30f6963ecf56e542459f4fbd67a470
git bisect good b56fa05d5bbd65716f28f62a64de2f50b5d0
# good: [51d671b1aaff7e2cc40e874da7aa27cc8af5dcfa] source
sha:36f2df84fcfc21038b4d20df38a9e5addfcbde3f
git bisect good 51d671b1aaff7e2cc40e874da7aa27cc8af5dcfa
# first bad commit: [936b6d0472c6affb34c2a3dd30e814c25879d6ba] source
sha:83b43ef2223b66484e0e90e7b614886e06f955b5

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 98168] Cannot use XLSX (with validation errors) as address list in Mail Merge Wizard - error in Comment 6 (workaround: add as external data source)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=98168

Buovjaga  changed:

   What|Removed |Added

 CC||jonathan.camilleri@outlook.
   ||com

--- Comment #11 from Buovjaga  ---
(In reply to John Smith from comment #10)
> Is it possible to test other formats import/export and their user
> friendliness?
> 
> https://blog.filestack.com/thoughts-and-knowledge/document-file-extensions-
> list/

Can you verify Gábor's result?
https://dev-builds.libreoffice.org/daily/master/?C=M=D

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 98168] Cannot use XLSX (with validation errors) as address list in Mail Merge Wizard - error in Comment 6 (workaround: add as external data source)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=98168

--- Comment #10 from John Smith  ---
Is it possible to test other formats import/export and their user friendliness?

https://blog.filestack.com/thoughts-and-knowledge/document-file-extensions-list/

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 98168] Cannot use XLSX (with validation errors) as address list in Mail Merge Wizard - error in Comment 6 (workaround: add as external data source)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=98168

--- Comment #9 from Gabor Kelemen  ---
Created attachment 138471
  --> https://bugs.documentfoundation.org/attachment.cgi?id=138471=edit
The example file imported correctly in current master

I just rechecked this on a current master build and it seems to be able to
import xlsx files as data source, even the sheet selection works when there are
multiple sheets.

Could someone also check it? Then I guess we could set it to WFM.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 98168] Cannot use XLSX (with validation errors) as address list in Mail Merge Wizard - error in Comment 6 (workaround: add as external data source)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=98168

Timur  changed:

   What|Removed |Added

   Priority|medium  |low
Version|5.0.4.2 release |Inherited From OOo
Summary|Cannot update all fields in |Cannot use XLSX (with
   |mail merge  |validation errors) as
   ||address list in Mail Merge
   ||Wizard - error in Comment 6
   ||(workaround: add as
   ||external data source)

--- Comment #8 from Timur  ---
Attachment 122970 shows a number of validation errors when checked with OpenXML
Productivity Tool. On the other hand, LO opens it and there's a way to use it. 

Conclusion from here and from what I tested with master 6.0+: we cannot use
this XLSX as address list in Mail Merge Wizard. Connecting to data source
fails. Looks inherited from OO.
If we try to use that unconnected address list then as Data Source, we get: 
"SQL Status: HY000
The driver class '' could not be loaded."
There's workaround: add it as external data source.

Title "Cannot update all fields in mail merge" is not clear so I change to
"Cannot use XLSX (with validation errors) as address list in Mail Merge Wizard
(workaround:  add as external data source)".

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs