Author Topic: Importing Date fields - when leading zeros are truncated - date no longer matche (Read 8525 times)

Bob_Lem · April 30, 2007, 09:41:31 pm

Hey,

I am attempting to load a set of records which originated in Access, are being massaged in Excel and exported as CSV files prior to the Import into CiviCRM.

It seem that the Import objects and reject the records when the leading zeros are left off of dates. e.g. it will reject 2006/11/2 but will accept 2006/11/12. And I cant seem to force the 02.

Any advice would be greatly appreciated.

CiviCRM 1.7.beta.9101

Bob Lem
Philadelphia

Michał Mach · May 01, 2007, 03:51:27 am

Did you try setting up the date format in excel to YYYY/MM/DD (in cell format settings)? I just tried it in Open Office and it seems to be working fine, adding leading 0 where needed.

Another thing that I sometimes do when OO/Excel fail to do what I need is using text format: start the contents of the cell with ' character and it should preserve the information that you put into in after it, so you can fix selected dates manually if there is not too many of them.

michau

Bob_Lem · May 02, 2007, 02:00:27 pm

Hi Michau,

Thanks! I decided to brute force it for now and convert the CSV date fields to text format using '

I could not get Excel to force a true yyy-mm-dd format. I will load OO and give tha a try for future ref.

Appreciate the help with this!

Bob Lem

CiviCRM Community Forums (archive)

News:

Author Topic: Importing Date fields - when leading zeros are truncated - date no longer matche (Read 8525 times)

Bob_Lem

Importing Date fields - when leading zeros are truncated - date no longer matche

Michał Mach

Re: Importing Date fields - when leading zeros are truncated - date no longer ma

Bob_Lem

Re: Importing Date fields - when leading zeros are truncated - date no longer matche