English > Support

Importing Episodes

<< < (4/4)

Testing_Business:
Sure.

I created a view selecting some fields from both movie and episode.


--- Quote -----View: VIEW03

--DROP VIEW VIEW03;

CREATE VIEW VIEW03
(
  MID,
  TITLE,
  PATH,
  EPID,
  EPNUM,
  SEASON,
  MID01
)
AS
SELECT
  MOVIES."mid",
  MOVIES."title",
  MOVIES."path",
  EPISODES."epid",
  EPISODES."epnum",
  EPISODES."season",
  EPISODES."mid"
FROM
  MOVIES
  LEFT OUTER JOIN EPISODES ON (MOVIES."epid" = EPISODES."epid");
GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES
  ON TABLE VIEW03
TO VIEW VIEW03;


--- End quote ---

I granted full permissions and full grants.

I then imported data in csv format for those fields assigning proper columns. But when I tried to import I got the message I described. I don't know if there is a default somewhere (in the server or meastro) that only loads the pvd file in read-only? Am I missing an option somewhere?

Testing_Business:
I have understood the issue. I believe the problem is that only one table can be updated at a time.

I think it was a valid try if certain fields in the tables could be selected and then data could be imported for those fields. Unfortunately for that to work the rest of fields are filled with NULL values.

There are too many fields constraints for that to work so data cannot be imported in large amounts directly through Maestro.

Will just have to wait until you develop a script for importing episodes from a text file.

nostra:
All right. This feature will probably be available in version 1.

Navigation

[0] Message Index

[*] Previous page