File system document?

hpl123

Hi all,
I´m trying to figure out how the file system document attribute option (i.e using local server files instead of DB files for document attributes) works. Has anyone used this option successfully and can share how it´s done?
Thanks

hpl123

hpl123 wrote
Hi all,
I´m trying to figure out how the file system document attribute option (i.e using local server files instead of DB files for document attributes) works. Has anyone used this option successfully and can share how it´s done?
Thanks

Or support, if you could provide some pointers. Thanks

aware_support

The attribute that stores the path of the document must have the correct path for the instance of the object being saved. How the path is set into this attribute is entirely up to you. In most cases you would have a rule that would set a path depending on some other attributes of the object.

hpl123

Thanks support,
I have tried to do just that but haven´t succeeded. I will test some more.

weblike

Hi hlp123,

Have you succeeded with this?
I'm trying to use this option but no luck.
My scenario is as follows:
I have UserDefDocs with Ms Word Documents as templates
With a process I export the UserDefDoc to a specified Path. (c:\Invoices

EXPORT DOCUMENT InvoiceBO.InvoiceDocument.UDD_Name TO FILE '<<InvoiceBO.PDFInvoice_Path>>/<<InvoiceBO.InvoiceNumber>>.doc'
EXECUTE PROGRAM '<<SystemSettings.InstallPath>>\thirdpartyPDFconverter.exe <<InvoiceBO.PDFInvoice_Path>><<InvoiceBO.InvoiceNumber>>.doc'

Everything is ok for above rules. I can see the created PDF file.

Now I want to import it to FileSystem and I entered the rule bellow:

IMPORT DOCUMENT InvoiceBO.PDFInvoice FROM '<<InvoiceBO.PDFInvoice_Path>><<InvoiceBO.InvoiceNumber>>.pdf'

but I get the following error:

Internal system errorTransaction exception Unable to write document into file system. Exception message C:\Invoices (Access is denied). File path C:\Invoices may be invalid
C:\Invoices is a folder which exists....

Thank you.

kklosson

Try setting the path to ...\AwareIM\Tomcat\Webapps\AwareIM\Temp

...assumes no paths changed from standard installation.
...you have to create the Temp folder first
...you may choose to create and use subfolders at this location
...I find that my app can't create the Temp folder but it can create the subfolders, go figure

Rationale: I don't think that Tomcat can write to the C: drive, AFAIK. Plus, if you call a file from a URL, it will have to be in a location relevant to the webapp path like this.

RentProperty

Dear Weblike

I'm very interested to know what this thirdPartyPDFConverter is that you have used and how to implement this as I have a similar need to convert Doc's to PDF automatically. Would you mind sharing your expertize? Will be MUCH appreciated.

Kindest Regards

Hein

weblike

Hi there,

Of course. Gladly to share. I'm implementing 7PDF Maker from http://www.7-pdf.de/produkte/7-pdf-maker. I have installed it on C:\7PDF path to be easier.
Just keep in mind that 7PDF doesn't allow spaces in Folder Names/document names, but you can avoid this with REPLACE PATTERN function.

Then Execute Command is as I wrote above.
If you need further advices, please let me know.

Now I'm playing with file system documents as I don't want to keep PDF documents in DB.

hpl123

weblike wrote
Hi hlp123,

Have you succeeded with this?
I'm trying to use this option but no luck.
My scenario is as follows:
I have UserDefDocs with Ms Word Documents as templates
With a process I export the UserDefDoc to a specified Path. (c:\Invoices

EXPORT DOCUMENT InvoiceBO.InvoiceDocument.UDD_Name TO FILE '<<InvoiceBO.PDFInvoice_Path>>/<<InvoiceBO.InvoiceNumber>>.doc'
EXECUTE PROGRAM '<<SystemSettings.InstallPath>>\thirdpartyPDFconverter.exe <<InvoiceBO.PDFInvoice_Path>><<InvoiceBO.InvoiceNumber>>.doc'

Everything is ok for above rules. I can see the created PDF file.

Now I want to import it to FileSystem and I entered the rule bellow:

IMPORT DOCUMENT InvoiceBO.PDFInvoice FROM '<<InvoiceBO.PDFInvoice_Path>><<InvoiceBO.InvoiceNumber>>.pdf'

but I get the following error:

Internal system errorTransaction exception Unable to write document into file system. Exception message C:\Invoices (Access is denied). File path C:\Invoices may be invalid
C:\Invoices is a folder which exists....

Thank you.

I found another way to go about the thing I wanted so I never really got anywhere with this. I did try though and could never really get it to work. If you (or other) developers get this working: a short guide to replicate in our own applications would be appreciated. Thanks

weblike

Hi hpl123,

Thanks for your reply.

I have tried to do what kklosson suggested. I have created a Temp folder in \AwareIM\Tomcat\Webapps\RenamedFolder\Temp

Also tried with existing \AwareIM\Tomcat\Webapps\RenamedFolder\TEMP_RESOURCES

but no luck....I get same error:

Internal system errorTransaction exception Unable to write document into file system. Exception message C:\AwareIM\Tomcat\webapps\APPS\TEMP_RESOURCES (Access is denied). File path C:\AwareIM\Tomcat\webapps\APPS\TEMP_RESOURCES may be invalid

I have searched in userguide but no examples.
If anyone managed to deal with this will be much appreciated if share with us...
Support, can you give a helping advice(example) here?This will be also be much appreciated.

Thank you

RentProperty

weblike wrote
Hi there,

Of course. Gladly to share. I'm implementing 7PDF Maker from http://www.7-pdf.de/produkte/7-pdf-maker. I have installed it on C:\7PDF path to be easier.
Just keep in mind that 7PDF doesn't allow spaces in Folder Names/document names, but you can avoid this with REPLACE PATTERN function.

Then Execute Command is as I wrote above.
If you need further advices, please let me know.

Now I'm playing with file system documents as I don't want to keep PDF documents in DB.

Thank you So much WebLike!! Downloaded it and got it working in no time using the Sytax you described. This is going to make it alot easier to design nice looking reports in WORD and converting to PDF rather than Designing with The Report Designer.

weblike

Glad could help...

How do you store your documents in DB or in file system???
I'm not getting anywhere with storing documents in File System... I know i'm missing a little stuff here, but I can't figure it out....

thx.

RentProperty

weblike wrote
Glad could help...

How do you store your documents in DB or in file system???
I'm not getting anywhere with storing documents in File System... I know i'm missing a little stuff here, but I can't figure it out....

thx.

Hi Weblike, no sorry I am still using DB storage so haven't got round to play with the file system yet, but will let you know if I do and I get it working. Might need it soon.

Kind Regards

Hein

weblike

Bingo my friends...
I have achieved to do what I wanted...after few days of reading user-guide, forum posts and lot of testing.

I post here my experience with File system if anyone will need it:

The process is like this
EXPORT DOCUMENT InvoiceBO.InvoiceDocument.UDD_Name TO FILE '<<InvoiceBO.PDFInvoice_Path>>/<<InvoiceBO.InvoiceNumber>>.doc'
EXECUTE PROGRAM '<<SystemSettings.InstallPath>>\thirdpartyPDFconverter.exe <<InvoiceBO.PDFInvoice_Path>><<InvoiceBO.InvoiceNumber>>.doc'
IMPORT DOCUMENT InvoiceBO.PDFInvoice FROM '<<InvoiceBO.PDFInvoiceImportPath>>'

This is the trick.
You have to declare another File Path which includes the PDF file too(example: C:\AwareIM\Invoices\Invoice001.pdf). I have created attribute <<PDFInvoiceImportPath>>
With a rule in BO you have to instert the value of the full path in this attribute and the IMPORT DOCUMENT will wok.

Kind regards..

hpl123

weblike wrote
Bingo my friends...
I have achieved to do what I wanted...after few days of reading user-guide, forum posts and lot of testing.

I post here my experience with File system if anyone will need it:

The process is like this
EXPORT DOCUMENT InvoiceBO.InvoiceDocument.UDD_Name TO FILE '<<InvoiceBO.PDFInvoice_Path>>/<<InvoiceBO.InvoiceNumber>>.doc'
EXECUTE PROGRAM '<<SystemSettings.InstallPath>>\thirdpartyPDFconverter.exe <<InvoiceBO.PDFInvoice_Path>><<InvoiceBO.InvoiceNumber>>.doc'
IMPORT DOCUMENT InvoiceBO.PDFInvoice FROM '<<InvoiceBO.PDFInvoiceImportPath>>'

This is the trick.
You have to declare another File Path which includes the PDF file too(example: C:\AwareIM\Invoices\Invoice001.pdf). I have created attribute <<PDFInvoiceImportPath>>
With a rule in BO you have to instert the value of the full path in this attribute and the IMPORT DOCUMENT will wok.

Kind regards..

Great stuff, thanks for sharing.

weblike

Hi RentProperty,

Have you tested 7PDF?

I have the following problem. When the PDF is displayed on the screen and I try to print directly without saving, on printed paper I have only hieroglyphs... 🙁...
I tried to use DISPLAY DOCUMENT pdf IN WINDOW
same thing...

Thank you

weblike

Anyone,

Can you suggest another third-party word .doc, .docx to PDF command line converter?

We have tested 7PDF but the converted PDF documents contains strange characters when are printed directly from the browser.

Appreciate any idea.

Thank you.

hpl123

weblike wrote
Hi there,

Of course. Gladly to share. I'm implementing 7PDF Maker from http://www.7-pdf.de/produkte/7-pdf-maker. I have installed it on C:\7PDF path to be easier.
Just keep in mind that 7PDF doesn't allow spaces in Folder Names/document names, but you can avoid this with REPLACE PATTERN function.

Then Execute Command is as I wrote above.
If you need further advices, please let me know.

Now I'm playing with file system documents as I don't want to keep PDF documents in DB.

George,
Trying to set up the word to pdf convert using 7-zip (thanks for the info/guide by the way 🙂 ) and I wanted to ask you about how you / Aware IM / 7-zip handle multiple files being converted at the same time? If I for example have a process that (just like in your scenario):

EXPORT DOCUMENT (Word)
EXECUTE PROGRAM (Word to PDF)

and I use the same folder for example "C:/7dfconvert" and same filename file.doc. What would happen if my process above is executed multiple times? Will the solution handle this correctly or should one use a different name for each file to make sure all works?

Thanks in advance.

Powerm

What about security ??? I won't store confidential infos on a Tomcat folder.

hpl123

Powerm,
Did you reply to this topic or another? If this one, please clarify?