Sage 100

Customer wants to import extended descriptions (v2013) but I don't see CI_ExtendedDescription as an available table in VI. Is there a trick to doing this? It's been a while since I've had to do this and last time was in non-BF which was a nightmare. I was thinking it would be easier. What am I missing???

I thought about that but didn't want to create a disaster - thanks @BrettLyder !!

I think if you import into the CI item description field , VI automatically handles the rest... Business framework is good that way

It is easier. Just import into CI_Item. If the description is longer that 30 char. VI automatically creates the extended description.

lol, I understand!

Much much simpler in the new frame work...

Except now I am having issues with double quotes.... Saw the previous threads. May check out early since it's a Friday.....

Thank you @BrettZimmerman too!! https://90minds-com.socialcast.com/messages/11256182 ""I usually just open the .csv in WordPad and do a Find-Replace of """" to "" (that's double-quote to single-quote).

For ongoing imports you can alternatively use a Calc of SUB(IMP$[17],quo+quo,quo), which will fix the quotes during the actual importing.  17 represents the column to pull from in the Excel import source file.

------------------------------
- Brett
------------------------------

Original Message:
Sent: 11-21-2014 13:13
From: Therese Logeais
Subject: Customer wants to import extended descriptions (v2

Thank you @BrettZimmerman too!! https://90minds-com.socialcast.com/messages/11256182 ""I usually just open the .csv in WordPad and do a Find-Replace of """" to "" (that's double-quote to single-quote).

If you use Access, you can import the CSV file into an Access table, then export as a tab delimited.  Export does NOT add any extraneous quotes that Excel CSV or tab  delimited insists on.

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------

Original Message:
Sent: 10-22-2019 16:48
From: Brett Zimmerman
Subject: Customer wants to import extended descriptions (v2

For ongoing imports you can alternatively use a Calc of SUB(IMP$[17],quo+quo,quo), which will fix the quotes during the actual importing.  17 represents the column to pull from in the Excel import source file.

------------------------------
- Brett
------------------------------


Original Message:
Sent: 11-21-2014 13:13
From: Therese Logeais
Subject: Customer wants to import extended descriptions (v2

Thank you @BrettZimmerman too!! https://90minds-com.socialcast.com/messages/11256182 ""I usually just open the .csv in WordPad and do a Find-Replace of """" to "" (that's double-quote to single-quote).