aeontimeline

Open full view…

Import from CSV not working for dates older than 9,999 BC

rg1452
Thu, 02 Jan 2020 18:27:12 GMT

Hello, I'm trying to import a timeline from CSV (UTF-8) using the Import tool. All events with start dates 10,000 BC or previous are ignored. A snippet of the CSV file is posted below. Note also, I'm trying to import into a new Basic timeline. I have also tried to do this in a new History timeline. Any help would be appreciated. Thanks in advance! EventID,Title,Start Date,Duration,End Date,Parent,Color,Tags,Summary,Location,Person,Category,Complete,Sourc e,External Links,,,,,,,,,, 1,Matter and energy appear. Beginning of physics. Atoms and molecules appear. Beginning of chemistry,"13,500,000,000-01-01 00:00:00 BC",0 seconds,"13,500,000,000-01-01 00:00:00 BC",,Green,Geological epochs,,,,,,,,,,,,,,,,, 2,Formation of planet Earth,"4,500,000,000-01-01 00:00:00 BC",0 seconds,"4,500,000,000-01-01 00:00:00 BC",,Green,Geological epochs,,,,,,,,,,,,,,,,, 3,The Agricultural Revolution. Permanent settlements. ,"10,000-01-01 00:00:00 BC",0 seconds,"10,000-01-01 00:00:00 BC",,Purple,Inventions & Discoveries,Harari YN. Sapiens: A brief history of humankind. Random House; 2014.,,, Inventions & Discoveries,,,,,,,,,,,,, 4,"First kingdoms, script and money. Polytheistic religions.","2,500-01-01 00:00:00 BC",0 seconds,"2,500-01-01 00:00:00 BC",,Red,"Empires, Religions & Cultures",Harari YN. Sapiens: A brief history of humankind. Random House; 2014.,,,"Empires, Religions & Cultures",,,,,,,,,,,,, 5,First empire - the Akkadian Empire of Sargon,2334-01-01 00:00:00 BC,181 years,2153-01-01 00:00:00 BC,,Red,"Empires, Religions & Cultures",Harari YN. Sapiens: A brief history of humankind. Random House; 2014,,,"Empires, Religions & Cultures",,,https://en.wikipedia.org/w/index.php?title=Akkadian_Empire&oldid=883247505,,,,,,,,,, 35,Founding date of Rome,0753-01-01 00:00:00 BC,0 seconds,0753-01-01 00:00:00 BC,,Red,"Empires, Religions & Cultures",,,,"Empires, Religions & Cultures",,,"https://www.ancient.eu/Roman_Empire/ | Mark, Joshua J. ""Roman Empire."" Ancient History Encyclopedia. Ancient History Encyclopedia, 22 Mar 2018. Web. 16 Feb 2019. ",,,,,,,,,, 6,Invention of coinage,0700-01-01 00:00:00 BC,0 seconds,0700-01-01 00:00:00 BC,,Purple,Inventions & Discoveries,,Aegina (Greece),,Inventions & Discoveries,,,"https://www.ancient.eu/coinage/ | Crabben, Jan V. D. ""Coinage."" Ancient History Encyclopedia. Ancient History Encyclopedia, 28 Apr 2011. Web. 16 Feb 2019.",,,,,,,,,, 7,The first Persian Empire. A universal political order ‘for the benefit of all humans’.,0522-01-01 00:00:00 BC,37 years,0485-01-01 00:00:00 BC,,Purple,Inventions & Discoveries,,,,Inventions & Discoveries,,,"https://en.wikipedia.org/w/index.php?title=Achaemenid_Empire | Achaemenid Empire, https://en.wikipedia.org/w/index.php?title=Achaemenid_Empire (last visited Feb. 16, 2019).""",,,,,,,,,, 8,Emergence of Buddhism - “a universal truth ‘to liberate all beings from suffering’”,0404-01-01 00:00:00 BC,0 seconds,0404-01-01 00:00:00 BC,,Purple,Inventions & Discoveries,,,,Inventions & Discoveries,,,"https://www.ancient.eu/Buddhism | Violatti, Cristian. """"Buddhism."""" Ancient History Encyclopedia. Ancient History Encyclopedia, 20 May 2014. Web. 16 Feb 2019.""",,,,,,,,,, 9,The Roman Empire,0212-01-01 00:00:00 BC,"1664 years, 4 months, 4 weeks, 1 day",1453-05-30 00:00:00 AD,,Red,"Empires, Religions & Cultures",,,,"Empires, Religions & Cultures",,,https://www.ancient.eu/Roman_Empire/,,,,,,,,,, 9.1,Start of The Roman Empire,0212-01-01 00:00:00 BC,0 seconds,0212-01-01 00:00:00 BC,9,Red,"Empires, Religions & Cultures",,,,"Empires, Religions & Cultures",,,,,,,,,,,,, 9.2,The Western Roman Empire,0285-01-01 00:00:00,192 years,0477-01-01 00:00:00,39,Red,"Empires, Religions & Cultures",,,,"Empires, Religions & Cultures",,,https://en.wikipedia.org/wiki/Western_Roman_Empire|https://www.ancient.eu/Roman_Empire/,,,,,,,,,, 9.3,Byzantine (Eastern Roman) Empire,0285-01-01 00:00:00,"1168 years, 4 months, 4 weeks, 1 day",1453-05-30 00:00:00,39,Red,"Empires, Religions & Cultures",,,,"Empires, Religions & Cultures",,,https://www.ancient.eu/Byzantine_Empire/|https://www.ancient.eu/Roman_Empire/,,,,,,,,,, 10,Han Dynasty,0206-01-01 00:00:00 BC,426 years,0221-01-01 00:00:00 AD,,Red,"Empires, Religions & Cultures",,,,"Empires, Religions & Cultures",,,"https://www.ancient.eu/Han_Dynasty/ | Violatti, Cristian. ""Han Dynasty."" Ancient History Encyclopedia. Ancient History Encyclopedia, 27 May 2013. Web. 16 Feb 2019.",,,,,,,,,, 11,Period of Scientific Revolution,1542-01-01 00:00:00,146 years,1688-01-01 00:00:00,,Purple,Inventions & Discoveries,"• While its dates are debated, the publication in 1543 of Nicolaus Copernicus's De revolutionibus orbium coelestium (On the Revolutions of the Heavenly Spheres) is often cited as marking the beginning of the Scientific Revolution. • The beginning of the Scientific Revolution, the Scientific Renaissance, was focused on the recovery of the knowledge of the ancients; this is generally considered to have ended in 1632 with publication of Galileo's Dialogue Concerning the Two Chief World Systems.[8] The completion of the Scientific Revolution is attributed to the ""grand synthesis"" of Isaac Newton's 1687 Principia. The work formulated the laws of motion and universal gravitation thereby completing the synthesis of a new cosmology.[9] By the end of the 18th century, the Age of Enlightenment that followed Scientific Revolution had given way to the ""Age of Reflection.”",,,Inventions & Discoveries,,,"https://en.wikipedia.org/wiki/Scientific_Revolution | Scientific Revolution, https://en.wikipedia.org/w/index.php?title=Scientific_Revolution&oldid=879299906 (last visited Feb. 16, 2019).",,,,,,,,,,

aeonjess
Sun, 05 Jan 2020 02:15:35 GMT

Hi, I replied to your email, but for other users aswell the reason that the dates are not importing correctly is because they contain commas and our date formatting system does not recognise this at the moment. We will look to improve on this in the next version as we understand that this is how some users would want to format larger dates. Jess