Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Generic Import MEMO field

Questions about updating prices or transactions in Fund Manager

Postby elliots » Sun Dec 07, 2014 12:13 pm

Mark,

I've got a generic import file that works well except the MEMO field won't import. I've got MEMO in the format string (on the end, no delimiter after). I've tried adding text delimiters (" or ') to the field data and that doesn't help. I'm assuming the MEMO field is the field showing in the transaction list or report.

Elliot
elliots
 
Posts: 167
Joined: Sun Sep 28, 2008 11:29 am
Location: West Palm Beach, FL

Postby Mark » Sun Dec 07, 2014 1:12 pm

Hi Elliot,

If you have quotes in the data file, then you want quotes in the format string. The MEMO field is the transaction memo. If you are importing a CSV file, you might want to open it in Notepad instead of Excel, so you can see how the raw data is formatted.

If you want, you can post a sample line from your CSV file, and the format string you're using.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11583
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby elliots » Sun Dec 07, 2014 1:17 pm

Mark,

Sorry, false alarm. It actually did import the memo field; it just didn't show the memos on the preview screen before the actual import.

Elliot
elliots
 
Posts: 167
Joined: Sun Sep 28, 2008 11:29 am
Location: West Palm Beach, FL


Return to Prices and Transactions

Who is online

Users browsing this forum: Google [Bot] and 18 guests

FundManagerSoftware.com | Search | Site Map | About Us | Privacy Policy
Copyright © 1993-2024 Beiley Software, Inc. All rights reserved.