63 questions
0
votes
0
answers
46
views
Excel: XML Export table how to grow dynamically from input table
In excel, I'm taking user input in one table INPUT, copying it to a structured table OUTPUT with some additional data and exporting that into XML.
Input Table
Category
Code
Foocat
Zulucode
Barcat
...
0
votes
1
answer
49
views
python to_xml to display xsi:nil="" instead of nothing
I have this export script of a dataframe in xml format:
df.to_xml('df.xml',root_name='dataroot',row_name='Anexa_1I',
namespaces={"xsd": "http://www.w3.org/2001/XMLSchema",...
0
votes
0
answers
67
views
What’s Wrong with my Code? "PHP ERROR: Uncaught ArgumentCountError"
I have seen that there are already some articles on this topic, but unfortunately I have not found a solution for my code.
I’m exporting orders from Woocommerce with custom codes (plugin WP ALL IMPORT)...
- 55
0
votes
1
answer
109
views
How to modify an xml string with python in synapse notebook
I have a pandas dataframe with a single row. Now I need to
Convert this dataframe into an xml string and store it to a variable
Modify the xml string variable to add header tags.
Load the modified ...
- 25
1
vote
1
answer
135
views
How to remove prefix from every attribute in xml using python
I am trying to generate xml file from pandas dataframe using pd.to_xml() method.
I have data in SQL-Server and trying to read from it.
id
first_name
last_name
email
gender
ip_address
1
Erika
Pickless
...
- 109
0
votes
1
answer
52
views
Serialization Class to XML Problem List<>
I have trouble exporting my xml from class object, when I generate my XML a node nests inside one with the same name the problem will be serialized a list.
I have an object like this:
Currently my ...
0
votes
1
answer
1k
views
How to export/generate XML file with METADATA in ASP.NET Core using C#?
I need to get data from database, massage it into list of objects, then finally generate an XML file with a METADATA tag (expected result), I think those DATA PACKET, METADATA, etc.. tag is not ...
- 15
0
votes
0
answers
2k
views
How to insert XML tags into a microsoft word 2022 document, export this document as xml, and get only the tags+infos in between in a new xml file
I'd like to insert XML tags into a word document to grab some information, same as this guy.
https://www.youtube.com/watch?v=v0DoQkecvnI
My mindset is to keep something simple when i take notes from ...
0
votes
0
answers
326
views
How can I generate an XML or text file from certain text in a Word doc
So my issue is, as part of my job I have to complete in regular reports on word which are formatted in tables. I then have to go online and fill in an online form with all the information from the ...
- 1
0
votes
1
answer
1k
views
How can I save an XML file from a SQL query?
I'm using SQL Server 2019 - v15.0.4123.1.
This is the sample query (from this question):
DECLARE @tbl TABLE (ID INT IDENTITY PRIMARY KEY, city VARCHAR(30))
INSERT INTO @tbl (city)
VALUES ('Miami'), (...
- 113
0
votes
1
answer
260
views
Sql Server FOR XML Fields and Attributes
I need to get an XML from a query:
SELECT
... join ...
FOR XML PATH ('parent-lines'), ROOT('main-tag'), ELEMENTS XSINIL;
I have been able to get this structure:
<main-tag>
<parent-lines>...
- 11
0
votes
1
answer
521
views
SQL query to XML output goes something wrong. the format is like text file
I have a very interesting problem with XML output from SQL query.
DECLARE @DateStr VARCHAR(30), @sql nvarchar (4000)
SET @DateStr = REPLACE(REPLACE(REPLACE(CONVERT(VARCHAR(30), dateadd(HH,+2,getdate(...
- 1
0
votes
0
answers
147
views
Methods to persist CSV data using PowerShell on Linux?
From Linux, might there be a "native" or built-in convenient "database" facility from withing Powershell itself?
While this works fine for importing data:
nicholas@mordor:~/csv$
...
0
votes
1
answer
414
views
how to export raw XML returned from Invoke-RestRequest with Export-CliXml?
How can I get the curl result of just <notes/>, from eXist, with PowerShell?
PS /home/nicholas>
PS /home/nicholas> $url='http://localhost:8080/exist/rest/db/scripts/notes.xq'
PS /home/...
0
votes
0
answers
205
views
Excel export multiple different tables to XML
I have an excel (2016) document. On one sheet I have a table that I want to export to XML, no probleem. Now I ad an new sheet with a new and different table, that I also want to export to XML, this ...
- 1
1
vote
1
answer
2k
views
Ag grid exportDataAsExcel run export to xml instead xlsx
I add context menu and reassign export to csv and Excel - I need export use valueFormatter for some column.
Export working fine, but after I run export to xml, and then run export to Excel - I get xml ...
- 71
0
votes
0
answers
560
views
SQL Server BCP XML export with <?xml version ='1.0' encoding='UTF-8'?>
I have to export data from SQL Server 2014 SP3 CU3 to an XML file, for a vendor to test something, which I've done successfully.
However, I don't know how their application/system works, as they ...
0
votes
1
answer
319
views
CSV to Custom XML with Java/Javascript
i would like to convert from CSV to XML with Java/Javascript.
For example my CSV file is like this table:
| ID | OLO |
| 12345 | TLC |
| 12345 | VPN |
| 67890 | TLC |
I would like to have an XML ...
- 3
0
votes
1
answer
2k
views
Convert .mat annotation file into XML file
I have some images, which I annotated using MATLAB's imageLabler tool. As a result I got gtruth.mat file (which contains annotations of all of the images).
Now I would like to train a simple object ...
- 79
1
vote
2
answers
618
views
Handling repeating rows when exporting spreadsheet to XML using XSLT
I have a very large spreadsheet that I'm trying to export to XML. Any row with repeating cells are skipped over during the transformation. So if a row has
1 2 2 2 3 4 5
only the first 2 will be ...
- 68
1
vote
1
answer
2k
views
Writing contents of XML Variable to File
The code below creates me an XML file that shows up as a link as shown in image1
DECLARE @xmlentire AS XML = (
select (select @xmlheader as returnXml),
(select @xmlbody as returnXml)
for xml path ('...
- 71
0
votes
1
answer
264
views
NSXMLElements breaking line before close TAG - Cocoascript
I'm creating an XML file. What I need is to have a line-break before close the TAG
My expected printout is
<View
x=“0” y=“0"
width=“464” height=“287">
</View>
instead, the ...
- 1
0
votes
0
answers
87
views
Export Excel to XML with added string
I have an Excel file that contains the column persons. In order to export this Excel sheet to XML I provided an XML schema that looks like this:
<members>
<person></person>
</...
- 2,700
2
votes
0
answers
634
views
How to export XML from MySQL using PHP?
I'm trying to export products from WooCommerce in XML using MySQL and PHP (v7.*). I've created custom table and added products there, using codes:
INSERT INTO `xml_export`(`id`, `product_name`, `...
- 349
1
vote
3
answers
1k
views
Export-Clixml Escape All Special Characters in Variable
I have a DataGrid ($myWindow.myDataGrid.Items) that I am trying to Export-Clixml. The $myWindow.myDataGrid.Items is an ItemCollection that contains String properties that are words with certain ...
- 636
1
vote
2
answers
2k
views
Can you export SQL Server 2012 data into an XML file
Below is a very small example of the SQL and XML but no idea how to export this into say C:\Users\Simon.Evans\Documents\Test.xml. To be fair I have very little to zero knowledge of XML so walking in ...
- 401
0
votes
2
answers
3k
views
How to export Lotus Notes documents (both parent and response forms) to XML
Anybody here knows how to export the parent and response forms to xml file? I got this code wherein it gets all the objects in the parent form and exports it to xml but it doesn't access the response ...
- 75
2
votes
3
answers
9k
views
Exporting to XML with PHP
Trying the following PHP export to XML in order to create a remote phonebook for a Yealink SIP-T46G. Managed to get so far but currently exporting a an XML format that isn't valid to use on the phones....
user7680251
0
votes
1
answer
1k
views
XML Save/Export - SQL Server - Copy direction must be either 'in', 'out' or 'format'
I am trying to export the xml generated from sql query. I am trying like this
EXEC master.dbo.sp_configure 'show advanced options', 1
RECONFIGURE
EXEC master.dbo.sp_configure 'xp_cmdshell', 1
...
- 2,341
0
votes
1
answer
366
views
Beautifulsoup xml no data when write()
I'm connecting to an API to download some websites in xml format. I utilizing BeautifulSoup in the Jupyter environment. I'm utilizing this code to access the data...
my_params = {some parameters}
...
- 4,895
0
votes
0
answers
384
views
Export xls file to xml with existing xml schema
I am having a xlsm file and I need to export one sheet from that file to an xml file. I am having a predefined xml schema and i have to do it from the command line.
Can anyone help with this problem?
- 333
0
votes
1
answer
69
views
how to customize xml headers
I have a resultSet formed by:
LazyList<DeliveryLabel> deliveryLabels = DeliveryLabel.findBySQL(sql);
String wxml = deliveryLabels.toXml(true, true);
The xml generated start with:
<...
0
votes
1
answer
1k
views
How to set Umbraco Child Node to List<T>
I have a blog export package which exports blog content in Umbraco to XML.
Now I want to export comment data, the comments section is set as a childNode on the NewsItem node, how can I use this ...
0
votes
1
answer
559
views
How do I export data from a table to a xml file?
I want to export data to a xml file from oracle. I'm not sure how to go about it. This is the code for what I have tried so far but I am getting a error saying table doesnt exist. The schema has ...
- 131
2
votes
1
answer
4k
views
How to generate an XML report?
I have a requirement where I need to generate the XML reports and I need to populate the the XML with the values from Database.
I starting using Jasper Reports where I can generate the reports of ...
- 21
0
votes
1
answer
495
views
1B6 error while trying to create an XML map in Excel
When trying to create a XML map in excel I get the error 1B6:
(Add-Ins Tab -> XML Tools -> Select Convert range to XML -> click OK button)
fnMapRangeWithXml window which states
ERROR 1B6: Object ...
- 4,281
0
votes
1
answer
318
views
XSL transform MS Access 2007 output
I am exporting data from Access on regular basis. So far I used to export it and manually edit some tags to adjust it to Clients needs. Lately I found that that there is posibility to use XSL as a ...
- 1,294
2
votes
1
answer
2k
views
Can header labels be translated in sonata admin bundle export feature?
SonataAdminBundle can export list data into several formats (CSV, Excel, JSON and XML), but the resulting file label headers exactly as the column names.
How can I replace those names for more ...
- 714
0
votes
1
answer
70
views
Access table, cannot export hidden query
I use MS Access 2007. I have created simple select query and later I used hidden attribute.
My question is why I cannot export data to XML while having hidden attribute?
- 1,294
0
votes
1
answer
4k
views
SSRS Export report to XML and drop <Report> Element
I'm trying to set up a report in SSRS with a subscription to export some data as a XML file so it can be imported into another application. However the report element is causing the whole thing to ...
-1
votes
1
answer
3k
views
Exporting data from database to xml
I need to save data from a relational database record set in MySQL (composed of multiple tables and multiple sub-records for each master record) to an xml file. My questions are:
Is there an xml ...
1
vote
1
answer
2k
views
VBA command export XML fine but do not replace
I'm decided to try my way around VBA, got a little script running to export a XML map I have in a worksheet to XML, works fine so far, but when that XML file is already generated, it returns a error ...
- 105
0
votes
1
answer
154
views
Exporting SQL Server table to XML
I'am trying to export SQL Server table to XML file using the following code:
Dim ds As New Data.DataSet("MyData")
Dim QueryStr As String = "Select * from Inventory"
Dim ConnectionStr as String = "...
- 25
-2
votes
1
answer
346
views
How to convert data in Excel to XML
My requirement is as follows
I want to convert below data in Excel to XML in this format.
Last Name Sales Country Quarter
Smith $16,753.00 UK Qtr 3
Johnson $14,808.00 USA Qtr ...
- 5
0
votes
1
answer
60
views
From database to XML with data types
I am getting info from a database and adding it to a dataset. Then I create a XML with this info. I would want to have the XML, but also the datatypes in the header. Is it possible?
Here my code to ...
- 1,428
0
votes
1
answer
260
views
Lotus Notes XML Export as embedded view not working
I am trying to export fields from a Lotus Notes database via XML.
I created a view with all the columns and the XML tags.
I then created a page that references this embedded view.
When I open the ...
- 2,045
1
vote
2
answers
1k
views
Ruby on Rails to_xml nil="True"
I need your help on to_xml function. How can i make all nil="True" value to a default value '' (blank) when exporting to xml from active record.
- 11
0
votes
2
answers
6k
views
Get Account Data and export to xml
I need to export some attributes from active directory user accounts to xml containg Displayname, email, officephone, mobile, office and department. I got this powershell code
foreach ($User in (get-...
- 27
13
votes
2
answers
49k
views
Specify encoding XmlSerializer
I've a class correctly defined and after serialize it to XML I'm getting no encoding.
How can I define encoding "ISO-8859-1"?
Here's a sample code
var xml = new XmlSerializer(typeof(Transacao));
...
- 2,702
1
vote
3
answers
11k
views
Excel formatting for date is not working when exporting as XML
I have created an Excel that includes a mapping file. What I am trying to do is have users enter the data in here and press ctrl + E (I created a macro) and it would export it out as XML. Here's the ...
- 1,387