Skip to main content
Question

Files Maintenance -> Synchronization Type -> OneDrive


TimRodman
Pro I
Forum|alt.badge.img+1

Has anyone found a way to use one of the 4 out-of-the-box Synchronization Type settings (FTP, HTTP, Shared Folder, or SFTP) to sync a file with Office 365 OneDrive?

 

7 replies

Forum|alt.badge.img+1
  • Semi-Pro III
  • 141 replies
  • May 24, 2023

Hi, I have the same question.

 


Forum|alt.badge.img+10
  • Semi-Pro III
  • 229 replies
  • May 24, 2023

Hi @TimRodman,

 

You can refer the below link.

https://asiablog.acumatica.com/2016/08/sync-files-from-acumatica-to-ftp-server.html

 

Hope it helps!

Regards,

Sweta


darylbowman
Captain II
Forum|alt.badge.img+13

@sweta68 Is OneDrive an FTP server?


greglang
Varsity I
Forum|alt.badge.img+1
  • Varsity I
  • 61 replies
  • May 24, 2023

Tim, I actual started playing with this a few weeks ago with AirTable  and created an HTTP link to download a Table we use to track time for a project and it updates a data provider

I am then using the imported csv file to create appointments for a project.  I set an automation schedule to get the latest version every Monday afternoon (after all approvals are done) then a second automation to run the import scenario with the csv file right after. 

 

The file sync was easier than I thought for HTTP.  I put a sanitized screenshot of my configuration below if anyone is intrested. 

First manually upload a copy of the file you want to use.  In my case as a data provider.  then go to File Maintenance Screen (SM202510) from Tims screenshot above.  Under the tab Synchronization check Sync, Pick the Type and enter the path for your file or folder and any login info needed. 

For me I used CSVGetter to create a static link I could pull an updated table from each time I need it. for my import. 

Hope that helps.   This is a heck of a lot easier than in my case using a long string of API calls to Create, Start, Complete and Close appointments with an import scenario. 

 

I would love to hear other ways its being used!  OneDrive would be amazing

Cheers,  Greg

 


TimRodman
Pro I
Forum|alt.badge.img+1
  • Author
  • Pro I
  • 144 replies
  • May 31, 2023

Hi @greglang, I love Airtable, but didn’t know about csvgetter.com. Very cool! And what a great site name!

 

In my case, I’m looking to export Acumatica data into a CSV file in OneDrive. The reason is that Power BI can ingest CSV files really quickly. Using a CSV would bypass the need to stand up a Data Warehouse and worry about data types, etc.


  • 111 replies
  • July 17, 2023

It seems this function has not release. Please view the link and vote for this option

One Drive Integration for file uploading | Community (acumatica.com)


  • Freshman I
  • 7 replies
  • May 29, 2024

What storage platforms work for HTTP file sync? OneDrive for business does not include the embed features. We would like to sync to a cloud-based storage platform for stock item and template item product data. 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings