Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

Welcome to the CollectiveAccess support forum! Here the developers and community answer questions related to use of the software. Please include the following information in every new issue posted here:

  1. Version of the software that is used, along with browser and version

  2. If the issue pertains to Providence, Pawtucket or both

  3. What steps you’ve taken to try to resolve the issue

  4. Screenshots demonstrating the issue

  5. The relevant sections of your installation profile or configuration including the codes and settings defined for your local elements.


If your question pertains to data import or export, please also include:

  1. Data sample

  2. Your mapping


Answers may be delayed for posts that do not include sufficient information.

Data Import - Excel date format

Whenever I run a data import from an Excel data file, any fields that are formatted as Excel dates are entered as the day before into CollectiveAccess. For example, a date that is formatted in the Excel spreadsheet as "2017-05-11" is entered into a CollectiveAccess object as "May 10, 2017 at 20:00". This happens consistently no matter what date is entered. However, this does not happen when the date is added in the CollectiveAccess user interface. In addition, when the data type of the date field is changed in Excel from "Date" to "Text", the date imports correctly. We are trying to create a bulk import workflow and template, and we would like to store these dates as Excel dates, in order to take advantage of the date validation functions in Excel.

Any idea what could be causing this?

Comments

  • This is a known issue with how Excel formats dates. You can either copy the date column into a program such as text edit and paste it back into the data source, or you can change your server date config to: set date_default_timezone_set('Europe/London'); in setup.php and that will resolve the date shift.

  • Thanks. I'll convert the dates to text in Excel.

Sign In or Register to comment.