MATWorX Ver 6.3 CSV files
MATWorX Ver 6.3 CSV files
(OP)
Hi, has anyone been able to create CSV files using Excel and sucessfully importing and running the script using the MACH script editor in 6.3
It seems that with MATWorX 6.3, the CSV format has changed but nobody knows what this new format is.
I am forced to have an earlier version of MATWorX installed on my laptop just to run the scripts that have been created using EXCEL.
There is a new function in 6.3 called 'Office Data Listup' which reads and then lists up all the programming within the PBX and creates multiple CSV files.
These files can be imported with the MACH script editor and run, but if you change/modify any of the data the CSV file will no longer work.
Does anyone know what this new format with 6.3 is.
Thanks
It seems that with MATWorX 6.3, the CSV format has changed but nobody knows what this new format is.
I am forced to have an earlier version of MATWorX installed on my laptop just to run the scripts that have been created using EXCEL.
There is a new function in 6.3 called 'Office Data Listup' which reads and then lists up all the programming within the PBX and creates multiple CSV files.
These files can be imported with the MACH script editor and run, but if you change/modify any of the data the CSV file will no longer work.
Does anyone know what this new format with 6.3 is.
Thanks
Jesse
PABX Sales and Service
RE: MATWorX Ver 6.3 CSV files
RE: MATWorX Ver 6.3 CSV files
Ex.
"10","000","F200"
Unfortunately Excel does not support this natively. You can do one of two things :
First, you can import some VBA script that Microsoft provides to export your table in this format. I do not have the article number off hand, but I'll find out for you if someone else doen't post it first.
However, what I do is create a second sheet and put this in cell A1 --- =char(34)&'Sheet1'!A1&char(34). This will take the data from the first sheet and surround it with quotes. Then simply drag the formula out two columns, and down as many rows as you need.