Open remote file (url) from command line

Talk about anything at all....

Open remote file (url) from command line

Postby bartjeman » Thu Dec 12, 2019 9:26 pm

I am trying to start openoffice from command line to open a remote file
like this:
"C:\Program Files (x86)\OpenOffice 4\program\soffice.exe" "https://mywebsite.com/custom/openoffice-quotes/quotation_&_specs.ots"
error message is attached
Attachments
Clipboard01.jpg
Clipboard01.jpg (9.59 KiB) Viewed 1697 times
OpenOffice 4.0.1 on Windows 7
User avatar
bartjeman
 
Posts: 157
Joined: Sun Jan 03, 2010 6:23 am
Location: Toronto

Re: open remote file (url) from command line

Postby RoryOF » Thu Dec 12, 2019 9:38 pm

Can you open that file from within OpenOffice, using /File /open?
Apache OpenOffice 4.1.7 on Xubuntu 18.04.4 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 31236
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: open remote file (url) from command line

Postby Villeroy » Thu Dec 12, 2019 10:36 pm

RoryOF wrote:Can you open that file from within OpenOffice, using /File /open?
This works by pasting the URL into the file name box.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28434
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Open remote file (url) from command line

Postby bartjeman » Thu Dec 12, 2019 11:56 pm

Yes the file opens locally no problem
Yes I know you can paste URL into File Open dialog

The plan is to have our customers install openoffice locally
Then they open .ots template file from our server. This way we are certain they always have the latest version of the file.
We will create a program shortcut on their desktop.
Attachments
Clipboard01.jpg
OpenOffice 4.0.1 on Windows 7
User avatar
bartjeman
 
Posts: 157
Joined: Sun Jan 03, 2010 6:23 am
Location: Toronto

Re: Open remote file (url) from command line

Postby bartjeman » Wed Dec 18, 2019 5:48 pm

Is my idea so absurd :-)
OpenOffice 4.0.1 on Windows 7
User avatar
bartjeman
 
Posts: 157
Joined: Sun Jan 03, 2010 6:23 am
Location: Toronto

Re: Open remote file (url) from command line

Postby RoryOF » Wed Dec 18, 2019 6:51 pm

I am able to do this on my Xubuntu system by
Code: Select all   Expand viewCollapse view
openoffice4 /Path/to/remote/File/Remote_file.odt


OpenOffice can sort out which of its applications to use to open the file. Note that it does not like spaces in the path or filename, and for some reason (I think some sort of race condition, not investigated) on my computer a file of less than about 55KB will not reliably load across the network using this method. Your circumstances may differ.
Apache OpenOffice 4.1.7 on Xubuntu 18.04.4 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 31236
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Open remote file (url) from command line

Postby RoryOF » Wed Dec 18, 2019 7:23 pm

My advice is that you should try this using a simple file (no spaces in file name) on your local remote server, starting with soffice.exe, and commence with a file of some size - say 200KB, reducing it in size until it fails. Keep everything simple until you know that it can or cannot be done on your computers
Apache OpenOffice 4.1.7 on Xubuntu 18.04.4 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 31236
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Open remote file (url) from command line

Postby Villeroy » Wed Dec 18, 2019 7:33 pm

I get the same "Error reading from internet" with OpenOffice on Linux. Works fine with LibreOffice.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28434
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Open remote file (url) from command line

Postby RoryOF » Wed Dec 18, 2019 7:43 pm

I'm only working on my local network; my main NAS doesn't like opening smaller files from OO /File /Open - they need to be larger than about 28KB. After two or three attempts a smaller file will open.

Note that the OO user will (I think) need permissions to write to the remote server so that it can create a lock file. If the remote files are marked read-only the required user permissions may change - I have not investigated this.
Apache OpenOffice 4.1.7 on Xubuntu 18.04.4 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 31236
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Open remote file (url) from command line

Postby bartjeman » Wed Dec 18, 2019 7:56 pm

Not working for me
I uploaded an empty file, it will be there only for 120 minutes if you want to try it
https://tmpfiles.org/download/34455/this-is-a-test.ods

"C:\Program Files (x86)\OpenOffice 4\program\soffice.exe" https://tmpfiles.org/download/34455/this-is-a-test.ods
"Error reading data from internet"
OpenOffice 4.0.1 on Windows 7
User avatar
bartjeman
 
Posts: 157
Joined: Sun Jan 03, 2010 6:23 am
Location: Toronto

Re: Open remote file (url) from command line

Postby bartjeman » Wed Dec 18, 2019 8:05 pm

What you said about the lock file is interesting.
Webmasters are unlikely to give free reign for writing to their servers, perhaps LibeOffice has recognized this and disabled the lock file feature (for remote files only).
Villeroy when you used LO was a lock file created?
OpenOffice 4.0.1 on Windows 7
User avatar
bartjeman
 
Posts: 157
Joined: Sun Jan 03, 2010 6:23 am
Location: Toronto

Re: Open remote file (url) from command line

Postby RoryOF » Wed Dec 18, 2019 8:23 pm

I got "Server error message ."
Apache OpenOffice 4.1.7 on Xubuntu 18.04.4 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 31236
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Open remote file (url) from command line

Postby RoryOF » Wed Dec 18, 2019 8:25 pm

There is a command line setting for OO to disable the lock file.
Apache OpenOffice 4.1.7 on Xubuntu 18.04.4 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 31236
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Open remote file (url) from command line

Postby bartjeman » Wed Dec 18, 2019 9:02 pm

Manual says -nolockcheck does not check for the lock file, maybe that also means that a lock file will not be created.
"C:\Program Files (x86)\OpenOffice 4\program\soffice.exe" -nolockcheck https://tmpfiles.org/download/34455/this-is-a-test.ods
Still get "Error reading data from the internet. Server error message"
OpenOffice 4.0.1 on Windows 7
User avatar
bartjeman
 
Posts: 157
Joined: Sun Jan 03, 2010 6:23 am
Location: Toronto

Re: Open remote file (url) from command line

Postby Villeroy » Wed Dec 18, 2019 9:16 pm

Code: Select all   Expand viewCollapse view
libreoffice https://forum.openoffice.org/en/forum/download/file.php?id=39048

Opens a Writer template from this site. The resulting document is a new instance of that template. There is no lock file until you save the document to some place.

Code: Select all   Expand viewCollapse view
/opt/openoffice4/program/soffice https://forum.openoffice.org/en/forum/download/file.php?id=39048

raises the same "Error reading from the internet" as you get on Windows. I would say that OpenOffice fails to download the file. This may be due to outdated SSL libraries or something on that level. If it has to be OpenOffice for some reason, you may try an unencrypted http:// address.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28434
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Open remote file (url) from command line

Postby bartjeman » Thu Dec 19, 2019 5:49 pm

Thanks Villeroy
Are there any unencrypted sites anymore ;-)
Anyway, in my scenario the sharing site will be encrypted
Should I submit this to BugZilla?
OpenOffice 4.0.1 on Windows 7
User avatar
bartjeman
 
Posts: 157
Joined: Sun Jan 03, 2010 6:23 am
Location: Toronto

Re: Open remote file (url) from command line

Postby Villeroy » Thu Dec 19, 2019 7:40 pm

I'm just guessing. If you were running your own http: server, you could give a try. I doubt that this will ever be fixed in AOO. Just use what works. LibreOffice can be a bitch. However, most things work better and they try to improve the software every day.

I just tried this with our local ftp: server
Code: Select all   Expand viewCollapse view
/opt/openoffice4/program/soffice ftp://scanner@192.168.15.1/Krimskram/Stellenbeschreibung.ott

and it works.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28434
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Open remote file (url) from command line

Postby bartjeman » Thu Dec 19, 2019 9:51 pm

With FTP it will require username and password (in my case)
Thank you RoryOF and Villeroy for your time
I think I will look into a batch file that downloads the file, and then opens OO
Take Care
OpenOffice 4.0.1 on Windows 7
User avatar
bartjeman
 
Posts: 157
Joined: Sun Jan 03, 2010 6:23 am
Location: Toronto

Re: Open remote file (url) from command line

Postby Bill » Fri Dec 20, 2019 1:14 am

bartjeman wrote:Manual says -nolockcheck does not check for the lock file, maybe that also means that a lock file will not be created.

I think you need to use the -n option to stop creation of a lock file. However, I don't think that will have any effect on the error message. These are some of the options for /opt/openoffice4/program/soffice on Manjaro:

Code: Select all   Expand viewCollapse view
-nolockcheck    don't check for remote instances using the installation
-o              open documents regardless whether they are templates or not.
-n              always open documents as new files (use as template).

I tested opening a local file from the command line with and without the -n option. With the -n option, a new file was created and there was no lock file. Without the -n option, the original file was opened for editing and a lock file was created.
AOO 4.1.7, LO 6.3.6.2 and LO 6.4.3.2 on Kubuntu 20.04
Bill
Volunteer
 
Posts: 7803
Joined: Sat Nov 24, 2007 6:48 am

Re: Open remote file (url) from command line

Postby Haris3986 » Mon Mar 30, 2020 9:05 pm

I got the same error
OpenOffice 3.1 on Windows Vista
User avatar
Haris3986
Banned
 
Posts: 2
Joined: Mon Mar 30, 2020 8:55 pm
Location: X: getreviewit.com/2020/02/coin-master-free-spins.html


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 4 guests