Integrate Movie Magic Scheduling with Google Calendar

So I receive a couple of messages asking how I created this integration between Movie Magic Scheduling and Google Calendar. Instead of answering one by one, I decided to create this tutorial that teaches how to do the integration.

The process is pretty simple. We have to create a CSV file using Movie Magic Schedule. To do that we need to run a REPORT that will transfer all the database info into a pdf file and save this pdf to a CSV file.

In order to do that you need the following software:

  • EXCEL
  • WORD
  • ACROBAT READER
  • MOVIE MAGIC SCHEDULING

PART 1 – CREATING THE PDF FILE

Download and import the following report that I created.

CALENDAR EXPORT – BY MARIO AMADEU.

To import a calendar you have to open a Movie Magic Schedule, click on DESIGN, a list of Report Layouts will appear, click on the IMPORT ICON, select the downloaded file and voilà.

A report called Calendar Export by Mario Amadeu will show up. Run the report by double clicking on it and then click on Print Preview. The content generated will be barely readable, don’t worry about that because I did this way so the whole information stays in one page for exporting purposes. Print the file as PDF so you can transfer to excel. The first part is done.

PART 2 – CREATING THE CSV FILE

Open the generated PDF file, rotate 90 degrees clockwise, and save. Select all, copy and paste to a word Document.

Every line should have a set of information. For some reason the line breaks messes up sometimes when copying and pasting to word. Because of that, I created one more step on word just to make sure everything will be smooth. With the text copied to word, go to EDIT->REPLACE. In the field “Find what:” type “}”, and in the field “Replace with:” type “^p”. Hit REPLACE ALL button.

Note: if the line breaks are fine, then replace “}” with a “blank space”

Save the file as txt. Open Excel and click on DATA->GET EXTERNAL DATA->IMPORT TEXT FILE. Open the text file created on word and a Text Import Wizard will open.

On step one choose Delimited;
On step two select Semicolon;
On step three select the second column and change the data format to DATE MDY
Hit finish.

The excel file will be created. Select the column B, START DATE, and format the column as a DATE with format MM/DD/YYYY. Save the file as CSV. DONE.

PART 3 – IMPORTING TO GOOGLE CALENDAR

This is the last step. To import to Google calendar, you have to open Google Calendar and under OTHER CALENDARS click on ADD->IMPORT CALENDAR. Browse for the csv file you just created, select the calendar to export to, and hit IMPORT.

If for some reason you get an error message, open the CSV file on Excel and break the table down in less records. Save 2 or 3 CSV files, each one containing 30 lines maximum. Repeat the first line with the header and save it for each one. Import the files into Google Calendar. DONE.

CONCLUSION

The good part of this integration is the fact that you can add cast and crew to the calendar, they can see details like maps, description, synopses, page count, estimated time and comments. I am pretty sure that more features will be created in the future, and maybe in a next version of Movie Magic Scheduling we will have this integration built in.

What I am working now is creating fields for call time and more detailed information like inserting day breaks and so on.If anyone figures new things, please comment here and share with the world. Thanks.

Rosa Morena

Neste Domingo dia 5 de junho fui assistir ao filme Rosa Morena que estava sendo exibido no Hollywood Brazilian Film Festival. A minha irmã Miriam Amadeu participou deste filme com uma personagem fantástica.

O filme trata-se da história de um Dinamarquês, Thomas (Anders W. Berthelsen), que vai para o Brasil tentar adotar uma criança. Pelo fato de ser homossexual, Thomas enfrenta grandes obstáculos que o impedem de adotar uma criança na Dinamarca. A personagem que a minha irmã faz é a primeira tentativa real de Thomas na busca de seu sonho.

O filme é muito bem feito com atuações verdadeiras e com um roteiro real e denso. Os personagens tem muita profundidade e os diálogos são sinceros. O que mais marca no filme é a perfeita combinação de humor e drama. Homossexualismo é um tema que para ser tratado precisa-se muita coragem e sutileza. O filme lida com o drama dos personagem de forma humana, e não levanta bandeiras que possam gerar polêmica. Eu acredito que que a audiência vai se identificar com a história independentemente  da opção sexual ou da opinião sobre o assunto. Esse é o motivo que mostra o brilhantismo dessa produção.

O filme foi produzido com capital Dinamarquês e Brasileiro. Um dos produtores do filme é o Ivan Teixeira. Conversamos um pouco ao final da apresentação e fiquei muito contente de conhecer um profissional brasileiro tão talentoso e simpático.

O video acima é uma das cenas que a minha irmã faz. As fotos abaixo são do Grauman’s Chinese Theatre em Hollywood lotado durante a apresentação do filme.

Grauman’s Chinese Theatre
Miriam Amadeu
Anders Berthelsen
Miram Amadeu

New Feature Film in New York

I am doing the pre-production of a new feature film based in New York.

The director called me from over there and hired me to work for him at a distance. I couldn’t physically travel to New York because I am doing physical therapy and my doctor didn’t allow me to work yet. So we agreed that I would do the scheduling, budgeting, and breakdown before the principal photography starts.

For this production I am using the Movie Magic screenwriter, Movie Magic Scheduling, and Movie Magic Budgeting. These software are really good. They are very helpful with the whole process of pre-production.

The advantages of these software over other software, like Celtx for example, is the industry standard interface. Pre-production of films in Hollywood is made the same way for a long time. Scheduling a feature film is a three-part process: 1 – breakdown the script, 2 – preparing a production strip board, and 3 – determining the final shooting schedule. The movie magic package helps a lot with this process. Little things like the color coding, break down categories, and full integration between script, schedule and budget are key to the creation of a well structured pre-production. Then we have more advanced tolls like Report Design, Day out of Days control, Red Flags features, Calendar Management, and Element linking that makes the scheduling process way more precise.

Another good aspect of the Movie Magic package is that the company who creates the software gives a couple of courses for free. Right now I don’t have time to do them, but as soon as I finish this schedule I might take some courses. I might be able to catch little and more advanced things that I wouldn’t otherwise.

The main production of the film is scheduled to start in July. I am having a lot of work to put everything together as fast and accurate as possible. So far I am doing fantastic. My job is to manage everybody schedule, solve this jigsaw puzzle, and deliver the schedule and budget in two weeks.

 

AFM

American film market is one of the biggest film markets in the world.

It is a good place to meet people from all over the place and make especially business connections.

My first impression of the AFM was like this:

It takes place in a beach front 5 star hotel reserved for production companies to sell their films. Each room is a company that has different titles. If some one has a green badge means that this person is a buyer. Purple badge means production company, Red/orange means industry professional and no badge means loser.

If you have a purple you want to talk to green badges and eventually red/orange badges. You don’t want to spend a second with purple and definitively no badges. People with no badges can be annoying. We learned not to trust a buyer that doesn’t have a badge, because badges are expensive. A minimum of $500for a buyers badge.

There is also a distinct status according to the floor that a production company is located. If the company is bellow the 5th floor, their status is not as good as someone who is in the 5th up. The 2nd and 3rd floor are called The Dungeon. They are cheaper and usually the production companies that are there are lower budget. There are a lot of Asian companies in the dungeon, but the quality of their posters and the content of their actions films are not as bad as expected from companies that are in theses floors. The 4th floor is where the lobby and the no badges are. It’s a chaos to stay there. Buyers don’t usually talk to people over there because they suffer a lot of hassle. It’s a waste of time to try to network at the lobby. There are companies in the lobby too, but their budgets are not very high as the ones on the 5th floor up.

 

The 5th floor is a better floor, even with part of it opened to the public where you can find no-badges there as well. The 6th floor is the beginning of the respect. That’s where I was working on. It costs a lot of money to rent a room in the 6th floor. The company that I worked for spent about 30k.

 

The 7th floor is way better and the 8th floor is where the big boys are. Lionsgate, Weisntein, and other are located in the 8th floor. They don’t even look at your face if you are not a buyer. They have the presidential suites and they treat a production company like a filthy dog. “There is no leftover for you here. Go away!”

 

Overall it is a place where business is made. Even with those notions of social separation, AFM is nothing more than an open fair. When I was younger, I used to go with my father to the open market to buy groceries. The simple elements of the open market on the Brazilian streets I saw at the AFM. The banana vendor needed to make noise, scream sometimes, and loudly reinforce that he had a better deal with a better product then his fellow, and sometimes quieter, next-door seller.

BRANDO UNAUTHORIZED – San Clemente

I am here at the backyard of a beautiful house in San Clemente, Orange County. Tonight is the last day shooting at this location. This place has breath taking views. The people are warm and everybody seems to like us.

I will give a back story to this production. It was a low budget film, shot with no permits and literally on spot decisions every single day. I had to manage a crew of 35 people average and come up with decisions that would keep us motivated, on schedule, and under budget.

We faced all sort of troubles during this second week of production. Starting with the sudden change of location on Tuesday. We were shooting in Burbank and the idea was to shoot there for at least 3 days with the possibility of shooting 5 days total. Well, the very first day we had the cops getting there all the time. Instead of telling the truth and get over with it, some production people lied to the cops saying that we were doing a party and not a film. Cops by nature are dogs searching for lies. They knew that something was up. We had no permits and on top of that, the neighbors were calling the police all the time.

We ended up shooting one day and a half. The cops, neighbors, vibe, nothing was working. The solution was to move some where else. That’s when we decided to go to San Clemente at Rusty’s House. His wife Debbie opened the house for us and let us use the place for 5 days. We not only used her house but we shot at her neighbor’s house. Her name is Alice.  We were also fortunate to shoot in a multi million mansion overlooking the ocean, which in my opinion was one of the best locations we got.

I had the pleasure to work with a guy that randomly appeared one day on set as an extra and I hired him to be my personal helper. His name was Steve and he had no experience whatsoever in the film business. The very first day of work he managed to help me find the multi million dollar location. He got a hold of a guy called Berry who is one of the most generous person that I had the pleasure to meet lately. He is a very known person by everyone in San Clemente and also a real gentleman and a good friend of Rusty. By the fact that he is so well connected, he managed to get us the place in less than one day. I believe that God provides if one keeps a strong heart on everything that one does. Berry told me so many good things that I will keep for the rest of my life. That day was magical.

Right now we are wrapping the last scene of the day. Today I had to do the 1st AD job because the 1st AD had personal problems. Well, I am here typing on the computer because my actors for the last scene are doing the make up. I felt like writing this post because I think this moment is a very special moment in my life. I will get married in a couple of weeks from now, I am finishing my 2nd feature in less than one year, and I will graduate on my 2nd university this semester. The most important is that I feel God closer to me everyday. He is my best friend, and everything is possible because of Him. Thank You.

 

First part of the film almost done

We are taking 5 days off and we will start production back again this Sunday, December 20. Ron Quigley (dir./e.p./lead) had to travel. His brother with cancer unfortunately past away. We were about to wrap our second week shooting, and the bad news came. Ron tried to hold on and keep going. This is a lot to handle. The best thing for him to do was visit his family, spend some time away, recharge batteries, and come back renewed.

The good part is that the production is on schedule, footage looks amazing, performances are believable, crew is getting along pretty well, workflow is  in shape. I’m pretty confident that Ron is happy with the work that everybody is doing. As for me, I am really happy with my work too. I am feeling more confident about the work that I do. I can manage the crew better now than I ever managed before. We are always getting good results. Best of all, I am making new friends.

Everybody is amazing. I don’t want to leave anyone behind, but as far as I remember there are in the

– camera/grip department John, Pat, Mark, Tra, Bobby
– make up Deonna,
– Art department with Stacy and Adam,
– production with Edward, Suzana, Rich, Felipe Costa, Coco,
– stills by Maria, and Kevin
– catering by Chris,
– audio by Kevin,
– cinematography by Peter Lugo,
– and direction by Ron.

stills in this post by Kevin.

Everybody is doing an amazing job. There is an excitement every time we call action. I hope this excitement will follow us wherever we go.
I hope that Ron’s brother is resting in peace now. I dedicate my work in his name. May God bless his soul.

Start of production and engagment

Tomorrow we will start the film. The guys had already being there today for a test shoot and pre light the set. I was not able to go because I had to get done with a bunch of school work. I had even a test of one of the best classes I ever took: grip. Good thing is that I nailed the test. I am getting my school done and I am ready for the film.

We are going to start tomorrow from 7 am to 7 pm. It’s a lot of work but we are getting more people to work with us. Today I met a guy that wants to take some still photography of the film. That’s great. I hope he can join us.

There is also one more thing that I would like to mention.
I am an engaged man. I will marry my princess. She didn’t know that I planned to propose to her on thanksgiving. I prepared everything for when the moment would come. I even taped the whole thing with a hidden camera. It was awesome. I was very nervous and stressed out. My neck was killing me since I decided to take this step. It was about one month ago. I called her parents and they were happy with the news. We will figure our plans after I am done with the film and she is done with her finals at school. Now the world is opening to a new perspective. New adventures. New challenges.

I pray that God will bless the end of 2009.
Amem.

POSITIVE – A Test of life

I am working on my first 20 minutes short film.
There are many challenges in order to make this film a reality.
Location is hard to find when you don’t have money and crew. I need to count on other people’s help and it is just not that easy.
Thank God I do have some good people helping me. My right hand man is FELIPE COSTA. He is one of the most talented and responsible person I’ve ever met. Coco Cook also is a great professional and she really knows how to handle everything I ask her.

This Thursday night I have my first shooting scheduled. It’s going to be the nightmare sequence, where the main actress Veronika is going to dialogue with herself. That’s crazy huh!!! My teacher will help us to make it happen. He is the best cinematographer I meet in my whole life. I will have the pleasure to work with him. His name is Charles Haine.

Tomorrow I have my first meeting with my main casting. We are going to discuss relationship, objectives, background story, and so on. It is important to discuss the schedule also.

Tonight i will call my crew and let them know that we are going to be ready to go.
I pray for God to bless this project.