https://issues.apache.org/ooo/show_bug.cgi?id=85198
Rainer Bielefeld <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Keywords|needmoreinfo | Status|RESOLVED |REOPENED Latest|--- |4.1.0-beta Confirmation on| | Resolution|IRREPRODUCIBLE |--- Summary|mail merge CSV data source |Maimerge Wizard does not |with space in name not |accept CSV address data |accepted |source with space in name Ever confirmed|0 |1 OS|Windows XP |Windows, all --- Comment #13 from Rainer Bielefeld <[email protected]> --- Yeah, now I see things clearly. It's really tricky, everything works fine, even a "name with blanks.csv" can be defined as address data source via 'Address Data Source Wizard', but in Mailmerge Wizard the same definition to assign a name with blanks.csv" as data source wizard fails. Really strange! Steps how to reproduce Reproducible with server installation of "AOO 4.1.0-Beta – German UI / German locale - [AOO410m14(Build:9760) - Rev. 1573601 2014-03-03 17:47:48]" on German WIN7 Home Premium (64bit)", own separate user profile: 0. Download / Unzip Test Kit 1. From AOO Start center menu 'Tools -> Options -> Base -> Databases' Delete all unknown / unnecessary Databases [OK] 2. Quit / Relaunch AOO 3. From AOO Start Center open new empty writer document 4. Menu 'File -> Wizards -> Adress Data source.... -> Other External source -> [Next] -> [Settings]' 5. Select Text -> [Next] 6. Browse for folder where you extracted test kit \ DSW > No files will be shown 7. [Select] -> Next -> Selec CSV (radio button) -> Character set = "Wetern Europe (WIN-1252/WinLatin 1)" -> Check "Text Contains Headers" Leave Field Separator comma, [Finish] > Pane shows "Sample database csv - Adress Datasource Wizard" and "Sample database csv - Maiol Merge Wizard" 8. Click "Sample database csv - Adress Datasource Wizard" -> Next -> Next 9. In Step 5 Change Filename from Addresses.odb to AddressesDSW.odb and change Address book name from Addresses to AddressesDSW -> [Finish] 10. Do a quick test in Untitled 1 with <f4>: Database "AdressesDSW" will be shown with a single Table and Names "a1" and more That worked fine, now similar test from Mail Merge Wizard 14. In Text Document menu 'Tools -> Mail Merge Wizard -> Click step 3 -> [Select Address List]' > Shows "AdressesDSW" from test above 15. [Add] 16. Browse for folder where you extracted test kit \ MMW -> Select "Sample database csv - Mail Merge Wizard.csv" [Open] 17. Leave Field Separator comma, rest does not matter, Character set = "Wetern Europe (WIN-1252/WinLatin 1)" -> Check "Text Contains Headers" [OK] > An indicator that this did not work is that no table pane for this .csv will be shown and that ok button leaves greyed 18. Click "AdressesDSW" and back to second .csv -> [OK] > It looks as if that would have worked, but you can not reach steps behind MMW step 3 with this approach 20. Do a quick test in Untitled 1 with <f4>: An Additional "Sample Database ..." will be shown, but Tables will be shown, this data base is unusable So finally we can confirm the old report for AOO 4.1.0 Beta, it's impossible to add a .csv with blanks in name. That works fine with names without blanks (I did a test), and via Address Datasources Wizard also .csv with blanks in the name will be handled correctly. That has been some hard work! @Edwin: Thank you for additional test, what showed up important details I never should have tested -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes.
