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. >> >> > >
