Sage 100

Vi trick. I remember a post about importing quotes so it does not import double quotes (""""). Anyone know where that is??

I usually just open the .csv in WordPad and do a Find-Replace of """" to "" (that's double-quote to single-quote).

Johnny, Scott Brady at Sage has an import he will send you that does this. Just drop him a note.

This is from the resellers yahoo in 2008. Probably what BL is referring to. Subject: [sageresellers] Re: Importing Extended Descriptions Here is a great response from my secret sources at Sage. You'll need to use SUB Functions. Modify your source file by replacing all "" with * and replace all , with ^. You can then use the attached sample. The attached import uses SUB functions which will change the * back to "" and change the ^ back to , Note: this import job is for 4.10 and higher. If anyone wants the import job I'll be glad to send it to them.

Dats It!

Did you keep a copy of the import as I don't have it?????

To see the previous SC posting by @EricAnderson, do a search for ""import items/descriptions"" (including the quotes).

Here are the links that Brett was referring to in case there was interest to read the entire thread. The second one is the original discussion. https://90minds-com.socialcast.com/messages/7108278 https://90minds-com.socialcast.com/messages/6941091

copy/paste: Here is the formula that Todd posted in case anyone else is curious: SUB(IMP$[3],quo+quo,quo). Dawn's solution was replace the "" in the original file with ^ and the use this formaul in VI: SUB({CI_Item.ItemCode$}, ""^"", CHR(34)

This is the complete write up in the KB Item extended descriptions with commas cannot be imported from a tab delimited (CSV) file. Use temp variables to create the commas from the source file. Note: Similar steps can be used for quotation marks (""). In the source file, change the commas to asterisks (*). In Sage MAS 90 or 200, expand Visual Integrator and Main. Double-click Import Job Maintenance. Select (or create) the import job for IM.ITEMEXT, and click the Data tab. Add the following fields to the selected fields list (below COMMENT_TEXT): TEMP01: Type = String Operation = String Default value = * (asterisk) TEMP02: Type = String Operation = String Default value = , (comma) TEMP03: Type = String Operation = Replace Field = 3 (Description) Length = 9999 Move the COMMENT_TEXT field to the bottom of the list. Double-click the COMMENT_TEXT field to open Import Field Properties, and make the following changes: Operation = Calculate (from Replace) Calculation = SUB({TEMP03},{TEMP01},{TEMP02}) Run the import job.

Thanks guys - I remembered something like this. Now off to correcting the items in inventory. Thanks a bunch!

Well an FYI here - this was 4.4 and I imported data into access, corrected and did an odbc import via - the quotes imported perfectly without having to so any weird calculations or characters. I wonder if csv would be different.

It's because of the way fields are defined in Access vs CSV.

Would making the text file a tab delimited vs. a comma delimited make a difference. I've started making my major VI's tab imports and they seem to go smoother.

I don't think so.