Stack Overflow
Stack Overflow

Questions tagged [xml-import]

39 questions
3
votes
1 answer

Indesign Script does function twice

I'm assembling a script to automate the production of different versions of a report. The script will first import the XML file, and then run some other functions to tidy up the Indesign project. When I run this script, var myMenuAction =…
PaulTong
  • 35
  • 4
3
votes
3 answers

Performance bulk-loading data from an XML file to MySQL

Should an import of 80GB's of XML data into MySQL take more than 5 days to complete? I'm currently importing an XML file that is roughly 80GB in size, the code I'm using is in this gist and while everything is working properly it's been running for…
Nick
  • 763
  • 1
  • 11
  • 26
2
votes
2 answers

While importing XML to MS Access 2003, boolean variable is being imported as string

I am trying to import an XML file into MS Access 2003, through File>Get External Data>Import. And I want to import a field as boolean. I have pre-built the tables and importing the data only. I am confused that what should be value of boolean in XML…
Varun Mahajan
  • 7,037
  • 15
  • 43
  • 65
2
votes
1 answer

SQL SERVER - OPENROWSET with filepath parameter

I have this SQL script tht work properly: INSERT INTO #XMLwithOpenXML(XMLData, LoadedDateTime) SELECT CONVERT(XML, BulkColumn) AS BulkColumn, GETDATE() FROM OPENROWSET(BULK 'C:\temp\test.wordpress.2017-05-22.xml', SINGLE_BLOB) AS x; SELECT @XML =…
DarioN1
  • 2,460
  • 7
  • 32
  • 67
2
votes
0 answers

Import Google search results using ImportXML

I want to use Google Sheets to grab Google search results's number. My formula is: =ImportXML(URL,"//div[@id='resultStats']") =IMPORTXML("https://www.google.it/search?q=seo+prova";"//div[@id='resultStats']") Google Sheets always returns #N/A, is…
emanuela
  • 31
  • 1
  • 3
2
votes
1 answer

Informatica XML Import Issue from command line: PMREP

I wanted to import an XML file into my informatica repositry from the command line using PMREP command. The command I executed: pmrep objectimport -i .XML -c Control.XML -l Import_Log.txt The control file:
Ra-V
  • 69
  • 2
  • 10
2
votes
1 answer

How to access nested elements in xml with OpenXML

I'm trying to import data from a rather large xml file to an SQL Server. After some online searching I settled upon using OpenXML. The query I have so far is DECLARE @doc INT DECLARE @xml XML SELECT @xml = evnt FROM OPENROWSET (BULK…
Ryez
  • 63
  • 2
  • 8
2
votes
1 answer

How to use Import Xml feature in EPPLUS or other excel generation library?

I was reading in some very old posts that the XML importing feature is going to be implemented in EPPLus. Is it currently implemented? How can I Import data to a excel document that has a XML mapped to its cells. I can't use the interop services,…
Andron
  • 223
  • 1
  • 3
  • 14
1
vote
1 answer

How to import spring bean's configuration file in Maven dependency to an other in my Maven project?

I add local maven repository, I add the local dependency in my project. this dependency encompass a Spring configuration file . I want to import this file in an other spring configuration file. What should I do ? knowing that the dependency tree…
Abdennour Toumi
  • 23
  • 4
1
vote
1 answer

Properly expand xml table nested within cell (Power Query)

I would appreciate your help on importing and expanding an XML file, with Power Query. The XML link is here: UN Consolidated Sanctions List After expanding the table named ”Individual” I get a lot of tables nested within cells. Nested Table I tried…
Bee Hoof
  • 13
  • 3
1
vote
0 answers

Split XML file into multiple Google Sheets

It seems Google Sheets has a limit of 8000 rows (approximately due to my little test). I have an XML file URL containing several thousands of elements. Because of that I'd like to split the XML file into multiple Google Sheets. Is there some way I…
Jester
  • 11
  • 2
1
vote
1 answer

XML import of nested classes with space between them

I am using XMLimport to import various bits of information from a coinmarketcap.com page into a Google sheet. It all works perfectly, accept when I come across what look like two classes appearing within a span tag. This is used to show the 24hr…
Glyph
  • 97
  • 2
  • 9
1
vote
1 answer

Undeclared general entity error while performing XML full import on Solr using DIH

I am trying to bulk import xml files from a folder to solr. My DIH config looks like this.