Post reply

Warning: this topic has not been posted in for at least 120 days.
Unless you're sure you want to reply, please consider starting a new topic.

Note: this post will not display until it's been approved by a moderator.

Name:
Email:
Subject:
Message icon:
Attach:
(Clear Attachment)
(more attachments)
Allowed file types: gif, jpg, png, txt, tpl, lng, ini, pvd, psf, ini, cfg, csv, zip, xml, pas, 7z
Restrictions: 4 per post, maximum total size 1024KB, maximum individual size 1024KB
Note that any files attached will not be displayed until approved by a moderator.
Verification:
Type the letters shown in the picture
Listen to the letters / Request another image

Type the letters shown in the picture:
What is the best video database software?:

shortcuts: hit alt+s to submit/post or alt+p to preview


Topic Summary

Posted by: deazo
« 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
Posted by: rick.ca
« on: August 04, 2010, 10:12:10 am »

Congratulations! With 5,800 movies to watch, I trust you'll be happy for some time. ;)
Posted by: deazo
« 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
Posted by: deazo
« 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.
Posted by: deazo
« 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.
Posted by: nostra
« 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]
Posted by: rick.ca
« 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.
Posted by: deazo
« 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??
Posted by: nostra
« 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.
Posted by: deazo
« 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.
Posted by: buah
« 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.
Posted by: deazo
« 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]
Posted by: nostra
« 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.
Posted by: deazo
« 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?
Posted by: buah
« on: July 19, 2010, 06:28:23 pm »

Did you properly set up Excel importing plugin?
Posted by: deazo
« 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.
anything