Monday, February 15, 2010

Version 1.2.4 Released!

Changes to Literature Room Organizer include:

  • Added: Language to top of Mock S-28 form
  • Added: "Reset Filter" on all new filter screens.
  • Updated: Help info for Publisher Search asterisk
  • Changed: Request Month is no longer editable by default. Must click on "Allow Editing" to be able to change it.
  • Fixed: Item Name choices are populated after changing Item Number (if visible)
  • Fixed: Tab order on View All Orders, Pending Items, Orders by Publisher
  • Fixed: LRO adjusts date of order (if needed) when changing Request Month. Only orders for previous years are updated to be current year when Request Month is changed.
  • Fixed: Marking all orders as Received/Delivered when Inventory Automation is on will go faster and no longer flash/scroll through all records. Will now see an hourglass (or Vista/7 busy mouse) symbol and screen will refresh ONLY when it is finished.

I realized something about Request Month now that we are in a new year.  If you take an old order (perhaps because you ran out of that item) and re-submit it for the current order (simply by changing the Request Month date, and removing the mark from Ordered), it will show up as an order from last year on the month you selected.  So I put a fix that will update the date attached to an order if you change the Request Month on an older order.  It will prompt you before making the change to the date though, of course.

I also turned off the ability to change the Request Month by default.  When I first introduced the feature, I had it editable all the time so everyone could update the orders with a Request Month.  Now it is uneditable by default, but you can click "Allow Editing" to edit it, just like everything else.

Last but not least...we are remodeling our Kingdom Hall.  This means that I've got a VERY BUSY month coming up, as I take care of more than the usual congregational responsibilities.  Therefore the next update, which will be the addition of the Russian language, will be the last for about a month.  I hope to have this update by this weekend.  If anyone discovers any bugs, or has a QUICK change request, please submit it soon.

Thanks! :-)

PS - Screenshots are updated and available!

Saturday, February 13, 2010

New site design!

Hope you all like the new site design and colors! There's a new poll (on the right) where you can voice your opinion.

Seems that FreeWebHosts deletes accounts that have inactive Screenshots are gone! Will try to get them back up (along with v1.2.4) tomorrow! They needed to be updated anyways...

Wednesday, February 10, 2010

S-28 Form for Spanish users

Howdy all!

I have received a copy of the S-28 form in Spanish.  Spanish users can now download it and update their Mock S-28 Form.  To do this, please go to "Manejo del Inventario" -> "Constr. Form.
Simula. S-28" -> "Descargar Actualizaciones al S-28".

NOTE: This does NOT affect English users, only those who downloaded the Spanish version of LRO.

Thanks to brother Gus for providing the form, and thanks to brother Jorge for putting together the text into the spreadsheet for me!  :-)

On a different note...English users, you may want to delete items #9826 & 9830 from the "Literature Items List" screen.  During our Spanish translation, these items were discovered to be extraneous.  I could not find them in the Watchtower Publications listing either.  I'm not going to write a "delete" routine...I don't want to be deleting things out of your data.  So I'm telling you here that these two "sample" items don't appear to exist anymore and can be deleted.

Saturday, February 6, 2010

Version 1.2.3 Released!

Changes to Literature Room Organizer include:

  • Improved Feature: Filtering ability on all order management screen can now filter multiple columns at the same time.  See the new blue bar above the orders.
  • Added: "Total Items Shown", on all order management screens, you will see a sum of all the items in the orders displayed.
  • Added: "Type of Item" to the View All Orders screen.
  • Improved: LRO now closes MUCH faster! Rather than exporting your data (the tables) in order to "survive" updates, LRO now just makes a copy of itself (the entire program). Amazingly, that works MUCH faster than exporting each table.  Go figure! :-P
  • Improved: Deliverable Items report is now in portrait mode.
  • Changed: LRO now shows you the whole publisher list on the Order Form screen, regardless whether the publisher has an order or not. The asterisk next to their name means they are waiting on an order.
  • Fixed: Inventory management will start at the beginning of the last inventory period...if there is no data for Inventory Management yet.  So if there is no data, you will see the Inventory Management start in September or March, whichever was the last.
  • Fixed: Mock S-28 form now separates items by language instead of adding all the languages together.
  • Fixed: LRO will only Compact & Repair when it reaches 10 MB in size. Thus speeding up exiting on slower machines or when run from a flash drive. Theoretically, it should not reach this size until after 1-2 years of usage.
  • BUG FIX: Automatic & Manual backups would report a failure, even though it was actually successful.

Yes indeed, LRO closes MUCH faster now!  It is amazing the difference...depending on the speed of your computer, it may even be less than a second.  For those who have slower computers, or are running it off of a flash drive, it may still be slow, possibly around 8 seconds.  So you will notice the progress bar still appears, but on the super-fast just appears & then disappears. This is long as you don't get any error messages, everything is fine. :-)

I have received a copy of the S-28 form in Spanish.  I will be working on this, and will hopefully have an update available to the Spanish users in a few days.  Will let you all know when it is available.

I hope you all enjoy the new filter system & the new "Total Items Shown" counter at the bottom.  I know I could have used both of these when I was checking in our last shipment (it was my first experience)!  ;-)

Friday, February 5, 2010

Calling all Spanish brothers - Need S-28 form

Howdy all!

I am still searching for a Spanish version of the S-28 form.  Spanish users will notice that the mock S-28 form still has all the items in English.  While we could translate each item individually, if the S-28 form in Spanish has a different order of its categories and items, it would not be as easy to transfer the data from the Mock form onto the real form.  Therefore it is necessary to get a Spanish S-28 form to accurately recreate how it looks.

If any of you Spanish brothers can get a hold of the S-28 form, please send it to me via e-mail ( so I can update the Mock S-28 form for Spanish users.  :-)

Also, I was informed that the S-28 form should only display a single language, not combine literature from other languages.  So the next update will allow you to select the language to display on the report, based on the languages of the items you've entered.  I will allow you to leave this option blank in order to combine the languages, just in case it is applicable to you situation.