Lantica User Forum - Mass Update records from Delimited File

(UTC)

Lantica User Forum › Lantica Discussions › Lantica Discussion › Mass Update records from Delimited File

(Moderator: Forum Admin)

‹ Previous Topic | Next Topic ›

Pages: 1

Mass Update records from Delimited File (Read 762 times)

Acebanner Full Member Offline Posts: 123 Location: New York City Joined: Jan 23^rd, 2008	Mass Update records from Delimited File Feb 22^nd, 2012 at 4:06pm	Print Post
	My company is using ConstantContact, and I was hoping to cobble together a way to manage our email contacts. CC allows me to export all my 'bounced' emails into a delimited file (.CSV) -- the format is: email, FirstName, LastName, Company I've isolated all the email address contacts that were bounced because the email address did not exist. What I would love to be able to do is have Sesame check all my contacts that match the email address, and if they do match, delete the email entry -- but not the record. How would I access the CSV file? Using Notepad++, each line appears as: "email@email.com","Yahoo","Serious","ACME Products" Any ideas?


	WWW IP Logged

Hammer YaBB Administrator Lanticans Offline Fire bad. Tree pretty. Posts: 3436 Location: Ohio Joined: Nov 22^nd, 2002	Re: Mass Update records from Delimited File Reply #1 - Feb 22^nd, 2012 at 4:32pm	Print Post
	Look at the documentation for FileReadLn (Programming Guide pg 236) and the Parsing a Delimited FIle sample program (pg 481).

	- Hammer The plural of anecdote is not data.
	WWW IP Logged

Steve_in_Texas Senior Member Offline No personal text Posts: 893 Location: San Antonio Joined: Feb 21^st, 2004	Re: Mass Update records from Delimited File Reply #2 - Feb 22^nd, 2012 at 5:47pm	Print Post
	Another option... I've found that it's helpful to have an empty 'generic' sesame database on hand. Import the .csv and then you can easily use the power of XLookup() and Xpost() commands to update all of your databases from the .csv data.


	WWW IP Logged

Ray the Reaper Global Moderator Members Lantica Support Offline The One & The Only Posts: 2483 Joined: Aug 20^th, 2003	Re: Mass Update records from Delimited File Reply #3 - Feb 22^nd, 2012 at 8:06pm	Print Post
	Steve_in_Texas wrote on Feb 22^nd, 2012 at 5:47pm: Another option... I've found that it's helpful to have an empty 'generic' sesame database on hand. Import the .csv and then you can easily use the power of XLookup() and Xpost() commands to update all of your databases from the .csv data. If you are going this route I would recommend XResultSetSearch() and XResultSetValue() over XPost() and XLookup(). -Ray

	Raymond Yoxall Consulting ray.yoxall@gmail.com ryoxall@lantica.com Sesame Applications, Design and Support
	WWW IP Logged

BWETTLAUFER Full Member Offline Posts: 216 Location: Cambridge, Ontario Joined: Apr 9^th, 2010	Re: Mass Update records from Delimited File Reply #4 - Mar 6^th, 2012 at 3:37am	Print Post
	Your timing on this question is impeccable! I'm looking at building an import functionality button on my database to do the following 1) Locate the import file 2) Display the top two lines of the import file 3) Ask which delimited value is the import key 4) Ask which field it matches to 5) Loop through the remaining fields and ask if they are to be updated, and which fields they match to I'll keep you posted on my progress ...


	WWW Twitter IP Logged

Pages: 1

‹ Previous Topic | Next Topic ›