Lantica User Forum - Edit the server log?

(UTC)

Lantica User Forum › Lantica Discussions › Lantica Discussion › Edit the server log?

(Moderator: Forum Admin)

‹ Previous Topic | Next Topic ›

Page Index Toggle

Pages: 1

Send Topic

Print

Normal Topic

Edit the server log? (Read 658 times)

Infinity Senior Member Members Offline Diagonally parked in a parallel dimension Posts: 1290 Location: Massachusetts Joined: May 27^th, 2005	Edit the server log? Feb 9^th, 2006 at 4:54pm	Print Post
	Yesterday I did a translation of our biggest Q&A database, in terms of both amount of programming and the quantity of records. I got a huge number of errors in the server log, which I expected. The Server Admin screen allows for a terrific view of this log but I cannot edit it, which would be useful in squashing the bugs. I've looked at "s_log0000.log" in Notepad, MS Word, and Excel, but none of these have been helpful in presenting the data in a manner which can be easily manipulated. I will, of course, try other editors, but I thought I'd ask if anyone knows of an application which is suited for the job. Thanks in advance.

	** Captain Infinity
	WWW IP Logged

Ray the Reaper Global Moderator Members Lantica Support Offline The One & The Only Posts: 2482 Joined: Aug 20^th, 2003	Re: Edit the server log? Reply #1 - Feb 9^th, 2006 at 5:09pm	Print Post
	Hello Scott Do Not Edit That File. It is a binary log file and the order of it is very important to Sesame. One small change and you can render that entire Log file useless. -Ray

	Raymond Yoxall Consulting ray.yoxall@gmail.com ryoxall@lantica.com Sesame Applications, Design and Support
	WWW IP Logged

Infinity Senior Member Members Offline Diagonally parked in a parallel dimension Posts: 1290 Location: Massachusetts Joined: May 27^th, 2005	Re: Edit the server log? Reply #2 - Feb 9^th, 2006 at 5:11pm	Print Post
	I assumed that so I am working with a copy. Any editor suggestions? Can I print it to a file and edit that?

	** Captain Infinity
	WWW IP Logged

Ray the Reaper Global Moderator Members Lantica Support Offline The One & The Only Posts: 2482 Joined: Aug 20^th, 2003	Re: Edit the server log? Reply #3 - Feb 9^th, 2006 at 5:17pm	Print Post
	I have no suggestions. I know of only two programs that can read a Sesame Log File correctly. They are Sesame and the Sesame Log Reader that Technical Support uses. Why do you want to edit it? If you have a Text printer then Yes you can print the log out. -Ray

	Raymond Yoxall Consulting ray.yoxall@gmail.com ryoxall@lantica.com Sesame Applications, Design and Support
	WWW IP Logged

Infinity Senior Member Members Offline Diagonally parked in a parallel dimension Posts: 1290 Location: Massachusetts Joined: May 27^th, 2005	Re: Edit the server log? Reply #4 - Feb 9^th, 2006 at 5:35pm	Print Post
	With a bit of experimentation, I have found a way to edit the text of the log. First, I printed it to my Adobe document converter. Then I selected all the text in the PDF and copied it to a text editor. YAY! I want to edit it so that I can group similar errors and delete them from the log (TXT file - I'm not touching the actual log) when I have fixed them, leaving only unfixed errors. Fixing these problems will take a loooong time (the PDF is 650 pages). The alternative is to fix a few, save the dtf, re-translate, read the log, fix a few more, and so on. And since the original translation took about 2 hours I want to avoid that process.

	** Captain Infinity
	WWW IP Logged

Bob_Hansen Senior Member Members Offline WOW, They have the Internet on computers now! Posts: 1861 Location: Salem, NH Joined: Nov 24^th, 2002	Re: Edit the server log? Reply #5 - Feb 9^th, 2006 at 5:50pm	Print Post
	If you recently did a translation, most of those errors may be for each record with the same problem. For instance, if you had a field named DATE, which is a reserved word, then renaming that single field may eliminate thousands of lines in the log. Suggets you pick away at the obvious errors, fix them, and do translate again vs. doing log line by line. Will be much better use of your time. I saw you earlier posts re acceptable characters in field names. It is easiest to just limit yourself to 26 chars and 10 digits, forget all other symbols/characters. Q&A will adjust all references to field name changes except those in quotes in XL statements). Easier to change names before translating because Sesame will not change names in programming, you will need to do manual Search/Replace in program editor, in each form, in each program trigger section. Also suggest changing all field types "N" to "N0" (That is a zero).

	Bob Hansen Sesame Database Manager Professional Sensible Solutions Inc. Salem, NH 603-898-8223 Skype ID = sensiblesolutions
	WWW Skype/VoIP IP Logged

Infinity Senior Member Members Offline Diagonally parked in a parallel dimension Posts: 1290 Location: Massachusetts Joined: May 27^th, 2005	Re: Edit the server log? Reply #6 - Feb 9^th, 2006 at 6:09pm	Print Post
	Quote: If you recently did a translation, most of those errors may be for each record with the same problem. For instance, if you had a field named DATE, which is a reserved word, then renaming that single field may eliminate thousands of lines in the log. Ah. I was unaware of this. Thanks! Quote: Suggets you pick away at the obvious errors, fix them, and do translate again vs. doing log line by line. Will be much better use of your time. OK, I'll give it a shot. Quote: Also suggest changing all field types "N" to "N0" (That is a zero). OK. I assume that eliminates the trailing zeroes in Sesame?

	** Captain Infinity
	WWW IP Logged

Page Index Toggle

Pages: 1

Send Topic

Print

‹ Previous Topic | Next Topic ›

« Board Index ‹ Board Top

Top

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid XHTML

Valid CSS

Powered by Perl

Source Forge