from:"Paul"


Calc template files end in .ots

Although I used Writer to make my macros, Writer does not export CSV 
files correctly, or should I say without spaces as Calc does, I guess 
you will have to make your macros in Calc. (Version: 6.3.5.2).


Hope this helps.

On 4/8/20 1:30 PM, edonkey2001-libreoff...@yahoo.it wrote:

Hi Paul,
I've tried to create an ods file to use as template as suggested.
I've set my intended column widths in it, enabled line wrapping, then I saved 
it.

Then I ran:
soffice -n template.ods --infilter=CSV:44,34,UTF8 myfile.csv

Unfortunately what actually happens is that LibreOffice opens two files:
- a new file based on my template, which contains no data
- my csv file, without applying my template to it



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Open .csv by specifying column widths on command line


There may be another answer.

I import semi-colon (;) separated data into Writer, recorded Macro 
filters and tied them together. In my case, I made a Menu which reformat 
the data fields.


See the example below from URL: 
https://ask.libreoffice.org/en/question/150565/execute-macro-in-calc-from-terminal/



Also, this simple Sub:



|SubFindSheet(aNumber)MsgBox"Here is the number " EndSub|

run from terminal as:

|libreoffice6.0"macro:///Standard.Module1.FindSheet(4)"|

or on some systems:

|soffice "macro:///Standard.Module1.FindSheet(4)"|

displays the proper variable and message in a message box.

Another note, when executing the macro from terminal and all of LO is 
closed, you will briefly see the LO splash screen displayed.






Thanks Brian for your reply, unfortunately that does not help me.

What I'm looking for is a way to work with csv files with minimum hassle.
I do not need features such as column widths, other formatting etc. to be saved 
in the file(s).
I just need to specify the way LO displays csv files when they are opened (as 
command line arguments so I can automate that).

Your proposed workaround would require manual adjustments, on a file by file 
basis, and each time they are opened.
These manual steps are what I'm looking to avoid. Else I could just resize the 
columns and enable wrapping every time and be done with this.



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Problem with print dialogue


This may work.



  Wayland solution

Since Ubuntu 18.04, Wayland 
 
is the default display protocol.

To enable scaling:

 *

Enable fractional Scaling experimental-feature:

|gsettings set org.gnome.mutter experimental-features
"['scale-monitor-framebuffer']" |
 *

Restart the computer.

  * Open /Settings/ -> /Devices/ -> /Displays/
  * Now you should see 25 % step scales, like 125 %, 150 %, 175 %.
Click on one of them and see if it works.

Quote from: 
https://askubuntu.com/questions/1029436/enable-fractional-scaling-for-ubuntu-18-04


I do not know if it has reduction settings.

It may be possible to set a separate workspace using the above, but I'm 
no expert.


Anybody else?


On 4/7/20 10:03 PM, John Sweeney wrote:

I have this version of libre office: Build ID: 1:6.4.2-0ubuntu0.18.04.3

I cannot see the OK button on the print dialgoue because the dialogue is
too big for my screen and there is no scroll bar nor can i change the
dialogue's size. It is very frustrating.

Can anyone help?

Thanks,

John Sweeney




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Open .csv by specifying column widths on command line


Would this work in your command line mixed with Brians' idea?

-n {filename} Creates a new document using *{filename}* as a template.

From: 
https://help.libreoffice.org/Common/Starting_the_Software_With_Parameters


On 4/7/20 6:58 AM, edonkey2001-libreoff...@yahoo.it wrote:

Thanks Brian for your reply, unfortunately that does not help me.

What I'm looking for is a way to work with csv files with minimum hassle.
I do not need features such as column widths, other formatting etc. to be saved 
in the file(s).
I just need to specify the way LO displays csv files when they are opened (as 
command line arguments so I can automate that).

Your proposed workaround would require manual adjustments, on a file by file 
basis, and each time they are opened.
These manual steps are what I'm looking to avoid. Else I could just resize the 
columns and enable wrapping every time and be done with this.



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Re: Base created from xlsx file - move to proper DB

2020-03-19 Thread Paul D. Mirowsky

I hope that once you have HSQLDB working, you will transfer eventually 
migrate to Firebird.


It has been far superior and and stable once I worked out the bugs.

https://wiki.documentfoundation.org/Documentation/HowTo/MigrateFromHSQLDB

https://wiki.documentfoundation.org/Documentation/FirebirdMigration

Glad to help.

On 3/19/20 11:31 AM, bunk3m wrote:

Thank you Alex, Paulo and Drew.
I didn't realize there were so many "bugs" still to work out.
I'll stick with HSQLDB for now.
I trust there will eventually be a way to migrate to the new DB in the
future?

On Thu, 19 Mar 2020 at 10:10, Alexander Thurgood 
wrote:


Le 19/03/2020 à 13:32, bunk3m a écrit :

I would only recommend using embedded Firebird if you're comfortable
with all of its still numerous bugs, and are happy to get your hands
dirty correcting data types, lengths, etc and possibly corrupted data.

Also, it is my understanding that there is currently still a limitation
of 64Kb for the total insert length of any transaction, meaning that you
have to be especially wary of the number, and length of any VARCHAR data
that you have in your spreadsheet.

If you have Unicode characters in any cell, you might also get an import
failure because these are coded over 4 bits per character, which can
rapidly cause the automatically created insert statement to exceed the
64KB limit, and again, fail.


My advice would be to stick to embedded HSQLDB until, or unless, you are
comfortable with such limitations.


Alex




Thank you Alex and Drew.
I'll try your suggestions today.
I appreciate your help!

One more question if I might.
If I understand correctly, HSQLDB is being replace by Firebird.  So I'd
like the engine to be Firebird so I don't end up with an issue in the
future.
How does one know that Firebird is being used?

On Thu, 19 Mar 2020 at 05:52, Alexander Thurgood <

alex.thurg...@gmail.com>

wrote:


Le 19/03/2020 à 01:57, bunk3m a écrit :

As Drew has said, you can use your existing flat file in several ways :

1) Go via the empty ODB file method to drag the linked XLSX sheet from
your first ODB file to the second, empty ODB file and then follow the
import wizard.

2) Create an empty ODB file and keep it open. Open your XLSX sheet
directly in LO Calc. Select all of the data including column headers,
that you want to import.
Drag and drop this selected data onto your open ODB.
Use the import wizard options to configure the way you want the data to
be imported into a new table that will be created as a result of the
drag and drop maneuver.

Be aware that the import wizard isn't perfect, depending on the version
of LO you are using, it might cause you a bit of grief, so double-check
afterwards that it has done what you wanted (within the confines of what
it can actually do, of course). You might find that some post-import
database alteration statements might be necessary.


Alex





--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Re: Base created from xlsx file - move to proper DB

2020-03-19 Thread Paul D. Mirowsky


See below...

On 3/19/20 10:10 AM, Alexander Thurgood wrote:

Le 19/03/2020 à 13:32, bunk3m a écrit :

I would only recommend using embedded Firebird if you're comfortable
with all of its still numerous bugs, and are happy to get your hands
dirty correcting data types, lengths, etc and possibly corrupted data.


Always look at the resulting table to see if it's fields are defined 
correctly and display correctly when looking at table data.


Make sure columns are defined with proper data type such as date or time 
in your spreadsheet.


Until the resulting table is as close to your intended field type, keep 
making a new table.


Understanding through re-iteration will help you see the pitfalls.

If you can't get the import to the correct data type, import in such a 
way as to have complete data from spreadsheet field.


At this point, from within Base, you may be able to make a new table 
that has a correct data type and copy from Table-0 to Table-1.


Hope this helps

Paul


Also, it is my understanding that there is currently still a limitation
of 64Kb for the total insert length of any transaction, meaning that you
have to be especially wary of the number, and length of any VARCHAR data
that you have in your spreadsheet.

If you have Unicode characters in any cell, you might also get an import
failure because these are coded over 4 bits per character, which can
rapidly cause the automatically created insert statement to exceed the
64KB limit, and again, fail.


My advice would be to stick to embedded HSQLDB until, or unless, you are
comfortable with such limitations.



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Libreoffice office cloud version

2020-03-10 Thread Paul D. Mirowsky


You may want to look here: https://nextcloud.com/


On 3/6/20 12:51 PM, sterbl...@tutanota.com wrote:

Rather than saying this is a question. This is more like expressing what I am 
looking for, after searching online. My search result doesn't find anything 
similar, so ask it here (and appreciate any suggestions if any similar service 
existed).

I am looking for something like Google doc, sheet but purely libreoffice 
version where I can do online collaborative editing, sharing doc, and so on. I 
understand there are services like MS sharepoint, Google doc, and so on. But I 
am more interested in using open source software, and I know some of my friends 
who also want to use such service as well, though I understand that might not 
be big enough request in triggering to create such service. But anyway that'd 
be nice to see such service that people can use.

And thanks community's effort to create such kind of software!
  





--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Re: Libre Writer Help download + Margin adjustment

2020-03-02 Thread Paul D. Mirowsky

Hello Charles

Suggest you go to a more current stable version, 6.3.5.

https://www.libreoffice.org/download/download/

Allow download to begin. On that page, click on "LibreOffice built-in help".

If that doesn't work, then, after downloading the package, use browser
to go back to same page and click on the green link that says ":

* Help for offline use: *English (US)*

<http://download.documentfoundation.org/libreoffice/stable/6.3.5/deb/x86_64/LibreOffice_6.3.5_Linux_x86-64_deb_helppack_en-US.tar.gz>
(Torrent

<https://download.documentfoundation.org/libreoffice/stable/6.3.5/deb/x86_64/LibreOffice_6.3.5_Linux_x86-64_deb_helppack_en-US.tar.gz.torrent>,
Info

<https://download.documentfoundation.org/libreoffice/stable/6.3.5/deb/x86_64/LibreOffice_6.3.5_Linux_x86-64_deb_helppack_en-US.tar.gz.mirrorlist>)

Do not use(Torrent
<https://download.documentfoundation.org/libreoffice/stable/6.3.5/deb/x86_64/LibreOffice_6.3.5_Linux_x86-64_deb_helppack_en-US.tar.gz.torrent>,
Info
<https://download.documentfoundation.org/libreoffice/stable/6.3.5/deb/x86_64/LibreOffice_6.3.5_Linux_x86-64_deb_helppack_en-US.tar.gz.mirrorlist>)
unless that is type of download you want.

On 3/1/20 2:37 PM, charles meyer wrote:

Hi Paul,

I hope this email fiend you well.

I downloaded the most recent version of Libre Office (.6.2. something
) running on Windows 10 Pro on a laptop.

I need to download the help file which works with Libre Writer.

Would you pls share the direct link to that download?

Also, I can't seem to find where you adjust margins in Writer.

Menu and change Left/Right margins.

This is also the place for changing 'Orientation' from Landscape to
Portrait.

It used to be under Edit or File>Page Layout.

I have "text" words in an Excel spreadsheet file. I copy and the paste
them into a Libre Write new document but about 1/3 of those words goo
off the page to the right so I can't read them.

Sorry, but I am not familiar with how Excel copies to Writer.

What I always do when copying from an uncommon format is clear it and
use the software's format.

Highlight incorrectly formatted text, then Menu Formatting>

I don't know how to reach Landscape (from Portrait) to read
the words/text better (like you can in Print) - is there a way to do
that in Writer?

Thanks so much.

Charles.

Re: [libreoffice-users] Writer will not print envelopes

2020-02-06 Thread Paul D. Mirowsky


Long shot.

1. There is a possibility that printer dimension don't actually match
   the definition of envelope. This might causing 1 page print on 2
   page envelope. This might result in 1st page blank and 2nd page with
   address do to width incorrectly defined. Does "Print Preview" show 1
   or 2 pages for envelope?
2. Go to , "Options" tab to try "Use only paper size from
   printer preference".
3. Check "Properties" for your Brother printer and see if there is an
   option for "Other Pages" and that it is set correctly.

By the way, I noticed you did not mention what operating system you are 
using.


Hope this helps.

On 1/31/2020 5:36 AM, williamdrescher wrote:

Win10
Version: 6.2.8.2 (x64)
Build ID: f82ddfca21ebc1e222a662a32b25c0c9d20169ee

I insert an envelope into a document.  When I then print the document the
first page (the envelope) prints as a blank page.  The rest of the document
prints just fine.

Any suggestions or thoughts?

bill



--
Sent from: 
http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] RE: Using Libre Writer - with hardware questions

2020-01-27 Thread Paul D. Mirowsky

This sounds more like a hardware problem then a LibreOffice/software
problem.

Some manufacturers have built in hardware diagnostics, run them if
available.

If you have the ability to add a external monitor to the laptop.

Although it varies from *laptop* to *laptop*, some can turn on the
*external monitor* by hitting the *Function Key* (*Fn*) plus the F5
*key*. On the *Toshiba*, continually hitting *Fn*-F5 , skips between
the various *monitor* options including *screen* duplication and
*screen* extension.

https://www.google.com/search?ei=cAQvXub9LKqd_Qb5nKbwBg=toshiba+laptop+external+monitor+function+key=toshiba+laptop+second+monitor+key_l=psy-ab.3.0.0i22i30.427589.447202..449066...5.2..0.189.2795.35j3..01..gws-wiz...0i71j0i273j0i131i273j0j0i131j0i67j0i131i67j0i22i10i30j33i22i29i30j33i160j0i13.VDP2nfMeXEU

This information can be confirmed from your laptop owners manual.

If you have the ability to create a Linux OS disk like Ubuntu, boot it
and see the screen problem goes away. This may help to confirm a Windows
driver problem.

https://tutorials.ubuntu.com/tutorial/try-ubuntu-before-you-install#0

It also will allow you to do a memory check.

https://askubuntu.com/questions/591488/how-do-i-run-memtest86

Go to a different computer and look for search engine listings of your
laptop model having similar problems. Youtube videos can tell you a lot
about what may be happening.

Google "YouTube Toshiba vertical banding"

Hope this helps.

Paul

On 1/25/2020 4:58 PM, charles meyer wrote:

I've been encouraged to post here re: my hardware travails!

Here goes...

I booted up my older Toshiba laptop running Windows 7 which for years had
been working fine.

Then, one day I booted up and got these vertical color bands where you
couldn't see anything else bu the bands.

I then re-booted and opened Word 2003 (as Libre Office take a longer time
to open and the laptop would just shut Word
down, then when I re-booted it would shut the laptop down while I was
writing in Word.

Then, I tried opening Libre Writer and it just froze – never opened so
I had to press the power button to re-boot.

I moved the laptop power adapter from the power strip to the UPS then
moved the laptop so it’s connected directly into a wall outlet in
another room. Still no good. I then powered the laptop in an outlet in
the top outlet (not the bottom one even though the last testing showed
the outlet (top/bottom)were both fine.

I then brought the laptop to work and got the same results when trying to
run it.

Someone said I might have to delete all my video drivers and r-install them.

I have no idea where to find those drivers on my laptop, nor which ones to
delete nor where I would find the correct replacement video drivers nor if
that's even a correct solution.

I've got 3 GB Ram running.

It's a nice 17" screen so I don't want to toss the laptop and it ran for 3+
hours at a friend's work space - with 4 programs open at the same time -
Publisher, GIMP, the Brave browser running a YouTube video and another
program to test the laptop and it all worked fine.

Thanks for your thoughts/ suggestions.

Re: [libreoffice-users] Using Libre Writer - with hardware questions

2020-01-24 Thread Paul D. Mirowsky

Submit your issue here. This forum has an amazing amount of knowledge 
and if they don't know, they will give you guidance.


On 1/24/2020 3:09 PM, charles meyer wrote:

I like using Libre Writer but have been confounded with a hardware issue
with my laptop.

Would anyone please suggest a knowledgeable forum where I could post what's
happening with my laptop to troubleshoot so I can get it stabilized to use
Libre Writer?

Tom's Hardware has been disappointing.

Thank you.



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] excel 3d maps tour workalike?

2019-11-14 Thread Paul D. Mirowsky

While not sure of video out capability, you may want to look at these 
extensions.


https://extensions.libreoffice.org/extensions/geomap

or https://extensions.libreoffice.org/extensions/geooo

or working with Google Maps KML (XML) format in Calc.

 *

   created map & entered some points of interest

 *

   created & downloaded KML file

 *

   changed extension from |kml| to |xml|

 *

   Opened Calc

 *

From menu |Data->XML Source...| this started dialog

 *

   Under |Source File| clicked icon to select .xml file

 *

   Once selected |Map to Document| was filled with field names

 *

   Selected |..Placemark| section ( subsequently selects all entries below)

 *

   In |Mapped Cell:| section used icon to select cell where data would
   start

 *

   Returned to dialog & selected |Import| button

The above is from 
https://ask.libreoffice.org/en/question/176585/will-calc-be-able-to-import-dat-from-kml-file-containing-a-collection-of-points-of-interest-from-google-mymaps/


Hope this helps.

Paul


On 11/9/2019 3:55 PM, Dave Stevens wrote:

Excel's 3D map
tour


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Transparency issue saving to .doc/docx

2019-11-05 Thread Paul D. Mirowsky


This may or may not work.

You may want to look into creating a SVG incorporating underlying text 
with overlay images.


Suggest you look at Inkscape for creating a _plain_ (not Inkscape) SVG.  
https://inkscape.org/




On 11/5/2019 4:31 PM, Tim-L wrote:

The problem is it gets up when I save it back to DOCX or DOC.  I have 2 
transparent background images that overlap each other to solve a visual 
need.  The problem is half the time the images lose their transparent 
backgrounds and cover up the underlying text.



#2
They are logo and a high def images that do not work well to break up 
and then realign them in some way to into a odd shaped space. It would 
be very hard to cut up the images so their borders are wavy and curved 
to match the free spaces.




2. Transparency

Consider breaking the image up, where the resulting pieces won't overlay
your text. That is, instead of leaving a border image with text 
appearing
inside it, place the border as multiple images, so that no text can 
"fall
behind" because the images never overlay.  This will require 
exporting the
image and cutting it, or placing the image multiple times and 
cropping it.

If you go the route of cropping the image within LO Write/MS Word, the
resulting document gets large and lags performance.






--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] LibreOffce 6.2.4 won't start after upgrade on Debian 9.9

2019-06-24 Thread Paul D. Mirowsky

Try using the program selector icon.  See there is an icon there that 
will complete the loading of the program.


Although the LibreOffice Icon may still exist, direct installation may 
not be updated to 'start' the program from that icon.


The program selector is direct.

Hope this helps.

Paul

On 6/20/2019 1:37 PM, Allen Seelye wrote:

Good afternoon,

I am running Debian 9.9 and the system us fully up-to-date. I tried up
upgrade LibreOffice this morning, and now it will not start.

If I start it from the desktop, the splash screen comes up and the
progress bar moves about 1/3 of the way, then it goes away and nothing
happens.

If I start it from the command line with "libreoffice6.2 --writer", the
same thing happens only the terminal spits out "Application error".

-I've tried logging into the system with a brand new user, same results.
-I've checked to make sure there are no LibreOffice processes running.
-I've done "apt purge LibreOffice*" and verified that anything
LibreOffice is removed from the system, rebooted, then installed and
rebooted again, same problem.
-Tried installing the old version again, no good.

I'm at a loss now. It was working this morning, and told me there was a
new version available, which is what started all of this.

Any ideas?



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Base Firebird reserved words

2019-05-22 Thread Paul D. Mirowsky


I have recently been battling with the change to Firebird.

When using query, I would continuously get some form of 
'isc_dsql_prepare' errors.


As it turns out, I repeatedly used "Select" as a field name within "Tables".

Changing the field names from "Select" to "Selection" has eliminated all 
of the 'isc_dsql_prepare' errors.


I checked the reserved words for Firebird 2.5 and 3.0.  "Select" is a 
reserved keyword in 2.5.


My suspicion is that there is some kind of misinterpretation during the 
analysis of field name vs keyword when opening and/or using a query.


Can someone confirm that Firebird keywords should never be used as field 
names.


Thanks

Paul


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] No corresponding column type could be found for column 'ID'.

2019-05-16 Thread Paul D. Mirowsky


Hello Robert

See below.
Hello Robert

See below.


On 5/16/2019 2:53 PM, Robert Großkopf wrote:


Hi Paul,

When I want to append a Table from database one to database two, I get
the message "No corresponding column type could be found for column 
'ID'."

The field "ID" from the Firebird-table must be autovalue.
The receiving firebird database two is ID primary key, AutoValue = yes, 
Length = 10


I you will import the table, which all contains text-fields, the wizard
will start. First you have to add the targettablename the content of the
fields should be added to. Mark also "First row will show fieldnames"
(don't know how it is called in English).


Up to this point everything works.

Table name is set correctly and Append Data is checked (circle filled 
with blue)


"Use first line as column names" is already check marked and cannot be 
changed.


Click on "Next" and then message shows "No corresponding column type 
could be found for column 'ID'."


Cannot continue past this message.

  Then goto next and mark all
fields of your importtable except "ID", if this content created new and
shouldn't be moved to the targettable. Switch with the arrow-buttons on
the right the field of the targettable, which should be filled by the
content of your importtable. The field ID of the targettable could be at
the same position as the field of the importtable, because you have
deselected the field ID from the importtable.

Hope this will work for you.

Regards

Robert

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] No corresponding column type could be found for column 'ID'.

2019-05-16 Thread Paul D. Mirowsky


Windows 7 64 bit, Version: 6.2.3.2 (x64)

I have two databases.

Both have "ID" defined as the first field in the databases.

The first database is an import of text files that is unregistered. I 
believe it is Firebird, but do not know how to confirm this. The header 
to the text file has "ID" in the first line, first position and all its 
fields are blank.


Example:

ID;Model;Tube;Position;Date;Time;Ions;Select;Series;Settings
;1-1612-0023-192;1-1617-0009-1759;1.1;2019-05-14;3:32:00 PM;  503075;0;135;100

"ID" field was defined as "Text [ VARCHAR ]" automatically at Import and 
does not define "ID" as a key field.


The second database is firebird registered.

"ID" is defined as "Integer [ INTEGER ]".

When I want to append a Table from database one to database two, I get 
the message "No corresponding column type could be found for column 'ID'."


It does not let me skip this warning and move to the next screen where I 
would usually uncheck the field and allow automatic key to be filled in 
second database.


Any suggestions welcome.

Paul


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] LO Basic: DialogLibraries contains no elements

2019-05-06 Thread Paul D. Mirowsky


Shot in the dark.

If I understand it correctly, this function is case sensitive.

Check spelling.

Hope this helps

On 5/5/2019 12:19 PM, Pusteblumi wrote:

/DialogLibraries.LoadLibrary ("OOoLilyPond")/


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Page number messed up in LO Writer 6.2.1/2 and 6.1.5

2019-04-10 Thread Paul D. Mirowsky


You may have "Field Names" under the " View" menu activated.

Click it or Ctl+F9 to deactivate.

Hope this helps.

On 4/10/2019 6:08 PM, MR ZenWiz wrote:

I've been LO Writer for a long time for, among other things, a few
novels I am writing.

Just now I noticed that the page number field in the header no longer
contains the page number itself, it contains the shaded text "Page
Numbers".

This is new as of LO 6.2.1 and 6.2.2, and kind of defeats utterly the
ability to use this field for page numbering.

I tried deleting it and re-inserting, both with Insert -> Page Number
and Insert -> Field -> Page Number.  Same result.

I have attached a brand new .ods document with the same problem - all
I did was insert the page number in a fresh header.  See also the
attached screen image.

For S, I reinstalled LO 6.1.5, but it does the same thing with the
older files, and also with a brand new file.

I'm running this on Xubuntu 18.04.2 in a VB VM (here at work - I'll
check again when I get home).

WTH?

Mark Richter, Senior Staff Engineer
http://www.linkedin.com/in/markrichter1
Registered Linux User #472807 http://counter.li.org/
FSF Member #12694 http://www.fsf.org
LO recurring contributor



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Re: Draw changes font when opening pdf text file.

2019-03-18 Thread Paul D. Mirowsky

I am using "Version: 6.1.5.2 (x64)". Supposedly, you can force font 
substitution. I have not tried it.


Choose *Tools - Options'* /- LibreOffice - Fonts'   From: 
https://help.libreoffice.org/Common/Fonts/


You must click in the box next to "Apply replacement table" before you 
can select the substitute fonts.


Hope this helps.


On 3/18/2019 9:44 AM, Malcolm Jaros wrote:

It occurs to me that Draw does not recognise, or does not have, the font used 
for the original document and substitutes one that it does have.
My problem is that the original, serif, font is being substituted by a 
monopitch font.
Regards, MalJaros

- Original Message -
From: "Malcolm Jaros" 
To: "Global Users@" 
Sent: Monday, March 18, 2019 3:27:05 PM
Subject: [libreoffice-users] Re: Draw changes font when opening pdf text file.

I do apologize for not pointing out that I am using 6.2.1.2 on Ubuntu 18.04

Regards, MalJaros


From: "Malcolm Jaros" 
To: "Global Users@" 
Sent: Monday, March 18, 2019 3:24:12 PM
Subject: Draw changes font when opening pdf text file.

Greetings All.
I would like to add a few words to the text embedded in a pdf file.
When the file is opened in Draw the text is displayed, and subsequently saved, 
in a different font from the that in the original file.
This unfortunately changes the line length and hence the page layout, which 
makes the amended copy unusable.
How can I prevent this?
Regards, MalJaros




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Impress window position

2019-03-14 Thread Paul D. Mirowsky


In Impress under "Slide Show Settings" you should find



Multiple Displays

By default the primary display is used for slide show mode. If the 
current desktop is displayed on more than one display, you can select 
which display to use for full screen slide show mode. If the current 
desktop spans only one display, or if the multi display feature is not 
supported on the current system, you cannot select another display.



  Presentation display

Select a display to use for full screen slide show mode.

If the system allows the user to span a window over all available 
displays, you can also select "All displays". In this case the 
presentation is spanned over all available displays.


From: 
https://help.libreoffice.org/Impress/Slide_Show_Settings#Multiple_Displays


Try this.

Hope it helps.


On 3/14/2019 11:13 AM, malcolm moore wrote:


Impress is on the left screen and I set the slideshow up to display on the 
right so the left is in presenter mode
The full screen presentation goes over everything. If I click on OpenBoard it 
comes to the front but as soon
as you advance to the next slide Impress goes over the top again

Ta

Mal



  
- Original Message -

From: Paul D. Mirowsky (p_mirow...@bentaxna.com)
Date: 14/03/19 14:22
To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Impress window position

When you drag Impress over to the screen on right, does it remain there
after clicking on OpenBoard?

On 3/12/2019 4:22 AM, malcolm moore wrote:

Sorry a bit sparce on information...

It's openSUSE Tumbleweed
KDE Plasma
The screen is extended to the right

Mal



  
- Original Message -

From: Tom Davies (tomc...@gmail.com)
Date: 11/03/19 18:18
To: malcolm moore (st-malcolm.mo...@whsg.info)
Cc: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Impress window position

Hi :)
Errr, which OS platform?  Is it some version of Linux (such as Ubuntu,
Mint, Redhat or something) or is it some flavour of Windows (such as Xp,
Vista, Win7, Win8, Win8.1 or Win10 or something?) or is it a Mac or BSD or
something else?

Also do you know if the the 2 screens are really treated as 1 very large
screen?  We can probably help with that if we knew which platform, or
better still which specific OS.

Good luck and regards from a Tom :)



On Mon, 11 Mar 2019 at 08:58, malcolm moore 
wrote:


Is it possible to get Impress  to go full screen for a presentation
without going
over the top of everything - here is the scenario - I have 2 screens, one
is an
interactive whiteboard and I am running OpenBoard. When I start a
presentation
it goes full screen and covers the OpenBoard 'control' panel. If I bring
the OpenBoard
to on top when I move to the next slide Impress goes over the top again
and
hides OpenBoard

Ta

Mal






--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Impress window position

2019-03-14 Thread Paul D. Mirowsky

When you drag Impress over to the screen on right, does it remain there 
after clicking on OpenBoard?


On 3/12/2019 4:22 AM, malcolm moore wrote:


Sorry a bit sparce on information...

It's openSUSE Tumbleweed
KDE Plasma
The screen is extended to the right

Mal



  
- Original Message -

From: Tom Davies (tomc...@gmail.com)
Date: 11/03/19 18:18
To: malcolm moore (st-malcolm.mo...@whsg.info)
Cc: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Impress window position

Hi :)
Errr, which OS platform?  Is it some version of Linux (such as Ubuntu,
Mint, Redhat or something) or is it some flavour of Windows (such as Xp,
Vista, Win7, Win8, Win8.1 or Win10 or something?) or is it a Mac or BSD or
something else?

Also do you know if the the 2 screens are really treated as 1 very large
screen?  We can probably help with that if we knew which platform, or
better still which specific OS.

Good luck and regards from a Tom :)



On Mon, 11 Mar 2019 at 08:58, malcolm moore 
wrote:



Is it possible to get Impress  to go full screen for a presentation
without going
over the top of everything - here is the scenario - I have 2 screens, one
is an
interactive whiteboard and I am running OpenBoard. When I start a
presentation
it goes full screen and covers the OpenBoard 'control' panel. If I bring
the OpenBoard
to on top when I move to the next slide Impress goes over the top again
and
hides OpenBoard

Ta

Mal






--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Help files bad link

2019-03-06 Thread Paul D. Mirowsky


Sorry about that.

Windows 7 Professional Service Pack 1 (64 Bit)

There are files in:

    C:\Program Files\LibreOffice" which are the default for 64 bit 
programs.


    and

    C:\Program Files\LibreOffice\help\en-US


In 

    LibreOffice 6.1.5.2

    LibreOffice 6.1 Help Pack (English (United States))



On 3/6/2019 8:51 AM, Tanstaafl wrote:

That didn't answer the question...

Do you have the 32bit or 64bit version of the application and/or Help
installed?

Look in the Programs and Features control panel to see what versions are
installed.

On Tue Mar 05 2019 10:50:22 GMT-0500 (Eastern Standard Time), Paul D.
Mirowsky  wrote:

Sort of.

      C:\Program Files (x86)\LibreOffice 4

      C:\Program Files (x86)\LibreOffice 5

          Are both empty.

C:\Program Files\LibreOffice\help

          Is not and "C:\Program
Files\LibreOffice\help\en-US\text\swriter" has HTML files.

When  on "main.html" results on Firefox URL
"file:///C:/Program%20Files/LibreOffice/help/en-US/text/swriter/main.html"
and displays correctly in browser.

Paul




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Help files bad link

2019-03-05 Thread Paul D. Mirowsky


I checked this and all fields seem appropriate.

I used the [Reset] button, but still results in Browser at 
"file:///C:/Users/paul/AppData/Local/Temp/lu109605km9jx.tmp/NewHelp1.html".


Paul

On 3/5/2019 10:46 AM, Graham Luffrum wrote:

Some years ago I had the same problem as you using LibreOffice on Windows.
It was solved by checking that the user interface language (Tools ->
Language settings -> User interface) was the same of that of the Help file
that you installed.

As an aside this problem doesn't arise under Linux as both the user
interface and the help are installed separately and will automatically have
the same language.  This is not the case with the Windows version and hence
someone not in the know can install LibreOffice in say the UK and
automatically have the user interface set to UK English.  If then the help
file for say US English is installed it will not be available.

Graham


On Tue, 5 Mar 2019 at 16:05, Paul D. Mirowsky 
wrote:


Have now tried...



[Toolbars]Search "Help" which results in

 Get Help Online
 Helplines While Moving
 LibreOffice Help

Selecting "LibreOffice Help"

Selecting {Defaults} and said {Yes}.

Results in Firefox tab with text "Help Page Redirection" at URL
"file:///C:/Users/paul/AppData/Local/Temp/lu78445i2amn.tmp/NewHelp1.html"

I'm am not sure of the context of the {Defaults} button, but am assuming
it does not mean correcting the URL because it doesn't.

Bueller?,   Bueller?, Bueller?,   Bueller?



On 3/1/2019 11:39 AM, Paul D. Mirowsky wrote:

I have removed and re-installed
"LibreOffice_6.1.5_Win_x64_helppack_en-US.msi".

But when I use  , it sends me to my browser at


"file:///C:/Users/paul/AppData/Local/Temp/lu791214dve3.tmp/NewHelp2.html".

Any ideas on how to fix this.

Help does not show up in "Options - LibreOffice - Paths".  Maybe it
should.

Thanks

Paul




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Help files bad link

2019-03-05 Thread Paul D. Mirowsky


Sort of.

    C:\Program Files (x86)\LibreOffice 4

    C:\Program Files (x86)\LibreOffice 5

        Are both empty.

C:\Program Files\LibreOffice\help

        Is not and "C:\Program 
Files\LibreOffice\help\en-US\text\swriter" has HTML files.


When  on "main.html" results on Firefox URL 
"file:///C:/Program%20Files/LibreOffice/help/en-US/text/swriter/main.html" 
and displays correctly in browser.


Paul


On 3/5/2019 10:36 AM, Tanstaafl wrote:

Is it possible you have mix of 64 bit application and 32 bit Help (or
vice versa)?

On Tue Mar 05 2019 10:03:45 GMT-0500 (Eastern Standard Time), Paul D.
Mirowsky  wrote:

Have now tried...



[Toolbars]        Search "Help" which results in

 Get Help Online
 Helplines While Moving
 LibreOffice Help

Selecting "LibreOffice Help"

Selecting {Defaults} and said {Yes}.

Results in Firefox tab with text "Help Page Redirection" at URL
"file:///C:/Users/paul/AppData/Local/Temp/lu78445i2amn.tmp/NewHelp1.html"

I'm am not sure of the context of the {Defaults} button, but am assuming
it does not mean correcting the URL because it doesn't.

Bueller?,   Bueller?, Bueller?,   Bueller?



On 3/1/2019 11:39 AM, Paul D. Mirowsky wrote:

I have removed and re-installed
"LibreOffice_6.1.5_Win_x64_helppack_en-US.msi".

But when I use  , it sends me to my browser at
"file:///C:/Users/paul/AppData/Local/Temp/lu791214dve3.tmp/NewHelp2.html".

Any ideas on how to fix this.

Help does not show up in "Options - LibreOffice - Paths".  Maybe it
should.

Thanks

Paul







--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Help files bad link

2019-03-05 Thread Paul D. Mirowsky


Have now tried...



[Toolbars]        Search "Help" which results in

   Get Help Online
   Helplines While Moving
   LibreOffice Help

Selecting "LibreOffice Help"

Selecting {Defaults} and said {Yes}.

Results in Firefox tab with text "Help Page Redirection" at URL 
"file:///C:/Users/paul/AppData/Local/Temp/lu78445i2amn.tmp/NewHelp1.html"


I'm am not sure of the context of the {Defaults} button, but am assuming 
it does not mean correcting the URL because it doesn't.


Bueller?,   Bueller?, Bueller?,   Bueller?



On 3/1/2019 11:39 AM, Paul D. Mirowsky wrote:
I have removed and re-installed 
"LibreOffice_6.1.5_Win_x64_helppack_en-US.msi".


But when I use  , it sends me to my browser at 
"file:///C:/Users/paul/AppData/Local/Temp/lu791214dve3.tmp/NewHelp2.html".


Any ideas on how to fix this.

Help does not show up in "Options - LibreOffice - Paths".  Maybe it 
should.


Thanks

Paul





--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Help files bad link

2019-03-01 Thread Paul D. Mirowsky

I have removed and re-installed 
"LibreOffice_6.1.5_Win_x64_helppack_en-US.msi".


But when I use  , it sends me to my browser at 
"file:///C:/Users/paul/AppData/Local/Temp/lu791214dve3.tmp/NewHelp2.html".


Any ideas on how to fix this.

Help does not show up in "Options - LibreOffice - Paths".  Maybe it should.

Thanks

Paul



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Base/Firebird Queries broken

2019-01-17 Thread Paul D. Mirowsky


Ok, this is what happened.

Opening the "2 Amps to Volts-High by Series"

    By main "Queries", right click and choose "Edit"

        In view, changed 134 to '134'

            Message: Warning    The entered criterion cannot be 
compared with this field.


        Remove 134 from Series and hit enter.

             results in all records

        Add 134 to Series and hit enter.

             results in just 134 Series records.

        Query Design 

    Double left click on query name "2 Amps to Volts-High by Series"

        Message: The data content could not be loaded.

                        Error code: 1

             firebird_sdbc error:
                        *Dynamic SQL Error
                        *SQL error code = -104
                        *Invalid usage of boolean expression
                        caused by
                        'isc_dsql_prepare'

By main "Queries", right click and choose "Edit in SQL view..."

        Remove AND "Amps"."Series" = '134'

             results in all records

        Add AND "Amps"."Series" = '134'

             results in just 134 Series records.

        Remove Add AND "Amps"."Series" = '134' and add Add AND 
"Amps"."Series" = 134


             results in just 134 Series records.

Saved the query in multiple states

When ever I save the Query and double left click from main Query window 
on "2 Amps to Volts-High by Series"


    Results in error message:

               firebird_sdbc error:
                            *Dynamic SQL Error
                            *SQL error code = -104
                            *Invalid usage of boolean expression
                            caused by
                            'isc_dsql_prepare'

In effect, in either edit mode it works correctly.

The saved query always fails.

Hope this helps

Paul


On 1/17/2019 12:58 AM, Robert Großkopf wrote:

Hi Paul,


Ok, things are narrowing down on this issue.

I have a Query Design view in which I have a field Series set to 134.

I remove the 134 and press enter.

Run Query (F5)

It works.

Save it at this point. Don't switch back. Does this work?

Then try
"Equipment"."Series" = '134'
instead of
"Equipment"."Series" = 134
before.

Regards

Robert


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Base/Firebird Queries broken


When editing the query, it works using RunQuery (F5)

After editing and it is working, I save the Query.

Then clicking on the saved Query from main Query window results in error 
again.


On 1/16/2019 1:06 PM, Drew Jensen wrote:

So, can you open that Query definition, the one that raised the error when
you double clicked on it, in design view and Run it and it works?

Is that what you are saying?

Thanks


On Wed, Jan 16, 2019 at 12:17 PM Paul D. Mirowsky 
wrote:


Ok, things are narrowing down on this issue.

I have a Query Design view in which I have a field Series set to 134.

I remove the 134 and press enter.

Run Query (F5)

It works.

Add back in 134 to Series field.

It works

Save it and save the database.

Double click on the query to run it.

Result in:


Error code: 1

firebird_sdbc error
*Dynamic SQL Error
*SQL error code = -104
*Invalid usage of boolean expression
caused by
'isc_dsql_prepare'

It appears that the run function is adding an operation that is not in
Query Design view.

Any suggestions?

Thanks

Paul


On 1/15/2019 6:19 PM, Paul D. Mirowsky wrote:

I am receiving the following error when opening a query.


firebird_sdbc error:
*Dynamic SQL Error
*SQL error code = -104
*Invalid usage of boolean expression
caused by
'isc_dsql_prepare'

The table names are: Amps   Volts-High

The two tables involved both have one boolean field each, so I removed
them from the query. The error still occurs.

I am taking this to mean that there is a boolean comparison happening
that is not in the SQL generated by Base.

Is this possible?

Thanks

Paul




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Re: Base/Firebird Queries broken

Hello Drew

I assumed that you are answering the question on error 104.

I changed the file as per your instructions to

db:parameter-name-substitution="true"

, but error 104 is still there.

Do I have to go back to my original file a migrate again with this fix
or am I fixing

SELECT rdb$get_context('SYSTEM','ENGINE_VERSION')... -- ENGINE_VERSION
Thanks

Paul

On 1/16/2019 11:42 AM, Drew Jensen wrote:

Howdy,

Yes, I have a suggestion - there is a property in the Base file which is
incorrectly set during the Migration Assistant run and must be fixed. The
error message looks like this is what is biting you.

The fastest way to fix it is at follows:
Close the base file and exit LibreOffice.
Rename the base file from .odb to .zip
Now open the file with your favorite zip tool.
You fill find a file named content.xml in the root of the file.
Open that with a text editor.
Search for this string: db:parameter-name-substitution="false"
Edit that so that it reads db:parameter-name-substitution="true"
Save your changes.
Close the zip file, it should ask if you want to update the file with the
change and answer yes.
Change file name back to .odb and you should be good to go.

Best wishes,

Drew

On Wed, Jan 16, 2019 at 11:27 AM Paul D. Mirowsky
wrote:

Found this at

https://stackoverflow.com/questions/31611233/determine-firebird-version-with-sql-version-2-1

|SELECT rdb$get_context('SYSTEM','ENGINE_VERSION')... -- ENGINE_VERSION
>= 2.1 Only problem is, when run as "Execute SQL Statement" menu item,
it errors as

1: firebird_sdbc error: *Dynamic SQL Error *SQL error code = -104
*Token unknown - line 1, column 50 *. caused by 'isc_dsql_prepare'

I'm sure it's buried somewhere. Any hints anyone? I am by no means an
SQL expert, Thank you for being patient. Paul |

On 1/16/2019 2:27 AM, Alexander Thurgood wrote:

Le 16/01/2019 à 00:19, Paul D. Mirowsky a écrit :

Invalid usage of boolean expression

This bug perhaps ?

http://tracker.firebirdsql.org/browse/CORE-5367?page=com.atlassian.jira.plugin.ext.subversion%3Asubversion-commits-tabpanel

Not sure which version of Firebird we are using in LO - 3.0.1 or 3.0.2 ?

Alex

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Base/Firebird Queries broken


Ok, things are narrowing down on this issue.

I have a Query Design view in which I have a field Series set to 134.

I remove the 134 and press enter.

Run Query (F5)

It works.

Add back in 134 to Series field.

It works

Save it and save the database.

Double click on the query to run it.

Result in:


Error code: 1

firebird_sdbc error
*Dynamic SQL Error
*SQL error code = -104
*Invalid usage of boolean expression
caused by
'isc_dsql_prepare'
It appears that the run function is adding an operation that is not in 
Query Design view.


Any suggestions?

Thanks

Paul


On 1/15/2019 6:19 PM, Paul D. Mirowsky wrote:

I am receiving the following error when opening a query.


firebird_sdbc error:
*Dynamic SQL Error
*SQL error code = -104
*Invalid usage of boolean expression
caused by
'isc_dsql_prepare'

The table names are: Amps   Volts-High

The two tables involved both have one boolean field each, so I removed 
them from the query. The error still occurs.


I am taking this to mean that there is a boolean comparison happening 
that is not in the SQL generated by Base.


Is this possible?

Thanks

Paul





--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Re: Base/Firebird Queries broken

Found this at 
https://stackoverflow.com/questions/31611233/determine-firebird-version-with-sql-version-2-1


|SELECT rdb$get_context('SYSTEM','ENGINE_VERSION')... -- ENGINE_VERSION 
>= 2.1 Only problem is, when run as "Execute SQL Statement" menu item, 
it errors as
1: firebird_sdbc error: *Dynamic SQL Error *SQL error code = -104 
*Token unknown - line 1, column 50 *. caused by 'isc_dsql_prepare' 
I'm sure it's buried somewhere. Any hints anyone? I am by no means an 
SQL expert, Thank you for being patient. Paul |


On 1/16/2019 2:27 AM, Alexander Thurgood wrote:

Le 16/01/2019 à 00:19, Paul D. Mirowsky a écrit :

Invalid usage of boolean expression


This bug perhaps ?

http://tracker.firebirdsql.org/browse/CORE-5367?page=com.atlassian.jira.plugin.ext.subversion%3Asubversion-commits-tabpanel

Not sure which version of Firebird we are using in LO - 3.0.1 or 3.0.2 ?


Alex



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Re: Base/Firebird Queries broken


I have replaced blanks with underscores in field names in tables.

I have removed alias named fields from queries.

It did not appear to make a difference.

I should note that tables Amps, Volts-High and  Volts-In have the same 
or more field names.


As each table name is prefixed to a field, I would not think this a 
possible error. Am I correct in this assumption?


Thanks

Paul

On 1/15/2019 11:27 AM, Alexander Thurgood wrote:

Le 15/01/2019 à 16:14, Paul D. Mirowsky a écrit :


Hi Paul,


SELECT "Equipment"."ID", "Equipment"."P_Model",
"Equipment"."P_Model_No", "Equipment"."Power Meter",

Check that the space in the field "Power Meter" isn't causing an issue.

There was a known bug about spaces being misinterpreted by the parser.



"Equipment"."Series", "Equipment"."Power Meter 2", "Equipment"."Power_No
2", "Equipment"."Power Meter 3", "Equipment"."Power_No 3",

Same here for "Power Meter 2" and "Power Meter 3"




"Ions-IM"."Ions", "Ions-IM"."Select", "Ions-IM"."Series",

Also check that the field name "Select" in Ions-IM.Select isn't being
misinterpeted.



"Volts-High"."Time", "Volts-High"."Reading" "Vo-Hi-Reading",

What is "Vo-Hi-Reading" - is this supposed to be an ALIAS ? Maybe check
whether that is correctly supported.


"Volts-High"."Type" "Vo-Hi-Type", "Volts-High"."Series",

Same here with "Vo-Hi-Type"



"Volts-High"."Setting", "Amps"."Reading" "Am-Reading", "Amps"."Type"

Same here with "Am-Reading"



"Am-Type", "Amps"."Series", "Amps"."Setting" FROM "Ions-IM",
"Equipment", "Volts-High", "Amps" WHERE "Ions-IM"."Series" =
"Equipment"."Series" AND "Volts-High"."Series" = "Ions-IM"."Series" AND
"Volts-High"."Date" = "Ions-IM"."Date" AND "Volts-High"."Time" =
"Ions-IM"."Time" AND "Amps"."Series" = "Volts-High"."Series" AND
"Amps"."Date" = "Volts-High"."Date" AND "Amps"."Time" =
"Volts-High"."Time" AND "Equipment"."Series" = 134 AND
"Ions-IM"."Select" = TRUE ORDER BY "Ions-IM"."Date" ASC,
"Ions-IM"."Time" ASC, "Ions-IM"."Ions" ASC

Not sure about how many left join conditions you can currently have.
That would probably need checking by removing them one-by-one until you
get something that works.


As Robert has mentioned, perhaps the migration didn't convert the data
types correctly, so your comparisons in the join conditions are no
longer working.


Good luck !


Alex



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Base/Firebird Queries broken


I am receiving the following error when opening a query.


firebird_sdbc error:
*Dynamic SQL Error
*SQL error code = -104
*Invalid usage of boolean expression
caused by
'isc_dsql_prepare'

The table names are: Amps   Volts-High

The two tables involved both have one boolean field each, so I removed 
them from the query. The error still occurs.


I am taking this to mean that there is a boolean comparison happening 
that is not in the SQL generated by Base.


Is this possible?

Thanks

Paul



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Re: Base/Firebird Queries broken


See below...

On 1/15/2019 10:37 AM, Robert Großkopf wrote:

Hi Paul,

Have a look at


"Ions-IM"."Select" = TRUE

Did the migrationtool set the field "Select" to a BOOLEAN-field?

Yes

"Equipment"."Series" = 134

Did the migrationtool import the field as a INTEGER field?

Not quite. Series is set to Number [Numeric]


There is no function in the query, only 4 tables connected ...
The only possibility to find the reason why Firebird couldn't execute
the query at this moment is to delete some parts of the query and try if
it will work without this parts.

By the way: There are only tables connected in theis query, not a view
connected with tables?
Not sure what you mean. These queries are developed to be linked to a 
Writer document as test data documentation. It is used to check the 
quantity of readings per unit at two each. Incorrect quantities of 
records prove data missing or inaccurate on import to Base.


Regards

Robert


Thanks

Paul


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Re: Base/Firebird Queries broken