Skip to main content
Question

Alternate ways to auto import data from a CSV besides Sync?

  • January 11, 2022
  • 0 replies
  • 43 views
Forum|alt.badge.img+20
I am trying to auto import data from a CSV. I tried syncing to Box/Dropbox. The problem is, the csv I get is saved as UTF-16 and to sync it must be UTF-8.

So in order for me to sync I would need to open up the file, and save-as a different format. I am trying to automate the entire process, so once a human has to open a file and save as, it blows that process.

Is there a way using Pipelines? Can I grab the file from email, or some other spot and parse through it?

------------------------------
Mike Tamoush
------------------------------

Forum|alt.badge.img+15
  • DonLarson
  • Registered
  • January 12, 2022
Mike,

What is the source of the CSV?  Can you go upstream one more layer to the parent where the format is different?

------------------------------
Don Larson
------------------------------
KeithJusas
Forum|alt.badge.img+7
  • KeithJusas
  • Registered
  • January 12, 2022
Hi Mike,
  another option...EZ File Importer: Demo here

Upload the csv file to a file attachment field and it automatically kicks off the EZ File importer.  No need to open it and resave it. 

Combined that with Email Parser and you can send an email with the csv as an attachment, Email Parser will upload the file to a file attachment field and kick off EZ File Importer

------------------------------
Keith Jusas
------------------------------
Terms & ConditionsAccessibility statement