Page 1 of 1 1
Topic Options
#213862 - 2020-07-04 01:04 AM UDF Library
Glenn Barnas Administrator Online   content
KiX Supporter
*****

Registered: 2003-01-28
Posts: 4323
Loc: New Jersey
It's been a while, but my UDF and apps library is back online - www.barnas.us/programming.
Items that are available include:
  • Intro to Programming Guide
  • KGen Function Linker / Script Generator
  • Entire KixLib as a single Zip file
  • The KixLib in browsable HTML format
  • The Cipher UDF - Tokenized
  • Universal Login Script
The site is a little bland - I just wanted to get the components back online first. The UDF library has been maintained and updated, and there are several new UDFs, including a URL function that supports PUT,GET,POST,PATCH, and DELETE, and can download text and binary files over HTTP or HTTPS protocols. Another new function that we use extensively for debugging is DispResult(thing) Feed it a "thing" and it figures out what it is (var, array, complex array), then reports the type of data and displays the contents. The Excel library (Lib-XL) has been updated with Save-As and Export to PDF/XPS functionality.

I have additional libraries available under license that interface with REST APIs of various products, including QuickBooks, Zen Support/Sell, and others.

Enjoy!

Glenn
_________________________
Actually I am a Rocket Scientist! \:D

Top
#213864 - 2020-07-07 11:07 AM Re: UDF Library [Re: Glenn Barnas]
Arend_ Moderator Offline
MM club member
*****

Registered: 2005-01-17
Posts: 1876
Loc: Hilversum, The Netherlands
Nice Glenn!!
Top
#213875 - 2020-07-24 10:09 PM Re: UDF Library [Re: Arend_]
NTDOC Administrator Offline
Administrator
*****

Registered: 2000-07-28
Posts: 11592
Loc: CA
Thanks for keeping up and sharing for everyone Glenn

Hope you're doing well during these trying times

Top
#213876 - 2020-07-28 01:43 PM Re: UDF Library [Re: NTDOC]
Glenn Barnas Administrator Online   content
KiX Supporter
*****

Registered: 2003-01-28
Posts: 4323
Loc: New Jersey
Thanks! Hope you and family are good as well.

Took a long time to find the time and energy to put a site back up, but we've been busy and I'm trying to force myself to have some down-time, even if it's tech in a different form. Spending time in the shop on weekends (when it's not 90+ degrees) and finally prepping the basement for a train layout.

Lots of updates in the library, and we've built some cool (but private) libraries for interfacing with APIs, including QuickBooks (thanks to Allen for pitching in!)

Glenn
_________________________
Actually I am a Rocket Scientist! \:D

Top
#213877 - 2020-08-06 11:57 PM Re: UDF Library [Re: Glenn Barnas]
Henriques Offline
Fresh Scripter

Registered: 2007-09-13
Posts: 32
Talking about the Excel-Library, there's an error in xlRangeSort() namely in line 1203 there's a variable _ExRv which is no longer dimmed and I think not even necessary in that line since it's nowhere filled.
Top
#213878 - 2020-08-07 12:42 AM (NA) Re: UDF Library [Re: Henriques]
Glenn Barnas Administrator Online   content
KiX Supporter
*****

Registered: 2003-01-28
Posts: 4323
Loc: New Jersey
The command run by the Execute statement is $_ExRv = $_ID.Worksheets...
In effect, it's an un-dimmed variable used to catch the return code of the Execute statement. Dimming it in the function is unnecessary because it isn't used, and execute isn't subject to the Explicit declaration, but a var is required in the Execute to handle the result or it will pop out somewhere.

At least that's how I remember it from some 15 or so years ago when it was first written. ;\)

I don't recall ever using that function - I'll give it a try and see what I get.

Glenn
_________________________
Actually I am a Rocket Scientist! \:D

Top
#213879 - 2020-08-07 12:59 AM (NA) Re: UDF Library [Re: Glenn Barnas]
Henriques Offline
Fresh Scripter

Registered: 2007-09-13
Posts: 32
When looking in version 1.1 you'll see that there is a dim of $_ExRv.
Top
#213880 - 2020-08-07 05:52 PM (NA) Re: UDF Library [Re: Henriques]
Glenn Barnas Administrator Online   content
KiX Supporter
*****

Registered: 2003-01-28
Posts: 4323
Loc: New Jersey
Verified that it must be dim'd. Also found a bug in xlRangeValue that fails to return data when requesting a single column. Single Row and multi-row/col work. Bug is fixed, but after a power failure this week my site is down. Unsure at this time if the firewall reverted to a prior config or the fiber router is blocking ports, but I have no inbound web or email at this time. Updates are posted and will be available once I figure out the traffic issue sometime this weekend.

Glenn
_________________________
Actually I am a Rocket Scientist! \:D

Top
#213881 - Yesterday at 08:48 PM (NA) Re: UDF Library [Re: Glenn Barnas]
Glenn Barnas Administrator Online   content
KiX Supporter
*****

Registered: 2003-01-28
Posts: 4323
Loc: New Jersey
OK - overthinking the problem - Dynamic IP changed, Dyn-DNS update failed because the provider changed their URL. All good now, and added several new and updated UDFs, as well as fixing the Lib-XL library issue that Henriques mentioned.

Glenn
_________________________
Actually I am a Rocket Scientist! \:D

Top
Page 1 of 1 1


Moderator:  Arend_, Allen, Jochen, Radimus, Glenn Barnas, ShaneEP, Ruud van Velsen, Mart 
Hop to:
Shout Box

Who's Online
0 registered and 116 anonymous users online.
Newest Members
Onsitejim, nexup3000, Luis_Ballesteros, Young, marielia
17725 Registered Users

Generated in 0.073 seconds in which 0.031 seconds were spent on a total of 13 queries. Zlib compression enabled.

Search the board with:
superb Board Search
or try with google:
Google
Web kixtart.org