[BaseCamp] Can I Copy/Paste Route "Properties" ?

[saddle sore]

Greg and Troy
Thanks for this info!!  I also have wanted to be able to create such a
spreadsheet but have been doing them manually since I couldn't figure out
how to have BC do it.  I just ran a test, with mixed results for the column
containing th date and Zulu time.   It appears that the date and Zulu time
are tied to the time and date that the waypoint was created, not tied to
the arrival time stated in my route.   So I'm curious, did you guys see
accurate date and Zulu times in your exported csv spreadsheet?    So I'm
still scratching my head on this one.
Joe Y
western PA





On Thu, Feb 11, 2016 at 10:03 AM, Troy Martin <qikslvr1 at gmail.com> wrote:

> Thanks Greg, that's a good way.
>
> I just tested it out and yeah, the information is there for only the ones I
> had "arrival time" checked. Interestingly though it gave me the times in
> Zulu time (GMT) rather than the zone I have it in BC. Like you said though,
> that's easily remedied.
>
> I can handle all the excel stuff, but if I have anymore questions about
> this method or need to bounce an idea off someone I'll let you know.
>
> Thank you,
> Troy
> On Feb 11, 2016 8:54 AM, "Greg Horodeck" <greghoro at gmail.com> wrote:
>
> > Perhaps you can get the information you want by exporting the route to a
> > csv
> > file. In Windows, make sure your route is selected, go to the File menu,
> > choose Export, Export Selection, tell it where you want the exported file
> > put and specify csv as the type to be saved.
> >
> > The data you want is all there. It may not be exactly in the form you
> want
> > but if you know Excel, you should be able to manipulate the data to put
> it
> > in the form you want. Certainly a macro could be created to automate the
> > isolation and reformatting of the data (I can provide help). Note, you
> will
> > need to make sure that for each waypoint in the route, you explicitly
> check
> > the Arrival and/or the Departure box. Waypoints with unchecked boxes will
> > not export Arrival/Departure information.
> >
> > Look in the rtept section of the exported file for the data you want.
> >
> > The date and time will be concatenated together in one cell and it is
> > expressed in Zulu time, not local time for the waypoint. Which may be a
> > positive, keeping a rally clock on Zulu and not having to do possible
> error
> > prone calculations to convert to local time.
> >
> >
> > Greg
> >
> > -----Original Message-----
> > From: Basecamp [mailto:basecamp-bounces at micapeak.com] On Behalf Of Troy
> > Martin
> > Sent: Wednesday, February 10, 2016 10:36 PM
> > To: BaseCamp
> > Subject: [BaseCamp] Can I Copy/Paste Route "Properties" ?
> >
> > Hi all, not sure I'm doing this right so feel free to flog me properly
> for
> > any mistakes I make.
> >
> > I'm just getting into using BC (still prefer S&T, but starting to come
> > around) and I was wondering if there's any way to copy the information
> from
> > a route "Properties" tab to say a word document or text file for
> printing.
> >
> > What I want is my "rundown" sheet which has the bonus code in the order
> of
> > collection and the arrival time at that bonus, but I don't want all the
> > turn
> > directions. When I try to copy the data it selects all the information
> in a
> > single box, but when I paste it I only get the code, and not anything
> else.
> > At a minimum I need the code and arrival time .
> >
> > I'm sure I'll have more questions in the coming months, but you BC
> > die-hards
> > will be happy to hear I am actually starting to like BC. It's still
> missing
> > a few things IMHO but I am working to find ways around that.
> >
> > --
> > Thanks,
> > Troy Martin
> >
> > To make _ANY_ changes, including unsubscribing from this list, click
> > ----->http://micapeak.com/mailman/listinfo/basecamp
> >
> >
> > To make _ANY_ changes, including unsubscribing from this list, click
> ----->
> > http://micapeak.com/mailman/listinfo/basecamp
> >
> >
>
> To make _ANY_ changes, including unsubscribing from this list, click ----->
> http://micapeak.com/mailman/listinfo/basecamp
>
>