Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Importing names & addresses from Excel
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Plusnet Community
- :
- Forum
- :
- Help with my Plusnet services
- :
- Everything else
- :
- Importing names & addresses from Excel
Importing names & addresses from Excel
01-02-2008 8:49 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
I am building a website that will contain the names and address details and other stuff of around 470 businesses. Hopefully with a search function.
Pretty adventurous, really for me as I've only ever designed static sites; however, I did manage to install a phpbb forum on one site. (That's probably the most adventurous. (I didn't have a clue what I was doing; just followed the instructions)
Anyway, I have all the data I need in an Excel Spreadsheet and, as a novice to web databases, I presume I'm right in thinking that I do not need to re-type these details (or even copy/paste) into 470 separate web pages.
I've heard the terms CGI; php; Perl; mysql; etc., and asp, although I gather that PN doesn't support asp and I know about FTP'ing to my cgi server, but that's about it.
I would welcome someone pointing me in the right direction as to whether I could be capable of doing it the 'proper' way. Or even somewhere that offers and idiot's step-by-step guide.
Great Forum guys, keep it up.
Pretty adventurous, really for me as I've only ever designed static sites; however, I did manage to install a phpbb forum on one site. (That's probably the most adventurous. (I didn't have a clue what I was doing; just followed the instructions)
Anyway, I have all the data I need in an Excel Spreadsheet and, as a novice to web databases, I presume I'm right in thinking that I do not need to re-type these details (or even copy/paste) into 470 separate web pages.
I've heard the terms CGI; php; Perl; mysql; etc., and asp, although I gather that PN doesn't support asp and I know about FTP'ing to my cgi server, but that's about it.
I would welcome someone pointing me in the right direction as to whether I could be capable of doing it the 'proper' way. Or even somewhere that offers and idiot's step-by-step guide.
Great Forum guys, keep it up.
Message 1 of 5
(1,760 Views)
4 REPLIES 4
Re: Importing names & addresses from Excel
01-02-2008 9:35 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
You will need to write some PHP code to import the data from the file and import it into your MySQL database (you are using a database for this?).
Reading .xls files can be difficult for a novice so save the file as a .csv file and read up on the php functions for reading csv files - fgetcsv().
Or just google for reading csv files with php.
Or search for php based CRM systems (Customer relationship Manager) which might save you a lot of coding. You might find something suitable on www.hotscripts.com
Reading .xls files can be difficult for a novice so save the file as a .csv file and read up on the php functions for reading csv files - fgetcsv().
Or just google for reading csv files with php.
Or search for php based CRM systems (Customer relationship Manager) which might save you a lot of coding. You might find something suitable on www.hotscripts.com
Message 2 of 5
(575 Views)
Re: Importing names & addresses from Excel
01-02-2008 11:19 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
The best way depending on your knowledge is to export it as XML as its then in a format as a database and can be used by most programing languages. There is old fashioned text of coarse.
what data are you using as I am thinking Data Protection Act
what data are you using as I am thinking Data Protection Act
Message 3 of 5
(575 Views)
Re: Importing names & addresses from Excel
02-02-2008 11:21 AM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
He already stated it's business addresses, so the Data Protection act doesn't apply.
B.
B.
Message 4 of 5
(575 Views)
Re: Importing names & addresses from Excel
03-02-2008 12:16 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Thank you for your starters for 10!
Diving into the deep end comes to mind.
I'll have a delve around and see how it goes; after all, if don't try it you never learn it.
Thanks again
Funseeker
Diving into the deep end comes to mind.
I'll have a delve around and see how it goes; after all, if don't try it you never learn it.
Thanks again
Funseeker
Message 5 of 5
(575 Views)
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Plusnet Community
- :
- Forum
- :
- Help with my Plusnet services
- :
- Everything else
- :
- Importing names & addresses from Excel