Import an excel/csv file?

by **scott** on Tue Oct 11, 2005 4:11 pm

Hi I am looking for guidance on how to import data from an excel sheet. I was thinking along the lines of something like the DVD profiler import. If i remember correctly that data is saves as a csv file and then XL takes the data and populates the appropriate fields.

If there is anyone here who could help me with this I would greatly appreciate it

Thanks

by **dgemily** on Tue Oct 11, 2005 5:21 pm

I use Ant Movie Catalog to import my csv files, then the plugin xant to export it in xlobby.

by **scott** on Tue Oct 11, 2005 6:08 pm

Thanks for the quick reply

I looked at the Ant software but I dont think it will do what i want. I currently have an excel sheet that tracks the contents of my wine collection. the fields that I populate are:

Wine,Quantity,Pending,Size, Price,Valuation,Vintage,Wine,Locale,Country,Region,SubRegion,Appellation,Producer,SortProducer,Type,Varietal,MasterVarietal,Designation,Vineyard....and a few others on seperate sheets.

I have no real programing experiance other than creating excel sheets. My goal is to integrate this data into XL so i could page through the contents of my cellar and track its contents. I envision this like scrolling through the DVD tabe, where a picture of the cover appears (i would substitute pic of lable) and ther along the side would be displayed basic stats about the current selection.

In theory this sounds pretty easy, i should be able to just modify an existing database, like the dvd. In reality I dont really know where to start the process, and then there is the problem of importing all this data.

If I were able to change the field names in Ant from "movie" to "Wine" and so on it would work. It appears that is not possible

Thanks

by **badubo** on Tue Oct 11, 2005 7:03 pm

Check in the Languages folder of AMC, you will see the file English.lng

you can modify it to your needs (pay particular attention to strings like Fields.Strings.String[0])

You have to remember which original string you replaced by your (in order to make the relation with XAnt)

Then you can import using "Import from CSV"

by **scott** on Wed Oct 12, 2005 7:56 pm

HI badubo
I looked through the AMC software for the language folder you mentioned but was unable to find what you were talking about. I also downloaded the rename software. Could it be that was what you were referring to? Where can i find the fields to rename them I am lost here. Thanks in advance.

by **badubo** on Wed Oct 12, 2005 7:59 pm

Which version did you install?
If you use the full installer, you have a directory "Languages" under "c:\Program Files\Ant Movie Catalog"

by **C-moi** on Thu Oct 13, 2005 5:20 am

I also downloaded the rename software. Could it be that was what you were referring to?

no : i use also the rename software : you have to use Ant Movie Catalog and search in the file English.lng in c:\Program Files\Ant Movie Catalog\Languages\ folder
Make a copy of this file, rename it and open it with notepad

Code: Select all: ActionFileNew.Caption=&Nouveau

change :

Code: Select all: ActionFileNew.Caption=&New

save

by **scott** on Thu Oct 13, 2005 7:43 pm

C-moi

Thanks I found and opened the file in notepad, i copied the original english file and renamed it englishoriginal I then changed the field names as needed ex:

from
Fields.Strings.String[0]=Number
Fields.Strings.String[1]=Checked
Fields.Strings.String[2]=Media Label
Fields.Strings.String[3]=Media Type
Fields.Strings.String[4]=Source
Fields.Strings.String[5]=Date added
Fields.Strings.String[6]=Borrower
Fields.Strings.String[7]=Rating
Fields.Strings.String[8]=Original Title
Fields.Strings.String[9]=Translated Title
Fields.Strings.String[10]=Formated Title
Fields.Strings.String[11]=Director
Fields.Strings.String[12]=Producer
Fields.Strings.String[13]=Country
Fields.Strings.String[14]=Category
Fields.Strings.String[15]=Year
Fields.Strings.String[16]=Length
Fields.Strings.String[17]=Actors
Fields.Strings.String[18]=URL
Fields.Strings.String[19]=Description
Fields.Strings.String[20]=Comments
Fields.Strings.String[21]=Video Format
Fields.Strings.String[22]=Video Bitrate

To:

Fields.Strings.String[0]=iWine
Fields.Strings.String[1]=Quantity
Fields.Strings.String[2]=Pending
Fields.Strings.String[3]=Size
Fields.Strings.String[4]= Price
Fields.Strings.String[5]= Valuation
Fields.Strings.String[6]=Vintage
Fields.Strings.String[7]=Wine
Fields.Strings.String[8]=Locale
Fields.Strings.String[9]=Country
Fields.Strings.String[10]=Region
Fields.Strings.String[11]=SubRegion
Fields.Strings.String[12]=Appellation
Fields.Strings.String[13]=Producer
Fields.Strings.String[14]=SortProducer
Fields.Strings.String[15]=Type
Fields.Strings.String[16]=Varietal
Fields.Strings.String[17]=MasterVarietal
Fields.Strings.String[18]=Designation
Fields.Strings.String[19]=Vineyard
Fields.Strings.String[20]=Begin
Fields.Strings.String[21]=End

I deleted the extra fields. I then saved the file. I went to the main AMC program and select
>file
>import
>CSV box
>then i navigate to my csv file. the app locks up, shows "not responding " in task manager

There must be something i am missing. Assume I know nothing about programming(not a big leap there) I think I am making progress and appreciate the time you guys are spending helping me with this.

by **C-moi** on Thu Oct 13, 2005 9:15 pm

sorry for my bad english !
I import a .csv file with AMC as you can see on this screenshot : you have to select a field (1) here and press on the rectangle (2) for Original Title on this example or (3) Translated Title...
You must associate each field of your .csv file with each field you created here

Fields.Strings.String[0]=iWine
Fields.Strings.String[1]=Quantity
Fields.Strings.String[2]=Pending
Fields.Strings.String[3]=Size
Fields.Strings.String[4]= Price
Fields.Strings.String[5]= Valuation
Fields.Strings.String[6]=Vintage
Fields.Strings.String[7]=Wine
Fields.Strings.String[8]=Locale
Fields.Strings.String[9]=Country
Fields.Strings.String[10]=Region
Fields.Strings.String[11]=SubRegion
Fields.Strings.String[12]=Appellation
Fields.Strings.String[13]=Producer
Fields.Strings.String[14]=SortProducer
Fields.Strings.String[15]=Type
Fields.Strings.String[16]=Varietal
Fields.Strings.String[17]=MasterVarietal
Fields.Strings.String[18]=Designation
Fields.Strings.String[19]=Vineyard
Fields.Strings.String[20]=Begin
Fields.Strings.String[21]=End

then press on Import button (4)
If you want i can try to import your .csv file in amc and make the template for xant ...asap

by **scott** on Thu Oct 13, 2005 10:32 pm

C-moi

[quote] If you want i can try to import your .csv file in amc and make the template for xant ...asap[/quote

Thank you very much, that would be great. should I e-mail the file to you?

Scott

by **C-moi** on Thu Oct 13, 2005 10:39 pm

my email
jp.onthewebATfree.fr

by **scott** on Fri Oct 14, 2005 1:12 am

hi C-moi

I tried sending the file to you using 3 different e-mail programs; Hotmail, Outlook through my company, and my local ISP. all three rejected the e-mail address you put on the forum: jp.onthewebATfree.fr my addresses are mailto:sklym@hotmail.com
mailto:sklym@optonline.net

it may be possible for me to reply to an e-mail from you.

I dont know why it is not going through but tahat is where I am stuck.

Thanks

by **C-moi** on Fri Oct 14, 2005 5:17 am

i send you an email :wink:

by **scott** on Fri Oct 14, 2005 10:01 pm

C-moi

I sent the file. Did you recieve it?

Scott

by **C-moi** on Fri Oct 14, 2005 10:31 pm

yes !
i send you the template, the language file for Ant Movie Catalog, the .amc database, a little screen for trying ....
Did you try it ?