ID |
Date |
Icon |
Author |
Author Email |
Category |
OS |
ELOG Version |
Subject |
66514
|
Tue Aug 11 16:25:28 2009 |
| Alan Grant | netman311@mts.net | Question | Windows | 2.6.5 | Re: Logbook Parser |
Steve Williamson wrote: |
Stefan Ritt wrote: |
Alan Grant wrote: |
We are exploring whether it's possible/feasible to import ELog logbooks into a another database for special purposes (plotting/statisical, etc). Target database is TBD (perhaps Access).
Does anyone have or know of a logbook parser program? From cut/pasting into, for example, Excel, it does appear that the data fields are already line-feed delimited so offhand it would seem possible to parse if one really wanted to pursue it.
Regards,
- Alan
|
You can export to CSV (comma-separated-values) if you go to "Find" and then click on "Export: CSV". These fiels you ran read right into Excel or other spreadsheet programs for further analysis.
|
excuse my butting in ... I've found the exports useful in the past - however, is is possible to run the export from a script in order to produce reports? Utilities like wget won't work as the export process doesn't return the data as html.
regards
Steve
|
Steve, just a word of thanks for "butting in" ... my next thought was how could I schedule an export to feed the other database so it wouldn't have to be done manually each day. Your question took care of that for me! :)
Good community. Thanks. |
66778
|
Mon Mar 29 06:05:08 2010 |
| Alan Grant | netman311@mts.net | Question | Windows | 2.7.8 | Active Directory authentication | Found a thread from 2004 ("External authentication") asking about the possibility of tying that in with ELog and answer was "Not yet". With time past, any chance this is now possible? I didn't see any more info on that since.
I'd like to explore using AD to set up/manage groups for ELog authentication. Alternatively, is there currently another way with ELog to manage groups?
Regards. |
67094
|
Fri Jul 22 00:05:02 2011 |
| Alan Grant | netman311@mts.net | Question | Windows | 2.9.0 | Elog client usage | I have searched the Elog forum and docs at length for actual examples of how to use the Elog client and I apologize if I missed it somehwere but could someone please provide some actual examples of how the parmeters are used? I haven't had much success setting it up just going by the Elog command syntax quide.
What I intend to do is load a raw text file into an active logbook directly, either one line at at time or batched from a text file ("m" option).
Also, I saw a Perl script contribution somewhere on the site which appears to offer the same functionality as the above util. Just wondering why there would be two methods, and which might be the best for me to use?
Thank you. |
67096
|
Tue Jul 26 21:50:05 2011 |
| Alan Grant | netman311@mts.net | Info | All | 2.9.0 | Re: Elog client usage |
Andreas Luedeke wrote: |
Alan Grant wrote: |
I have searched the Elog forum and docs at length for actual examples of how to use the Elog client and I apologize if I missed it somehwere but could someone please provide some actual examples of how the parmeters are used? I haven't had much success setting it up just going by the Elog command syntax quide.
What I intend to do is load a raw text file into an active logbook directly, either one line at at time or batched from a text file ("m" option).
Also, I saw a Perl script contribution somewhere on the site which appears to offer the same functionality as the above util. Just wondering why there would be two methods, and which might be the best for me to use? Thank you.
|
I suppose you have your demon "elogd" running and you can connect to your logbook via the web interface?
Then you can use the "elog" command to upload a text file as one entry.
If you want to split the text file to one-entry-per-line, you need to write a batch script to do that.
The usage of the "elog" command is descibed in the ELOG User's Guide: https://midas.psi.ch/elog/userguide.html#misc
The command line for "elog" has to define all "Required attributes" with "-a ..."
elog -h <host> -p <port> -l <logbook> -u <user> <password> -a <attribute>=<value> -n 1 -m <text-file>
<port> can be omitted if port 80 is used, "-u <user> <password>" can be omitted if anonymous entry creation is allowed.
Here's an example to write to the demo logbook at midas (local text file /tmp/hello.txt contains "hello world")
elog -h midas.psi.ch -l Linux+Demo -d elogs -a Author=nobody -a Type=Other -a Category=test -a "Subject=hello" -m /tmp/hello.txt
I hope this helps.
PS: please never refer to a location as "somewhere on the site".
|
It seems straight forward enough but I must be missing something in my elog command string. I run the client utiltiy but it always hangs after pressing Enter from the cmd window. It could be the way I specifying the host or subdir but I'm not sure. I tried multiple variations.
Some more info: For the prototype I'm just running Elog locally. I installed it to my XP in "c:\program files\elog". I verified tht elogd process is running. With the Elog page already open (ref my attached cfg file) I typed the following, observing case sensitivity, then press enter and at this point it just hangs:
elog -h localhost -p 8080 -l Tartan+Tow+Log -d elog -a Ticket+date="Jul26/11"
Note since all attributes are optional I only included "Ticket Date" for now until I can get this cmd working.
Please bear with me as I don't have an extensive technical background but I would be very grateful for any help as it's for a project at work. Soonest response would be greatly appreciated.
Thanks.
Alan
|
Attachment 1: elogd.cfg
|
[global]
port = 8080
SMTP host = citygw
Display mode = summary
Self register = 1
[Tartan Tow Log]
Theme = default
Entries per page = 30
List Menu commands = New, Find, <a href=?cmd=Find>Print</a>
Menu commands = List, Edit, Duplicate, Delete, Back
Attributes = Ticket Date, Ticket Time, System Rec'd Date, System Rec'd Time, Ticket, Plate, Make, VIN, Pick Up Location, Officer, Violation, Work Type, Pick Up Date, Pick Up Time, Tow Unit, Drop Date, Drop Time, Drop Location, GOA, Cancel
List Display = ID, Ticket Date, Ticket Time, Ticket, Plate, VIN, Pick Up Location, Work Type, Pick Up Time, Drop Time, Drop Location, GOA
Summary lines = 0
Options Work Type = Rush Hour AM, Rush Hour PM, Street Work, Snow Route, ROPB, General
Options GOA = boolean
Options Cancel = boolean
Page Title = ELOG - $subject
Reverse sort = 1
Quick filter = Date, ID, Ticket Date, Ticket, Plate, VIN, Pick Up Location, Work Type, Drop Location, Subtext
|
67099
|
Tue Aug 2 21:36:20 2011 |
| Alan Grant | netman311@mts.net | Info | All | 2.9.0 | Re: Elog client usage |
Andreas Luedeke wrote: |
Alan Grant wrote: |
Andreas Luedeke wrote: |
Alan Grant wrote: |
What I intend to do is load a raw text file into an active logbook directly, either one line at at time or batched from a text file ("m" option). [...]
|
[...] The usage of the "elog" command is descibed in the ELOG User's Guide: https://midas.psi.ch/elog/userguide.html#misc |
[...] I typed the following, observing case sensitivity, then press enter and at this point it just hangs:
elog -h localhost -p 8080 -l Tartan+Tow+Log -d elog -a Ticket+date="Jul26/11"
|
You wrote you want to upload a text file, then you need to add at the end "-m <file>". E.g. if the text-file is named "C:text.txt", then write:
elog -h localhost -p 8080 -l Tartan+Tow+Log -d elog -a Ticket+date="Jul26/11" -n 1 -m C:text.txt
The "-n 1" is just to tell elog to upload plain text. If you do not specify "-m <file>" then it expects input from a pipe and therefore hangs. If you don't know what "input from a pipe" means then ALWAYS use the "-m <file>" option.
PS: if "Ticket date" is of the format "date" then it is sensitive to the formatting of the date string. "Jul26/11" is likely not a legal date format. Better do not specify it for the first test. Write instead:
elog -h localhost -p 8080 -l Tartan+Tow+Log -d elog -n 1 -m C:text.txt
PPS: do you really use a sub-directory "elog" instead of the default location "logbooks" for your ELOG logbook files? If not, then leave out this option, too.
elog -h localhost -p 8080 -l Tartan+Tow+Log -n 1 -m C:text.txt
|
Andreas, thank you very much. I was able to get the stand alone function working fine on my site, including a number of add'l attributes and options (SSL, etc).
|
67100
|
Tue Aug 2 22:58:37 2011 |
| Alan Grant | netman311@mts.net | Question | Windows | 2.9.0 | Hyperlinking address to Google Maps | I have a street address attribute called Ticket Location which I would like to hyperlink to google maps so I can see a map representation of the actual value. For example, the value "654 Pembina" on the List page shoud be inserted into the url such that it displays http://maps.google.com/?q=654 Pembina, winnipeg when the browser window opens. This url works fine when I manually type it directly into the address bar, however I cannot get it to work properly as a link originating from Elog.
This is what I have done so far: I added the following to my cfg file: Change Ticket Location = <a href="http://maps.google.com/?q=$Ticket Location,%20winnipeg">$Ticket Location</a> ... but the resulting link does not end up contiguous on the single entry page, ie: <a href="http://maps.google.com/?q=72217864 Location,%20winnipeg">72217864 Location</a> .I also tried several variations in the cfg file without any better success (ie: double quotes; resorting to 1 word variable name; concatenating with +; etc).
Having this map link would be a tremendous help to our operation. Does anyone know of any way to make this work?
There's also two spin-off issues I'm having with the above approach that you may have noticed: 1) I also have another separate variable called Ticket (rep the actual ticket #) which Elog assumes I want in the url, hence the reason 72217864 shows up on the single entry opage; 2) Secondly, I prefer the single entry to retain the original value as the link (in this case, 654 Pembina), as opposed to <a href="http://maps.google.com/?q=72217864 Location,%20winnipeg">72217864 Location</a>.
Any suggestions on resolving these issues is greatly appreciated.
Alan |
67101
|
Wed Aug 3 17:55:41 2011 |
| Alan Grant | netman311@mts.net | Question | Windows | 2.9.0 | Re: Hyperlinking address to Google Maps |
Alan Grant wrote: |
I have a street address attribute called Ticket Location which I would like to hyperlink to google maps so I can see a map representation of the actual value. For example, the value "654 Pembina" on the List page shoud be inserted into the url such that it displays http://maps.google.com/?q=654 Pembina, winnipeg when the browser window opens. This url works fine when I manually type it directly into the address bar, however I cannot get it to work properly as a link originating from Elog.
This is what I have done so far: I added the following to my cfg file: Change Ticket Location = <a href="http://maps.google.com/?q=$Ticket Location,%20winnipeg">$Ticket Location</a> ... but the resulting link does not end up contiguous on the single entry page, ie: <a href="http://maps.google.com/?q=72217864 Location,%20winnipeg">72217864 Location</a> .I also tried several variations in the cfg file without any better success (ie: double quotes; resorting to 1 word variable name; concatenating with +; etc).
Having this map link would be a tremendous help to our operation. Does anyone know of any way to make this work?
There's also two spin-off issues I'm having with the above approach that you may have noticed: 1) I also have another separate variable called Ticket (rep the actual ticket #) which Elog assumes I want in the url, hence the reason 72217864 shows up on the single entry opage; 2) Secondly, I prefer the single entry to retain the original value as the link (in this case, 654 Pembina), as opposed to <a href="http://maps.google.com/?q=72217864 Location,%20winnipeg">72217864 Location</a>.
Any suggestions on resolving these issues is greatly appreciated.
Alan
|
Update: I checked through the forum some more (keying on "link" instead of "hyperlink") and found the answer to my main problem - I needed Allow HTML = 1.
So the only issue remaining is that so far I can only get it to work when I use a one word variable (please ref my point #1 in last paragraph above). When I use $Ticket Location vs just $Location, the HTML href sees it as two separate variables. Is there any way to ref $Ticket Location as a single variable in the href statement? |
67176
|
Fri Jan 27 02:26:02 2012 |
| Alan Grant | agrant@winnipeg.ca | Question | Windows | 2.9.0 | Return Code | We are using the Elog client from one vlan to insert entries into our Elog system on a different vlan.
Works fine for the most part but we occasionally have network connection issues which prevents some entries from being added, and we don't find out about it until later.
Is there a Return Code associated with the client pgm? Or some suggestion to promptly verify a successful enrty? (We'd queue and resubmit in bulk once running again, if we knew about it.)
Thanks. |
|