.csv Dates in 20-Oct-06 fomat won't import/translate into VStuido

[william humphrey]

It's even worse when the database you are converting from also needs to be
completely re-written, normalized and logical to improve it and even worse
yet when the old database is still being used...

On Wed, Aug 13, 2008 at 6:52 PM, Barry G. Sumpter <barry at noodlebox.com.au>wrote:

> Solved.
>
> I used excel and formatted date columns in dd/mm/yyyy format.
> Then saved to .csv
> And imported with vStudio into a VarChar(200) fields table.
> Then wrote an INSERT INTO / SELECT query.
> Once I got it into VStudio it was easier.
>
> I wonder now that I'm writing this if we can add a mapping listbox
> To use like the import date into a table procedure.
> Where we would be able to define the new table layout and save it
> Etc..
>
>
> Is it me or is data conversions from one DB to another a pain.
> Not just field types but field matching as well.
> It's not a next day delivery kind of project.
> I'm thinking it's the grunt end of IT.
>
>
>  Thanks,
>      Barry G. Sumpter
>
>
>
> -----Original Message-----
> From: valentina-studio-bounces+barry=noodlebox.com.au at lists.macserve.net
> [mailto:valentina-studio-bounces+barry <valentina-studio-bounces%2Bbarry>=
> noodlebox.com.au at lists.macserve.net]
> On Behalf Of Ruslan Zasukhin
> Sent: Thursday, 14 August 2008 4:16 AM
> To: valentina-studio at lists.macserve.net
> Subject: Re: .csv Dates in 20-Oct-06 fomat won't import/translate into
> VStuido
>
> On 8/13/08 3:36 AM, "Barry G. Sumpter" <barry at noodlebox.com.au> wrote:
>
> Hi Barry.,
>
> IMPORTANT to understand:
>
> When data are stored INSIDE of db, they do not have any format!
> Format of string plays only when numbers are converted to/from strings
>
> > In VStuido I've got a VarChar field which contains a date in the format
> of
> > 20-Oct-06.
>
> Field DO NOT contains it in this format.
>    it only convert to it on the fly to display
>
>
> > It's the only way I could get the data in a VStuido DB.
> >
> > VStuido can't translate the data by simple changing the field type to
> date.
> >
> > Does anyone have a SQL statement to change the format into 20/08/2006 ?
>
> Select database in Schema Editor
> In the property inspector -- should be few parameters related to date/time
> format/ Check them
>
> --
> Best regards,
>
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
>
> Valentina - Joining Worlds of Information
> http://www.paradigmasoft.com
>
> [I feel the need: the need for speed]
>
>
> _______________________________________________
> Valentina-studio mailing list
> Valentina-studio at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina-studio
>
> _______________________________________________
> Valentina-studio mailing list
> Valentina-studio at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina-studio
>



-- 
http://www.bluewatermaritime.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.macserve.net/pipermail/valentina-studio/attachments/20080813/4e35ca68/attachment-0001.html