Databases
StackOverflow2013
Postsdbo
POEPFImporter creates table but imports nothing
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POEPFImporter creates table but imports nothing
    text
    copied!<p>I'm using Apple's EPFImporter tool <a href="http://www.apple.com/itunes/affiliates/resources/documentation/epfimporter.html" rel="nofollow">http://www.apple.com/itunes/affiliates/resources/documentation/epfimporter.html</a></p> <p>It's a Python script that will take space separated EPF file lists and import them into my database.</p> <p>Here's what I have:</p> <pre><code>Braden-Keiths-MacBook-Pro:~ bradenkeith$ ./EPFImporter.py /Users/bradenkeith/Downloads/popularity20120314 </code></pre> <p>Here's what the CLI returns:</p> <pre><code>2012-03-14 22:12:28,748 [INFO]: Beginning import for the following directories: /Users/bradenkeith/Downloads/popularity20120314 2012-03-14 22:12:28,748 [INFO]: Importing files in /Users/bradenkeith/Downloads/popularity20120314 2012-03-14 22:12:28,749 [INFO]: Starting import of /Users/bradenkeith/Downloads/popularity20120314... 2012-03-14 22:12:28,749 [INFO]: Beginning full ingest of epf_application_popularity_per_genre (2000491 records) 2012-03-14 22:14:28,774 [INFO]: ...at record 1797000... 2012-03-14 22:16:02,152 [INFO]: Full ingest of epf_application_popularity_per_genre took 0:03:33.402408 2012-03-14 22:16:02,196 [INFO]: Import of popularity20120314 completed at: 12-03-14 22:16:02 2012-03-14 22:16:02,196 [INFO]: Total import time for popularity20120314: 0:03:33.44 2012-03-14 22:16:02,196 [INFO]: Total import time for all directories: 0:03:33.44 </code></pre> <p>The tool was capable of creating the database. It just won't add any of the entries to the database. It obviously sees 2mil+ records, and spends the time combing through them... deleting and merging the blank tables... but it's just that - tables are still blank. I thought possibly it's a permissions thing with mySQL. I double checked and made sure everything was granted to the user account I was using. Still nothing. </p> <p>Any ideas of what this might could be?</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

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