| Author | Message | ||
     Craig Ball Username: craigball Registered: 4-2006 |
I ran Trace against a hard disk and recovered 1,174,551 URLs, 94,573 redirections and 4275 "other." As Trace offers no obvious way to save the results, I sought to export them. This caused the program to go into "waiting" (hourglass) mode for more than 12 hours. Of course, I had to kill the process to regain control and lost the analysis. I ran it again, sought to export again, and after 16 hours, it's still exporting to oblivion. I've got 3 GB of RAM in the system. Anything I can do to save this work or successfully export the results when I kill the process tomorrow? Might three times be a charm with a little help? Thanks. | ||
| Stefan Fleischmann Username: admin Registered: 1-2001 |
I still have to look into this, but would recommend checking the output file for how many lines were actually exported up to that point. | ||
| Alan M. Kaplan Username: lasvega0 Registered: N/A |
Craig, I had a similar experience with Trace 3.1 just the other day. I finally got it to set up two XLS files. Now one thing I should say is that my URLs were only 110,000 so it isn't necessarily a good comparison. Nevertheless when it exported it asked me if I wanted to set it up a txt file I responded no. next it asked me if I wanted to save to an XLS file and when I replied in the affirmative it asked me about want to make it into two XL as files, with the first one being about 65,000 lines. I assume that was part of the Excell program trying to keep my list in limits. As I say, that was a few days ago I am currently trying to repeat that experience and I can't get past the export command. Trace does a beautiful job but as you say it is very difficult to capture and use the results. Al | ||
| Stefan Fleischmann Username: admin Registered: 1-2001 |
There is no way you could create an XLS file with X-Ways Trace. Unfortunately I don't know why it would hang when using the Export command, sorry. | ||
| Don Camillo Username: willybilly Registered: N/A |
The reason: I suppose you use Excel 2003 or earlier! See: http://www.office-loesung.de/ftopic133650_0_0_asc.php 1 Begrenzung beim Speichern / Verwalten von Daten Excel 2003 Excel 2007 2 Spalten pro Arbeitsblatt 256 16.384 3 Zeilen pro Arbeitsblatt 65.536 1.048.567 4 Verschiedene Farben in einer Arbeitsmappe 56 4,3 Milliarden 5 Bedingte Formatierungen pro Zelle 3 Nur durch Arbeits- speicher begrenzt 6 Sortierstufen für einen Bereich der Tabelle 3 64 7 Angezeigte Elemente in einer Autofilter-Liste 1.024 32.768 8 Angezeigte Zeichen pro Zelle 1.024 32.768 9 Zeichen pro Zeile die gedruckt werden können 1.024 32.768 10 Individuelle Zellformate in einer Arbeitsmappe 4.000 65.536 11 Zeichen pro Formel 1.024 8.192 12 Verschachtelungen pro Formel 7 64 13 Argumente pro Formel 30 255 14 Zeichen pro Zelle, die im Textformat gespeichert und angezeigt werden können 255 32.768 15 Spalten pro Pivottabelle 255 16.384 16 Felder in einer Pivottabellen-Feldliste 255 16.384 |