Welcome Serena Central users! CLICK HERE
The migration of the Serena Central community is currently underway. Be sure to read THIS MESSAGE to get your new login set up to access your account.
Highlighted
Yuri Prado Super Contributor.
Super Contributor.
751 views

Removing "Date Closed" dates from records using TRIMport Tool

Jump to solution

Hi,

 

I was wondering if there was a way to remove the date closed on containers (bulk update) using the TRIMport tool.  I had a look at the TRIMport help files but there seems to be no information regarding removing closed date field.

 

Any help will be much appreciated.

 

Cheers,

 

Yuri

0 Likes
1 Solution

Accepted Solutions
Chris Mcklaren Absent Member.
Absent Member.

Re: Removing "Date Closed" dates from records using TRIMport Tool

Jump to solution

Hi Yuri,

 

I'm uncertain if this will work so please try in a test environment first.

 

When using the COM SDK in TRIM 6R2 with MS Excel I was able to use a date value that resulted in a blank date in TRIM. Now this applied to Additional Fields formatted as a Date, so I'm uncertain if it will work with Date Closed.

 

Try either 01/01/1900 or 31/12/1899.

 

Good Luck!

 

Chris Mcklaren

Cheers,
Chris Mcklaren
4 Replies
Grundy Acclaimed Contributor.
Acclaimed Contributor.

Re: Removing "Date Closed" dates from records using TRIMport Tool

Jump to solution

TRIMPort doesn't remove anything.

 

You can add data but you cant remove it.

Importing empty fields will do nothing.

 

Alternatively, you can import the Date Closed field but set it to something like year 2020.

It wont remove it, but the records will remain open for now.



::::::::::::::::::::::
NOT A HP EMPLOYEE
::::::::::::::::::::::

INFORMOTION.com.au
0 Likes
Chris Mcklaren Absent Member.
Absent Member.

Re: Removing "Date Closed" dates from records using TRIMport Tool

Jump to solution

Hi Yuri,

 

I'm uncertain if this will work so please try in a test environment first.

 

When using the COM SDK in TRIM 6R2 with MS Excel I was able to use a date value that resulted in a blank date in TRIM. Now this applied to Additional Fields formatted as a Date, so I'm uncertain if it will work with Date Closed.

 

Try either 01/01/1900 or 31/12/1899.

 

Good Luck!

 

Chris Mcklaren

Cheers,
Chris Mcklaren
Yuri Prado Super Contributor.
Super Contributor.

Re: Removing "Date Closed" dates from records using TRIMport Tool

Jump to solution

Thanks so much Chris. The 1899 trick worked.


@Chris Mcklaren wrote:

 

Try either 01/01/1900 or 31/12/1899.

 

Good Luck!

 

Chris Mcklaren


 

0 Likes
Grundy Acclaimed Contributor.
Acclaimed Contributor.

Re: Removing "Date Closed" dates from records using TRIMport Tool

Jump to solution

Ha, cool trick Chris, I'll try to remember that one! 🙂



::::::::::::::::::::::
NOT A HP EMPLOYEE
::::::::::::::::::::::

INFORMOTION.com.au
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.