Best of Support

Importing data from an external CSV source

Issue

How to import lists from an external data source.

Solution:

There are a few options available. In the FillPoint Editor, click the Tasks tab. Double-click Lists, and then double-click List. Click the Import task and then press F1. The help opens, offering some samples of how to import a list.

 

In your case you might need something like this:

 

If the GhostFill List does not yet exist:

%[MyList=Lists.New()]

%[MyList.Import("CSV", "MyCSVSstring")]

%[MyList.SaveAs("\ApplicationMapping", "MyListName")]

 

If the GhostFill List does exist:

%[MyList=Lists.Select("\ApplicationMapping", "MyListName")]

%[MyList.Import("CSV", "MyCSVSstring")]

%[MyList.Save("\ApplicationMapping", "MyListName")]

 

Daniel Todes