XCode export archive is missing "export as application" |
I just checked my version of Xcode to make sure and with Version 4.6.3
(4H1503) of Xcode I see the same screen as in the video with or without
code signing turned on. I would make sure you have the most current version
of Xcode, clean your build folder and try to Archive again. If that doesn't
work I would delete Xcode and reinstall it from the App Store. The other
option is to create another user account on your machine and try archiving
and distributing from there to see if it is any different (I actually had a
problem related to provisioning a few years ago that only showed up on my
main user account).
|
MySQL export - import of a log table / partial synchronization (full export, import in an existing table) |
This use case is one of the reasons people consider using the Cassandra
product. I am dumping all my logs into a cassandra cluster for processing.
It allows you to do a lot more than you can do with MySQL.
http://cassandra.apache.org
In my experience, using Cassandra to hold the log data has made so many
things much more productive.
|
Why are my Orchard CMS widgets not populating the Id property when I export them through with Import/Export module? |
Turns out that I needed to add the IdentityPart to be attached to my
widgets. You can do this in your migrations file by using
ContentDefinitionManager.AlterTypeDefinition("MyWidget",
cfg => cfg
.WithPart("IdentityPart"));
|
my excel2003 toolbar is missing after export |
That’s not necessarily a problem of your code. Try to reset the Excel
toolbar by opening the registry, navigating to HKEY_CURRENT_USER Software
Microsoft Office <Version> Common Toolbars Settings and delete
the Microsoft Excel entry (after making a backup, of course). Then run your
code again and see if the toolbar is disappearing again.
But I suspect it is a coincidence.
|
Haskell records setter export |
One fairly easy option is to define a synonym and export that:
module M1(customCtor, getField1) where
data DType = DCtor { field1 :: Int }
customCtor = DCtor { field1 = 1 }
getField1 = field1
Here, getField1 is a "getter" function (type: DType -> Int) that gets
field1 but doesn't have the additional status of being a record field for
updates.
|
SQL export to XML. usting php script. (customer export) |
You are using the concatenate operator, so it's making a long string of all
your query results:
$customers_id.=$row['customers_id'];
You might want to put that data into an array instead:
$customer['id'][$key] = $customers_id.=$row['customers_id'];
|
Foreign Key constraints missing after phpmyadmin export |
So the question are: where is my foreign key constraints?
They are defined in the database. The output from SHOW CREATE TABLE
users_x_activities will include the foreign key constraint definitions.
The definitions of the foreign key constraints likely appear in separate
ALTER TABLE statements at the end of the generated script.
does KEY refer to FK?
No. KEY id_user (id_user) here refers to an index.
Seems that the two tables utente and attivita are no longer referenced in
the new generated script.
Yes, you are correct. The foreign key constraints are not included in the
CREATE TABLE statement.
where am I doing wrong?
A MySQL SHOW CREATE TABLE users_x_activities will include the foreign key
constraints.
The foreign key constraints are likely included in the script generated by
phpM
|
Handling bad records during sqoop import or export |
Sqoop currently expects that the data to export is clean and do not provide
facilities to handle corrupted data. You can use MR/Pig/Hive job to clean
your data up, prior using Sqoop to export them.
|
IIS Web Deploy's "Import/Export Application" Action Missing? |
Go to http://www.iis.net/downloads/microsoft/web-deploy
Scroll to the bottom of the page to the "Download Web Deploy" header
Click the x86 or x64 link next to your language of choice. Do not click the
WebPI link.
Once downloaded, click on the installer to open it.
Click Next
Click the Remove button
Now you can reinstall it using the Web Platform Installer, or just use the
standalone.
On a side note...
If you don't see the Deploy options in IIS once you've reinstalled Web
Deploy, try running IIS as Administrator. Hope this helps.
|
Need to Change ids of records from SugarCRM Export for Accounts and Contacts |
Are you planning on keeping the data in sync? I'd suggest adding a
"sugar_id" column in your app and a "your_app_id" column in SugarCRM. This
way the native id column remains the same and that it will maintain a
reference to the record in the other system.
|
Export Angular JQLite as $/jQuery |
Actually, you can, but it almost certainly won't help.
If you wanted to "export" it, you'd simply need to add this after the
Angular JavaScript is loaded:
window.jQuery = window.$ = angular.element;
Now calling $() or jQuery() will run jqLite. Here's why it most likely
won't work: jqLite doesn't support selectors, meaning you can't do
angular.element('.foo').html();
You'll just get an error stating that Selectors not implemented.
Here's a jsFiddle showing it working when used on elements directly, but
failing with the selector.
Edit
Based on Yashua's suggestion below, here's an update using his trick to
enable selectors. It's a nice trick/hack if jqLite is good enough.
Personally, I don't agree that you should just include jQuery. It's
another large library to depend on,
|
How to export postgres data containing newlines to CSV without breaking records on several lines |
You can try replace() or regexp_replace() function.
The answer to the followinig SO question should give you an idea: How to
remove carriage returns and new lines in Postgresql?
|
ERROR org.apache.sqoop.tool.ExportTool - Error during export: Export job failed |
You seem to be having a string where a number expected like " it was not
able to authenticate." (as I can see from the trace that you shared).
Please check the source data that is being pushed to the database.
Edit
Use some other character as the delimiter. When the data is being written
(I assume that a MR program is generating this data.) to HDFS, use a rare
character (like ^A, #, @) as a delimiter.
There are various options in the 'export' command such as '--enclosed-by',
' --escaped-by'. But your data should be prepared accordingly. The simplest
option looks to be to select a delimiter character that is highly
improbable to occur inside your data.
Edit-2
In that case, there's nothing much any tool can do as the delimiter
character is coming in between the data field without any es
|
Is it possible to export a sql table to excel using asp.net |
Here is a utility function you can use:
Public Shared Sub ExportToSpreadsheet(table As DataTable, filename As
String)
' Get a hold of the HTTP context and clear it, because we are going to
push the CSV data through the context
Dim context = HttpContext.Current
context.Response.Clear()
' Loop through each column in your data table
For Each column As DataColumn In table.Columns
' Write column names
context.Response.Write(column.ColumnName + ";")
Next
context.Response.Write(Environment.NewLine)
' Loop through each row in the data table
For Each row As DataRow In table.Rows
' Loop through each column in row
For i As Integer = 0 To table.Columns.Count - 1
' Write each column value
context.Response.Wr
|
Export a Object in a CSV Table |
Have you not tried using Filehelpers to accomplish CSV manipulation?
Try doing it with Filehelpers they do all the hard work for you. Create a
class as below:-
[DelimitedRecord(",")]
public class Customer
{
public int CustId;
public string Name;
public decimal Balance;
[FieldConverter(ConverterKind.Date, "dd-MM-yyyy")]
public DateTime AddedDate;
}
...and then just read and write as below::-
FileHelperEngine engine = new FileHelperEngine(typeof(Customer));
// To Read Use:
Customer[] res = engine.ReadFile("FileIn.txt") as Customer[];
// To Write Use:
engine.WriteFile("FileOut.txt", res);
They have some really good examples
|
Export a key value table to JSON |
You're looking for a :reduce via :merge.
> rows = [{ navigationBarColor: "#E31937" }, { navigationBarImage:
"Background-NavBar" }]
=> [{:navigationBarColor=>"#E31937"},
{:navigationBarImage=>"Background-NavBar"}]
> rows.reduce(&:merge!)
=> {:navigationBarColor=>"#E31937",
:navigationBarImage=>"Background-NavBar"}
> puts rows.reduce(&:merge!).to_json
{"navigationBarColor":"#E31937","navigationBarImage":"Background-NavBar"}
|
Export Data to a hive table on querying another table |
ALTER IGNORE TABLE yourTable ADD UNIQUE INDEX idx_name
(columnwithduplicates)
EDIT
ALTER TABLE yourTable ADD CONSTRAINT idx_name UNIQUE (columnwithduplicates)
this removes duplicate rows
INSERT INTO table2
SELECT column1,column2,etc
FROM table1
provided the structure is the same
|
how to export last 15 mins data from mongo collection using mongo export |
You can check out this question: mongoDb return results based on time
interval
You have to escape the spec chars. I could not make it run with the ISODate
helper but like this
"{date:{$gt:{ "$date" : 1370935140000 }}}"
given as a -q parameter to the mongoexport works fine. This case
1370935140000 is the unix timestamp in mili secs. So you have to calculate
the unixtimestamp 15 mins before than add 000 at the and and go on with
this. I will try to resolve also with the ISODate.
|
Export database table with data |
The export should be default include the table data. Make sure that Skip
table data (no-data) in the options sub-panel is unchecked before you start
the export.
If that doesn't work, try reverse engineering your database by going to the
menu option Database > Reverse Engineer and complete the steps.
After you've reverse engineered your database, go to File > Export >
Forward Engineer SQL CREATE Script.
Under SQL Options, check the box Generate INSERT statements for Tables and
then continue the export process.
|
Export a mysql table into CSV using PHP code |
Before for loop initialize $header to empty string.
$header = '';//initialize header
for ( $i = 0; $i < $fields; $i++ )
{
$header .= mysql_field_name( $export , $i ) . " ";
echo $header;//remove this line
}
EDIT
Also initialize $data outside while loop.
$data = '';
while( $row = mysql_fetch_row( $export ) )
{
$line = '';
foreach( $row as $value )
{
if ( ( !isset( $value ) ) || ( $value == "" ) )
{
$value = " ";
}
else
{
$value = str_replace( '"' , '""' , $value );
$value = '"' . $value . '"' . " ";
}
$line .= $value;
}
$data .= trim( $line ) . "
";
}
|
Highcharts and the export of table data |
Please refer this article: High Charts Link
Also refer Fiddle for code
|
How to export a Hive table into a CSV file? |
You can not have a delimiter for query output,after generating the report
(as you did).
you can change the delimiter to comma.
It comes with default delimiter 01 (inivisible character).
hadoop fs -cat /user/data/output/test/* |tr "1" ","
>>outputwithcomma.csv
check this also
|
Export Eclipse NAT Table to CSV/Excel |
for reading / writing to excel you can use Apache POI
http://poi.apache.org/
for how to get started with Apache POI look at
http://viralpatel.net/blogs/java-read-write-excel-file-apache-poi/ might
help
|
Export a table to LaTeX and respect ^:nil |
I get it to export successfully under Org 8.0.3.
Export
section*{tRemovalEpisodes}
label{sec-1}
A "removal" is a discrete event blah blah blah. This is all fine.
underline{Columns}
egin{itemize}
item removal\_id (int) is a Primary Key
item child\_id (int) is a Foreign Key
item removal\_date (date)
item exit\_date (date)
item primary\_removal\_reason (int)
end{itemize}
egin{center}
egin{tabular}{r|r|r|r|r|}
removal\_id & child\_id & removal\_date & exit\_date &
primary\_removal\_reason\
hline
1 & 12345 & 2012-01-01 & 2012-04-13 & 13\
2 & 12346 & 2012-01-03 & 2013-02-14 & 22\
3 & 12347 & 2012-04-02 & & 12\
4 & 12348 & 2012-09-05 & 2013-02-28 & 13\
5 & 12349 & 2013-01-02 & 2013-04-12 & 56\
|
Export R object table to excel |
It's not a dataframe, but it was pretty easy to turn it into one.
dat <- as.data.frame(structure(list(depth = c(10, 20, 30, 40, 50, 60,
70, 80,
90, 100), obs = c(146L, 147L, 147L, 147L, 147L, 146L, 147L, 147L,
147L, 147L), cume.obs = c(146L, 293L, 440L, 587L, 734L, 880L,
1027L, 1174L, 1321L, 1468L), mean.resp = c(0.0116469582940705,
0.0125322442801302, 0.0142252481339337, 0.0106531565074638,
0.0130847548479835,
0.0106034244135535, 0.00455378455081303, 0.0061834241946857,
0.00989105136990672, 0.00841145735618072), cume.mean.resp =
c(0.0116469582940705,
0.012091112014039, 0.0128041074904584, 0.0122654536667783,
0.012429537145848,
0.0121265684425355, 0.0110426354025324, 0.0104341992461836,
0.010373758112336,
0.0101772606932932), cume.pct.of.total = c(0.113817337305101,
0.2371247
|
How to export sql a table structure and data in mysql? |
AFAIK, ther is no SQL statement that will allow you to generate INSERTS
like that.
Though, if you are looking for a lazy automated processing, I guess you
could dump your data with SELECT INTO OUTFILE, then reload it later with
LOAD DATA INFILE.
|
VBA (Access) - How to scan through A table and export images as a pdf |
You might try to start with a report if what you want is the information in
the table in a PDF form. You can create a report under the "create" tab
and use the Reports Wizard to input the fields that you want. You can then
easily export the report to a PDF, either by opening the report and
manually clicking "PDF or XPS" under "Data" on the Print Preview tab of the
ribbon or via VBA. As PowerUser said, if you can give more detail about
the table and field as well as how the images are stored that will also
help answer this question more thoroughly.
|
Export HTML table to Excel - options? |
You could try using SQL Reporting Services. It's a bit heavy, but you
could create the HTML tables as a report. Using Reporting Services you
could then render out the report as an Excel document (or PDF, or an image,
etc.).
I've found it to be the easiest way to get a consistent output into
documents like that.
I've not tried calling Reporting Services from PHP, but I'm sure it can be
done.
There's a blog article by Brian Swan of MS that explains it -
http://blogs.msdn.com/b/brian_swan/archive/2010/09/23/rendering-sql-server-reports-as-excel-documents-with-php.aspx
I've not tried it myself though, so I can't vouch for it, but may be
helpful for a starting point.
|
Oracle sql developer - export DDL - only create table sql |
It's some work, but you can implement your own tool to create the DDL.
All you need is stored in the Oracle database catalogue.
To create just tables (without index and constraints) you need these 2
tables:
USER_TAB_COLUMNS
USER_TABLES
You will find a detailed documentation of these tablese here:
Oracle Database Reference
Other usefull Oracle tables are
USER_CONSTRAINTS
USER_INDEXES
|
Trying to save a table export with file dialog box |
You can receive that error if:
you don't have Option Explicit at the top of your module,
your VBA project does not have the reference to the Office Object Library,
and
you try to use the msoFileDialogSaveAs constant name.
To fix this, either...
(a) verify that your VBA project has a valid reference for...
Microsoft Office nn.n Object Library
...where nn.n corresponds to the version of Office you have installed
(e.g., it is 14.0 for Office 2010).
(b) Failing that, you can use
Dim f As Object
Const msoFileDialogSaveAs = 2
Set f = Application.FileDialog(msoFileDialogSaveAs)
TIP: Always use Option Explicit for every module you create. It will save
you many a headache. To make it the default, choose Tools > Options in
the VBA editor and select "Require Variable Declaration".
|
Viewing DLL function names which have no export table |
Try Dependency Walker(http://www.dependencywalker.com) or application
verifier(http://msdn.microsoft.com/en-us/library/ms220948%28v=vs.90%29.aspx),
these are utilities for Windows that allow you to do what you stated.
|
How to export table data to csv where date 'today' |
SELECT 'Title', 'Date', 'Count'
UNION ALL
SELECT Title,Date,Count
FROM sales_com
WHERE Date >= to_date('2004/01/01', 'yyyy/mm/dd')
AND Date <= to_date('2004/12/31','yyyy/mm/dd');
INTO OUTFILE 'U:/CSV-LiveDB-Upload/sales_com/Data.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '
';
|
Daily export mySql table to folder/url |
You should be able to export a table like so
SELECT * INTO OUTFILE "data/mostRecent.csv"
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY "
"
FROM surveyTable;
Referenced from http://dev.mysql.com/doc/refman/5.0/en/select.html
You can then simple point to the exported file with a link(assuming you
have it within your webroot). Alternatively, you could set headers, and
then fpassthru it
|
How to export constant based on size of table |
You have a third option:
Move MIN_LEVEL and MAX_LEVEL to library.c and create new functions
get_min_level() and get_max_level() declared in library.h and implemented
in library.c that simply return MIN_LEVEL and MAX_LEVEL respectively. These
functions will be visible from consumer.c without revealing the library's
internal data structures.
|
Need to export SQL for creating table(s) from Enterprise Architect |
In the diagram where your tables are designed, select all of them and right
click in one of the tables. Look for SQL Code Generation and choose one of
the options: single DDL script or not.
The difference is that in the single script all create table statements
will be generated in only one file (which is usually better!)
|
Struts 2 distplay:table tag export links appear on top |
The div has the class exportlinks that you should override via CSS
technique. In this case you could customize the appearance of the bar.
To change pagesize dynamically you need to customize the banner and place
select there, then onchange event should handle the change
pagesize="<s:property value="pagesize"/>" by submitting the value
from the select or sending it in GET request. After the value is changed by
the action just keep return or refresh the page to take changes effect.
|
Can not export html table to excel using jQuery |
window.open() has its scope and limitations that has been well explained in
this post: Export to CSV using jQuery and html
For your concern, I tested with 2500 rows and it works fine. (I can't
upload so much data on jsfiddler but I am sure it will work for 5000 rows
also.)
Also, I suspect if you are wrapping your html table into a container DIV.
Just put your html table into a DIV and use like this -
$("[id$=myButtonControlID]").click(function(e) {
window.open('data:application/vnd.ms-excel,' + encodeURIComponent(
$('div[id$=divTableDataHolder]').html()));
e.preventDefault(); });
http://jsfiddle.net/AnilAwadh/wJyWm/
encodeURIComponent() is a Javascript function that is used to encode
special characters if you data has any and its use is optional.
|
How to export html value(not table) to a csv file with jquery? |
if you don't have comma-containing strings:
var csv = jQuery(".list").map(function(a,i){
return $.trim($(this).text()).split(/s*
s*/).join(",");
}).toArray().join("
");
alert(csv);
you can use my downloader at http://danml.com/js/download.js to download
the csv variable like:
download(csv, "tabledata.csv", "text/csv");
|
Javascript to export html table to Excel |
If you add:
<meta http-equiv="content-type" content="text/plain; charset=UTF-8"/>
in the head of the document it will start working as expected:
<script type="text/javascript">
var tableToExcel = (function() {
var uri = 'data:application/vnd.ms-excel;base64,'
, template = '<html
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40"><head><!--[if gte mso
9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>{worksheet}</x:Name><x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--><meta
|
How can I export a table and import the data to other table? |
Try:
insert into tableB
select * from tableA
This is possible also if the tables are in different databases, creating a
DB-link between the databases (granted you have the permissions to do so).
You can otherwise copy a max number of columns from TableA in memory and
than insert them into the TableB, but I strongly discourage this.
Unfortunately in java there is nothing similar to the .NET BulkCopy
|