Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - ruffa

Pages: [1]
1
Support / Re: Lost all my PVD data after upgrading?
« on: December 13, 2019, 04:25:08 pm »
Thanks for your reply and sorry for the late reply i got locked out of this forum by making a password change and it seems the mailing system on here is broke, i didn't get any confirmation email to reset password and ended up locked out, i think it must have timed out after so many days and it's let me back in now.

I tried what you suggested and PVD loaded up with no films so i imported an old backup which worked, which was great! so i immediatley exported into all formats as a precaution.

But next time i tried to load the database up i found that the version had returned back to V.10 (?) the latest version, not sure how thats happened as i ran the same bat file from within the zip folder for V.9 so very strange. I've not been able to get it working since.

I should probably try re-unzipping the zip file and doing it again but wonder why it reverted back to a newer version when it shouldn't even be on my system although i may have the newer version in another folder on the PC somewhere, not sure if this will interfere with it.

thanks for your help


2
Support / Lost all my PVD data after upgrading?
« on: November 26, 2019, 11:25:33 am »
Hoping someone can help me, i lost all my PVD data about 6months back, because it happened a while ago i'm not 100% sure which order things happened but i'll do my best to explain.
I had been using the old 9. version of PVD for 10yrs+ and upgraded to Windows 10 which may have  been the start of the problems, i think i noticed some odd behaviour in PVD, i then seem to remember comming to this website to upgrade to the latest version of PVD in an attempt to fix, then next time i went to go into my database to my horror it listed 0 films! i've not been able to get them back since and have no idea whats happened.

I did have a HTML and .bak files of my old database from a few yrs back but these are missing 200+ films and i have tried to restore these backups within the latest PVD i have installed just so i have something to work with but they will not install for some reason i always get errors so currenty the only access i have to my work is via the HTML which isn't great. I have tried uninstalling the latest verison and tried installing every version of PVD in order to get one of my backups installed and none of them work, i'm kind of desperate right now just to get PVD working again, not bothered what version i have as i dont use the scripts or internet i only want it for PC use.

As far as i know the PVD data is saved in the exe file, the one that my desktop PVD icon would point to(hope thats right) if it's not could someone tell me where the PVD data for my files sits on the computer?
I do remember moving some folders off my hard drive to make space at one point so there is a possibility i may have moved something which caused the problem(i need to check this) but after comming here and reading the probs with win10 and software versions i'm thinking maybe the issue relates to me upgrading PVD and maybe not doing it properly or something.

Hoping someone might recognize this problem i have, any ideas appreciated, thanks

3
Development / Re: PK's MovieDB dynamic website template
« on: October 31, 2008, 08:44:42 pm »
i think i might have disabled one of the side pannels which displayed something i didn't want, maybe it was the years? i didn't really need a years display so i think i may have edited it out somewhere.

I have photoshop but i've never figured out how to use it to save web pages, but i get what u where saying about the colour changes, the main thing i want to do is disable the video bitrate and all those fields i don't use, so u guess i just need to edit the details.tpl

thanks for all your help.. i'm going to try and build a nice website to go with the database when i get time, will post a link when i eventually finnish it.

4
Development / Re: PK's MovieDB dynamic website template
« on: October 29, 2008, 04:32:59 pm »
Hi, yes i thought that might be the case where like the 9th database field ORIGINALTITLE corresponds to the 9th export variable, would be easier if it could recognise the field name rather than order in the list.
But anyway i have done it successfully, in the end! i'm very greatful for your help.

I just repasted the template file into PVD as i think i may have removed some fields from the script, so fixed this, and i made the change to the script like u told me to do and it now works fine.

My next question is whats the best way to edit the main view of the database, just things like colours and aswell as adding maybe other things on either side of the database as there are 2 black empty bits where i can put extra info.
Can i do this in HTML? i think the index file is in PHP but i'm not used to using php but i do have an editor, can i edit using Front Page? or NVU?

Thanks for helping with all the info and files etc.

By the way, the film names did import ok in the end, u can have a look:
http://bwoyruff.co.cc/index.php
But i noticed the film title is not clickable like yours i just have to click the jpeg instead, but i can live with that. Actually the example on the webpage has a clickable title thats just because the entry also had info in the Title Field of PVD but most of my films titles are int he ID no section.

you will only see one entry in there right now, i did upload 2000+ but deleted them now i know it works and will now work on a new list for the web.

5
Development / Re: PK's MovieDB dynamic website template
« on: October 29, 2008, 08:42:54 am »
thanks,
you know on my pvd database where u have the first field for an entry where your supposed to put a ID number maybe, i have been using this field for the film title, i did this from the start without realizing, so where it says 'Original Title' this isn;t always filled in, i wonder if this will cause the problem?

I also remembered, i think i may have removed some of the fields on the pvd sql export config so i will put this back right aswell, maybe this was causing problems aswell? i'll let u know how i get on.

6
Development / Re: PK's MovieDB dynamic website template
« on: October 28, 2008, 05:12:14 pm »
I removed the database, created a fresh one and i get the same error, here it is below:

******************************************************
Quote
Error
SQL query:

INSERT INTO movies( NUM, CHECKED, MEDIA, MEDIATYPE, SOURCE, DATEADD, BORROWER, RATING, ORIGINALTITLE, TRANSLATEDTITLE, FORMATTEDTITLE, DIRECTOR, PRODUCER, COUNTRY, CATEGORY, YEAR, LENGTH, ACTORS, URL, DESCRIPTION, COMMENTS, VIDEOFORMAT, VIDEOBITRATE, AUDIOFORMAT, AUDIOBITRATE, RESOLUTION, FRAMERATE, LANGUAGES, SUBTITLES, FILESIZE, DISKS, VIEWDATE, PICTURENAME )
VALUES (

'0', '', '', '', '', '2008-05-29', '', '0', '', '150 YEARS OF INDIANS IN JAMAICA', '', '', '', 'JA', '', '0', '0', '', '', 'A discussion and re-enactment of the coming of the East Indians to Jamaica.', '', '', '', '', '', '', '', '', '', '0', '0', '', ''
);

MySQL said: 

#1062 - Duplicate entry '0' for key 1

*************************************************
It couldn;t be refering to a duplicate film entry could it?? as i may have some duplicate titles in there.


Here is a sample of a few lines from the SQL file i exported from PVD:

Quote
INSERT INTO movies (NUM, CHECKED, MEDIA, MEDIATYPE, SOURCE, DATEADD, BORROWER, RATING, ORIGINALTITLE, TRANSLATEDTITLE, FORMATTEDTITLE, DIRECTOR, PRODUCER, COUNTRY, CATEGORY, YEAR, LENGTH, ACTORS, URL, DESCRIPTION, COMMENTS, VIDEOFORMAT, VIDEOBITRATE, AUDIOFORMAT, AUDIOBITRATE, RESOLUTION, FRAMERATE, LANGUAGES, SUBTITLES, FILESIZE, DISKS, VIEWDATE, PICTURENAME) VALUES ('0', '', '', '', '', '2008-08-06', '', '7.4', 'Amandla! A Revolution in Four Part Harmony', 'Amandla', '', 'Lee Hirsch', 'Johnathan Dorfman, Temple Fennell, Lee Hirsch, Desireé Markgraaff, Sherry Simpson', 'South Africa, USA', 'Documentary, Music, History', '2002', '108', 'Walter Cronkite, F.W. de Klerk, Abdullah Ibrahim, Jesse Jackson, Duma Ka Ndlovu, Ronnie Kasrils, Sibongile Khumalo, Vusi Mahlasela, Miriam Makeba, Nelson Mandela, Winnie Mandela, Hugh Masekela, Sophie Mgcina, Thandi Modise, Sifiso Ntuli, Sibusiso Nxumalo, Dolly Rathebe, Hendrik Frensch Verwoerd, Lindiwe Zulu', 'http://www.imdb.com/title/tt0303297/', 'Through a chronological history of the South African liberation struggle, this documentary cites examples of the way that music was used in the fight for freedom. Songs united those who were being oppressed and gave those fighting a way to express their plight. The music consoled those incarcerated, and created an effective underground form of communication inside the prisons.', '', '', '', '', '', '', '0', '', '', '0', '0', '2008-07-19', 'image83.jpg');
INSERT INTO movies (NUM, CHECKED, MEDIA, MEDIATYPE, SOURCE, DATEADD, BORROWER, RATING, ORIGINALTITLE, TRANSLATEDTITLE, FORMATTEDTITLE, DIRECTOR, PRODUCER, COUNTRY, CATEGORY, YEAR, LENGTH, ACTORS, URL, DESCRIPTION, COMMENTS, VIDEOFORMAT, VIDEOBITRATE, AUDIOFORMAT, AUDIOBITRATE, RESOLUTION, FRAMERATE, LANGUAGES, SUBTITLES, FILESIZE, DISKS, VIEWDATE, PICTURENAME) VALUES ('0', '', '', '', '', '2008-08-06', '', '0', '', 'Amandla - Wake Up and Live (Bob Marley)', '', '', '', 'USA', '', '0', '0', '', '', '', 'Havard Stadium, boston, 21st July 1979', '', '', '', '', '', '0', '', '', '0', '0', '2008-07-19', 'image84.jpg');
INSERT INTO movies (NUM, CHECKED, MEDIA, MEDIATYPE, SOURCE, DATEADD, BORROWER, RATING, ORIGINALTITLE, TRANSLATEDTITLE, FORMATTEDTITLE, DIRECTOR, PRODUCER, COUNTRY, CATEGORY, YEAR, LENGTH, ACTORS, URL, DESCRIPTION, COMMENTS, VIDEOFORMAT, VIDEOBITRATE, AUDIOFORMAT, AUDIOBITRATE, RESOLUTION, FRAMERATE, LANGUAGES, SUBTITLES, FILESIZE, DISKS, VIEWDATE, PICTURENAME) VALUES ('0', '', '', '', '', '2008-09-05', '', '0', '', 'Amazing World - Jamaica', '', '', '', '', '', '2001', '0', '', '', 'series, one ja episode', '', '', '', '', '', '', '0', '', '', '0', '0', '', '');
INSERT INTO movies (NUM, CHECKED, MEDIA, MEDIATYPE, SOURCE, DATEADD, BORROWER, RATING, ORIGINALTITLE, TRANSLATEDTITLE, FORMATTEDTITLE, DIRECTOR, PRODUCER, COUNTRY, CATEGORY, YEAR, LENGTH, ACTORS, URL, DESCRIPTION, COMMENTS, VIDEOFORMAT, VIDEOBITRATE, AUDIOFORMAT, AUDIOBITRATE, RESOLUTION, FRAMERATE, LANGUAGES, SUBTITLES, FILESIZE, DISKS, VIEWDATE, PICTURENAME) VALUES ('0', '', '', '', '', '2008-08-12', '', '0', '', 'Amish in the City - Reggae, Never Heard of the Dude', '', '', '', '', '', '2005', '60', '', 'http://www.imdb.com/find?s=tt&q=Amish%20in%20the%20City%20-%20Reggae,%20Never%20Heard%20of%20the%20Dude', 'Reality series following young Amish people as they get their first experience of the outside world. The Amish kids grapple with LA''s public transport system, attend a music concert and indulge themselves at the races. ', '', '', '', '', '', '', '0', '', '', '0', '0', '', '');
INSERT INTO movies (NUM, CHECKED, MEDIA, MEDIATYPE, SOURCE, DATEADD, BORROWER, RATING, ORIGINALTITLE, TRANSLATEDTITLE, FORMATTEDTITLE, DIRECTOR, PRODUCER, COUNTRY, CATEGORY, YEAR, LENGTH, ACTORS, URL, DESCRIPTION, COMMENTS, VIDEOFORMAT, VIDEOBITRATE, AUDIOFORMAT, AUDIOBITRATE, RESOLUTION, FRAMERATE, LANGUAGES, SUBTITLES, FILESIZE, DISKS, VIEWDATE, PICTURENAME) VALUES ('0', '', '', '', '', '2008-05-29', '', '0', '', 'An Evening With Harry Belafonte', '', '', '', '', '', '2003', '57', '', '', 'Taped in Chicago in front of a live audience, Harry Belafonte was interviewed by his friend Danny Glover. The viewer will travel back in time to Mr. Belafonte''s early childhood: New York to Jamaica and back to New York, wherein he  experienced racism that was life altering. His frustrations propelled him to Humanitarian causes: marching with Martin Luther King, the Free South Africa movement, and We Are The World recording session and UNICEF to name a few.', '', '', '', '', '', '', '', '', '', '0', '0', '', '');
INSERT INTO movies (NUM, CHECKED, MEDIA, MEDIATYPE, SOURCE, DATEADD, BORROWER, RATING, ORIGINALTITLE, TRANSLATEDTITLE, FORMATTEDTITLE, DIRECTOR, PRODUCER, COUNTRY, CATEGORY, YEAR, LENGTH, ACTORS, URL, DESCRIPTION, COMMENTS, VIDEOFORMAT, VIDEOBITRATE, AUDIOFORMAT, AUDIOBITRATE, RESOLUTION, FRAMERATE, LANGUAGES, SUBTITLES, FILESIZE, DISKS, VIEWDATE, PICTURENAME) VALUES ('0', '', '', '', '', '2008-05-29', '', '0', '', 'Anansi', '', '', 'Fritz Baumann', '', '', '2002', '80', '', '', 'German director Fritz Baumann''s 2002 immigrant drama follows the paths of four Ghanaians as they begin a journey to Germany in the hopes of reaping the benefits of a capitalist society -- the likes of which are simply not to be found in their homeland. Things go from bad to worse for the four companions as they begin their trip by stowing away on a freighter, only to be caught by the crew a short time later. They are sent out to sea in a small raft and eventually beach on a remote coast that leads to the Sahara. After spending a number of days wandering about, they encounter a caravan that leads them to the Moroccan port of Tangiers. After a number of devastating challenges, the group finally reaches its destination -- but not without some substantial losses along the way.', '', '', '', '', '', '', '', '', '', '0', '0', '', '');
INSERT INTO movies (NUM, CHECKED, MEDIA, MEDIATYPE, SOURCE, DATEADD, BORROWER, RATING, ORIGINALTITLE, TRANSLATEDTITLE, FORMATTEDTITLE, DIRECTOR, PRODUCER, COUNTRY, CATEGORY, YEAR, LENGTH, ACTORS, URL, DESCRIPTION, COMMENTS, VIDEOFORMAT, VIDEOBITRATE, AUDIOFORMAT, AUDIOBITRATE, RESOLUTION, FRAMERATE, LANGUAGES, SUBTITLES, FILESIZE, DISKS, VIEWDATE, PICTURENAME) VALUES ('0', '', '', '', '', '2008-05-29', '', '0', '', 'Anansi Fantasia', '', '', 'Shirley Thompson', 'UK', '', '1993', '7', '', '', 'One of a series of short productions made by young black film- and video-makers, a dramatisation of a Caribbean folk tale in which trickster Anansi tries to find out a young woman’s secret name, the narration is by Jamaican-born community activist, Connie Mark (1923-2007).     Cast: Storyteller, Connie Mark, Anansi, Leon Hazlewood, Dora, Dollie Henry, King, Hi Ching , Missirolinkia, Lorraine Le-Blanc. Crew: Director of Photography Jeff Baynes, Gaffer Jim Lennon, Camera Assistant Tiffany Walker, Grip Martin McCullough, Sound Recordist Kim Joseph, Art Director Andrea Montag, Make-up Artist Michele Baylis, Stills Photographer Armet Francis, Catering H. E.Thompson, Production Manager Dominic DeVine, Production Supervisor Juliet McKoen, Off-Line Editor Peter Harvey, On-Line Editor Julian Bryant, Telecine Operator Dave Ludlam, Music Shirley Thompson, Music & Effects Recording Henry Thomas, Executive Producers Paul Corley, Rodney Wilson, Special Thanks to Anita Bell, Jason Glenister, Carol Jacobs, Michael Ho, Glen Laker, Bill Pretty, Richard Thompson, Greenwich Council, The Mill, SVC TV, Tattooist International Ltd., Theatre Royal, Stratford East. Produced and Directed by Shirley Thompson. For the Arts Council of Great Britain and Carlton Television. © Arts Council of Great Britain & Prime Productions 1993.', '', '', '', '', '', '', '', '', '', '0', '0', '', '');

7
Development / Re: PK's MovieDB dynamic website template
« on: October 28, 2008, 10:05:23 am »
I got the config file sorted now, i had the wrong password so i can now see the index.php ok. I made the new database in mysql etc.
but the problem i now have is when i try to import the .sql file it gives an error, it says 'Duplicate' i should have copied it for u to see but it highlighted the field YEAR and mentioned a duplicate in the database which gave an error. Any ideas what might be causing this?

I did change the way my pc shows the date, althought i only had the option to change the 'short date' as it says in windows options.
In PVD i actually do the dates liked: 21st Oct.2008 or 21/10/08  it changes.

8
Development / Re: PK's MovieDB dynamic website template
« on: October 28, 2008, 09:29:10 am »
Quote from: blue334 on October 27, 2008, 10:46:21 pm
Next, forget about exporting csv, it is not relevant to this. What you are exporting is sql script files with a .sql extension. If you haven't already you must copy the sql.ptm file to the ..\Personal Video Database\Plugins\Templates directory. DONE THIS OK That will make it appear as an option in the export dialog pulldown menu. Before exporting, you must make a subdirectory named "images" in the folder where you plan on saving the sql file DONE THIS AND I NOW SEE THE IMAGES ARE IN THERE. If you don't images won't go anywhere probably.

NB! After you have successfully created a file with .sql extension this goes into the database the same way the fields.sql file does DONE. But in this case the file will be much bigger, so it will not be practical/possible to paste its content in the sql query area in phpmyadmin. Instead you should go to the IMPORT tab, where there is an option to select the file from your hd and run it directly.

The database connection problem you experience is due to wrong credentials or other info in mdb_config.inc
Since you're with byethost, it should look somewhat similar to this:

$this->config['mysql']['server']    = "sql207.byethost9.com";
$this->config['mysql']['username']  = "b9_2508518";
$this->config['mysql']['password']  = "mypass";
$this->config['mysql']['database']  = "b9_2508518_movies";
$this->config['mysql']['table']     = "movies";


Since you deleted fields in the database you must delete/drop it completely and run the fields.sql query again.


Thanks for your help, i will redo the sql query and redo the database and redo the mdb config file, i think it's this that might be causing problems, u know the info u gave as an example of what it should look like, is this the only thing i should be changing? i altered a few more things on that file.

But even if the mdb config file was wrong, shoulkdn;t i have seen somehting when i tried to access the index.php file? i will redo it and see how i go this time.
Thanks again for all this help


9
Development / Re: PK's MovieDB dynamic website template
« on: October 27, 2008, 09:34:26 pm »
In the meantime i tried to import the data i had just to see what results i got, the first error is it says
#1054 - Unknown column 'VIDEOFORMAT' in 'field list'

this i guess will be due to some of the field titles not matching the ones on the mdb_config.inc file, or something to do with that anyway! something else i did while the database was created using the sql query, i deleted the fields that i didn't want to use form the database, this would have incluided the VIDEOFORMAT it mentions above, so maybe i get the error because the mdb_config.inc file is telling it to put this in ??

So i went to check that i could view the index.php file on my website which i had forget to do earlier and i cannot view it for some reason, it says 'cannot access XXX database with XXXX(my username) login, why it says that i have no idea, any suggestions?

hope im not hijacking this thread with my problems... :-\

10
Development / Re: PK's MovieDB dynamic website template
« on: October 27, 2008, 09:18:23 pm »
my other problem, i can;t find where pvd is saving all the posters/dvd covers! i checked the tools menu and it states a folder that doesn't exist! so im now very confused as to where pvd is saving everything, i have checked the pvd installation folder and there are no files in the posters folder either, any ideas where they may be saved or how i can find out where?

11
Development / Re: PK's MovieDB dynamic website template
« on: October 27, 2008, 08:57:01 pm »
I had more luck this time, i didn;t read your instructions properly first time and didn;t see that i had to copy the text for the sql query. anyway i seem to be doing ok with it now, the bit i want to ask youo about is where on your premade fields query which setup the database, it has pre done fields for title, description etc. can you tell me how does the script recognise these fileds in the database info you are importing, does it recognise the words eg. title, description? or does it go by the order you put them in?
I'm asking because my database does not have the same order as yours, or i don't want to use all the fields u have included like bitrate media format etc. so i'm wondering how this might effect things when i try to add the database info to the equation?

I'm guessing that i just need to remove the fields i don't want from the my sql database table right?
But then will i need to alter any other files?

****
I'm also noticing when i'm exporting the pvd, it exports to an excel csv file, but it is not exporting all fields, any idea why this might be? for example fields like Producer, Date Added, Length are not showing on the csv file, only these fields are importing:
Title;Original Title;Year;Genre;Country;Actors;Director;Description;   
I guess i have to configure it somehow.   
*i just noticed in the export configuration that only those selected fields mentioned where included in the export script, so i guess that explains why they only exported these, i looked at the sql export script and it includes lots more but it also includes lots that i don;t want, or don't use and don;t want showing in the final website.            


Would be very helpful if u can advise.


12
Development / Re: PK's MovieDB dynamic website template
« on: October 27, 2008, 11:53:17 am »
thanks for the reply Blue, yes i did spell the name wrong it is byethost like u said, very nice find, thnx for reccomending this.
Will try what u said and see how i get on next time. thnx for the help...

13
Development / Re: PK's MovieDB dynamic website template
« on: October 25, 2008, 11:59:28 am »
thanks for the reply, i am using the free webhost u suggested,bytehost, so i went to the mySQL bit and created a new database, then named a field or somehting like it explains in your instructions called Movies, but i did not get to do the mysql query as i did not get that option i think probabbly because i was using bytehost and not the other one. So it asked how many fields i wanted, i put 28, i got this number by counting the number of fields on my PVD entries, eg. movie name, description, date etc.
So thats where i got up to, any advice would be most apreciated. I am pretty knowledgable when it comes to computers, and web design etc but never used MySQL before.

14
Development / Re: PK's MovieDB dynamic website template
« on: October 24, 2008, 08:09:07 pm »
i setup a free webspace account, althought i do already have webspace but no MySQL on it, so i set a new one up as u reccomended but having big trouble trying to figure out how these mySQL work, i created a database, but it's giving me a table full of blanks which i need to fill in and im not familiar with the language they use on these database creation things in mysql. it's asking about singed and unsigned, Null, and lots of blanks i have no idea what there are all for, i managed to fill in my colum titles but it won;t save because it keeps saying this is not a number!

Any advice?

I love the website u created, just the kind of thing i've been trying to find for ages, i found lots of free web based databases but all of them are setout just like excel or similar, instead of laid out as a webpage, and this is the first time i've found one like this.

Does anyone know of a commercial product(that needs no advanced tecnical knowledge) which would setout a excel or pvd database on a website in a similar way to what your doing hear?



15
Feature Suggestions / Re: Vote: Features for 0.9.9
« on: September 07, 2008, 03:42:39 pm »
Not sure if anyone has suggested it yet but i think an import function for British Film Institute Database would make your database the best ever! It contains most UK TV broadcasts ever screened......

Or better still, is there any way you could include a customizable import function so that users could fill in pre set fields with the variables needs to import from such online databases? This would be excellent!

Great work your doing....

16
Support / importing posters
« on: June 08, 2008, 01:48:23 pm »
I'm having probs importing posters, i like to use mainly Amazon.com and i know that the posters exist on amazon.com yet the import plugin is not finding these films, is there any reason why the plugin isn;t finding them? does the plugin search for the file name as opposed to the film title perhaps? im just trying to figure out why the plugin is not finding the posters that i know are there.

17
Support / Re: Importing from Excel
« on: May 27, 2008, 06:31:11 pm »
if it accepts 'number of mins' without text after it then i will try the method of using the replace the word mins with nothing, then try to import again i guess.thanks for the suggestions

18
Support / Re: Importing from Excel
« on: May 25, 2008, 09:14:29 am »
thanks for the replies,
You said if i want to import data to my existing database i need at least 2 columns to import, eg. title, and length, the title so the database can ID where the stick the times.
But i'm still confused, Nostra said i'd need to keep the plugin configured for all fields when importing to an existing database, i understand this and then import it with Merge ticked, then it will fill in the blanks, but i don't understand what you are saying about working only with 2 columns at a time, how would you do this?
If i only selected to import title and length then surley the length would end up in my 'B' column which is my description column.

About the 'Length' columns, i have simply typed in the runtime like this: 60mins, 54mins etc. i have not done it like this 00:01:03:00hrs
I've always manually typed out my database or copied+pasted, i've never altered any settings on excel, does this make any difference?
Thanks for the piece of code you typed which would redo the times but i'm not familiar with how to actually use that sum you typed. But like i said the runtime is typed like 60mins.

19
Support / Re: Importing from Excel
« on: May 24, 2008, 08:43:47 pm »
Ok, so i just tried importing from excel again, this time using only 27 rows of data,
Problems i found.....

The 'Length' category was not imported at all, even though i asked it to while configuring the excel plugin.


This time the data does appear in the correct fields but the 'length' column is missing completely,

IF I'M INCORRECT IN WHAT I SAY BELOW PLEASE CAN SOMEONE TELL ME

I also now realize that the spelling of the column titles does not matter, and i see that regardless of the title of your colums in excel, the excel plugin configuration function is just used to select the column titles in order 1-2-3... of your new database. I previously thought that the plugin configuration was asking for words to recognise as titles in your excel database but this is not the case, the plugin configuration is just a way of selecting how many columns to import and what title you'd like to select for each column.


Maybe this should be added to a future help file, explaining that in the excel plugin configuration, the order in which you select what fields to import corresponds to the Column position,
for example:
If in the configuration i selected to import Title, Description, and Year in this order, then this would import my excel Column A to 'TITLE', B to 'Description' and C to 'Year' etc.

BUT WHAT I NOW DON'T UNDERSTAND IS, IT THE ABOVE IS CORRECT, THEN IF I WANTED TO IMPORT LETS SAY MY 'LENGTH' COLUMN AT A LATER DATE TO MY PVD. SO I'D CONFIGURE THE PLUGIN TO ONLY IMPORT THE LENGTH, BUT SURELY IF THE ABOVE WAS CORRECT THIS WOULD THEN IMPORT NOT THE LENGTH BUT COLUMN 'A' OF MY EXCEL DATABASE INTO THE PVD.

SO HOW COULD I GO ABOUT TRYING TO IMPORT ONLY THE LENGTH FIELD FROM MY EXCEL NOW?
(i just tried to import only the LENGTH field but nothing happened, probably because it see's the first column full of titles i guess)


i noticed that there is no need to save the data you have enetered into the database, it saves automatically i guess, this is a good thing in some ways but what do you do if you make a big mistake to your database then it autosaves! is there an undo or back button, i guess u just need a backup to hand which u backup regularly, it would be nice to see a save button with the option to turn off+on autosave function.




20
Support / Re: Importing from Excel
« on: May 24, 2008, 07:59:36 pm »
thanks for the help rick, i'm going to have another go using only a small number of rows in my database this time just to see how it goes, i'm unsure as to why the producer and year fields got mixed up but some where ok and some where not which was what made it strange, i will look into it some more and see if it works next time i try.
I'll let you know how i get on, and thanks again for the help.

Pages: [1]