Verified Answers

If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it!  Learn more

  • State Suggested Answer
  • Replies replies
    2
  • Answers answer
    1
  • Subscribers subscribers
    10
  • Views views
    190
  • Users 0 members are here
Related
Options

Date is getting changed when importing the UNL file

Ayushi Jain

Hi Team,

I am taking the unload file of a cm3r ticket and trying to import in a lower env. When I do so, The creation date(orig.date.entered) and Last update date(sysmodtime) is taking current system date/time.

I want to import the unl file same as it was unloaded without changing any date parameter.

I have same timezone set up in both servers. I checked the system information record

Can someone pls help me on this.

  • 0

    Its bit urgent. Can someone pls suggest on this.

  • Suggested Answer

    0

    Logically, you are trying to insert a complete new change record to the DB of Lower environment system and thats normal behavior to update the creation time and sysmodtime as the current date value. You may use the RAD debugger to modify the Change Open date after importing the unload file but the sysmod time will still get updated as per design. To update both of these fields, you can modify the values of both in backend database. 

    So - import the unload and run a update scrupt in backend database to update both the fields. 

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.