Hi Ryan, I was able to download the export files (it's 33MB total). But I don't think we have the time and resources right now to write a parser to convert the JSON file to a CSV file for version 4. Isn't this something that you should be supporting instead because you changed the data model? We don't even know what changed from v3 to v4 as far as the data models are, and you're expecting us to write the parser already?
We need to have this up and running by the end of this month. What are our other options at the moment to complete this migration process? Regards, Joel On Saturday, May 6, 2017 at 1:37:26 PM UTC+8, Ryan Anderson wrote: > > Hi Joel, > > > Have you looked into the v3 export_resources command? (python manage.py > packages -o export_resources -d 'path_to_destination') This might fit the > bill for what you're doing. It should export business data as json (with > all your groups intact I believe). From there you can write a parser to > convert that json to a v4 csv file. > > Ryan > > On May 5, 2017 at 10:11 PM, <Joel Aldor <javascript:>> wrote: > > Hi all, > > I'm trying to export resources from Arches version 3 into a CSV file that > I can manipulate for version 4 upload, as recommended by Adam > <https://groups.google.com/d/msg/archesproject/rE9ipvxHso4/fQuB3tGRBgAJ>. > I'm looking into this documentation for v3 > <http://arches-hip.readthedocs.io/en/latest/system-administration/#exporting-data> > > which lets me configure resource export mappings via a JSON file. I > realized, however, that the output of this example is best for resources > that only have single entries per field. Many of our historic resources > have multiple data entries for several fields (e.g. resource description, > classification, components, important dates, measurements, condition > assessments, and lots more). And we are referring to thousands of historic > resources that have these info. > > I tried using the example resource_export_mappings.json file and the > exported CSV file only populates the latest entry for a certain field. > Basically there's only one row per historic resource. We must be able to > export all multiple entries per data field. How do you configure that JSON > file to be able to populate all those fields in a CSV file? > > Requesting for you to look into this matter as this is a very major > challenge for us to be able to export all business data from version 3 and > import them to version 4. We hope to finish this upgrade before the end of > May because we have an upcoming batch of volunteers to train next month. > Didn't realize how hard this whole migration process is. > > Regards, > > Joel > > > -- -- To post, send email to archesproject@googlegroups.com. To unsubscribe, send email to archesproject+unsubscr...@googlegroups.com. For more information, visit https://groups.google.com/d/forum/archesproject?hl=en --- You received this message because you are subscribed to the Google Groups "Arches Project" group. To unsubscribe from this group and stop receiving emails from it, send an email to archesproject+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
