News!! Comparison Ii Text Files - Using Excel
Thursday, 22 November 2018
Article,
Excel,
File management,
Template Designer,
Template editing,
ZZ - needs 2015 2nd review,
ZZ - needs 2017 theme review
Edit
This article is virtually comparing ii text files, making a listing of the differences betwixt them together with categorising each deviation according to whether yous aid virtually it or not. An Excel file tool (available for download) is used, because this helps amongst making the concluding list.
The tool was made to back upward comparing ii Blogger templates,as share of Seven Simple Steps to a Snazzy New-look Blog. But it tin last used for many dissimilar types of file-comparisons where yous necessitate to yell upward virtually the betwixt the files, proceed rails of private differences, together with innovation actions based on them.
In theory, yous tin compare ii text-files business yesteryear business manually. But inward practice, specially when the files are made from code similar HTML together with non English-language sentences, this is rattling difficult to do: fifty-fifty a one-character deviation may last significant, but difficult to see.
There are many existing tools that volition compare ii files. But a spreadsheet plant simply every bit good - together with it has other features that tin last used to assistance amongst making a plans based on the differences found, together with tracking progress amongst fixing them.
I've set simply about notes virtually where to set the comparing text files, together with how to exercise the formulas into the spreadsheet, together with simply about detailed pictures below. But the principal indicate is that when yous honour a deviation yous necessitate to:
Get the ii template files that yous desire to compare, together with opened upward them amongst a text editor (eg Notepad).
They volition await ugly together with difficult to piece of employment this - this is ok, the adjacent footstep puts them inward a improve format.
Download the Excel tool for comparing text-files.
Paste the contents of the template file from your real blog inward the left-hand column.
Paste the contents of the template from your test-blog inward the middle column.
Paste the contents of the comparison formula cell (ie the red-shaded one) into every row where at that topographic point are contents from either of root files.
NB the comparing forumla is =IF(D8=A8, "", "Not the same")
In the spreadsheet the prison theater cellular telephone is shaded red, together with yous cannot come across it unless yous await inward the formula bar (this makes the pictures easier to read).
In Column F, await for the get-go row when "Not the same" is displayed.
Look at the code for that line, together with work out what caused the difference, together with whether it's is due to a customisation that yous made together with desire to keep, or individual that yous don't desire to keep, or something else that Google convey done inward the meantime.
If the deviation is due to a customisation that yous desire to keep, together with then make notes virtually this into the Comments together with ToDo columns.
In the event shown, the get-go deviation business is a meta-tag, which I do desire to keep, but the instant is simply the tag-close command: I don't necessitate to set it separately into my plan, thence it's marked "no".
Re-match the lines of code:
If the deviation was due to extra code, then
Repeat these steps until all the differences are understood.
At the end, re-create the comments together with notes columns into simply about other worksheet, together with exercise Excel's variety functions to extract a listing of the differences that yous necessitate to bargain with.
(I similar to exercise Excel to proceed lists of planned changes likewise - but that's a whole dissimilar topic.)
Making a test-blog for testing template changes
Seven unproblematic steps to a snazzy new-look blog.
Showing a PowerPoint presentation every bit a slideshow inward your website
Planning changes to your weblog - inward private
The tool was made to back upward comparing ii Blogger templates,as share of Seven Simple Steps to a Snazzy New-look Blog. But it tin last used for many dissimilar types of file-comparisons where yous necessitate to yell upward virtually the betwixt the files, proceed rails of private differences, together with innovation actions based on them.
In theory, yous tin compare ii text-files business yesteryear business manually. But inward practice, specially when the files are made from code similar HTML together with non English-language sentences, this is rattling difficult to do: fifty-fifty a one-character deviation may last significant, but difficult to see.
There are many existing tools that volition compare ii files. But a spreadsheet plant simply every bit good - together with it has other features that tin last used to assistance amongst making a plans based on the differences found, together with tracking progress amongst fixing them.
I've set simply about notes virtually where to set the comparing text files, together with how to exercise the formulas into the spreadsheet, together with simply about detailed pictures below. But the principal indicate is that when yous honour a deviation yous necessitate to:
- Work out where the deviation ends,
- Insert simply about blank cells inward the other column thence that the code lines upward again,
- Re-copy the comparing formulas into column F (because the insert volition convey mis-aligned the existing ones),
- Make notes virtually differences every bit they are constitute - this listing is of import for deciding what to do next.
Preparing to compare text files
Get the ii template files that yous desire to compare, together with opened upward them amongst a text editor (eg Notepad).
They volition await ugly together with difficult to piece of employment this - this is ok, the adjacent footstep puts them inward a improve format.
 |
| A text file, viewed inward Excel together with looking ugly |
Download the Excel tool for comparing text-files.
Paste the contents of the template file from your real blog inward the left-hand column.
Paste the contents of the template from your test-blog inward the middle column.
Paste the contents of the comparison formula cell (ie the red-shaded one) into every row where at that topographic point are contents from either of root files.
NB the comparing forumla is =IF(D8=A8, "", "Not the same")
In the spreadsheet the prison theater cellular telephone is shaded red, together with yous cannot come across it unless yous await inward the formula bar (this makes the pictures easier to read).
Doing the Comparison
In Column F, await for the get-go row when "Not the same" is displayed.
Look at the code for that line, together with work out what caused the difference, together with whether it's is due to a customisation that yous made together with desire to keep, or individual that yous don't desire to keep, or something else that Google convey done inward the meantime.
If the deviation is due to a customisation that yous desire to keep, together with then make notes virtually this into the Comments together with ToDo columns.
In the event shown, the get-go deviation business is a meta-tag, which I do desire to keep, but the instant is simply the tag-close command: I don't necessitate to set it separately into my plan, thence it's marked "no".
Re-match the lines of code:
If the deviation was due to extra code, then
- insert simply about extra rows inward the other column thence that the matching code lines upward again, AND
- re-copy the comparing forumula into the rows from at that topographic point down.
Repeat these steps until all the differences are understood.
At the end, re-create the comments together with notes columns into simply about other worksheet, together with exercise Excel's variety functions to extract a listing of the differences that yous necessitate to bargain with.
(I similar to exercise Excel to proceed lists of planned changes likewise - but that's a whole dissimilar topic.)
Related Articles
Making a test-blog for testing template changes
Seven unproblematic steps to a snazzy new-look blog.
Showing a PowerPoint presentation every bit a slideshow inward your website
Planning changes to your weblog - inward private
0 Response to "News!! Comparison Ii Text Files - Using Excel"
Post a Comment