Method:Classic General Q&A

Re: Export/Import function

Method_Ashur — Fri, 09 Nov 2012 14:21:00 GMT

Hi Mario,

In order to troubleshoot this issue I would need you to enable your MethodSupport user: Go to Customize > Users > click the Active checkbox next to the MethodSupport user. Once that's done let me know via email and also include your Method Company Account name, not your username.

- Ashur

Re: Export/Import function

Mario Herbst — Tue, 06 Nov 2012 19:06:18 GMT

I'm trying to use this function to make some "global" changes to my Leads, but when I export my Customer Lead table, not all leads are exporting. I see them in the Leads and Contacts List, but they are not in the export spreadsheet. Am I missing something?

Mario

Re: Export/Import function

Method_Paul — Mon, 15 Nov 2010 20:05:47 GMT

Perfect. Thanks for letting me know. ;)

Re: Export/Import function

l.fischer — Mon, 15 Nov 2010 19:46:59 GMT

Paul,

When I was working on this on Friday, after hitting the import data button, the screen would refresh itself, and nothing more would happen. But today, on a different computer, it worked exactly as you described, I got to the validation screen, then to the import screen, and all the records were updated. Voila!

Thanks for all of your help.

Laura

Re: Export/Import function

Method_Paul — Sat, 13 Nov 2010 18:00:38 GMT

L.fisher,

"1 Choose to import or export
2. Pick a table
3 Choose File to import
4 click 'import data' "
-That's correct. Once you click Import Data, you get to the next screen "Prepare Data".

"Also, can you tell me if the RecordID is a column header in addition to the Entity?"
-If you are exporting and then importing to update, the RecordID is recommended to export and then later use for the "Update existing records by matching the key fields" in the Prepare Data screen.

Paul

Re: Export/Import function

l.fischer — Fri, 12 Nov 2010 22:29:49 GMT

When I choose the file to import and click the import data button, nothing happens.

Re: Export/Import function

l.fischer — Fri, 12 Nov 2010 22:26:55 GMT

All I'm seeing is:

1 Choose to import or export

2. Pick a table

3 Choose File to import

4 click 'import data'

Also, can you tell me if the RecordID is a column header in addition to the Entity?

Re: Export/Import function

Method_Paul — Fri, 12 Nov 2010 22:19:57 GMT

Laura,

If you pick a table first and click Import Data you'll get that option.

Paul

Re: Export/Import function

l.fischer — Fri, 12 Nov 2010 22:10:32 GMT

Paul,

I am trying to do this. But on the Import data screen, item # 2 says to "Pick a Table." I'm in Customize/Integration Tools/Import/Export Menu.

I don't see "2. Set Options". Set "Update existing records by matching the key fields" to be checked" anywhere.

Can you tell me where to find this?

Thanks,

Laura

Re: Export/Import function

Method_Paul — Wed, 03 Nov 2010 23:45:49 GMT

TogsTeam - Good news, if you do it right, you can choose (b) Append to the existing records.

When you export the records, make sure the RecordID is exported along with the fields you want to change. This will be used to identify and match records on the import.

When you import the data, play close attention to "2. Set Options". Set "Update existing records by matching the key fields" to be checked.

That way it will actually update the records based on matching the RecordID. Pretty cool, huh? So.....it should really be called "Import / Export / Update" instead of "Import / Export"!

Paul

Export/Import function

TogsTeam — Wed, 03 Nov 2010 22:34:06 GMT

If I exported my Customer records, did some data cleanup in Excel, and then imported them back into the Customer table, would the revised records:

a) Update (or overwrite) the existing records

b) Append to the existing records

c) Crash, because the unique Customer record ID would be duplicated

I know this seems like a simple question, but I've been away from Method for awhile, and I didn't find an answer when I queried the forum...

Thanks!