Yes, Paul,
this is a one-time-only conversion.
I've worked with my previous Access-database for 13 years.
I expect the new R-base database to serve me well for the next 15-20 years
of my career as a radiologist.
After that...well, it might be 'The Day After'.....who knows.....
But I have to be able to see and if necessary print the 'old' radiology
reports.
The goal is to have a software that is independent. So no external
word-editors....
Makes it much easier to install on several Pc's.
And this, without losing any of the info that was in the old Access
database.
In the new Rbase database no new .docs will be generated as the reports will
be dictated directly in an advanced DB Rich Text Varchar field.
Luc D.
--------------------------------------------------
From: "Paul" <[email protected]>
Sent: Monday, August 23, 2010 6:54 PM
To: "RBASE-L Mailing List" <[email protected]>
Subject: [RBASE-L] - re: uploading .doc in rbase
Hate to be a pita but, is this a one-time deal conversion? Or are
users
still going to be generating these or receiving .doc's and this is an
ongoing process?
I assume you are data mining this data after?
Paul
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Luc
Delcoigne
Sent: Monday, August 23, 2010 12:30 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - re: uploading .doc in rbase
Hi Paul,
I must be able to read the .doc files in an advanced DB Rich Text field in
the database.
This way I can see the text directly without the need to launch an
external
editor such as word.
Luc D.
--------------------------------------------------
From: "Paul" <[email protected]>
Sent: Monday, August 23, 2010 6:14 PM
To: "RBASE-L Mailing List" <[email protected]>
Subject: [RBASE-L] - re: uploading .doc in rbase
Are you trying to convert and load? Example: As Razzak said convert
something_MS1.doc to a rtf something_MS1.rtf and save as a varchar in
the db.
Or just load these .doc files into the db in the original .doc format?
Example: something_MS1.doc > save as varchar and open it needed as >
launch something_MS1.doc ||w after you output it from the
table/varchar.
Paul
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Luc
Delcoigne
Sent: Monday, August 23, 2010 11:40 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - re: uploading .doc in rbase
Hello Razak,
thanks for the tip.
But this seems to be a very 'manual' way to do it and quite achievable
for a small number of documents.
However I have to read more than 80.000 word-documents into the database.
It
then seems not an option to do this manually.
Isn't there a way to automate this and speed things up ?
Luc D.
--------------------------------------------------
From: "A. Razzak Memon" <[email protected]>
Sent: Monday, August 23, 2010 5:19 PM
To: "RBASE-L Mailing List" <[email protected]>
Subject: [RBASE-L] - re: uploading .doc in rbase
At 10:34 AM 8/23/2010, Luc Delcoigne wrote:
in my Access > Rbase conversion I have come to the point that I have
to load .doc files into the varchar field of an rbase table.
What would be the most elegant way to this, considering there are
more than 80.000 files to upload in the table....?
Luc,
Here's how I have converted/stored all .doc files into R:BASE.
01. Open the original .doc file(s) in MS Word and then save as
.RTF to preserve the original formatting, etc.
02. Then, load these .rtf file(s) in R:BASE as VARCHAR or BLOB
(VARBIT) data type.
Use the appropriate data type (VARCHAR/VARBIT) accordingly.
03. Once stored in R:BASE, you may take advantage of enhanced
Blob Editor to manage all your documents, etc.
Tip:
When using the enhanced R:BASE BLOB Editor, make sure to
select [Rich Text] option/tab to manage .rtf files.
04. To print these documents in R:BASE eXtreme 9.0 reports,
make sure to use Advanced DB Rich Text Control.
That's all there is to it!
2010 Annual R:BASE Conference Highlights include a session to
demonstrate the use of such features in R:BASE eXtreme 9.0.
http://www.rbase.com/conference/
Very Best R:egards,
Razzak.
