2017 R2: option to retain form dropdown selections

Hello

I have a small basic script stored in my form that writes this data into a text file in the public folder and opens it again as soon as the form is opened, in order to then fill the fields with the last entries, including the dropdown menus.

In the PC-DMIS form editor there are event handlers for the form itself. There you will find "EventInitialize" and "EventTerminate". You can write in these that the current entries should be saved in a text file or read from it.

The programming language is Basic, though. Works pretty well, I think.

If you want, I can give you the code and show you exactly where it has to be inserted. But I need the "names" of the text fields and combo boxes from the properties menu of the PC-DMIS form editor

Hello Henniger123, thanks for your reply. Below are the form fields and the names of their objects. I am familiar with "EventInitialize" and "EventTerminate," but I could not figure out how to get them working. I appreciate your help with this.

I'll write something together next week, please give me some time

Do you want to read data from another excel sheet or?

Hello, please make a backup beforehand

you can edit the form events by double-clicking on the empty field to the right of the event name in the properties window

insert the following code into the "EventInitialize" event of your Form(View):

  On Error Resume Next

  ' Dim Something
    Dim sPath As String
    Dim strLine As String

  ' path
    sPath = "C:\Users\Public\Documents\" & "pcDMIS_LastFormEntrys.txt"

  ' open file
    Open sPath For Input As #1
    
  ' read line(s)
    Line Input #1, strLine
    strLine = Trim(strLine)
    customerlist.Selection = CDbl(strLine)
    
    Line Input #1, strLine
    strLine = Trim(strLine)
    thicknessbox.Text = CStr(strLine)
    
    Line Input #1, strLine
    strLine = Trim(strLine)
    materiallist.Selection = CDbl(strLine)
    
    Line Input #1, strLine
    strLine = Trim(strLine)
    cutlist.Selection = CDbl(strLine)
    
    Line Input #1, strLine
    strLine = Trim(strLine)
    jobbox.Text = CStr(strLine)
    
    Line Input #1, strLine
    strLine = Trim(strLine)
    serialbox.Text = CStr(strLine)

    
    Line Input #1, strLine
    strLine = Trim(strLine)
    firingbox.Text = CStr(strLine)
    
  ' close file
    Close #1

insert the following code into the "EventTerminate" event of your Form(View):

  On Error Resume Next
  
  ' Dim Something
    Dim sPath As String
    Dim strLine As String

  ' path
    sPath = "C:\Users\Public\Documents\" & "pcDMIS_LastFormEntrys.txt"

  ' open file
    Open sPath For Output As #2
    
  ' write line(s)
    Print #2, Str(customerlist.Selection)
    Print #2, thicknessbox.Text
    Print #2, Str(materiallist.Selection)
    Print #2, Str(cutlist.Selection)
    Print #2, jobbox.Text
    Print #2, serialbox.Text
    Print #2, firingbox.Text

  ' close file
    Close #2

Everything worked in my test.
(the path specified in the code must have write permissions)

you can also create the path dynamically based on the current measurement program, then the form always has the last entry for each program, but that also creates tons of txt files

Thank you so much for putting this together for me. It is successfully outputting and inputting, but it is adding extra returns after every repetition. I cannot see the returns in PC-DMIS. I illustrated them in the TXT output (first image), and it is affecting my CSV outputs (second image).

I'm trying to read through this and see what jumps out at me for why there is returns, but I can't tell at the moment. Are you adding spaces or returns in your input commands?

I know this is already working for you, and you just have a small hiccup, but could you also use a method similar to this one I shared here?

https://nexus.hexagon.com/community/public/pc-dmis/f/pc-dmis-for-cmms/139275/export-generic-txt-not-showing-all-dimensions-pc-dmis-2022-1/810989

I am not hitting the enter key while filling out the form. There are no spaces being entered either and I think the Trim commands during the Initialize stage would remove any that were entered.

I would like to avoid touching the exporting of the results section. The program has been successfully exporting and uploading to our database for a couple months and I do not want to risk breaking that as I am not on-site to troubleshoot. Thanks for the suggestion.

No worries there, I understand where you're coming from. So I was researching this, and I was using Trim, LTrim, and RTrim to see if PC-DMIS would remove spaces in my comment, and it is not. I may have a typo somewhere, but it is keeping all my spaces.

This comes from the "Line Input" where a line return is automatically added. I think there was another command that doesn't do this. I have to look for it a bit