php - Moving html data from mysql (wordpress) to sqlserver -

-

i upgrading website asp.net have @ least 100k posts in wordpress. not find related topic moving wanted share experience.

big data not problem, however, of wordpress tables have html data containing quotes (both single , double), &nbsp's, tab characters , on. have tried many ways both exporting however, exporting sql file not work me (at least, not able work it, causes many troubles).

best way move data exporting csv files, seperately each table. while exporting, have to:

  1. custom export
  2. different , unique strings both "columns separated with" , "columns enclosed with" (i used ############ , @@@@@@@, respectively)
  3. check "remove carriage return/line feed characters within columns"
  4. check "put columns names in first row"
  5. download export file

after downloading, replacing take place:

  1. tabs spaces \t -> space
  2. double quotes single " -> '
  3. ###### -> \t
  4. @@@@@@@ -> "

finally, encoding conversion required. myadmin output ansi file , corrupt. sql server might not able handle it. resolve it, first convert utf-8 , convert ansi again (in notepad++, has options in "encoding" menu).

while importing sql server, must have select text file source. select related csv files , while importing, take care of column lengths. sql server make columns varchar(50) default. exported data have more larger columns. have adjust them in import wizard manually. use dt_text (not dt_ntext) string values.

i know process result in data loss (tabs , double quotes) however, wordpress' html editor's fault. html data should stored encoded in database these purposes...


Comments

Post a Comment

Popular posts from this blog

python - pip install -U PySide error -

-
does know how avoid following error when running pip install -u pyside per official website instructions here: https://pypi.python.org/pypi/pyside/#installing-pyside-on-a-mac-os-x-system note have done brew install qt successfully. you using pip version 7.0.3, version 7.1.2 available. should consider upgrading via 'pip install --upgrade pip' command. collecting pyside using cached pyside-1.2.4.tar.gz installing collected packages: pyside running setup.py install pyside complete output command /applications/anaconda/bin/python -c "import setuptools, tokenize;__file__='/private/var/folders/dy/ttgqhqqx3g9bsbsnqnxsk2z80000gq/t/pip-build-cpxemt/pyside/setup.py';exec(compile(getattr(tokenize, 'open', open)(__file__).read().replace('\r\n', '\n'), __file__, 'exec'))" install --record /var/folders/dy/ttgqhqqx3g9bsbsnqnxsk2z80000gq/t/pip-0r7hri-record/install-record.txt --single-version-externally-managed --compile: ...
Read more

arrays - C++ error: a brace-enclosed initializer is not allowed here before ‘{’ token -

-
simple question: i'm trying initialize array within c++ class declaration: using namespace std; #include <string> class myclass{ public: string myarray[] = {"a","b","c"}; }; and i'm getting error: error: brace-enclosed initializer not allowed here before ‘{’ token no, without complied c++11 compiler, cannot initialize member array in declaration. have initialize array member in constructor. , don't use open array if know number of elements initialize array.
Read more

cytoscape.js - How to add nodes to Dagre layout with Cytoscape -

-
i trying add nodes dagre graph through cityscape.js. problem nodes not painted. code have: cy.add({ group: "nodes", data: { id:"n0",name:"n0",weight: 75 }, }); $.ajax(url).done(function(jsontree){ var newnodes=[]; for(var i=1;i<6;i++){ //var child = jsontree.result[i]; newnodes.push( { group: "nodes", data: { id: "n"+i, name:"n"+i}}, { group: "edges", data: { id: "e"+i, source: "n0", target: "n"+i } } ); } cy.add(newnodes); any ideas? have used loaded function reload graph not work. not know if have use specific function reload graph. thank in advance. you need add positions new nodes. cytoscape.js docs : it important note positions of newly added nodes must defined when calling cy.add(). nodes can not placed in graph without valid position — otherwise not displayed. yo...
Read more