1. John Vanleeuwe
  2. PowerBuilder
  3. Wednesday, 24 January 2018

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
0
Votes
Undo

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.
  1. Wednesday, 24 January 2018
  2. PowerBuilder
  3. # Permalink
Chris Pollach Accepted Answer Pending Moderation
0
Votes
Undo

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
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. Tobias Roth
  2. Thursday, 25 January 2018
There are no comments made yet.
  1. Wednesday, 24 January 2018
  2. PowerBuilder
  3. # 1
Roland Smith Accepted Answer Pending Moderation
0
Votes
Undo

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

Comment
Hi Roland;



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



Regards ... Chris

  1. Chris Pollach
  2. Wednesday, 24 January 2018
There are no comments made yet.
  1. Wednesday, 24 January 2018
  2. PowerBuilder
  3. # 2
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.