Technical forums » General technical issues »
CSV data mess with Invoice export - any workaround?
Thread poster: Peter Sass
Peter Sass
Peter Sass
Germany
Local time: 06:32
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?<... See more
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! ▲ Collapse
 


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

Moderator(s) of this forum
Laureana Pavon[Call to this topic]

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

CSV data mess with Invoice export - any workaround?






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 »
TM-Town
Manage your TMs and Terms ... and boost your translation business

Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.

More info »