Support » Fixing WordPress » Importing from an unknown CMS (got xml & sql files)

  • Hello all,

    I’m new to wordpress and I’ve noticed that there’s several options to import from. I’m sure they’re all very easy to do, but my problem is just received an XML export and a SQL dump along with the images folder from my company’s previous host. The relationship ended badly so I can’t just ask them what CMS they were using.

    How should i go about importing this into Word press ?

Viewing 5 replies - 1 through 5 (of 5 total)
  • One can answer this when one has seen the xml structure and the sql dump.

    Thread Starter Klark

    (@d_kc)

    This is the first couple of lines from the xml file opened with notepad.

    <?xml version="1.0" encoding="utf-8" ?>
    <CPSG>
      <!-- Table export -->
        <export>
            <id>2890403</id>
            <headline>Guyanese UN official agrees to serve as UG Chancellor</headline>
            <article_text><p>Guyanese United Nations official, Dr Bertrand Ramcharan has accepted the appointment to serve in the post of Chancellor of the University of Guyana.
    </p>
    <p>Dr Ramcharan who is currently acting as United Nations High Commissioner for Human Rights succeeds Kenyan Professor Calestous Juma who resigned last year after spending just over a year in the position.
    </p>
    <p>Juma, a Harvard University professor in International Affairs had been installed in the post on January 28, 2002 after being unanimously elected by members of the UG Council at a January 17 meeting to fill the position vacated by Guyanese diplomat Rudy Insanally.
    </p>
    <p>Ramcharan will be the fourth Guyanese to take up the position and the seventh Chancellor of the country's lone university.
    </p>
    <p>Cabinet Secretary Dr Roger Luncheon in formally announcing Ramcharan's acceptance said that cabinet at its most recent meeting on Tuesday had been informed of the UN official's decision to take the largely ceremonial post.
    </p>
    <p>According to Luncheon, Dr Ramcharan has spent most of his public and professional life in service of the UN system.
    </p>
    <p>Ramcharan who has been functioning in the post of Deputy High Commissioner for Human Rights at the UN, has since May last year been performing the role of acting High Commissioner for Human Rights. This followed the appointment of the substantive post holder Sergio Vieira de Mello to head the UN team in Iraq.
    </p>
    <p>Following de Mello's tragic death in August last year, Ramcharan has continued to act in the position once held by the Brazilian diplomat.
    </p>
    <p>Luncheon also noted Dr Ramcharan's important contributions through his writings on human rights. Ramcharan is also a lawyer by training.</p>
    </article_text>
            <dateline>Thursday, January 29th 2004</dateline>
            <created_date>2004-01-29 01:20:21</created_date>
            <section>Local News</section>
            <caption>Bertrand Ramcharan</caption>
            <link>/shared/images/2004/01/29/ram 1.jpg</link>
            <caption2>Bertrand Ramcharan</caption2>
            <link2>/shared/images/2004/02/03/ramcharran_bertie.jpg</link2>

    looking at the SQL dump will give you table names… googling a few of those might give you a hint as to which CMS was used.

    you could be lucky to find that it’s a common one.

    Thread Starter Klark

    (@d_kc)

    I searched did find anything. First couple of lines in the sql looks like this.

    CREATE TABLE export (
      id int(11) NOT NULL default '0',
      headline varchar(255) default NULL,
      subheadline varchar(255) default NULL,
      article_text blob,
      breakout varchar(255) default NULL,
      byline varchar(255) default NULL,
      dateline varchar(255) default NULL,
      created_date varchar(255) default NULL,
      section varchar(255) default NULL,
      caption varchar(255) default NULL,
      link varchar(255) default NULL,
      caption2 varchar(255) default NULL,
      link2 varchar(255) default NULL,
      PRIMARY KEY  (id)
    ) TYPE=MyISAM;
    
    --
    --
    
    INSERT INTO export VALUES (2890403,'Guyanese UN official agrees to serve as UG Chancellor',NULL,'<p>Guyanese United Nations official, Dr Bertrand Ramcharan has accepted the appointment to serve in the post of Chancellor of the University of Guyana.\n</p>\n<p>Dr Ramcharan who is currently acting as United Nations High Commissioner for Human Rights succeeds Kenyan Professor Calestous Juma who resigned last year after spending just over a year in the position.\n</p>\n<p>Juma, a Harvard University professor in International Affairs had been installed in the post on January 28, 2002 after being unanimously elected by members of the UG Council at a January 17 meeting to fill the position vacated by Guyanese diplomat Rudy Insanally.\n</p>\n<p>Ramcharan will be the fourth Guyanese to take up the position and the seventh Chancellor of the country\'s lone university.\n</p>\n<p>Cabinet Secretary Dr Roger Luncheon in formally announcing Ramcharan\'s acceptance said that cabinet at its most recent meeting on Tuesday had been informed of the UN official\'s decision to take the largely ceremonial post.\n</p>\n<p>According to Luncheon, Dr Ramcharan has spent most of his public and professional life in service of the UN system.\n</p>\n<p>Ramcharan who has been functioning in the post of Deputy High Commissioner for Human Rights at the UN, has since May last year been performing the role of acting High Commissioner for Human Rights. This followed the appointment of the substantive post holder Sergio Vieira de Mello to head the UN team in Iraq.\n</p>\n<p>Following de Mello\'s tragic death in August last year, Ramcharan has continued to act in the position once held by the Brazilian diplomat.\n</p>\n<p>Luncheon also noted Dr Ramcharan\'s important contributions through his writings on human rights. Ramcharan is also a lawyer by training.</p>\n',NULL,NULL,'Thursday, January 29th 2004','2004-01-29 01:20:21','Local News','Bertrand Ramcharan','/shared/images/2004/01/29/ram 1.jpg','Bertrand Ramcharan','/shared/images/2004/02/03/ramcharran_bertie.jpg'),(3047186,'Guyanese UN official agrees to serve as UG Chancellor','','Guyanese United Nations official, Dr Bertrand Ramcharan has accepted the appointment to serve in the post of Chancellor of the University of Guyana.\r\nDr Ramcharan who is currently acting as United Nations High Commissioner for Human Rights succeeds Kenyan Professor Calestous Juma who resigned last year after spending just over a year in the position.\r\nJuma, a Harvard University professor in International Affairs had been installed in the post on January 28, 2002 after being unanimously elected by members of the UG Council at a January 17 meeting to fill the position vacated by Guyanese diplomat Rudy Insanally.\r\nRamcharan will be the fourth Guyanese to take up the position and the seventh Chancellor of the country’s lone university.\r\nCabinet Secretary Dr Roger Luncheon in formally announcing Ramcharan’s acceptance said that cabinet at its most recent meeting on Tuesday had been informed of the UN official’s decision to take the largely ceremonial post.\r\nAccording to Luncheon, Dr Ramcharan has spent most of his public and professional life in service of the UN system.\r\nRamcharan who has been functioning in the post of Deputy High Commissioner for Human Rights at the UN, has since May last year been performing the role of acting High Commissioner for Human Rights. This followed the appointment of the substantive post holder Sergio Vieira de Mello to head the UN team in Iraq.\r\nFollowing de Mello’s tragic death in August last year, Ramcharan has continued to act in the position once held by the Brazilian diplomat.\r\nLuncheon also noted Dr Ramcharan’s important contributions through his writings on human rights. Ramcharan is also a lawyer by training.','','','2004-01-29','2004-02-03 11:02:33','Local News','Bertrand Ramcharan','/shared/images/2004/02/03/ramcharran_bertie.jpg',NULL,NULL),(13683846,'Guyana and the wider world','Sluggish export growth and the economic slump','<p>Last week\'s article drew attention to the fact that over the past seven years the Guyana  economy has been mired in an economic slump with an average growth rate of national output (GDP) of less than one-half of one per cent per annum.  As the figures I cited and the accompanying graph revealed in that article, for three of those years per capita GDP actually declined.  Alongside that observation we noted that nevertheless gross investment rates remained high in the country, averaging 23 per cent of GDP in the same period (1998-2004). When this is put in the context of the economic slump the need for an explanation of this paradox is readily apparent. \r\n</p>\r\n<p>As an explanation, some would simply say the figures are too surreal to be true and that the national accounts data are little more than fabrication.  I shall not pursue that issue at this stage, as it raises concerns and issues that go well beyond the intended scope of today\'s article. As I proceed I shall, however, return to it. Suffice it to say that for the moment these are the only figures we have. What would replace the existing historical time series if we discard them?\r\n</p>\r\n<p></p>\r\n<p>The investment factor\r\n</p>\r\n<p>That apart, one contributing factor that immediately springs to mind is that investment must be inefficient for this to have persisted this long. I started to address this last week.  As I noted this would be true both for public and private investment, although it is pertinent to note that public investment accounts for more that 60 per cent of the total investment in Guyana.  However, the inefficiency of much of the public investment is well known to the average Guyanese, and in fact bears no repeating.  \r\n</p>\r\n<p>Our recent history has been littered with infrastructure works, which, if not actually having turned sour, have certainly yielded very poor returns for money spent.  To this observation we should add the wastage that has occurred because of favouritism in awarding contracts, corruption, and mismanagement.   \r\n</p>\r\n<p>Without gainsaying this, the situation does, however, also suggest that the system and methodology for project selection in Guyana is quite weak.  Further, it seems that too much of public investment flows to \'traditional\' low productivity sectors of the economy.  Indeed, this latter occurrence may well link backwards to the period of immiserizing growth, which the country endured during the late 1970s and 1980s.  That period was marked by a calamitous wastage of the productive factors.  The deterioration of the physical infrastructure, including both public utilities as well as other areas such as roads, bridges, wharves and sea defences has been well documented in a number of my earlier publications.  So too has been the evidence of the collapse of basic social services, particularly health, education and housing.  And to add to this, coastal lands were also withdrawn from agriculture as the drainage and irrigation system deteriorated, along with access roads and storing and drying facilities.  Readers, who have done so previously, may wish to re-read the Guyana Human Development Report, where a similar description to this was presented, almost a decade ago. \r\n</p>\r\n<p>Because of foreign exchange shortages of that period, much of the machinery, plant and equipment used in both the public and private sectors, but particularly the latter, had become obsolescent, as maintenance and replacement could not be financed. In this regard therefore, the damage caused by the recent floods would have aggravated the situation of the economic and social    infrastructure, which will in turn force further public investment in the direction of again simply replacing what was destroyed.\r\n</p>\r\n<p></p>\r\n<p>Sluggish export growth\r\n</p>\r\n<p>Another important contributing factor to the economic slump in the face of high investment has been the sluggish growth of export earnings. The weak performance of the export sector becomes dramatically evident when one considers the trend in exports over the past decade from 1996 to 2004 (or the Budget projection for 2005). \r\n</p>\r\n<p>Because in the Budget presentation comparisons are usually made with the previous two years, the impression might have been created in the document that export earnings have increased, with rising earnings from sugar as the US dollar has depreciated against the euro. The truth of the matter, however, is that an export earning of US$560 million in 2004 was still below that of 1997 nearly a decade ago (US$ 594 million).  That year was the year before the economic slump started in 1998.   \r\n</p>\r\n<p>This decline in export earnings is very significant, as is in some ways one would expect that with inflation and the depreciation of the Guyana dollar (reinforced by its peg to the US dollar) that nominal values would just continue to rise over time, but this has not been the case.  For 2005, the Budget has projected an even lower target of export earnings of US$533 million.  This no doubt reflects the impact of the closure of the Omai mines, as exports of gold are projected to fall by about 40 per cent, from a total of US$145 million in 2004 to US$88 million in 2005. \r\n</p>\r\n<p>The Guyana economy as we all know is heavily dependent on export production and sales of goods and services.  \r\n</p>\r\n<p>On average it accounts for well over 90 per cent of our GDP, the bulk of formal employment, and much of government revenue.  Weakness in this sector cannot be compensated for by growth in the domestic sector, because it is too small and the government\'s policy of wage compression has stifled its growth. The irony of course, is that despite these policies, growth of the economy has not been forthcoming. \r\n</p>\r\n<p>The future prospect for our exports does not look too bright.  Sugar is facing a threat in the European Union market and the Omai gold exports are coming to an end. In the face of this there has been little diversification. Next week I shall continue this discussion.\r\n</p>\r\n','','By Dr Clive Thomas','Sunday, March 13th 2005','2005-03-12 22:00:41','Sunday Features',NULL,NULL,NULL,NULL),(13683853,'Through a woman\'s eyes','Woman\'s work','<p>Man may work from sun to sun,\r\n</p>\r\n<p>But woman\'s work is never done. \r\n</p>\r\n<p>  - Anonymous\r\n</p>\r\n<p></p>\r\n<p>Despite endless research, I just could not find out who penned the above rhyme. It may as well remain unsourced, because while it is true, it is more of a curse than an adage; but thankfully curses can be broken. A sister said she believes the truth is that women never know when their work is done. But what is a woman\'s work? A poem written by Marshall H. Hart (aptly named, you will see) gives an inkling:\r\n</p>\r\n<p></p>\r\n<p>What Do Women Do All Day?\r\n</p>\r\n<p>Every minute to and fro, that\'s the way my hours go.\r\n</p>\r\n<p>\"Bring me this and take me that,\" feed the dog, take out the \r\n        cat.\r\n</p>\r\n<p>Standing up, I eat my toast, drink my coffee, thaw the roast.\r\n</p>\r\n<p>Empty the garbage, make the bed, rush to church, then wash \r\n</p>\r\n<p>  my head.\r\n</p>\r\n<p>Sweep the kitchen, wax the floors, scrub the woodwork,\r\n       clean the  doors.\r\n</p>\r\n<p>Scour the bathtub, then myself. Vacuum carpets, straighten\r\n       shelves.\r\n</p>\r\n<p>Eat my sandwich on the run; now my afternoon\'s begun.\r\n</p>\r\n<p></p>\r\n<p>To the baseball game I go; when will there be time to sew?\r\n</p>\r\n<p>Meet the teachers, stop the fight. See the dentist, fly the kite.\r\n</p>\r\n<p>Help with homework, do the wash. Iron the clothes, put on\r\n      the squash.\r\n</p>\r\n<p>Shop for groceries, cash a check; fight the crowds, now I\'m \r\n</p>\r\n<p>  a wreck.\r\n</p>\r\n<p>Dinnertime it soon will be. \"What\'s for dinner?\" \"Wait and\r\n</p>\r\n<p>   see.\"\r\n</p>\r\n<p></p>\r\n<p>Dirty dishes crowd the sink. Next there\'s popcorn, then a\r\n       drink.\r\n</p>\r\n<p>Will they ever go to bed? Will I ever get ahead?\r\n</p>\r\n<p>\"Bring me water,\" get the light. Turn off the TV, lock the \r\n        bike.\r\n</p>\r\n<p>\"Where\'s my pillow?\" \"Hear my prayers.\" \"Did you lock \r\n         the door downstairs?\"\r\n</p>\r\n<p>At last, in bed, my spouse and I, too tired to move, too weak \r\n       to cry.\r\n</p>\r\n<p>But ere I doze, I hear him say, \"What do women DO all \r\n      day?\"\r\n</p>\r\n<p>We have been assimilated. Eons of socialisation have placed us in a group, which society dictated should act in a certain way and do certain things. Any deviation from this saw raised eyebrows, whispers and even broad deprecation, sometimes from members of the group. \r\n</p>\r\n<p></p>\r\n<p>Enter the feminists. These were/are the ones who originally set the eyebrows jumping and the tongues wagging. They believe(d) that since women were also born with human intelligence then they should be expected to use it in ways other than figuring out how to run a home on a pittance or fit  100 hours of housework into a 24-hour day. Getting the \'others\' to see this took some time, as we all know. \r\n</p>\r\n<p>Today, hundreds of years later, most women in the world have achieved suffrage and have broken the barrier of securing paid work outside the home. Certainly there is cause to celebrate, but this is one instance where woman\'s work remains undone. The struggle for equal pay as the man in the next cubicle, office, or next door on the production line continues all around the world. \r\n</p>\r\n<p>Whether women work outside the home or not, we are still ultimately responsible for, as my sister puts it, \'home affairs.\' How many times have you heard spouses say, \"I help my wife with the housework\" and expect a pat on the back for it? Pat him on the back, but offer him this caveat: You are not helping your wife, you are simply doing what needs to be done. \r\n</p>\r\n<p>Society also holds women responsible for good looks, the right weight (beer bellies are fondly acceptable on men only), imparting morals to our children. It is also supposed to be our \'god-given\' talent to make something out of nothing - that did not end in our mothers\' generation. \r\n</p>\r\n<p>By the way, my mother and mother-in-law, both among the millions of gold medallists in woman\'s work, raised six and eight children respectively; cooked, cleaned, crocheted, sewed, volunteered at church and also worked outside the home. I could never in my wildest dreams hold a candle to either of them. Nor would I want to.\r\n</p>\r\n<p>Lest you think I am completely jaded and headed for manic depression, let me tell you this. I love both my jobs and wouldn\'t change either. But don\'t get me wrong, I look forward just as eagerly to vacation and down time. Nor do I blame men for women\'s plight. The real enemies are ignorance and poverty. If we can find a way to successfully tackle these then we would be well on our way to breaking the curse.</p>\r\n','','By Cheryl Springer','Sunday, March 13th 2005','2005-03-12 22:00:42','Sunday Features',NULL,NULL,NULL,NULL),(13683854,'Consumer Concerns','Say no to genetically modified food','<p>Once again we celebrate World Consumer Rights Day on Tuesday, March 15. The theme this year is \'Consumers say NO to GMOs\' (genetically modified food).\r\n</p>\r\n<p>Consumers International (CI), with 250 member organisations in 115 countries, has been using this day to remind consumers worldwide of their consumer rights.  This year the Council of CI, after thorough discussion and debate, agreed to create a global campaign on genetically modified food. The campaign priorities for 2005 include compulsory  labelling legislation, bio-safety and strict co-existence.\r\n</p>\r\n<p>CI reminds its members that their participation in the campaign is essential for its success.  With a little imagination one would recognise that 250 organisations concentrating on a single theme holds out more promise of success than if each member went about the commemoration in his own way. Unfortuntely, in Guyana, the Consumer Affairs Division in the Ministry of Tourism, Industry and Commerce does not recognise this fact and has decided to select its own theme for WCRD.\r\n</p>\r\n<p>CI\'s council envisages that the first and important step will be for all members to encourage their governments to support guidelines for GM labelling at the next meeting of Codex Alimentarius on Food Labelling (CCFL) in May in Malaysia.\r\n</p>\r\n<p>One of the eight consumer rights accepted by Consumers International and by United Nations is the right to choose.\r\n</p>\r\n<p>The others are:\r\n</p>\r\n<p></p>\r\n<p>the right to basic needs;\r\n</p>\r\n<p>the right to safety;\r\n</p>\r\n<p>the right to be informed;\r\n</p>\r\n<p>the right to be heard;\r\n</p>\r\n<p>the right to redress;\r\n</p>\r\n<p>the right to consumer education;\r\n</p>\r\n<p>the right to a healthy environment.\r\n</p>\r\n<p>(To be continued)\r\n</p>\r\n<p></p>\r\n<p>For a number of years efforts have been made to have mandatory labelling requirements for genetically modified food. The three largest producers of GMOs - United States, Canada and Argentina - have no mandatory labelling requirements. \r\n</p>\r\n<p>The European Union\'s legislation on GM food and food labelling came into force in October 2003 and is among the strictest in the world. The People\'s Republic of China in 2002 announced plans to introduce compulsory GM food labelling. In Australia only foods with GM proteins detectable in testing must be labelled. India, South Korea, Taiwan and Thailand have adopted labelling schemes similar to Australia\'s. Regulations in Brazil include mandatory use of a symbol indicating GM content.\r\n</p>\r\n<p>For the benefit of those who are now becoming familiar with genetically modified or genetically engineered food this is a process whereby genes are removed from one organism - a plant, animal or microbe - and transferred to another. \r\n</p>\r\n<p>This procedure is carried out in order to give the treated plant some desirable trait. A gene from a bacterium can enable corn and cotton crops to produce their own pesticide that is harmless to humans and most insects. The yield from the plant increases.\r\n</p>\r\n<p>Genetic engineering has been practised for years. We learn, for instance, that tomatoes, potatoes and wheat have been genetically altered by breeding them with wild relatives.\r\n</p>\r\n<p>There are two major concerns: whether the new genes or proteins  might produce toxins that can cause harm in the long or short term and whether the new gene might produce a protein that triggers an allergy reaction in a person who eats the food.\r\n</p>\r\n<p>Consumers have concerns because serious health problems may not appear for years. And there are many consumers who object to these man-made changes to nature. Like climate change we may feel the effects when it is too late to reverse our actions.\r\n</p>\r\n<p>There are other concerns. Steps are now being taken to genetically engineer rice. If one farmer in Guyana decides to produce GM rice, it may have an effect on other farms as neighbouring fields become contaminated. The European Union does not accept GM products.  Trade will be affected.\r\n</p>\r\n<p>One of the chief concerns is that, with GM plants producing sterile seeds, those who control seeds that germinate will be in a position to control all the countries that need seeds. \'You do as our government wishes, or else.\'\r\n</p>\r\n<p>Labelling of GM foods is essential. Those who wish to be guinea pigs may consume GM foods. Others, conservative by nature, will remain with traditional foods.\r\n</p>\r\n<p>In asking consumers to say NO to GMOs, it is evident that CI is not satisfied that these foods have had enough testing to be accepted as safe.\r\n</p>\r\n<p>In some countries consu

    It says right there on the second line of the XML file….

    CPSG Software, Inc.
    http://www.cpsgsoftwareinc.com/index.pl/cms1
    Tel 450.624.9973

    Call them for assistance.

    If this helps, I invite you to visit my profile some time.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Importing from an unknown CMS (got xml & sql files)’ is closed to new replies.