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 reply
    1
  • Answers answer
    1
  • Subscribers subscribers
    21
  • Views views
    56
  • Users 0 members are here
Related
Options

Issue with Timestamp Field in Bulk Loader

Saurav Sinha

I'm experiencing an issue when uploading an Input.csv file to Content Manager using the bulk loader. The Timestamp field in the CSV file has a different date and time when it's uploaded. For example, a timestamp like 15/11/2024 at 4:51 PM changes to 15/11/2024 at 6:51 AM after the upload.

Has anyone encountered a similar issue, and can you suggest a solution to preserve the correct timestamp during the upload process?

Thanks

Saurav

  • Suggested Answer

    0

    That sounds like a timezone issue.  Do the date values in the CSV file contain a timezone component?  If not, they are probably being interpreted as GMT/UTC time zone and  appearing as the wrong time when adjusted for display in your timezone.  Do you happen to be in UTC-10 timezone?

    Try adding the correct timezone to the datetime values before adding them through bulk loader.

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.