Skip to main content

I would like to update my database with an excel file the problem is that it is on a cloud. This is a doc itself updated by several partners. Is it possible with fme to recover this data?

Thank you in advance for your help

Short answer yes, to give a longer answer, we need some more details:

  • Where is it stored? O365, Dropbox, GDrive?
  • Do you have access?
  • Is it just new rows being added? or does the schema change?

Think of your help:

- it is stored on NFS, 

- yes I can request access

- yes the diagram doesn't change it’s just to add lines 


Think of your help:

- it is stored on NFS, 

- yes I can request access

- yes the diagram doesn't change it’s just to add lines 

Just to clarify, NFS is Cloudian, right? It appears to be S3 compatible so maybe the regular S3 options within FME would already do the trick. Otherwise I'm sure they'll have an API so you can use an HTTPCaller to download the file and process it.


Good morning,

 

Thanks for the information indeed the support gave me the tool.

thank you


Reply