DonationCoder.com Software > Finished Programs

FINISHED: Reopen file after Wifi reconnects

<< < (2/2)

wysiwyg125:
I guess we'll need to have a little more insight into the type of information, and where it originates, stored in the Excel sheet, to help you further. (With a +1 to shades' reply :))
-Ath (November 15, 2017, 01:25 AM)
--- End quote ---

Ok, here's the more detailed rundown:

The purpose of this is for people working in our production environment to easily be able to see which products/orders have been approved and released for them to begin work on.
The Source file is located on our fileserver. It is an Excel file containing a table with 5 columns: Date of approval; Product#; Product Name; Initials of who approved; Time of approval.

On the production floor, I set up a wall-mounted screen with an Intel Compute Stick. This has a locally stored Excel file, ("Dashboard"), which contains only a query to the table in the Source file. The query is set up to refresh every minute. This seemed to be the best way, using Excel, to have a near-realtime view of what was being approved, without having the "Locked for editing" message and without relying on a "cloud", internet-based solution e.g. Google Sheets. There is a mouse mounted to the wall next to the screen, so workers can scroll up and down the spreadsheet to see what has been approved.

The closest analogy I've come up with for this is an airport Departures/Arrival screen: Data gets updated by someone, and the screen shows the changes as they happen.
I used Excel because A) we have it installed already and B) People are familiar with it. It seemed like it would be the easiest way to do this at the time. I'd be happy to hear the alternatives!


Let me know if more detail is needed.

Ath:
You might give the free tier of Trello a try

skrommel:
Try ReOpen! :)

It closes a file when it becomes unavailable, and opens the file again when it becomes available.

FINISHED: Reopen file after Wifi reconnects

Download and install AutoHotkey to run the script.
Save the script as ReOpen.ahk and doubleclick to run.

Skrommel


--- ---;ReOpen.ahk
; Closes a file when it becomes unavailable, opens the file again when it becomes available
; The filename is saved to ReOpen.ini
;Skrommel @ 2017

#NoEnv
#SingleInstance,Force

Gosub,INIREAD
Gosub,GUI
Return


INIREAD:
IniRead,file,ReOpen.ini,Settings,file
If (file="ERROR")
  file=Spreadsheet.xlsx
Return


INIWRITE:
IniWrite,%file%,ReOpen.ini,Settings,file
IniWrite,%window%,ReOpen.ini,Settings,window
Return


GUI:
Gui,Add,Text,XM,File:
Gui,Add,Edit,XM Y+3 W300 Vfile,%file%
Gui,Add,Button,X+5 W50 GBROWSE,&Browse
Gui,Add,Button,XM+250 W50 GSTART,&Start
Gui,Add,Button,X+5 W50 GEXIT,E&xit
Gui,Show,,ReOpen
Return


START:
Gui,Hide
closed=1
IfWinNotExist,%title%
{
  Run,%file%,,UseErrorLevel,pid
  If (ErrorLevel=1)
    Return
  closed=0
}
Loop
{
  If closed=0
  IfNotExist,%file%
  {
    WinClose,Ahk_pid %pid%
    closed=1
  }
 
  If closed=1
  IfExist,%file%
  {
    Run,%file%,,UseErrorLevel,pid
    If (ErrorLevel=1)
      Return
    closed=0
  }
  Sleep,1000
}


BROWSE:
FileSelectFile,file,3,,Select a file,All files (*.*)
If (ErrorLevel=1)
{
  MsgBox,No file selected
  Return
}
GuiControl,,file,%file%
Return


EXIT:
Gosub,INIWRITE
ExitApp
Return

Navigation

[0] Message Index

[*] Previous page