 |
so you can use expressions in your AOP Template
27-Nov-2023 12:35:PM by: dgielis
|
 |
{column == null ? ‘-’: column}
27-Nov-2023 12:35:PM by: dgielis
|
 |
Is there any option available in AOP to replace Null in excel report download. I can not change sql of report.
27-Nov-2023 10:55:AM by: Hocco
|
 |
Only the first header, but not the second.
22-Nov-2023 02:19:PM by: Eric Sacramento
|
 |
Hi Eric, you should be able to repeat the first x rows in Word table
22-Nov-2023 01:27:PM by: Sunil Tandan
|
 |
I don't think it's possible to do these two things that I mentioned (last week and yesterday) on AOP. :disappointed:
22-Nov-2023 01:26:PM by: Eric Sacramento
|
 |
I am attempting to repeat the header when the table continues to the other page, but what I've tried so far is not working (all combinations). Do you have any tips? Thanks.
21-Nov-2023 07:02:PM by: Eric Sacramento
|
 |
Is it possible to create two breaks on the top of the CATEGORY using this example from the AOP documentation? Or is it better to create another cursor? I am trying to do something like it, but it is not working.
`{#element|break:"continent"}*{break[*0*]*.continent *}*`
`{#element|break:"region"}`
`*{break[*0*].region}*`
`{#break}`
`{product_name}`
`{/break}`
`{/element|break:"region"}`
`{/element|break:"continent"}`
17-Nov-2023 03:19:PM by: Eric Sacramento
|
 |
When using apex_web_service.make_request I get insufficient privileges.
I feel like this can be for several reasons. I’ve found some documentation about setting up ACLs for connect and I did that.
I’m concerned that the service I’m calling requires my apex service instance ip to be put in a whitelist.
What is the safe/correct way to whitelist the oracle managed apex service instance? I assume its IP, if I can even get the current one, might change
16-Nov-2023 11:39:PM by: Jason Stortz
|
 |
Hi Martin - there is a setting to specify the time-out for PDF conversion
16-Nov-2023 03:20:PM by: dgielis
|
 |
Has anyone encountered problem with AOP 23.1.1. on premis outputing PDF?
I loaded sample word template and when processing to PDF output, the process finishes with error
```The given request took more time than allowed. Please try again with a smaller request/data, or increase the request timeout on aop_config.jsonc.```
Output to Word works just fine.
If i check Configuration PDF converter seams to be working:
```Checking for soffice headless server pdf converter.
Libreoffice headless server pdf converter is available.```
soffice version:
`LibreOffice 7.6.2.1 56f7684011345957bbf33a7ee678afaf4d2ba333`
16-Nov-2023 09:20:AM by: Martin Mirenic
|
 |
Thanks that helps
08-Nov-2023 05:59:PM by: pritham9
|
 |
Use := v(‘item’)
08-Nov-2023 05:44:PM by: dgielis
|
 |
of course :smile:
08-Nov-2023 05:35:PM by: maxime_tremblay
|
 |
And I can make it dynamic fetching it from page item values correct ?
08-Nov-2023 05:19:PM by: pritham9
|
 |
Thanks that helps
08-Nov-2023 05:19:PM by: pritham9
|
 |
aop_api_pkg.g_output_filename := ‘name’;
08-Nov-2023 05:19:PM by: dgielis
|
 |
Use the global variable in init plsql
08-Nov-2023 05:18:PM by: dgielis
|
 |
Yes
08-Nov-2023 05:18:PM by: dgielis
|
 |
Hi. How can I change AOP document output file name?
08-Nov-2023 05:09:PM by: pritham9
|
 |
I try to use the apex office edit sample app on our own server but when I start a new document the websockets kills the connection - anyone an idea?
07-Nov-2023 06:41:PM by: Andi Oberhauser
|
 |
HIi, I'm using a docx template and would like to insert a carriage return in a table cell in the source sql. I want to split a returned field into 2 rows in the output of AOP if that make sense. So select blah ||chr(13)||more_text as a_column from a_table.
02-Nov-2023 04:52:AM by: Gary Perkins
|
 |
Thx Maxime I will try after my vacation :relaxed:
27-Oct-2023 06:08:PM by: Andi Oberhauser
|
 |
it looks like you don’T have the callback defined correctly
you can have a look at the doc here: https://www.apexofficeedit.com/docs/apex/region-plugin-custom-attributes#custom-plsql-package-name
27-Oct-2023 01:10:PM by: maxime_tremblay
|
 |
I installed the Sample App and set the configuration on our environment
27-Oct-2023 01:04:PM by: Andi Oberhauser
|
 |
Hey Guys and Ladies - i want to try apex office edit on premise. But i always get this fail. Maybe somebody knows something?!
27-Oct-2023 01:03:PM by: Andi Oberhauser
|
 |
Trying to create multi-page PDFs sourced from an interactive grid with a static id of igtest. The static application file template source is the same one I was able to generate a populated PDF (only 1 page though, different issue though) using a SQL cursor query. IG has same column names as PDF template fields. It returns one PDF page without data filled in. Attached are the settings for the IG.
10-Oct-2023 11:13:PM by: Joe Kerr
|
 |
Creating populated PDFs with AOP DA + Static application file PDF template using the SQL query below (did not list all the fields for brevity). It populates and returns a single pdf page, but there are more than 20 (Note fetch first 20 rows only). Tried in development and Production AOP mode, same result. What is limiting the output to only 1 PDF page?
```Select
'file1' as "filename",
cursor(
Select
Cursor(
Select
FORM_1099_ID As "form_1099_id"
,TAX_YEAR As "tax_year"
,VOIDED As "voided"
,CORRECTED As "corrected"
,PAYERS_NAME As "payers_name"
,PAYERS_NAME_LINE2 As "payers_name_line2"
From VW_Form_1099_MISC
Fetch first 20 rows only
) as "aop_pdf_form_data"
from Dual)
as "data"
from dual;```
10-Oct-2023 08:10:PM by: Joe Kerr
|
 |
Can you send the debug json in the AOP support portal- will be easier to help you
07-Oct-2023 09:25:PM by: dgielis
|
 |
New to AOP. Uploaded fillable PDF IRS1099 template with fields named same as a view and SQL select. Using AOP DA with SQL to generate PDF per attached screenshot. AOP DA generates a fillable PDF with proper format, but no data. Tried defining view with quotes around column names and AOP DA select with quotes, didn't make a difference.
Suggestions?
07-Oct-2023 06:44:PM by: Joe Kerr
|