Marco,
it's always the same.
Every report is defined by the patientnumber (Punieknummer) and the
consultnummer, just as the images are.
My idea was to scroll through through the database from row 1 one to the
last, put the PatID and the Consultnummer in a variable and read in the
files.
the doc-files are all in a directory that is named by the PatID and the
file itself is named according to the consultnummer.doc.
So I have to to upload these files with those two parameters.
The problem is how to get the word-document into the varchar BLOB.
Gr
Luc D.
--------------------------------------------------
From: "Marco Groeneveld" <[email protected]>
Sent: Monday, August 23, 2010 7:06 PM
To: "RBASE-L Mailing List" <[email protected]>
Subject: [RBASE-L] - re: uploading .doc in rbase
Hi,
I understand you will convert doc to rtf. That is not so difficult and can
be automated with marco / software tool. (I will see what is available on
the net).
I understand you can upload a rtf file in R:BASE. But how will you
identify the rtf file to a patient / afspraak / behandeling record ? Maybe
this can be automated as well ?
Marco
----- Original Message -----
From: "Luc Delcoigne" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Monday, August 23, 2010 6:32 PM
Subject: [RBASE-L] - re: uploading .doc in rbase
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
