Hi,
I'm developing a timesheet form in order to integrate with my organization's asset management software. I have created a timesheet form that I feel will be sufficient in meeting our needs, however I need to generate a csv file output to import into the asset management software. I've exported the default csv file from a returned form dataset, but the format is incompatible for importing with the management software. Is there a way I can customize the layout of the exported csv file? For example, I have a table entry that has all of the necessary fields, and a new line is added for additional information (for time alotted to different work order numbers/categories/etc) under the same employee name. I would like these repeating table rows to show up as table rows in the csv file, with the employee name repeating itself for each entry.
It is going to take some time and I'm sure that there is no simple solution, but does anyone know of a good resource to get me started on this? It would be greatly appreciated.
Thanks in advance.
Andrew
Is there a way of doing this? Or maybe some sort of software that can be installed on the machine collecting the emails that will convert the collected information into the desired format? It seems everything for adobe forms deals with .xml, but they don't want to move over to that format as of yet. Keep in mind there will be a large amount of form submissions per day, so simplicity is key for organization. Does anyone have any ideas???