English > Support
Can't get Excel import to work at all - any ideas?
rick.ca:
--- Quote ---The original 1300 or so line Excel sheet would lead to a crash with a message from PVD about Continue/Abort etc, but would always end with nothing changed.
--- End quote ---
Using version 1.0.2.2, I tested imports of 2,000, 1,000 and 100 records. They all completed without error, suggesting it's not the number of records that's causing the problem. I'm reminded the import is rather slow—about one record/second on my system. Is there any chance you were trying to do other things with the program when the error occurred? It may have something to do with the content or the of data being imported (I was importing only a flag). It would be helpful if you could reproduce the error when the program is running with the -debug switch, and then send the exception report. It don't believe the plugin has changed since 0.9.9 (assuming that's what you're using), so if the problem is with the plugin it likely persists.
Data1001:
Roy -
Just chiming in that I used the Excel import plugin successfully this week, but was having troubles using it with v9.9.21, so I downloaded the latest beta version of PVD, and it worked great. (I can't vouch that the switch from the stable release to the preview release is what made the difference, however, since I did also make some changes to the Excel spreadsheet during that time, as well.)
The Excel document that I used has over 2700 rows.
I did make sure I had the columns organized a certain way, though. First column was ID (which I put the exact same thing I had in my 7th column, LOCATION). The second column was TITLE. Third column, YEAR; fourth column DESCRIPTION; fifth, COMMENTS; sixth, RELEASE DATE; and seventh column, LOCATION (which, in this case, since I was importing records of my videotapes, was the number I assigned to each particular VHS tape -- i.e., 823-01 or ST-A-01). The "type" format of all columns except DATE was formatted as Text. All columns had a header row.
There was a lot of babysitting while I was importing, but despite the time it took, it was a pretty easy method of getting over 2,700 titles into the database, relatively speaking.
Roy22:
--- Quote ---Is there any chance you were trying to do other things with the program when the error occurred?
--- End quote ---
Only in terms of the PC video processing other stuff, which I expected to slow PVD down, though not crash it. Or do you mean something else with PVD, as I'm not aware you can get it to do more than one thing at once?
--- Quote ---Just chiming in that I used the Excel import plugin successfully this week, but was having troubles using it with v9.9.21, so I downloaded the latest beta version of PVD, and it worked great.
--- End quote ---
I am using 9.9.21. By 'having troubles using it with v9.9.21' do you mean something similar to my experiences? It may be that something has been knowingly or unknowingly fixed in the beta release.
I'll try and get the crash data you requested.
Data1001:
--- Quote from: Roy22 on January 22, 2012, 02:11:52 pm ---
--- Quote ---Just chiming in that I used the Excel import plugin successfully this week, but was having troubles using it with v9.9.21, so I downloaded the latest beta version of PVD, and it worked great.
--- End quote ---
I am using 9.9.21. By 'having troubles using it with v9.9.21' do you mean something similar to my experiences? It may be that something has been knowingly or unknowingly fixed in the beta release.
--- End quote ---
Honestly, I was having so many issues with other things this week (mainly trying to use both the stable release and the beta at the same time and corrupting my configuration file -- but that's another story), I don't completely recall the issue with importing from Excel, but as my memory serves me, when I tried the import initially, it just hung there and didn't do anything.
I would suggest you install the beta version and see if that makes any difference for you. Then, if it does, you can decide whether you want to start using the beta release exclusively (which is what I'm doing). Just make sure to back up your database first -- you won't be able to open the database in the stable version of PVD once it's been opened in the beta (preview) release of the application. And also when you run the beta, make sure you do what I should have done in the first place, and run it with the "-portable" switch (without the quotes) -- that will keep your configuration files separate between the two versions.
Roy22:
This may have been covered elsewhere, but is the beta version anywhere near become officially released? I usually like to let others get the nasty surprises first. ;)
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version