Append to CSV data?
Author: mht
Creation Date: 9/27/2010 12:11 PM
profile picture

mht

#1
Hello,
is there a possibility to store ascii data to another file and upload the new data to append them to this file, or do you have to handle your data in the csv file?

regards
mfh
profile picture

Cone

#2
Sure you can append data to a text file. But what do you mean about "the possibility" of doing this or "handle your data"? The question isn't clear to me.
profile picture

mht

#3
Hello Cone,

Sorry I have to be more precise. Is there a way of loading data from a csv file into wealth lab and store it within wealth lab to e.g. a binary file format. New data I like to upload again from a csv file and append it to the data in the other file. Something like updating a database from a csv file.

thanks for your effort

Regards

mfh
profile picture

Eugene

#4
With .NET, sure you can write to a binary file format (as well as read it), for instance --

Exporting as WLD/WLP 4.x native binaries (*.WL)

Question is, what's the point to complicate things? The ASCII provider works with CSV files at the speed of binary files due to caching (enabled in Data Manager > ASCII Data tab). There's no speed benefit in this complication.

QUOTE:
Something like updating a database from a csv file.

While I'm at it, early next month, we'll release the Database provider that will connect to any database supported by ADO.NET. For Wealth-Lab users, it also opens the possibility to append CSV data to a database (e.g. SQL Server) and load the data from the DB (we'll provide a sample code for example purposes.)
profile picture

mht

#5
Hello Eugene,

thanks you for your answer, I think that helps.

I don't want to complicate things, I only want to get rid of clearing my overlapping data and merge my csv files together.

regards

mfh
This website uses cookies to improve your experience. We'll assume you're ok with that, but you can opt-out if you wish (Read more).