Tips & Tricks
Are you looking for some of the best-known Tips & Tricks or have some to share. This is the place to... View more
Organizer:
- Organized by
-
-
Markups XML Import
-
Markups XML Import
Hi!
I have an example case that I am struggling with and I would be grateful for some insight.
I am creating a simple sequence (think 1, 2, 3) where I am labeling locations on a PDF. I am trying to test the following workflow that I will build out more once I get success.
1) add 1,2,3 location labels via a sequence
2) create a markup summary xml
3) delete the markup’s for testing the workflow
4) Markup’s list –> Markup’s –> Import –> select the summary file just created
5) 🙁 no markups are showing up but this is where I would hope the 1,2,3 markups would reappear
The bigger workflow is I am trying to edit the data in the xml between the export and import process. I would love to export a csv then figure out how to convert this to xml, but I wanted to start simple with xml out and xml in, but I am unable to even get this to work.
I can get the .bax to work as expected, but editing a .bax is beyond my skillset.
Any help would really be appreciated. Thank you.
-
10 Replies
-
Points: 23,447Rank: UC2 Brainery Brown Belt III
Welcome to the Brainery @backpacker87 (Not sure why it displays that way Joseph) 🙂
There have been a number of discussions about exporting data, modifying it and importing it back in, but I don’t know that I’ve seen this one yet! Unfortunately I don’t know the answer, but I expect a few folks will be along shortly that have more experience with this process.
🍿
-
Points: 6,243Rank: UC2 Brainery Purple Belt I
Quite the workflow there! Curious what you are trying to edit in the markups file?
-
Points: 150Rank: UC2 Brainery Newbie
We are going to be performing field measurements at specific locations that we will mark with a sequenced dot. My idea is the sequenced dot will just have the sequence as the text and a generic color. After all the measurements are recorded in excel, my hope is to overwrite the text in the markup from the markup number say “27” to read “27: 12 FC” (we are measuring light in foot-candles) and I also wanted to change the color of the markup based on if the measurement is within design spec. or not.
Having the data in a table is always nice, but a picture is worth a thousand words and it would be great to provide a set of drawings with the measurement locations marked and the resulting data in a clean and concise way that allows for action to be taken. Such as being able to look at an entire area and see all the dots red would indicate that area’s light levels are too low.
There will be hundreds or thousands of readings, hence the desire to automate the changing of the markups.
-
Points: 23,447Rank: UC2 Brainery Brown Belt III
-
Points: 23,447Rank: UC2 Brainery Brown Belt III
Throwing an idea out to see what other thoughts it generates. How about collecting your data directly in Revu, rather than trying to import it in?
You could create a markup that you apply to your drawing in the field and then capture your meter reading in a custom column directly in Revu.
Once you have a number of results captured your could sort your markups by the meter reading column. You could select all of the markups in the desired range and change the color of the markup. This way your “dots” would be color coded and located on the drawing sheet.
As an added benefit when you hover over your markup in the PDF, depending upon how you have the data entered, you will see some of the information displayed on the screen at your curser (this is how it works on a PC at least). Complete data would be shown in the markup list.
If you need the data in Excel for reporting you could export the data from Revu and then process the information in Excel – perhaps with a Power Query.
-
-
-
Points: 6,243Rank: UC2 Brainery Purple Belt I
Ok, I did a little testing on this, let me know if this fits or not:
When exporting a “summary”, it will not store the same data as if you were to actually “Export markups”. The default format for this is .bax, but you can switch the dropdown for file type to “all files” and put a .xml extension on your name. Tested an export import with this and it seems to work, but it depends on what you are doing with those markups in between and if they need to be imported into another program.
Also, if you export .bax, then open the file with notepad, you will see the same format as if you saved xml and opened in notepad, so maybe some others can chime in on effects of this I don’t know about.
Attached are two files, the M2.00.xml is a Markup summary exported as xml, the Longer named xml file is an actual markups export saved as xml. Try opening both in notepad to see the above visually. I can’t upload .bax extensions here.
-
Points: 150Rank: UC2 Brainery Newbie
Issac,
Thanks for digging in! I am out of the office today but I will be back in tomorrow and I will give this a test drive. Thanks!
-
Points: 6,243Rank: UC2 Brainery Purple Belt I
Wanted to follow up here on a part of your OP. When you say that editing a .bax is beyond your skill set, have you tried just exporting markups (not a summary), and then just opening the markup file like a PDF? you should be able to edit the markups on basically a blank space before re-importing to your file.
-
-
-
Points: 12,674Rank: UC2 Brainery Blue Belt II
Hmm, I’ll have to dig into this a bit
-
Points: 12,674Rank: UC2 Brainery Blue Belt II
What exactly would you be importing back to the drawings?
How would you be editing the xml file?
Log in to reply.