Programming Office & Sharepoint Application with Marianne van Wanrooij

[Athman]

WELCOME TO OUR SECOND
EVER GLOBAL MEETING

VERY EXCLUSIVE

FOR THE CAIRO.CODE.CAMP EVENT

WHICH WILL HELD
IN THE 27 -28 TH THIS MONTH AT THE GERMAN UNIVERSITY

WITH . OUR . VERY . GUEST . HOST

organiser of 2 user groups; DIWUG (Dutch Information Worker User Group) and I'm track owner of the SDN (Software Developers Network) Information Worker section

AND SHE IS SPECIALISED IN PROGRAMMING WITH OFFICE AND SHAREPOINT

With Our Topic that we are going to discuss

((•:*¨`*:• •
Office Programming and Sharepoint• •:*¨`*:•))

((•:*¨`*:• •برمجة تطبيقات أوفيس و مايكروسوفت شيربوينت• •:*¨`*:•))

.

So With That Been Said Lets Jump to The Discussion

DONT . GO . AWAY

[Athman]

This Question By
●۩۝۩● -Athman- ●۩۝۩●

So we know that you will headlining the CairoCodeCamp event

can you give to us details abt what you are going to do in the event
how many session and what is the sessions going to be abt

[Marianne van Wanro]

Hi there..
First of all thank you for inviting me for this forum. This year is the second time I 'm visiting Cairo for the Cairo Code Camp. This year I'm giving three session. 1. Customizing the SharePoint 2010 UI, 2. SharePoint Nightmares about the don'ts and software boundries in SharePoint 2007 and the 3rd session is together with Remi Caron -who is sitting next to me at this moment- A SharePoint Battle where we'll let the audience challenge us to do Out of the Box solutions on SharePoint 2010.

[Athman]

This Question By
●۩۝۩● -abu_omar- ●۩۝۩●

So I've read an article about creating the new xml format documents (docx, xlsx) and search inside them using VB code without opening the related program (word, excel) programaticlly from my code but I couldn't understand the idea 100%
Q1:can you support us with useful resources on how to deal with this idea?

Q2: what is the benefits that I gain as VB programmer in my practical programs using this code?

Q3: can I use the spelling and translation dictionaries of the office directly from my code without opening one of office aplications first in my code. if yes please give us hints in how to do it

[Athman]

so we have been told that attending our meeting a very special guest and CairoCodeCamp Event Headling

pls join me welcoming

[Marianne van Wanro]

Remi Caron says hi! He used to be cool... he WAS a VB developer. Not anymore... he switched to BI and SharePoint stuff.

[Marianne van Wanro]

Q1. I found the posts of Wouter van Vugt - a Dutch MVP - very usefull: http://msdn.microsoft.com/en-us/office/bb265236.aspx
Also the trick here is creating, changing documents without having the client application installed on the server. The docx is a compresed -zip- file containing xml files, images or your own custom.xml file.
Q2. The biggest gain is using VSTO instead of VBA. But in VSTO you can use VB-COde or C# code
Q3.No you can't as far as i am aware you'll have to have a connection to the office product (through the object model you can) However there are spellcheck packages out there for use in your app.

[Athman]

This Question By
●۩۝۩● -DotNetSpider- ●۩۝۩●

So I used the OpenXML SDK v 2.0 for a while, i spend a long time to understand its API , i used also the SDK tools such as DocumentReflector and they were useful and powerful but not all the time.

Q: Is there any plans to simplify this API in the next
Version of the SDK

[Marianne van Wanro]

المشاركة الأصلية بواسطة Remi Caron

while waiting for your questions Mariannerd (a Remi wanna be) are practising for our battle text like this is stiring up the fire nicely

[Marianne van Wanro]

المشاركة الأصلية بواسطة Remi Caron

I was at the MVP summit (Another thing Mariannerd would like to be) and i was told that the next version will have a focuson simplify things. Amongst the improvement areas SDK's were mentioned

[Athman]

This Question By
●۩۝۩● -abu_omar- ●۩۝۩●

Is there ways to Save the result of Query (select statement from a given datasource) to Excel Sheet directly from My code. I don't want to make a report then export it to excel sheet?

[Marianne van Wanro]

Marianne: yes you can. Depending on the business case. If you want to create this within an Excel sheet you could use VSTO and use ADO.NET to query your datasource. Another way to do this (when you are creating a web application) is bind the query to a DataGrid and after binding you can Export this to Excel: Here is a code sample how you can do this:
DataGrid1.DataSource = dt;
DataGrid1.DataBind();

Response.Clear();
Response.Charset = "";
//set the response mime type for excel
Response.ContentType = "application/vnd.ms-excel";
//create a string writer
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
//create an htmltextwriter which uses the stringwriter
System.Web.UI.HtmlTextWriter htmlWrite = new System.Web.UI.HtmlTextWriter(stringWrite);

//tell the datagrid to render itself to our htmltextwriter
DataGrid1.RenderControl(htmlWrite);
//all that's left is to output the html
Response.Write(stringWrite.ToString());
Response.End();

[Athman]

This Question By
●۩۝۩● -WAIS- ●۩۝۩●

Coz I've many of webpart template So
How can I make webpart template from start to setup
?

[Marianne van Wanro]

Marianne: not sure what you mean with Web Part templates

[Athman]

This Question By
●۩۝۩● -أحمد جمال- ●۩۝۩●

I hear, but not sure, that the sharepoint server is very costly and it is one of reasons that not all software companies go in this direction, is it true?

- I was planing to start learning sharepoint, first problem I have faced is that I need to have windows server instead of my vista or at least to use VM, is there any other solution for such developer who want only to start learning and testing?

- And the other problem was in the period of free trail, I can test sharepoint for one month only after that I must purchase, is there any free edition for non-commercial user like what we have in Visual c# express for example

[Marianne van Wanro]

Question 1 Windows SharePoint Services (teamsites) is for "free". Meaning if you have a Windows Server 2003 or higher licence. SharePoint Portal Server is the more expensive one. But if you need profiles, Search, Audiences etc. you need the Server version.

[Marianne van Wanro]

Question 2: No I'm sorry to say that SharePoint 2007 only works on a Windows Server. My personal experience is to create a Virtual Machine where I install both SharePoint Server as Visual Studio so I can develop , debug and test my source code. SharePoint 2010 however can be installed on a Windows7 machine. But it needs to be 64bit a machine in order to be able to install it. However, my personal preference is to create a VM for every customer I develop for..

[Marianne van Wanro]

Question 3: Again WSS is for free if you have Windows Server 2003 or higher. If you're developing Web Parts that don't have to use the Portal functionality you can use that version. Too bad there is no free version for developers. A way to get a full version for less money is to subscribe to a MSND subscription. Thats where you 'll find all application you can use in an NON production environment.
More info on MSDN subscriptions: https://msdn.microsoft.com/en-us/sub...s/default.aspx

[Athman]

This Question By
●۩۝۩● -النبهاني- ●۩۝۩●

what are the future trends in developing office applications with visual studio ?

is sharepoint effective with very small companies (like 5 employees or less) and what about using it through internet when the connections are so poor and expensive in many developing countries

[Marianne van Wanro]

Question 1: (Remi) The roadmap for Office is simplifycation. One way they want to accomplish that are the use of wizzards.

[Marianne van Wanro]

Question 1: (Marianne) When you use Visual Studio 2010 you are using the VSTO 4 (2010 version) of the runtime. Which means no matter what version of Office you target, you can take advantage of the new deployment features. You can take a look at the VSTO 2010 resources page here: http://msdn.microsoft.com/en-us/vsto/ee676911.aspx .

[Marianne van Wanro]

Question 2: When your company has (only) 5 employees you still want functionality for collaboration and document management. You can do this using Teamsites. and then WSS (the Free version shipped with Windows Server) will be sufficient. You can use this through your company's network internal) or through the internet. ) You always have to look at the TCO (Total cost of Ownership) If the costs are higher than the revenue you should look for other options.

[Athman]

●۩۝۩● -
And We Come to the end of our meeting with my question
- ●۩۝۩●

First of all a great thanks to you for accepting my invitation for this meeting and for you to know for u visiting us here is my celebration for my first 1000 post in this forum so thank you very much

I have 3 questions

1-to my knowlage this are the possible ways to develop for office products
a-adding office dll to the project and create a new instance for it and deal with them
b-VSTO
c-open xml
in your opinion which is the best way and is there any other ways that i didnt mention are available if so what is it?

2-now with office web app what is the technique to develop such application that deal with this type of new era ( i just made up this question so it might not have an answer) as how to deal with files in the skydrive and how to automatically upload files using the app we create and open office files directly through office web app

or let me reform my question to be correct
is there is something called office web app sdk (ok this was good and not look like it been made up)

3-how to make Microsoft hear abt us and support us with every thing i mean is there way to be MSDN 4 Arab ? you know to hear something like
"Microsoft Recommand you to visit vb4arab.com" or maybe make us certified in one or other way?

finally what do u have to say to us (both of you)? as Arab Programmers what do u have to recommand to our beginners? and what is the chance for us to work with microsoft?

thank you very much for accepting the invitation and looking forward to see you in the CairoCodeCamp event

i just have one wish ?can you recommand this site to people who like to be participted in meetings like this one so that as i said we become famous

maybe through you we can bring scott hanselman and scott guthrie to other future meetings


thanks

[Marianne van Wanro]

Q1. My answer would be B or C . and when your creating Server apps NEVER answer A.
Q2. There is an API for SkyDrive At CodePlex they have some interesting samples: http://skydriveapiclient.codeplex.com/
.Q3 That is an difficult question because I don't know how Microsoft works in Arab countries. My experiences with microsoft is just to invite them to UserGroup meetings and events. Or use the contacts of your Regional Director (a non Microsoft person who has contact with MVP's and Microsoft). Maybe they can help you with the question about the MSND 4 Arab.
Q4. Microsoft is always very interested in real world cases. I've started together with some other SharePoint enthusiasts a UserGroup and Microsoft is really supportive of such initiatives. Remi is president of the SDN (the Dutch Software Development Network) he also works closely with microsoft on events and magazines.

I hope I (and Remi) answered the questions sufficient. We 're both at the Cairo Code Camp if you have more questions. I really enjoyed doing this and I want to thank you all for the questions and for inviting me (and Remi) to this forum.

[Athman]

This was the end for our meeting tonight


thank you very much for your participant

and special thanks to the Guest hosts

for joining us in this good moments


thanks and have a good day


الى هنا نكون قد صلنا الى نهاية لقائنا لهذا اليوم

سعدنا جدا بحضوركم معنا

كما نشكر ضيوف اللقاء على حضورهم معنا واعطائهم جزء من وقتهم الثمين

نشكركم جميعا

على هذا العدد من المشاهدات في وقت قصير جدا