Author Topic: Tool needed: Import lists and re-order them  (Read 3699 times)

Chunkford

  • Inner Core
  • Hero Member
  • *
  • Posts: 1057
    • View Profile
Tool needed: Import lists and re-order them
« on: August 06, 2012, 12:19:41 PM »
Hey peeps,

Does anyone know of a tool that allows two lists to be imported and displayed next to each other so I can then easily reorder them?

What I'm doing is 301 redirects en masse due to a platform change and need to match up the old pages to the new pages.
Doing it in excel is a little fiddly so being able to drap and drop for example would be a time saver :)
"If my answers frighten you then you should cease asking scary questions"

ergophobe

  • Inner Core
  • Hero Member
  • *
  • Posts: 9298
    • View Profile
Re: Tool needed: Import lists and re-order them
« Reply #1 on: August 07, 2012, 04:46:53 AM »
Hmm... several

I use Beyond Compare but someone here uses another one... blanking on the name

Beyond Compare rocks. You can also use diff (*nix tool) but it's not usually visual.

bill

  • Devil's Avocado
  • Global Moderator
  • Hero Member
  • *****
  • Posts: 1286
  • Avast!
    • View Profile
    • Email
Re: Tool needed: Import lists and re-order them
« Reply #2 on: August 07, 2012, 05:42:57 AM »
You just want to manipulate one column of data while the other remains static, right? I'm not sure Beyond Compare, UltraCompare, or WinMerge would be right for that.

Maybe look at Excel alternatives like the Excel Web app, Google Docs or Open Office?

Chunkford

  • Inner Core
  • Hero Member
  • *
  • Posts: 1057
    • View Profile
Re: Tool needed: Import lists and re-order them
« Reply #3 on: August 07, 2012, 12:41:30 PM »
Thanks for that. Beyond compare looks nice but wont do what I need.

Yea that's right Bill, but I've slugged on at it and making progress albeit monotonous. That's the name of the game I suppose.
It has given me an idea for a tool to build tho as I'm sure I'm not the only one doing this :)
"If my answers frighten you then you should cease asking scary questions"

ergophobe

  • Inner Core
  • Hero Member
  • *
  • Posts: 9298
    • View Profile
Re: Tool needed: Import lists and re-order them
« Reply #4 on: August 07, 2012, 01:55:29 PM »
Quote
so I can then easily reorder them

Missed that the first time through - you're right the diff/merge tools won't help much with reordering.

Would something like this work?
http://www.redips.net/javascript/drag-and-drop-table-content/ - "Content of HTML table cells can be dragged to another table cell or another table."

or this
http://www.isocra.com/2008/02/table-drag-and-drop-jquery-plugin/ - "This TableDnD plugin allows the user to reorder rows within a table"

Those might take a bit of effort to get them working for what you want to do, but it would jumpstart you perhaps.

I have to imagine that somewhere the tool you want exists ready-made though....

Damian

  • Inner Core
  • Full Member
  • *
  • Posts: 144
    • MSN Messenger - ddoyle@gmail.com
    • AOL Instant Messenger - seodamian
    • View Profile
    • Ranks NL
    • Email
Re: Tool needed: Import lists and re-order them
« Reply #5 on: August 07, 2012, 02:24:01 PM »
I created a custom tool for something similar in Perl once, as part of a client's custom CMS and new website launch. 1000's of URLs had to be redirected.

Aside from selecting and storing the redirects, the server redirect map had to be updated to make the new redirects actually work, so I combined the matching and the redirect creation into a single action for the client. It allowed the client to work in his own pace instead of finishing the entire list in one go because every new redirect was used live  right away.

I categorized all non-redirected or non-verified URLs for the client, so they could focus on important categories first.

I created automated redirect match suggestions, and it used some custom logic, ie.. if a main level would be named /products/ on the old site and would now be called /shop/ the script would automatically suggest matching URLs based on this knowledge.

If the auto suggestions did not help, the next step was a URL search engine and clicking on a part (folder) of any old URL would search for new URLs matching that part, to help find the right URL to redirect more easily.
Ie.. f the URL was /products/widgets .. clicking on 'widgets' would return '/shop/widgets' among the results.

Last resort was free search.

Even though most new URLS had some logical relation to the old URLs, the old site was very chaotic and it was still a lot of manual work for the client.

All this probably doesn't help much....sorry  :D

Chunkford

  • Inner Core
  • Hero Member
  • *
  • Posts: 1057
    • View Profile
Re: Tool needed: Import lists and re-order them
« Reply #6 on: August 07, 2012, 03:31:59 PM »
Cheers ergophobe, that's the type of functionality I was looking for but the time to implement it would take just as long as finishing what I've done so far. Will have to defiantly come back to it as I have an idea in my head of what would make all this easier.

I have to imagine that somewhere the tool you want exists ready-made though....

That's normally the case and you find it after you've finished the job :(

All this probably doesn't help much....sorry  :D

No need to say sorry, information is good :)
Sounds to me you could turn that into a plugin for various CMS's so people can migrate to different platforms easier?
"If my answers frighten you then you should cease asking scary questions"