Author Topic: [FAQ] Aargh.... file path not imported  (Read 9985 times)

0 Members and 1 Guest are viewing this topic.

Offline deazo

  • Older Power User
  • *****
  • Posts: 283
    • View Profile
[FAQ] Aargh.... file path not imported
« on: July 19, 2010, 05:41:09 pm »
 Hi me again sorry for all the posts but problems are piling up...
 
 Before I describe the problem let me describe the method I am following.
 PVD won't import an XLS file for an unknow reason and would give me an error everytime I try.
 So I am using CSV import instead and it works.

 I basically create an xml exportd file from my corrupted database, convert it into a csv file, delete the columns/fields that i do not need to import in the new database.
 Then when I import the csv file in the new database, for some reason the "file path" field gets populated with the field that is just before it in the csv file!

 I even tried to create a csv file that is two columns only, ID and File path.
 When I import (after having modified the csv import to limit it to ID and Path), the File path gets populated with the ID number!!

 I'm going crazy here, the delimiter is fine, the csv import configuration corresponds to the csv file and yet it does not take the path.

 Am I missing something here?
 aaaarh I need some fresh air.
« Last Edit: September 22, 2010, 01:18:18 am by rick.ca »

buah

  • Guest
Re: Aargh.... file path not imported
« Reply #1 on: July 19, 2010, 06:28:23 pm »
Did you properly set up Excel importing plugin?

Offline deazo

  • Older Power User
  • *****
  • Posts: 283
    • View Profile
Re: Aargh.... file path not imported
« Reply #2 on: July 19, 2010, 06:57:37 pm »

 I think so yes, I did choose only two fields, ID and Path.
 In my xls (or csv) I have only two column, Num and Path.
 It should work, right?

Offline nostra

  • Administrator
  • *****
  • Posts: 2852
    • View Profile
    • Personal Video Database
Re: Aargh.... file path not imported
« Reply #3 on: July 19, 2010, 07:13:33 pm »
Maybe you should quote the values...

If it does not help submit your file here and I will have a look at it.
Gentlemen, you can’t fight in here! This is the War Room!

Offline deazo

  • Older Power User
  • *****
  • Posts: 283
    • View Profile
Re: Aargh.... file path not imported
« Reply #4 on: July 19, 2010, 07:19:52 pm »
 OK here is the csv file I use, the xls one is identical.
 In both CSV and Excel import configuration I have only two fields, ID and Path. also I use the ; delimiter.

[attachment deleted by admin]

buah

  • Guest
Re: Aargh.... file path not imported
« Reply #5 on: July 19, 2010, 08:54:49 pm »
Well, as far as I can remember Title and Year columns are must a have. If I'm wrong, sorry to mislead you.

Offline deazo

  • Older Power User
  • *****
  • Posts: 283
    • View Profile
Re: Aargh.... file path not imported
« Reply #6 on: July 19, 2010, 09:07:50 pm »
Quote
Well, as far as I can remember Title and Year columns are must a have. If I'm wrong, sorry to mislead you.
Nostra, could you confirm that please?

When using ID/Path only, PVD seem to recognize the ID's and ask me if I want to update the info for these entries, so I thought it was fine.
I'll test with ID/Title/Year/Path then.

Offline nostra

  • Administrator
  • *****
  • Posts: 2852
    • View Profile
    • Personal Video Database
Re: Aargh.... file path not imported
« Reply #7 on: July 19, 2010, 09:58:25 pm »
ID only should be enough for the case if records already exist in the database, otherwise you need at least one title.
Gentlemen, you can’t fight in here! This is the War Room!

Offline deazo

  • Older Power User
  • *****
  • Posts: 283
    • View Profile
Re: Aargh.... file path not imported
« Reply #8 on: July 19, 2010, 10:09:25 pm »

 Thanks yes my movies are already there with the right ID's.
 Would you know why the importing does not get the file path by any chance??

Offline rick.ca

  • Global Moderator
  • *****
  • Posts: 3241
  • "I'm willing to shoot you!"
    • View Profile
Re: Aargh.... file path not imported
« Reply #9 on: July 19, 2010, 11:02:40 pm »
Quote
Would you know why the importing does not get the file path by any chance??

Yes. This is what you should be doing...

1. Modify the CSV export template replacing filter="CSV Files|*.csv" with filter="CSV Files|*.txt". The purpose of this is just to create a TXT file so Excel will not open it automatically and instead you can...

2. Start Excel and open the exported file using File - Open (select the "all" or "text" file type). This will invoke the "Text Import Wizard"—which will allow you to specify the delimiter used (i.e., ";") and otherwise ensure the data is parsed properly.

3. Do whatever you need to do to the data (if anything) in Excel.

4. Configure the Excel import plugin by mapping the columns in the sheet to PVD fields. The plugin ignores column headings. Fields must be assigned to each column, in exactly the same order.

5. Run the import plugin. I always forget what the import actions (update, merge, add...) mean exactly, so I remind myself with this post.
« Last Edit: September 22, 2010, 01:17:53 am by rick.ca »

Offline nostra

  • Administrator
  • *****
  • Posts: 2852
    • View Profile
    • Personal Video Database
Re: Aargh.... file path not imported
« Reply #10 on: July 19, 2010, 11:41:36 pm »
The path is not imported because you do not have a separator at the end of each line. I have attached the corrected version.

[attachment deleted by admin]
Gentlemen, you can’t fight in here! This is the War Room!

Offline deazo

  • Older Power User
  • *****
  • Posts: 283
    • View Profile
Re: Aargh.... file path not imported
« Reply #11 on: July 25, 2010, 10:38:20 am »

 Thanks All I will test that out when back home and keep you updated on my progress.

Offline deazo

  • Older Power User
  • *****
  • Posts: 283
    • View Profile
Re: Aargh.... file path not imported
« Reply #12 on: July 30, 2010, 06:38:26 am »

 Nostra I cannot tell the difference between my csv file and the one you created for me but the import worked with yours while failing with mine, so thanks a lot! ;D

 Now my comp is going to spend all day getting imdb and allmovie info for my movies and my last step will be to re-attach all posters.

Offline deazo

  • Older Power User
  • *****
  • Posts: 283
    • View Profile
Re: Aargh.... file path not imported
« Reply #13 on: August 04, 2010, 09:14:03 am »

 Just wanted to report that I have now successfully transferred all 5800 movie entries from my previous corrupted database file to a new clean one.
 
 I imported all posters (VERY important step so that I don't loose hours/days of image hunting) using ImgID

 Many many thanks (for their patience and expertise) to all who helped me in this process: Buah, Nostra and Rick

 I am a happy man. ;D ;D ;D ;D ;D ;D

Offline rick.ca

  • Global Moderator
  • *****
  • Posts: 3241
  • "I'm willing to shoot you!"
    • View Profile
Re: Aargh.... file path not imported
« Reply #14 on: August 04, 2010, 10:12:10 am »
Congratulations! With 5,800 movies to watch, I trust you'll be happy for some time. ;)

Offline deazo

  • Older Power User
  • *****
  • Posts: 283
    • View Profile
Re: Aargh.... file path not imported
« Reply #15 on: August 04, 2010, 10:35:55 am »

 Well... some of these I have watched already and some others are not worth watching and I do not possess them anymore.
 But yes, it's still a lot I agree  :P