Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 6 of 6 total |
Excel formatted date import |
Mon, Oct 1 2018 6:05 PM | Permanent Link |
Adam Brett Orixa Systems | I have CSV Files (saved from Excel) in which the date has "helpfully" been formatted:
01-Apr-18 ie DD-mmm-YY I can't see an easy way to import these into EDB. I can write a procedure to REPLACE the values and then convert them into a date ... but is there an easier way? |
Tue, Oct 2 2018 2:53 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Adam
I guess you're using IMPORT in which case unless Tim implemented MMM but forgot to document it - no, A third party tool (eg Scalabium's import component) would work. The other bad news is that you'll either have to convert the csv file, have an intermediate table in which the date field is a string or write the whole import yourself. Wouldn't be a bad idea to ask Tim to implement this anyway. Roy Lambert |
Tue, Oct 2 2018 3:25 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Adam,
<< I have CSV Files (saved from Excel) in which the date has "helpfully" been formatted: 01-Apr-18 ie DD-mmm-YY I can't see an easy way to import these into EDB. >> I can't make any promises because 2.29 is starting to get rather "large" in terms of features, but I will see if I can squeeze it into 2.29. Tim Young Elevate Software www.elevatesoft.com |
Tue, Oct 2 2018 4:54 PM | Permanent Link |
Ian Branch | Tim Young [Elevate Software] wrote:
> I can't make any promises because 2.29 is starting to get rather "large" in terms of features, but I will see if I > can squeeze it into 2.29. Hi Tim, Care to tease us with any tit bits? Ian |
Wed, Oct 3 2018 4:48 AM | Permanent Link |
Adam Brett Orixa Systems | Tim
If you could squeeze it in, that would be brilliant. As the CSV has dates in the form "-Jan-" and these text segments are unique, I have used a Delphi routine to "find & replace all" "-Jan-" to "-01-", "-Feb-" to "-02-" etc. It was not too cumbersome, and worked, but obviously is a bit suspect in case those segments of text occurred anywhere else in the file! |
Tue, Oct 9 2018 1:53 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Ian,
<< Care to tease us with any tit bits? >> Join performance improvements, replication enhancements, and query performance monitoring are the big ones. There are also some minor improvements to the migrations and some other miscellaneous fixes. Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |