1. John Vanleeuwe
  2. PowerBuilder
  3. Wednesday, 24 January 2018 06:20 AM UTC

Hi all,

First of i would like to thank the Appeon team for delivering PB2017 without any ( in our case ) bugs ! The migration process was easy and straightforward. After many years of being in the PB dark tunnel, we can finally see light again at the end of it !!

 

Second , we are wondering if following functionalities , which we believe are not possible at the moment, can be integrated/possible in the future ?

 

1. importfile based on an excel file , at the moment importfile doesn't accept .xls extensions ? Seems to me a pretty basic feauture or am i missing something here ?

2. new native save as PDF , this works great in PB2017! , but we would like to have the possibility to have multiple dw's saved into 1 pdf ?

 

Thanks in advance & kindest regards

 

 

John

Accepted Answer
Marco Meoni Accepted Answer Pending Moderation
  1. Wednesday, 24 January 2018 07:17 AM UTC
  2. PowerBuilder
  3. # Permalink

Hi John,

I cannot answer on Appeon roadmap about question #2, but I can give you a couple of workarounds for Excel import.

1) you can define an ODBC connection to the Excel spreadsheet (no manual configuration on the client machines, make it "DSN-less" with just a few settings in the Win registry), and treat it just like a database. A single dw_1.Retrieve() and the spreadsheet will be loaded into your DW

2) you can use olebject to scan and parse the spreadsheet, something like the mockup code here below:

lole_excel.ConnectToNewObject("excel.application")
lole_excel.WorkBooks.Open("temp.xls") 
lole_workbook = lole_excel.application.workbooks(1)
lole_worksheet = lole_workbook.worksheets(1)
ll_rows     = lole_worksheet.UsedRange.Rows.Count
ll_columns  = lole_worksheet.UsedRange.Columns.Count
// scan rows and columns

My 2 cents.
Cheers,
.m

Comment
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 24 January 2018 13:56 PM UTC
  2. PowerBuilder
  3. # 1

Hi John;

   Great suggestion on the ability to merge PDF files into one PDF! I believe that Engineering already has that on their enhancement list. In the meantime, I have been doing this for over a decade in my PB Apps using the free PDF Toolkit software. There are also many other PDF utilities out there that can help you do this as well.

HTH

Regards ... Chris

Comment
  1. Tobias Roth
  2. Thursday, 25 January 2018 16:36 PM UTC
Hi Chris,



Would be really nice to have the ability to merge PDF files soon.

So you wouldn't need any additional software for complex reports.



Regards Tobi

  1. Helpful
There are no comments made yet.
Roland Smith Accepted Answer Pending Moderation
  1. Wednesday, 24 January 2018 12:30 PM UTC
  2. PowerBuilder
  3. # 2

My biggest issue with the Native PDF is that it is slower than Ghostscript.

Comment
  1. Chris Pollach @Appeon
  2. Wednesday, 24 January 2018 13:53 PM UTC
Hi Roland;



  FYI:  NativePDF improvements coming in the new PB 2017 R2 release next week.



Regards ... Chris

  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.