Skip site navigation (1) Skip section navigation (2)

Re: Import from CSV - Questions

From: "Joel Hainley" <joelh(dot)pg(at)gmail(dot)com>
To: "Magnus Hagander" <mha(at)sollentuna(dot)net>
Cc: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>, pgadmin-hackers(at)postgresql(dot)org
Subject: Re: Import from CSV - Questions
Date: 2006-03-14 20:28:06
Message-ID: e1c4469a0603141228l6022ad1aua2d8fe63dfbac878@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-hackers
Magnus, any chance of getting a look at what you currently have to help
guide me in the appropriate direction?

On 3/10/06, Magnus Hagander <mha(at)sollentuna(dot)net > wrote:
>
> > To be honest I didn't realise it was there. The tool I have
> > in mind for more general data movement is a simplified
> > version of something like Microsoft's DTS, essentially with
> > input, transform and output modules. The input modules might
> > get data from ODBC or a CSV file for example, the transform
> > module would allow either straight mapping of source to
> > target columns, and (probably) python based transformation
> > for more complex stuff, and the output module would insert
> > the data into PostgreSQL, a CSV file or and ODBC data source etc.
> >
> > That is clearly a complex project though... An alternative
> > might be a simple wizard, activated by a 'load data' option
> > on the table context menu
> >
> > Magnus was also talkng about XML export (and import?) so
> > perhaps he has some ideas.
>
> Yeah, I've got some very sketchy design and code started around
> somewhere. Nothing ready to be looked at yet though, much less something
> usable.
>
> (And yes, the design was modularised to plugin thigs like ODBC and
> stuff, just in this particular case I needed XML specificaly)
>
> BTW - one important aspect is that the actual transfer part should run
> as a separate program and not just inside pgadmin. pgadmin would do the
> GUI to set it up only.
>
> //Magnus
>

In response to

pgadmin-hackers by date

Next:From: Magnus HaganderDate: 2006-03-14 20:44:41
Subject: Re: Import from CSV - Questions
Previous:From: OpenMacNewsDate: 2006-03-14 17:26:30
Subject: Re: SVN Commit by dpage: r5054 - trunk/pgadmin3/pkg/win32

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group