www.bolidesoft.com Forum Index www.bolidesoft.com
Bolide Software
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

 
 
[Bolide Software Home] [All My Movies™ page] [All My Books™ page] [Image Comparer™ page]
 


Import custom fields from excel

 
Post new topic   Reply to topic    www.bolidesoft.com Forum Index -> All My Movies™ related
Author Message
mikey8it4u2



Joined: 15 Feb 2007
Posts: 7
Location: Manitoba, Canada
PostPosted: Thu Feb 15, 2007 2:59 pm    Post subject: Import custom fields from excel Reply with quote
Hi there.. I have been using "All My Movies" for a few years now and think it's the only good one out there. I know you can export custom fields to excel, but when I try to import from execl, the custom fileds are not avail. is there any way to mass import them??

Thanks for your Help..

Mike..
Back to top
bolide
Site Admin


Joined: 04 Aug 2005
Posts: 585
PostPosted: Thu Feb 15, 2007 7:45 pm    Post subject: Re: Import custom fields from excel Reply with quote
Please, wait for the update. I hope it will be available at this weekend.
Your issue is fixed
Back to top
mikey8it4u2



Joined: 15 Feb 2007
Posts: 7
Location: Manitoba, Canada
PostPosted: Thu Feb 15, 2007 9:50 pm    Post subject: Wow... That was fast.. Thank-you very much.. Reply with quote
This would be just great... Very Happy Very Happy Very Happy
Back to top
bolide
Site Admin


Joined: 04 Aug 2005
Posts: 585
PostPosted: Sun Feb 18, 2007 10:39 am    Post subject: Re: Wow... That was fast.. Thank-you very much.. Reply with quote
Check the latest build
Back to top
Mara



Joined: 18 Feb 2007
Posts: 2
PostPosted: Sun Feb 18, 2007 8:21 pm    Post subject: Entering Excel file into All My Movies Reply with quote
When I enter my excel list in All My Movies, he creates 2000 till 3000 movies!
I want to import 200 movies!! Why does it create 2000 till 3000, and how can I select the empty movie cells at ones and not by "delete"and "enter", while this takes me a lot (approx 2000 times) of clicking "delete" "enter". Can someone please help me with this problem!! Question Question Question
Back to top
bolide
Site Admin


Joined: 04 Aug 2005
Posts: 585
PostPosted: Sun Feb 18, 2007 8:32 pm    Post subject: Re: Entering Excel file into All My Movies Reply with quote
Mara wrote:

I want to import 200 movies!! Why does it create 2000 till 3000, and how can I select the empty movie cells at ones and not by "delete"and "enter", while this takes me a lot (approx 2000 times) of clicking "delete" "enter". Can someone please help me with this problem!!


You can delete empty rows in MS Excel before import XLS file to All My Movies
Back to top
Mara



Joined: 18 Feb 2007
Posts: 2
PostPosted: Sun Feb 18, 2007 10:32 pm    Post subject: Reply with quote
The other cells he copies from excel are not in use, but he imports anyway 1564 films. (200 are films and the rest are empty cells.
How do you explain that? Sad Question
Back to top
mikey8it4u2



Joined: 15 Feb 2007
Posts: 7
Location: Manitoba, Canada
PostPosted: Sun Feb 25, 2007 11:36 pm    Post subject: still having trouble importing custom fields from excel. Reply with quote
Ok I have updated to the latest ver. When I go to import from excel the custom fields are now available, however when the import is done it just appends the records to the end of the database and I end up with double the amount of records. Maybe I need to explain myself; here is what I want to do. I want to export certain custom fields to excel. Make mass changes or entries to those fields and then import those changes back into the database to update existing records. Is this even possible?? Can I open this database directly with another program to do a mass change??

Thanks for your help...
Mike..
Back to top
bolide
Site Admin


Joined: 04 Aug 2005
Posts: 585
PostPosted: Mon Mar 05, 2007 8:31 pm    Post subject: Reply with quote
Mara wrote:
The other cells he copies from excel are not in use, but he imports anyway 1564 films. (200 are films and the rest are empty cells.
How do you explain that? Sad Question


try to do the following:
- open MS Excel and your movie collection XLS file
- select your 200 movies and copy them to the clipboard
- create an empty XLS document, paste your movies and save
- use just saved document to import movies to AMM

I hope this helps
Back to top
bolide
Site Admin


Joined: 04 Aug 2005
Posts: 585
PostPosted: Mon Mar 05, 2007 8:35 pm    Post subject: Re: still having trouble importing custom fields from excel. Reply with quote
mikey8it4u2 wrote:
Make mass changes or entries to those fields and then import those changes back into the database to update existing records. Is this even possible??


When you use import from MS Excel, the movies you got from XLS will be always added to the existing ones. You can create an empty database and import your movies.

You can open AMM database with MS Access.
Or you can try to use MassPlugin for mass updates.
Back to top
Display posts from previous:   
Post new topic   Reply to topic    www.bolidesoft.com Forum Index -> All My Movies™ related All times are GMT
Page 1 of 1

 


Powered by phpBB © 2001, 2005 phpBB Group