Skip to main content
Best Answer

Import certification records via csv

aswartz
Helper I
Forum|alt.badge.img

Hi all, I’m pulling my hair out here. I am trying to import certification records from our old LMS into Docebo. I have been following the directions in the knowledge base and the field formatting outlined here: https://www.docebo.com/wp-content/uploads/2015/04/Certification-Data-Fields-Certification-Data-Fields-ENG.pdf

Despite the date format clearly being YYYY-MM-DD as required as you can see on the import screenshot below as well if you open the csv file in notepad I still get the error: “Invalid parameter: issue_date”.

Can anyone spot what I’m doing wrong?

Many thanks,

Aimee

Best answer by avega

Hi Aimee,

 

There is a space in the date field before the year.

View original
Did this post help you find an answer to your question?

4 replies

A
Novice II
  • avega
  • Novice II
  • 7 replies
  • Answer
  • June 6, 2022

Hi Aimee,

 

There is a space in the date field before the year.

ABNER VEGA Senior Consultant, Professional Services o: 800-434-6418 eSkillz.com
aswartz
1 person likes this
  • aswartz
    aswartz
TaiSaxty
Helper I
  • TaiSaxty
  • Helper I
  • 54 replies
  • June 6, 2022

@aswartz I think the error message may be missleading, i think tis the expiry date that is incorrect as you still have it as DD/MM/YYYY instead of YYYY-MM-DD.

Try changing both to be YYYY-MM-DD and re-importing it again, and as @avega said there is a space before the date.

aswartz
Helper I
Forum|alt.badge.img
  • aswartz
  • Author
  • Helper I
  • 164 replies
  • June 6, 2022

@avega that was exactly it! OMG thank you. I was losing the will to live. 🤣

Jihane
A
2 people like this
  • Jihane
    Jihane
  • A
    avega
aswartz
Helper I
Forum|alt.badge.img
  • aswartz
  • Author
  • Helper I
  • 164 replies
  • June 6, 2022
TaiSaxty wrote:

@aswartz I think the error message may be missleading, i think tis the expiry date that is incorrect as you still have it as DD/MM/YYYY instead of YYYY-MM-DD.

Try changing both to be YYYY-MM-DD and re-importing it again, and as @avega said there is a space before the date.

Thank you for answering!

The issue date and expiry date were both already in the correct format as you can see in the screenshot and file attached. The space was the problem which I must have accidently added when creating the custom date format in Google sheets. 

Best,

Aimee

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings