[dba-issues] [Issue 97762] Exporting a base table int o CSV text file: Unicode code replaced by ? si gn
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97762 --- Additional comments from nbrou...@openoffice.org Tue Jan 6 11:51:33 + 2009 --- Thank you for confirming the bug with your nice files examples. The work around which is also a simpler way was also mentioned in the quoted forum. Using OOdev-300m7 build 9371 I can confirm that opening a new sheet, typing F4 to register the database given as an example, clicking on the top-left grey empty square of the table of the database in order to select all data and draging into the empty sheet fills the sheet with correct hungarian accentuation. I haven't been able to reproduce the bug of CTRL_C from Base to CTRL-V in a new spread sheet: I get only the top left element (0) to be copied. But if I drag directly from Base and drop into the empty sheet it works: no need to use F4. And all characters are OK: U umlaut is still a U umlaut. The original first reported bug comes probably from the fact that on Windows as well as on Linux, while writing or reading a text file like a CSV, calc asks for the underlying code, UTF-8 or another old one. Anything against UTF-8 by default? - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 97762] Exporting a base table int o CSV text file: Unicode code replaced by ? si gn
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97762 --- Additional comments from nbrou...@openoffice.org Tue Jan 6 13:07:54 + 2009 --- CTRL+C and CTRL+V works as you decribed in open database table, but if you select whole table (in main table window)and copy into the ods file, will show my results. Ok I understood the différence (copying the whole table) but on my French XP there is no errors and I get: ÁRVÍZTŰRŐTÜKÖRFÚRÓGÉP Őő, and Űű are oldest problems with Hungarian keyboard drivers and setting, it allways caused problems until UTF was introduced, but haunting now. On Linux there is no error too. Under winXP when saved from Calc to csv needs to select win1250 coding for correct characters. If I save as UTF-8 total mess. Did you use a simple notepad to read it? (or a recent emacs). Because I verified that the output in utf-8 was correct too. At least csv files in utf-8 are read correctly by oocalc on Windows (and Linux). Concerning Excel it can be read as is, I agree. ÁRVÍZTŰRŐTÜKÖRFÚRÓGÉP - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 97762] Exporting a base table int o CSV text file: Unicode code replaced by ? si gn
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97762 Issue #|97762 Summary|Exporting a base table into CSV text file: Unicode cod |e replaced by ? sign Component|Database access Version|OOO300m7 Platform|Unknown URL|http://user.services.openoffice.org/en/forum/viewtopic |.php?f=13t=5009st=0sk=tsd=astart=10 OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P2 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|nbrouard --- Additional comments from nbrou...@openoffice.org Mon Jan 5 08:19:39 + 2009 --- From the forum discussion link it appears that a way to export a table from a base database into a CSV consists in the following steps. It works but ...: -Solution quoted- To start this ( and, this can also be accomplished by a macro if you so desire ) . . . the steps are: 1. Open your database 2. From the menu: Tools - SQL... 3. under Command to execute, enter your SQL 4. an example might be ( change output_csv_file_name to your desired OUTPUT name, and, your_table_name to the HSQL table you are using ) Code: Select all Expand viewCollapse view SELECT * INTO TEXT output_csv_file_name FROM your_table_name 5. Press the Execute button 6. Press the Close button The bottom line . . . this will create a TEXT CSV file for you . . . located in the same directory where your database ODB file is located. The file will have a file type of CSV . Additionally, your database will have a NEW TEXT 'table' as defined by the name you gave it in the SELECT above. This 'database' file may be deleted. Also, you can include a WHERE clause above if you wish to only output a part of the table to your CSV file. And, an ORDER BY clause will further define the CSV output. - ... the problem encountered, even on latest 3.00m7 version is that my accented characters disappeared. I know that Windows has difficulties is writing text files in Unicode but I am not sure that it is a Windows problem. I haven't found an option for the SELECT command or for the INTO TEXT command to add something like UTF-8 encoding or similar. In both, the .CSV file as well as the new table created into the database, all accented characters have been replaced by ? signs. PS: Priority is set to P2 because last time I used P3 it last more than a year. I won't be frustrated if you confirm the bug and that if there is no easy work around to be downgraded to a lower priority. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 95663] Crash or no issue when cha nging the path of a database in a writer form.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95663 User nbrouard changed the following: What|Old value |New value Status|UNCONFIRMED |RESOLVED Resolution| |FIXED --- Additional comments from nbrou...@openoffice.org Fri Dec 26 20:36:58 + 2008 --- When you distribute a new form then, the use of the Registered Datasource name, versus the hard coded path to a file should avoid this proboem totally. Thank you very much and instead of hard-coded path in a 'connection-resource' you need a 'datasource': Instead of: form:connection-resource xlink:href=file:///C:/Documents%20and%20Settings/brouard/Bureau/Dass45-6-old.odb/ you need, within the form:forms form:datasource=Dass45-6-old. Despite my efforts to find the information I did not go through. But if you get an odt form with hard-coded path there is no other solution than changing the path in content.xml . I am closing the bug because it doesn seem to be a priority. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 95663] Crash or no issue when cha nging the path of a database in a writer form.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95663 --- Additional comments from nbrou...@openoffice.org Tue Dec 23 15:00:46 + 2008 --- It seems that I am not alone to have the same problem: http://de.openoffice.info/viewtopic.php?f=1t=21560p=92868#p92250 And the only solution is to change the address in the content.xml . I am sure that it is a common problem: you want to distribute a form and an empty database for many interviewers. The interviewers have their own laptop with various configurations. The have to bring back the odb file once the interviews are done. The only solution is to write a small program which, once the odt and odb files are stored somewhere (on a USB for example), will get the current absolute directory unzip the odt content.xml , modify the former path to the current path and update the archive. The official documentation is very confused on this point. They speak of registering a database, but the hang occurs before the registration. And registration doesn't change anything too. You can close this bug if you think that a hang is not a bug. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 95663] Crash or no issue when cha nging the path of a database in a writer form.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95663 --- Additional comments from nbrou...@openoffice.org Fri Dec 19 14:08:23 + 2008 --- Could someone at least confirm this bug (we really need this to be fixed)? Just download EssaiOO-dev.odt, click on any of 3 input text areas. Once you get the classic dashed green square right click and choose Forms in order to set a new path to the database (which you can also download). Tell me if it hangs? Tell me also if there is another way to set the new path to the database? Many thanks for your help. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 95663] Crash or no issue when cha nging the path of a database in a writer form.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95663 --- Additional comments from nbrou...@openoffice.org Mon Dec 15 19:13:58 + 2008 --- Created an attachment (id=58832) Simple writer form using a base database with path - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 95663] Crash or no issue when cha nging the path of a database in a writer form.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95663 --- Additional comments from nbrou...@openoffice.org Mon Dec 15 19:24:28 + 2008 --- Created an attachment (id=58833) Small database to be used with a writer form (backup file detroyed in order to shrink the odb size) - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 95663] Crash or no issue when cha nging the path of a database in a writer form.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95663 User nbrouard changed the following: What|Old value |New value CC|'blueice7,clu,mechtilde' |'blueice7,clu,fs,mechtilde | |' --- Additional comments from nbrou...@openoffice.org Mon Dec 15 19:44:39 + 2008 --- I uploaded a simple writer form which connects to a small database. The only solution that I found to move both files to another machine is to change the path iinto content.xml form:connection-resource xlink:href=file:///C:/Documents%20and%20Settings/brouard/Bureau/Dass45-6-old.odb/ In order to do it (I haven't found the following on Windows) I just right click on the text file name, choose = 7-zip and Edit (not open, not extract), then an editor is used and when I save the new file content.xml, 7-zip asks me if I want to update the archive and I say yes. The simple test is just to navigate within the 4 records from the writer. If your name is not brouard it won't connect and hangs. It is a very easy bug, too easy to be true. But I looked at bug 96134 which is similar which has been fixed with latest snapshot DEV300m37 (build 9371) to change to a relative path. But it did not work too. I am not using F4 because it is not a mailing with fields. Hope that with these files attached you can understand better the problem. You can also give me a simpler way than modifying content.xml . - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 95663] Crash or no issue when cha nging the path of a database in a writer form.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95663 --- Additional comments from [EMAIL PROTECTED] Wed Dec 3 09:49:29 + 2008 --- Thanks for your answers. It is not a xform document, a simple odt file with forms which access to a oobase database. Even if you stay on Windows only, you can't change the path if the path doesn't correspond to an existing database because owriter checks (or seems to check) its existence and hangs if it doesn't exist. It is a real bug because it hangs. I can't send you my forms but I will try to simulate the problem on a newer and more simple form with a simple database. Regards, - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 95663] Crash or no issue when cha nging the path of a database in a writer form.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95663 User nbrouard changed the following: What|Old value |New value CC|'blueice7,clu'|'blueice7,clu,mechtilde' --- Additional comments from [EMAIL PROTECTED] Mon Nov 24 16:37:04 + 2008 --- I originally put the bug as a dba (base) bug, but blueice7 changed it to sw (writer) and I think that he might be correct because writer checks if a database responds according to the previous path and hangs if there is no database. Writer should not check the database if we only want to change the path by clicking on the appropriate icon. Regards, - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 95663] Crash or no issue when cha nging the path of a database in a writer form.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95663 User nbrouard changed the following: What|Old value |New value CC|''|'blueice7' Priority|P3|P2 --- Additional comments from [EMAIL PROTECTED] Thu Nov 20 10:13:48 + 2008 --- We really need confirmation on this bug. Last time I reported a bug (78539) it last 17 months to get a useless answer. This bug really hangs openoffice and we need such a facility. Please answer. Raising priority to P2. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 95663] Crash or no issue when cha nging the path of a database in a writer form.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95663 Issue #|95663 Summary|Crash or no issue when changing the path of a database | in a writer form. Component|Database access Version|1.0.0 Platform|Unknown URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|nbrouard --- Additional comments from [EMAIL PROTECTED] Thu Oct 30 17:28:07 + 2008 --- We are using a nice (writer) form which is linked to a database. And thus, the form and the database are separated. When we release a new form (keeping the database design unchanged) and send it to the interviewers on the field, they have to sync the new form to their old working database. It means, from what I understand, that they have to click on the Design mode button, click on any form control in order to highlight the red dashed rectangle and either right click in order to select the Form line or on the main Form button in the bar. From their onward, they must choose the Data tab (others are General and Events) and select a their old data source path where their old database is. And here is the problem, when the new form has a different path from the interviewer's setting (USB key, drive E: or whatever other path) oobase claims that the association is not correct and ask for OK or Option (Option tells you the error). But whatever you are doing, by clicking on OK as many times as asked, it starts freezing or crashing. If the new form comes from a Linux platform (2.4.1) (with a very different path like /home/myname/ instead of c:\Document and settings\) it works: it means that you can click on the ... at the right and associate the old database to this new form. But if the new form has been built on Windows XP (either 2.4.1 or 3.0) with a path which looks similar, oobase tries to find the database ''before'' offering the possibility of changing the path and crashes or freezes. Is there another way to attach a form (.odt) to a database (.odb)? Or is it a bug? Many thanks for your time. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
