Streaming live at 10am (PST)

CSV import: no date mapping possible?


#1

Hi All,

I’m trying to import CSV data from Wordpress, one of the fields being the date of the post. Now I have the dates in the CSV, bur when I try to map the column, I don’t see date as an option (not even as a greyed out option) in the dropdown list.

Am I doing something wrong or is this no longer possible to do…?

Thx!


#2

The date in your CSV must be in the ISO form. It looks like this:

2017-12-04T16:05+01:00


#3

the last part, after the + account for your timezone. it must reflect the timezone setting of your site (see in site settings)


#4

@vincent Thx for helping out! I read https://university.webflow.com/article/importing-collection-items and that says:

Date/Time field - any supported date and time formats can be mapped to this field.

…which links to all these options:

Year:
YYYY (eg 1997)
Year and month:
YYYY-MM (eg 1997-07)
Complete date:
YYYY-MM-DD (eg 1997-07-16)
Complete date plus hours and minutes:
YYYY-MM-DDThh:mmTZD (eg 1997-07-16T19:20+01:00)
Complete date plus hours, minutes and seconds:
YYYY-MM-DDThh:mm:ssTZD (eg 1997-07-16T19:20:30+01:00)
Complete date plus hours, minutes, seconds and a decimal fraction of a
second
YYYY-MM-DDThh:mm:ss.sTZD (eg 1997-07-16T19:20:30.45+01:00)

…so I thought my YYYY-MM-DD would do too :slight_smile:

I also noticed that my WP exporter does something weird: it exports to 2001-Feb-Thu instead of 2001-02-08. I was stubborn enough to just give that a try, but that didn’t work of course :slight_smile:

I changed the export and the dates now read

2001-02-08T11:00+01:00

But alas, still no date option to select in the dropdown…
Screenshot at Dec 05 19-47-15

Any new suggestions?


#5

Sharing link?



#6

@vincent To the webflow installation you mean? gxjansen.webflow.io


#7

@vincent any more info you need? was that indeed the link you were looking for ?


#8

Hi Guido… Could you tell me the exporter to csv that you used?

I’m using “WP All Export” Plugin but I have some issues with date format.

Thanks in advance


#9

I actually “fixed” it by adding a date field. Since all posts have a webflow created on date I assumed it would be possible to populate that but that doesn’t seem to be an option. I manually added a date field and I was able to populate that one. I now have to manually add a date to each post but at least it works :slight_smile: