Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ProjectWise
  • Product Communities
ProjectWise
ProjectWise PowerShell Extensions Forum archive fails to import with Russian text
    • Sign In

    • State Suggested Answer
    • Replies 7 replies
    • Answers 1 answer
    • Subscribers 66 subscribers
    • Views 963 views
    • Users 0 members are here

    archive fails to import with Russian text

    Stephen Herrick
    Offline Stephen Herrick over 2 years ago

    All,

    i am using the Export-PWDocumentsToArchive  and Import-PWDocumentsFromArchive to move some projects

    the files in ProjectWise was provided by our Russian office and have some Russian text, see below

    90651-9100-ТМ-06-000_rB1 для AFW-Лист1-AFW Comments.pdf

    the export works fine, with no errors,

    however when i import, i get the following errors

    WARNING: Zip file error: Illegal characters in path.
    Will be treated as abstract document

    i havent installed a Russian language pack, as the project didnt require it and the files were opening fine within PW

    Any suggestions?

    • Sign in to reply
    • Cancel
    Parents
    • Dan Williams
      0 Offline Dan Williams Thu, Mar 25 2021 4:54 AM

      Stephen Herrick,

      What versions are you using for ProjectWise and for PWPS_DAB?

      Can you provide your script that creates the archive and the script that imports from that archive?  That will make troubleshooting easier.  And if you can, a small archive that can be use to demonstrate the problem.

      If you don't want to post your scripts or archive here, try using the method documented here: Secure File Upload

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    • Stephen Herrick
      0 Offline Stephen Herrick Thu, Mar 25 2021 8:45 AM in reply to Dan Williams

      HI Dan, thanks for the reply, 

      I have both pwclt and pwadm 10.00.03.434

      pwps_dab version 1.27.1.0

      pretty simple script,

      #Archive to SQL lignth

      $OutputArchive = "C:\PowerShell\A19_Archive"
      $begin = Get-Date

      New-PWLogin
      Get-PWCurrentDatasource

      $ArchiveProject = Show-PWFolderBrowserDialog -Verbose
      $ArchiveName = $ArchiveProject.FullPath

      Export-PWDocumentsToArchive -ProjectWiseFolder $ArchiveProject.FullPath -OutputFolder $OutputArchive -OutputFileName $ArchiveName -Verbose

      Undo-PWLogin

      #so now lets import in the Archive

      New-PWLogin
      Get-PWCurrentDatasource

      $ArchiveImportFolder = Show-PWFolderBrowserDialog -Verbose

      $ArchiveImportFile = $OutputArchive + "\" + $ArchiveName + ".sqlite"

      Import-PWDocumentsFromArchive -InputFile $ArchiveImportFile -TargetProjectWiseFolder $ArchiveImportFolder.FullPath -Verbose

      Undo-PWLogin
      $End = Get-Date

      $End - $begin

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    • Dan Williams
      0 Offline Dan Williams Tue, Mar 30 2021 1:11 AM in reply to Stephen Herrick

      Stephen Herrick, can you please make your archive file available to me? the ".sqlite" file?  Then I can try to import it and walk through the code behind Import-PWDocumentsFromArchive and see what is going on.

      BTW, if you weren't aware, an .SQLITE file is a self contained database which you can open with the tools from https://www.sqlite.org/ 

      I'm always a bit wary of "special characters" and databases, so one of things I would check is to see if the import recorded the file names correctly or not.  If not, then the "problem" might well be with the Export-PWDocumentsToArchive, so I hope to look at that process as well.

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    • Stephen Herrick
      0 Offline Stephen Herrick Tue, Mar 30 2021 1:03 PM in reply to Dan Williams

      Thanks so much Dan, i exported a subset, to make it a smaller file, wher can i upload that to,

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    • Stephen Herrick
      0 Offline Stephen Herrick Tue, Mar 30 2021 1:32 PM in reply to Stephen Herrick

      Dan, here is snap shot of the SQL data and PW data

      PDF

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    • Dan Williams
      0 Offline Dan Williams Tue, Mar 30 2021 1:56 PM in reply to Stephen Herrick

      Please follow the instructions provided here:  https://communities.bentley.com/help/w/be_communities_help/7079/communities-secure-file-upload 

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Reject Answer
      • Cancel
    • Dan Williams
      0 Offline Dan Williams Tue, Mar 30 2021 1:59 PM in reply to Stephen Herrick

      Stephen Herrick, if I'm interpreting the snap shot that you provided correctly, it appears that the document name is the same in the SQLITE file as it is in ProjectWise.  Thanks for verifying this.

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    Reply
    • Dan Williams
      0 Offline Dan Williams Tue, Mar 30 2021 1:59 PM in reply to Stephen Herrick

      Stephen Herrick, if I'm interpreting the snap shot that you provided correctly, it appears that the document name is the same in the SQLITE file as it is in ProjectWise.  Thanks for verifying this.

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    Children
    No Data

    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies