Topics started by tharindukshan

9 Topics

posted in Projects Based (Contract/Resource Management, Project Management, Engineering Design & Deliverables)

Downloading a CSV file using a command button

Hi all,Here’s how you can download a CSV file by using a Command in IFS Cloud.We can easily achieve this by doing few adjustments in .client, .projection, .plsvc and .plsql files.(change in the .plsql file can be done in the .plsvc file too) It’ll look like thisAdd the command into the page that you want and click on it.It’ll get downloaded to your default download folder Here’s that downloaded CSV file Steps to achieve the above functionality .PLSQL File changeHere you’ll add a method.Basically you have to create a CLOB file > convert it to a BLOB file > return it.PROCEDURE Convert_to_Csv( csv_data_blob_ OUT BLOB)IS csv_clob_ CLOB;BEGIN csv_clob_ := 'Header 1' || ',' || 'Header 2' || ',' || 'Header 3' || ',' || 'Header 4'|| CHR(10); FOR rec_ IN 1..20 LOOP csv_clob_ := csv_clob_ || 'THRULK'||rec_ || ',' || 'THRULK'||rec_ || ',' || 'THRULK'||rec_ || ',' || 'THRULK'||rec_ || CHR(10); END LOOP; csv_data_blob_ := Utility_sys.Clob_To_Blob(cs

1 month ago

tharindukshanSidekick (Employee)

asked in Upgrades & Updates

What are the pre-requisites required to run the IFS CRIM Uplift Estimator??

Hii,I want to run the IFS CRIM Uplift Estimator but before we have to install few softwares to make it run.Any idea on the softwares that we need to install prior to running this?Softwares I’ve installed so farOracle Client 12.1.0.2 32 bit and 64 bit IFS Com Access Provider IFS Component Specification

1 year ago

tharindukshanSidekick (Employee)

asked in Document Management (DocMan)

Cannot access SharePoint documents

Hi, URL has changed when accessing anything from the SharePoint Just change this word “ifsworld” to “ifs” in the URL

1 year ago

tharindukshanSidekick (Employee)

asked in Finance (Financials)

Client not found in IFS Business Reporter

Hi,Any clue for this? 🤔 Regards,Tharindu

1 year ago

tharindukshanSidekick (Employee)

asked in Finance (Financials)

For some columns LOV dialog is not showing in Quick Reports

Hi,I have the below parameter in my quick reportAND t.tax_code = NVL('&[MC--L]STATUTORY_FEE.FEE_CODE', '%')But it is not showing the relevant LOV dialog for the above parameter For some fields it’s working fineDid I miss something here ?

2 years ago

tharindukshanSidekick (Employee)

asked in Service (Touch Apps, MWO, MRO)

Exporting data to Excel file with separate sheets for each table in Aurena

Hi,I have a requirement in Aurena to add an action which will output an Excel file with sheets.Action should be added to the parent and when clicked all the child elements should be added as sheets of that excel file and excel file should be downloaded.Any suggestions? 🤔ThanksRegards,Tharindu

2 years ago

tharindukshanSidekick (Employee)

asked in Service (Touch Apps, MWO, MRO)

How to open up an Outlook mail with attachments in Aurena

Hi,We have a requirment.We introduced a new tab in Aurena for the Purchase Order screen.In that new tab we are displaying all the attachments in Purchase Order Header, Part lines & Nopart lines (direct attachments & indirect attachments ).Now we need to create a command which open up an Outlook mail with the attachments mentioned above.We have observed the Business Activity Screen in Aurena where outlook mail is opened with some information but not loaded with attachments.Is it possible to open up an outlook mail with attachments loaded in Aurena?

3 years ago

tharindukshanSidekick (Employee)

asked in Service (Touch Apps, MWO, MRO)

How to silently print a report and check-in that to document management

Hi,I am working the purchase order screen and introduced a new command. When the user click this command a report should generate for the purchase order and automatically check-in that to document management. (Here print dialog is not opening)How to achieve this in the server side?Regards,Tharindu

3 years ago

tharindukshanSidekick (Employee)

asked in Service (Touch Apps, MWO, MRO)

How to create a .zip file from attachments in the Document Revisions screen in Aurena

Hi,I want to create a .zip file from some of the attachments in Document Revisions screen using a JAVA code and opening an Outlook mail by adding that .zip file as an attachment.Since Aurena agent only allows one file at a time, how to implement this functionality for multiple files using a JAVA code in a projection in Aurena?Any suggestions?ThanksRegards,Tharindu

3 years ago

Topics started by tharindukshan

Badges

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded