Sage 100

Hello

Customer is asking for extra comma that gets exported at the end of each line on a VI Export Job to be removed.   I have searched and have not found anything on this.  I am using delimited and csv.   I tried on two different systems and exporting puts a comma at the very end of the last field exported.

Thanks in advance,
Christine

------------------------------
Christine Kuhn
Consultant
RKL eSolutions, LLC
------------------------------

My reply would be to not use VI for exports.  There are much better ways, with more control over the output.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
------------------------------

Have to agree with @Kevin Moyes - I couldn't get no satisfaction 17 years ago with VI exports, I tried and I tried.  So I broke out the dummies book on Excel queries and haven't looked back.  That's what I say.
​

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
(540) 221-4444
------------------------------

Original Message:
Sent: 09-30-2022 15:26
From: Kevin Moyes
Subject: VI Export adds extra comma at end of every line

My reply would be to not use VI for exports.  There are much better ways, with more control over the output.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
------------------------------

Christine - VI Exports are frustrating in several ways this being one of them. If you have no way to pull the data from an external app then one way to deal with this is to have a VB script (not a Custom Office VB script) that executes on the Job Completion event that you define from the Perform button in Configuration tab. Here is an example of one that takes the exported file (File1) and make a copy of it (File2) and removes it from there : https://bit.ly/3CnrYz1

------------------------------
Alnoor Cassim
------------------------------

Original Message:
Sent: 09-30-2022 17:42
From: Jeff Schwenk
Subject: VI Export adds extra comma at end of every line

Have to agree with @Kevin Moyes - I couldn't get no satisfaction 17 years ago with VI exports, I tried and I tried.  So I broke out the dummies book on Excel queries and haven't looked back.  That's what I say.
​

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
(540) 221-4444
------------------------------


Original Message:
Sent: 09-30-2022 15:26
From: Kevin Moyes
Subject: VI Export adds extra comma at end of every line

My reply would be to not use VI for exports.  There are much better ways, with more control over the output.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.

Thanks Alnoor, if it's not too much of a pain, can you send your link again?  I tried it on the same day but it said it was expired.  

I am using windows Task Scheduler and a bat file to copy the file after it finishes to another location and then rename it with the date.   Can I launch this using Perform? 

CK

------------------------------
Christine Kuhn
Consultant
RKL eSolutions, LLC
------------------------------

Original Message:
Sent: 10-01-2022 02:03
From: Alnoor Cassim
Subject: VI Export adds extra comma at end of every line

Christine - VI Exports are frustrating in several ways this being one of them. If you have no way to pull the data from an external app then one way to deal with this is to have a VB script (not a Custom Office VB script) that executes on the Job Completion event that you define from the Perform button in Configuration tab. Here is an example of one that takes the exported file (File1) and make a copy of it (File2) and removes it from there : https://bit.ly/3CnrYz1

------------------------------
Alnoor Cassim
------------------------------


Original Message:
Sent: 09-30-2022 17:42
From: Jeff Schwenk
Subject: VI Export adds extra comma at end of every line

Have to agree with @Kevin Moyes - I couldn't get no satisfaction 17 years ago with VI exports, I tried and I tried.  So I broke out the dummies book on Excel queries and haven't looked back.  That's what I say.
​

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
(540) 221-4444


Original Message:
Sent: 09-30-2022 15:26
From: Kevin Moyes
Subject: VI Export adds extra comma at end of every line

My reply would be to not use VI for exports.  There are much better ways, with more control over the output.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.

WAIT NEVERMIND, THIS MAY BE IT.

Resolution

------------------------------
Christine Kuhn
Consultant
RKL eSolutions, LLC
------------------------------

Original Message:
Sent: 10-01-2022 02:03
From: Alnoor Cassim
Subject: VI Export adds extra comma at end of every line

Christine - VI Exports are frustrating in several ways this being one of them. If you have no way to pull the data from an external app then one way to deal with this is to have a VB script (not a Custom Office VB script) that executes on the Job Completion event that you define from the Perform button in Configuration tab. Here is an example of one that takes the exported file (File1) and make a copy of it (File2) and removes it from there : https://bit.ly/3CnrYz1

------------------------------
Alnoor Cassim
------------------------------


Original Message:
Sent: 09-30-2022 17:42
From: Jeff Schwenk
Subject: VI Export adds extra comma at end of every line

Have to agree with @Kevin Moyes - I couldn't get no satisfaction 17 years ago with VI exports, I tried and I tried.  So I broke out the dummies book on Excel queries and haven't looked back.  That's what I say.
​

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
(540) 221-4444


Original Message:
Sent: 09-30-2022 15:26
From: Kevin Moyes
Subject: VI Export adds extra comma at end of every line

My reply would be to not use VI for exports.  There are much better ways, with more control over the output.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.

Christine - the link seems to work today but easier to use this simple Perform you found. This gets installed when you install V/I and all you have to do is call it. Those instructions look good. I totally forgot about it. (Side note: There are some variations that I and some others have done.)

------------------------------
Alnoor Cassim
------------------------------

Original Message:
Sent: 10-05-2022 15:10
From: Christine Kuhn
Subject: VI Export adds extra comma at end of every line

WAIT NEVERMIND, THIS MAY BE IT.

<content>How to remove trailing separator when exporting with Visual Integrator</content>

Resolution

<content>

1. Open Export Job in Export Job Maintenance
2. Click Perform Button on Configuration Tab
3. For Perform Type, select After Assign
4. For Table Name, select last field being exported
5. For Column Name, select Last field to be exported
6. For Sequence, leave default value 001
7. Enter the following Command:
   • ..\VI\VI_RemoveTrailingSep.M4p
8. Click Accept button
9. Click Accept to run the export

</content>

------------------------------
Christine Kuhn
Consultant
RKL eSolutions, LLC
------------------------------


Original Message:
Sent: 10-01-2022 02:03
From: Alnoor Cassim
Subject: VI Export adds extra comma at end of every line

Christine - VI Exports are frustrating in several ways this being one of them. If you have no way to pull the data from an external app then one way to deal with this is to have a VB script (not a Custom Office VB script) that executes on the Job Completion event that you define from the Perform button in Configuration tab. Here is an example of one that takes the exported file (File1) and make a copy of it (File2) and removes it from there : https://bit.ly/3CnrYz1

------------------------------
Alnoor Cassim


Original Message:
Sent: 09-30-2022 17:42
From: Jeff Schwenk
Subject: VI Export adds extra comma at end of every line

Have to agree with @Kevin Moyes - I couldn't get no satisfaction 17 years ago with VI exports, I tried and I tried.  So I broke out the dummies book on Excel queries and haven't looked back.  That's what I say.
​

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
(540) 221-4444


Original Message:
Sent: 09-30-2022 15:26
From: Kevin Moyes
Subject: VI Export adds extra comma at end of every line

My reply would be to not use VI for exports.  There are much better ways, with more control over the output.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.

@Christine Kuhn Hard to tell but your resolution above appears not to have a hyperlink associated with it.  Is it possible to repost the link?

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
(540) 221-4444
------------------------------

Original Message:
Sent: 10-05-2022 15:34
From: Alnoor Cassim
Subject: VI Export adds extra comma at end of every line

Christine - the link seems to work today but easier to use this simple Perform you found. This gets installed when you install V/I and all you have to do is call it. Those instructions look good. I totally forgot about it. (Side note: There are some variations that I and some others have done.)

------------------------------
Alnoor Cassim
------------------------------


Original Message:
Sent: 10-05-2022 15:10
From: Christine Kuhn
Subject: VI Export adds extra comma at end of every line

WAIT NEVERMIND, THIS MAY BE IT.

<content>How to remove trailing separator when exporting with Visual Integrator</content>

Resolution

<content>

1. Open Export Job in Export Job Maintenance
2. Click Perform Button on Configuration Tab
3. For Perform Type, select After Assign
4. For Table Name, select last field being exported
5. For Column Name, select Last field to be exported
6. For Sequence, leave default value 001
7. Enter the following Command:
   • ..\VI\VI_RemoveTrailingSep.M4p
8. Click Accept button
9. Click Accept to run the export

</content>

------------------------------
Christine Kuhn
Consultant
RKL eSolutions, LLC


Original Message:
Sent: 10-01-2022 02:03
From: Alnoor Cassim
Subject: VI Export adds extra comma at end of every line

Christine - VI Exports are frustrating in several ways this being one of them. If you have no way to pull the data from an external app then one way to deal with this is to have a VB script (not a Custom Office VB script) that executes on the Job Completion event that you define from the Perform button in Configuration tab. Here is an example of one that takes the exported file (File1) and make a copy of it (File2) and removes it from there : https://bit.ly/3CnrYz1

------------------------------
Alnoor Cassim


Original Message:
Sent: 09-30-2022 17:42
From: Jeff Schwenk
Subject: VI Export adds extra comma at end of every line

Have to agree with @Kevin Moyes - I couldn't get no satisfaction 17 years ago with VI exports, I tried and I tried.  So I broke out the dummies book on Excel queries and haven't looked back.  That's what I say.
​

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
(540) 221-4444


Original Message:
Sent: 09-30-2022 15:26
From: Kevin Moyes
Subject: VI Export adds extra comma at end of every line

My reply would be to not use VI for exports.  There are much better ways, with more control over the output.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.

hello.

This was the command.    It removes all but the comma at the end of the headings I believe - if you need headings.    

------------------------------
Christine Kuhn
Consultant
RKL eSolutions, LLC
------------------------------

Original Message:
Sent: 02-07-2024 18:43
From: Jeff Schwenk
Subject: VI Export adds extra comma at end of every line

@Christine Kuhn Hard to tell but your resolution above appears not to have a hyperlink associated with it.  Is it possible to repost the link?

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
(540) 221-4444
------------------------------


Original Message:
Sent: 10-05-2022 15:34
From: Alnoor Cassim
Subject: VI Export adds extra comma at end of every line

Christine - the link seems to work today but easier to use this simple Perform you found. This gets installed when you install V/I and all you have to do is call it. Those instructions look good. I totally forgot about it. (Side note: There are some variations that I and some others have done.)

------------------------------
Alnoor Cassim


Original Message:
Sent: 10-05-2022 15:10
From: Christine Kuhn
Subject: VI Export adds extra comma at end of every line

WAIT NEVERMIND, THIS MAY BE IT.

<content>How to remove trailing separator when exporting with Visual Integrator</content>

Resolution

<content>

1. Open Export Job in Export Job Maintenance
2. Click Perform Button on Configuration Tab
3. For Perform Type, select After Assign
4. For Table Name, select last field being exported
5. For Column Name, select Last field to be exported
6. For Sequence, leave default value 001
7. Enter the following Command:
   • ..\VI\VI_RemoveTrailingSep.M4p
8. Click Accept button
9. Click Accept to run the export

</content>

------------------------------
Christine Kuhn
Consultant
RKL eSolutions, LLC


Original Message:
Sent: 10-01-2022 02:03
From: Alnoor Cassim
Subject: VI Export adds extra comma at end of every line

Christine - VI Exports are frustrating in several ways this being one of them. If you have no way to pull the data from an external app then one way to deal with this is to have a VB script (not a Custom Office VB script) that executes on the Job Completion event that you define from the Perform button in Configuration tab. Here is an example of one that takes the exported file (File1) and make a copy of it (File2) and removes it from there : https://bit.ly/3CnrYz1

------------------------------
Alnoor Cassim


Original Message:
Sent: 09-30-2022 17:42
From: Jeff Schwenk
Subject: VI Export adds extra comma at end of every line

Have to agree with @Kevin Moyes - I couldn't get no satisfaction 17 years ago with VI exports, I tried and I tried.  So I broke out the dummies book on Excel queries and haven't looked back.  That's what I say.
​

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
(540) 221-4444


Original Message:
Sent: 09-30-2022 15:26
From: Kevin Moyes
Subject: VI Export adds extra comma at end of every line

My reply would be to not use VI for exports.  There are much better ways, with more control over the output.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.

Thanks.  Interesting.  I wonder if there are any other "easter eggs" available that we are unaware of.

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
(540) 221-4444
------------------------------

Original Message:
Sent: 02-07-2024 22:41
From: Christine Kuhn
Subject: VI Export adds extra comma at end of every line

hello.

This was the command.    It removes all but the comma at the end of the headings I believe - if you need headings.    

------------------------------
Christine Kuhn
Consultant
RKL eSolutions, LLC
------------------------------


Original Message:
Sent: 02-07-2024 18:43
From: Jeff Schwenk
Subject: VI Export adds extra comma at end of every line

@Christine Kuhn Hard to tell but your resolution above appears not to have a hyperlink associated with it.  Is it possible to repost the link?

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
(540) 221-4444


Original Message:
Sent: 10-05-2022 15:34
From: Alnoor Cassim
Subject: VI Export adds extra comma at end of every line

Christine - the link seems to work today but easier to use this simple Perform you found. This gets installed when you install V/I and all you have to do is call it. Those instructions look good. I totally forgot about it. (Side note: There are some variations that I and some others have done.)

------------------------------
Alnoor Cassim


Original Message:
Sent: 10-05-2022 15:10
From: Christine Kuhn
Subject: VI Export adds extra comma at end of every line

WAIT NEVERMIND, THIS MAY BE IT.

<content>How to remove trailing separator when exporting with Visual Integrator</content>

Resolution

<content>

1. Open Export Job in Export Job Maintenance
2. Click Perform Button on Configuration Tab
3. For Perform Type, select After Assign
4. For Table Name, select last field being exported
5. For Column Name, select Last field to be exported
6. For Sequence, leave default value 001
7. Enter the following Command:
   • ..\VI\VI_RemoveTrailingSep.M4p
8. Click Accept button
9. Click Accept to run the export

</content>

------------------------------
Christine Kuhn
Consultant
RKL eSolutions, LLC


Original Message:
Sent: 10-01-2022 02:03
From: Alnoor Cassim
Subject: VI Export adds extra comma at end of every line

Christine - VI Exports are frustrating in several ways this being one of them. If you have no way to pull the data from an external app then one way to deal with this is to have a VB script (not a Custom Office VB script) that executes on the Job Completion event that you define from the Perform button in Configuration tab. Here is an example of one that takes the exported file (File1) and make a copy of it (File2) and removes it from there : https://bit.ly/3CnrYz1

------------------------------
Alnoor Cassim


Original Message:
Sent: 09-30-2022 17:42
From: Jeff Schwenk
Subject: VI Export adds extra comma at end of every line

Have to agree with @Kevin Moyes - I couldn't get no satisfaction 17 years ago with VI exports, I tried and I tried.  So I broke out the dummies book on Excel queries and haven't looked back.  That's what I say.
​

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
(540) 221-4444


Original Message:
Sent: 09-30-2022 15:26
From: Kevin Moyes
Subject: VI Export adds extra comma at end of every line

My reply would be to not use VI for exports.  There are much better ways, with more control over the output.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.