uShop English (U.S.) for 179!

uStorekeeper English (U.S.) for 149!

 Tech Support
       Support Policy
       Knowledge Base
       Reference Sites
       Software Piracy
       Legal Notices
       Privacy Policy
       Reseller Info
       Contact Us
       Site Map
Ureserve and E-mail

Knowledge Base Lobby : uReserve Support Conference : General Questions
Jul-18-18 10:33 AM EST
Original Message
Ureserve and E-mail
Author Brian Avis on 05-11-2001 at 16:56 (EST)

We purchased ureserve and so far have really liked it.

What we would like though is to have the system send an e-mail to the people in charge of scheduling everyday to give them a quick briefing on what is going on for the day.

Right now I have a script that that can parse thru the text data files and send an e-mail with what is scheduled. The problem is that when you schedule one resource more than once a day my script ignores all but the first reservation for that resource. Basically because you put all the reservations for that resource on a single line and my script was ready for that.

Thus we come to my question. Could you point me to the section of your perl script that parses out the data (perhaps a quick explanation on how it works) so that I don't have to kill myself trying to find that one part (or re-invent the wheel).

Any help you can provide with this would be much appreciated. Perhaps you can consider something like this for future versions??


Brian Avis.

Table Of Contents
  RE: Ureserve and E-mail Bill Weiner, 2001-05-12 13:32:44 (1)
            E-mail Brian Avis, 2001-05-14 12:44:48 (2)
  E-mail Brian Avis, 2001-05-14 17:31:55 (3)
            RE: E-mail Bill Weiner, 2001-05-14 23:57:47 (4)
                 E-mail Brian Avis, 2001-05-15 10:59:57 (5)
                 E-mail Brian Avis, 2001-05-18 18:39:04 (6)
                      RE: E-mail Bill Weiner, 2001-05-20 22:18:10 (7)

Messages In This Discussion
         1. RE: Ureserve and E-mail
        Author Bill Weiner on 05-12-2001 at 13:32 (EST)
Glad to hear the script is working out for you. In regard to sending an email.... that sounds very similar to the email feature that was added to version 2.0:

So, if you haven't downloaded the free upgrade yet, you might want to look into doing that.... And if that doesn't result in what you are looking for... then let me know and I will point you to the place in the Perl script where the data is parsed.
                 2. E-mail
                Author Brian Avis on 05-14-2001 at 12:44 (EST)
Thanks. We will check it out.
         3. E-mail
        Author Brian Avis on 05-14-2001 at 17:31 (EST)
Okay the way it looks to me is that your e-mail notification sends an e-mail to the admin and the person who made the reservation when the appt. is made.

What we want to do is to be able to send and e-mail to the admin daily. Well actually they want a group of e-mails for some reason (users... go figure).

The admin wants one big e-mail with everything scheduled for that day. As well as individual e-mails each day for each resource scheduled.

For example, they get the main e-mail that says conference room 1 is reserved, conference room 2 is reserved, and the video equipment is reserved for that day.

Then they get further e-mail for conference room 1 saying it is reserved at 12-1 and 1-2:30 and so forth. Then they can take the conference room 1 e-mail and print it out for the day and stick it on the door for the conference room in question so people know if it is reserved (like they can't check on-line.... users... go figure).

Your data files put all the scheduling information for a particular resource on a single line, at least it looks that way to me, so I just wanted to see how you were parsing that data out.

                 4. RE: E-mail
                Author Bill Weiner on 05-14-2001 at 23:57 (EST)
That's pretty custom all right. So here is some information that may help:

1) An example of how to parse an entire data file can be found in the "sub display_week_graphical" subroutine. In particular, the 7-day loop begins with the line:

for ($day_index = $sday; $day_index < $eday; $day_index++)

(If you would like to see a commented version of that subroutine, send us a support request... with your license number... and I should be able send it to you.)

2) The key to deciphering each line is to use some command like this:

@key_value_pairs = split (/ZZZ/, $current_line);

(where ZZZ is actuall a vertical bar - or pipe - it's just that this forum doesn't let me Post a pipe symbol).

... Which would basically separate all fields into separate elements in an array, such as:

$key_value_pairs[0] ... The resource name

$key_value_pairs[1] ... Reservation 1 field 1 (user's name by default)
$key_value_pairs[2] ... Reservation 1 field 2 (user's phone number by default)
$key_value_pairs[3] ... Reservation 1 field 3 (user's email by default)
$key_value_pairs[4] ... Reservation 1 field 4 (user's notes by default)
$key_value_pairs[5] ... Reservation 1 field 5 (user's password by default)
$key_value_pairs[6] ... Reservation 1 start time
$key_value_pairs[7] ... Reservation 1 end time

$key_value_pairs[8] ... Reservation 2 field 1 (user's name by default)
$key_value_pairs[9] ... Reservation 2 field 2 (user's phone number by default)
$key_value_pairs[10] ... Reservation 2 field 3 (user's email by default)
$key_value_pairs[11] ... Reservation 2 field 4 (user's notes by default)
$key_value_pairs[12] ... Reservation 2 field 5 (user's password by default)
$key_value_pairs[13] ... Reservation 2 start time
$key_value_pairs[14] ... Reservation 2 end time

$key_value_pairs[15] ... Reservation n field 1 (user's name by default)
$key_value_pairs[16] ... Reservation n field 2 (user's phone number by default)
$key_value_pairs[17] ... Reservation n field 3 (user's email by default)
$key_value_pairs[18] ... Reservation n field 4 (user's notes by default)
$key_value_pairs[19] ... Reservation n field 5 (user's password by default)
$key_value_pairs[20] ... Reservation n start time
$key_value_pairs[21] ... Reservation n end time

Does this info help?
                         5. E-mail
                        Author Brian Avis on 05-15-2001 at 10:59 (EST)
I will check out that section and see what I can come up with. May take me a while since I am also working on a Corporate service plan project that has priority.

                         6. E-mail
                        Author Brian Avis on 05-18-2001 at 18:39 (EST)
Hi Bill,

Thanks for the info, I finally got time to get that custom script working.

If you would like a copy of the script or know anyone that needs that type of functionality let me know and I would be happy to e-mail a copy of the script out.

Thanks again.

                                 7. RE: E-mail
                                Author Bill Weiner on 05-20-2001 at 22:18 (EST)
Great! Glad you got that worked out.

And thanks for the script offer. If we get any requests for similar functionality, I may be contacting you :^)

© 2003 Microburst Technologies, Inc.