• State Suggested Answer
  • Locked Locked
  • Replies 7 replies
  • Answers 1 answer
  • Subscribers 96 subscribers
  • Views 8110 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Upload file and read into collection

kinshasa
over 7 years ago

Hi Experts,

I have a file upload node using which I upload a file to a server. I think trigger an event and read that data into a table. So far so good. 

I now need to load this data into a collection. To do this, I though of using a while loop with the condition

0 = select count() from BulkUploadUsers

Inside the loop, I load the collection.

I thought the collection will be loaded in one go, however the while loop quits after it loads the first object.

 

Is there some way to effectively give feedback from the backend to the front end that it can now load the collection?

 

Thanks

Kin

Parents
  • 0 over 7 years ago

    Hi

    What you can do is to write a script that will read in all files in a directory an return them as a semicolon separated string. So, you are able to call this script after uploading a file  to fill your collection with the option "Fill from expression". To get a result set for the collection you need to split the semicolon separated string by using the built-in function Split().

    For further details see the following printscreen:

    Ensure that you also need to write a DialogScript function that will be able to read in all files from a directory. The function should have one parameter, so that you are able to submit the full quallified path of the directory. The return value should be a semicolon separated string. If you want to upload your files to a file share in your company network you have to ensure that your ApplicationPool user have the appropriate access rights to this share. Otherwise the access via your web frontend will fail (in this case it is recommended to use an own AD account for the ApplicationPool identity).

    -
    Regards
    Sven

Reply
  • 0 over 7 years ago

    Hi

    What you can do is to write a script that will read in all files in a directory an return them as a semicolon separated string. So, you are able to call this script after uploading a file  to fill your collection with the option "Fill from expression". To get a result set for the collection you need to split the semicolon separated string by using the built-in function Split().

    For further details see the following printscreen:

    Ensure that you also need to write a DialogScript function that will be able to read in all files from a directory. The function should have one parameter, so that you are able to submit the full quallified path of the directory. The return value should be a semicolon separated string. If you want to upload your files to a file share in your company network you have to ensure that your ApplicationPool user have the appropriate access rights to this share. Otherwise the access via your web frontend will fail (in this case it is recommended to use an own AD account for the ApplicationPool identity).

    -
    Regards
    Sven

Children
No Data