Welcome, Guest. Please login or register.
Login with username, password and session length


It's a release candidate! VirtueMart 2.0 RC - the next generation VirtueMart - is available! Read more....

  Advanced search

247038 Posts in 67506 Topics- by 258314 Members - Latest Member: aniketana
Pages: [1]   Go Down
Print
Author Topic: Import pricelist from my Suppliers webpage. (asking after really good search)  (Read 2757 times)
erick_alcala
Full Member
***
Posts: 154

Everything is Possible!


WWW
« on: October 02, 2009, 15:18:35 PM »

Hello,

I have searched in this forum, and googled it, and have not found any solution. So after not sleeping till 4:30 AM and waking at 7:30AM to keep looking I am hoping to get a neat solution. lol




Okay,
I count with:
Suppliers webpage
- no rss
 - no xml
 - no xls pricelist.
 - pricelist in HTML table wish u can see only if u log in
 - two different currencies in same list, and same row :S.. ej. | 19.80 D |

My Webpage
 - www.ofixcomp.com
My computer
- HTML WYIWYG
 - FIREFOX with firebug and DejaClick plugins.




What do I want to do?
Make auto updates from a webpage that does not have RSS or any kind of help to do so.




Problem:
*my suppliers pricelist cant be copied correctly to any excel sheet because it jumps rows and it gets all messy.
* pricelist stock changes every time something gets bought by another client.




Posible solution (if anyone can help)
- Use DejaClick to record me:
     1.- Loging to my suppliers webpage
     2.- Copying HTML Table pricelist
     3.- logging into my server
     4.- Pasting HTML Table
- Use PHP to convert table to CSV and save it in a directory *this is the only thing I need to finish.
- Use DejaClick to record me:
     1.- logging into joomla
     2.- going to csvi improved component
     3.- import products from directory of saved csv



what other solutions have I searched?
- RSS to CSV from PHP
- Google docs pasting pricelist and converting to csv but couldnt find any way for google docs to save file to my server, or to fix messy pricelist in google docs.
- importing html table directly to mysql
- asking personally my supplier to add rss or pass me a full pricelist of products in xls.



as I said, I have searched a LOOOOT of sites, and found some tips but have not found any script that converts HTML table to CSV and saves it in a directory.


Logged

wanting to learn to create good templates
Pages: [1]   Go Up
Print
Jump to: