[ale] OT: Data Mapping Tool

[Jim Philips]

Well, if you're going to use standard UNIX tools, awk would do just
fine--especially if you give it clear delimiters to work with. Then you
could use whatever import tool works with the given database. But all of
this may be too simple for the task at hand. Can you give us an example
of your "from" and "to" data?


On Wed, 2002-03-13 at 15:54, James P. Kinney III wrote:
> Sounds like a job for perl and regular expressions. If you can define
> the data types that go in each table, the separation into discrete lists
> by a comparison shouldn't be too hard. Once split, iterate through each
> list and insert into the designated table.
> 
> As most spreadsheets have some sort of common factor joining column and
> row relationships, it should be quite easy. Even easier if you have
> "column M is table M" and "columns A-L are tables A-L". Probably not :)
> Too easy.
> 
> 
> On Wed, 2002-03-13 at 15:42, Kevin O'Neill Stoll wrote:
> > Hello All,
> > 
> > I am in need of a tool that can handle a combination of importing and
> > mapping data to a database.
> > 
> > Example of my problem would be this:
> > 
> > I have a spreadsheet of data that I wish to import into a database BUT..
> > this spreadsheet really contains data that needs to be divided up into
> > three or four different tables in my database.
> > 
> > 
> > What I would like to be able to do is choose a delimited file to import
> > and then choose the 'mapping schema' that matches my database. In other
> > words, import data from one file into multiple tables that don't have the
> > same field name or number of fields but do have the proper data types.
> > 
> > 
> > Thanks for your help in advance, I have always received awesome answers
> > back from this list. Keep up the great work :)
> > 
> > Kevin Stoll
> > 
> > __________________________________________________
> > Do You Yahoo!?
> > Try FREE Yahoo! Mail - the world's greatest free email!
> > http://mail.yahoo.com/
> > 
> > ---
> > This message has been sent through the ALE general discussion list.
> > See http://www.ale.org/mailing-lists.shtml for more info. Problems should be 
> > sent to listmaster at ale dot org.
> > 
> -- 
> James P. Kinney III   \Changing the mobile computing world/
> President and COO      \          one Linux user         /
> Local Net Solutions,LLC \           at a time.          /
> 770-493-8244             \.___________________________./
> 
> GPG ID: 829C6CA7 James P. Kinney III (M.S. Physics)
> <jkinney at localnetsolutions.com>
> Fingerprint = 3C9E 6366 54FC A3FE BA4D 0659 6190 ADC3 829C 6CA7 
> 
> 
> 
> ---
> This message has been sent through the ALE general discussion list.
> See http://www.ale.org/mailing-lists.shtml for more info. Problems should be 
> sent to listmaster at ale dot org.
> 



---
This message has been sent through the ALE general discussion list.
See http://www.ale.org/mailing-lists.shtml for more info. Problems should be 
sent to listmaster at ale dot org.