[ale] OT: Data Mapping Tool

[James P. Kinney III]

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.