Custom Objects and their fields from CSV to SF via apex

Generally customers give us a excel sheet for the custom objects and the custom fields. It take too much time to create them manually.
So I have tried a code with the help of meta data api class , which can create all the custom objects and custom fields from CSV to SF in a single click.

There are two standard objects in SF which can be accessed via apex
1. CustomObject
     

MetadataService.MetadataPort service = new MetadataService.MetadataPort();    
        service.SessionHeader = new MetadataService.SessionHeader_element();
        service.SessionHeader.sessionId = UserInfo.getSessionId(); 
        
        List<MetadataService.Metadata> fields = new List<MetadataService.Metadata>();
        
        for(String s : objSet){
            MetadataService.CustomObject customObject = new MetadataService.CustomObject();
            customObject.fullName = s+'__c';
            customObject.label = s;
            customObject.pluralLabel = s+'s';
            customObject.nameField = new MetadataService.CustomField();
            customObject.nameField.type_x = 'Text';
            customObject.nameField.label = 'Name';
            customObject.deploymentStatus = 'Deployed';
            customObject.sharingModel = 'ReadWrite';
            fields.add(customobject);
        }
        List<MetadataService.SaveResult> results = service.createMetadata(fields);

2. CustomFields
      

MetadataService.MetadataPort service = new MetadataService.MetadataPort();   
        service.SessionHeader = new MetadataService.SessionHeader_element();
        service.SessionHeader.sessionId = UserInfo.getSessionId(); 
        
        List<MetadataService.Metadata> fields1 = new List<MetadataService.Metadata>();
        
        for(String s : multField){
           MetadataService.CustomField customField = new MetadataService.CustomField(); 
           customField.fullName = s.substringBefore('-')+'__c.'+s.substringBetween('&')+'__c';
           customField.label = s.substringBetween('&');
           if(s.substringAfter('#') == 'Text'){
               customField.type_x = 'Text';
               customField.length = 42;
           }else if(s.substringAfter('#') == 'Number'){
               customField.type_x = 'Number';
               customField.precision = 18;
               customField.scale = 2;
           }else if(s.substringAfter('#') == 'Checkbox'){
               customField.type_x = 'Checkbox';
               customField.defaultvalue  = 'false';
           }else if(s.substringAfter('#') == 'Email'){
               customField.type_x = 'Email';
           }else if(s.substringAfter('#') == 'Currency'){
               customField.type_x = 'Currency';
               customField.precision = 18;
               customField.scale = 2;
           }
           fields1.add(customField);
        }  
        List<MetadataService.SaveResult> results = service.createMetadata(fields1);

So we need to do following steps.....

A. The sheet should be in a csv format because it returns a string.
   

B. Select the file which you want to create

C. Click Ok to create objects and their related fields.

So if you need the full code or demo then please let me know.


Thanks
Vikas Gaur

Analog Clock

                                                     "Time is money"

When you are working in any salesforce org then  one thing you have in your mind that is TIME. I will say that current time of the org or current time of login user or particular time zone or GMT. So we have following OOTB in salesforce to get the time

1. System.now();
2. System.today();
3. Time zone of login user based on UserInfo.getUserId()
5. Formula field
6. Workflow
7. Some other also

What if we have a analog clock for the same at home page as following

 

So I tried to build to an application which will work for this requirement. For now this working based on the GMT. It can be extended for login user or particular time zone. 

We can see working demo on following link

http://vickygaur-developer-edition.ap1.force.com/Demo/AnalogClock

So when we add this link in home page component and page layout , then it will be visible at location.

As always please let me know for suggestions and sample code. 

~Vikas Gaur