XLS.Misc - When opening file with excel the numbers appear in scientific notation (exponential)

Problem: numbers appear in scientific notation (exponential) in document excel in file generated from Genexus.

This file is generated like a file with Tags HTML and engraving with extension xls.

That it is the scientific format:
The Scientific format shows a number in exponential notation, replacing part of the number with E+n, where E (that means Exponent) multiplies the number previous by 10 to the nth power. For example, a scientific format with two decimal shows 12345678901 like 1.23E+10, that is 1.23 times 10 to the tenth power.

Answer:
The answer is that excel uses the General format.

The General format uses the exponential notation for the great numbers (of 12 digits or more).

In order to clear the exponential notation in the great numbers, it can apply different a numerical format, like Number. This is in manual form.

Another alternative is to add some character (apostrophe, # or what is) to tag HTML that contains the number so that excel takes it like text.

The HTML would be thus:

<Table>
<Tr>
<Td>'1234567890111111</td>
<Td>'1234567890111111 </td>

</Tr>
</Table>

and it would be seen like Image 1.




On the other hand if what is desired to show are number of credit card, the number with the intermediate spaces could be recorded. Of that form excel understands it as character and shows it well.

The HTML would be thus:

<Table>
<Tr>
<Td>1234 5678 9011 1111</td>
<Td>1234 5678 9011 1111 </td>

</Tr>
</Table>

And it would be seen like Image 2.




At least with this it is left the reason by which this happens, and single subtraction to find other alternatives of solution if clear this does not satisfy.

Welcome commentaries to solve this subject!


View original link http://mundosupport.blogspot.com/2008/05/xlsvarios-al-abrir-archivo-con-excel.html

Web.Misc - Download files from web page (web panel)

To download files from a web page that are in the server , to do the following thing:

Create a Report Main with the property Call Protocol in HTTP, that have the following structure:

a) Rules
Parm( &ServerPath, &FileName );
// &ServerPath es la ruta absoluta en el servidor del archivo a descargar.
// NombreArchivo es el nombre que el usuario verá en la ventana de descarga y le será sugerido para grabar el archivo en disco.

b) Source
&Httpresponse.addheader('Content-Type','application/octet-stream')

&Httpresponse.addheader('Content-Disposition','attachment; filename=' + Trim ( &FileName ))

&Httpresponse.addfile(&ServerPath)

Web.Misc - Generate ZIP/RAR Files with Genexus

For generate a ZIP file:

1) Insert this code in a Genexus Report:

&cmd= '7z.exe a -tzip ' + &FileNameZIPDestiny + ' ' + &FileNameOrigin
&ret=shell(&cmd,0)

2) Copy 7z.exe file to the root directory.

Yoy can find 7z at www.7-zip.org

Web.Misc - Default archive for Web Site

This code, makes that the page be shown inside a frame leaving fixed the url that is visualized in the bar of directions of the explorer.

To generate the file, open the notepad and copy the following code modifying according to the name of our place, the url, and the page of start.

Then record it with the name default.htm



View Original Link =>http://mundosupport.blogspot.com/2008/02/webvarios-archivo-default-para-sitio.html

Genexus.Start - Initial readings

In the following URL will find reading that will allow to begin to understand Genexus and its philosophy you:

http://www.genexus.com/portal/hgxpp001.aspx?2,32,660,O,S,0,MNU;E;131;12;MNU;,

Vie original link => http://mundosupport.blogspot.com/2008/02/genexusinicial-material-de-lectura.html

NetMobile.Varios - To execute Beep function (Symbol MC3000) in Pocket PC

Execute Beep function (Symbol MC3000) on Pocket PC

To executre a Beep sound on a pocket PC (tested on Symbol MC3000) use this code:

(NetMobile Generator, Genexus 9.0.)

Event Enter
do 'Beep'
EndEvent // Enter

sub 'Beep'
csharp Beep();
csharp }

csharp static Symbol.Audio.Controller MyAudioController;

csharp public static void Beep(){
csharp if (MyAudioController==null){
csharp
csharp Symbol.Audio.Device
MyDevice=(Symbol.Audio.Device)Symbol.StandardForms.SelectDevice.Select
Symbol.Audio.Controller.Title,Symbol.Audio.Device.AvailableDevices);
csharp if(MyDevice
==null){System.Windows.Forms.MessageBox.Show("No Device Selected",
"SelectDevice"); return;}
csharp else{
csharp
if(MyDevice.AudioType==Symbol.Audio.AudioType.StandardAudio)
csharp MyAudioController = new
Symbol.Audio.StandardAudio(MyDevice);
csharp else if
MyDevice.AudioType==Symbol.Audio.AudioType.SimulatedAudio)
csharp MyAudioController = new
Symbol.Audio.SimulatedAudio(MyDevice);
csharp else{ System.Windows.Forms.MessageBox.Show("Unknown
Device Type"); return;}
csharp }
csharp }
csharp MyAudioController.PlayAudio(1500,2670);
csharp MyAudioController.Dispose();
csharp
endsub

Setup model properties: Compiler Flags = /r:bin\Symbol.Audio.dll /r:bin\Symbol.dll /r:bin\Symbol.StandardForms.dll
Copy the Dlls in bin directory.

Add the Dlls (symbol librarys) a "Additional Files" when deploy presssing F5.

This files are required:
Symbol.StandardForms.dll
Symbol.Audio.dll
sonido.cs

Ask them to mundosupport@gmail.com

View original link => http://mundosupport.blogspot.com/2008/02/netmobilevarios-ejecutar-beep-function.html

 

VisualBasic.FTP - Visual Basic Application to work with FTP server

An alternative to work and to communicate with a servant FTP who allows to make consultations, ascents and unloadings is to be based on the following example that can be found in:

http://support.microsoft.com/kb/195653/es

It is possible to integrate and/or to take advantage of in a Genexus object the example being obtained an interesting functionality.

In the URL mentioned you will be able to find a file called Vbsmpftp.exe that contains sources visual BASIC 6.

Among others the example shows:
• How to enumerate a directory and to obtain info of the file.
• How to load archives it grandese and to inform progress into transference.
• How to unload archives.



View original link => http://mundosupport.blogspot.com/2008/02/visualbasicftp-aplicacin-visual-basic.html

Tools.Office - Tool online that allows to create, to share and to publish spreadsheets, text documents and presentations

Looking for material for a development I found this tool of very interesting Google that is called Google Docs => http://www.google.com/google-d-s/intl/es/tour1.html

Básicaly consists of a tool online that allows to work with (to create, to modify, to share) lists of calculation, text documents and presentations.

It is free to use, only need google account.

Tools.Storage - Storage of Archives Online Free

Several alternatives exist that offer storage free online.

It is always useful to have some available one to make backup or to have to the reach archives.

This is called XDrive (it is of AOL) and offers 5 GB.

http://www.xdrive.com/

Web.Varios - Include HTML editor in WebObjects Part. 1

Something that increases the power of our Web objects is to offer to the user the possibility to him of entering enriched text since it would do it working with a text editor.

The subject at issue is like taking it to the practice with Genexus.

In order to obtain this, it can must incorporate to webpanels and Web transactions a publishing HTML that will allow to give format, colors, to insert images, tables, vinetas and others.

Until the moment I found two that they can be incorporated freely to our projects:

1) Publishing FCK
2) TinyMCE

An example of how to take it to ahead using the Publishing FCK can be in the Wiki de Genexus: http://wiki.gxtechnical.com/commwiki/servlet/hwiki?Incluir+FCKEditor+en+tus+web+objects



In order to use the second alternative (TinyMCE) I was testing and I am going to enter a next entrance with the commentaries that surgan and an example of implementation.

View Original Link => http://mundosupport.blogspot.com/2008/02/webvarios-agregar-editor-html.html

Web.Net - Put in production of site made with generator net (c#, genexus 9.0)

In order to make the putting in production of the objects developed with 9,0 Genexus and Net generator c# in a IIS is necessary to copy the servant:

- The directory bin of the model (where they are dlls of each object)

- Java script (*.js)

- The images, htmls, *.css and any wished static content

- The Web.config file

More information and requirements of the servant in the Manual of the generator Net Genexus 9.0 http://www.gxtechnical.com/gxdlsp/pub/home.htm?genexus/csharp/docum/manuals/9.0/manualnet90.htm

View Original Link => http://mundosupport.blogspot.com/2008/02/webnet-puesta-en-produccin-de-sitio.html