ACS AEM CSV Asset Importer Is not working in my Dev server | Community
Skip to main content
D
dipu2
New Participant
September 21, 2020

ACS AEM CSV Asset Importer Is not working in my Dev server

  • September 21, 2020
  • 2 replies
  • 3272 views

Dear All,

 

I am using Latest ACS AEM CSV Asset Importer and trying to import images from my local drive (C:\Users\sunita_c\dam) to AEM local instance , as shown below screenshot.

 

 
 

In my local I am getting success message and upload the images are successful.

 

2) When I am doing the same steps in my Development environment (which is in Linux server) , Then I am not able to upload the images. It is not taking the relSrcPath that is C:\Users\sunita_c\dam\images...

 

Is anybody faced similar issue ? "or" any work around for this ? 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

D
dipu2Author
New Participant
September 23, 2020

Hi,

 

I got below error message  java.io.FileNotFoundException: C:/Users/sunita_c/Sunita-Work/images/hero.jpeg (No such file or directory)

 

com.adobe.acs.tools.csv_asset_importer.impl.CsvAssetImporterServlet
CSV Asset Importer Config
----------------------------------------
File Provided: true
Import Strategy: FULL
File Location: C:/Users/sunita_c/Sunita-Work
Unique Property: null
Absolute Target Path Property: absTargetPath
Relative Src Path Property: relSrcPath
MIME Type Property: mimeType
Skip Property: null
Ignore Properties: [absTargetPath, relSrcPath, mimeType, skip, _LINE_TERMINATED]
Batch Size: 1000
Throttle: 0
Charset: UTF-8
Delimiter: null
Separator: null

22.09.2020 21:00:56.276 *ERROR* [10.7.19.151 [1600826456273] POST /etc/acs-tools/csv-asset-importer/_jcr_content.import.json HTTP/1.1] com.adobe.acs.tools.csv_asset_importer.impl.CsvAssetImporterServlet Could not import the row due to
com.adobe.acs.tools.csv_asset_importer.impl.CsvAssetImportException: Could not import row
at com.adobe.acs.tools.csv_asset_importer.impl.CsvAssetImporterServlet.importAsset(CsvAssetImporterServlet.java:251) [com.adobe.acs.acs-aem-tools-bundle:1.0.2]
at com.adobe.acs.tools.csv_asset_importer.impl.CsvAssetImporterServlet.doPost(CsvAssetImporterServlet.java:126) [com.adobe.acs.acs-aem-tools-bundle:1.0.2]
at org.apache.sling.api.servlets.SlingAllMethodsServlet.mayService(SlingAllMethodsServlet.java:146) [org.apache.sling.api:2.20.0]
at org.apache.sling.api.servlets.SlingSafeMethodsServlet.service(SlingSafeMethodsServlet.java:342) [org.apache.sling.api:2.20.0]
at org.apache.sling.api.servlets.SlingSafeMethodsServlet.service(SlingSafeMethodsServlet.java:374) [org.apache.sling.api:2.20.0]
at org.apache.sling.engine.impl.request.RequestData.service(RequestData.java:552) [org.apache.sling.engine:2.7.2]
at org.apache.sling.engine.impl.filter.SlingComponentFilterChain.render(SlingComponentFilterChain.java:44) [org.apache.sling.engine:2.7.2]
at org.apache.sling.engine.impl.filter.AbstractSlingFilterChain.doFilter(AbstractSlingFilterChain.java:82) [org.apache.sling.engine:2.7.2]
at com.day.cq.wcm.core.impl.WCMDebugFilter.doFilterWithErrorHandling(WCMDebugFilter.java:192) [com.day.cq.wcm.cq-wcm-core:5.12.124.CQ655-B0001]
at com.day.cq.wcm.core.impl.WCMDebugFilter.doFilter(WCMDebugFilter.java:159) [com.day.cq.wcm.cq-wcm-core:5.12.124.CQ655-B0001]
at org.apache.sling.engine.impl.filter.AbstractSlingFilterChain.doFilter(AbstractSlingFilterChain.java:72) [org.apache.sling.engine:2.7.2]
at com.day.cq.wcm.core.impl.WCMComponentFilter.filterRootInclude(WCMComponentFilter.java:375) [com.day.cq.wcm.cq-wcm-core:5.12.124.CQ655-B0001]
at com.day.cq.wcm.core.impl.WCMComponentFilter.doFilter(WCMComponentFilter.java:190) [com.day.cq.wcm.cq-wcm-core:5.12.124.CQ655-B0001]
at org.apache.sling.engine.impl.filter.AbstractSlingFilterChain.doFilter(AbstractSlingFilterChain.java:72) [org.apache.sling.engine:2.7.2]
at com.day.cq.wcm.core.impl.page.PageLockFilter.doFilter(PageLockFilter.java:91) [com.day.cq.wcm.cq-wcm-core:5.12.124.CQ655-B0001]
at org.apache.sling.engine.impl.filter.AbstractSlingFilterChain.doFilter(AbstractSlingFilterChain.java:72) [org.apache.sling.engine:2.7.2]
at com.day.cq.personalization.impl.TargetComponentFilter.doFilter(TargetComponentFilter.java:94) [com.day.cq.cq-personalization:5.12.40]
at org.apache.sling.engine.impl.filter.AbstractSlingFilterChain.doFilter(AbstractSlingFilterChain.java:72) [org.apache.sling.engine:2.7.2]
at org.apache.sling.engine.impl.SlingRequestProcessorImpl.processComponent(SlingRequestProcessorImpl.java:283) [org.apache.sling.engine:2.7.2]
at org.apache.sling.engine.impl.filter.RequestSlingFilterChain.render(RequestSlingFilterChain.java:49) [org.apache.sling.engine:2.7.2]
at org.apache.sling.engine.impl.filter.AbstractSlingFilterChain.doFilter(AbstractSlingFilterChain.java:76) [org.apache.sling.engine:2.7.2]
at org.apache.sling.engine.impl.filter.AbstractSlingFilterChain.doFilter(AbstractSlingFilterChain.java:78) [org.apache.sling.engine:2.7.2]
at com.day.cq.wcm.core.impl.warp.TimeWarpFilter.doFilter(TimeWarpFilter.java:109) [com.day.cq.wcm.cq-wcm-core:5.12.124.CQ655-B0001]
at org.apache.sling.engine.impl.filter.AbstractSlingFilterChain.doFilter(AbstractSlingFilterChain.java:72) [org.apache.sling.engine:2.7.2]
at com.adobe.cq.social.ugcbase.security.impl.SaferSlingPostServlet.doFilter(SaferSlingPostServlet.java:126) [com.adobe.cq.social.cq-social-ugcbase-impl:2.5.2]
at org.apache.sling.engine.impl.filter.AbstractSlingFilterChain.doFilter(AbstractSlingFilterChain.java:72) [org.apache.sling.engine:2.7.2]
at org.apache.sling.engine.impl.filter.AbstractSlingFilterChain.doFilter(AbstractSlingFilterChain.java:78) [org.apache.sling.engine:2.7.2]
at org.apache.sling.engine.impl.filter.AbstractSlingFilterChain.doFilter(AbstractSlingFilterChain.java:78) [org.apache.sling.engine:2.7.2]
at com.day.cq.dam.core.impl.servlet.ActivityRecordHandler.doFilter(ActivityRecordHandler.java:141) [com.day.cq.dam.cq-dam-core:5.12.242]
at org.apache.sling.engine.impl.filter.AbstractSlingFilterChain.doFilter(AbstractSlingFilterChain.java:72) [org.apache.sling.engine:2.7.2]
at com.day.cq.dam.core.impl.assetlinkshare.AdhocAssetShareAuthHandler.doFilter(AdhocAssetShareAuthHandler.java:434) [com.day.cq.dam.cq-dam-core:5.12.242]
at org.apache.sling.engine.impl.filter.AbstractSlingFilterChain.doFilter(AbstractSlingFilterChain.java:72) [org.apache.sling.engine:2.7.2]
at com.adobe.granite.rest.impl.servlet.ApiResourceFilter.doFilter(ApiResourceFilter.java:70) [com.adobe.granite.rest.api:1.1.16]
at org.apache.sling.engine.impl.filter.AbstractSlingFilterChain.doFilter(AbstractSlingFilterChain.java:72) [org.apache.sling.engine:2.7.2]
at com.adobe.granite.requests.logging.impl.RequestLoggerImpl.doFilter(RequestLoggerImpl.java:121) [com.adobe.granite.requests.logging:1.0.20]
at org.apache.sling.engine.impl.filter.AbstractSlingFilterChain.doFilter(AbstractSlingFilterChain.java:72) [org.apache.sling.engine:2.7.2]
at com.adobe.granite.rest.assets.impl.AssetContentDispositionFilter.doFilter(AssetContentDispositionFilter.java:96) [com.adobe.granite.rest.assets:1.0.58]
at org.apache.sling.engine.impl.filter.AbstractSlingFilterChain.doFilter(AbstractSlingFilterChain.java:72) [org.apache.sling.engine:2.7.2]
at com.day.cq.wcm.core.impl.AuthoringUIModeServiceImpl.doFilter(AuthoringUIModeServiceImpl.java:372) [com.day.cq.wcm.cq-wcm-core:5.12.124.CQ655-B0001]

at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:388) [org.apache.felix.http.jetty:4.0.16]
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:806) [org.apache.felix.http.jetty:4.0.16]
at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:938) [org.apache.felix.http.jetty:4.0.16]
at java.lang.Thread.run(Thread.java:748)
Caused by: java.io.FileNotFoundException: C:/Users/sunita_c/Sunita-Work/images/hero.jpeg (No such file or directory)
at java.io.FileInputStream.open0(Native Method)
at java.io.FileInputStream.open(FileInputStream.java:195)
at java.io.FileInputStream.<init>(FileInputStream.java:138)
at java.io.FileInputStream.<init>(FileInputStream.java:93)
at com.adobe.acs.tools.csv_asset_importer.impl.CsvAssetImporterServlet.getOrCreateAsset(CsvAssetImporterServlet.java:400) [com.adobe.acs.acs-aem-tools-bundle:1.0.2]
at com.adobe.acs.tools.csv_asset_importer.impl.CsvAssetImporterServlet.importAsset(CsvAssetImporterServlet.java:239) [com.adobe.acs.acs-aem-tools-bundle:1.0.2]
... 141 common frames omitted

    D
    davidjgonzalezzzz
    Employee
    October 20, 2020

    The error states your input file cannot be found:

     

    Caused by: java.io.FileNotFoundException: C:/Users/sunita_c/Sunita-Work/images/hero.jpeg (No such file or directory)

     

    I believe this is due to Java File APIs want Windows paths formatted - so i think you need to provide your path as:

     

    C:\\Users\\sunita_c\\Sunita-Work\\images\\hero.jpeg

     

    https://stackoverflow.com/questions/3059383/file-path-windows-format-to-java-format 

     

    Alternative there are similar tools in ACS Commons (MCP Tools) that can import assets as well - i think the main difference is some of the options around moving assets around via UniqueId and possibly Delta updates.

      vanegi
      vanegi
      Employee
      September 21, 2020

      Do you see any logging in AEM error.log for that timeframe?

        D
        dipu2Author
        New Participant
        September 23, 2020

        Hi,

         

        I got below error message  java.io.FileNotFoundException: C:/Users/sunita_c/Sunita-Work/images/hero.jpeg (No such file or directory)

         

        com.adobe.acs.tools.csv_asset_importer.impl.CsvAssetImporterServlet
        CSV Asset Importer Config
        ----------------------------------------
        File Provided: true
        Import Strategy: FULL
        File Location: C:/Users/sunita_c/Sunita-Work
        Unique Property: null
        Absolute Target Path Property: absTargetPath
        Relative Src Path Property: relSrcPath
        MIME Type Property: mimeType
        Skip Property: null
        Ignore Properties: [absTargetPath, relSrcPath, mimeType, skip, _LINE_TERMINATED]
        Batch Size: 1000
        Throttle: 0
        Charset: UTF-8
        Delimiter: null
        Separator: null

        22.09.2020 21:00:56.276 *ERROR* [10.7.19.151 [1600826456273] POST /etc/acs-tools/csv-asset-importer/_jcr_content.import.json HTTP/1.1] com.adobe.acs.tools.csv_asset_importer.impl.CsvAssetImporterServlet Could not import the row due to
        com.adobe.acs.tools.csv_asset_importer.impl.CsvAssetImportException: Could not import row
        at com.adobe.acs.tools.csv_asset_importer.impl.CsvAssetImporterServlet.importAsset(CsvAssetImporterServlet.java:251) [com.adobe.acs.acs-aem-tools-bundle:1.0.2]
        at com.adobe.acs.tools.csv_asset_importer.impl.CsvAssetImporterServlet.doPost(CsvAssetImporterServlet.java:126) [com.adobe.acs.acs-aem-tools-bundle:1.0.2]
        at org.apache.sling.api.servlets.SlingAllMethodsServlet.mayService(SlingAllMethodsServlet.java:146) [org.apache.sling.api:2.20.0]
        at org.apache.sling.api.servlets.SlingSafeMethodsServlet.service(SlingSafeMethodsServlet.java:342) [org.apache.sling.api:2.20.0]
        at org.apache.sling.api.servlets.SlingSafeMethodsServlet.service(SlingSafeMethodsServlet.java:374) [org.apache.sling.api:2.20.0]
        at org.apache.sling.engine.impl.request.RequestData.service(RequestData.java:552) [org.apache.sling.engine:2.7.2]
        at org.apache.sling.engine.impl.filter.SlingComponentFilterChain.render(SlingComponentFilterChain.java:44) [org.apache.sling.engine:2.7.2]
        at org.apache.sling.engine.impl.filter.AbstractSlingFilterChain.doFilter(AbstractSlingFilterChain.java:82) [org.apache.sling.engine:2.7.2]
        at com.day.cq.wcm.core.impl.WCMDebugFilter.doFilterWithErrorHandling(WCMDebugFilter.java:192) [com.day.cq.wcm.cq-wcm-core:5.12.124.CQ655-B0001]
        at com.day.cq.wcm.core.impl.WCMDebugFilter.doFilter(WCMDebugFilter.java:159) [com.day.cq.wcm.cq-wcm-core:5.12.124.CQ655-B0001]
        at org.apache.sling.engine.impl.filter.AbstractSlingFilterChain.doFilter(AbstractSlingFilterChain.java:72) [org.apache.sling.engine:2.7.2]
        at com.day.cq.wcm.core.impl.WCMComponentFilter.filterRootInclude(WCMComponentFilter.java:375) [com.day.cq.wcm.cq-wcm-core:5.12.124.CQ655-B0001]
        at com.day.cq.wcm.core.impl.WCMComponentFilter.doFilter(WCMComponentFilter.java:190) [com.day.cq.wcm.cq-wcm-core:5.12.124.CQ655-B0001]
        at org.apache.sling.engine.impl.filter.AbstractSlingFilterChain.doFilter(AbstractSlingFilterChain.java:72) [org.apache.sling.engine:2.7.2]
        at com.day.cq.wcm.core.impl.page.PageLockFilter.doFilter(PageLockFilter.java:91) [com.day.cq.wcm.cq-wcm-core:5.12.124.CQ655-B0001]
        at org.apache.sling.engine.impl.filter.AbstractSlingFilterChain.doFilter(AbstractSlingFilterChain.java:72) [org.apache.sling.engine:2.7.2]
        at com.day.cq.personalization.impl.TargetComponentFilter.doFilter(TargetComponentFilter.java:94) [com.day.cq.cq-personalization:5.12.40]
        at org.apache.sling.engine.impl.filter.AbstractSlingFilterChain.doFilter(AbstractSlingFilterChain.java:72) [org.apache.sling.engine:2.7.2]
        at org.apache.sling.engine.impl.SlingRequestProcessorImpl.processComponent(SlingRequestProcessorImpl.java:283) [org.apache.sling.engine:2.7.2]
        at org.apache.sling.engine.impl.filter.RequestSlingFilterChain.render(RequestSlingFilterChain.java:49) [org.apache.sling.engine:2.7.2]
        at org.apache.sling.engine.impl.filter.AbstractSlingFilterChain.doFilter(AbstractSlingFilterChain.java:76) [org.apache.sling.engine:2.7.2]
        at org.apache.sling.engine.impl.filter.AbstractSlingFilterChain.doFilter(AbstractSlingFilterChain.java:78) [org.apache.sling.engine:2.7.2]
        at com.day.cq.wcm.core.impl.warp.TimeWarpFilter.doFilter(TimeWarpFilter.java:109) [com.day.cq.wcm.cq-wcm-core:5.12.124.CQ655-B0001]
        at org.apache.sling.engine.impl.filter.AbstractSlingFilterChain.doFilter(AbstractSlingFilterChain.java:72) [org.apache.sling.engine:2.7.2]
        at com.adobe.cq.social.ugcbase.security.impl.SaferSlingPostServlet.doFilter(SaferSlingPostServlet.java:126) [com.adobe.cq.social.cq-social-ugcbase-impl:2.5.2]
        at org.apache.sling.engine.impl.filter.AbstractSlingFilterChain.doFilter(AbstractSlingFilterChain.java:72) [org.apache.sling.engine:2.7.2]
        at org.apache.sling.engine.impl.filter.AbstractSlingFilterChain.doFilter(AbstractSlingFilterChain.java:78) [org.apache.sling.engine:2.7.2]
        at org.apache.sling.engine.impl.filter.AbstractSlingFilterChain.doFilter(AbstractSlingFilterChain.java:78) [org.apache.sling.engine:2.7.2]
        at com.day.cq.dam.core.impl.servlet.ActivityRecordHandler.doFilter(ActivityRecordHandler.java:141) [com.day.cq.dam.cq-dam-core:5.12.242]
        at org.apache.sling.engine.impl.filter.AbstractSlingFilterChain.doFilter(AbstractSlingFilterChain.java:72) [org.apache.sling.engine:2.7.2]
        at com.day.cq.dam.core.impl.assetlinkshare.AdhocAssetShareAuthHandler.doFilter(AdhocAssetShareAuthHandler.java:434) [com.day.cq.dam.cq-dam-core:5.12.242]
        at org.apache.sling.engine.impl.filter.AbstractSlingFilterChain.doFilter(AbstractSlingFilterChain.java:72) [org.apache.sling.engine:2.7.2]
        at com.adobe.granite.rest.impl.servlet.ApiResourceFilter.doFilter(ApiResourceFilter.java:70) [com.adobe.granite.rest.api:1.1.16]
        at org.apache.sling.engine.impl.filter.AbstractSlingFilterChain.doFilter(AbstractSlingFilterChain.java:72) [org.apache.sling.engine:2.7.2]
        at com.adobe.granite.requests.logging.impl.RequestLoggerImpl.doFilter(RequestLoggerImpl.java:121) [com.adobe.granite.requests.logging:1.0.20]
        at org.apache.sling.engine.impl.filter.AbstractSlingFilterChain.doFilter(AbstractSlingFilterChain.java:72) [org.apache.sling.engine:2.7.2]
        at com.adobe.granite.rest.assets.impl.AssetContentDispositionFilter.doFilter(AssetContentDispositionFilter.java:96) [com.adobe.granite.rest.assets:1.0.58]
        at org.apache.sling.engine.impl.filter.AbstractSlingFilterChain.doFilter(AbstractSlingFilterChain.java:72) [org.apache.sling.engine:2.7.2]
        at com.day.cq.wcm.core.impl.AuthoringUIModeServiceImpl.doFilter(AuthoringUIModeServiceImpl.java:372) [com.day.cq.wcm.cq-wcm-core:5.12.124.CQ655-B0001]

        at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:388) [org.apache.felix.http.jetty:4.0.16]
        at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:806) [org.apache.felix.http.jetty:4.0.16]
        at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:938) [org.apache.felix.http.jetty:4.0.16]
        at java.lang.Thread.run(Thread.java:748)
        Caused by: java.io.FileNotFoundException: C:/Users/sunita_c/Sunita-Work/images/hero.jpeg (No such file or directory)
        at java.io.FileInputStream.open0(Native Method)
        at java.io.FileInputStream.open(FileInputStream.java:195)
        at java.io.FileInputStream.<init>(FileInputStream.java:138)
        at java.io.FileInputStream.<init>(FileInputStream.java:93)
        at com.adobe.acs.tools.csv_asset_importer.impl.CsvAssetImporterServlet.getOrCreateAsset(CsvAssetImporterServlet.java:400) [com.adobe.acs.acs-aem-tools-bundle:1.0.2]
        at com.adobe.acs.tools.csv_asset_importer.impl.CsvAssetImporterServlet.importAsset(CsvAssetImporterServlet.java:239) [com.adobe.acs.acs-aem-tools-bundle:1.0.2]
        ... 141 common frames omitted

          Terms & ConditionsAccessibility statement

          Loading footer...