HuntingNut
HuntingNut
   Login or Register
HomeCommunity ForumsPhoto AlbumsRegister
     
 

User Info

Welcome Anonymous


Membership:
Latest: ffttty100
New Today: 0
New Yesterday: 1
Overall: 12554

People Online:
Members: 0
Visitors: 335
BOT: 3
Total: 338
Who Is Where:
 Visitors:
01: News
02: News
03: Forums
04: Forums
05: Forums
06: News
07: News
08: Forums
09: Forums
10: News
11: Forums
12: News
13: News
14: News
15: Forums
16: Forums
17: Forums
18: Forums
19: News
20: Forums
21: Forums
22: Forums
23: News
24: Forums
25: News
26: News
27: Forums
28: Forums
29: Forums
30: Forums
31: News
32: Forums
33: News
34: News
35: Forums
36: Forums
37: News
38: Forums
39: Forums
40: Forums
41: News
42: Forums
43: News
44: Forums
45: News
46: News
47: Forums
48: Forums
49: News
50: News
51: News
52: News
53: News
54: News
55: Forums
56: News
57: Forums
58: Forums
59: Forums
60: News
61: Forums
62: News
63: Forums
64: Forums
65: News
66: News
67: Forums
68: Forums
69: Forums
70: Forums
71: Forums
72: Forums
73: Forums
74: Forums
75: News
76: News
77: Forums
78: Forums
79: News
80: Forums
81: News
82: Forums
83: News
84: Forums
85: Forums
86: Forums
87: Forums
88: News
89: News
90: News
91: Forums
92: Forums
93: Forums
94: Forums
95: Forums
96: News
97: Forums
98: Forums
99: Forums
100: News
101: News
102: Forums
103: News
104: News
105: News
106: Forums
107: News
108: Forums
109: Forums
110: Forums
111: News
112: Forums
113: Forums
114: Forums
115: Forums
116: Forums
117: Forums
118: News
119: Forums
120: News
121: Forums
122: News
123: News
124: Forums
125: Forums
126: Forums
127: Forums
128: Forums
129: Forums
130: Forums
131: Forums
132: Forums
133: News
134: News
135: News
136: Forums
137: News
138: Forums
139: Forums
140: News
141: Forums
142: Forums
143: News
144: Forums
145: News
146: News
147: News
148: Forums
149: News
150: Forums
151: News
152: News
153: News
154: Forums
155: Forums
156: Forums
157: Forums
158: Forums
159: Forums
160: News
161: News
162: Forums
163: Forums
164: Forums
165: News
166: Forums
167: News
168: News
169: News
170: Forums
171: News
172: News
173: Forums
174: News
175: Forums
176: News
177: Forums
178: News
179: News
180: Your Account
181: Forums
182: News
183: News
184: Forums
185: News
186: Forums
187: Forums
188: News
189: News
190: Forums
191: Forums
192: Forums
193: News
194: News
195: Forums
196: Forums
197: Forums
198: News
199: Forums
200: Forums
201: Forums
202: Forums
203: Forums
204: Forums
205: Forums
206: Forums
207: Forums
208: Forums
209: Forums
210: News
211: Forums
212: News
213: Forums
214: News
215: Forums
216: Forums
217: Forums
218: Forums
219: News
220: News
221: Forums
222: News
223: News
224: News
225: Forums
226: News
227: Forums
228: Forums
229: Forums
230: Forums
231: Forums
232: Forums
233: Forums
234: Forums
235: News
236: Forums
237: Forums
238: Forums
239: Forums
240: Forums
241: News
242: News
243: Forums
244: Forums
245: News
246: Forums
247: Forums
248: News
249: News
250: Home
251: Forums
252: Forums
253: News
254: Forums
255: News
256: News
257: Forums
258: Forums
259: News
260: News
261: Forums
262: News
263: Forums
264: Forums
265: News
266: Your Account
267: News
268: Forums
269: News
270: News
271: News
272: Forums
273: News
274: Forums
275: News
276: Forums
277: Forums
278: News
279: News
280: News
281: News
282: Forums
283: Forums
284: Forums
285: Forums
286: News
287: News
288: Forums
289: Forums
290: News
291: News
292: News
293: Forums
294: Forums
295: News
296: News
297: Forums
298: Forums
299: News
300: Your Account
301: News
302: Forums
303: News
304: News
305: Forums
306: News
307: News
308: News
309: Forums
310: Forums
311: Forums
312: News
313: News
314: Forums
315: Forums
316: Forums
317: News
318: Forums
319: News
320: Forums
321: Forums
322: Forums
323: News
324: Forums
325: Forums
326: News
327: Your Account
328: News
329: Forums
330: Forums
331: Forums
332: News
333: News
334: News
335: Forums
  BOT:
01: Home
02: Forums
03: Your Account

Staff Online:

No staff members are online!
 

Coppermine Stats
Photo Albums
 Albums: 305
 Pictures: 2353
  · Views: 331949
  · Votes: 1305
  · Comments: 85
 

Support our Advertisers

CSV export configuration problem
Post your bug reports or feature requests here!

View previous topic :: View next topic  
Author Message
lince
Member
Member


Joined: Jul 19, 2006
Posts: 32
Location: Madrid, Spain

PostPosted: Sun Aug 23, 2015 11:33 pm    Post subject: CSV export configuration problem Reply with quote

Hello,
I've tried to export my ballistics data in a CSV file but I found a problem: my laptop has defined a local configuration as ES (spanish), so the decimal separator is a comma "," instead of a dot "."
So when importing to excel or another program the created CSV file it doesn't distinguish between decimal numbers of a value and a different column data.

Maybe some of you could suggest to me to change the locale values of my laptop but this is very complicated for the rest of my software, so I'd suggest to modify Pointblack to be able to change the separator character (for example to a TAB, a DOT, etc.) for CSV files. In this way for different languages it could be easier to manage the data. I suppose this is an easy solution.
Another option is to change the CSV export file format to be written in fixed width columns, but I suppose this is more complicated to code.
As usual, thanks to everybody for reading and also to DallanC for this superb software.
Best regards from Spain!.
Back to top
View user's profile
MacD
Super Member
Super Member


Joined: Apr 08, 2011
Posts: 1052
Location: Canada

PostPosted: Mon Aug 24, 2015 5:31 am    Post subject: Re: CSV export configuration problem Reply with quote

A workaround is to change the language for your spreadsheet to English and import the CSV file.Then change back to Spanish and export a new CSV file. I know language can be set in MS Office and I assume in Open Office.

_________________
La a'Blair s'math n Cairdean
(Friends are good on the day of battle)
Back to top
View user's profile
lince
Member
Member


Joined: Jul 19, 2006
Posts: 32
Location: Madrid, Spain

PostPosted: Tue Aug 25, 2015 1:22 am    Post subject: Re: CSV export configuration problem Reply with quote

MacD,
Thanks a lot for your help, but anyway I think it's not a solution: the problem appears when exporting from PB to a CSV file, in which both decimal and separators are commas. In this way whichever language is defined in the spreadsheet it will take all commas as separators.
Or maybe I didn't understand your suggestion, could you please confirm?
Back to top
View user's profile
DallanC
Site Admin
Site Admin


Joined: Jan 18, 2005
Posts: 3177
Location: Utah

PostPosted: Tue Aug 25, 2015 6:51 pm    Post subject: Re: CSV export configuration problem Reply with quote

Yea I export it directly using the USA standard. In fact, all data IS in USA/ English units regardless of country formatting or metric unit mode, for data tracking and computing. I convert on the fly to metric or country specific when I display data fields.

Really, what I just need to do is add a native way within pointblank to edit any particular data field and save it out. There just isnt a real need to use intermediary programs to edit stuff. PointBlank can / should just allow it as a feature within itself.

Plus, SLK files while being one if not the oldest and widest supported database formats, really should be replaced with XML or even the new LUA formats.

Its on the TODO list, right now I'm working on the mobile versions.

-DallanC
Back to top
View user's profile Photo Gallery
lince
Member
Member


Joined: Jul 19, 2006
Posts: 32
Location: Madrid, Spain

PostPosted: Tue Aug 25, 2015 11:04 pm    Post subject: Re: CSV export configuration problem Reply with quote

Hi again.
Workaround found, a little bit tricky but it works, just in case it helps to somebody over there:
1) install a PDF printer in your system and make it default printer for windows (I use doPDF but I suppose some other will work too)
2) Compute your ballistics and go to your table data window
3) Print (it will create a PDF document with correct data and formatting)
4) Open the pdf and export all data to a text file (select all, copy, open notepad, paste and save to a file with .txt extension). All data will be exported with space separators.
5) A tricky step: edit the txt file to delete wichever data you don't need (headings, etc.)
6) Start your spreadsheet and open the txt file, importing the with spaces as separators.

New suggestion to include a feature that will ease this: when you select rows in table data window (also in MOA table and Misc windows) it could be very useful to include the ability to copy the selected data using the right button of the mouse, could it be possible?

Again, thanks to everybody (specially to DallanC) and hope that helps!
Regards from Spain.
Back to top
View user's profile
Display posts from previous:   
Post new topic   Reply to topic   Printer Friendly Page    Forum Index » Bug Reports / Feature Requests
Page 1 of 1
All times are GMT - 7 Hours



Jump to:  


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum


Advertisements
 


Valid CSS! Valid HTML 4.01!
Click to check if this page is realy HTML 4.01 compliant for speed :)

All logos and trademarks in this site are property of HuntingNut.com.
The comments are property of their posters, all the rest © 2011 by HuntingNut.com
Interactive software released under GNU GPL, Code Credits, Privacy Policy

.: Upgraded to DragonFly 9.2 by Dizfunkshunal :.