Date import for CMS not working (CSV)

Design help CMS
#1

Hi,

I have a csv, the format for the date follows all the guidelines yet it refuses to let me add it to any date type fields. I have 46 blog posts which i need to import and have their original publish dates. :confused:

I have checked all the help docs so am a little lost.

I can assign the other fields ok.

Thanks,
Josh

image
image

cells formatted to:
image

Date/Time Import
Import Dates & Time
#2

OMG, I figured it out. You have to switch it to American format :smiley: haha

In future iā€™d love support for english date formats

Thanks!
Josh

1 Like
#3

To ISO format :slight_smile: Which isnā€™t american as USA uses AM/PM dates.

Any format from here : https://www.w3.org/TR/NOTE-datetime

But in that form : YYYY-MM-DDThh:mm:ss.sTZD

The ZD is for timezone so if you have set your site as GMT+1 (= UTC+1) for ex, youā€™ll finish your date like this :

2017-11-08T13:00+01:00

Wjhat happens is Webfow is going to ingest your date and convert it to UTC. Then it will convert the UTC stored date into your site date, using your timezone setting. Then in the Designer, in the CMS database and on publish, it will display the computed date in the american AM/PM format.

Edit: if you need another format I made this :stuck_out_tongue: http://pardon-my-french.webflow.io/

1 Like
#4

Thanks for the more detailed reply @vincent - thatā€™s good to know re time setting!

Fortunately our blog will just be by day rather than time.

I got it to import simply with this format in the cells:

image

as this didnā€™t work:

image
image.jpg1168Ɨ248 18.8 KB

Thanks again! :slight_smile:

#5

With the slashes? Iā€™m really glad that it worked but Iā€™m surprised it did :smiley:

#6

Yep, uploaded the csv exactly like in that pic. :slight_smile:

Haha Iā€™m glad too!

#7

Can you screenshot how it is in the CMS database now? Wht time did it add to the date? The time of import?

Because when manually entering a date in the CMS, youā€™re not allowed not to add a time.

#8

Hey @vincent

It has added 12:00 am to them all

but I didnā€™t need a time with the csv import

image
image.png730Ɨ210 8.1 KB

1 Like
#9

Thanks, itā€™s just for satisfying my curiosity :slight_smile:

1 Like
#10

Curiosity killed the cat, so be careful buddy!

But happy to help anytime :slight_smile:

#11

@vincent

hey again dude. On a slight separate issue:

Why is it showing august on the block but November (correct) in sidepanel? If i go into the article it shows correctly nov 22nd but randomly august here :frowning:

Both pull data from same place but either way, its showing one thing on sidepanel and diff in editor/live on site

image
image.jpg2026Ɨ1294 330 KB

#12

November 22nd is today. Often, when displaying example of dates and time, Webflow is using the actual date and time.

#13

Fooled by a coincidence! I feel very stupid and will now delete my account

2 Likes
#14

It happened to me more than once! Sometimes I"m working with data that are indeed today, andā€¦ Iā€™m like WTF is the time not correct! :smiley:

Letā€™s classify this one in ā€œHappens to all of usā€

#15

Haha sounds good to me!

1 Like
#16

Hi,
Thanks for the info on the appropriate Date format M-D-Y (not so natural for non-american users)

Iā€™ve seen something quite weird happen when wanting to import my CSV data :
Webflow seems to remove a day to all datesā€¦ which is quite surprisingā€¦
Any idea why ?

12
Capture dā€™eĢcran 2018-01-11 aĢ€ 17.48.12.png1217Ɨ196 21.8 KB

If itā€™s a timestamp thing, I unfortunately canā€™t provide the UTC time for publishing dateā€¦ which means Iā€™ll probably have to accept the fact that my 799 article publishing dates will be 1 day wrong :disappointed_relieved:

If you have any suggestions Iā€™ll be glad to try them out :slight_smile:

1 Like
#17

wow i have exactly the same issue as you but no solutions just yet :frowning: