Page 1 of 2 1 2 >
Topic Options
#66608 - 07/23/21 01:44 PM Attach PDF, A/P Import
Holiday Offline
Adagio Guru

Registered: 04/26/07
Posts: 103
Loc: Canada
Good afternoon,

I'm trying to add a header field to an A/P import CSV file.
The format I've used is:

\\S:Accounting\HPR\Accounts Payable\25999.169 Folio.pdf

The last description is the actual PDF I'm trying to import. Everything looks ok to me, but i'm getting an error message. Is anyone familiar with this field?

thanks very much!

Top
#66609 - 07/23/21 02:06 PM Re: Attach PDF, A/P Import [Re: Holiday]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11571
Loc: Vancouver, BC Canada
Hello Holiday,

For the Hdr-Attach PDF field, try renaming your attachment so that there isn’t an extra period or a blank space in the attachment name.

A dash or an underscore will work.
_________________________
Regards,
Softrak Tech Support

Top
#66615 - 07/26/21 08:09 AM Re: Attach PDF, A/P Import [Re: Softrak Support]
Holiday Offline
Adagio Guru

Registered: 04/26/07
Posts: 103
Loc: Canada
I didn't think of that!
Thanks very much, I'll try it.

Top
#66618 - 07/26/21 09:19 AM Re: Attach PDF, A/P Import [Re: Holiday]
Holiday Offline
Adagio Guru

Registered: 04/26/07
Posts: 103
Loc: Canada
Unfortunately, that didn't work. I've shortened the file path in order to test the load file, but it's still giving me an error.

When I click on the link in my load file, it takes me to the PDF, but still get "Invalid data 'file://S:Accounting/25999_169_Folio.pdf' for field called 'Hdr-Attach PDF' of record 1. when I try to import to A/P.

Top
#66619 - 07/26/21 10:15 AM Re: Attach PDF, A/P Import [Re: Holiday]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11571
Loc: Vancouver, BC Canada
Hello Holiday,

The only time I get the error that you are getting is when the path really was invalid. I was successful using a mapped drive letter in the path as well as a UNC.

The path in the error message looks odd to me with "file:\\" What do you have in the file path? I have:
"\\STSINC\TECH\SOFTRAK\DATA\SAMDATA\Scans\AttachToExistingEntries\AdagioScan-20170428103651.PDF"

Which is also known as:
"L:\SOFTRAK\DATA\SAMDATA\Scans\AttachToExistingEntries\AdagioScan-20170428103651.PDF"

I had no problem importing documents with spaces and dashes in the filename as long as I had the rest of the path right.
_________________________
Regards,
Softrak Tech Support

Top
#66620 - 07/26/21 10:29 AM Re: Attach PDF, A/P Import [Re: Softrak Support]
Holiday Offline
Adagio Guru

Registered: 04/26/07
Posts: 103
Loc: Canada
I've eliminated the 'file://' portion of the path, and the import completed, but now with an error: Copying Storage file to destination failed (11104) during call to ADocFilerCreateW

Top
#66622 - 07/26/21 11:34 AM Re: Attach PDF, A/P Import [Re: Holiday]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11571
Loc: Vancouver, BC Canada
Hello Holiday,

The error message means that Payables failed to copy the file into DocStorage.

Where is the file located? Is "S:" a Local workstation, on the Network or a website?

Please post a sample Header record showing the import path currently in the file.
_________________________
Regards,
Softrak Tech Support

Top
#66624 - 07/26/21 11:44 AM Re: Attach PDF, A/P Import [Re: Softrak Support]
Holiday Offline
Adagio Guru

Registered: 04/26/07
Posts: 103
Loc: Canada
Hello,

S drive is on the network; this is the header line of the import file I'm working with. It has worked for importing with the exception of the attachment record.


H SHAWC Shaw Cable Shaw Cablesystems GP Woodlands, Aug 2021 1 6/28/2021 S:/Accounting/25999_169_Folio.PDF

Top
#66625 - 07/26/21 12:19 PM Re: Attach PDF, A/P Import [Re: Holiday]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11571
Loc: Vancouver, BC Canada
Hello Holiday,

I have another suggestion for you. In your path, you are using a forward slash. In some places, it is interchangeable with a back slash but this isn't one of them.

Please change:
S:/Accounting/25999_169_Folio.PDF

To:
S:\Accounting/25999_169_Folio.PDF
_________________________
Regards,
Softrak Tech Support

Top
#66627 - 07/26/21 12:27 PM Re: Attach PDF, A/P Import [Re: Softrak Support]
Holiday Offline
Adagio Guru

Registered: 04/26/07
Posts: 103
Loc: Canada
Hi,
Same error message results.

Top
Page 1 of 2 1 2 >


Moderator:  Christa_Meissner 
Who's Online
1 registered (Lauren Stief), 51 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14484 Topics
70731 Posts

Max Online: 432 @ 01/20/25 10:17 PM
May
Su M Tu W Th F Sa
1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31