Import Excel in CATVids

Discuss using and your tips/tricks for CATVids
Post Reply
User avatar
Alex Ivanovich
Posts: 311
Joined: Mon Sep 07, 2015 2:24 pm
Location: Russian - Italia

Import Excel in CATVids

Post by Alex Ivanovich » Fri Sep 28, 2018 8:24 am

As a title, I should export data from excel
I'm testing, but I can not do what I want
problem
The titles of the films are imported but the content actors in the field "Leading Role" I can not :|
It displays an error :roll:
does anyone help me?

thank you
Attachments
Cartel1.xlsx
file Excel
(10.66 KiB) Downloaded 10 times
Cattura 1.PNG
Cattura 1.PNG (36.7 KiB) Viewed 292 times
Cattura 2.PNG
Cattura 2.PNG (11.05 KiB) Viewed 292 times
Last edited by Alex Ivanovich on Wed Oct 17, 2018 5:51 am, edited 5 times in total.

User avatar
Alex Ivanovich
Posts: 311
Joined: Mon Sep 07, 2015 2:24 pm
Location: Russian - Italia

Re:Import Excel in CATVids

Post by Alex Ivanovich » Fri Sep 28, 2018 8:26 am

I insert another screen
Attachments
Cattura 3.PNG
Cattura 3.PNG (34.56 KiB) Viewed 290 times
Last edited by Alex Ivanovich on Tue Oct 02, 2018 8:26 am, edited 1 time in total.

User avatar
DougWilliams
Site Admin
Posts: 256
Joined: Thu May 22, 2014 11:36 am
Location: Wisconsin, USA
Contact:

Re: Export excel files to CATVids

Post by DougWilliams » Sun Sep 30, 2018 11:36 pm

Do you want to EXPORT from CATVids or IMPORT into CATVids?
Your screen shots and your text conflict.
Record Collector
"You Mean I'm Supposed To Listen To 'Em?!?!?!?"

User avatar
Alex Ivanovich
Posts: 311
Joined: Mon Sep 07, 2015 2:24 pm
Location: Russian - Italia

Re: Export excel files to CATVids

Post by Alex Ivanovich » Mon Oct 01, 2018 2:36 pm

Hello DougWilliams, :)
sorry for the late reply
I want to import from Excel to CATVids
video table is imported ;)
contents no :| , exactly it should import into the field "Leading Role"
I do not understand :roll:

User avatar
Alex Ivanovich
Posts: 311
Joined: Mon Sep 07, 2015 2:24 pm
Location: Russian - Italia

Re: Import Excel in CATVids

Post by Alex Ivanovich » Tue Oct 02, 2018 8:28 am

correct the title
I did a bit 'of confusion :lol:
no one helps me? :roll:

User avatar
DougWilliams
Site Admin
Posts: 256
Joined: Thu May 22, 2014 11:36 am
Location: Wisconsin, USA
Contact:

Re: Import Excel in CATVids

Post by DougWilliams » Wed Oct 03, 2018 1:24 am

Here's what I came up with. see the attached excel for data format.
Image1.JPG
Image1.JPG (52.37 KiB) Viewed 242 times
Image2.JPG
Image2.JPG (52.19 KiB) Viewed 242 times
image3.JPG
image3.JPG (55.98 KiB) Viewed 242 times
image4.JPG
image4.JPG (79.33 KiB) Viewed 242 times
Attachments
Cartel2.xlsx
Linda Blair movies
(12.67 KiB) Downloaded 13 times
Record Collector
"You Mean I'm Supposed To Listen To 'Em?!?!?!?"

User avatar
Alex Ivanovich
Posts: 311
Joined: Mon Sep 07, 2015 2:24 pm
Location: Russian - Italia

Re: Import Excel in CATVids

Post by Alex Ivanovich » Wed Oct 03, 2018 5:17 pm

HI DougWilliams,
thanks for your help :)

Interesting, I had not considered the "ID" :roll:

Questions:

1) #ignore, what does this mean? it is necessary? :roll:

2) how do I understand which "IDs" are available,
this works fine with an empty database, but if I have a databe with many movies with their "ID" how do I establish which one is available?
same speech for the actors and their "ID" :|

3) how to manage duplicates :|

User avatar
Alex Ivanovich
Posts: 311
Joined: Mon Sep 07, 2015 2:24 pm
Location: Russian - Italia

Re: Import Excel in CATVids

Post by Alex Ivanovich » Wed Oct 03, 2018 6:43 pm

I noticed a problem
"Leading role" and imported
but in the "Credits" tab of Linda Blair and empty :roll:
Attachments
Cattura 1.PNG
Cattura 1.PNG (62.83 KiB) Viewed 230 times
Last edited by Alex Ivanovich on Thu Oct 04, 2018 2:16 am, edited 1 time in total.

User avatar
DougWilliams
Site Admin
Posts: 256
Joined: Thu May 22, 2014 11:36 am
Location: Wisconsin, USA
Contact:

Re: Import Excel in CATVids

Post by DougWilliams » Thu Oct 04, 2018 12:54 am

1) #ignore, what does this mean? it is necessary?
For each unassigned column you need to use the #ignore
2) how do I understand which "IDs" are available, this works fine with an empty database, but if I have a databe with many movies with their "ID" how do I establish which one is available? same speech for the actors and their "ID"
Importing will ALWAYS create new records. You cannot update existing records with import.
3) how to manage duplicates
I believe this to be related to my #2 answer.
I noticed a problem "Leading role" and imported but in the "Credits" tab of Linda Blair and empty
I have not found a way to import the actor AND their characters name.
Record Collector
"You Mean I'm Supposed To Listen To 'Em?!?!?!?"

User avatar
Alex Ivanovich
Posts: 311
Joined: Mon Sep 07, 2015 2:24 pm
Location: Russian - Italia

Re: Import Excel in CATVids

Post by Alex Ivanovich » Wed Oct 17, 2018 5:50 am

ok, thanks for your help

Post Reply