transferring document

crisg0112

Hi,

How do I transfer a document type from one BO (app_A) to another BO (app_B)?

Basically, the user uploads the document in app_A and I have a scheduled process that grabs all the uploaded files in app_A then copies the document in app_B

tford

Are you creating a new instance of app_B or do you need to find a particular instance of app_B to copy the doc to?

crisg0112

tford wrote
Are you creating a new instance of app_B or do you need to find a particular instance of app_B to copy the doc to?

Hi Tom,

creating a new instance on App_B

kklosson

ObjectB.Doc=ObjectA.Doc

tford

To create a new instance, very similar to the one above:

CREATE ObjectB WITH ObjectB.Doc=ObjectA.Doc

crisg0112

tford wrote
To create a new instance, very similar to the one above:

CREATE ObjectB WITH ObjectB.Doc=ObjectA.Doc

Thanks Kingsley and Tom.

Let me explain the whole process

1) App_A is used by guest logon. Here they upload all the files they want.

2) App_B is use by the registered users.
The way App_B reads App_A data is by defining the Business Objects of App_A as an external database.

App_A has a BO called FileUploads with attribute:
FileSize (Number)
FileUploaded (Document)

App_B has the following BO's

ValidFileUploads (internal awareim)

FileSize (Number)
ValidFile (Document)
DateChecked (Date)

ext_FileUploads (this BO is from App_A)

EXT_ID
EXT_BASVERSION
EXT_BASTIMESTAMP
FIleUploaded_DOCDATA (binary data)
FileUploaded_DOCTYPE (plain text)
FileSize

Using CREATE ValidFileUploads WITH ValidFileUploads.ValidFile=ext_FileUploads.FileUploaded_DOCDATA doesn't work, it just creates a record but the document is not created.

kklosson

I assume "doesn't work" means that no data is entered into the doc attribute. I recommend you try any process to copy the blob from one database to the other. I'm out of my depth in any difference between MSSQL and MySQL blob data, but it could be a factor. I don't know if MSSQL has more than one blob type either. But I suggest Googling on the the differences between the databases as far as blobs go.

crisg0112

kklosson wrote
I assume "doesn't work" means that no data is entered into the doc attribute. I recommend you try any process to copy the blob from one database to the other. I'm out of my depth in any difference between MSSQL and MySQL blob data, but it could be a factor. I don't know if MSSQL has more than one blob type either. But I suggest Googling on the the differences between the databases as far as blobs go.

Hi Kingsley,

looks like you're right, transferring binary data in MSSQL (using SP) is not as simple as it seems but doable. And how to do it in Aware is another thing.

RLJB

Hey Chris, don't store it as a blob, put it in a file directory (or export it there), pass the file location/path and then create and reference it or import it.

crisg0112

RLJB wrote
Hey Chris, don't store it as a blob, put it in a file directory (or export it there), pass the file location/path and then create and reference it or import it.

Hi Rod,

I wish I could but this is more of a 'unsecure location' to a 'secure location' transfer. I cannot have any of the files sitting in the server at all.

Thanks for the idea though 🙂 ...

customaware

Do as Rod said ..... Import it and then delete it off the server

crisg0112

eagles9999 wrote
Do as Rod said ..... Import it and then delete it off the server

Mark,

let me explain the scenario 🙂

users will be accessing app_A, uploading the documents as needed, the physical files gets deleted after its been imported into its respective BO.

now App_B has a scheduled process (every 15 minutes) to read what's been entered into App_A.

App_B is accessing App_A database. App_A's table is defined as external database (objects) in App_B.

I agree that Rod's solution will work, but not in this case.