Gossamer Forum
Home : Products : Gossamer Links : Development, Plugins and Globals :

different tables, same database

Quote Reply
different tables, same database
I have two different datafeeds from two different companies that I need loaded into links. I can use LOAD DATA INFILE "xyz_datafeed.txt" INTO TABLE `xyz_table`. and LOAD DATA INFILE "abc_datafeed.txt" INTO TABLE `abc_table`. but how to get them to work with links. Will I have to add every imaginable colum for all of the datafeeds, and just leave the info from one that doesn't apply to the other blank???
Previously I have been manually modifying them to match, but now the datafeeds have grown too large to manually change...
Any suggestions...

</not a clue>
Quote Reply
Re: [Dinky] different tables, same database In reply to
Hi,

Can you show the specific structure of the data feeds you want to import?

And the database you are currently working with?

It's possible to import data fields into specific Links fields, by specifying them in order on the import line.

That means, you'd only need to have as many fields as are DIFFERENT in each data feed. The same fields (no matter what they are called) can be imported into the same column in links. You'd need to have a script, and give it the name to know which "layout" to use.


PUGDOG� Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.