Parse backup file in Excel

Asked by Arnaud on 2012-05-12

Hello,

I am going to begin an Excel file dedicated to give advanced features about results. This is for personal use, but it makes no problem to release it to the community if it's needed.
I found out that the CSV file does not export enough information (no attributes, rates...), but the database (regular backup file) needs more time to be parsed well, because of its complexity. This file is also easier to export automatically...

I saw on blueprints that there is one about exporting\sync in Excel format. I want to know, because I don't really understand this system, if this project is currently running, so there is no interest I double it with my own personal project.

If it is started, or on the way, I can help if you need.

Thanks in advance, and great job, this is one of the most useful apps you can find on the market...

Question information

Language:
English Edit question
Status:
Answered
For:
Financisto Edit question
Assignee:
No assignee Edit question
Last query:
2012-05-12
Last reply:
2012-06-26

Hi, there have not been much progress with "sync-with-excel" project. You're totally welcome to improve CSV export! Please let me know if you would need any information/help. Thanks!

Arnaud (lenainnoir) said : #2

Hi,

I did a very basic file, very close to my needs so I am not sure it will match with everyone, especially because I'm french so I did not include some non-french features, as credit card management...

Here are the file features:
> Full automated CSV import (you just need to select the file)
> Automatic layout on importations (basic)
> Added a column in Importations "P" to point Operations, for example when you compare with a monthly bank log.
> Overview sheet: displays all accounts, balance, debit, credit, daily, weekly and monthly use, balance prevision at a day. Everything is calculated between dates specified by the user.
> Dynamic table. You can virtually obtain every information you need in a few seconds.

The file is provided with 4 sample operations. You need to delete them before importing yours but make sure you import a new CSV file before doing anything else to the file (I still have some problems with VBA when the file is empty).

Here's the link: https://docs.google.com/open?id=0B3Cd2bwkxsdMcl9kcEFmek5neTQ
Compatibility: Microsoft Office Excel 2010 (older versions not tested).

If you have any idea, do not hesitate to propose, maybe i'll work on it later ! I am open to any comment.

______________
An import only adds operations newer than the newest of the file. Take it in account when you import.
Actually the file imports the CSV in a hidden sheet named "Import", then applies some layout modifications before including it in the "Operations" sheet.

james27 (biork25jameson) said : #3

Backup and Recover excel files thanks to next utility http://www.excel.fixtoolbox.com utility starts recovering excel files with MS Excel 95 version

Can you help with this problem?

Provide an answer of your own, or ask Arnaud for more information if necessary.

To post a message you must log in.