CSV data mess with Invoice export - any workaround?
Thread poster: Peter Sass

Peter Sass
Germany
Local time: 06:24
Member
English to German
+ ...
Oct 29, 2012

Hi there,

I love the billing feature, yet the invoice export via the CSV format does not seem to work properly. When trying to import the CSV data into common spreadsheet programs like Excel or Calc (OpenOffice), the columns get messed up, e.g. invoice dates and descriptions entered in one column etc. I've tried all the possible tweaks for data import, but none works to distribute the data into different columns.

Since this has been noted before, is there a workaround?

Unfortunately, the one mentioned by Juho Karhu here
http://www.proz.com/forum/prozcom:_translator_coop/158290-announcing_invoicing_tool_updates:_payment_reminders_custom_formatting_purchase_order_number_more-page7.html#1866286
, i.e. converting the CSV to XML before importing to Excel, does not seem to work either.

I'd be most thankful for any ideas on this!


Direct link Reply with quote
 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

CSV data mess with Invoice export - any workaround?

Advanced search






Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »
CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use SDL Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search