Agbebiyi Babajide http://i-tech-tips.blogspot.com/

Solution for “user not signed in” using Google Maps or Google Docs

2009-05-01T14:35:00.000-07:00

Using Google Maps on Google Site.

Using Google apps is very interesting, as I always say; I’m in love with uncle Google. Recently I had developed an event notice website for my company where I displayed a Google map of event address, this works well but unknowingly, map will not show for a visitor who just wants to see event information on the site. (User not signed in problem), For users of own domain, you may want to pay attention. This is why I created this tutorial.

Adding map addresses to your spreadsheet

1. Create a spreadsheet in Google Docs and name it GoogleMapAddresses

2. In the first column of the spreadsheet “GoogleMapAddresses” , type in the address "You may test to see that Google can find this address using http://maps.google.com/ ".

3. In the second column of same row where you typed your address in step 2 above, type the tooltip for the marker on the map e.g. “Google Office” .Repeat for as many addresses you want to use on map. Please do not leave any rows in between empty!

4. Highlight both cells that have your address and tooltip (Hint: use shift key when selecting)

Click on INSERT-> Gadgets->Maps, click on Add to spreadsheet button (See how it looks on your site-debugging)

The range will be inserted automatically based on the cells you had selected in step 4 above.

Optional settings:

1. Enter title of your choice in “Title”

2. To use the last column for tooltips, check “Last column as tooltips” then click Apply.(Note, this is the option that allows address description of “Google office” to show when you click on the marker on the map.

3. To enable zoom using mouse check “Zoom using mouse wheel” then click Apply.

4. Use any map type of your choice from the drop down menu in “Map type” for this tutorial we will use ‘normal’

5. Click Apply and Close button, Verify that the map is OK,

6. On the map, Click the little menu in the upper right hand corner of the gadget,( see image below) and click Get Query Data Source URL.

7. In the radio button, click “Selected range” right-click and copy the URL to the clipboard.

8. In your Google Site, Click “edit” to edit the page you want to show the map.

9. Click Insert-> More-> “Enter Google data connector” in search field and hit Search.

10. Insert the Gadget into the page ,Fill in the fields, Enter URL you copied in step 7 above into the Data Source URL field, check “Last column as tooltips”.

10. Save your changes and verify your map, click on the red marker to see if the tooltip is OK

TROUBLESHOOTING SECTION

Google is very strict with document security and this is why I love Google Docs, I had tried using a Java client to get (stream) my docs from Google but sometimes server denies me due to security features so if you really want to use your docs well, then security is nothing to toy with!

This section is the reason why I created this tutorial, it took me hours to figure the problem and this is why I have created this tutorial for someone to read and use.

If you are using a Google domain e.g urname@gmail.com

1. Just before your spreadsheet editor, click on Share -> “see who has access” link

2. There are three options available, for a website that the whole world can see, choose “People can view this item without signing in” hit “Save & Close” button.

If you are using a custom domain e.g urname@urdomain.com

Repeat steps 1 – 2 under TROUBLESHOOTING SECTION

NOTE: If your check box is grayed out under “Share with others” in step 2 above, don’t panic, just ask your administrator of your Google app to modify settings to allow sharing of documents outside domain.

If you cannot get hold of your administrator, maybe he is on a holiday to Bahamas, then you may want to create a new Gmail account and put these spreadsheet document.(You have to repeat all steps as URL will change)

Sources:

1. Use the Map Gadget to add interactive maps to your spreadsheets

http://docs.google.com/support/bin/answer.py?answer=91601

2. Using a Google Maps Gadget in Google Sites

http://wp.jarretthousenorth.com/2008/06/05/using-a-google-maps-gadget-in-google-sites/

Regards,

Babajide

PLEASE LEAVE COMMENTS

Code response to su mus (samuschen@gmail.com) [Google-Docs-Data-APIs] Re: no object DCH for MIME type application/atom+xml

2009-04-16T01:03:00.000-07:00

This is my source code in Java and it successfully uploads a .doc, .xml, .wsdl etc..document to google docs.

You may replace the following
1. jTexAreaMSG.append(chooser.getSelectedFile().getName() + " sucessfully uploaded to google docs") with a System.out.println();
2. service.setUserCredentials(txtUser.getText(), new String(txtPass.getPassword())); you can hard code your User credentials, Here I am using a GUI so I used JPasswordField and JTextField

All the best Su Mus,
Agbebiyi B.A

Salesforce.com connect for outlook VS Microsoft outlook 2007 Addin solution

2009-04-14T07:10:00.000-07:00

1 Management Project Summary

Salesforce connect for outlook is an add-in that integrates Salesforce with Microsoft Outlook. It allows users to manage information between either interfaces without sacrificing data consistency.

Users therefore have the advantage of having their Salesforce contacts, tasks, and events on Outlook and vice versa.

Users will be reminded of all events and task in outlook from Salesforce.

This post has been removed temporarily due to Adapti Policy restrictions, Queries ?

send e-mail to info@adapti.be

You may post in comment section for help or questions on this topic, but the full tutorial is temporarily unavailable.

How to get mimeType in Java

2009-04-09T10:19:00.000-07:00

Recently, I tried to write a piece of code that uploads my file directly to Google docs (I'm so in love with Google :-x) and I needed the mime type of the file I intended to upload , to my surprise, default packages in JDK does not return correct mimeTypes e.g java.net.FileNameMap.

Java by default returns 'application/octet-stream' as Microsoft word document mime type instead of 'application/msword'. This however causes an exception

ServiceException: com.google.gdata.util.InvalidEntryException: Bad Request
Content-Type application/octet-stream is not a valid media type

Strange isn't it? I also tried a couple of Classes that uses JAVA_HOME/lib/content-types.properties file. The is my solution perhaps you alsi have similar troubles like me.

1. Grab a copy of install-ocutil-2.4.2

2. Open a command prompt and type java -jar install-ocutil-2.4.2.jar

3. Follow the instructions and choose default installation path

4. Add C:\Program Files\clapper.org\util\lib\ocutil-2.4.2.jar to your application- In Netbeans IDE 6.5 you may follow these steps

5. Right click on Library of your project node

6. Click on Add JAR/Folder... and select C:\Program Files\clapper.org\util\lib\ocutil-2.4.2.jar

Please when adding hefty lib like gdata client libary you may want to create a library using library manager and then import. See getting started with Java and google soon in my next blog :-)

7. You may test using this sample code I have written, Note that org.clapper.util.misc.MIMETypeUtil was imported.

All the best and happy coding!!! :-)

How to configure PHP to use Oracle database

2009-04-09T03:20:00.000-07:00

Author: Agbebiyi Babajide Adebiyi

Remark: ITS Documentation

Date: 22022009

Link: jide@live.co.za

INTRODUCTION

This documentation is intended to help quickly configure the TUT(Tshwane university of technology, SA) ITS connection. ITS connection is simply the Oracle database connection that TUT uses to store all crucial information about student and staff of TUT. This documentation hereby written for a simple purpose of connecting to this database to read information stored on TUT database.

PURPOSE

This documentation may be used by anyone testing, trying or wanting to build applications that connects to an oracle database system and also to help configure or recompile oracle(OCI8 installation with world’s powerful server scripting language php) on a LINUX OS.

HARDWARE AND SPECIFIIC CONFIG

OS:Linux

DISTRO: Centos

VERSION: 5

NEEDED TOOLS OR SOFTWARE

At the time of writing, the following versions were used

Oracle Instant client 11

PHP5

SETTING UP THE ENVIROMENT

1. Grab a copy of Oracle instantclient (basic and devel packages ) at http://www.oracle.com/technology/software/tech/oci/instantclient/index.html Note: I will illustrate using the .zip files. It is the same thing either you use rpm versions too.

mkdir -p /opt/oracle/instantclient

cd /opt/oracle/instantclient

unzip instantclient-basic-linux32-XXXXXXX.zip

unzip instantclient-sdk-linux32XXXXXX.zip

NB: Make sure all your instantclient files are in /opt/oracle/instantclient

We have to create symbolic links to some very crucial files in our instantclient folder.

cd /opt/oracle/instantclient

ln -s libclntsh.so.10.1 libclntsh.so libclntsh.so.10.1 will be whatever version you have

ln -s libocci.so.10.1 libocci.so

2. Now we have to download OCI8 module and build it ourselves. Grab it at http://pecl.php.net/package/oci8 .

mkdir -p /usr/local/srcs

cd /usr/local/srcs

Move the oci8 module to this folder created in step 3 above.

mv oci8-xxx.tgz /usr/local/srcs

tar xzf oci8-xxx.tgz

cd oci8-xxx

phpize

./configure --with-oci8=shared,instantclient,/opt/oracle/instantclient

make

make install

3. Edit your php.ini and add

extension=oci8.so

TESTING IF OCI8 IS ENABLED

Quickly write a phpinfo() script and see if you will see anything about oci8 like below

ENVIROMENT VARIABLE

type

export LD_LIBRARY_PATH= opt/oracle/instantclient

export TNS-ADMIN= opt/oracle

Grab and copy tnsnames.ora from your database administrator to

opt/oracle Folder

Restart apache server, depending on how you installed apache, traditionally use/etc/init.d/httpd restart

Run the phpinfo() script and look for image below about oci8

NB: The variable you might see may differ a bit due to difference in oci8

version but what is important is that you see oci8

MORE ENVIROMENT VARIABLE / START UP SCRIPT

You may want to create a script and set these environment variables, e.g. you can put in

/etc/rc.local – this script runs last during system startup ensuring that your connection to Oracle DB is always active

cd /etc/rc.local

type vi oci-init.sh

type the following command

/etc/init.d/httpd stop #stop web server and set environment

export LD_LIBRARY_PATH= opt/oracle/instantclient

export TNS-ADMIN= opt/oracle

/etc/init.d/httpd start

Thank you for using my how to, any comment, e-mail me, see above

Agbebiyi Babajide Adebiyi (Prince)