Maximo Open Forum

 View Only

 Exclude specific columns for exporting CSV.

  • Integrations
jas condes's profile image
jas condes posted 04-30-2024 08:35

Hello,
Is there a way to exclude primary key or foreign key columns from csv file after being exported? 
For example, suppose I have three objects: INVOICE is the primary and its children are INVOICELINE and INVOICECOST. In that case, I don't want to include the primary key/foreign key "invoicelinenum" from INVOICELINE in my CSV export. Is it possible to hide or exclude it using an automation script?

Martin Fabra's profile image
Martin Fabra posted 04-30-2024 14:59

Hi @jas condes!

Yes, it's possible. 

For example, in this example, I export assets using ARS_ASSET object structure. 

In this example, someone need hide ASSETID (Column M). 

Then, in Object Structure application, I need to excep that field from the ARS_ASSET OS. To do that exclude field (open that option from contextual menu) and find ASSETID field

You set "Exclude" and save.

and when you export again, the ASSETID column will no longer be visible

You can do this exclusion for all the fields that are allowed in the structure.

Something important. This structure may also be used to import objects. You should keep in mind that you should not "exclude" a field that is used for the import.

Regards!

jas condes's profile image
jas condes posted 05-15-2024 02:22

Hi @Martin Fabra - for this I want to exclude those fields that is used as primary/foreign key. I already make other way regarding my concern, and it already worked. Thank you for answering my question I really appreciate it. :)

Related Content