w3hello.com logo
Home PHP C# C++ Android Java Javascript Python IOS SQL HTML Categories
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).

Categories : Xcode

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.

Categories : Mysql

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"));

Categories : C#

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.

Categories : Asp Net

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.

Categories : Haskell

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'];

Categories : PHP

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

Categories : Mysql

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.

Categories : Hadoop

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.

Categories : Iis

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.

Categories : Csv

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,

Categories : Javascript

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?

Categories : 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

Categories : Mysql

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

Categories : Asp Net

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

Categories : C#

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"}

Categories : Ruby On Rails

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

Categories : Mysql

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.

Categories : Mongodb

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.

Categories : Mysql

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 ) . " "; }

Categories : PHP

Highcharts and the export of table data
Please refer this article: High Charts Link Also refer Fiddle for code

Categories : Jquery

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

Categories : Csv

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

Categories : Java

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\

Categories : Emacs

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

Categories : R

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.

Categories : Mysql

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.

Categories : Vba

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.

Categories : HTML

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

Categories : SQL

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".

Categories : Vba

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.

Categories : C++

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 ' ';

Categories : Mysql

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

Categories : PHP

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.

Categories : C

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!)

Categories : SQL

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.

Categories : Jsp

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.

Categories : Jquery

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");

Categories : Javascript

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

Categories : Javascript

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

Categories : Java



© Copyright 2017 w3hello.com Publishing Limited. All rights reserved.