Ask Your Question
0

How to edit CSV files exported from GenSoft Money Works?

asked 2017-02-27 12:06:27 +0100

ValentinD gravatar image

updated 2017-02-27 12:21:55 +0100

Can someone assist me? I need to be able to edit CSV files exported by GenSoft Money Works just to be able later to import them again for the needs of the program. I can supply an exported file for examination. And I'm willing to donate course :)

edit retag flag offensive close merge delete

Comments

Please do share a sample file, e.g. by a link to shared resource.

Mike Kaganski gravatar imageMike Kaganski ( 2017-02-27 12:54:21 +0100 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2017-02-27 12:13:28 +0100

robleyd gravatar image

Presumably you have LibreOffice? Have you tried opening the CSV files in Calc - you can then edit them and save as CSV file.

edit flag offensive delete link more

Comments

Certainly I have. I do open the file, but instead of fluently display it the LiebreOffice suggests some kind of Import and asks for Character set, Language and many other parameters. My assumption is that after importing it this way the csv type signature is somehow changed beyond comprehansion for the purpouses of import later in the GenSoft Money Works program. Do please take a look. image description http://imgur.com/aEJOK24

ValentinD gravatar imageValentinD ( 2017-02-27 13:15:10 +0100 )edit

Well, did you check this assumption? Of course, importing and exporting CSV needs careful operation, and by default the export part may cause troubles, because you need to match export setting to import ones to generate compatible output. Be sure to check Edit filter settings in "Save As" dialog and edit export settings as well.

Mike Kaganski gravatar imageMike Kaganski ( 2017-02-27 13:24:09 +0100 )edit

I am not sure I understand you but I checked the options in LiebreOffice and now have the impression that you forgot that I only export from a program. My problem consists of the fact my format specific file being imported by the Liebre Office instead of the Office being able to open it as it is and preserve the format structure for editing.

ValentinD gravatar imageValentinD ( 2017-02-27 14:08:22 +0100 )edit

CSV is a format that allows different representation in file. It may use different separators, encodings, etc, and they are not easily deduced from the file contents itself. That's why an import dialog is required, where you help LO to properly import the file.

But it is not enough to "preserve format structure" on saving. E.g., on the screenshot you've provided, you have checked Tab, Comma and Semicolon as separators. So, which of them to use on export? You need a separate export setup.

Mike Kaganski gravatar imageMike Kaganski ( 2017-02-27 14:28:16 +0100 )edit

It can be deduced from the data. Just try out different options according to what the preview looks like.

rautamiekka gravatar imagerautamiekka ( 2017-02-27 14:36:59 +0100 )edit

I meant it cannot be deduced by LO, that's why it needs your help.

Mike Kaganski gravatar imageMike Kaganski ( 2017-02-27 14:39:53 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-02-27 12:06:27 +0100

Seen: 86 times

Last updated: Feb 27 '17