Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread Content of Memo Fields doesn't Export from DBISAM Database System Utility
Fri, Dec 5 2014 10:34 AMPermanent Link

robkraft

I recently downloaded the utilities including DBISAM Database System Utility Version 4.40.  I am trying to export data out of some DBISAM tables, but the content of Memo fields does not get exported to my .CSV files.  I can't find any configuration options related to this, so I assume this is a bug.

If so, can it be fixed soon, or do you know if it works on older versions of the software?

Thanks,

Rob Kraft
Fri, Dec 5 2014 11:03 AMPermanent Link

Raul

Team Elevate Team Elevate

On 12/5/2014 10:34 AM, robkraft wrote:
> I recently downloaded the utilities including DBISAM Database System Utility Version 4.40.  I am trying to export data out of some DBISAM tables, but the content of Memo fields does not get exported to my .CSV files.  I can't find any configuration options related to this, so I assume this is a bug.
> If so, can it be fixed soon, or do you know if it works on older versions of the software?

Not a bug but by design. Data in memo contain data not supported by CSV
for example - dbsys has no way of knowing.

If you know your memo data is OK (i.e. is clear text with no line breaks
or other control characters) you might be able to cast it to string and
export that.

Otherwise for more complex data every application can implement their
own custom export/import.

Raul
Fri, Dec 5 2014 4:00 PMPermanent Link

robkraft

Thanks for the quick reply Raul. I guess that makes sense.  It took me a few hours but I've got it working with ODBC.
Image