Sujet Vos mails pro rigolos !

Dear all,

During our projects we frequently have to organize several meetings in various locations.
For me who is not a grand-master in geography, it can become very quickly a nightmare when you want to optimize these meetings.

Here is the solution!

1°) First, you have to take your excel chart with your database containing:
- A first line with titles (name, address, postal code, country…)
- Row with Name of the company
- Row with Address
- Row with Postal code
- Row with City
- Row with Country
- Row with details you need to add: contact name, phone, etc… (optional: If you want to keep several rows with details, you can use the excel formula “concatener” which allow you to take the text from several cells in one cell (example: =CONCATENER(H60;" --- ";G60;" --- ";F60) brings you textfromH60 --- textfromG60 --- textfromF60 ))

Remark: There are some specific characters making the kml file (see 11°)) wrong. For example, if there is a “&” in the field “name” or “description”, it does not work in the step E°). Check with the search tool and replace the & by something else (info, maybe there is other specific characters… if step E°) do not work, please contact me)

2°) Save your excel file in text format, with tabulation as separator.

3°) Open the text file with wordpad or notepad
Copy everything. Be carefull to avoid an empty line at the end of the document.

4°) Open your favorite browser, and open this link
http://www.batchgeocodeur.mapjmz.com/
paste your text file in the field “1. Récupérer des données en format compatible »


5°) click « valider ». if everything is ok, you normally have a message in green telling you the number of column and row (in the ex 184 row and 12 column).
6°) check in the field “3. Choisir les champs d'adressage” if your address, postal code, etc… are correctly linked to the good data.

7°) launch the conversion with the button “Geocodage”


8°) When the process finish, (when you can see near the button “geocodage” the text “Traitement 184/184” for my example), click on “arrêter”.

9°) click on “format d’origine”, select the whole field “5” copy it, and paste it in a text document. Save it, and open it with excel.

10°) after accepting the conversion of the text file in excel file, check the column “accuracy”
Accuracy :, (0 nothing found) : 1:country/2:region/3:sub-region/4:city/5:postal code/6:road/7:intersection/8:adress
If there is some 0 in accuracy, check and modify your initial file used in 1°). You need to remove some information. For example “paris cedex” is not understood, and you need to remove the “cedex”.

Clean your file, it take few minutes, you can check with google maps if your address is found.
After this stage done, back to 2°) repeat 9°) and 10°) to check and if ok go to 9bis°)


9bis°)click on “format kml”, select the whole field “5” copy it, and paste it in a text document.

10bis°) add to the end of your text document :

</Document>
</kml>

11°) save it with the extension .kml


End of the first step!


The second step is much more easy.
A°) Open http://maps.google.fr/
B°) Click on login (top right) or create a account if you do not have one. It take 2 min to create.
C°) click on “my maps” (top left under the research bar)
D°) create a new map (private map is better to my point of view), give your title, description…
E°) click on “import”, select your .kml file, and click import.
F°) Et voilà !!!
G°) you can personalize your comments on each company, change the pin to another one in order to use a color code (green, red, yellow, pink…), etc.

H°) you can share your map with other colleagues, to collaborate, or just to see it, by clicking on the link “collaborate” just under the “my maps”. An address is shown and can be shared.

For any troubleshooting, you have my direct phone number below.

Bonjour à tous et toutes.

On bosse dans la chimie tout de même et il doit arriver à divers d’entre vous d’avoir des molécules à faires, des réactions chimiques à insérer, des modélisations moléculaires…
Je vous propose d’utiliser Chemsketch pour ça. Il est accessible comme freeware sur le répertoire commun

Si vous voulez des conseils pour l’utiliser au mieux, hésitez pas, je le maitrise pas mal…
Quelques exemples de ce qu’on peut faire avec (j’ai mis 2 min pour faire ça)

http://files.freemusiczilla.com/screenshots/00/1285219004173201_large.jpeg

Un autre logiciel, nommé Gamgi, qui lui est pour la modélisation cristalline. Cela peut être utile si jamais vous bossez dessus…
http://www.gamgi.org/
quelques screenshots (du site)



Il est téléchargeable sur le site. Par contre je crains qu’il ne soit utilisable que sur Debian, Ubuntu, Mac OS X … mais pas pour Windows.

On est tous sous Windows