![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Client/Server » View Thread |
Messages 1 to 4 of 4 total |
![]() |
Thu, Nov 30 2006 7:53 PM | Permanent Link |
"Eduardo" | Hi,
Does anyone knows how to export MEMO field type to a text file? And then, how to organize it so it can be imported from another database? Thanx Eduardo |
Fri, Dec 1 2006 10:10 AM | Permanent Link |
Sean McCall | You'll have to come up with you're own set of rules. My favorites are
CSV w/ everything quoted and w/ a literal character '^' and pipe separated w/a literal. So a single record in CSV would look like: "Field 1","121.111","Memo line 1 memo Line 2 Memo line 3 with a ^"Quoted Value^" Memo line 4", "Field 4" If you want to import these, I add control records & use the first 2 fields for commands: "$Table","MyTable" "$Fields","MyTable","Field 1","Field 2","Memo Field 3","Field 4" "$Insert","MyTable","Field 1","121.111","Memo line 1 memo Line 2 Memo line 3 with a ^"Quoted Value^" Memo line 4", "Field 4" This way you can store an entire database in a single text file. For BLOBs, you can use hex encoding. HTH, Sean Eduardo wrote: > Hi, > Does anyone knows how to export MEMO field type to a text file? > And then, how to organize it so it can be imported from another database? > > Thanx > Eduardo > > |
Fri, Dec 1 2006 10:28 AM | Permanent Link |
You might want to look at SMI/SME as it allows you to import/export
from dataset to dataset. (field mapping) http://www.scalabium.com Also, if you need to export, I have better luck exporting to XML especially if the memo/blob has special chars. SMI/SME has XML Another to look at is: http://www.deepsoftware.com/rsllib/ Regards, Scott. "Eduardo" <eduardo@brscan.com.br> wrote in message news:CE764653-463C-4D82-A5F1-A9C7255FDD65@news.elevatesoft.com... > Hi, > Does anyone knows how to export MEMO field type to a text file? > And then, how to organize it so it can be imported from another database? > > Thanx > Eduardo > > | |
Fri, Dec 1 2006 1:48 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Eduardo,
<< Does anyone knows how to export MEMO field type to a text file? And then, how to organize it so it can be imported from another database? >> You cannot export memo fields to text files in DBISAM due to the CRLF issues that exist. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Wednesday, August 14, 2024 at 07:31 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |