I would like to create an automatic sequence of Openoffice backups of a spreadsheet file, and each would be the daughter of the previous version.I would like it to autosave every hour so at the end of the day I could then manually make up a 'Day' file for permanent record.
View 2 Replies
I'm trying to set up my home server, which runs Fedora 12, to automatically backup user documents like pictures, music. I want it to make a new DVD or ISO image on, say, a weekly basis, and to only backup the files created since the last backup. I discovered mondoarchive, but I'm not sure if this is capable of doing that. Is there a tool that I can use to do this?
View 2 Replies View Relatedin order to visualize the mentor-student relations inside my fraternity, I'd like to create a genealogy graph from a Excel spreadsheet. This works way better than expected, but there is one final issue. To demonstrate, this is a smaller version of the graph:
[URL]
It is ordered by year , while members are placed in the appropriate timeslot and are connected to show said relations. Unfortunately, as you can see, during a few years when the choosing of mentors was partly suspended due to historical reasons (WWII etc.), the members stack up to the right of the graph, widening it a lot. Is there a way to specify that they are supposed to be distributed among the members that are part of the structure in order to achieve minimum width?
I would like to create lossless backups of my DVDs, or more exactly the main movie including one or more audio tracks and a subtitle of my choice. I would like to have the subtitle burned into the movie so that I only have one file (container). No, I don't want a complete DVD folder (TS_Video and other stuff) nor do I want to create an iso file of the DVD. Is it possible? The way I see it there should be two options:
1. Extract the wanted audio track/tracks, one subtitle and the main movie. Keep the audio track/tracks and the movie track in their original formats, and put it all together in one file/container (subtitle burnt in). In theory it should work! I know the video tracks are mostly MPEG2 and the audio tracks mostly AC-3 or DTS.
2. Do almost exactly as above, but before putting it all together compress the video and audio tracks even further to some lossless formats. In theory this should work too! In some other forum a guy told me that since MPEG2 and AC-3/DTS are already compressed formats it probably isn't possible to compress audio and video much further without losses, which is probably true.
Is it possible to do what I want to do? How? If this process is not easy to do it would be nice if some of the skilled guys would create an application that does exactly this. I believe more than me would find it extremely useful.
I'd like to create backups from some copy protected DVD's, for my private use only.
Does it work this way to circumvent the copy protection mechanisms?
Code:
# dd if=/dev/dvd of=dvd.iso
and then burn dvd.iso on an empty DVD.
I am getting the databases from mysql and my database name is username_something.
I am getting the username and then puting the respective backups in corresponding folders like
tar bala bla /backups/sql/username/username_something.tar.sql.gz
The problem is system worrks if i have the folder username already there but for new databases if get the error like unknown file path.
How can i do that if username folder is not there it should be created
I've had several HDD crashes on my personal server over the years and it's just gotten to be a real pain in the rear. Crashed again this morning. Currently, I make monthly tarball backups of the entire filesystem using my script:
Code:
#!/bin/sh
# Removes the tarball from the previous execution.
rm -rf /backup/data/*.tar.gz
[code].....
I've been trying to create file sharing between my MacBook Pro and my Lucid Lynx box for time machine backups and media server purposes. I followed this guide:[URL]..Everything seems to work with these exceptions: I can see my LucidLynx box in my finder app in my Mac but only when I run these commands from Ubuntu:
Code:
sudo /etc/init.d/netatalk restart
sudo restart avahi-daemon
If I restart my LucidLynx box then I can't see anything in finder. I can't log into my LucidLynx box from finder. I don't get a bad username or password error it just tells me the connection failed. *Note if I do enter an incorrect username or password it WILL tell me it's incorrect. I've looked at this link below since some people have used it in theses forums but it's a bit dated[URL]..
I've been a DOS/Windows guy for 20 years, and recently became a SW test lab helper. My company uses CentOS for a lot, so I've become familiar with it, but obviously not as comfortable as I am with Windows.
Here's what I have planned:
machine: Core 2 Duo E8400, 8GB DDR2, 60GB SSD OS drive, ATI 4650 video card, other storage is flexible (I have 3 1TB drives and 4 750GB drives around that can be used in this machine.)
uses: HTPC, Network Storage, VMWare server host: SMTP, FTP server, and Web server virtual machines
I've figured out how to do much of this, but I haven't figured out how to do backups in Linux. I've been spoiled with Windows, with the built in backup system so simple to use. I find myself overwhelmed with the array of backup software, and unable to determine which to use. none of them seem to do everything I need them to do, but some come close, I think. I'm hoping someone here can help me out in figuring out which program to use and how to use it.
Here is what I need the backup software to do:
1. scheduled unattended backups, with alerts if the backups fail
2. a weekly full backup with incremental every 12 hours
3. removing the old backups when the new full backup runs, I would prefer to keep 2 weeks of backups, but that's not necessary
4. a GUI would be preferable, since my arthritic fingers don't always do as I want them to do. I typo things a lot, and the label worn off my backspace can attest to that.
How do you get Rsync to do incremental backups rather than full backups? At the moment I have a script that will create a backup folder (if it doesnt already exist) then copy the source files into the backup directory with the command
rsync $VERBOSE --exclude=$TARGET/ $EXCLUDE --exclude '/Ls-wtgl1c8/**' -rt --delete $source/ $TARGET/$source/ >> $LOG_FILE
Target is where the files will be backed up to Sources is the dir(s) to be backed up Exclude files is the list of files not to backup
log file is where the output will be saved to. At the moment it only does full backups, but I would only like to do incremental, how would this be achieved? Am I missing out an option in the Rsync that is required.
Like topic, I want to create a weekly backup of some folder to anoter partition (or external usb), compressed or not (folder also of 20/30 gb), with only root permission on file (or folder) created..This system, where I have installed debian jessie, is always on being used like a NAS..
View 1 Replies View RelatedSo since i deleted a necessary package my redhat system crashed. Now, when i had initially installed redhat using a friends disk I copied all the files from the CD-ROM on my external hard drive (of course after installing through the CD)
Now I need to re-install linux and I have no idea how to actually use those files to create an actual automatic bootable installation CD?
I have a large music directory that I'd like to somehow acquire, or generate, a list of each sub-folder within it, and then somehow get the list into a spreadsheet format. Is there a way to do this?
View 1 Replies View RelatedI'm trying to create a simple times table on OpenOffice.org Spreadsheet
I'm trying to use the "$" in the top tab (input line) i.e.
Quote:
=A3*$B2$
Quote:
=A3*$B3$
[Code].....
To make the question clearer. When I used to use Microsoft Excel in Windows I would do just as I said in the above and I would be able to construct simple multiplication tables to more bigger/harder to memorize kind of type. And that would be by dragging the rectangle from it's bottom-right corner
Screenshot-5.jpg
Screenshot-4.jpg
So my question is what's the alternative OpenOffice.org Spreadsheet symbol for the "$" symbol used in the formula bar in Microsoft Excel?
I have used the words 'Open Challenge'.I have attached a spreadsheet 'Sample file for filter.ods'.TASK: In a presentation, I would like to show what are the Topics of India on Day-1 , Day-2 , Day-3 , Day-4. That means I am going to Filter India and (Day-1, Day-2, Day-3, Day-4).
View 7 Replies View RelatedI had a really important spreadsheet with my student's grades in it. I wanted to rename it so I right clicked and renamed (at least that's what I thought I did). After I looked again, the file somehow became a zip folder. I inside the zip folder are a bunch of files but I can't the spreadsheet anywhere! Here are some screens:
View 2 Replies View RelatedI'm having some trouble with hyperlinks in openoffice 3.2 spreadsheet, though it may be a begginers problem.
I wrote a script to execute a certain task (in my case, to open an DNA alignment file with bioedit) and then, in openoffice, I assigned a hyperlink button to the path needed to execute the script, which is in my /home ("./script_file"). When I do this the first time, clicking the hyperlink button runs the script perfectly. However, whenever I close openoffice and re-open it afterwards, the hyperlink doesn't work anymore. I've checked and this happens because the original URL, which was "./script_file" changes to /home/user/etc... or /temp/etc... and, obviously the file isn't found. If I manually correct the URL, the hyperlink is functional again... how to fix the URL of an hyperlink so that I won't have to correct it every time I close and re-open the program?
Is there any way to make an OpenOffice spread sheet open to the last cell that was edited? I have a friend that has a very large spreadsheet, and would like to have it open to where he left off, rather than cell A1. He says excel does, or can be made to do this.
View 3 Replies View RelatedI know this is more of the Openoffice question but I felt I would find some solution here for this. At my work I am using lot of PDF files which are created using Openoffice Calc (Spreadsheet). I want to convert those PDFs to Calc file again for editing. Currently I am using a windows Machine with able2extract pdf converter for converting PDFs to .xls file. But it is not ideal solution for Linux and Openoffice users here.
View 2 Replies View RelatedI'm in an Aussie rules fantasy football competition and someone posted a zip file with relevant stats for players in the under 18 comp, as a guide for selecting possible players in next years team. Never used any of the office applications. I've attached the zip file and this is what the poster said...
In the actual spreadsheet though, there are two sheets. The first is all the raw data which you can order by position (based on me watching the games, and the line-ups listed on the AFL websites), K: H ratio, state etc. The second is a sheet which you can use to compare players.
I find that sometimes it is easier for me to make decisions about which players to pick when the stats are more obvious, so if you are the same, you can use this sheet as well. Anyway, I hope you guys enjoy the spreadsheet and I'll update it after each round. Fixed, I had to change the file from .zip to .xlsx
In OpenOffice how do you generate a PDF from the current sheet in a spreadsheet. This spreadsheet has 40 sheets. But I want to get a PDF of sheet8 only. When I "Export as PDF", I get a PDF file that contains all 40 sheets.
View 3 Replies View Relatedsince upgrade from 9.04 to 9.10, I cannot load a website link which should load openoffice and then an excel or spreadsheet document.
It recognises that its an "excel" document because it load openoffice spreadsheet, but it loads a blank document without any data in it.
It worked properly in version 9.04?
I have created a very simple spreadsheet - using gnumeric - with small numbers and simple formulas - the numbers fit easily inside their cells - the formatting all seems in order BEFORE I try to print. When I set up the spreadsheet for printing - and "print preview" the document, I see hash marks in place of numbers in a majority of the cells. When I print the document, the hash marks are printed, in place of the numbers. When I view the document under normal circumstances, for editing - the hash marks are not present. All seems well. I cannot print the spreadsheet without the hash marks (#####) appearing!
View 1 Replies View RelatedI created a spreadsheet which I had edited repeatedly. Today I ran out of disk space and needed to resize some partitions. After that proceedure I opened the spreadsheet and when I click on a cell to see the formula I get the message "document opened in read only mode". Other documents open fine.
View 1 Replies View RelatedClamAV tells me that three of my OpenOffice.org Calc spreadsheets may be infected (status "MBL_144360.UNOFFICIAL", if that means anything). This seems not entirely implausible, since yesterday I used a USB stick to transfer files from a Windows system. Anyway, I'd really like to keep these spreadsheets. Can I disinfect them somehow?
View 2 Replies View Relatedhow to read data from excel to java in the excel sheet chinise language is present while reading into java iam getting question marks.how to get chiniese language instead of question marks in the java file
View 1 Replies View RelatedI'm looking for a Linux Open Office Calc Spreadsheet template to replace Intuit's Quicken. I prefer a spreadsheet over a stand alone. Anyone?
View 1 Replies View RelatedIn my prior experience with spreadsheet software on Linux, Gnumeric has been the most useful for my daily tasks. However, I am now required to plot scientific data and I need to be able to plot log-log graphs and semi-log graphs (graphs with logarithmic scales for x- and y- axes) and I cannot seem to find a program that will "fit the bill".
Gnumeric allows for log-log and semi-log graphs by selecting the logarithmic scale for the x- or y- axis, however it automatically does the log to a base 10 and I need to do log graphs to base n (n being a variable that I can set, whether it is 1.5 or 150000).I know this is possible in MS Word (somebody showed me a few weeks ago), but I want a Free (as in speech and as in beer) program that will allow me to plot log-log and semi-log to different bases. OpenOffice.org is also not useful for doing this as it plots to the base 10. Also tried labplot and qtiplot, they give a few more bases but still no base n
I have a spreadsheet which I update regularly. This involves downloading CSV files from a couple of websites, copying data from those files into an OO.org spreadsheet and copying formulas within the spreadsheet (the number of rows of data varies, so when the number of rows of data increases, I need to copy more lines of formulas).
I'd like to automate this process, so that with a single command I can get the data from the websites and feed it into my spreadsheet without having to copy rows of formulas. Although I've done lots of numerically-oriented programming, I have no idea how to undertake this automation task. I don't even know which tools I need to learn to do it.
Does anyone else find that Openoffice 3.2's spreadsheet app becomes unresponsive when copying and pasting multi-cell selections? I've had this problem ever since I started using Ubuntu 10.04, which comes with OO.O 3.2. The problem becomes noticeable whenever I make a selection more than about 8-10 columns across. Once the flashing border appears around the selected cells, the spreadsheet app becomes very sluggish. The mouse still moves normally, but it takes several seconds after a click until the highlight moves to another cell, or to un-select the cells, or copy them. These slowdowns happen both in old spreadsheets and in freshly created ones. They didn't happen with Openoffice 3.1 or earlier. Haven't tried it under Windows, so I'm not sure whether this is an issue specific to Linux OpenOffice 3.2. Other apps don't seem to be affected.
View 1 Replies View Related
