This is a discussion on "How do the pros do it?" within the Web Page Design section. This forum, and the thread "How do the pros do it? are both part of the Design Your Website category.
|
|
|
|
|
 |
||
How do the pros do it?
|
||
| Notices |
 |
|
|
LinkBack | Thread Tools |
|
#1
Mar 20th, 2007, 20:41
|
|||
|
|||
How do the pros do it?
Hey everyone. I hope this is the right place for this post. I’m making a site for my own personal use to organize my music and pictures and other media files. I have a template that I plan on using on each page of the site, but I wanted to change a few words in each of the pages. For example the file name, file size and file format. I have over 5000 pages to create and I wasn’t really looking forward to changing each one individually.
I was wondering if there was a feature in MS Front Page (or another program) that worked similarly to MS Word’s “Mail Merge” feature. Can I do this by creating a dynamic web template? I have organized all of the data in excel; is it possible to import it somehow to Front Page? Thanks in advance, linchpin.         
|
|
|
|
#2
Mar 21st, 2007, 00:14
|
|||
|
|||
|
Re: How do the pros do it?
Can't you create dynamic sites using an access database? Not sure about excel, but i think you can import data into MySQL using a few different methods. Someone with more knowledge and experience will no doubt let you know.
But you can do it yes. And there are loads of ways to go about it. Take a look at php and MySQL to get started. Pete. 
|
|
#3
Mar 21st, 2007, 14:28
|
|||
|
|||
|
Re: How do the pros do it?
If the spreadsheet has the same structure as your Database you can export it as a CSV file and inject it, I know you can with MySQL, I however never use Access. Alternately you can dump the MySQL DB into a CSV file as well and import that into Excel. Excel itself has some database connectivity built in also. You may want to read up on that.
Last Blog Entry: Apps every Mac based web dev should consider (Jul 10th, 2008)
|
|
#4
Mar 21st, 2007, 14:45
|
|||
|
|||
|
Re: How do the pros do it?
thanks guys, i was kinda hoping i wouldnt have to touch MySQL but a database is really the only path that makes sence in this case. it seems like the easiest way to get things done and to maintain the site once its up and running.
since ive never used MySQL before im sure ill have a bunch of problems and questions, but now that i know what im dealing with i will be able to ask them in the appropriate forum. thanks a lot guys, i appreciate the help!!
|
|
#5
Mar 21st, 2007, 17:03
|
|||
|
|||
|
Re: How do the pros do it?
It should work with Access too. One would think. But eh, it is Microsoft.
Last Blog Entry: Apps every Mac based web dev should consider (Jul 10th, 2008)
|
|
#6
Mar 21st, 2007, 23:25
|
||||
|
||||
|
Re: How do the pros do it?
Databases really make things easier. Don't know why you don't want to touch 'em
|
|
#7
Mar 22nd, 2007, 23:32
|
|||
|
|||
|
Re: How do the pros do it?
I guess i was just intimitated by something that didnt have a GUI...but i took the plunge and downloaded it along with PHP earlier today. i havent done anything major yet, just toying around with MySQL, but when i figure some things out and get more comfortable with it, ill dive into this dynamic web pages thing. im sure when i get the hang of it ill have thousand of uses and wonder where it's been all my life.
thanks everyone for your support!!! ill let you know how it turns out.
|
|
#8
Mar 23rd, 2007, 01:32
|
||||
|
||||
|
Re: How do the pros do it?
Ah, well. PHPMyAdmin gives MySQL a UI
|
|
#9
Mar 23rd, 2007, 19:50
|
|||
|
|||
|
Re: How do the pros do it?
PHPMyAdmin is very handy as is CocoaMySQL if you have a Mac. Would love if any one knows any good free windows equivs to CocoaMySQL.
Last Blog Entry: Apps every Mac based web dev should consider (Jul 10th, 2008)
|
|
#10
Mar 23rd, 2007, 20:31
|
|||
|
|||
|
Re: How do the pros do it?
Quote:
|
|
#11
Mar 26th, 2007, 23:35
|
|||
|
|||
|
Re: How do the pros do it?
Well i've got everything up and running and working together. I've been playing around with everything and i am starting to get the hang of MySQL. I must say, phpMyAdmin is helping me out a LOT. Special thanks to Ryan Fait for that tip. Thanks everyone else who pointed me in the right direction!!
|
|
#12
Mar 26th, 2007, 23:58
|
||||
|
||||
|
Re: How do the pros do it?
No problem!
|
|
#13
Mar 31st, 2007, 01:23
|
|||
|
|||
|
Re: How do the pros do it?
There is also Navicat for Windows and Mac (I think). That's what I use for my rails apps.
|
|
#14
Apr 2nd, 2007, 15:29
|
|||
|
|||
|
Re: How do the pros do it?
Not sure what your development environment is like, but I find xampp (http://www.xampp.org) indispensable for developing in php and MySql. It runs an apache server with MySql and allows you to run either php4 or php5 (so you can match up with your actual web server.) It includes phpMyAdmin, too.
HTH
|
|
#15
Apr 2nd, 2007, 16:52
|
|||
|
|||
|
Re: How do the pros do it?
Yeah xampp is good and free...but I hear Mac comes with something better!
|
|
#16
Apr 3rd, 2007, 05:10
|
||||
|
||||
|
Re: How do the pros do it?
Hehe.
*hugs my built-in Apache server with PHP on my PowerBook
|
|
#17
Apr 4th, 2007, 19:01
|
|||
|
|||
|
Re: How do the pros do it?
Oh yeah, got Apache, PHP, MySQL all running smooth on my MacBook Pro, edited the httpd.conf to use my sites folder as my root. mm mmm good.
Last Blog Entry: Apps every Mac based web dev should consider (Jul 10th, 2008)
|
|
#18
Apr 4th, 2007, 21:44
|
||||
|
||||
|
Re: How do the pros do it?
I didn't know you could do that. I just made a symbolic link to it in my home folder. That works too
|
|
#19
Apr 5th, 2007, 14:12
|
|||
|
|||
|
Re: How do the pros do it?
hehe yeah but its easy to change, and its a pain to dig down to the server folder. Besides, the site folder makes more sense to me as a repository for well, sites. Also, I prefer to use my home folder and not the root level of the drive. Ja know? Maybe this helps. http://www.cgi101.com/learn/connect/mac.html#3
Last Blog Entry: Apps every Mac based web dev should consider (Jul 10th, 2008)
|
