By samuk on

Hi all

We are building a Drupal site to contain some location specific content.

I have set up a dev site and got it working mostly as I would like. The actual build is not going to happen for several weeks.

In the meantime we need to start collecting the data to import once the site is up and running.

I have done a export from the dev site of the Entities that we need to capture data for (a custom content type that includes data from the location module)

I have never really used .xml files before and only have a very basic grasp of how they work.

I have opened the .xml file in excel and tried adding data to it. Howver when I try exporting the new data from excel I get a message that the xml maps in the workbook are not exportable.

I have tried suggesting that we just enter the data into the dev site and then export it from there when the proper build is ready. There is resistance to this approach for various political/organisational reasons.

Are there any documents or how to's that I should read about capturing data for Drupal?

Should I stick to my guns and insist that data is inputted into the dev site?

⋅ Categories: Drupal 6.x

Comments

cayenne’s picture

cayenne commented

When dealing with bulky data, I have found that turning the data into a csv (trivial with excel) and using the node import module does the trick.

:)

dcarr’s picture

dcarr commented

Yeah I'm trying to do something like that as well. Import data from a basic .csv file. I'm installing these:

FeedAPI
FeedAPI Mapper
Parser CSV

Hopefully that will do what I'm looking to do.

Mac Clemmens’s picture

Mac Clemmens commented

If you're working on a Mac, you may need to save your excel spreadsheet in "CSV (Windows)" format, to ensure the line breaks get properly processed. Node import thought my spreadsheet was one huge row. Hope this helps.