• Skip to primary navigation
  • Skip to main content
Fellow Consulting AG

Fellow Consulting AG

where people work together

  • Products & Services
    • Digital Transformation
    • Infor OS
    • Ephesoft Transact – IDM Capture
      • FellowKV²-Plugin
      • TableExtraction² Plugin
    • Marketing & CRM
      • SugarCRM
        • Sales & Service
          • Sugar Sell
          • Sugar Serve
          • Business Intelligence – Sugar Discover
        • Marketing
          • Sugar Market
        • Customer Data Management
        • Appointment Calendar
        • Follow-ups
        • Free SugarCRM 30 days trial
      • Oktopost – Social Marketing
      • Sugar Market
  • Customer Success Stories
    • MVTec – SugarCRM for a global manufacturer
    • Bet3000 – SugarCRM for Gambling
    • Coloplast – Mobile CRM for Life Science
    • Diversey – Mobile CRM and Maintenance for Cleaning and Hygiene
    • Diversey – Online Shop implementation
    • Jochen Schweizer – SugarCRM for Leisure
    • Acnos Pharma GmbH streamlines workflow
  • Fellow
    • About Us
    • Career: We are hiring!
    • Contact Us
    • Change Optin
    • Partners
  • Show Search
Hide Search

Dynamic CSV Import into SugarCRM via Azure Function

Thomas Dillinger · 12. March 2019 ·

Teilen

Microsoft Azure is easy going – with only a few lines of code you can create a CSV importer for SugarCRM. Free of charge up to 1 Million requests per month!

First of all, you create an Azure Function.

python3 -m venv fellowdemo
source fellowdemo/bin/activate
func init sugarfunc --worker-runtime python

Choose Azure Blob Storage Trigger, then add the Blob service in the Azure Portal.

After creating the blob, you need to enter the key in the function.

Define the file in the function

The import script takes only a few lines:


Create a simple CSV file to test the script.

Upload the file into the blob storage.

A second later, you see the file being processed:

An the records are created in the SUGARCRM!

Wow, having done a CSV import interface in a few lines of code!

More technical blogs:

  • Digitization forces low-code development
  • Digitalization: Shifting from short-term continuity to long-term transformation
  • Doc² Integration to Infor
  • What is Deep Learning?
  • 90% manual work


Teilen

Azure, Azure Function, Integration, News, Python, SugarCRM Azure, Azure Function, Integration, News, Python, SugarCRM

Additional blogs:

Digitization forces low-code development

Did you know that over 90% of the total number of invoices issued globally are still processed manually?

Yes, you read that right. Less than 10% of all invoices are automatically processed! This takes a huge toll on AP departments.

Digitalization

Digitalization: Shifting from short-term continuity to long-term transformation

The pandemic has served as a wake-up call for many finance organizations and – if they hadn’t already started – they implemented more digital processes. 
 
However, it is important to ensure these new workflows are sustainable. Here’s how:

Doc² Integration to Infor

DOC² is the newest document capturing software and solution developed by Fellow Consulting AG. It’s a completely AI and cloud-based solution that enables optical character recognition (OCR) capabilities and provides with a more automatic and self-learning capturing process. Most importantly is that apart from the extraction of meaningful data, it can also offer numerous connection functions for ERP systems such as Infor, SAP, Microsoft and […]

What is Deep Learning

What is Deep Learning?

The Magic of deep learning. Deep learning is a sub-area of machine learning and uses neural networks and large amounts of data. The learning methods are based on the functioning of the human brain and result in the ability to make one’s own prognoses or decisions. On the basis of existing information and the neural […]

90% manual work

Did you know that over 90% of the total number of invoices issued globally are still processed manually?

Yes, you read that right. Less than 10% of all invoices are automatically processed! This takes a huge toll on AP departments.

  • Contact Us
  • Privacy policy
  • Imprint
  • AGB