Databases
StackOverflow2013
Postsdbo
POuntangling directory separator madness using string manipulation?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POuntangling directory separator madness using string manipulation?
    primarykey
    data
    text
    <p>I'm working on converting a website. It involved standardizing the directory structure of images and media files. I'm parsing path information from various tags, standardizing them, checking to see if the media exists in the new standardized location, and putting it there if it doesn't. I'm using string manipulation to do so.</p> <p>This is a little open-ended, but is there a class, tool, or concept out there I can use to save myself some headaches? For instance, I'm running into problems where, say, a page in a sudirectory (<code>website.com/subdir/dir/page.php</code>) has relative image paths (<code>../images/image.png</code>), or other kinds of things like this. It's not like there's one overarching problem, but just a lot of little things that add up. </p> <p>When I think I've got my script covering most cases, then I get errors like <code>Could not find file at export/standardized_folder/proper_image_folderimage.png</code> where it should be <code>export/standardized_folder/proper_image_folder/image.png</code>. It's kind of driving me mad, doing string parsing and checks to make sure that directory separators are in the proper places. </p> <p>I feel like I'm putting too much work into making a one-off import script very robust. Perhaps someone's already untangled this mess in a re-useable way, one which I can take advantage of?</p> <p><strong>Post Script:</strong> So here's a more in-depth scoop. I write my script that parses one "type" of page and pulls content from the same of its kind. Then I turn my script to parse another type of page, get all knids of errors, and learn that all my assumptions about how paths are referenced must be thrown out the window. Wash, rinse, repeat. </p> <p>So I'm looking at doing some major re-factoring of my script, throwing out all assumptions, and checking, re-checking, and double-checking path information. Since I'm really trying to build a robust path building script, hopefully I can avoid re-inventing the wheel. Is there a wheel out there?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USuser151841
    1. USuser151841
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POuntangling directory separator madness using string manipulation?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COSo you are reading out the image URLs from the HTML sourcecode and you have problems to map the relative paths to the document base URL?
      singulars
      1. POuntangling directory separator madness using string manipulation?
      1. UShakre
    2. COSome are relative and some are absolute. It's just a big mess.
      singulars
      1. POuntangling directory separator madness using string manipulation?
      1. USuser151841
    3. COHow do you aquire the HTML source? Is it via DomDocument?
      singulars
      1. POuntangling directory separator madness using string manipulation?
      1. UShakre
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload