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
    • 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
    >

    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