I had gone through the API provided by Apache metamodel to connect Salesforce.com, most of API are there which can help perform CURD operation. But, i am unable to find the features which are not supported by Apache metamodel API's. Is there any document reference for complete API guide and feature document for Apache metamodel Salesforce.com connector ?
I have several excel files that are automatically generated by a system I don't have control over.
These excel files have a slightly unfortunate format, in that the first column is blank, the first row is blank, and there is a blank row between the headers and the data. An example format for these excel files would look like:
I want to use
Apache MetaModel to query and manipulate this data, but due to the poor format of these files, I can't open them with the usual
DataContextFactory.createExcelDataContext() as the
Default Schema doesn't select the
Headers to be the names of my columns.
One solution I thought of would be to include
Apache POI, and use that to delete the empty rows / columns before continuing to operate on them in
MetaModel, but I'd hate to add such a large dependency for such a small part of the program.
I was wondering if
MetaModel had any way for me to delete the blank data, before I have a good Schema? I'd like to be able to use
Header Two ect as the names of my columns in
Thank you for your time!
I have created a sample program using the
DataContext class to get records from an
oracle11g table, and write its data to CSV file.
Here is my code for getting table and write into a CSV.
UpdateableDataContext dataContext = DataContextFactory.createCsvDataContext(tmpCSV); TableCreationBuilder table = callback.createTable(getDataContext().getDefaultSchema(),"Table1").execute(); RowInsertionBuilder insert = callback.insertInto(table); //we are getting each column from each record and than run insert.value("columnName","value") //After inserting all records we are execute below command to insert data into csv insert.execute();
I want to do the same thing with creating a view, and putting its data into a CSV file.
How can I use
DataContext in java for creating views, and then writing the view's data into a CSV file?