Neil Hunter

So i've got the writing thing going, but can't seem to get reading an xlsx file to work

 

I've tried a combination of setXlsxFilename, openExistingExcelFile, openExistingWorksheet and set CurrentRow.

 

getCellContent keeps throwing Cannot get content - Column/row not found. Guessing my source file isn't being read or setup correctly

 

Can someone paste a code snippet of the sequence of opening up a file?

Hi all,

 

I have a restful web service that I need to pull data from, connects fine with HttpSSO and reads content fine.

 

Is there a way to convert the returned JSON content into something usable or do I have to do it the long way round? I've been using the @DemoHTTPSSO for reference, and it seems to be doing it the long way

 

 

Anyone using the ProIV LDAP SSO in their organisations?

I seem to have gotten authentication working and mapping to an existing ProIV user. I cant seem to get attributes of said user like email, position, telephone no etc

I'm busy with a new request where certain conditions mean users may add, change and delete records within a Paging screen. Under other conditions, they are only allowed to change records. Is the a command like @XCODE available whereby you can set what modes are allowed before entering the cycle? 

 

My other options are allowing all modes and stopping users based on said conditions with MSG's/UMSG's and FLD jumps or creating a mirror second cycle with the different modes. Both will work but aren't the greatest of solutions 

I can't seem to find a worthwhile answer in the V7 documentation

 

Our current architecture:

 

Server A with DB A and DB B (Win 2008 R2 with SQL2008)

Server B with DB Z (Win 2008 R2 with SQL2008)

 

Is it possible to:

 

From ProIV on Server A, connect to DB Z whilst still connected to DB A and exchange data between the 2 DB's?