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]

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]

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)

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

ext_FileUploads (this BO is from App_A)

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

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]

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]

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.