| Author | 
		  Message
		 | 
		
		  | rinky_chand | 
		  
		    
			  
				 Posted: Mon Apr 16, 2012 7:58 pm    Post subject: XBRL connection with MB | 
				     | 
			   
			 
		   | 
		
		
		   Newbie
 
 Joined: 16 Apr 2012 Posts: 5
  
  | 
		  
		    
			  
				Hello All,
 
 
As per the requirement, I have to convert excel file into XBRL(extensible business reporting language) in Message broker, for which I have to create a schema file for conversion of excel to XBRl.
 
 
I am confused as how I will declare the taxonomy elements in Message Broker. Anyone who  has worked in this scenario, please provide some suggestions | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | Vitor | 
		  
		    
			  
				 Posted: Tue Apr 17, 2012 4:51 am    Post subject: Re: XBRL connection with MB | 
				     | 
			   
			 
		   | 
		
		
		    Grand High Poobah
 
 Joined: 11 Nov 2005 Posts: 26093 Location: Texas, USA 
  | 
		  
		    
			  
				
   
	| rinky_chand wrote: | 
   
  
	| I am confused as how I will declare the taxonomy elements in Message Broker.  | 
   
 
 
 
I'm equally confused by your question.
 
 
What do you mean by "create a schema file"? An XSLT? Message sets for use in code? 
 
 
On the face of it, declaring the elements in either is straightforward (though I don't envy you the complexity of the Excel format) so what exactly are you asking? _________________ Honesty is the best policy.
 
Insanity is the best defence. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | rinky_chand | 
		  
		    
			  
				 Posted: Wed Apr 18, 2012 12:21 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Newbie
 
 Joined: 16 Apr 2012 Posts: 5
  
  | 
		  
		    
			  
				| I have an excel file and an xsd file , Now i have to do mapping of fields in excel file into XBRl format | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | mqjeff | 
		  
		    
			  
				 Posted: Wed Apr 18, 2012 4:48 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Grand Master
 
 Joined: 25 Jun 2008 Posts: 17447
  
  | 
		  
		    
			  
				| Step 1: confirm you can use Message Broker to read the excel file and parse the contents. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | Vitor | 
		  
		    
			  
				 Posted: Wed Apr 18, 2012 4:50 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Grand High Poobah
 
 Joined: 11 Nov 2005 Posts: 26093 Location: Texas, USA 
  | 
		  
		    
			  
				
   
	| rinky_chand wrote: | 
   
  
	| I have an excel file and an xsd file , Now i have to do mapping of fields in excel file into XBRl format | 
   
 
 
 
So your question is "how do I use WMB to convert an Excel file into a different format?".
 
 
That's a lot more than just declaring taxonomy elements in a schema file, and more than can be answered in a single thread here. 
 
 
My advice - use the search button top right of this page. I know reading Excel files with WMB has been discussed (IIRC it ended up with using a JCN and a open source class but don't tak emy word for it) and I think we've discussed XBRL as well. There could be something in either of those you can use. _________________ Honesty is the best policy.
 
Insanity is the best defence. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | rinky_chand | 
		  
		    
			  
				 Posted: Fri Apr 27, 2012 3:52 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Newbie
 
 Joined: 16 Apr 2012 Posts: 5
  
  | 
		  
		    
			  
				Thank you for your reply...
 
 
Actually, I have to create an XBRL file in Message Broker. As input Iwas getting an excel file and xsd file.
 
 
can anyone provide me a link for XBRL in message broker. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | fjb_saper | 
		  
		    
			  
				 Posted: Fri Apr 27, 2012 9:49 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Grand High Poobah
 
 Joined: 18 Nov 2003 Posts: 20768 Location: LI,NY 
  | 
		  
		    
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | rinky_chand | 
		  
		    
			  
				 Posted: Tue May 01, 2012 9:38 pm    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Newbie
 
 Joined: 16 Apr 2012 Posts: 5
  
  | 
		  
		    
			  
				| Thank you for the link ..... | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | 
		    
		   |