Timesheet Export to CSV Garbled.

[Jeff_D]

When I export a timesheet to Excel, the export is using a semi-colon as a delimiter, and I can't find a place to change it. This is what the Excel sheet looks like:

ts_id;ts_title;ts_start;ts_duration;ts_quantity;ts_unitprice;cat_id;ts_owner;ts_modified;ts_modifier;pl_id;ts_status;ts_total;class
7;203: eCVP;01/17/2011 12:00 am;240;4;;;Dore Jeff;01/17/2011 03:00 pm;D Jeff;0;;;row
8;253: APU-CVP-S-28-01;01/17/2011 12:00 am;240;4;;;Dore Jeff;01/17/2011 03:00 pm;Dore Jeff;0;;;row

What am I missing? Anyone know a fix?

[WLD]

That problem bugs me all over the shop.  I didn't have time to go hunting for it so simply opened up the output file in Open Office which easily allowed me to use a semicolon as a delimiter.  Then you can save it as an .xls (if you so need)   http://www.openoffice.org/ (free/OS for Windows too)


On Monday 17 Jan 2011 21:46:18 Jeff_D wrote:
> When I export a timesheet to Excel, the export is using a semi-colon as a
> delimiter, and I can't find a place to change it. This is what the Excel
> sheet looks like:
> ts_id;ts_title;ts_start;ts_duration;ts_quantity;ts_unitprice;cat_id;ts_owner;ts_modified;ts_modifier;pl_id;ts_status;ts_total;class
> 7;203: eCVP;01/17/2011 12:00 am;240;4;;;Dore Jeff;01/17/2011 03:00 pm;D
> Jeff;0;;;row
> 8;253: APU-CVP-S-28-01;01/17/2011 12:00 am;240;4;;;Dore Jeff;01/17/2011
> 03:00 pm;Dore Jeff;0;;;row
> What am I missing? Anyone know a fix?

------------------------------------------------------------------------------
Protect Your Site and Customers from Malware Attacks
Learn about various malware tactics and how to avoid them. Understand
malware threats, the impact they can have on your business, and how you
can protect your company and customers by using code signing.
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
eGroupWare-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/egroupware-users

[Jeff_D]

that would work if it was just me using it, but I can't ask 80 people to install Open Office and do a conversion like that. Especially the VPs, who would complain.

[Jürgen Dlugi]

Hi,

in excel 2003 for example you have in the menu "Data" -> "Text in columns".
Mark the column where all data is in and choose "Text in columns", now you can select the appropriate separator - maybe your 80 colleagues can handle this ;-).

regards
Jürgen
 

[Jeff_D]

That was one solution that I looked at, but it doesn't format the data correctly. It's also not pulling the field names from the database, like "Time In", "Time Out", "User Name" ... like this aspect of Groupware is half finished.

 I don't have a problem tracking down and fixing what I find, I just hoped someone had actually USED the Timesheet part of Groupware and had a fix..

[Birgit Becker Stylite GmbH]

Using the EGW 1.8 or EPL i suggest to use the import/export-modul this
allows you choose the delimiter and many more features

Birgit

Am 17.01.2011 22:46, schrieb Jeff_D:

> When I export a timesheet to Excel, the export is using a semi-colon as a
> delimiter, and I can't find a place to change it. This is what the Excel
> sheet looks like:
>
> ts_id;ts_title;ts_start;ts_duration;ts_quantity;ts_unitprice;cat_id;ts_owner;ts_modified;ts_modifier;pl_id;ts_status;ts_total;class
> 7;203: eCVP;01/17/2011 12:00 am;240;4;;;Dore Jeff;01/17/2011 03:00 pm;D
> Jeff;0;;;row
> 8;253: APU-CVP-S-28-01;01/17/2011 12:00 am;240;4;;;Dore Jeff;01/17/2011
> 03:00 pm;Dore Jeff;0;;;row
>
> What am I missing? Anyone know a fix?
>

--
Birgit Becker
Stylite GmbH
[open style of IT]

Morschheimer Strasse 15
67292 Kirchheimbolanden

fon [phone]
fax  [phone]
cell [phone]
mailto: [hidden email]
www.stylite.de
________________________________

Stylite GmbH
Handelsregister Kaiserslautern HRB 30575
Geschäftsführer:
Andre Keller und Ralf Becker
USt-ID: DE214280951


------------------------------------------------------------------------------
Protect Your Site and Customers from Malware Attacks
Learn about various malware tactics and how to avoid them. Understand
malware threats, the impact they can have on your business, and how you
can protect your company and customers by using code signing.
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
eGroupWare-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/egroupware-users

[WLD]

Well switching 80 users to a free and fully featured office suite that's compatible with MS Office will surely save your IT budget a lot of money and earn you some serious "brownie points" with the VPs :)

I guess you'll have to use the import/export unless you want to hack a script together to get your data straight out the database and in to Excel format, bypassing awful CSVs entirely.

You could also use the reporting system to generate Excel files directly if you create a custom report for it, it shouldn't be too difficult as the framework is already in place and quite simple to follow.

Good luck whichever method you choose!

Paul


On Tuesday 18 Jan 2011 12:57:33 Jeff_D wrote:
> that would work if it was just me using it, but I can't ask 80 people to
> install Open Office and do a conversion like that. Especially the VPs, who
> would complain.

------------------------------------------------------------------------------
Protect Your Site and Customers from Malware Attacks
Learn about various malware tactics and how to avoid them. Understand
malware threats, the impact they can have on your business, and how you
can protect your company and customers by using code signing.
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
eGroupWare-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/egroupware-users

[Jeff_D]

When trying to use import/export I get this:



And I am not able to edit any options. This is in IE, in Firefox it doesn't work either.



I am at a loss as to where to even start trying to fix this.. does it actually work for anyone? I have even started completely over with a new install of the software and recreating the database from scratch with no luck..

[Birgit Becker Stylite GmbH]

Hi Jeff,

you can create and difine the profile in admin and thatn run it with all
items or just the selected ones

Birgit



Am 19.01.2011 15:24, schrieb Jeff_D:

> When trying to use import/export I get this:
>
> http://egroupware.219119.n3.nabble.com/file/n2287548/1.jpg
>
> And I am not able to edit any options. This is in IE, in Firefox it doesn't
> work either.
>
> http://egroupware.219119.n3.nabble.com/file/n2287548/2.jpg
>
> I am at a loss as to where to even start trying to fix this.. does it
> actually work for anyone? I have even started completely over with a new
> install of the software and recreating the database from scratch with no
> luck..

--
Birgit Becker
Stylite GmbH
[open style of IT]

Morschheimer Strasse 15
67292 Kirchheimbolanden

fon [phone]
fax  [phone]
cell [phone]
mailto: [hidden email]
www.stylite.de
________________________________

Stylite GmbH
Handelsregister Kaiserslautern HRB 30575
Geschäftsführer:
Andre Keller und Ralf Becker
USt-ID: DE214280951


------------------------------------------------------------------------------
Protect Your Site and Customers from Malware Attacks
Learn about various malware tactics and how to avoid them. Understand
malware threats, the impact they can have on your business, and how you
can protect your company and customers by using code signing.
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
eGroupWare-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/egroupware-users

[Jeff_D]

Birgit Becker Stylite GmbH wrote

Hi Jeff,

you can create and difine the profile in admin and thatn run it with all
items or just the selected ones

Birgit

That made absolutely no difference at all. The admin account I created and the admin group I created has everything checked. Why is it so hard to get this to work? All I want is for the CSV sheets to use a comma (,) instead of a semicolon (;)

[Jeff_D]

Everyone gave up? No one has an idea on how to resolve this?

[WLD]

I guess your only option is to hack the source it would seem.  I have to say it is odd a semicolon was chosen rather than a comma.  It's called Comma-Separated-Values for a reason lol


On Thursday 27 Jan 2011 22:34:54 Jeff_D wrote:
> Everyone gave up? No one has an idea on how to resolve this?

------------------------------------------------------------------------------
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires
February 28th, so secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsight-sfd2d
_______________________________________________
eGroupWare-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/egroupware-users

[sank]

I had a similar problem as you.  I'm running 1.8.0

I fully agree that it makes absolutely no sense that egw uses semicolons as delimiters in Comma Separated Files.  An explanation would be helpful from the team.  Anyway, here's a very brief snippet from my personal installation changelog:

  etemplate/inc/class.nextmatch_widget.inc.php
    line 996:
      static public function csv_export(&$value,$separator=',')


Do a search for ';' and you'll find a bunch.  This one on my line 996 is in the csv_export function, which is called when I press the save icon in an etemplate table.  You can search for ';' in other files too if your export is coming some other way.

[Jeff_D]

Awesome, thank you very much!
________________________________________
From: sank [via EGroupware] [[hidden email]]
Sent: Tuesday, December 27, 2011 4:44 PM
To: Jeff Dore
Subject: Re: Timesheet Export to CSV Garbled.

I had a similar problem as you.  I'm running 1.8.0

I fully agree that it makes absolutely no sense that egw uses semicolons as delimiters in Comma Separated Files.  An explanation would be helpful from the team.  Anyway, here's a very brief snippet from my personal installation changelog:

  etemplate/inc/class.nextmatch_widget.inc.php
    line 996:
      static public function csv_export(&$value,$separator=',')


Do a search for ';' and you'll find a bunch.  This one on my line 996 is in the csv_export function, which is called when I press the save icon in an etemplate table.  You can search for ';' in other files too if your export is coming some other way.

________________________________
If you reply to this email, your message will be added to the discussion below:

NAML<http://egroupware.219119.n3.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.InstantMailNamespace&breadcrumbs=instant+emails%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>