PxPlus User Forum

Twitter Twitter Twitter

Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - pwhirley

Pages: [1] 2 3
Programming / Re: *obj/GoogleSheets won't open spreadsheet
« on: June 14, 2024, 10:14:29 AM »
I was finally able to create a new spreadsheet then open a test one. 

I tried again to open the original sheet I need to work with, but it still fails with no indication of the reason.

This spreadsheet was shared with me and is, therefore, not actually in my drive.  I did not think this would make a difference to the API, but I'm unable to open the shared spreadsheet.

Any suggestions?

Thanks - Phil

Programming / *obj/GoogleSheets won't open spreadsheet
« on: June 14, 2024, 09:22:46 AM »
I have successfully authenticated with Google Workspace (*obj/GoogleSheets) and I have created the sheets object.  I have successfully logged in with sheets'Login().
The scopes for my app are ../auth/drive and ../auth/spreadsheets, which should give me full read/write access to both my drive and my sheets.

When I try either sheets'OpenSpreadsheetByID(SheetID$) or sheets'OpenSpreadsheetByPath(SheetPath$) the return is zero, indicating that it was not successful.  I have tried all sorts of changes but I have no idea why it is not opening the spreadsheet

Is there any error information available that will tell me why it is failing to open my spreadsheet?  All I need to do is grab the data from a range of cells, but sheets'READ$("J1:K31") failed with an error 42, which I presume is because there is no spreadsheet open to read from.

Any help would be appreciated.  It would be great if I could trace through the logic in the GoogleSheets.pvc, but apparently I am not authorized.

Thanks - Phil

Webster Plus / Folder/Directory browsing from Webster+ page
« on: May 23, 2024, 09:28:38 AM »
In one of my file maintenance programs I need to select a folder from the SERVER to store in the record.  At this moment it is up to the user to just fill the path in, but I'd love to allow the user to browse local and network folders from the server's perspective.  I could not find a utility to allow this, but I'll be there is a way.

For the full story, the file maintenance identifies a printer and a folder.  At the user's demand the program spawns a background process which continuously monitors the folder for CSV files containing information to be printed to labels on the printer.

Any ideas for allowing the user to select a folder?

Thanks - Phil

It also never occurred to me to [execute call "myroutine",mynewvariable$].   That is a very easy way to get individual variables back on to the web page dynamically. 
Lots of options.
- Phil

This is helpful, Mike!  It did not occur to me to execute "winprt_setup" rather than executing a separate subroutine which then executes "winprt_setup".

I believe I'll implement this.


Thanks Susan!
I ended up doing something similar to get around my problem.  I created a "printers.dat" table and a query.  I execute a routine to update the printers.dat and inserted a query lookup for the Printers field on my form. 
One thing I didn't understand in your example:  In the place where I would put the delimited list of drop-down options, you just execute your little program the *memory* file.  How does Webster+ know that the contents of the memory file are to be used for the options?  Does it just know that any *memory* file contains the options or is there some other secret. 

Thanks also, Mike!
The program isn't a report but a setup definition for an automatic printing routine which will run in background.  Part of the set up is to define which label printer is to be used, so I need to present a list of the valid printers, which might well change from one day to the next.  I do save the user's choice in the profile definition file, but when the user is creating the definition, she needs to see all the available printers.  I thought I could just put the printer list in a variable built in an executed routine and pass that variable back to the Webster+ web page.  That was not working.  I'll take a look at the reports.html and *report files to see if I can see what I was doing wrong.

Thanks for the help, both of you!


Thanks Susan,

Your understanding is correct.  I have tried adding a line down where all the other hidden variables are.  it looks like this:
[hide printerList$ value=""]

That didn't work, so I also tried adding printerList$ to the _fm_panel_iol$ value, also at the bottom of the page. 

Your suggestion suggests that I'm not totally ignorant, thankfully.  I think I understand this but I'm doing something wrong.


I'm not sure how best to explain my question. I feel sure it is an easy solution but I'm tired of trying to figure it out.
I have a file maintenance page generated through the NOMADS tools.  It works just fine and I've been able to do some tweaks.  I have copied _fm_webmaint to my progs folder and modified it and all the mods work except one.  One of the fields available to edit is the selected Printer.  I have made this a drop box and intend to offer a list of the available printers ON THE SERVER.  I inserted this line within the <form>:
[execute perform "Tools;Printer_List"]
The line executes and creates a variable, printerList$ that has a delimited list of available printers.  I cannot figure out how to make that variable available on the page so that it shows up in the line below:

[row "*\[show usefile field=printer$\]:"][list printer$ usefile event=Printer_Validate]
      [data rowsep=/]printerList$[/data][/list]
   [/row]<br />[/font][/font][/size][/size]

I have tried using %webster'Update(printerList$,mynewlist$) in my program, but I cannot get any data in the variable printerList$ on the web page.

Any help would be appreciated.  It is something simple, I am certain.

Thanks - Phil

Webster Plus / Re: Password for downloaded CATS Webster+ demo
« on: May 14, 2024, 03:43:52 PM »
Thanks Jean,
I was not requesting a password for the online demo.  I downloaded the code to my local machine from https://demo.pvxplus.com/site.zip.

I chatted with Mike K. and found that the user name is "Admin" and the password is the same as the default online password.  It all works now and is very helpful.


Webster Plus / Password for downloaded CATS Webster+ demo
« on: May 13, 2024, 02:05:24 PM »
Hello All,
I have downloaded the CATS Webster+ demo application but cannot find the password.  Since I'm not terribly familiar with the PXPlus security system, yet, I have been unable to figure out how to hack it and get into the demo on my local system.

What's the user name and password for the demo system that I have downloaded?

Thanks - Phil

Programming / Re: Source code formatter
« on: May 13, 2024, 11:52:26 AM »
This is great news, Len!  Thanks for letting us know.  I will look forward to the extension and will immediately begin playing with it. 

Perhaps I'll even make it to the developer conference in September, though I can't find much information on it.


Programming / Re: Source code formatter
« on: May 02, 2024, 10:56:24 AM »
Thanks for the input.
I have not used line numbers in my code in many years, so changing line numbers doesn't bother me at all.  I also haven't used ED+ in many years, but I'll check it out and see if I can make use of it.  I really don't want to have to load individual programs to reformat them.  I would prefer to be able to process a whole folder full of source text at once.

Josh, you might want to check out the Eclipse plug-in.  Notepad++ is a good editor, but Eclipse is a full-featured integrated development environment which you can use at no cost.  With the plug-ins available (https://eclipse.sagemas.com) you get a decent editor and the ability to decompile programs, recompile with error flagging, a to-do list, very sophisticated search tool, integration to SVN or Git and much more.  You can automatically save your programs, classes and libraries to multiple locations such as a project space and a test system.

I'll let y'all know if I write something to format or if I figure out how to automate the existing ED+ tool.


Programming / Source code formatter
« on: May 01, 2024, 05:03:09 PM »
Has anyone out there written a source code formatter for PXPlus programs?  I use Eclipse with a plug-in developed and maintained by Fred McGuirk.  It does a great job of decompiling PXPlus programs into text source, but it does not attempt to do any pretty formatting.  I am considering writing a tool to do the formatting (i.e. remove LET, replace "THEN" with "{", indent IF and loop constructs, etc).  I don't want to write it if someone else has already done so.


Nomads / Re: Convert NOMADS file to XML (need IOLIST)
« on: March 14, 2024, 08:09:02 PM »
Thank you Jane!

I thought I had already replied to your post, but I don't see it.
I think the *plus/proj/pxpnl program looks promising to come up with a more readable comparison.  Thank you for the suggestion.


Nomads / Re: Convert NOMADS file to XML (need IOLIST)
« on: March 14, 2024, 09:09:29 AM »
Thanks Mike and St├ęphane,

I've written a quick and ugly XML conversion which is adequate, but I may look at the other option to make something prettier.  The way it's working now, I can easily see if the compared libraries have been changed, but identifying the changes adequately requires me to go back to NOMADS utilities.  Using the SVN utility may well work better, though it means another folder level.  However, that will help narrow down exactly where the change is, which should make things more efficient.

I know the NOMADS library IOLIST doesn't change very often, but grabbing the IOLIST from the object will insure that I get the correct columns for the version I'm working with.  That will be better.


Pages: [1] 2 3