Alastair,
making a program to convert the .docs to .rtfs doesn't seem too difficult.
The second part seems somehow more cumbersome to me.
So if you could give me that head start....I would accept it very gladly....
best regards,
Luc D.
--------------------------------------------------
From: "Alastair Burr" <[email protected]>
Sent: Monday, August 23, 2010 6:21 PM
To: "RBASE-L Mailing List" <[email protected]>
Subject: [RBASE-L] - re: uploading .doc in rbase
If you can record & edit or write a macro in Word you can convert your
files to .RTF if you want to go that route.
It's possible to write a command file in R:Base to list your directory(s)
containing the files, load the results into a temp table then insert the
files to your database using the temp table to locate the files.
If you need help with the second part I can copy and paste an example for
you - if you let me know - that should give you a head start.
Regards,
Alastair.
--------------------------------------------------
From: "Luc Delcoigne" <[email protected]>
Sent: Monday, August 23, 2010 4:39 PM
To: "RBASE-L Mailing List" <[email protected]>
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.
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.851 / Virus Database: 271.1.1/3088 - Release Date: 08/22/10
19:35:00
