Member Isaac Harned
Member
Forum Replies Created
-
Points: 8,204Rank: UC2 Brainery Purple Belt III
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: 8,204Rank: UC2 Brainery Purple Belt III
Quite the workflow there! Curious what you are trying to edit in the markups file?
-
Points: 8,204Rank: UC2 Brainery Purple Belt III
This was an awesome one for sure!
-
Points: 8,204Rank: UC2 Brainery Purple Belt III
Have you guys tried going to the properties of the file in studio and grabbing the link that way? This is the closest I can seem to get, and will still open up studio to get to the file, not a browser view or anything like that.
-
Points: 8,204Rank: UC2 Brainery Purple Belt III
Possible its on an “Enterprise hosted studio server?”
-
Points: 8,204Rank: UC2 Brainery Purple Belt III
Ugh, we are about to switch to sharepoint and I know this issue will come up. We already have the issue occasionally with onedrive through file explorer, and this sounds like it will be more of an issue when they switch. Is the error handling similar to Onedrive? Alot of these files will not even pop up with an error, and we just have to know why it refuses to open.
-
Points: 8,204Rank: UC2 Brainery Purple Belt III
OK further (confusing) clarification here. When finding that method, I was using the Bluebeam Script Reference 2.0.9, which was apparently published on Feb 9, 2018. This is apparently superseded by Version 1.0.8 (Published Feb 27, 2019?), which removes said method. Both attached.
-
Points: 8,204Rank: UC2 Brainery Purple Belt III
I think it might be able to:
-
Points: 8,204Rank: UC2 Brainery Purple Belt III
Sad day, missed the show. Is there by chance a recording floating around out there?
-
Points: 8,204Rank: UC2 Brainery Purple Belt III
We tried sets, but it does not seem like it is beneficial for our workflow. Our file structure is pretty basic, just mechanical revision sorted by date, but we keep all our bidding info on the revision file, and slip sheet the latest into a folder called “Takeoff Set”, which will have individual files and a ton of markups on each. If sets could manage a single up to date location instead of linking to each revision folder it would work better for us, but at that point would also not be much more different than just maintaining the file structure manually.
-
Points: 8,204Rank: UC2 Brainery Purple Belt III
This is really cool, and works on my end. Thank you @britger !
-
Points: 8,204Rank: UC2 Brainery Purple Belt III
I did end up figuring out the if statement after posting this, bit the offset I completely missed! Thank you, will try this out Monday! Definitely think you may have hit it perfect there!
-
Points: 8,204Rank: UC2 Brainery Purple Belt III
ok I am much closer now than ever before thanks to you guys and that amazing tool. Still having a couple issues:
1. I am seeing duplicated field names when formatted to fdf, can’t quite see why this is happening. Some also appear not to add the “J” variable to the name, and there are several duplications of that.
Also having issue with actually saving the file as FDF, as it is trying to save as xml and just adding the extension for fdf. File attached (could not upload “fdf” file, extension not supported. will have to run macro to see), here’s my code so far:
Sub fdfExpTest()
On Error GoTo ErrorHandler
Application.ScreenUpdating = False ‘disabling screen updating
Dim ws As Worksheet
Set ws = Worksheets(“Sheet3”)
Dim lrow As ListRow
Dim table As ListObject
Set table = ws.ListObjects(“Table3”)
Dim sFileFields, formField As String
Dim currentCell As String
Dim fileName As String
sFileFields = “”
Dim i As Integer
For i = 2 To table.ListRows.Count
Set lrow = table.ListRows(i)
currentCell = lrow.Range(1, 1).Address
Dim j As Integer
For j = 1 To 12
formField = “<</V(” & Range(currentCell).Value & “)/T(” & Replace(Range(currentCell).Value, “-“, j & “-“) & “)>>”
sFileFields = sFileFields & formField
Next j
Next i
fileName = InputBox(“Please enter the file name:”, “File Name”)
If fileName = “” Then Exit Sub ‘if user clicked cancel or didn’t type a name
Dim dialog As FileDialog
Set dialog = Application.FileDialog(msoFileDialogSaveAs)
With dialog
.Title = “Select a location to save the FDF file”
.InitialFileName = fileName & “.fdf”
.Show
If .SelectedItems.Count = 0 Then
MsgBox “No location selected, file will not be saved”
Exit Sub
Else
fileName = .SelectedItems(1)
End If
End With
If Dir(fileName & “.fdf”) <> “” Then ‘checking if the path exists
If MsgBox(“A file with the same name already exists, do you want to replace it?”, vbYesNo) = vbNo Then Exit Sub
End If
Dim fso As New FileSystemObject ‘Create a new FileSystemObject
Dim f As TextStream ‘Create a new TextStream
Set f = fso.CreateTextFile(fileName & “.fdf”, True) ‘Create a new .fdf file and open it for writing
f.WriteLine “%FDF-1.2”
f.WriteLine “%âãÏÓ”
f.WriteLine “1 0 obj<</Version 1.5/FDF<</F(12 TU – Portrait.pdf)/ID[<48dd2d6619f25a804876d8592bbf3bec><78c1721c7ccd2e9289e7fbfd72376444>]/Fields[” & sFileFields & “]”
f.WriteLine “]>>endobj”
f.WriteLine “trailer”
f.WriteLine “<</Root 1 0 R>>”
f.WriteLine “%%EOF”
f.Close ‘closing the file
MsgBox “FDF file has been created successfully and saved in ” & fileName
Application.ScreenUpdating = True ‘enabling screen updating
Exit Sub
ErrorHandler:
MsgBox “Error: ” & Err.Description
Application.ScreenUpdating = True ‘enabling screen updating
End Sub
-
Points: 8,204Rank: UC2 Brainery Purple Belt III
You would think the enterprise track of updates would be properly tested and vetted. Oh well, back to disabling!
-
Points: 8,204Rank: UC2 Brainery Purple Belt III
Sure it’s still a work in progress though. Tab one of the excel workbook was my original intent, but I abandoned after only naming a couple of fields.
Tab 2 is the start of the table. Any row identifiers that have no number would get the column name appended to the end. All the row titles with a dash would get the column name before the dash.
I think you are pretty familiar with the pdf form at this point =)