December 22, 2007 at 8:59 am
I am new to SQL---really new. Here's what I trying to accomplish.
Being an associate for a number of companies, I want to put their datafeeds on my web site. This will keep my site up to date and bring information of the latest sales to the sites visitors.
What I need to do is import files from my vendors. Anyone have any suggestions. I'm stuck!
Thanks in advance for your help.
December 22, 2007 at 3:09 pm
First, please post this in a forum that makes sense for your post. You titled it SQL Server Express, so perhaps that forum.
Second, how are the data feeds coming? If they're RSS, there are plenty of readers that will pull the data from the feed and display it. If you need to receive or read a file and show it differently, and store it, maybe you need something like SSIS.
It would help to have a better description of what you are trying to accomplish.
December 22, 2007 at 7:19 pm
My data is coming in xls via Outlook Express. Also they come in as zip files through Outlook Express.
In which forum should I be asking this question?
December 22, 2007 at 7:46 pm
It sounds to me like you have a lot more to worry about that the database side of things....
You'll want to write something to
1. Check your POP3 mailbox (don't intermingle these emails with your daily emails)
2. Get the appropriate emails, save the XML attachment.
(For these two steps there are some bits of off-the-shelf software you can use such as Outlook Attachment Sniffer)
3. Use some tool, whether it be some SQL code or a custom written program, to read the XML file and either
a) Put its data into a DB where your webpage can read it; or
b) Format a new XML or HTML page and put it on your website
You haven't mentioned what sort of web server you're running (Windows or Linux), presumably it's windows as you posted in a MS SQL forum. Is the site running ASP.NET, classic ASP, JSP, ColdFusion, Ruby, PHP, Perl, etc, etc, etc 🙂 I suggest you post in a general forum for parts 1/2 of the above at some MS Outlook site.
For part 3 you could either provide us with some example XML or post in a forum dedicated to the language used for your website (ASP.NET, JSP, etc).
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply