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
> (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.
In response to
pgadmin-hackers by date
|Next:||From: Magnus Hagander||Date: 2006-03-14 20:44:41|
|Subject: Re: Import from CSV - Questions|
|Previous:||From: OpenMacNews||Date: 2006-03-14 17:26:30|
|Subject: Re: SVN Commit by dpage: r5054 - trunk/pgadmin3/pkg/win32|