Target Eagle report

[Tim W-2]

Hi all,

One of our ASMs is our Eagle Scout coordinator. He wants to be able to find out which Scouts are on track to getting Eagle before 18, and which may need some gentle reminding and advice where needed.  I know about the Target Eagle report, but is there a way to output this as a CSV file so it could be loaded into a spreadsheet?

I can't find the equivalent way to export this same information under the File->Export->ASCII Delimited menu.

How do others track Scouts' path to Eagle in addition to the Target Eagle report?

Thanks.

YiS,

Tim Williams
T1518

[jmacartney]

 
In a message dated 9/3/2009 9:04:00 P.M. Eastern Daylight Time,  
tjandacw@... writes:

 
 
 
Hi all,

One of our ASMs is our Eagle Scout coordinator. He wants to  be able to
find out which Scouts are on track to getting Eagle before 18, and  which may
need some gentle reminding and advice where needed. I know about the  Target
Eagle report, but is there a way to output this as a CSV file so it  could
be loaded into a spreadsheet?

I can't find the equivalent way to  export this same information under the
File->Export->ASCII  Delimited menu.

How do others track Scouts' path to Eagle in addition  to the Target Eagle
report?

Thanks.

YiS,

Tim  Williams
T1518






I use the two advancement reports "Individual History" and "Individual  
Progress" along with a custom report that gives me the boys ages, sorted by
age.  The "Scouts not Advancing" report will give you the number of months
until the  boys turn 18.
 
YiS
Jim Macartney
T99

[Troop 322]

Tim,

 

Run the Target Eagle report as you would normally.

Then, instead of printing it, click on the little floppy icon to save it to
disk.

Choose text file (*.txt) when you save it.

You should probably choose horizontal in the report selection, too.

You can uncheck the legend box if you want.

 

Now, open up excel and go to data-->import.

From there, drill down and fine the file you just saved.

Take the defaults and import it into the spreadsheet and see if it's close
to what you are looking for.

 

Note, you may have to choose "all files (*.*)" in the import file type box
in order to see the file when you get to the directory you saved it in.

 

Chuck

 

 

Charles (Chuck) Hardee
Scoutmaster, Troop 9322
Montgomery, MN

email: Troop322@...

 

  _____  

From: TMTUG@... [mailto:TMTUG@...] On Behalf Of
tjandacw
Sent: Thursday, September 03, 2009 8:04 PM
To: TMTUG@...
Subject: [TMTUG] Target Eagle report

 

 

Hi all,

One of our ASMs is our Eagle Scout coordinator. He wants to be able to find
out which Scouts are on track to getting Eagle before 18, and which may need
some gentle reminding and advice where needed. I know about the Target Eagle
report, but is there a way to output this as a CSV file so it could be
loaded into a spreadsheet?

I can't find the equivalent way to export this same information under the
File->Export->ASCII Delimited menu.

How do others track Scouts' path to Eagle in addition to the Target Eagle
report?

Thanks.

YiS,

Tim Williams
T1518

[korchleader]

I've come to really appreciate the Individual Progress Advancement Report. Though it doesn't have all the details (like the "History" report has), I like that it gives details on the current rank that the Scout is working on, and, more importantly, gives a list of still-needed Eagle-required MBs.

Ken K.

[Tim W-2]

Thanks Chuck.

I thought about that, and tried it after I saw your reply. The problem is that when I try to delimit the columns by spaces and commas, it turns out that on Windows, TM strips out the spaces in the headers, so everything runs together. When I try this under Linux (Ubuntu+Wine), I  get columns, but now the problem becomes when there are blank columns, I can't tell which column the non-blank columns go unless I have the PDF version of the report up at the same time to compare.

It would be nice if TM had an option to output those reports that are basically tables to a CSV formatted text file.

--- In TMTUG@..., "Troop 322" <Troop322@...> wrote:

>
> Tim,
>
>  
>
> Run the Target Eagle report as you would normally.
>
> Then, instead of printing it, click on the little floppy icon to save it to
> disk.
>
> Choose text file (*.txt) when you save it.
>
> You should probably choose horizontal in the report selection, too.
>
> You can uncheck the legend box if you want.
>
>  
>
> Now, open up excel and go to data-->import.
>
> From there, drill down and fine the file you just saved.
>
> Take the defaults and import it into the spreadsheet and see if it's close
> to what you are looking for.
>
>  
>
> Note, you may have to choose "all files (*.*)" in the import file type box
> in order to see the file when you get to the directory you saved it in.
>
>  
>
> Chuck
>

[Troop 322]

Tim,

 

Just to be clear, I went Data-->Import External Data-->Import Data.

Then I drilled down and found my saved file from TM.

My excel defaulted to Fixed Width.

I clicked on Next, Next, Finish and then excel defaulted to "existing
worksheet, $a$1".

I clicked OK and then excel pasted everything into the new, blank,
worksheet.

The result was everything went in unique cells.

 

Chuck

 

Charles (Chuck) Hardee
Scoutmaster, Troop 9322
Montgomery, MN

email: Troop322@...

 

  _____  

From: TMTUG@... [mailto:TMTUG@...] On Behalf Of
tjandacw
Sent: Friday, September 04, 2009 5:23 PM
To: TMTUG@...
Subject: [TMTUG] Re: Target Eagle report

 

 

Thanks Chuck.

I thought about that, and tried it after I saw your reply. The problem is
that when I try to delimit the columns by spaces and commas, it turns out
that on Windows, TM strips out the spaces in the headers, so everything runs
together. When I try this under Linux (Ubuntu+Wine), I get columns, but now
the problem becomes when there are blank columns, I can't tell which column
the non-blank columns go unless I have the PDF version of the report up at
the same time to compare.

It would be nice if TM had an option to output those reports that are
basically tables to a CSV formatted text file.

--- In TMTUG@yahoogroups. <mailto:TMTUG%40yahoogroups.com> com, "Troop 322"
<Troop322@...> wrote:
>
> Tim,
>
>
>
> Run the Target Eagle report as you would normally.
>
> Then, instead of printing it, click on the little floppy icon to save it
to

> disk.
>
> Choose text file (*.txt) when you save it.
>
> You should probably choose horizontal in the report selection, too.
>
> You can uncheck the legend box if you want.
>
>
>
> Now, open up excel and go to data-->import.
>
> From there, drill down and fine the file you just saved.
>
> Take the defaults and import it into the spreadsheet and see if it's close
> to what you are looking for.
>
>
>
> Note, you may have to choose "all files (*.*)" in the import file type box
> in order to see the file when you get to the directory you saved it in.
>
>
>
> Chuck
>

[Tim Musson-2]

Hello tjandacw,

Thursday, September 3, 2009, 9:03:32 PM, you wrote:

> I know about the Target Eagle report, but is there a way to output
> this as a CSV file so it could be loaded into a spreadsheet?

A scripting language like Perl could take the .txt output and create a
.csv file for you...

--
Tim

[Tim W-2]

I thought about doing something in Python, but I didn't really want to put that much effort into it.  I may end up doing that though.

--- In TMTUG@..., Tim Musson <tim@...> wrote:

>
> Hello tjandacw,
>
> Thursday, September 3, 2009, 9:03:32 PM, you wrote:
>
> > I know about the Target Eagle report, but is there a way to output
> > this as a CSV file so it could be loaded into a spreadsheet?
>
> A scripting language like Perl could take the .txt output and create a
> .csv file for you...
>
> --
> Tim
>

[Tim W-2]

Chuck,

I don't have M$ Office on my machine. I use OpenOffice. When I open it as a Text CSV, I can set my delimeter to spaces, commas, tabs, etc. or I can set it to fixed width. Setting it to spaces and merging the delimeters works except for misaligning the columns. Setting it to fixed width,  I have to manually set the spacing for each column, and with the Scout's names being different widths, I can consistently split the first and last names.

This is the same on Vista or Linux. I also have an XP box with my kid's student copy of Office, but for some reason TM strips out the spaces for the column headings so I get a line like

                                SBBBBBBPRCR   SBBBBBPRCR   SBBBBBBBB  BRPCR1  
       
instead of

                         S B B B B B B P R C R   S B B B B B P R C R   S B B B B B B B B B B R P C R 1  

--- In TMTUG@..., "Troop 322" <Troop322@...> wrote:

>
> Tim,
>
>  
>
> Just to be clear, I went Data-->Import External Data-->Import Data.
>
> Then I drilled down and found my saved file from TM.
>
> My excel defaulted to Fixed Width.
>
> I clicked on Next, Next, Finish and then excel defaulted to "existing
> worksheet, $a$1".
>
> I clicked OK and then excel pasted everything into the new, blank,
> worksheet.
>
> The result was everything went in unique cells.
>
>  
>
> Chuck
>
>  
>
> Charles (Chuck) Hardee
> Scoutmaster, Troop 9322
> Montgomery, MN
>
> email: Troop322@...

[Troop 322]

Well Tim,

Unfortunately, I don't have OpenOffice installed anywhere right now.

All I have is M$ Office 2003.

So, you may have to write some intermediary processor to create your CSV
files.

If you do, I would suggest something along the lines of a REXX processor.

REXX has an extremely robust parser and with it you can parse the lines and
not have to worry about the character spacing on the line.

Good Luck,

Chuck

 

Charles (Chuck) Hardee
Scoutmaster, Troop 9322
Montgomery, MN

email: Troop322@...

 

  _____  

From: TMTUG@... [mailto:TMTUG@...] On Behalf Of
tjandacw
Sent: Friday, September 04, 2009 9:35 PM
To: TMTUG@...
Subject: [TMTUG] Re: Target Eagle report

 

 

Chuck,

I don't have M$ Office on my machine. I use OpenOffice. When I open it as a
Text CSV, I can set my delimeter to spaces, commas, tabs, etc. or I can set
it to fixed width. Setting it to spaces and merging the delimeters works
except for misaligning the columns. Setting it to fixed width, I have to
manually set the spacing for each column, and with the Scout's names being
different widths, I can consistently split the first and last names.

This is the same on Vista or Linux. I also have an XP box with my kid's
student copy of Office, but for some reason TM strips out the spaces for the
column headings so I get a line like

SBBBBBBPRCR SBBBBBPRCR SBBBBBBBB BRPCR1

instead of

S B B B B B B P R C R S B B B B B P R C R S B B B B B B B B B B R P C R 1

--- In TMTUG@yahoogroups. <mailto:TMTUG%40yahoogroups.com> com, "Troop 322"
<Troop322@...> wrote:

>
> Tim,
>
>
>
> Just to be clear, I went Data-->Import External Data-->Import Data.
>
> Then I drilled down and found my saved file from TM.
>
> My excel defaulted to Fixed Width.
>
> I clicked on Next, Next, Finish and then excel defaulted to "existing
> worksheet, $a$1".
>
> I clicked OK and then excel pasted everything into the new, blank,
> worksheet.
>
> The result was everything went in unique cells.
>
>
>
> Chuck
>
>
>
> Charles (Chuck) Hardee
> Scoutmaster, Troop 9322
> Montgomery, MN
>
> email: Troop322@...

[B Thomas]

Here's what I do every month, perhaps it will help you:

- For both TFC and TE, run the report
- Save as RTF format
- Open with Word
- Select the portion that you are interested in (generally, I remove
the empty lines first, then select everything including the headers)
- From the Microsoft Word menu bar, select Table->Convert->Text to
Table [note that this is on Word 2003, and other version may differ]
- The selected portion is now a table, and also still selected
- Edit->Copy (or Ctrl+C)
- Paste this into an Excel spreadsheet

I do a fair amount more formatting after that, but that's the main
flow item to get from TM to Excel.
Hope it helps.  I'm sure that there are many other possible
techniques.  Whatever works for you is the best.

-b

[groups-13]

Very timely discussion.  I have a scoutmaster and CC that like to see data
in a very particular series of reports that they have honed over the years.


 

The TM system does provide basic capability for creating your own reports.
Again, this is basic (think only 6 columns wide, and 3 rows deep), and lacks
the ability to create custom fields (age is expressed in years - my team
wants to see months to 18).  

 

Since TM is basically a data store for this data, is there a way to get at
the underlying data and build a series of custom reports that use the TM
data?  For instance, if the database were M$ SQL or Access, I could hit it
with Excel and build a suite of reports that meet my team's exact needs with
very little effort.  Same thing is the data structure were known.  

 

Two basic questions; has anyone done something similar, and how can I get
direct READ ONLY access to the data store?

 

Charles Johnstone

 

 

 

 

From: TMTUG@... [mailto:TMTUG@...] On Behalf Of B
Thomas
Sent: Saturday, September 05, 2009 11:08 PM
To: TMTUG@...
Subject: Re: [TMTUG] Re: Target Eagle report

 

 

Here's what I do every month, perhaps it will help you:

- For both TFC and TE, run the report
- Save as RTF format
- Open with Word
- Select the portion that you are interested in (generally, I remove
the empty lines first, then select everything including the headers)
- From the Microsoft Word menu bar, select Table->Convert->Text to
Table [note that this is on Word 2003, and other version may differ]
- The selected portion is now a table, and also still selected
- Edit->Copy (or Ctrl+C)
- Paste this into an Excel spreadsheet

I do a fair amount more formatting after that, but that's the main
flow item to get from TM to Excel.
Hope it helps. I'm sure that there are many other possible
techniques. Whatever works for you is the best.

-b

[Tim W-2]

--- In TMTUG@..., B Thomas <bjthomas3@...> wrote:

>
> Here's what I do every month, perhaps it will help you:
>
> - For both TFC and TE, run the report
> - Save as RTF format
> - Open with Word
> - Select the portion that you are interested in (generally, I remove
> the empty lines first, then select everything including the headers)
> - From the Microsoft Word menu bar, select Table->Convert->Text to
> Table [note that this is on Word 2003, and other version may differ]
> - The selected portion is now a table, and also still selected
> - Edit->Copy (or Ctrl+C)
> - Paste this into an Excel spreadsheet
>
> I do a fair amount more formatting after that, but that's the main
> flow item to get from TM to Excel.
> Hope it helps.  I'm sure that there are many other possible
> techniques.  Whatever works for you is the best.
>
> -b
>

I like this idea. I tried outputting to RTF, but when I opened it with OpenOffice, the formatting was all messed up. There may be something I can do with OpenOffice to fix this, but I need to look into it. I did something like this already with getting stats on the Activity report where I would edit out the headers and page breaks and saved the txt file as csv.  I need to go back to that file and see why this method works with the activity data, but not the TE report.

I'm starting also to lean into writing a little Python program to get the data into a csv file after a little minor editing.

Thanks.

[Troop 322]

You know, Tim, I was thinking about this a little more and I think you have
a problem that should be reported to the OpenOffice people.

If I save the report as a text file and then import it into excel as a
"fixed" report and everything goes into a unique column, then there is a
compatibility issue between OpenOffice and Micro$oft excel. As I understand
it, OpenOffice is supposed to be compatible with Micro$oft's tools and
clearly, they are not.

 

Just a thought. your call,

Chuck

 

Charles (Chuck) Hardee
Scoutmaster, Troop 9322
Montgomery, MN

email: Troop322@...

 

  _____  

From: TMTUG@... [mailto:TMTUG@...] On Behalf Of
tjandacw
Sent: Sunday, September 06, 2009 5:22 PM
To: TMTUG@...
Subject: [TMTUG] Re: Target Eagle report

 

 

--- In TMTUG@yahoogroups. <mailto:TMTUG%40yahoogroups.com> com, B Thomas
<bjthomas3@...> wrote:

>
> Here's what I do every month, perhaps it will help you:
>
> - For both TFC and TE, run the report
> - Save as RTF format
> - Open with Word
> - Select the portion that you are interested in (generally, I remove
> the empty lines first, then select everything including the headers)
> - From the Microsoft Word menu bar, select Table->Convert->Text to
> Table [note that this is on Word 2003, and other version may differ]
> - The selected portion is now a table, and also still selected
> - Edit->Copy (or Ctrl+C)
> - Paste this into an Excel spreadsheet
>
> I do a fair amount more formatting after that, but that's the main
> flow item to get from TM to Excel.
> Hope it helps. I'm sure that there are many other possible
> techniques. Whatever works for you is the best.
>
> -b
>

I like this idea. I tried outputting to RTF, but when I opened it with
OpenOffice, the formatting was all messed up. There may be something I can
do with OpenOffice to fix this, but I need to look into it. I did something
like this already with getting stats on the Activity report where I would
edit out the headers and page breaks and saved the txt file as csv. I need
to go back to that file and see why this method works with the activity
data, but not the TE report.

I'm starting also to lean into writing a little Python program to get the
data into a csv file after a little minor editing.

Thanks.

[Tim W-2]

--- In TMTUG@..., "Troop 322" <Troop322@...> wrote:

>
> You know, Tim, I was thinking about this a little more and I think you have
> a problem that should be reported to the OpenOffice people.
>
> If I save the report as a text file and then import it into excel as a
> "fixed" report and everything goes into a unique column, then there is a
> compatibility issue between OpenOffice and Micro$oft excel. As I understand
> it, OpenOffice is supposed to be compatible with Micro$oft's tools and
> clearly, they are not.
>

I found out that the formatting problem I'm having between RTF and OpnenOffice is that the tabs are all different. I set swriter to view non printing characters, and I have a tabs between the columns. Once I deleted all the default tab stops, everything moved over to the left.

OpenOffice seems to have issues in this area. I've seen others post about incorrectly formatted tables. I think it's already been submitted as a bug. Wnen I tried importing the text output as fixed width, the first column with the names is wider than the rest of the columns, so I needed to try and adjust the columns manually. Excel is probably better at this, but I still like OpenOffice's price. (And it runs on Linux.)

However, now that I know I have tabs in the RTF file, I can take bjthomas3's suggestion about converting text to a table. I tried it in Openoffice, and it works! I need to fiddle with the  headings because the report had them taking 2 rows, but I can deal with that.

[Tim W-2]

--- In TMTUG@..., <groups@...> wrote:

>
> Very timely discussion.  I have a scoutmaster and CC that like to see data
> in a very particular series of reports that they have honed over the years.
>
>
>  
>
> The TM system does provide basic capability for creating your own reports.
> Again, this is basic (think only 6 columns wide, and 3 rows deep), and lacks
> the ability to create custom fields (age is expressed in years - my team
> wants to see months to 18).  
>

The last column in the Target Eagle Report *is* months to 18.

I've seen the custom reports, but I've never used them (yet), because it seems that there's always happens to be a piece of data you want that is somewhere else. For example, the Custom report for Scouts has no data on Activities, just what's in Scout Management.  Same problem when trying to export an ASCII delimited file from the File menu.

>  
>
> Since TM is basically a data store for this data, is there a way to get at
> the underlying data and build a series of custom reports that use the TM
> data?  For instance, if the database were M$ SQL or Access, I could hit it
> with Excel and build a suite of reports that meet my team's exact needs with
> very little effort.  Same thing is the data structure were known.  
>
>  
>
> Two basic questions; has anyone done something similar, and how can I get
> direct READ ONLY access to the data store?
>
>  
>
> Charles Johnstone
>
>  

This would be great, but I have a feeling TSI wouldn't go for that. You're basically trying to get inside their database, and once you have that, you may as well set up your own MySQL database.  (If you're want to get into all that work, that is!)

[B Thomas]

On Sun, Sep 6, 2009 at 8:41 PM, tjandacw<tjandacw@...> wrote:

> However, now that I know I have tabs in the RTF file, I can take bjthomas3's
> suggestion about converting text to a table. I tried it in Openoffice, and
> it works! I need to fiddle with the headings because the report had them
> taking 2 rows, but I can deal with that.

I'm glad it was helpful.

I fiddle with lots of things.  This is just the launching point.  I
use conditional formatting to colorize the cells in TFC, separate the
name and rank into separate columns, make sure it fits on a single
page for printing, use bold lines to delineate patrols (TFC) and ranks
(which have been sorted) on TE, colorize M18 cells in TE,  etc, etc.

I end up with 3 Excel sheets in the same workbook: TFC, TE and a sheet
on all ongoing Eagle projects

I do this for the same reason that you use graphics for anything: ease
of comprehension.  The tables are intended to make it easier to
understand overall status, as well as to highlight opportunity.  While
it would be great if TM did more of this, it seems unreasonable to
expect them to have anything too specialized. It's the general nature
of what they produce that makes it possible for me to do what I want
to do with it.

-b

[groups-13]

  Anyone know how to do this?

 

The TM system does provide basic capability for creating your own reports.
Again, this is basic (think only 6 columns wide, and 3 rows deep), and lacks
the ability to create custom fields (age is expressed in years - my team
wants to see months to 18).  

 

Since TM is basically a data store for this data, is there a way to get at
the underlying data and build a series of custom reports that use the TM
data?  For instance, if the database were M$ SQL or Access, I could hit it
with Excel and build a suite of reports that meet my team's exact needs with
very little effort.  Same thing is the data structure were known.  

 

Two basic questions; has anyone done something similar, and how can I get
direct READ ONLY access to the data store?

 

Charles Johnstone

 

 

 

 

From: TMTUG@... [mailto:TMTUG@...] On Behalf Of B
Thomas
Sent: Saturday, September 05, 2009 11:08 PM
To: TMTUG@...
Subject: Re: [TMTUG] Re: Target Eagle report

 

 

Here's what I do every month, perhaps it will help you:

- For both TFC and TE, run the report
- Save as RTF format
- Open with Word
- Select the portion that you are interested in (generally, I remove
the empty lines first, then select everything including the headers)
- From the Microsoft Word menu bar, select Table->Convert->Text to
Table [note that this is on Word 2003, and other version may differ]
- The selected portion is now a table, and also still selected
- Edit->Copy (or Ctrl+C)
- Paste this into an Excel spreadsheet

I do a fair amount more formatting after that, but that's the main
flow item to get from TM to Excel.
Hope it helps. I'm sure that there are many other possible
techniques. Whatever works for you is the best.

-b




 
 

[gedmisto-2]

YES!  This is easily done.

From the main Troopmaster screen, click:
File --> Export --> ASCII delimited

In the Export Data menu you have many options.

Starting at the upper left, choose your "delimiter".
If you don't know what that is, that's the character
that separates each field of data.  You can chose
"TAB" or "Comma" delimiters.

TAB is the choice for Excel import.   You can use "comma"
if you know how to import CSV (comma separated variables)
in Excel.

Then select which dataset you want data.  This almost always
is Scout Data or Adult Data.   For this example, Choose
"Scout Data"

In each area, you will see the "fields" in the lower left.

For the purposes of this explanation, then click the
"ADD ALL" button.   Make sure the "Include field names
as the first line of export" is selected.

Later on, you can learn how to export ONLY the data fields
you want, and in the order you want them.

Optionally, you can also see the dataset file format by
clicking the "View Export Format" button.

Then click export and save the results in a file.  If you
used the "comma" delimiter, you can save it as
"filename.csv"

Using Excel, you can open that resulting file.  Excel won't know
exactly what to do with it, at first.  Choose "delimited" data
and the data fields should line up in each successive field.

Hope this helps.  I use this almost daily.

Here's one more example:
Say you want to know the age of your scouts, in detail.

Assume you had a list of Scout's data and their birthdate
is listed in your excel file in column A.  In cell B2, enter
the formula below.

If "today" is 9/10/2009 and the birthdate is 2/14/1995, then
the formula below will output "14y 11m 8d".
If you save the file away, and open it tomorrow it will reevaluate
and the Scout data will be one day "older".   Pretty nice report,
especially when tracking "Time to 18 years".

=DATEDIF(A2,TODAY(),"y")&"y "&DATEDIF(A2,TODAY(),"ym")&"m "&DATEDIF(A2,TODAY(),"md")&"d"

NOTE: DATADIF is an unsupported, undocumented Excel function.

Have fun with your data!



--- In TMTUG@..., <groups@...> wrote:

>
>   Anyone know how to do this?
>
>  
>
> The TM system does provide basic capability for creating your own reports.
> Again, this is basic (think only 6 columns wide, and 3 rows deep), and lacks
> the ability to create custom fields (age is expressed in years - my team
> wants to see months to 18).  
>
>  
>
> Since TM is basically a data store for this data, is there a way to get at
> the underlying data and build a series of custom reports that use the TM
> data?  For instance, if the database were M$ SQL or Access, I could hit it
> with Excel and build a suite of reports that meet my team's exact needs with
> very little effort.  Same thing is the data structure were known.  
>
>  
>
> Two basic questions; has anyone done something similar, and how can I get
> direct READ ONLY access to the data store?
>
>  
>
> Charles Johnstone
>
>  

[groups-13]

EXCELLENT.  I had been fixating on getting INTO TM and hadn't thought about
getting data OUT of TM.  

 

Thank you, that's just the path I'll try.

 

CJ

 

 

 

From: TMTUG@... [mailto:TMTUG@...] On Behalf Of
gedmisto
Sent: Thursday, September 10, 2009 10:01 AM
To: TMTUG@...
Subject: Link to the TM Data Structure Directly - WAS RE: [TMTUG] Re: Target
Eagle report

 

 

YES! This is easily done.

From the main Troopmaster screen, click:
File --> Export --> ASCII delimited

In the Export Data menu you have many options.

Starting at the upper left, choose your "delimiter".
If you don't know what that is, that's the character
that separates each field of data. You can chose
"TAB" or "Comma" delimiters.

TAB is the choice for Excel import. You can use "comma"
if you know how to import CSV (comma separated variables)
in Excel.

Then select which dataset you want data. This almost always
is Scout Data or Adult Data. For this example, Choose
"Scout Data"

In each area, you will see the "fields" in the lower left.

For the purposes of this explanation, then click the
"ADD ALL" button. Make sure the "Include field names
as the first line of export" is selected.

Later on, you can learn how to export ONLY the data fields
you want, and in the order you want them.

Optionally, you can also see the dataset file format by
clicking the "View Export Format" button.

Then click export and save the results in a file. If you
used the "comma" delimiter, you can save it as
"filename.csv"

Using Excel, you can open that resulting file. Excel won't know
exactly what to do with it, at first. Choose "delimited" data
and the data fields should line up in each successive field.

Hope this helps. I use this almost daily.

Here's one more example:
Say you want to know the age of your scouts, in detail.

Assume you had a list of Scout's data and their birthdate
is listed in your excel file in column A. In cell B2, enter
the formula below.

If "today" is 9/10/2009 and the birthdate is 2/14/1995, then
the formula below will output "14y 11m 8d".
If you save the file away, and open it tomorrow it will reevaluate
and the Scout data will be one day "older". Pretty nice report,
especially when tracking "Time to 18 years".

=DATEDIF(A2,TODAY(),"y")&"y "&DATEDIF(A2,TODAY(),"ym")&"m
"&DATEDIF(A2,TODAY(),"md")&"d"

NOTE: DATADIF is an unsupported, undocumented Excel function.

Have fun with your data!

--- In TMTUG@... <mailto:TMTUG%40yahoogroups.com> , <groups@...>
wrote:
>
> Anyone know how to do this?
>
>
>
> The TM system does provide basic capability for creating your own reports.
> Again, this is basic (think only 6 columns wide, and 3 rows deep), and
lacks
> the ability to create custom fields (age is expressed in years - my team
> wants to see months to 18).
>
>
>
> Since TM is basically a data store for this data, is there a way to get at
> the underlying data and build a series of custom reports that use the TM
> data? For instance, if the database were M$ SQL or Access, I could hit it
> with Excel and build a suite of reports that meet my team's exact needs
with

> very little effort. Same thing is the data structure were known.
>
>
>
> Two basic questions; has anyone done something similar, and how can I get
> direct READ ONLY access to the data store?
>
>
>
> Charles Johnstone
>
>