Bulk updating one field in each row of html on multiple webpages

Discussion in 'Coding Help' started by iddy, Jun 14, 2012.

Tags:
  1. iddy

    iddy New Member

    Hi

    I'd appreciate it if someone could let me know if the following is possible (without using php)

    I have a website that has a few hundred pages. Each page is basically just a html table (4 columns but there could be up to 100 rows). i need to update one field in each row, in each page. Is there any way to automate this or do i need to manually update each row/table/page then upload it again.

    The data I need to change is just text. I get a spreadsheet every so often which basically contains the whole web site.

    Thanks
     
  2. mneylon

    mneylon Administrator Staff Member

    The simplest way of doing it is server-side, but you'd need to either use PHP (or Perl) or some other type of server-side language
     
  3. php.allstar

    php.allstar New Member

    If you dont want to use a scripting language, then maybe you could download all the pages to your local machine, then do a global find and replace with a text editor such as edit editplus or something, then re-upload.
     
  4. philip82

    philip82 New Member

    The best way to do this is server side like blacknight mentions above. You could get the guy to format the files into CSV or you could scrape the file and explode each line into a list(json, serialized array) and post them to your database, or simply upload them to your server and read them line by line.
     

Share This Page