× Help Forum English

import event date format to convert

Start
Prev
1
Next
End

freddie24
Topic Author
New Member

9 years 8 months ago - 9 years 6 months ago #7850 by freddie24

import event date format to convert was created by freddie24

Hello everyone,

I imported about 500 events from an old database to the database of iCagenda.

all are seen perfectly in the backend, but the site NO.

The problem is in the date format.

iCagenda want the date in the format: a: 1: {i: 0; s: 16: "22/08/2014 00:00";}

how can I convert my date
from 22/08/2014 to a: 1: {i: 0; s: 16: "22/08/2014 00:00";} ???

Thank you!

Last edit: 9 years 6 months ago by Lyr!C.

Please Log in or Create an account to join the conversation.

giusebos
Moderator

9 years 8 months ago #7852 by giusebos

Replied by giusebos on topic import event date format to convert

how did you convert the events?

HAI BISOGNO DI ASSISTENZA?
leggi qui

Guarda tutti i video tutorial di iCagenda
Watch all video tutorials iCagenda
Regardez toutes les vidéos tutoriels iCagenda
Ver todos los videos tutoriales iCagenda

guarda qui

Please Log in or Create an account to join the conversation.

freddie24
Topic Author
New Member

9 years 8 months ago #7853 by freddie24

Replied by freddie24 on topic import event date format to convert

with phpmyadmin ... in CVS Excel

Please Log in or Create an account to join the conversation.

Lyr!C
Administrator
Lead Developer

9 years 7 months ago #7981 by Lyr!C

Replied by Lyr!C on topic import event date format to convert

Hello,

Today, the dates for an event (single date) are serialize using this php function.

So, in data, a date such as 22/08/2014 should become in date like this :

22/08/2014

will become this :

a:1:{i:0;s:16:"2014-08-22 00:00";}

Note the date format, is database internationnal datetime format YYYY-MM-DD HH-MM

Hope this helps!

Cyril

Latest version : iCagenda 3.9.3
We recommend every user to keep iCagenda updated.
Don't forget to have your Joomla!™ up-to-date!

Do you like iCagenda?
I would appreciate if you could take 5 minutes to post a review on JED (Joomla Extensions Directory) .

Please Log in or Create an account to join the conversation.

Start
Prev
1
Next
End

Moderators: Lyr!C

Time to create page: 0.210 seconds

Forum

import event date format to convert

Legal

Follow Us