Databases
StackOverflow2013
Postsdbo
POPython, problems modifying a text file, searching for terms
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPython, problems modifying a text file, searching for terms
    primarykey
    data
    text
    <p>I posted a question yesterday here: <a href="https://stackoverflow.com/questions/6944708/finding-and-adding-to-a-kml-file-using-python">Finding and adding to a .kml file using python</a></p> <p>I have read a bunch of tutorial and now have a better understanding of python and that is good. Yet I still can't seem to get my script right. I know I am so very close. Basically I want to add a bunch of jpg's to a .kml file, which is basically .xml in google earth. I want my program to find a google earth "placemarker" in the xml file called: TO-XXX </p> <p>where XXX matches the TO-XXX.jpg. I already have a folder with a bunch of .jpgs whose filename matches the name of each placemarker. I need the program to find the </p> <pre><code>&lt;name&gt; (for example &lt;name&gt;TO-101&lt;/name&gt;) </code></pre> <p>and add a line right below the name line with a:</p> <pre><code>&lt;description&gt; &lt;img src=TO-101.jpg&gt;&lt;/description&gt;. </code></pre> <p>So, I have the code written, but I just can't seem to get it to find the . Which is always written: </p> <pre><code>"\t\t\t&lt;name&gt;TO-XXX&lt;/name&gt;\n". </code></pre> <p>So, here is the code:</p> <pre><code>import os infile = 'TO-Hand-Holes2.kml' # the file I am reading outfile = 'TO-Hand-Holes-Output.kml' # the file I plan to write to, using print for now images = os.listdir("./images") # the images folder, all image names match names source = open(infile, 'r') target = open(outfile, 'w') x = 0 #an incrementer i = 0 # an incrementer readxml = source.readline while x &lt; 20000: #There are about 17,000 lines in the .kml file readxml = source.readline() while i &lt; len(images): word = images[i] if readxml == "\t\t\t&lt;name&gt;%s&lt;/name&gt;\n" % word[:6]: #!!!!!!!!! the problem is here print readxml #output the &lt;name&gt; print word[:6] #output the &lt;description&gt; hit = 'true' i = i + 1 else: hit = 'false' #print "test%s" % word[:6] i = i + 1 if hit == 'false': print ("%s") % readxml x = x + 1 </code></pre> <p>I just can't seem to get it to recognize the lines. Any suggestions?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USrenosis
    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
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POPython, problems modifying a text file, searching for terms
      1. This table or related slice is empty.
      1. VTUpMod
    1. COCan you ensure that the formatting / indentation that displays is what you're actually using? If so, this shouldn't work really much at all. Your first while loop doesn't have anything it executes (no indented block below it). Additionally, if it is set up like above, you read the 20000 lines before you attempt to process any of them.
      singulars
      1. POPython, problems modifying a text file, searching for terms
      1. USg.d.d.c
    2. COoops, it didn't paste right, the rest of the lines of code are actually indented to be under the while x < 20000 loop. Fixing!
      singulars
      1. POPython, problems modifying a text file, searching for terms
      1. USrenosis
    3. COWhen you say does not recognize, do you mean the match on `readxml == "\t\t\t<name>%s</name>\n" % word[:6]` does not work or there is no output? On the latter point, I do not see any place that you write to your output file. You need something like this: `print >> target, word[:6]`, assuming pre-python 3.0.
      singulars
      1. POPython, problems modifying a text file, searching for terms
      1. UShughdbrown
 

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