Wiki » History » Version 25
Manuel Madrid, 07/26/2014 07:13 PM
1 | 10 | Manuel Madrid | h1. Useful links |
---|---|---|---|
2 | 2 | Manuel Madrid | |
3 | 10 | Manuel Madrid | h2. Java Excel API |
4 | 1 | Manuel Madrid | * http://www.andykhan.com/jexcelapi/ |
5 | 2 | Manuel Madrid | * http://sourceforge.net/projects/jexcelapi/?source=navbar |
6 | 2 | Manuel Madrid | * http://search.maven.org/#artifactdetails|net.sourceforge.jexcelapi|jxl|2.6.12|jar |
7 | 2 | Manuel Madrid | |
8 | 16 | Manuel Madrid | h1. Google Summer of Code weekly reports history |
9 | 3 | Manuel Madrid | |
10 | 24 | Manuel Madrid | h2. Week 10 |
11 | 24 | Manuel Madrid | |
12 | 24 | Manuel Madrid | h3. What did I get done this week? |
13 | 24 | Manuel Madrid | |
14 | 24 | Manuel Madrid | Although I had planned to start with the writing support I finally decided to fix the feature request I opened last week [1] as I found an affordable way to do it. Finally, then, we will have a combo box for selecting the spreadsheet we want to load. |
15 | 24 | Manuel Madrid | |
16 | 24 | Manuel Madrid | I have to say that I'm very happy with this as I think that it is a very important usability improvement. |
17 | 24 | Manuel Madrid | |
18 | 24 | Manuel Madrid | While doing that I found and fixed a couple of issues affecting the gvSIG core: [2] and [3]. Hopefully those changes will be included in the next gvSIG 2.1 build. |
19 | 24 | Manuel Madrid | |
20 | 24 | Manuel Madrid | h3. What do I plan on doing next week? |
21 | 24 | Manuel Madrid | |
22 | 24 | Manuel Madrid | I'm considering to implement a similar solution for the "Point (X,Y,Z)" parameter in order to be able to select the name of the fields containing the coordinates from a combo box instead of just typing them, avoiding most mistakes. |
23 | 24 | Manuel Madrid | |
24 | 24 | Manuel Madrid | h3. Am I blocked on anything? |
25 | 24 | Manuel Madrid | |
26 | 24 | Manuel Madrid | No, I'm not. |
27 | 24 | Manuel Madrid | |
28 | 24 | Manuel Madrid | [1] https://redmine.gvsig.net/redmine/issues/2689 |
29 | 1 | Manuel Madrid | [2] https://redmine.gvsig.net/redmine/issues/2721 |
30 | 1 | Manuel Madrid | [3] https://redmine.gvsig.net/redmine/issues/2722 |
31 | 25 | Manuel Madrid | |
32 | 25 | Manuel Madrid | h2. Week 9 |
33 | 24 | Manuel Madrid | |
34 | 23 | Manuel Madrid | h3. What did I get done this week? |
35 | 23 | Manuel Madrid | |
36 | 23 | Manuel Madrid | This week I focused on testing the multiple spreadsheet support with latest gvSIG 2.1 build for both as a layer and a as a table cases. The functionality is working fine. I just detected one remarkable issue related with usability [1]. Unfortunately, to carry out this suggestion is too complicated and time-consuming to be done within the GSoC program as it would require to implement a new tab within the Load Layer and Load Table dialog boxes specific for Excel spreadsheets. |
37 | 23 | Manuel Madrid | |
38 | 23 | Manuel Madrid | h3. What do I plan on doing next week? |
39 | 23 | Manuel Madrid | |
40 | 23 | Manuel Madrid | Next week I will start the implementation of the writing support which will allow to export a gvSIG table to Excel spreadsheet format. |
41 | 23 | Manuel Madrid | |
42 | 23 | Manuel Madrid | |
43 | 23 | Manuel Madrid | h3. Am I blocked on anything? |
44 | 23 | Manuel Madrid | |
45 | 23 | Manuel Madrid | No, I'm not. |
46 | 23 | Manuel Madrid | |
47 | 23 | Manuel Madrid | [1] https://redmine.gvsig.net/redmine/issues/2689 |
48 | 23 | Manuel Madrid | |
49 | 22 | Manuel Madrid | h2. Week 8 |
50 | 22 | Manuel Madrid | |
51 | 22 | Manuel Madrid | h3. What did I get done this week? |
52 | 22 | Manuel Madrid | |
53 | 22 | Manuel Madrid | This week I focused on fixing the issue [1]. I have to say that, after spending a lot of time looking for the cause of the problem, it was a little bit embarrassing to discover that this was not a bug but my mistake. I was systematically giving a wrong input for the "Point" parameter: I was typing the original name of the columns instead of the name of the headers (first row). |
54 | 22 | Manuel Madrid | |
55 | 22 | Manuel Madrid | The good news are that the spatial support is working fine so I'm happy after all. |
56 | 22 | Manuel Madrid | |
57 | 22 | Manuel Madrid | h3. What do I plan on doing next week? |
58 | 22 | Manuel Madrid | |
59 | 22 | Manuel Madrid | Next week I will focus on testing the multiple spreadsheet support, which is already implemented. I also plan to prepare the implementation of the write support, which I will address the following week. |
60 | 22 | Manuel Madrid | |
61 | 22 | Manuel Madrid | h3. Am I blocked on anything? |
62 | 22 | Manuel Madrid | |
63 | 22 | Manuel Madrid | No, I'm not. |
64 | 22 | Manuel Madrid | |
65 | 22 | Manuel Madrid | [1] https://redmine.gvsig.net/redmine/issues/2606 |
66 | 22 | Manuel Madrid | |
67 | 20 | Manuel Madrid | h2. Week 7 |
68 | 19 | Manuel Madrid | |
69 | 20 | Manuel Madrid | h3. What did I get done this week? |
70 | 19 | Manuel Madrid | |
71 | 19 | Manuel Madrid | This week I focused on creating the first version of the user manual describing the functionalities developed so far. |
72 | 19 | Manuel Madrid | |
73 | 19 | Manuel Madrid | I created the manual in ReStructuredText format as this is the format used in the gvSIG project for documentation. I converted the source file to PDF an uploaded to the project site [1]. I also uploaded the source file and the images to the SVN. |
74 | 19 | Manuel Madrid | |
75 | 20 | Manuel Madrid | h3. What do I plan on doing next week? |
76 | 19 | Manuel Madrid | |
77 | 19 | Manuel Madrid | I will focus on trying to fix the only bug detected so far that is directly related with the plugin [2]. |
78 | 19 | Manuel Madrid | |
79 | 20 | Manuel Madrid | h3. Am I blocked on anything? |
80 | 19 | Manuel Madrid | |
81 | 19 | Manuel Madrid | I found problems converting the rest file to PDF. It took me quite a long time to figure out the cause of the problem, which was related with the quality of the images. However I'm not blocked at this moment as I could fix the problem. |
82 | 19 | Manuel Madrid | |
83 | 19 | Manuel Madrid | [1] https://redmine.gvsig.net/redmine/attachments/download/923/jexcel_plugin_user_manual_v03.pdf |
84 | 19 | Manuel Madrid | |
85 | 21 | Manuel Madrid | [2] https://redmine.gvsig.net/redmine/issues/2606 |
86 | 19 | Manuel Madrid | |
87 | 17 | Manuel Madrid | h2. Week 6 |
88 | 17 | Manuel Madrid | |
89 | 17 | Manuel Madrid | h3. What did I get done this week? |
90 | 17 | Manuel Madrid | |
91 | 17 | Manuel Madrid | This week I focused on testing the plugin. I created a first version of the plugin test plan [1] including the main test cases involved. I also executed the tests. |
92 | 17 | Manuel Madrid | |
93 | 17 | Manuel Madrid | As a result of the tests I detected a few issues that I reported to the gvSIG-Desktop project bugtraker [2]. Only one of them seems to be directly related with the jexcel plugin [3]. |
94 | 17 | Manuel Madrid | |
95 | 17 | Manuel Madrid | I'm happy because the plugin seems to be quite stable so far. |
96 | 17 | Manuel Madrid | |
97 | 17 | Manuel Madrid | h3. What do I plan on doing next week? |
98 | 17 | Manuel Madrid | |
99 | 17 | Manuel Madrid | I will focus on creating the user manual. Also will try to fix the only bug that is directly related with the plugin. |
100 | 17 | Manuel Madrid | |
101 | 17 | Manuel Madrid | h3. Am I blocked on anything? |
102 | 17 | Manuel Madrid | |
103 | 17 | Manuel Madrid | No. |
104 | 17 | Manuel Madrid | |
105 | 17 | Manuel Madrid | [1] https://redmine.gvsig.net/redmine/attachments/download/912/org.gvsig.jexcel.app.mainplugin_test_plan.html |
106 | 17 | Manuel Madrid | |
107 | 17 | Manuel Madrid | [2] https://redmine.gvsig.net/redmine/projects/gvsig-desktop/issues |
108 | 17 | Manuel Madrid | |
109 | 17 | Manuel Madrid | [3] https://redmine.gvsig.net/redmine/issues/2606 |
110 | 17 | Manuel Madrid | |
111 | 10 | Manuel Madrid | h2. Week 5 |
112 | 3 | Manuel Madrid | |
113 | 10 | Manuel Madrid | h3. What did I get done this week? |
114 | 7 | Manuel Madrid | |
115 | 8 | Manuel Madrid | This week I have been learning the procedures for generating plugin installation packages. I found some problems when trying to configure the downloading URL of the package but finally I got it. As Joaquín, my mentor, suggested, I opened an issue ticket explaining the problem because it could be useful for other developers. |
116 | 3 | Manuel Madrid | |
117 | 8 | Manuel Madrid | I uploaded the installation package to the project site at: |
118 | 1 | Manuel Madrid | |
119 | 3 | Manuel Madrid | https://redmine.gvsig.net/redmine/attachments/download/895/gvSIG-desktop-2.1.0-org.gvsig.jexcel.app.mainplugin-1.0.0-SNAPSHOT-1-testing-all-all-j1_5.gvspkg |
120 | 3 | Manuel Madrid | |
121 | 1 | Manuel Madrid | I also opened a ticket asking the gvSIG project admins for adding it to the official package repository: |
122 | 8 | Manuel Madrid | |
123 | 8 | Manuel Madrid | https://redmine.gvsig.net/redmine/issues/2587 |
124 | 1 | Manuel Madrid | |
125 | 10 | Manuel Madrid | h3. What do I plan on doing next week? |
126 | 9 | Manuel Madrid | |
127 | 9 | Manuel Madrid | I will test the package and will create user documentation for the current functionalities. |
128 | 3 | Manuel Madrid | |
129 | 10 | Manuel Madrid | h3. Am I blocked on anything? |
130 | 3 | Manuel Madrid | |
131 | 9 | Manuel Madrid | Not really. |
132 | 3 | Manuel Madrid | |
133 | 10 | Manuel Madrid | h2. Week 4 |
134 | 1 | Manuel Madrid | |
135 | 10 | Manuel Madrid | h3. What did I get done this week? |
136 | 3 | Manuel Madrid | |
137 | 9 | Manuel Madrid | I fixed some bugs related with the detection of the columns types. Now the plugin already recognize the following types: integer, long, float and double. The rest of the data is managed as string. |
138 | 1 | Manuel Madrid | |
139 | 9 | Manuel Madrid | I finally decided to go for the spatial support. I made some changes and now the plugin is already able to load tables containing coordinates (X,Y and Z) as point layers. |
140 | 3 | Manuel Madrid | |
141 | 11 | Manuel Madrid | h3. What do I plan on doing next week? |
142 | 1 | Manuel Madrid | |
143 | 9 | Manuel Madrid | I will get to know how to generate the plugin package. Then I will generate an addon that could be installed from the gvSIG addons manager. I will check that it can be installed on the last gvSIG 2.1 build (2227). Finally I will upload the package to the gvSIG official repo so it can be installed by everyone. |
144 | 3 | Manuel Madrid | |
145 | 11 | Manuel Madrid | h3. Am I blocked on anything? |
146 | 3 | Manuel Madrid | |
147 | 9 | Manuel Madrid | I had some problems trying to use the latest version of the gvSIG library org.gvsig.tools. I wanted to use it as it has some interesting bugfixes but I finally couldn't. |
148 | 3 | Manuel Madrid | |
149 | 9 | Manuel Madrid | Since those changes won't be available until the next gvSIG build release, Joaquín, my mentor, suggested to take a workaround in the meantime. |
150 | 1 | Manuel Madrid | |
151 | 11 | Manuel Madrid | h2. Week 3 |
152 | 3 | Manuel Madrid | |
153 | 11 | Manuel Madrid | h3 What did I get done this week? |
154 | 1 | Manuel Madrid | |
155 | 9 | Manuel Madrid | I adapted the source code of the CSV provider in order to be able to read Excel spreadsheets using the jexcelapi library. Finally I used more amount of source code of the CSV provider than expected. |
156 | 1 | Manuel Madrid | |
157 | 9 | Manuel Madrid | I converted to Excel file format through LibreOffice the following files: |
158 | 9 | Manuel Madrid | * http://downloads.gvsig.org/download/geodata/tables/CSV/poblacionINE.csv.zip |
159 | 9 | Manuel Madrid | * http://downloads.gvsig.org/download/geodata/tables/CSV/torrent_4.csv.zip |
160 | 7 | Manuel Madrid | |
161 | 9 | Manuel Madrid | I uploaded them to the plugin folder and used them for testing the data loading. |
162 | 7 | Manuel Madrid | |
163 | 9 | Manuel Madrid | Now it is already possible to load them as tables in gvSIG with minor issues that I will try to fix the next week. |
164 | 1 | Manuel Madrid | |
165 | 11 | Manuel Madrid | h3. What do I plan on doing next week? |
166 | 7 | Manuel Madrid | |
167 | 9 | Manuel Madrid | I will fix some issues affecting the detection of the column types. |
168 | 1 | Manuel Madrid | |
169 | 9 | Manuel Madrid | Depending on how long takes me to fix this issues I will consider to address the implementation of the spacial data support, despite it was initially planned in the next iteration, some weeks later. |
170 | 1 | Manuel Madrid | |
171 | 11 | Manuel Madrid | h3. Am I blocked on anything? |
172 | 1 | Manuel Madrid | |
173 | 9 | Manuel Madrid | I thought I could get more information from the Excel file than I finally got, as I couldn't get the information regarding the column type and the headers, in case they had. |
174 | 1 | Manuel Madrid | |
175 | 9 | Manuel Madrid | This made me spend more time than expected studying the jexcelapi needlessly as I finally reused some of the CSV provider source code. I have to say that this made me think if using the jexcelapi library was the right decision but I finally decided to carry on with it. |
176 | 1 | Manuel Madrid | |
177 | 11 | Manuel Madrid | h2. Week 2 |
178 | 1 | Manuel Madrid | |
179 | 11 | Manuel Madrid | h3. What did I get done this week? |
180 | 7 | Manuel Madrid | |
181 | 9 | Manuel Madrid | * Created the maven multi-mode structure for the project. |
182 | 9 | Manuel Madrid | * Added the library modules and configuration files needed to compile and deploy the gvSIG plugin. |
183 | 9 | Manuel Madrid | * Uploaded the project to the SVN: |
184 | 9 | Manuel Madrid | https://devel.gvsig.org/svn/gvsig-jexcel |
185 | 1 | Manuel Madrid | |
186 | 3 | Manuel Madrid | The SVN is also available from the gvSIG Redmine: |
187 | 9 | Manuel Madrid | https://devel.gvsig.org/redmine/projects/gvsig-jexcel/repository |
188 | 3 | Manuel Madrid | |
189 | 11 | Manuel Madrid | h3. What do I plan on doing next week? |
190 | 3 | Manuel Madrid | |
191 | 7 | Manuel Madrid | Next week I will try to have a preliminar version of the plugin that allows just to load data, without taking into account types and parameters. |
192 | 7 | Manuel Madrid | |
193 | 11 | Manuel Madrid | h3. Am I blocked on anything? |
194 | 7 | Manuel Madrid | |
195 | 12 | Manuel Madrid | Had problems to find where to register the new data provider. |
196 | 12 | Manuel Madrid | |
197 | 12 | Manuel Madrid | It was specially time-consuming to get familiar with the maven project structure. |
198 | 12 | Manuel Madrid | |
199 | 12 | Manuel Madrid | I also found some problems to upload the source code to the SVN. |
200 | 12 | Manuel Madrid | |
201 | 12 | Manuel Madrid | I was not sure if some aspects of the maven general configuration are correct. |
202 | 3 | Manuel Madrid | |
203 | 9 | Manuel Madrid | Finally I could fix all those problems so I made the expected progress. |
204 | 3 | Manuel Madrid | |
205 | 11 | Manuel Madrid | h2. Week 1 |
206 | 3 | Manuel Madrid | |
207 | 11 | Manuel Madrid | h3. What did you get done this week? |
208 | 3 | Manuel Madrid | |
209 | 9 | Manuel Madrid | In order to implement the Excel data provider for gvSIG I will use as a basis a Java library that provides access to Excel data. |
210 | 7 | Manuel Madrid | |
211 | 9 | Manuel Madrid | I considered the following alternatives: |
212 | 15 | Manuel Madrid | * POI-HSSF and POI-XSSF - Java API To Access Microsoft Excel Format Files |
213 | 15 | Manuel Madrid | * SmartXLS for Java |
214 | 15 | Manuel Madrid | * Java Excel API |
215 | 7 | Manuel Madrid | |
216 | 9 | Manuel Madrid | I finally decided to go for the last one as it is powerful enough and it looks quite simple. It seems that this project doesn't have activity since 2010 but I hope this is not a problem. |
217 | 7 | Manuel Madrid | |
218 | 9 | Manuel Madrid | Those are the most relevant links of this library: |
219 | 18 | Manuel Madrid | * http://www.andykhan.com/jexcelapi/ |
220 | 18 | Manuel Madrid | * http://sourceforge.net/projects/jexcelapi/?source=navbar |
221 | 18 | Manuel Madrid | * http://search.maven.org/#artifactdetails|net.sourceforge.jexcelapi|jxl|2.6.12|jar |
222 | 3 | Manuel Madrid | |
223 | 7 | Manuel Madrid | I've got a project within the gvSIG project infrastructure: |
224 | 14 | Manuel Madrid | https://devel.gvsig.org/redmine/projects/gvsig-jexcel |
225 | 3 | Manuel Madrid | |
226 | 7 | Manuel Madrid | The source code will be stored at: |
227 | 9 | Manuel Madrid | https://devel.gvsig.org/svn/gvsig-jexcel |
228 | 3 | Manuel Madrid | |
229 | 11 | Manuel Madrid | h3 What do you plan on doing next week? |
230 | 7 | Manuel Madrid | |
231 | 9 | Manuel Madrid | I plan to create the Maven projects infrastructure. I will use as a basis the following gvSIG projects: |
232 | 9 | Manuel Madrid | * gvSIG data provider for DGN |
233 | 3 | Manuel Madrid | https://devel.gvsig.org/redmine/projects/gvsig-dgn |
234 | 9 | Manuel Madrid | * gvSIG data provider for DXF |
235 | 3 | Manuel Madrid | https://devel.gvsig.org/redmine/projects/gvsig-dxf |
236 | 3 | Manuel Madrid | |
237 | 9 | Manuel Madrid | I also will use the gvSIG CVS data provider to compose the project skeleton. |
238 | 3 | Manuel Madrid | |
239 | 11 | Manuel Madrid | h3. Are you blocked on anything? |
240 | 3 | Manuel Madrid | |
241 | 9 | Manuel Madrid | Not, so far. |