Keyword

Importing items from csv file Start publishing err

More
12 years 5 months ago #107296 by emma
I'm using the extension K2 Import / Export tool so that I can create items from a csv file. Delighted that all 671 items have been created - only issue is that its put some random stuff in the start publishing field so that when I set the state to published it still doesn't display (see screengrab1) If I manually go into the item and copy and paste the created date into this field all is fine. If I look at my list of K2 items I can see that editing the start publishing field now assigns author, last modified and access level properties to the item (screengrab 2)

Is there anything I can do to either stop this on import or to quickly clear out of all the items as a batch? TIA

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

More
12 years 3 months ago #107297 by mikexcite
Hi Emma,

I had the same problem, and it is maddeningly frustrating.

The solution I found was to create a column and force something to go in to the "Publish Up" field. This will then put something in that field instead of the bad text.

You must be extremely careful that whatever spreadsheet program you use (and libreoffice does handle it better than excel - i chased that problem for at least an hour) does not make the field into a date field with a different format. Go into cell formatting and override the cells to be text fields, and make sure the date is entered exactly YYYY-MM-DD HH:MM:SS or it will not work.

Disappointed in this bug, because as far as I can tell I've followed the instructions perfectly, but still a useful product at a reasonable price. Also, I beleive the creators follow this forum for tech support and so anyone who has issues should post there.

Mike

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


Powered by Kunena Forum