Deleting existing dataset?

Nov 26, 2010 at 2:53 PM

How can I completly remove a dataset? Can this be done with the DataLoader Utility?

Since I'm having problems with the metadata of a dataset (no entry for the entity meta data in the table storage), I want to completly rebuild it.

Kind regards

Juergen

Coordinator
Nov 26, 2010 at 5:32 PM

If you reload the dataset under the same name using the same .cfg file data loader will delete existing data and metadata for the dataset before loading it again. Data loader doesn't have delete option. Since OGDI uses Windows Azure storage for its data any of the free or commercial tools can be used to edit it (e.g. http://code.msdn.microsoft.com/windowsazuremmc or http://myazurestorage.com). To delete a data set you need to delete the corresponding table and entities from EntityMetadata and TableMetadata tables (one per).

HTH,

-Vlad

Nov 26, 2010 at 7:39 PM

I had problems loading the dataset the first time, because one of my column names had diacritical characters (german: ß) in its name. Therefore I've got a valid entry in the TableMetaData table but no entry in the EntityMetadata. Reloading the dataset didn't solve the problem and quering for the metadata didn't return the entity meta data. I'll try to completly remove the dataset with a tool and reload the dataset again.

Kind regards

Juergen

Nov 26, 2010 at 7:55 PM

Next try, after removing the diacritical character ß from the column and deleting all table entries for the dataset, didn't work, too. I always end up with a table for the dataset, filled with the data loaded from the csv file, and one entry in the TableMetaData table. Unfortunately there's never a corresponding entry in the EntityMetadata table for my dataset.

Please help, because without metadata access we won't able to show the integration.

Kind regards

Juergen

Nov 26, 2010 at 8:19 PM

And finally solved: Source of the problem was a column with the name 'e-mail' in my dataset. After changing it to 'email' everything worked perfectly.

Final question: Which characters can be used for column names?

Kind regards

Juergen

Coordinator
Nov 29, 2010 at 1:26 PM

Glad to hear!

It's best to stick with column names that are valid Windows Azure tables property names - see http://msdn.microsoft.com/en-us/library/dd179338.aspx. Data loader performs some column name transformations but doesn't catch all the issues.

-Vlad