[dba-Tech] FireFox

[John R Bartow]

Nice tip! Thanks.

-----Original Message-----
From: dba-Tech [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of
Stuart McLachlan
Sent: Thursday, October 27, 2016 7:35 PM
To: Discussion of Hardware and Software issues
Subject: Re: [dba-Tech] FireFox

You don't even need to change the extention.  Many ZIP file utilities let
you open regardless of the extension.  ( I just right click on a .xlsx file
and select 7Zip - Open from my explorer
menu.)

I've done this occassionally.  If you need to check the number of sheets and
the sheet names (and possibly rename sheets) in a load of workbooks, the
simplest way is to open the  
archive  7Zip and edit the file Workbook.xml.     

It's fairly simple to write a small utility to do this this sort of thing
for all the files in a directory.
:)


On 27 Oct 2016 at 17:34, Jim Lawrence wrote:

> Hi Lambert:
> 
> I did not know that. I could visualize some interesting applications.
> Have you ever used this knowledge?
> 
> Jim
> 
> ----- Original Message -----
> From: "Heenan, Lambert" <Lambert.Heenan at aig.com>
> To: "Discussion of Hardware and Software issues"
> <dba-tech at databaseadvisors.com> Sent: Thursday, October 27, 2016
> 10:39:05 AM Subject: Re: [dba-Tech] FireFox
> 
> On a related note. Did you know that Excel 2007+ files are actually 
> ZIP files containing a series of XLM files. That's why they do not 
> compress much: already compressed internally. Change the extension of 
> an .xlsx file to ZIP and you can open it in your favorite ZIP manager 
> as see the structure laid out.
> 
> Lambert
> 
> -----Original Message-----
> From: dba-Tech [mailto:dba-tech-bounces at databaseadvisors.com] On 
> Behalf Of Jim Lawrence Sent: Thursday, October 27, 2016 1:18 PM To:
> Discussion of Hardware and Software issues Subject: [dba-Tech] FireFox
> 
> Hi All:
> 
> Does everyone already know this or is it just me, that the following 
> amazing?
> 
> I have just discovered that FireFox is built on top of a series of 
> SQLite files. Every plugin, setting, history, download, cookie, visted 
> site, caches and bookmarks are all stored in these database files. All 
> tranaction date, size, duration, activity and location is stored in 
> the records. If you lose some information and wish to trace it just 
> dig through these files. Mind you, if you have been using your version 
> of FF for more than a couple weeks, the files are huge and date ranges 
> are the only way to find anything usable (50 pages of data is 
> useless)...spent hours last night trying to find details on a couple 
> of visited site (and was learning how SQLite works).
> 
> I have not tried to use other SQLs to access the data as I suspect 
> SQLite has it own data encoding. I was working at the command prompt 
> for quite a while before I downloaded a GUI. Has anyone else had 
> experience with SQLite? If you have do you have any comments or 
> recommendations?
> 
> TIA
> Jim    
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
> 
> 
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
> 
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com



_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com