Reading attachment data and entering into a table

Jason Stephens · ‎09-10-2012

Is there any way to receive an email attachment (csv, xls), and write the data into a system table? I have a few places where I could use this functionality, but I can't seem to figure out how to do it, or if it's even possible. Has anyone ever done this?

Thanks for the help.

Jason

tony_fugere · ‎09-20-2012

There's a few out there have done this. I am one of them.

Scripting an Inbound Email Action to add attachments to a Data Source
Data imports from email attachments

Here is a Script Include I've had success with after learning from the posts above.

Usage from Inbound Action:



var type = {};
type.schedule = 'Dell Shipping Report'; //Display name for scheduled import
type.table = 'u_import_dell_shipping'; //Import table name

u_importViaEmail(type, 'Dell Shipping Report');

Script:



function u_importViaEmail(type, logSource) {
  if(type.schedule != '' &amp;&amp; type.table != '') {
    gs.log('1. Setting up data source', logSource);
    current.name = type.schedule + ' ' + gs.nowDateTime(); //append date time to name of data source for audit
    current.import_set_table_name = type.table;
    current.import_set_table_label = "";
    current.type= "File";
    current.format = "Excel";
    current.file_retrieval_method = "Attachment";

    var myNewDataSource = current.insert();

    gs.log('2. Data source inserted with sys_id - ' + myNewDataSource, logSource);

    //point the scheduled import record to the new data source
    var gr = new GlideRecord ('scheduled_import_set');

    gr.addQuery('name', type.schedule);
    gr.query();

    if (gr.next()) {
      gs.log('3. Found Scheduled Import definition', logSource);
      gr.data_source = myNewDataSource;
      gr.update();
      gs.log('4. Scheduled Import definition updated to point to data source just added', logSource);

      Packages.com.snc.automation.TriggerSynchronizer.executeNow(gr);

    } else {
      // add error conditions to email somebody that this has occurred
      gs.log('5. ERROR - Unable to locate scheduled import definition. Please contact your system administrator', logSource);
    }

    gs.log('6. Inbound email processing complete', logSource);
  } else {
    gs.log('7. Inbound email processing skipped', logSource);
  }
}

View solution in original post

odijk · ‎01-02-2018

Package calls are sooooo 2012...

There used to be a wiki article with a list of replacements for each of the package calls, but that seems to have been moved.

sowmya01236 · ‎03-28-2019

Hi Sumit,

Did you find any other solution to read the .csv files and insert data into tables ?

Thanks,

Sowmya